We have detected that cookies are not enabled on your browser. Please enable cookies to ensure the proper experience.
Page 1 of 23 1 2 3 4 5 11 ... LastLast
Results 1 to 25 of 566
  1. #1
    Join Date
    Jul 2011
    Posts
    752

    LotroPlan - calculate stats & plan upgrades

    Hi, I would like to introduce you to my planning spreadsheet. It's my first spreadsheet, which I started around the time of the launch of RoR.
    Through time it has seen many improvements and I have used it a lot privately to plan my captain(s) mainly. I found it a great tool to optimize my characters and that's why I'd like to share it with you.

    Here is a picture of how it looks like (version 3.4):


    And here the calculated stats section (version 3.4):


    You can see that everything is looking kinda double. It's two of everything. That's because you want to compare two sets or situations. Your current character like it is now and a new situation, maybe with that item in auction which you can buy or a fully buffed character with food, scrolls, hope tokens whatever.

    The spreadsheet calculates your stats like inside the game and shows your improvements(green numbers) and/or negative effects (red numbers).
    It also shows information on cap percentages and the required rating to reach these for any character level.

    Rating Caps Information (version 3.4):


    The selection of essences by dropdown list (version 3.4):


    A virtue table in the style of Lotro wiki. Play with your virtue selections and change virtue ranks to see what it'll be like when you have leveled them up (version 3.4):


    Currently supports:

    1) All Races (includes racial traits)
    2) All Classes
    3) All Levels (for instance: see what your critpercentage would be when you level up a few), even past the current level cap.
    4) Includes most items: jewelry, armour, essences, legendary items, all food, scrolls, perks
    5) Effects section: captain's IDOME aura, motivation, hope/dread, minstrel's Tale of Tales aura and many more
    6) Stat tomes I-XII (and up to XX for future updates)
    7) Virtues section (what would my stats be with rank19 in...)

    See below for a link to the spreadsheet document in the OpenDocument format (ODS). The spreadsheet works with OpenOffice and LibreOffice, which are free downloadable.
    The spreadsheet will not work in Excel, because of the macro functions and other differences.

    Enjoy.

    Version 3.4 (for U16.2):
    - PvMP support: added PvMP rank, Audacity number, zone selection PvE/PvMP.
    - PvMP: added PvMP sheet with armour, jewelry sets and Ettenmoors effects.
    - new layout: all target percentages in one column. stats have been split in melee, ranged and tactical confirm Lotro's stat panel.
    - changed buff/debuff section into skill tree passives/effects section. effects can be found on (and copied from) the effects sheet.
    - added an effective mitigation percentage based on incoming damage and mitigations.
    - added 55661 items from the excellent LID - LOTRO Item Database by Castorix (see also https://www.lotro.com/forums/showthr...for-gear-gt-lt)
    - reworked Legendary sheet
    - added Rating Caps 'window' with dynamic data & graphs

    Version 3.5 (for U17):
    - added Anórien items
    - some changes related to added LI tiers

    Version 3.5.1:
    - updated ITEMSDB tab from Castorix' latest database (includes U17 items)
    - minor bugfixes (some workarounds for LibreOffice 5.0 quirks)
    - optimizations (mainly style related. now smaller file size: faster loading).

    Version 3.5.2:
    - reworked HD jewelry sheet: now contains all level 100 sets
    - added some Warden effects, submitted by rocksteadie
    - armour calculations again, because I've linked some more data, but shouldn't have any effect for current itemlevels.

    Version 3.6 (for U18):
    - changed calculation of damage/mastery, BPE and medium mitigation. changed corresponding graphs
    - increased BPE ratings on items
    - added Burglar's tactical mastery contribution from agility
    - Champion receives now 3 Block rating per point of Might
    - enabled block rating/% for champion
    - Warden receives now 0 Tactical Mastery rating and 5 Physical Mastery per point of Might
    - added lvl105 T8 essences, armour sets, blue/gold jewelry, purple weapons
    - added new zone "PvE T2". calculations will automatically include T2 mitigation penalty when this zone is selected
    - added support for new zone to Cap Info Panel
    - slightly adjusted armour values for gold leggings
    - armour selection lists are now class specific
    - more intermediate caps
    - added fully scalable Mathom Hunter armour (by character level 1-105, so you can plan at what level to open a box)
    - added automatic scaling Shield of the Hammerhand (automatic stats by character class/level)

    Version 3.6.1:
    - resolved confusing N/A's when changing class

    Version 3.7 (for U18.2):
    - added an opponent level.
    - contains all T2 Penetration debuffs as displayed in-game.
    - mitigation calculations by opponent level.
    - added all 18.2 items.
    - added essence jewelry selection lists.
    - refreshed ItemsDb.

    Version 3.8 (for U19):
    - added U19 Ithilien items (no purples).
    - added essence cloak selection list.

    Version 3.8.1:
    - updated ITEMSDB tab from Castorix' latest database (includes U19 items)
    - added LM Beneficial Sword and Staff Bug passive (see https://www.lotro.com/forums/showthr...16#post7638616)
    - added lvl105 skirmish weapons and updated item levels of skirmish cloaks/jewelry/shields
    - realigned caps panel

    Version 3.8.2:
    - added U19.2 essences and gold bracelets.

    Version 3.9 (for U20):
    - added U20 items.
    - new selection list functions.

    New version 3.10 (for Mordor/U21):
    - many calculation changes
    - includes all new items
    - added Light of Eärendil stat
    - rework of selection lists
    - solved compatibility issues

    Spreadsheet download link: https://www.dropbox.com/s/d88hfqlrsq....10.1.ods?dl=0

    Data/development resources:
    Last edited by Giseldah; Yesterday at 05:35 AM.

  2. #2
    Join Date
    Dec 2007
    Posts
    224
    bump........

  3. #3
    Join Date
    Jul 2011
    Posts
    752
    New version 2.2.1:
    - adds high mastery rating % calculation. see https://www.lotro.com/forums/showthr...97#post7080097
    Last edited by Giseldah; May 24 2014 at 08:47 AM.

  4. #4
    Join Date
    Jul 2011
    Posts
    752
    New version 2.2.3:
    - changed formulas for block, parry & evade (changed in upgrade 12.2)
    Last edited by Giseldah; May 24 2014 at 08:48 AM.

  5. #5
    Join Date
    Jul 2011
    Posts
    752
    New version 2.2.4:
    - some formulas adjusted again. nothing shocking.


    Note on the use of MoraleF (Morale factor in buff section):

    Extra % to morale in Lotro are not added up, but are all multiplied.

    For instance using a yellow line captain as example:

    extra morale% from:
    - Motivated 10%
    - 2-handed Prowess 25%
    - Steeled Resolve 4%
    - Duty bound 5%
    - Hope token 5%

    These percentages are not added up (49% total), but are multiplied like:
    standard morale * 1.10 * 1.25 * 1.04 * 1.05 * 1.05

    If you put that all in one factor then it woud be: 1.10 * 1.25 * 1.04 * 1.05 * 1.05 = 1.576575 (57.6575% total)

    The spreadsheet already has a system for Hope/dread, so you can use that for the Hope %.
    Left is the factor for the other percentages, in this case MoraleF = 1.10 * 1.25 * 1.04 * 1.05 = 1.5015
    Last edited by Giseldah; May 24 2014 at 08:48 AM.

  6. #6
    Join Date
    Jul 2011
    Posts
    752
    Special version:

    This version uses the new rating factors which are now on BR (see https://www.lotro.com/forums/showthr...60#post7121760) for the 'new' set 1 in the spreadsheet.
    So if you keep set 1 & 2 the same then you can see the results of the rating cuts compared to current.

    Nothing else changed in this version. Note: I didn't check any formulas on BR.
    Last edited by Giseldah; Aug 14 2014 at 02:05 AM.

  7. #7
    Join Date
    Jul 2011
    Posts
    752
    Quote Originally Posted by Giseldah View Post
    Special version:

    This version uses the new rating factors which are now on BR (see https://www.lotro.com/forums/showthr...60#post7121760) for the 'new' set 1 in the spreadsheet.
    So if you keep set 1 & 2 the same then you can see the results of the rating cuts compared to current.

    Nothing else changed in this version. Note: I didn't check any formulas on BR.
    I updated the special version to reflect to latest changes on BR concerning mitigations. See https://www.lotro.com/forums/showthr...97#post7126297
    Last edited by Giseldah; Aug 14 2014 at 02:05 AM.

  8. #8
    Join Date
    Jul 2011
    Posts
    752
    Quote Originally Posted by Giseldah View Post
    Special version:

    This version uses the new rating factors which are now on BR (see https://www.lotro.com/forums/showthr...60#post7121760) for the 'new' set 1 in the spreadsheet.
    So if you keep set 1 & 2 the same then you can see the results of the rating cuts compared to current.

    Nothing else changed in this version. Note: I didn't check any formulas on BR.
    I've updated special version again, now to show the added results of the virtue changes (only for set 1 again) on BR. see https://www.lotro.com/forums/showthr...47#post7131447
    Last edited by Giseldah; Aug 14 2014 at 02:06 AM.

  9. #9
    Join Date
    Jul 2011
    Posts
    752
    Special version is up to date with last update 13 on BR - p5.

    Notes:

    1) Starting with update 13, some mysterious rounding errors(?) are introduced which seem to happen for offense stats. For example, now if you add up all Finesse displayed on your items then chance is that it's not the same as displayed in your stat panel inside the game. I have seen differences of 1-3 points.
    2) Some small changes happened to various items. These are not in adjusted in the included item tabs yet. Some changes that I have seen on items(lvl95): 76fate->77fate, higher finesse +1-1.5%.

  10. #10
    Join Date
    Jul 2011
    Posts
    752
    New version 2.3:
    - many changes for update 13. initial release.

    Complies with update 13, afaik with calculations. I need to check things like stats on food.
    Last edited by Giseldah; May 24 2014 at 08:49 AM.

  11. #11
    Join Date
    Jul 2011
    Posts
    752
    New version 2.3.1:
    - lots of items adjusted for update 13. for instance, almost all food was changed
    - added a lot of new Fangorn items, including golden Onodrim armour pieces.
    Last edited by Giseldah; May 24 2014 at 08:49 AM.

  12. #12
    Join Date
    May 2012
    Location
    Germany
    Posts
    80
    Thanks for your work! This is very useful!

  13. #13
    Join Date
    Jul 2011
    Posts
    752
    Quote Originally Posted by Martinuil View Post
    Thanks for your work! This is very useful!
    Thank you.

    Indeed, I've used it a lot again recently (like after every update) in update 13 to re-adjust my mitigations and BPE to certain levels.
    I figured out that for my cappy switching some virtues to Innocence and Mercy + ..Device of Protection relics were my main solution by only calculating it with the spreadsheet.

  14. #14
    Join Date
    Jul 2011
    Posts
    752
    New version 2.3.2:
    - made changes to support Warden: different formula for critical defense passive skill + adjusted class definition + complete base table
    Last edited by Giseldah; May 24 2014 at 08:50 AM.

  15. #15
    Join Date
    Jul 2011
    Posts
    752
    Version 2.3.3:
    - support for player level extended to 105 by extrapolation of basetables
    - fixed minstrel Tale of Tales finesse rating bonus in Dissonance stance (changed in U13)
    - added on-level information about maximum ratings/percentages for Critical Hit, BPE and Mitigations

    Edit: New version 2.3.4:
    - adjusted caps and information at lower levels for Critical Hit and BPE + added some notes

    Hi. You have a chance now to play with character levels up to 105.
    I also added some information lines about maximums which are very useful I think. These are always valid for the entered character levels, even above 95 if nothing changes..
    If you don't need them then you can just remove them.

    Last edited by Giseldah; Jun 04 2014 at 04:42 PM.

  16. #16
    Join Date
    Jul 2011
    Posts
    752
    New version 2.3.5:
    - added mitigation percentage/rating for Orc-craft/Fell-wrought damage
    - added Lore-master fs pet buff Shield of the Raven's Wing
    Last edited by Giseldah; Aug 14 2014 at 02:06 AM.

  17. #17
    You should create a web application for this (webpage). Also put in crafting calculators too.
    This space intentionally left blank

  18. #18
    Join Date
    Jul 2011
    Posts
    752
    Quote Originally Posted by selltekk View Post
    You should create a web application for this (webpage). Also put in crafting calculators too.
    Well, it's very easy to use when you have a google account. Just make a copy to your googledrive, which is a cloud kind of thing.. you can go to it with your browser from anywhere without the need to install anything.
    I don't have the knowledge to create a complicated web something. If anyone wants to do that then it's fine by me when things are used from the spreadsheet, but I don't want to go in that direction.

  19. #19
    Join Date
    Jul 2011
    Posts
    752
    Busy with U14, preparing scalable items. Finished essences lvl100.



    Need to figure out armour.
    Last edited by Giseldah; Jun 15 2014 at 08:03 AM.

  20. #20
    Join Date
    Jun 2009
    Location
    UK
    Posts
    1,468
    Quote Originally Posted by Giseldah View Post
    Busy with U14, preparing scalable items. Finished essences lvl100.



    Need to figure out armour.
    Most of the armour seems to be place-holders at the moment, so I wouldn't worry too much at this point. Also things are likely to change before going live That's why Tulkas doesn't usually get updated until after - it's too much work to keep updating stats on items with each build. That being said, I have added all the essences, but mainly because there are over 300 of them and it's an entire new system which I need to integrate.
    Galuhad | Narvelan
    Lore Breakers of Evernight (formally of Eldar) | Plugins

  21. #21
    Join Date
    Jul 2011
    Posts
    752
    Quote Originally Posted by Galuhad View Post
    Most of the armour seems to be place-holders at the moment, so I wouldn't worry too much at this point. Also things are likely to change before going live That's why Tulkas doesn't usually get updated until after - it's too much work to keep updating stats on items with each build. That being said, I have added all the essences, but mainly because there are over 300 of them and it's an entire new system which I need to integrate.
    Point of the scalable items in the picture is that I don't need to enter that many items. In fact, the rare items ilvl 192 were mainly copy/paste with the ilvl changed. They are there for convenience only and appearance.

  22. #22
    Wow, awesome, thanks. I always wanted something like this.

    I'm a much more casual player now than I used to be, sometimes taking months off. After I get back, I generally can't remember a thing about what gear or stats I might need next. This will help a lot.

  23. #23
    Join Date
    Jul 2011
    Posts
    752
    oops what happened?



    aha something became a little overpowered. need to be careful with entering those itemlevels xD




    Quote Originally Posted by Geldeger View Post
    Wow, awesome, thanks. I always wanted something like this.

    I'm a much more casual player now than I used to be, sometimes taking months off. After I get back, I generally can't remember a thing about what gear or stats I might need next. This will help a lot.
    yw. I hope it will be useful.

  24. #24
    Join Date
    Feb 2011
    Location
    Argentina
    Posts
    282
    Hi stat master... your old stat thread got closed

    Lotro Players News (ep52: http://lotroplayers.mymiddleearth.co...oman-dyslexia/)
    were discussing DMG and DPS and I remembered your detailed breakdown of the new mitigations and I was thinking if anyone knew how the DPS and DMG is calculated in game you would probably be the person to contact...

    A funky formula would be greatly appreciated...

    LOL all the best with the great spreadsheet
    WINDFOLA: Tsuhelm Hunter lv62 LANDROVAL: Tsudryt Captain lv62 LAURELIN: Opopa Burgler lv22 WITHYWINDLE: Tsukuld Rune-keeper lv85

    WP blog: Tsuhelm

  25. #25
    Join Date
    Jul 2011
    Posts
    752
    Quote Originally Posted by tsunamimc View Post
    Hi stat master... your old stat thread got closed

    Lotro Players News (ep52: http://lotroplayers.mymiddleearth.co...oman-dyslexia/)
    were discussing DMG and DPS and I remembered your detailed breakdown of the new mitigations and I was thinking if anyone knew how the DPS and DMG is calculated in game you would probably be the person to contact...

    A funky formula would be greatly appreciated...

    LOL all the best with the great spreadsheet
    Lol I didn't dare to venture in that direction yet. For now only stats and rating/percentages which is in the scope of the spreadsheet.

    At the moment I'm very busy with calculations of stats on items from iLevels. It's a big job, especially armour which have relations, but didn't discover anything matching, so I have to examine every type individually.

    Today I found a perfect match (so far) for main stats on items which is separated in a graph of 4 segments with each having a higher rising slope.

    Last edited by Giseldah; Jun 25 2014 at 06:02 PM.

 

 
Page 1 of 23 1 2 3 4 5 11 ... LastLast

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