Modding Tool Beta Test and a Plea for Help

[Saber Cherry]

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 ]