Arena Score Estimator, a spreadsheet!
I've seen a lot of posts concerning arena scoring and confusion on how it works, so I thought I'd share something I recently created for myself. UPDATED: Hares at the Fair
THE SPREADSHEET
(Make sure to go to FILE > MAKE A COPY to edit the sheet for yourself!)
Once I got tired of not getting to Tier 20 and getting serious about increasing my arena score, I made (a much more simple) spreadsheet to see at a glance how units affected my score.
The formulas used in this sheet were not created by me! You can thank /u/patoente and his team on /r/OrderOfHeroes for all their hard work. /u/articsilverfox even created a webpage version here if you'd rather use that instead. I will continue to update this spreadsheet, so feel free to choose whichever is easiest for you.
HOW TO USE:
- Make sure you saved the spreadsheet as a copy first!
- Start with picking the unit's name from the drop-down box in each slot. The weapon/movement icons should update to reflect that.
- You can then change boon and bane, merges, rarity, summoner support, etc.
- The skill drop-down boxes should contain only skills that hero would be able to inherit. The SP costs should update as well.
WHAT MAKES MY SCORE?
- A Base Stat Total, excluding skills, weapons, blessings, and merges
- Rarity and Levels
- Skill Point costs, including Sacred Seals
- Merges
- Blessings, assuming appropriate season and Legendary Hero in team
If you'd like a more in-depth look at exactly how the formula is made, definitely check out /u/patoente's explanation.
IMPROVEMENTS
Is there anything else you'd like to be added or changed? I, personally, think there should be some kind of method to save individual unit builds so they can be swapped around on the fly. This, however, is currently outside of my expertise... But, I'm looking into it!
I want to thank /u/Pegasnow as without their awesome Unit Planner Spreadsheet, this spreadsheet would be a lot more boring. I originally designed it with the user inputting their unit's stats manually and picking from a list of skills. A friend suggested to make it more user-friendly and automatic, so I used the Unit Planner Spreadsheet as a base with it's base stat-calc formulas and whatnot. I certainly learned a lot, so thanks again, and check out their sheet if you haven't already.
If you have any bugs, questions, or suggestions, comment here or PM me.