Dominions 3 Database Thread - Dominions 3: The Awakening

The Dominions 3 Database (more commonly abbreviated to Dom3 DB and available from here) is a spreadsheet document that contains information on almost everything in the game except for spells and data related to spell modding.

The file was created as a tool for modding and mapmaking, because lack of accurate lists of units, weapons, armor and their stats and other similar things were originally the main obstacle to modding. The Dom3 DB is an improvement over the older document originally created for Domions 2: The Ascension Wars, which was not as amenable to easy sorting by single attributes.

A word of warning for new players: If you wish to discover the rich and vivid world of Dominions on your own by playing the game, do yourself a favor and do not download this document. It WILL act as a massive spoiler if you do. However, if and when you wish to start making maps and mods of your own, then the Dom3 DB will be a valuable tool for you.

The Dom3 DB document contains

• Units
• Weapons
• Armor
• Forts
• Poptypes
• Magic Sites
• Nation lists
• Army lists for nations
• List of independent units and units recruitable from magic sites
• Summary of Pretender gods (mapping pretender availability for all nations not finished)
• Items (unfinished and subject to a number of inaccuracies)
• Flysprite numbers for weapons
• Sound effect numbers
• Bitmasks for magic path combinations
• Bitmasks for magic sites (terrain)

The Dom3 DB is available as three files:

• The full Dom3 DB, which autocalculates the actual in-game stats for the display page from the base stats of units, weapons and armor. Only available in Open Office format. This file will give even a fairly robust computer a good workout, because the massive number of VLOOKUP functions used takes a good while to run through. If you have an old computer, don't use this version.
• A static version in Open Office format (functions removed, only end result data is shown)
• A static version in Microsoft Excel format (functions removed, only end result data is shown)

The structure of the first file is such that it references base pages with VLOOKUP functions and calculates the actual results for the user's perusal. If you wish to use the Dom3 DB to make a version for a mod of your own, making changes to the base tables will instantly reflect the effects in the display pages. If new units are added, just add the unit numbers to the display page, the actual stats to the base pages and then extend the formulas on the display page and you will have a variant version that can show you everything at a glance.

The latest version of the Dom3 DB at this stage is version 3.26, but as there have been few changes to anything covered by the DB in patches 3.27 and 3.28, the document is accurate enough that it does not need an update at this stage.

If you have feedback or suggestions about the document, feel free to post it here. However, keep in mind that unless new content related to the DB is added to Dominions via patch, it is not going to be actively maintained. This means that minor errors will not cause an updated version to be posted.

Edited by: Edirr

Dom3 DB have an outrageous features over backup and managing data securely..It is truly amazing and VLOOKUP functions is mind blasting..

It's a wonderful utility. Edi did great work.

I agree with what others have posted, this document is amazingly useful for modding.

Public service announcement:

The old location for hosting Dom3 DB will cease to exist in 1 hour and 23 minutes. My ISP is terminating all consumer web hosting services as a cost reduction measure because of very low usage.

The Dom3 DB will henceforth be hosted at the llamaserver, as soon as I manage to upload it there. There was some glitch with the FTP connection just now and I could not log in, so that will have to wait until the problem has been resolved. Thank you for your time.