Completionist Tracker (All deeds, titles, virtues, mounts)

[Whiteberry_Laurelin]

I have been working for a while on a "Completionist Tracker" containing all deeds, virtues, titles and mounts (so far) in-game and the first non-beta release is ready.

As the name says, this is a Completionist Tracker for those, who want to keep track of what they have completed and what they are missing of deeds/virtues/titles/mounts. I wanted to make this since I found it increasingly difficult to keep track of anything with the poor in-game logs (especially the Deed Log).

It includes deeds such as hidden, consumption, festival, meta, epic and classes/vocations/races are taken into consideration.

If others can find use for it as well, it's only a plus :)

Please note:

• It is not a plugin
• It does not pull info from the game automatically
• It is currently only available in Open Office Calc format (3.2.1+). Open Office is a free open source suite very similar to MS Office.
• It does not contain Monster player content

Please note: This project has stopped being updated from March 15, 2014.

Update 1.8.4:
2014-02-05

Download

New:

• Classes: Added an extra line in totals “Trait points missing” to make it easier to overview since the quest points aren't counted in the completion rate (because they are not deeds).
• Mounts/Exclusive: Added 'Westfold Steed'.

Fixes:

• General: Fixed issue with greyed-out cells when choosing to display less than 9 characters.
• Setup: Removed update of the number of characters to count for totals since it was causing problems when updating the sheet. The number will have to be set by users after updates.
• Eriador/Dunland: Corrected Meta deed “Slayer of Dunland” to be based on tier 1 slayer deeds and not tier 2.
• Mounts/Promotional + Standard: Fixed an error where Steed of the Red Dawn was not updated correctly when updating to a new tracker version.
• Mounts/Promotional + Standard: Combined the two Bree-steeds (Founder + Starter) in one count since they are identical and both can't be obtained on the same character.
• Reputation/Guilds: Fixed issue with greyed-out cells for all but cooks.
• Titles/Social: Attempted to fix issue with totals for users using other language version of Open Office/Libre Office than English. Thanks to Marmi for the help trying to sort this out.

Screenshot Samples:

[LadyDena]

Hi. Thanks for making this, I haven't downloaded it yet but would like to ask a question.

How does this thing work if it doesn't pull information from the game? Where is it getting its data from?


And a question for the computer savvy people :

This is actually a program I would be interested in using, but I'm of course deadly paranoid about trojans and key loggers. Can a computer guru person or two check this out to make sure it is okay? It sure sounds useful and I'd like to know if I have missed things.

[Achy]

Sure look interesting Berry

I am currently downloading it now

[Whiteberry_Laurelin]

Hi. Thanks for making this, I haven't downloaded it yet but would like to ask a question.

How does this thing work if it doesn't pull information from the game? Where is it getting its data from?

You simply check your Deed Log in-game and mark the deeds you have done in the tracker. There's a "mark all as completed" function, so it shouldn't be too tedious for those who have a lot of marks to put, but it's still manual work

And a question for the computer savvy people :

This is actually a program I would be interested in using, but I'm of course deadly paranoid about trojans and key loggers. Can a computer guru person or two check this out to make sure it is okay? It sure sounds useful and I'd like to know if I have missed things.

I understand your concern. To clarify: The file is like an Excel file and does not contain any macros, but you will need Open Office Calc installed. There are online tools available to check files for malicious content such as: http://www.virustotal.com/

[Xandarien_PoTI]

I'm probably missing something, but it seems to want a password and won't open?

[Whiteberry_Laurelin]

I'm probably missing something, but it seems to want a password and won't open?

This will happen if you try to open the file with Excel and perhaps also older versions of Open Office than 3.2.1.

[Sebbi]

Lovely, I was trying to work out something myself of a similar nature but this is.. much better!

good stuff Whiteberry

[Whiteberry_Laurelin]

Lovely, I was trying to work out something myself of a similar nature but this is.. much better!

good stuff Whiteberry

