I have to admit that I'm largely interested in your work as a source of data for my precious! MY PRECIOUSSS!!!!
Er... I mean the combat sim
Too bad I didn't include ID number support in the combat sim from day 1 or the data files would be much more compatible with Dominions and your mod maker.
By the way, I came up with a nice formula for you
This one rips "Fire Resistance" data from the "Special Abilities" column into a new column you make (just enter the forumla in a new column called "Fire Resistance" in Sunray's excel sheet and drag it down). It's easy to modify for the other resistances, of course...
=IF(SUBSTITUTE(Q10, "rF(100)", "")<>Q10,"100","")&IF(SUBSTITUTE(Q10, "rF(75)", "")<>Q10,"75","")&IF(SUBSTITUTE(Q10, "rF(50)", "")<>Q10,"50","")&IF(SUBSTITUTE(Q10, "rF(25)", "")<>Q10,"25","")&IF(SUBSTITUTE(Q10, "rF(-50)", "")<>Q10,"-50","")
...and for special abilities like "flight":
=IF(SUBSTITUTE(Q10, "fly", "")<>Q10,"1","")
or
=IF(SUBSTITUTE(Q10, "fly", "")<>Q10,"Flier","")
Too bad Excel formulas don't support substrings and "CONTAINS", it makes things confusing... so I couldn't figure out how to deal with variable numbers. But I hope that helps anyway=)
P.S. Forgot to mention... looks great so far! Good work!
[ March 13, 2004, 06:05: Message edited by: Saber Cherry ]