MarkyJoe1990 Posted December 11, 2012 Share Posted December 11, 2012 (edited) There used to be a Microsoft Excel file that you could use to calculate average stats, but every time I try to download it, I get redirected to the main page of the download site it's hosted on, so I decided to make my own version. Open Office Version! Microsoft Excel Version! Instructions Put in your characters base stats in the "Bases" column, then in the "Growths" column, put their growths. Lastly put in the promotion gains they get in the "Promotion Gains" column. Then you will see their average stats from 1/0, 10/0, 20/0, 10/1, 20/1, 20/10, and 20/20. You can also go to the "Level before Promotion" and "Level after promotion" spot and change the number to their right to see the unit's average stats at specific levels, and when promoted on a specific level, and leveled to a specific level. Changes over the original stat average calculator - Stats are rounded to the nearest whole number rather than displaying the decimals. - More color so it looks nice. - If a stat goes above it's cap, then it's brought down to the cap for accurate stats. - Capped stats are bolded in and colored. - Yellow cells indicate what cells you can edit. Let me know what other features you'd like and I'll put them in. Edited December 11, 2012 by MarkyJoe1990 Quote Link to comment Share on other sites More sharing options...
MarkyJoe1990 Posted December 11, 2012 Author Share Posted December 11, 2012 Updated to include a separate... thingy that allows you to customize the level before and after promotion, so you can now do things like average stats of a 15/15 unit, or 12/19 unit, etc. Quote Link to comment Share on other sites More sharing options...
eCut Posted December 11, 2012 Share Posted December 11, 2012 Updated to include a separate... thingy that allows you to customize the level before and after promotion, so you can now do things like average stats of a 15/15 unit, or 12/19 unit, etc. Ooh, that's quite an interesting feature. :o Quote Link to comment Share on other sites More sharing options...
MarkyJoe1990 Posted December 11, 2012 Author Share Posted December 11, 2012 (edited) Updated to look better, and to fix the new "Choose your level" feature so that the stats can't go over the cap. The yellow cells are what you are allowed to edit. Edited December 11, 2012 by MarkyJoe1990 Quote Link to comment Share on other sites More sharing options...
MarkyJoe1990 Posted January 26, 2014 Author Share Posted January 26, 2014 (edited) I've updated the sheet to be more concise and precise. Hope it helps. Edited January 26, 2014 by MarkyJoe1990 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.