After a year-long hiatus, here's the newest version of my spell-modding guide.
It includes:
Bitmasker.xls - this is a shortcut to help you calculate bitmask for #spec fields, or for the fields associated with some effect #s that take bitmasks in the damage. Also good for custommagic.
HexConvert.pl and howthisworks.txt - In case you feel a crushing need to convert binaries to .csv format. Use with caution.
Spell Effects and Damage Combos.txt - This is a comprehensive list of all of the effect #s and what they do with different damage values. Edi doesn't think this belongs in the mod manual
. I say he is mean.
spells_320_VLOOKUP.xls - Ha ha! It's an .xls file! Kneel before your master, filthy hippies!
This is far from complete. The SPELLS sheet is slowly gaining the kind of functionality that would make it actually useful. For many spells, it may be informative.
The Raw Data sheet has the raw #s associated with each field in each spell record. This *is* quite useful. You can help me write more lookup scripts for these if you want, but for use in spell modding, you can just dump the values in this table (if numeric values are accepted) into the corresponding fields of a custom spell, and usually you will get a duplicate spell.
Very large numbers are actually negative.