28 replies to this topic

[Raven]

If you haven't got Microsoft Excel, or some equivalent that will have Microsoft Excel documents work, then I advise you to get one.

I've assembled a table with several hundred equations. It will automatically work out all averages for every level by simply inputting your base stats, growth rates and promotion gains. By inserting your promoted class's caps, it is also capable of telling you how much below or above the cap the average Lv20 promoted stats are.


Unpromoted
Unpromoted classes are to fill in the following fields highlighted in red:


Important:
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
Pre-promoted classes are to fill in the following fields highlighted in red:


Important:
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
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.

Promo Gains
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
Growths to be edited by both Unpromoted and Pre-promoted units. Insert your stat growths here.

Stat Caps
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 Difference
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
https://docs.google.com/open?id=0BzoOx0uNIm7AdVFrckg4b0tWX0E
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.
Thanks.

Edited by Raven, 25 December 2012 - 08:16 AM.

[Ether]

one quick question,Is it mandatory to do all of this?If so,must we use the calculator,I can calculate my character's 20/20 averages pretty easily on my own,and give the differences if you need them.

Edited by Ethereal Hero, 23 December 2008 - 07:59 AM.

[Nightmare]

It's just a handy thing to have when you want to work out your stats fast and easy. Pretty useful, I'd say, without all the extra work of calculating. With this, everybody should be able to come up with their own stats.

[Ether]

I understand the concept,but my computer is slow enough already without having to download more programs,if you want my stats,I'll work them out myself and post them/Pm them to someone.

[Nightmare]

If you're capable of making them without any extra help, then there's no need for this.

And you should PM your stats to Fireman when you're done with them.

[Ether]

Ok then I'll start on them,do you want every level or just 20/20 stats?

[Nightmare]

Just give us your base stats and growths. Everything else is unneeded.

[Ether]

Fireman has those already...

[Nightmare]

Alright then, you've nothing to worry about.

This Excel calculator that Raven has put up is just for people looking for an easy and fast way to calculate their stats and growths and see if they are to their liking. Nothing more than that, and averages are certainly unneeded for us. We will just be inserting your bases and growths, anyway.

[Ether]

Oh...figures I did my averages already...oh well,not too bad,atleast now I know that unless some sort of major flaw shows up,I should atleast be a decent character.

[Raven]

If you already have Microsoft Excel, then you have nothing to worry about. The download is just a save file that opens in Excel. 13Kb in size.

[Raven]

Updated -
Two downloads now available - one for Office 2007, another for Office 1997 - 2003. Enjoy. Also, any and all feedback's welcome, even if it is just to let me know who's using it. [b]/b]D

Edited by Raven, 24 December 2008 - 12:31 PM.

[Arch]

Excellent work Raven. I could probably find a million uses for this tool.

[Nintenlord]

As a aspiring mathematician, I have to say this: This isn't average stat counter, it's mode(sorry if the name is wrong, I study math in Finnish) counter. Mode is the stat with the highest chance of happening, average is the stat where the chance of getting a lower value is the same as getting a higher value.

[Raven]

As a aspiring mathematician, I have to say this: This isn't average stat counter, it's mode(sorry if the name is wrong, I study math in Finnish) counter. Mode is the stat with the highest chance of happening, average is the stat where the chance of getting a lower value is the same as getting a higher value.

Point taken. As a failed A level mathematician, I should have remembered that, at least. But I will keep it as "Average" in the title because it gives the same results as what the main site gives on existing FE characters.

[Tino]

What you're referring to are the so-called "simple" averages. Or in other words, the mode. The average is the point where 50% of the time the stat will be below it, the other 50% of the time the stat will be above it.

[Raven]

For those who are being urged to work on your character's stats, I'd like to ask you to give this a try, if you don't mind. It would make the job of working out your own stats alot easier on yourself.

Feedback and questions welcome, as usual.

[Bohemund]

OMG, this is awesome to play with. Nice job setting it all up.

[Kiba]

I let you handle the boring jobs, gl with everything

[Raven]

Moved topic from "Serenes Emblem" forum to "ROM Hacking" forum for wider coverage. As normal, any problems - let me know.