Word logging for LOTR and the Silmarillion

[ruth barratt]

Hello all,
So I first posted this in the ExLOTR thread by as it has now grown to include the Silmarillion I thought I would repost it here.
Basically, I have gone through the books and created a spreadsheet of the use of a word. I have logged the book, chapter, where it is used, and how used it used in the line.
The links are 'comment' links so that if you spot something that is wrong please leave me a comment and I'll have a look-see.
If you would like to have more access for some reason you can request this through the green box at the top.
If you have any words that are not on there that you think should be let me know.

Also, I have a general call for aid; being dyslexic I have some, shall we say, special spellings in these sheets, as well as the normal typos. So if there is anyone who would like to help in finding them please feel free to leave comments on the sheet, I appreciate any and all constructive feedback.

Word log Lord of the Rings Main text

Lists of words List of words recorded so far <a href="#gid=2003407298">Adventure</a> <a href="#gid=809326100">Anduin (The vs. Non The)</a> <a href="#gid=1354240608">Arrayed</a> <a href="#gid=1970134441">Bag End</a> <a href="#gid=137943297">Barad-dûr</a> <a href="#gid=882219744">Black Rider</a> <...

docs.google.com

Word Logging The Silmarillion

List of Words List of words recorded so far <a href="#gid=1746360145">Adventure</a> <a href="#gid=897651984">Anger</a> <a href="#gid=897651984">Angry</a> <a href="#gid=819293023">Bright</a> <a href="#gid=1123868514">Dawn</a> <a href="#gid=1669957131">Day</a> <a href="#gid=1564663426">Daylight</a...

docs.google.com

Word log Lord of the Rings: Prologue/ Appendix

List of words List of words recorded so far <a href="#gid=1048465259">Adventure</a> <a href="#gid=982860795">Afternoon</a> <a href="#gid=872999283">Anduin (The vs. Non The)</a> <a href="#gid=832822079">Anger</a> <a href="#gid=832822079">Angry</a> <a href="#gid=14036937">Arrayed</a> <a href="#gid...

docs.google.com

Word log Lord of the Rings Hyphen versions

Lists of words List of words recorded so far <a href="#gid=2133604306">Afternoon</a> <a href="#gid=280251059">Arrayed</a> <a href="#gid=1293028916">Breakfast</a> <a href="#gid=1522196139">Bright</a> <a href="#gid=745759955">Dawn</a> <a href="#gid=1823161901">Day</a> <a href="#gid=1548227932">Dim...

docs.google.com

 

[ruth barratt]

I have also graphed some of the words and made a little word doc for them sometimes with a thought (may not be the best thought) from yours truly.
Again they are comment links so feel very free to point out mistakes, I can guarantee that there will be some.

Bad guy related words:

Names for Mordor

Names for Mordor Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Mordor 18 43 32 37 44 47 The Black Lands 1 2 3 0 3 3 The Land of Shadow 0 1 2 0 0 0 The Nameless Lands 0 0 0 5 0 0

docs.google.com

Names for Nazgul

Names for Nazgul Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Nazul 0 2 12 4 20 12 Black Riders 33 6 2 3 7 3 Ringwraiths 2 10 1 2 5 3 Overall use person Gandalf Frodo Sam Pippin Merry Aragorn Orcs Misc. Narrator Nazul 10 0 0 0 0 1 1...

docs.google.com

Use of Sauron

Use of Sauron Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 10 48 20 15 35 12 F-1 Gandalf Strider Nazgûl Glorfindel 5 3 1 1 F-2 Gandalf Aragorn Elrond Nazgûl Narrator Galadriel Gimli Boromir Isildur Galdor Saruman Glorfindel Haldir 12 3 ...

docs.google.com

Use of The Dark Lord

Use of The Dark Lord Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 6 13 6 10 7 6 F-1 Gandalf Poem Narrator 2 2 1 F-2 Gandalf Gloin Galadriel Haldir Boromir Gimli Narrator 5 1 2 1 1 1 2 TTT-1 Aragorn Gandalf Wormtongue 3 2 1 TT...

docs.google.com

The Enemy

The Enemy Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 21 42 9 31 21 1 F-1 Gandalf Narrator Frodo Gildor Strider Merry 7 1 5 3 4 1 F-2 Bilbo Gloin Elrond Boromir Aragorn Gandalf Legolas Radagast Galdor Narrator Gimli Haldir Galadriel Celeb...

docs.google.com

The Enemy

