Dom 3 DB: Units, Weapons, Armor

Edi · #1 February 23rd, 2007, 07:59 AM

The full unit list is now available.

Attached to this post is the complete list of all existing units in the game, as well as all weapons and all armor. The file has pages for base data of units, weapons and armor, and display pages which reference the data pages to display the units as they really, truly appear in the game.

There are some deficiencies. I do not possess the armor calculation formula, therefore protection values are a direct base protection + body armor value. Seems like I also managed to forget adding earth magic bonus, but tough cookies, I'm not going to go poke at those formulas anymore today. Live with it.

The resource cost is also plonked directly from the game without calculating it because I couldn't be bothered to do enough mod testing to find out what the ressize modifiers are and then start testing different units to see what size they really are for resource cost purposes. Unless by the grace of KO and JK I see the relevant source code, you're not going to get it either.

Another deficiency is that the only display pages actually having data on them are AllUnits and Pretenders. Takes too much time to do the others and at this point I'm bloody sick and tired of the whole DB, so you again just have to live with it. You need national unit reference lists, use Sunray's list and the ArmyList page in this file. It doesn't contain possible summons or reanimation units for the nations and Ashen Empire Ermor is completely missing, but again, I couldn't care less at this point.

The final deficiency is that this file is BIG. It's not just the "Wow, that's a lot of data!" kind of big, it's the "Holy crapola, my machine just went to its knees and keeled over trying to open this thing!" kind of big, because there are a LOT of VLOOKUP function formulas that reference absolutely massive arrays. So if and when you sort it, be prepared for it to take time. If I were to add the other listed pages, the file size would also grow in direct proportion

Display pages hide the formulas, but you can get them visible by unprotecting the sheets. No password, but if you delete any formulas by accident, don't come crying to me. I spent three days constructing them and I do NOT want to look at them again if I can help it.

There. That should be all. Enjoy.

Edi

Jack_Trowell · #2 February 23rd, 2007, 08:12 AM

Yoohooo ! At last, Edi's Unit list !

Thanks Edi !

Boron · #3 February 23rd, 2007, 04:24 PM

Thank you very much Edi and good timing, i just started making a mod, your DB is really helpful for that

.

Edi · #4 February 23rd, 2007, 04:31 PM

Thanks for the compliments, guys.

Boron, you can quicktest your new mod ideas if you save another copy of the DB under a different name and then plug the new numbers into the BaseU, BaseA and BaseW pages. You'll see the instant final results on the unit display page.

Just make sure you enter 0 for FALSE or 1 for TRUE or actually type out the word each time you use them. Dragging the values for several trues in a row will screw things up since it will do a sequence of 1..2..3..4.. and show everything above 0 as TRUE. See also the Tools and Tutorials thread in the map/mod forum for some more instructions. I'd still be correcting those by hand if Kaljamaha hadn't fixed it for me with a handy perl script that took care of the issue.

Edi

Ironhawk · #5 February 23rd, 2007, 05:13 PM

Thanks edi!

Gandalf Parker · #6 February 23rd, 2007, 06:59 PM

Way cool. Especially the "you can test" tidbit you just mentioned. Maybe you could create a tab for "testing" with the formulas and blank fields and instructions for the next edition (just brain farting, dont know if thats easy or not)

Im downloading the new (free open-source) Office Suite so I can make a new webby version of your database and make it available at www.Dom3minions.com/docs

Gandalf Parker