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