Peridotz Posted August 28, 2019 Share Posted August 28, 2019 (edited) Hey guys, I made an average stats calculator in Google Sheets after I tried finding one on by searching around but couldn't find one, so I decided to just make my own. Just view the document and go to File -> Make a copy. https://docs.google.com/spreadsheets/d/1DRmkoHpF4FaukKk-AkCOmxESxBZ-v5Q8291jk-d_mdM/edit?usp=sharing Everything you need to know on how to use the calculator is in the spreadsheet by clicking on boxes that have notes on them. This calculator allows you to see every levels' average stats for a unit while taking into account different class's growth rates, class base stats, as well as class bonuses and dismount bonuses. Happy theorycrafting! Edited August 28, 2019 by Peridotz Wrong link whoops Quote Link to comment Share on other sites More sharing options...
LegendOfLoog Posted August 28, 2019 Share Posted August 28, 2019 Looks great. In a game with this much variability, this makes finding interesting paths for the students so much easier. Quote Link to comment Share on other sites More sharing options...
Peridotz Posted August 29, 2019 Author Share Posted August 29, 2019 Thanks! The only thing this calc won't take into account is multiple reclasses at the same level, but I'd assume those are rare. Quote Link to comment Share on other sites More sharing options...
thetiger39 Posted August 29, 2019 Share Posted August 29, 2019 Nice. Would it be possible to account to edit in custom classes and OCs as well? Quote Link to comment Share on other sites More sharing options...
Peridotz Posted August 30, 2019 Author Share Posted August 30, 2019 Yep. Just updated the doc so you can add custom chars and classes. Just make sure you add what you need into every sheet in the document so that the formulas in the calculator work correctly. Quote Link to comment Share on other sites More sharing options...
Cysx Posted August 30, 2019 Share Posted August 30, 2019 Hey, thanks a lot first of all, this is going to save a lot of people a lot of time. Much appreciated:) I've noticed magic classes in advance and above have their Mag class bonus lowered by 1 for some reason, don't know if it's a bug or something. Also it's a bit of a tangent but maybe you have the answer to one of my questions: Why do stat bonuses(as well as caps) cut leftover decimals from growths, for example, a character with an average of 6.5 str at level 10 class changing into a soldier should, in my mind, have an average of 8.5, but we mark it as 8, and I just don't get why. By that reasoning, using a stat booster every two levels would make every growth under 0.5 null, no? And really in general, saying 9 levels of 0.5 will average in 4.0 or 3.5 (with two promotions) in stat gains... I don't know, that's weird to me. Whether you answer this or not, the essential part is the shortest, so again, thank you very much. Quote Link to comment Share on other sites More sharing options...
Altruren Posted September 5, 2020 Share Posted September 5, 2020 Hey, just wanted to say that this is a great tool and I really appreciate you for making it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.