LotroPlan - calculate stats & plan upgrades

[Giseldah]

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

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.14 (for U25):
Most stats should be up-to-date.

Version 3.15 (for U25.1):
- Beorning/Champion stat contributions.
- ICMR/NCMR progression change (more in line with vitality now).

Version 3.16.2 (for U25.4):
- U25.4 adjustments
- Solves a bug which caused old trait/skill stats to scale to above lvl130.
- Solves unknown function Regex in OpenOffice

Version 3.17:
- Fixes virtue ranks > 68

Version 3.18 (for U28.2):
- New LI titles+values
- Adjustment of MP buffs (audacity and battlefield promotion)
- Added some item set bonuses.
- Calculation fix to implement Might stat bug (new in game since U28.2).

New version 3.19 (for U28.2.2):
- Fixes Mastery and Mitigation LI title stats

Spreadsheet download link: LotroPlan 3.19
Items database: LotroPlan U28.2.1 itemsdb

Data/development resources:
CalcStat - https://www.lotrointerface.com/downl...-CalcStat.html

[JRAD65]

bump........

[Giseldah]

New version 2.2.1:
- adds high mastery rating % calculation. see https://www.lotro.com/forums/showthr...97#post7080097

[Giseldah]

New version 2.2.3:
- changed formulas for block, parry & evade (changed in upgrade 12.2)

[Giseldah]

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

[Giseldah]

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.

[Giseldah]

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

[Giseldah]

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

[Giseldah]

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%.

[Giseldah]

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.

[Giseldah]

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.

[Martinuil]

Thanks for your work! This is very useful!

[Giseldah]

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.

[Giseldah]

New version 2.3.2:
- made changes to support Warden: different formula for critical defense passive skill + adjusted class definition + complete base table

[Giseldah]

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.

[Giseldah]

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

[selltekk]

You should create a web application for this (webpage). Also put in crafting calculators too.

[Giseldah]

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.

[Giseldah]

Busy with U14, preparing scalable items. Finished essences lvl100.



Need to figure out armour.

[Galuhad]

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.

[Giseldah]

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.

[Geldeger]

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.

[Giseldah]

oops what happened?



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

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.

[tsunamimc]

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

[Giseldah]

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.