Thank you Glad you can use it.

[Whiteberry_Laurelin]

Update 1.5.6:

Several corrections to mounts, deeds and deed orders have been made.

This version 1.5.6 is now made ready for future updates (fx Rise of Isengard), so that most or all the data typed in by users in this version can be automatically transferred to updates.

[Lestache]

Ew, European notation using commas in place of decimal points!

Just kidding, of course.

It looks pretty cool - I may check it out. Thanks for putting this together.

[Whiteberry_Laurelin]

Ew, European notation using commas in place of decimal points!

Just kidding, of course.

It looks pretty cool - I may check it out. Thanks for putting this together.

That's actually a good point - I hadn't caught that, thanks Will be updated.

[Lestache]

That's actually a good point - I hadn't caught that, thanks Will be updated.

No worries. I think you should leave it the way it is. Force some of us Americans to learn something about other parts of the world, even if that something is "some places use commas where we would use decimal points".

And I did check it out - it's pretty neat. A bit depressing to know that I'm not nearly as close to finishing every deed as I thought I was, but I already knew that the group skirmish LT deeds and emote deeds were going to find me wanting. Not to mention the Ettenmoors deeds. Ugh. :P

[Whiteberry_Laurelin]

Thanks to everyone for the feedback and ideas, I have received.

Updater added:

I added a program, which makes it possible to automatically update to new versions of the tracker (from version 1.5.6 and newer) without having to retype your data.

Update 1.5.7:

Prepared for future sheet/row additions (simplifying updates).
Titles added to deed sheets
Overview changed to include all sheets
Added “Misc” sheet (Instrument Proficiencies & Key Ring)

Download

[Iledwen]

Thanks Whiteberry, that's a nice tracker. I made an excel sheet myself some time ago, but at some point stopped updating the new deeds.

[Grahlwur]

First of all, really amazing work! Been longing for something like this, but thought it was hard to make something useful without the game's support to pull the data automatically. Gotta say though, it's really worth downloading OpenOffice and check all deeds manually to get this kind of overview!


Now, some questions/suggestions/thoughts/whatever:

