Events Calendar
 
Ventrilo Status
 
Who's Online
 
Poll Widget
 
Site Contributions
 
1
 
Post new topic   Reply to topic    Away Shall Fade Forum Index -> Other Guides
View previous topic :: View next topic   Goto page 1, 2  Next
Saelios
Former Leader
First Marshal

First Marshal
user avatar
Awarded:
Joined: 23 Jun 2008
Posts: 465

Send private message
Reply with quote

re: My LotRO Excel File

0

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.


Last edited by Saelios on Mon Oct 13, 2014 7:52 am; edited 1 time in total
Golbo
Golbo
Member
First Marshal

First Marshal
user avatar
Awarded:
Joined: 02 Mar 2008
Posts: 558

Send private message
Reply with quote

re: My LotRO Excel File

0
oh. emm. GEEE!!!!!1!
Taisie
Taisie
Officer
Captain-General

Captain-General
user avatar
Awarded:
Joined: 31 Aug 2009
Posts: 887

Send private message
Reply with quote

re: My LotRO Excel File

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


_________________
Plaidflower
Member
Third Marshal

Third Marshal
user avatar

Joined: 20 Jun 2011
Posts: 270

Send private message
Reply with quote

re: My LotRO Excel File

0
This is absolutely amazing. Thank you for sharing!!! Happy
Pyramus7

user avatar

Joined: 01 Jun 2012
Posts:

Send private message
Reply with quote

re: My LotRO Excel File

0
Wow, you are super organized. This is awesome!
Saelios
Former Leader
First Marshal

First Marshal
user avatar
Awarded:
Joined: 23 Jun 2008
Posts: 465

Send private message
Reply with quote

re: My LotRO Excel File

0

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

user avatar

Joined: 01 May 2009
Posts:

Send private message
Reply with quote

re: My LotRO Excel File

0

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



_________________
Whyaduck, hunter


Bahtring Rahm, guard

Balagan, burglar


Cuisanart, champion

JeffreyT Spalding, captain

QuincyAdams Wagstaff, LM

Rapakivi, Rune-Keeper

RufusT Firefly, Warden

Whyanochickens, hunter frozen at 65
groucho42

user avatar

Joined: 01 May 2009
Posts:

Send private message
Reply with quote

re: dropbox working?

0

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



_________________
Whyaduck, hunter


Bahtring Rahm, guard

Balagan, burglar


Cuisanart, champion

JeffreyT Spalding, captain

QuincyAdams Wagstaff, LM

Rapakivi, Rune-Keeper

RufusT Firefly, Warden

Whyanochickens, hunter frozen at 65
groucho42

user avatar

Joined: 01 May 2009
Posts:

Send private message
Reply with quote

re: My LotRO Excel File

0

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



_________________
Whyaduck, hunter


Bahtring Rahm, guard

Balagan, burglar


Cuisanart, champion

JeffreyT Spalding, captain

QuincyAdams Wagstaff, LM

Rapakivi, Rune-Keeper

RufusT Firefly, Warden

Whyanochickens, hunter frozen at 65
Saelios
Former Leader
First Marshal

First Marshal
user avatar
Awarded:
Joined: 23 Jun 2008
Posts: 465

Send private message
Reply with quote

re: My LotRO Excel File

0

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

groucho42

user avatar

Joined: 01 May 2009
Posts:

Send private message
Reply with quote

re: Slightly updated version

0

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.



_________________
Whyaduck, hunter


Bahtring Rahm, guard

Balagan, burglar


Cuisanart, champion

JeffreyT Spalding, captain

QuincyAdams Wagstaff, LM

Rapakivi, Rune-Keeper

RufusT Firefly, Warden

Whyanochickens, hunter frozen at 65
Rubigrangea
Recruit
Footman

Footman


Joined: 04 Oct 2010
Posts: 5

Send private message
Reply with quote

re: My LotRO Excel File

0

This is spectacular. Thank you. :)

Mortanah
Member
Sergeant of the Guard

Sergeant of the Guard
user avatar

Joined: 24 Dec 2011
Posts: 56

Send private message
Reply with quote

re: My LotRO Excel File

0

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

Taisie
Taisie
Officer
Captain-General

Captain-General
user avatar
Awarded:
Joined: 31 Aug 2009
Posts: 887

Send private message
Reply with quote

re: My LotRO Excel File

0

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



_________________
Saelios
Former Leader
First Marshal

First Marshal
user avatar
Awarded:
Joined: 23 Jun 2008
Posts: 465

Send private message
Reply with quote

re: My LotRO Excel File

0

Latest version posted.

Posts from:   
Post new topic   Reply to topic    Away Shall Fade Forum Index -> Other Guides All times are GMT - 6 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
 
 
Most Recent Images
Uploaded by: Ozif on 2017-12-21 19:25:14
Merry Christmas Gorthur
Uploaded by: Finnok on 2017-09-11 14:50:07
Rescued Steed of Agarnaith
 
Kinship Summary
 
Last Forum PostsLast Forum Post RSS Feed
 
Membership
 
User Recognition
 
1