Utility: Code diving - 3.10 list of sites and spells

[Edi]

Actually, you didn't. Doesn't matter, I can easily work with this since I've got most of the things down, the things I don't wil stick out like a sore thumb.

[Edi]

Aaaaand it's done! Sites have been fully updated with terrain masks, levels and specials! Thank you, DrPraetorious!

[DrPraetorious]

I must've uploaded the wrong attachment or failed to overwrite it or something, but if it's not a problem it's not a problem.

I'm perfectly happy to make the spell-list nice myself, but do not know how to do it. Can you suggest a tutorial on how to make dependent sheets and list lookups as is done in the main guidebook? It's a useful thing for me to know anyway.

[Edi]

The spell list as such seems just fine, I can actually read most of it fairly well. In order to make the thing more readable, to create the kind of display pages the Dom3 DB has for units, you actually need to have the whole main page roughly as it is right now. Basically, that's your BaseS page.

Then you need a separate page which lists Effects, which would be BaseE, a list of Powers, which would be BaseP and possibly also a list of Arguments, which would be BaseA, but that depends on whether the argument values are fixed. I know there are some effect lists lying around, which could help in this.

Once you have all of that together, all you need for the display page is list the spell numbers in the ID column and everything else is retrieved from the Base tables by VLOOKUP functions. Some of those might even need to be conditional, but I don't think so, not in the same way they are in the unit DB. This project would be big enough that it'd need to be a separate document, so it could be called Dom3 Spell DB, I guess. If anyone can get me a half-decent list of the basic effects, just copying the id# and name columns from the BaseU, BaseW and BaseA tables of Dom3DB would give me enough to work with to get a rudimentary legible spell DB ready at a pretty short notice.