The Enemy Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 21 42 9 31 21 1 F-1 Gandalf Narrator Frodo Gildor Strider Merry 7 1 5 3 4 1 F-2 Bilbo Gloin Elrond Boromir Aragorn Gandalf Legolas Radagast Galdor Narrator Gimli Haldir Galadriel Celeb...

docs.google.com

Use of the names for Sauon

Use of the names for Sauron Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Sauron 10 48 20 15 35 12 The Dark Lord 6 13 6 10 7 6 The Eye/ Great Eye 0 6 5 6 1 5 The Enemy 21 42 9 31 21 1 Good guys Bad guys Narrator Sauron 89 15 36 The Dark L...

docs.google.com

 

[ruth barratt]

Caps vs. Non-cap

East Cap vs

East Cap vs. Non-cap Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 47 52 42 30 44 31 Use in poems vs. other uses Poem Other F-1 1 20 F-2 2 14 TTT-1 1 27 TTT-2 1 11 RK-1 1 22 RK-2 1 10 F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Cap/name 21...

docs.google.com

Moon cap vs. Non-cap

Moon Cap vs. Non-cap Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 31 36 39 29 9 6 Cap- use in poems vs. other use Use in poems Other F-1 10 21 F-2 7 29 TTT-1 2 37 TTT-2 0 29 RK-1 0 9 RK-2 1 5 F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Cap 16...

docs.google.com

North Cap vs

North Cap vs. Non-cap Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 40 47 66 14 47 40 Cap vs. Non-cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Cap 12 25 33 9 27 19 Non-cap 28 22 33 5 20 21 Use per chapter Chapter C-1 C-2 C-3 C-4 C-5 C-6 C-...

docs.google.com

Orc Cap vs

Orc Cap vs. Non-cap Overall use Cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 5 27 192 56 6 1 Non-cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 0 29 2 3 21 62 Cap vs. Non-cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Cap 5 27 192 56 6 1 Non-cap 0 29 2 3 21 62 ...

docs.google.com

Sea Cap vs

Sea Cap vs. Non-cap Overall use Cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 15 23 14 7 13 17 Use in poems vs. other uses Poem Non-poem F-1 6 19 F-2 9 32 TTT-1 7 23 TTT-2 0 11 RK-1 3 19 RK-2 3 20 Non-cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 10 1...

docs.google.com

South cap vs

South cap vs. Non-cap Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 27 51 25 22 41 23 Cap vs. Non-cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Cap 8 21 11 11 23 4 Non-cap 19 30 14 11 18 19 Use per chapter Chapter C-1 C-2 C-3 C-4 C-5 C-6 ...

docs.google.com

Sun Caps vs

Sun Caps vs. Non-caps Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 73 67 60 30 39 37 Caps- Use in poems vs. other uses Poem Other F-1 9 6 F-2 4 19 TTT-1 2 13 TTT-2 0 10 RK-1 0 16 RK-2 1 16 Overall Cap vs. Non-cap F-1 F-2 TTT-1 TTT-...

docs.google.com

West Cap vs

West Cap vs. Non-cap Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 41 48 52 30 37 53 Cap vs. Non-cap F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Cap 22 19 24 14 25 37 Non-cap 19 29 28 16 12 16 Use per chapter Chapter C-1 C-2 C-3 C-4 C-5 C-6...

docs.google.com

 

[ruth barratt]

Use of Hobbits fully names (I was just intrigued)

Use of Full Names

Use of Full Name Overall use Peregrin F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 10 2 6 0 19 6 Meriadoc F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 3 0 3 0 18 3 Samwise F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 0 0 0 10 0 6 F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Pereg...

docs.google.com

 

[ruth barratt]

Light related

Glimmer

Glimmer Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 10 12 12 10 7 8 Number of Alliteration 9 What is Glimmering F-1 Light Item Person Colour 2 4 2 2 F-2 Light Item Person 3 8 1 TTT-1 Light Item Colour 2 8 1 TTT-2 Lig...

docs.google.com

Gloom

Gloom Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 10 9 5 12 31 6 Number Alliteration 13 Use per chapter C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 C-9 C-10 C-11 C-12 F-1 0 0 1 1 1 2 1 1 1 0 1 1 F-2 0 0 2 4 1 0 0 0 2 0 TTT-1 0 ...

docs.google.com

Gleam

Gleam Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 16 23 23 19 18 16 Overall Eyes Other 22 93 Number of Alliteration 9 F-1 Eyes Item Light Misc. 6 5 1 3 F-2 Eyes Item Light Hope 2 13 5 1 TTT-1 Eyes Light Item Hop...

