I've assembled a table with several
Unpromoted classes are to fill in the following fields highlighted in red:
I realise there will be some units who may cap a stat or two while unpromoted, but I don't think I am able to create a "cap" of sorts, and so it keeps on going above the 20 cap that is supposed to be there. It's got to stay at 20 until the unit promotes. Check Guy's Speed stat for an example of what I mean. To fix this, if any of the following stats: strength/magic, skill, speed, defense and resistance, reach 20 or above before getting to Lv20, do the following:
Replace the Lv20 equation for the stat(s) that has reached 20 or above, with 20. This will fix this slight problem. As long as the Lv20 of that stat is 20, it will continue to work as it should. Don't worry about deleting and replacing the equation in this situation.
Do not edit/delete any of the equations, unless it's been said you can.
Pre-promoted classes are to fill in the following fields highlighted in red:
You are to leave all stats under "Base Stats" and "Promo Gains" as 0.
Remember to delete the equations used in the fields under "Promoted Base Stats". This is so that unpromoted and pre-promoted stats are totally cut off from eachother. This will result in the top half of the table being all 0's, but that doesn't matter.
Base stats to be edited by Unpromoted units only. After assembling your base stats using the FE7 class base stats data and the bonus points given, insert them here. Remember that Luck is initially 0, so your bonus points must be used if you want your bases to have some luck.
Promotion gains to be edited by Unpromoted units only. This one's simple: Just go to the FE7 Promo Gains, find the class you promote to, then insert the relevant information here. Remember that Luck doesn't rise at all during promotion.
Growths to be edited by both Unpromoted and Pre-promoted units. Insert your stat growths here.
Stat caps to be used by both Unpromoted and Pre-promoted units. Insert your Promoted Class's FE7 Stat Caps.
Promoted Base Stats
Promoted Base Stats to be viewed by both Unpromoted and Pre-promoted units, but edited by Pre-promoted units only. Basically this is your Lv1 stats for your promoted class. For Unpromoted units, this is based off the Base stats, Growths, and Promo gains. So don't touch.
Pre-promoted units are to delete the equations here, and replace them with their base stats, based off the FE7 pre-promoted unit bases and the bonus points given.
Promoted Lv20 Stats
Promoted Lv20 Stats are to be viewed by both Unpromoted and Pre-promoted units, but not to be edited at all. This is the average stats for your unit at 20/20 or --/20, for unpromoted and pre-promoted units, respectively.
Cap/Lv20 Differences are to be viewed by both Unpromoted and Pre-promoted units, but not to be edited at all. This shows the difference between your unit's caps and the average stats, and it tells you how much under or over that stat is to the cap. If it's red and in the minus, it means the average of that stat is below the cap by however much is shown. If it's black and positive, then the average is over the cap by however much is shown.
Obtaining the Excel Calculator
Click on the arrow on the left, next to the printer icon in the grey tab, to download.
If you notice any mistakes in either this post or the Excel Calculator I've assembled, post them here in this thread.
The same goes for any suggestions on how I can improve it.
Edited by Raven, 25 December 2012 - 08:16 AM.