FE6 Average Stats Hacking Spreadsheet

[TheToad]

FE6 Average Stats Hacking Spreadsheet

Here's a spreadsheet I made that greatly facilitates hacking character stats in FE6. I basically made a database of bases, growths, promotion gains and caps for all 54 characters in the game, and used that data to be able to automatically generate codes for a unit's stats that can be directly copied into VBA's codebreaker.

In essence, all you need to do is input a unit's level, promoted level, experience, con bonus and move bonus, and the suitable codes adapt accordingly. For now the spreadsheet outputs a unit's average stats and maximum stats for the level you choose.

That may seem a bit confusing, so I'll do my best to explain how one would go about applying this spreadsheet.

Suppose you want to hack Dieck's stats. First you open up the workbook for Dieck in the spreadsheet. It should be workbook 12, as all names after Roy are in alphabetical order.

(Note: Sorry about the text being hard to read, but I reduced the size of the image in an effort to not stretch the page)

I have Dieck's level defaulting at 5/1 since Dieck starts at lv 5/0, and promotes to lv 1. Also note that there there are 4 different columns from which to choose codes: Average stats no promo, average stats promo, max stats no promo, max stats promo. It's pretty self-explanatory, if you're hacking your unit to be unpromoted, say lv 18/0, use one of the no promo columns. If you want to find out the maximum stats a unit could possibly have at 20/5, use the max stats promo column.

So let's suppose you want Dieck to be lv 18/7 (ie he uses a knight's crest at lv 18 and reaches level 7 promoted). You also want to give him 32 exp, and 2 con bonus. Make the suitable inputs in the green boxes, and you should get the following:

Finally, suppose we want the codes for Dieck's 18/7 average stats. In this case we'd copy the codes in the 2nd column (highlighted in a red box below).

Now open up FE6 in visual boy advance, and put Dieck in slot 2 in the unit preparations screen.

If you're hacking anyone other than Roy, they have to be in unit slot 2 in order for the codes to work. Now access cheats -> view cheats list in the toolbar and paste the codes into codebreaker (shown in detail in the screens below).

And just like that, Dieck should be instantly transformed into a level 7.32 hero.

At this point you can remove the codes, and the effects of the code will remain, at which point you can make a savestate or save the game to make the change permanent.

What's also cool about these codes is you can do things like turning Merlinus into the Dieck I just showed by putting Merlinus in slot 2 and using the very same codes.

==========

Applications

==========

There's a lot you can do with these codes. For instance, with a chapter select code (input 3202AA56 00## and replace ## with the chapter's hexadecimal value in the save screen after finishing a chapter) you can basically hack up a team of choice for any chapter you feel like playing. Imagine booting up a fresh game, then suddenly being able to hack your way to C14 (the desert map) with a bunch of promoted magic users, or increase Wendy and Sophia's base level to make them more usable. There's a lot of fun you can have with random challenges that no longer require hours of playing to set up.

Another application is in debating. The spreadsheet itself will automatically generate a unit's average stats properly rounded, so it saves from having to look up averages. Moreover, if you want to see for yourself how well a 15/10 Lot fares lategame, you can easily test it out without having to play 3/4ths of the game.

Well, that's it for now. I might add some more features, such as making a database for weapons, weapon levels and supports, but I might need some programming help with that, since I'm not sure how to get excel to recognize a string like "iron lance" and convert it into a hex value like "0006". There's likely to be some errors here and there since entering all this data into excel was incredibly tedious. Nonetheless I tried out the codes in the latest random, pointless video I made (shown below) and they seem to work like a charm :)

http://www.youtube.com/watch?v=PpVneiwubLw