My LotRO Excel File

[Saelios]

I've been keeping a LotRO spreadsheet for quite a whlie now, and I've had a few requests to share it, so I've posted it to my public folder on Dropbox. Here's the link. Here are a few notes about the contents:

 

• Miscellaneous Tab - Contains general quick-reference stuff, like instance quests my different characters need, remaining vault space, etc.

• Quests Tab - A list of all the quests any of my characters has done or is doing. A "Y" means it's done, green means it's in progress, yellow means the character doesn't have it, and red means the character is ineligible for it. (This coding applies to most of the tabs.)

• Deeds Tab - Only contains Class/Race/Social, Eriador, Rhovanion, Gondor, and instance deeds.

• Meta-Deeds Tab - Component deeds for the Eriador, Moria, Lothlórien, and Mirkwood meta-deeds. This tab has reference links to the Quests and Deeds tabs, so if you fill those out correctly, this one will be populated automatically.

• Recipes Tab - Crafting recipes.

• Reputation Tab - Each character's rep with each faction, with a column to remind me which character stores any extra rep items from a faction (I save these and give them away when I get a full stack).

• Keys Tab - Which characters have which instance keys.

• Skirmishes Tab - Cosmetic options I picked for my skirmish soldiers. I also keep track of instances I run during the week, so I know who's on cooldown for what (when I remember to write it down).

• Virtues Tab - What each virtue does, and which characters slot which virtues.

• Crafting Tab - Which characters are what level at which crafts.

• Crafting Mats - I try to keep a stack of each kind of crafting mat in the vault.  This tracks who has a full stack of what, and who still needs more of a particular material.

• Legacies Tab - The list of available legendary item legacies for each class. The Rank column shows my relative preferences.

• Mounts Tab - Which characters have which mounts.

• Decorations Tab - Which characters have which Taxidermist-type decorations.

• Eggs Tab - Which characters have collected which Farmers Faire eggs.

• Emotes Tab - Which characters have learned which emotes.

• Big Battles Tab - Which characters have completed which parts of the big battles, with color coding for bronze, silver, and gold, and a 'Y' for platinum.

• Stats Tab - Which characters have used which stat tomes.

[Golbo]

oh. emm. GEEE!!!!!1!

[Taisie]

Oh my god! Thanks so much for sharing, I love this.

[Plaidflower]

This is absolutely amazing. Thank you for sharing!!!

[Pyramus7]

Wow, you are super organized. This is awesome!

[Saelios]

I've put an updated version of this file on Dropbox.  The link in the OP still works, and I've updated the tab descriptions, as I've added a few.  

[groucho42]

Finally remembered and went out to get it. Thanks Ev!

[groucho42]

Ev, I downloaded it and started working. The first tab I've looked at in detail in the rep tab. It doesn't have any of the rep for the last couple of zones. you mentioned the link in the OP should work so just checking. When you go to it do you see your current spreadsheet?

 

Thanks

[groucho42]

Another techie/dweeb question/issue. I'm looking at deeds and I'm not seeing columns for tab and zone. Did they get dropped? It looks like you have zones sorted alphabetically, starting with Angmar, but I'm not seeing anything that specifies the zone except in a couple of titles.

 

thx

[Saelios]

Grouping is Tab, and Sub-Grouping is Zone.  I don't have any entries for Hobby or Skirmish, yet.

[groucho42]

I've been adding my information into the spreadsheet and I've gone into some areas Ev hasn't yet added. I've also found a couple of item missing in older areas. Just cuz, figured I'd share what I have so far with folks.

Supposedly, https://www.dropbox.com/sh/e7w1bihokl99fjh/AAC3Km_M_S8SOIw7hEGECuVYa?dl=0 will get you there.

[Rubigrangea]

This is spectacular. Thank you. :)

[Mortanah]

I knew you were amazingly organised but this is insane!!! Such a great job. 

[Taisie]

Thanks to whoever bumped this. I really need this now :-/

[Saelios]

Latest version posted.