docs.google.com

Types of Light

Types of Light Overall use Sunshine F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 4 0 5 0 2 3 Sunlight F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 8 13 11 4 7 4 Daylight F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 12 2 1 6 0 0 Starlight F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 9 ...

docs.google.com

 

[ruth barratt]

Dream

Dream Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 23 23 22 18 19 17 F-1 Frodo Sam Merry Pippin Tom Group Man in the Moon 12 1 2 4 1 2 1 F-2 Frodo Sam Boromir Faramir Aragorn Dwarves Elves Groups 9 5 2 3 1 2 1 1 TTT-1 Arag...

docs.google.com

Fair

Fair Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 47 59 36 27 48 63 Person 123 Other 157 F-1 All uses Anything living Item Weather Location Type Speed Time 18 3 4 4 14 2 2 People Frodo Merry Goldberry Groups Misc. 1 1 8 6 3 F-2 Al...

docs.google.com

Fly

Fly Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 7 23 19 9 15 7 Fly vs. Run vs. Other Fly Run Other 31 37 13 F-1 Fly Run 1 6 F-2 Fly Run Other 11 10 3 TTT-1 Fly Run Other 7 10 2 TTT-2 Fly Run Other 5 2 2 RK-1 Fl...

docs.google.com

Heart

Heart Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 64 80 55 41 79 50 Use in reference to person vs. Item vs. Location F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Person 60 80 50 39 76 43 Item 1 0 2 1 1 2 Location 3 4 3 1 2 5 Who it is used for F-1 ...

docs.google.com

Use of Hope

Use of Hope Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 82 90 75 37 103 66 Overall Person/people Type Any 364 8 81 Overall Hobbits Other persons (Not including groups) 106 89 Use of Hopeless F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 1 3 1 2 ...

docs.google.com

Smile

Smile Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 18 26 11 8 13 9 Who is Smiling Overall use per main character of Smile Frodo Sam Merry Pippin Aragorn/Strider Gimli Legolas Boromir Gandalf Theoden 7 3 1 1 16 2 1 2 8 5 F-1 Aragorn Frodo Gand...

docs.google.com

Pale

Pale Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 38 39 29 37 16 13 F-1 Light Eyes Time of day Person/group Sky Place/ landmark Misc. Stars 10 2 4 5 4 5 6 1 F-2 Light Sun Sky Person/ Groups Time of day Item/ plants Eyes Misc. Place 7 2 ...

docs.google.com

 

[ruth barratt]

Metals

Gold

Gold Overall usel F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 31 36 17 13 12 6 F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Metal 24 19 9 7 8 3 Colour 6 17 8 6 4 2 Use per chapter C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 C-9 C-10 C-11 C-12 F-1 5 5 2 ...

docs.google.com

Silver

Silver Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 23 50 17 20 25 31 F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 Colour 9 17 15 12 14 17 Metal 11 31 2 7 9 12 Use per chapter C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 C-9 C-10 C-11 C-12 F-1 4 0 ...

docs.google.com

 

[ruth barratt]

Keen

Keen Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 7 12 15 6 3 3 Overall use (in ref to) Delight Dagger Eyes Lance Feel Swords Air Eyes/ look Sense Faces Ears Air Voice Wind 1 1 16 1 1 2 4 4 7 2 1 4 1 4

docs.google.com

Gollum vs

Gollum vs. Sméagol Overall use Gollum F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 32 25 0 242 0 21 Sméagol F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 8 1 0 142 0 2 Use per person Gollum Bilbo Gandalf Sam Frodo Aragorn Boromir Gollum Narrator 4 29 34 15 3 1 3 ...

docs.google.com

 

[ruth barratt]

I'm back and my first new page is Eyes. Sorry for the tiny font in places.

Eyes

Eyes Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 101 138 140 172 104 99 Use per person F-1 Gandalf Bilbo Merry Sauron Gollum Pippin Sam Frodo Tom Luthien Hobbits (group of) Elves (group of) Elbereth Rangers/ watchers Farmer Maggot The conspiracy Butter...

docs.google.com

I have also done the uses of Mr. and Master

The use of Mr

The use of Mr. Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 131 26 0 49 0 114 Who is called Mr F-1 Bilbo Frodo Drogo Sandyman Boffin Gandalf Maggot Pippin Merry Butterbur Mugwort Strider 24 25 4 1 1 2 2 7 6 15 1 2 F-2 Frodo Pippin Gandalf...

