We have detected that cookies are not enabled on your browser. Please enable cookies to ensure the proper experience.
Results 1 to 25 of 127

Hybrid View

  1. #1
    Join Date
    Dec 2011
    Location
    Rivendell
    Posts
    140

    LotRO Character Log - Deed Tracking File

    Greetings Free-folk of Middle Earth,

    I am Maranwethiel of Landroval server, formerly Denebrian of Laurelin. I have been playing LotRO for just over 2 years and feel I have gained enough knowledge of the game to share some of it with the community. I love to deed grind with a passion, having ground over 300 deeds each on 8 different characters across 2 servers. I wanted to have a way a to keep track of what deeds each character could do; what they had already done, etc.

    I used Whiteberry's Completionist Tracker for a while. Her file was very good in getting me at least knowing somewhat what to do as far as deeds. Its one downfall, for me at least, was Open Office. Free is good, don't get me wrong, but the load times of files used in Open Office is ughhh, slow. Another issue I personally had was information overload. What I mean here, is most things listed did not have enough information for me to understand where something was, what to do, was it still in game, etc. This meant a lot of trips to lotrowiki, and asking others what or where something was.

    That brings me to today, this posting. I wanted something smaller, something more in line with the deed log itself. I wanted more details on deeds; if it was explorer, the coordinates, quests in instances to complete, what to do for challenges, etc. I also wanted something to keep track of the trait levels for each of my characters, how many Turbine points I had earned on my account, what character had and had not done an instance yet. I had enjoyed some of these features in Whiteberry's file, even the way she had laid it all out.

    In early October I began working on making a version similar, if only in appearance to Whiteberry's, yet with my own unique flavor. I wanted something that would run in Excel. Why? You may ask. Excel opens spreadsheets a whole lot quicker than Open Office, runs smoother, and I know how to work with it. My first version of a deed tracker was a sorry looking excuse of a file, I wont lie to ya, and rather large (8+ mb). Some time around mid-November I decided to look into some visual basic coding to handle some of the functions you still see in current versions of the file today. In fact, every single command button in the file runs in visual basic, when a button is clicked. This alone knocked the file size down a comfortable size of 2.5mb, which is small when you consider the amount of information in this workbook file. The file contains nearly 1400 deeds.

    So, you have made it through the wall of text, on the history of this file. You are likely wondering why I had to tell a story before getting to my point. My answer, I am female, its what we do. Seriously though, the point to this post is to let everyone know what is coming in the next version of this file. The next version, coming soon (maybe by this weekend), will fix the biggest hurdle I have had since day one with this file. Having to copy and paste data whenever I issued an update to the file.

    I also would like to welcome a kin-mate of mine to the team and all his help with the vba coding. Thank you Bracke, aka Karotte, here on the forums. In addition to his help on the vba coding, Bracke will also be handling the German translation of this file, and helping me with quality control issues. Yes, sometimes I get the fat finger, or type sometimes ahead of my thinking. Extra eyes help, a lot with looking over so many deeds. We are looking for an additional member of the team to handle the French side. This person will need to be fluent with Microsoft Excel, speak English as well, and deal with my craziness. This is not a paid job, we are doing this because we love the game and want to share knowledge with the community.

    More info about LotRO Deed Log HD can be found at https://sites.google.com/site/wintersongofarda/deeds. Feedback and suggestions are welcomed. Thank you for reading and if you use the file already, your support.
    Last edited by Denebrian_Wintersong; Jan 22 2016 at 03:16 AM.

  2. #2

    Thank you!

    I'm going to download the tool as soon as I'm done here. I've been trying to find a good spreadsheet to keep track of things as I've had to dump quests when my tracker got too full. Now that my kin have jumped ship for the summer, I want to take the time to go back and complete those quests. This will be a big help!

  3. #3
    Join Date
    Jul 2013
    Location
    Orel. Russia.
    Posts
    14
    I use ODS.

  4. #4
    Join Date
    Oct 2013
    Location
    Ireland
    Posts
    1
    Thank you so much for this utility. It has helped me as a returning player to re-adjust back into Middle Earth.

  5. #5

    Appreciation!

    Just to say thank you for a great work!

    I realize that you chose not to include crafting deeds, including the vocation deeds... This apparently also means no place to track Craft Guild rep either? I'll add my wish for including crafting, tho I understand it is a low priority to other deeds in game. :-)

    Again, thank you for the huge effort to make this work!

  6. #6
    Join Date
    Dec 2011
    Location
    Rivendell
    Posts
    140
    LotRO Character Log v1.2.4 is now available for users of Microsoft Office Excel

    Find it here.

    Changes and additions as follows:
    • Fixed various typos and formula errors
    • Added Roving Threat-slayer deeds to Race_Social Miscellaneous
    • Added The Ballad of Bingo episodic quests
    • Added Epic Battles


    Still working on update to file for Open Office users. Will post when its available.

  7. #7
    Join Date
    Dec 2011
    Location
    Rivendell
    Posts
    140
    - Side by Side Comparison LotRO Deed Log for Excel and Open/Libre Office -

    See the table below which compares these 2 versions:


    Detail .xlsm .ods
    Number of sheets in file 49 23
    Number of deeds in file 1724 1724
    Number of quests in file 1679 1679
    Has Optional Bingo Boffin quests and Epic Battles Listings Yes Yes
    Formula protection Yes Yes
    Contains Macros Yes Yes
    - semi-automatic hide/unhide of row/columns/elements o o
    - semi-automatic update feature o o
    Requires manual user input? Yes Yes
    Last edited by Denebrian_Wintersong; Jan 02 2017 at 01:05 AM.

  8. #8
    Join Date
    Dec 2011
    Location
    Rivendell
    Posts
    140
    File version 1.1.1 of LotRO Character Log is now available

    v1.1.1 Patch Notes:
    Sheet Type Details
    Home New Sheet This sheet will function as the start page for the file, even if the file is saved on another worksheet.
    About Edit Formatting and layout changes.
    Setup Change Moved "Copy Data" button to top of sheet; added more details on its usage.
    Changed drop-down list order; added usage tips within the drop-down lists.
    Added image icons for class and professions. These will change automatically based on drop-down selection.
    C|R|E Edit Class deeds - added class icons; tier deeds are highlighted by red text; adding daily skill usage (only partially complete)
    Class quests - adding quest giver for each quest (only partially complete)
    Vol 3 Epic deeds - Deeds that require Riders of Rohan Legendary Edition are highlighted in white text.
    S|E|R Edit Added partial deed names for each reputation tier; corrected some of the reputation titles.
    Eriador Change

    Edit

    New
    Moved deed type to column A; highlighted deeds not associated with the regional meta deeds by red text.
    Rearranged deeds for Enedwaith and Dunland to match game deed log, meta deeds were not moved.
    Added quests and deeds for Roving Threats and Treasure Cache of Eriador.
    Rhovanion Change

    Edit
    Moved deed type to column A; highlighted deeds not associated with the regional meta deeds by red text.
    Rearranged deeds for Great River to match game deed log, meta deeds and instance deeds were not moved.
    Gondor -
    Hobby
    Edit Moved deed type to column A.
    Mounts Edit
    New
    Reordered all mounts to alphabetic listing.
    Added 2 new reputation mounts. Added missing festival mounts.
    Titles Edit Simplified lookup formulas to make sheet faster.


    Special Notes for users that are updating (new users can ignore these notes):
    1. Both files had minor color pallete changes.
    2. Setup sheet notes

    • The image icons are only found in the Microsoft Office version of the file as Open Office does not support image swapping in the same way. These areas of the sheet will be empty space.
    • If you have a Rune-keeper or Lore-master character you will need to change their drop-down selection to Runekeeper or Loremaster.
    • Any unused drop-down list will need to be returned to its new version state after the file has been updated. For example if slot 10 is not being used you will need to set all drop downs in slot 10 to what they were when you first opened v1.1.1.
    • Open Office and Libre Office users will need to re-enter their data on the Setup sheet in addition to resetting unused drop downs. (could not be helped, sorry)
    • Open Office now has conditional drop-down lists to match its Excel counterpart. What this means is you will only see, for example, Beorning class listed for characters with a Beorning race.


    3. Corrected minor bugs that were posted on the Facebook page.

    Other notes:


    • The website address remains the same as before https://sites.google.com/site/wintersongofarda/deeds, from there you will be directed to the page to support your office software.
    • I will no longer be posting an exclusive xls version. Users of Microsoft Office 2003 or older, you can download the 2007 compatibility pack to use the xlsm version from Microsoft Office's website. The copy/paste function should still work to transfer from .xls to .xlsm.
    • And lastly please read this, since some have forgotten or either don't bother to read the About sheet in the file. *NOTE* All files downloaded from this site are in zipped format. You will need to unzip the folder and open the file from the unzipped folder. Opening the file from the zipped folder will be READ ONLY. Also, for both file extension types, you will need to enable the macros to run for the file to function as intended.



    Last edited by Denebrian_Wintersong; Mar 16 2015 at 10:30 AM.

  9. #9
    Amazing work! Totally digging it

    one little issues I noticed registering my main deeds: quests of kingstead is missing in westemnet tab.

    Keep up the good work!
    [charsig=http://lotrosigs.level3.turbine.com/042080000002232c7/01003/signature.png]undefined[/charsig]

  10. #10
    Join Date
    Dec 2011
    Location
    Rivendell
    Posts
    140
    Checked both versions of file.

    Quests of Kingstead is first deed listed for both under Westemnet.

    Thank you for using.

  11. #11
    How did I miss it? I even double-checked it! lol

    Let's just pretend I didn¿t say anything and move on :P

    Thanks for the help
    [charsig=http://lotrosigs.level3.turbine.com/042080000002232c7/01003/signature.png]undefined[/charsig]

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

This form's session has expired. You need to reload the page.

Reload