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

    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.1):


    And here the calculated stats section (version 3.1):


    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.

    New in version 3.1 the selection of essences by dropdown list:


    New in version 3.1 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.


    With current version 3.1 it 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) up to 105
    4) Includes (but certainly not all) jewelry, armour, essences, legendary items, all food, scrolls, perks
    5) Buff/Debuf section: captain's IDOME aura, motivation, hope/dread, minstrel's Tale of Tales aura
    6) Stat tomes
    7) Virtues section (what would my stats be with rank19 in...)

    See below for a link to the spreadsheet document. It's avaliable in OpenDocument Spreadsheet (ODS) AND Microsoft Excel Macro-Enabled format(XLSM). If you don't have a spreadsheet application yet: Apache OpenOffice is free downloadable.

    Enjoy.

    Version 2.2.1:
    - adds high mastery rating % calculation. see https://www.lotro.com/forums/showthr...97#post7080097
    Version 2.2.2:
    - added a lot of base values for classes. everything complete except for warden (I don't have it unlocked)
    Version 2.2.3:
    - changed formulas for block, parry & evade (changed in upgrade 12.2)
    Version 2.2.4:
    - some formulas adjusted again. nothing shocking.
    Version 2.3:
    - many changes for update 13. initial release.
    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.
    Version 2.3.2:
    - made changes to support Warden: different formula for critdef passive skill + adjusted class definition + complete base table
    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
    Version 2.3.4:
    - adjusted caps and information at lower levels for Critical Hit and BPE + added some notes
    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
    Version 3.0 pre14:
    - only OpenOffice version
    - new dynamic calculation of item stats based on itemlevel
    - U14 changes:
    -- All essences included. All levels supported thanks to dynamic calculation.
    -- All lvl95/100 Nadhin socket armour items, all new lvl100 class armour sets. Lots of lvl100 jewelry.
    -- Virtue ranks 19.
    Version 3.0:
    - see pre14
    - maximum avoidance percentages (BPE) back to 25%.
    - added extra line with BPE ratings for 10, 17 or 20% depending on character level
    - adjusted critical ratings in relics
    Version 3.01:
    - adjusted calculation of mastery(damage) percentage. graph was slightly changed and simplified. rating to percentage conversion now supported for > 100k rating (or any amount)
    - added rating/% information for partial BPE cap, devastate crit cap and partial BPE mitigation cap (all accurate for any specified character level as usual).
    - added new drop set items as far as my information goes. includes support for set bonuses
    Version 3.02:
    - made a Microsoft Excel version
    - adjustment of some armour values
    - adjusted captain HD jewelry
    - fixed a bug in partial avoid mitigation information

    New version 3.1:
    - single sheet/tab per character build allows multiple builds in the same spreadsheet and comparison between any.
    - reworked all formulas which were messy because of conversions and also for the new layouts.
    - new virtue section with 'wiki' table
    - selection boxes for essences

    OpenOffice: https://drive.google.com/file/d/0B0L...it?usp=sharing
    Microsoft Excel: https://drive.google.com/file/d/0B0L...it?usp=sharing
    Last edited by Giseldah; Sep 14 2014 at 02:52 AM.

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

  3. #3
    Join Date
    Jul 2011
    Posts
    188
    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 07:47 AM.

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

  5. #5
    Join Date
    Jul 2011
    Posts
    188
    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 07:48 AM.

  6. #6
    Join Date
    Jul 2011
    Posts
    188
    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 01:05 AM.

  7. #7
    Join Date
    Jul 2011
    Posts
    188
    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 01:05 AM.

  8. #8
    Join Date
    Jul 2011
    Posts
    188
    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 01:06 AM.

  9. #9
    Join Date
    Jul 2011
    Posts
    188
    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
    188
    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 07:49 AM.

  11. #11
    Join Date
    Jul 2011
    Posts
    188
    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 07:49 AM.

  12. #12
    Thanks for your work! This is very useful!

  13. #13
    Join Date
    Jul 2011
    Posts
    188
    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
    188
    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 07:50 AM.

  15. #15
    Join Date
    Jul 2011
    Posts
    188
    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 03:42 PM.

  16. #16
    Join Date
    Jul 2011
    Posts
    188
    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 01: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
    188
    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
    188
    Busy with U14, preparing scalable items. Finished essences lvl100.



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

  20. #20
    Join Date
    Jun 2009
    Location
    UK
    Posts
    1,450
    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 Eldar


    Extra Life Challenge | Plugins | New Player Guide | Twitter | Twitch

  21. #21
    Join Date
    Jul 2011
    Posts
    188
    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
    188
    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
    262
    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 lv61 LAURELIN: Opopa Burgler lv18 WITHYWINDLE: Tsukuld Rune-keeper lv68

    WP blog: Tsuhelm

  25. #25
    Join Date
    Jul 2011
    Posts
    188
    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 05:02 PM.

 

 
Page 1 of 3 1 2 3 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