docs.google.com

The use of Master

The use of Master Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 48 32 49 163 51 61 Who is called Master F-1 Frodo Gorbadoc Everard The Gaffer Sauron Bilbo Pippin Oldbuck Brandybuck head Merry Tom Great Willow The Moon Bill Ferny The hobbits 27 2 1 1 ...

docs.google.com

 

[ruth barratt]

Some new graphs for you:

Use of Home

Use of Home Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 41 31 18 14 7 30 Who is it related to F-1 Bilbo Frodo Ted Sandyman Sam Déagol Wine/ Frodo Folco Snails The hobbits Any Singer Elves Farmer Maggot The Brandybucks Tom Tom/ The hobbits The Forest Sa...

docs.google.com

Type of Journey

Type of Journey Overall use Adventure F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 16 10 1 2 2 5 Quest F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 3 13 5 4 0 5 Journey F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 39 65 29 25 21 25 Errand F-1 F-2 TTT-1 TTT-2 RK-1 RK-...

docs.google.com

Types of Meals

Types of Meals Overall use Breakfast F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 19 2 6 4 5 1 Lunch F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 8 0 2 0 0 0 Dinner F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 5 1 0 0 1 0 Supper F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 26 ...

docs.google.com

Use of Bright

Use of Bright Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 35 31 28 15 11 13 What is Bright F-1 Afternoon Colour Fire Eyes Ring script The Ring Stars Breath Morning The Sun Sky Light Candles Swords The Sickle 1 3 5 6 1 1 1 1 5 3 2 3 1 1 1 ...

docs.google.com

Use of Dim

Use of Dim Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 13 28 19 26 26 16 What is Dim F-1 Sky Sight LIght Sound 1 5 6 1 F-2 Memory Sight Light Colour Shadow Sky 2 8 15 1 1 1 TTT-1 Sight Light Sky Awareness Sound 4 11 1 2 1 ...

docs.google.com

 

[ruth barratt]

I was wondering about the feelings of the people in the book so here's a folder full if there is any I missed that you would like to see just give me a shout.

Feelings - Google Drive

drive.google.com

 

[ruth barratt]

So I was wondering about the word Fool, who is called fool the most and who uses it the most. The answer is Gandalf for both of them.

Use of Fool

Use of Fool Overall use F-1 F-2 TTT-1 TTT-2 RK-1 RK-2 6 10 17 4 11 22 Who is called Food Overall The Brandybucks Bilbo Gollum Sam Frodo Radagast Gandalf's Friends Butterbur Pippin The Company Saruman Orc Uglúk Merry & Pippin Sauron 1 2 1 5 4 1 1 ...

docs.google.com

 

[ruth barratt]

I went a little crazy and the times of day!

Time of day - Google Drive

drive.google.com

 

[ruth barratt]

So at my mum's request, I have started logging plant names. the book Flora of middle-earth by the Judds is a brilliant book and helped loads with this.

Plants

List of words List of words recorded so far,Key <a href="#gid=1673842689">Aeglos</a> <a href="#gid=321245811">Alder</a>,Highlight <a href="#gid=331244265">Alfirin</a>,Hyphenated <a href="#gid=1265486088">Anemones</a>,Used as a name <a href="#gid=1877008761">Apple</a>,If it is Pipe-weed <a href="...

docs.google.com

 

[ruth barratt]

So to save me having to update this thread every time I do a word sheet I have put them all into folds that I will just update instead.
Here are the links for all the folds. Have fun all.

Bad guys - Google Drive

drive.google.com

Metals - Google Drive

drive.google.com

Story and Tales - Google Drive

drive.google.com

Cap vs. Non-cap - Google Drive

drive.google.com

Misc - Google Drive

drive.google.com

Names - Google Drive

drive.google.com

Light related - Google Drive

drive.google.com

Person related - Google Drive

drive.google.com

Worksheets for word logging - Google Drive

drive.google.com

 

[ruth barratt]

Hello all,
So I have started to add the Historys to my spreadsheets. I have begun with Unfinished Tales in the plant sheet.
If some of you lovely people didn't mind looking at it and letting me know if it makes sense I would be very grateful.

 

[Kathrin]

oh this is coincidentally very interesting to me! I've been translating and reconstructing the "lost poem" Mim's Klage, that we only have in german, and i have been pouring over word choice for quite a while xD I will have to take a look and see if I can deduce any translation choices from this

 

[ruth barratt]

Let me know if you need any words that I haven't done yet and I'll add them to my list.