Celas's Modified Stats Calculator

[Celas]

http://battle-arena.online/Files/2019.01.17.xls

It's a spreadsheet! I made it in LibreOffice but gave it .xls attachment so anyone should be able to open it with basically any spreadsheet manager. Excel, OpenOffice, LibreOffice... probably Google Docs.

I'll probably post revised versions in the near future, particularly with the Traits changes in the pipeline and the new stats from Tsayikk stuff, but for the moment, just so people have it, we get the one I've got on hand.

Some notes: This sheet contains Celas's equipment for using the full Silver Implements set, which makes it a huge mess, but also helpful for being basically worst-case as far as equipment goes.

Page 1 contains your equipment sheet and your stat values.

Page 2 is for whatever abilities you want to include in your calculations.

It's all manual entry only. It doesn't do any parsing at all. You fill in the name and numbers yourself.

Equipment fields don't care about what type you put in them. Like at all. I still highlighted them for my preferred types (weapons, armor, accessories getting red, green and blue borders respectively, and then the big blob for Extras, initially due to the Jack of Blades Overcrash and the Sun Spheres, but it wound up being really handy and also needing expansion once extra equipment slots became ubiquitous. Whee, tangential irrelevant history lesson!) but you can stick whatever wherever, literally only the number fields matter.

One of the big shortcuts I took was with the abilities summing. So, uh, it treats your abilities as a single piece of gear instead of comparing the cap stat for each entry on the list, simply because it... didn't matter. When i did it, I found that nothing even came close to reaching the cap on it, so I just did the easy method. That's one of the revisions I'll need to make to it, but until it actually winds up mattering it's a low priority.

You might also notice that I've got a spell listed as a piece of equipment! I do that when I'm using one in an action to calculate in the attack bonus.

The "Prime Attribute" and "HP/MP Stat" (Column B) fields accept text arguments! In the sample sheet provided, you'll notice that Defense Stat is set to SPI instead of its default CON, because that's a thing Celas has, but you should probably chance it to CON at your earliest convenience. Column C numbers next to it are for the cap multipliers. So if you've got

Blood Emblem- (Accessory, Broach, Darkness & Blood, 15,500,000 Gold) +15,000 Melee Attack, +15,000 to all stats, 10% Blood Resistance, Wearer's per-item Melee Attack bonus cap becomes 2x the relevant stat

flip that Melee Prime number 2 so, and watch the numbers change! That's the big strength of this thing, calculating your modified values for caps and stat changes on the fly. Try playing around with it!

One final handy toy that I don't have shown off on this particular sheet is that it accepts "Level" as an argument. Have an ability giving you +1 to all Base Stats? Slap =Level*1 in E32 (Uncapped Bonus, All Stats column) and let the sheet do the math for you. Equipping a sword that gives you +(1,000 x Wielder Level) Melee Attack? slap =Level*1000 on the line! ALL GLORY TO THE LAZINESS.

...might try putting the "release version" on GDocs in the future, maybe...