Key ring: There's one key that's missing from the list: West Gate Key from Fornost (http://lorebook.lotro.com/wiki/Item:West_Gate_Key) this key allows you to get to the 3rd boss without having to defeat any of the previous.
(There also used to be several keys in Garth Agarwen, and if you obtained them before they revisited the instance you still have them in your key-ring. Though they are useless nowadays and you can't obtain them anymore, so really no point adding them to the list.)

Mounts: Not sure if this is the Founders-mount, it might very well be http://lorebook.lotro.com/wiki/Item:Bree-Steed
Bree-land Starter Steed tooltip says "Barring Skills: Bree-Pony, Bree-Horse, Bree-Starter Pony, Bree-Starter Horse", so I guess you gain Bree-Steed by using Bree-land Starter Steed as well... but it is sold separately by Gaelm at Hengstacer Farm and is listed in mount-tab as an individual horse. Perhaps you are aware of this already and count Bree-Steed and Bree-Starter Horse as the same horse, but this just made me a bit confused.
Tame redhorn, Nimble redhorn and Smokey black all have the prefix Prized; Prized Smokey Black Horse etc.

Titles: I am pretty sure they screwed up some of the Helegrod-titles with the update, a few for sure, and I have complete all deeds/quests in there but still can't seem to find "The Venomous", "Giant Dues-collector", "Hatchery Raider" and "Hated by Zaudru" in my titles-list. You might better take a look in your own list but I suspect these are removed from the game.
Also, from where do you get the quest for "Steward/Stewardess of Order".. Can't seem to find any info on the net and haven't done it myself, is it available in game for sure?

Social deeds: Is "A Game of Hobnanigan" available at all anymore, even during summer festival? According to lotro-wiki it's an "Old quest, last seen 2008", maybe that's what you mean by "Game is currently disabled" though.
The entries with the note "uncertain whether this is a deed or just a quest/title", looks to me like it's "just a quest/title". Completed everything I've found during Yule festival for couple of years now and haven't completed any of the deeds which have that note.

Skirmish deeds: I found one deed in my log that's not listed in the tracker: "Pride of Endurance -- Fellowship". "Survive in the Barrow-downs for thirty minutes as part of a fellowship" // "This deed has been completed. (5/5)". Guess it's available for other sizes as well, but this is all info I have. Might find something useful here though: http://forums.lotro.com/showthread.p...87#post4613887

Suggestion: There are some deeds I have not completed for some reason, and am not able to do anymore. Basically, I would like the opportunity to mark something as completed with something else than an X.
For example, I never did all the undying-deeds when I leveled up, and of course I cannot do them anymore. Instead of marking it with an X I'd like to be able to mark it with something else, like a Z, which still would make it count as completed, but when I browse the list of deeds I can see there's a Z and not an X, meaning that I actually have not completed it but want it to count as completed. Another example could be the PAX-horse, I would for sure never get that one, and if I mark it with an X I really have no idea (at least a few months later) whether I have it or just want it to count.
The basic reason behind this suggestion is that I want the percentage to show what I can get, rather than what was once available and is no longer so.

P.S. the tracker works great in LibreOffice as well (surprise surprise).

Regards,
Grimfrithgar

[Yula_the_Mighty]

Titles: I am pretty sure they screwed up some of the Helegrod-titles with the update, a few for sure, and I have complete all deeds/quests in there but still can't seem to find "The Venomous", "Giant Dues-collector", "Hatchery Raider" and "Hated by Zaudru" in my titles-list. You might better take a look in your own list but I suspect these are removed from the game.

Some of these titles have been removed from the game.

Social deeds: Is "A Game of Hobnanigan" available at all anymore, even during summer festival?

Another name for it is Chickenball. This festival activity was removed about 3 years ago. I doubt it is ever going to return at this point. I do not think Turbine going to expend the resources to fix the problems.

[Whiteberry_Laurelin]

Grimfrithgar, thank you very much for your great feedback and for taking the time to help. I have added my comments below:

Key ring: There's one key that's missing from the list: West Gate Key from Fornost
(There also used to be several keys in Garth Agarwen, and if you obtained them before they revisited the instance you still have them in your key-ring. Though they are useless nowadays and you can't obtain them anymore, so really no point adding them to the list.)

Great, I will look into it and add the Fornost key. I will skip the GA ones since they are no longer usable.

...so I guess you gain Bree-Steed by using Bree-land Starter Steed as well... but it is sold separately by Gaelm at Hengstacer Farm and is listed in mount-tab as an individual horse.

I will look into this as well with the Bree mounts and get them corrected and sorted, thanks.

Tame redhorn, Nimble redhorn and Smokey black all have the prefix Prized; Prized Smokey Black Horse etc.

I know that some of the (reputation) horses can be bought in the store as well and have lower hp (I think) and not the "Prized" prefix. My aim has been to add those that are available outside the store, so I will add the prefixes needed.

Titles: I am pretty sure they screwed up some of the Helegrod-titles with the update

I was aware that some of them were no longer available, but wasn't sure if the titles already gained had been removed from the game. I will check up on this, thanks.

Also, from where do you get the quest for "Steward/Stewardess of Order"

The Steward/Stewardess of Order I read about here: http://forums.lotro.com/showthread.p...al-deed!/page2 - I suppose that they are hidden Yule/Harvest Festival titles like the rest, but can't confirm it 100%.

Social deeds: Is "A Game of Hobnanigan" available at all anymore, even during summer festival? According to lotro-wiki it's an "Old quest, last seen 2008", maybe that's what you mean by "Game is currently disabled" though.

Yes, that's what I mean with "Game currently disabled". I might change it to "no longer available".

The entries with the note "uncertain whether this is a deed or just a quest/title", looks to me like it's "just a quest/title".

Thank you - I haven't been able to confirm whether those were deeds or quests. Have you received the titles associated with these? (Titles/Social: Party Fouler, Spoiler of All Things Good in this World, etc.?)

Skirmish deeds: I found one deed in my log that's not listed in the tracker: "Pride of Endurance -- Fellowship".

I found this deed today myself as well and it will be added (For Small FS/FS/Raid/Complete) along with "Pride of Endurance" and the rest of the "Defeating the Dead".

Suggestion: There are some deeds I have not completed for some reason, and am not able to do anymore. Basically, I would like the opportunity to mark something as completed with something else than an X.

I really like this idea and will implement it with next version. It's a good way to get an overview of what your aim is to complete, rather than always having 99% in total, when there's some deeds you can't/will never do. Thank you - excellent idea.

P.S. the tracker works great in LibreOffice as well (surprise surprise).

That is great to know - thank you for the info

[Yula_the_Mighty]

I was aware that some of them were no longer available, but wasn't sure if the titles already gained had been removed from the game. I will check up on this, thanks.

It is unclear to me what Turbine did. Some of the titles like Venomous are not possible to get any more. The forums complaints seemed to indicate that anybody with the Venomous title was stripped of the title. Although I have lots of titles between my characters. Venomous was not one of them.

[Whiteberry_Laurelin]

Thanks for all the comments and PMs I have received on the Barrow-downs survival deeds.

I am currently updating the sheet with the tier 1 - 4 slayer deeds and "Weathering the Storm" in addition to "Pride of Endurance" and "Rulers of the Dead", making it a total of 58 different deeds for the Barrow-downs skirmish.

[Whiteberry_Laurelin]

Update 1.5.8:

Added tracking of emotes & notes on how to obtain them
Added tracking of epic quests & notes on start NPCs and locations
Added tracking of FMs & guide to what they do
Changes and additions of several deeds (especially the Barrow-downs survival ones).

It now has a feature to mark items as "voided" for those, which you would like to count towards the total but haven't actually completed. Fx deeds that are no longer obtainable.

Download

[Ceifwien]

Why did you need to release this AFTER i'd finished every deed on my minstrel?

Jokes aside, good effort- it would rock if it could somehow magically fetch the completed data from in game, perhaps a future idea?

[HolyGigi]

Looks really awsome, but I cant open it in Excel. I get "the file has been protected with a password and cannot be open"
Dont really feel like installing Open Office just for this. Is there anything I can do to use Excel for it?

[Whiteberry_Laurelin]

Jokes aside, good effort- it would rock if it could somehow magically fetch the completed data from in game, perhaps a future idea?

Yeah, it would rock. I'd be open to hearing if anyone has ideas to how this could be done

[Whiteberry_Laurelin]

Looks really awsome, but I cant open it in Excel. I get "the file has been protected with a password and cannot be open"

Aye, as noted in my initial post, it will not be compatible with Excel.

Dont really feel like installing Open Office just for this. Is there anything I can do to use Excel for it?

No, not at this point. I will most likely only do it in Open Office in the future as well, since it is too much work to prepare both versions for updates, etc.

[Ramuch]

Some things that i notice in your tracker :

• the class name "Burglar" in the "CRE tab" is hidden (line 23) but the others class don't
• with the deed "Bulwarks of the enemy (8 of 8)" in the Moria comes a title (Deep-Delver), and this title doesn't seem to be in your tracker in the Virtues list tab. For help i found this title ingame in my title list, sub-section "Deed".
• the % total count in the sub heritage section of the Title tab is a bit weird. If i "x-mark" 3 titles the % show 200% instead of 100% and i've notice that it's counting 3 completed AND 3 avoided titles
• same for the hobby and kinship sub-section

Finally, i want to congrats you for this wonderful tool.

PS : sorry if my english is a bit poor and incomprehensible but i'm french and not really good with english language...