http://www.verve-fanworks.com/SMF/index.php?action=dlattach;topic=291.0;attach=781
I'm trying to write a bunch of formulas that will generate entries in the data tab of this spreadsheet, using info from the data_dec tab. Specifically stat bonuses granted by equipment.
0x02 : Determines the amount of stat boost an item grants, in conjuction with byte 03. Bit 7 (80) determines which species recieves the stat boosts.
00-7F = Mecs
80-FF = Humans/Monsters/Mystics
0x03 : Determines which stats get boost via bit toggle. Amount of boost is determined by previous byte.
00 = none
01 = str
02 = qui
04 = int
08 = wil
10 = psy
20 = vit
40 = cha
80 = hp [values from byte 02 are multiplied by 5, and for humans, mystics, and monsters it only shows up in battle]
0x04 : Determines the amount of stat boost an item grants, in conjuction with byte 05. Bit 7 (80) determines which species recieves the stat boosts.
00-7F = Mecs
80-FF = Humans/Monsters/Mystics
0x05 : Determines which stats get boost via bit toggle. Amount of boost is determined by previous byte.
00 = none
01 = str
02 = qui
04 = int
08 = wil
10 = psy
20 = vit
40 = cha
80 = hp [values from byte 04 are multiplied by 5, and for humans, mystics, and monsters it only shows up in battle]
I have 16 colums, each which needs a different formula. Every time I try to think of a formula, I get confused, because there are so many things that must be done I can't keep them all in my head at once. I'm not sure if the species getting the bonus should go first, or the stat getting the bonus, or the amount of the bonus. This is way beyond me, so could someone walk me through it?