DW2 Cheat Sheet - A reference list of everything - Version 7 (25/7/2025)

[OrnluWolfjarl]

CURRENT VERSION: v7

FOR GAME VERSION 1.3.1.1.01 (Public Beta 23 July 2025)

-----------------------------------------------------------------------------------------------------------------------------------
Contents:

You can get the DW2 Cheat Sheet by downloading ALL files attached below.

You will need 7-Zip File Manager (found here for free) to extract and access them.

Unfortunately, uploading the Cheat Sheet as separate files (as was done in earlier versions) is no longer possible, due to file size limitations of the Matrix Forums.

Therefore, I had to cut the XLSM Cheat Sheet in 2 parts. To join them together you will need to:

1. Download both parts (Part 1 and Part 2)
2. Open them together in Excel
3. Select the Sheets in the tab below by holding Ctrl and then clicking on each one with your mouse (or using Shift and clicking on the first and last sheet to select all)
4. Right-click on your selected sheets (any one)
5. Select to Move
6. In the window that comes up, select the other part in the dropdown menu at the top
7. Select where to move the sheets (the order in which they'll appear)
8. Save the file as one
   
   If you intend to use Macros for importing and validating data, or for formatting, it is essential that you join the 2 parts into 1 file, otherwise they won't work.
   
   If you just want to browse the data, then there's no need to join them.

These are the different files found in the DW2 Cheat Sheet, use whichever one is convenient for you.

• XLSM - Excel 365 sheet (what I work with currently). This file contains VBA code (see info on Functionality above)
• ODS - Open Office sheet. This file contains no VBA code and can be opened with older Excel versions, as well as Open or Libre Office (which are open source and free to download)
• WEB - Can be opened through your browser, no internet connection required. Make sure to extract all files together in the same folder/location and do not change the file names (otherwise it won't work anymore, unless you know what you are doing).
• Google Sheets - Can be opened through your browser, internet connection required. Found here.
  
  Feel free to use, and let me know if you encounter any issues!
  
  Downloads since last update: 1324
  
  -----------------------------------------------------------------------------------------------------------------------------------
  
  Features:
  
  • List of all resources: their IDs and cost (working on expanding the USES of each resource)
  • List of all planets, asteroids and stars: with all their resources, bonuses, sizes, celestial objects in orbit around them, IDs AND their spawn chance and values.
  • How mining works, in detail.
  • List of all Technologies: with all their costs, components/hulls/planetary facilities/bonuses they unlock, races/situations they are specific for, IDs, requirements, research bonuses they benefit from (some need confirmation, which I will do later this week), and their possible paths in case of randomized tech tree
  • List of all Components: with all their stats (across all their versions), costs, types, sizes
  • List of all Planetary Facilities: with all their costs, bonuses they provide, troops they can produce, defensive capabilities, races/situations they are specific for, IDs, requirements, how many can be build per Colony/Empire/Galaxy.
  • List of all Troops: with all their stats, costs, types, sizes, races - (Dhayut Regular Infantry not included yet)
  • List of all Races: with their habitability, biases towards other races, governments allowed (if playable), characteristics, unique technologies/components/planetary facilities, starting research, preferred components (if AI) special features (Aurora DLC only), troops and victory conditions - (Hulls will be filled in next version)
  • List of all Governments: with their political system, stability, biases towards other governments, diplomatic outlook, bonuses they provide, starting events and additional features (Aurora DLC only)
  • List of all Artifacts: with the bonuses they apply, governments they unlock, techs they unlock or complete, and requirements for the bonuses to apply
  • List of all Hulls: with all their costs, bonuses they have, defensive capabilities, component bays (with sizes and rotation arcs), technologies required to unlock them, races they are specific to, hull size, max size and available space.
  • NEW! - List of all Space Monsters (titled Creatures): with all their stats, reproduction rates, resources dropped on death and prevalence in the galaxy
  • NEW! - List of all Diseases and Plagues: with all their effects on colonies, chance to happen, chance to spread (for plagues) and plague curing against each one (for plagues)
  • Hulls Overview: a more compact list, which gives each hull in a single row with its important information, and where hulls are grouped by race and role.
  • Components Overview: a more compact list, which gives each component in a single row with its important information.
  • Components Overviews by Type: each component group has received its own compact list, with ALL its information and attributes
  -----------------------------------------------------------------------------------------------------------------------------------
  
  Functionality features (Macros):
  
  The following functionalities can possibly only work in Excel 365 or earlier Excel versions.
  
  Most of them also require VBA to be enabled. To enable VBA, see the Manual document uploaded with the other files.
• Can import specific XML files from the game data folder and display their information in Excel
• Can use the imported information to validate data in your own Cheat Sheet
• Can format your Cheat Sheet after adding new data to keep it nice and functional
• Can create Overview tables for Hulls & Components, for easier viewing and comparison.
• Can filter HULL OVERVIEWS by Name, Race, Type and Role for easier viewing (does not require VBA)
• Can filter COMPONENT OVERVIEWS by Name, Version, Type and Group for easier viewing (does not require VBA)
  
  -----------------------------------------------------------------------------------------------------------------------------------
  
  PREVIOUS UPDATES - DETAILS FOUND IN SEPARATE COMMENTS BELOW
  
  UPDATE 1 - April 3rd, 2022
  UPDATE 2 - April 22nd, 2022
  UPDATE 3 - May 4th, 2022
  UPDATE 4 - May 26, 2022
  UPDATE 5 - June 20, 2022
  UPDATE 6 - February 23, 2023
  
  -----------------------------------------------------------------------------------------------------------------------------------
  
  UPDATE 7 - July 25, 2025
  
  I have added:
  
  • List of all Space Monsters (titled Creatures): with all their stats, reproduction rates, resources dropped on death and prevalence in the galaxy
  • List of all Diseases and Plagues: with all their effects on colonies, chance to happen, chance to spread (for plagues) and plague curing against each one (for plagues)
  Furthermore:
  
  • The VBA code for importing and validating files is now a lot more streamlined. If anybody is using this feature you will notice it is now faster than before (though certain sheets, like Hulls, will still take up to 1 hour to process due to the amount of data)
  • Fixed multiple typos and errors.
  • Updated to latest game version, including all data from DLCs
  -----------------------------------------------------------------------------------------------------------------------------------
  
  COMING UP NEXT
  
  • Update the Cheat Sheet to new game versions
  Any suggestions you may have, please post them here

[frankycl]

This is great - thanks for sharing it !

But why only TXT-/PDF-format ? - why not an Excel-/OpenOffice-sheet, or at least RTF-format ?

[OrnluWolfjarl]

As I said, it's only a draft. I'm working to turn it into an Excel and GoogleDoc. I posted it to see if anybody would see any mistakes I missed.

[frankycl]

As I said, it's only a draft. I'm working to turn it into an Excel and GoogleDoc. I posted it to see if anybody would see any mistakes I missed.

Well, you could find those mistakes (even more easily) with an Excel-sheet, too - no ? (and you could update your Excel-downloads anytime in the same way you do this with other stuff... ) - no criticism, though.

[frankycl]

... wow - at first sight I'd say your sheet is very well though-out and structured (and I also think that all main analysises/assertions are very right, too) - very well done !

But I think you should upload this in the modding-forums - here and on Steam -, too (this way much more people (and in the end the mods/the game itself) could benefit from it) !

[OrnluWolfjarl]

As I said, it's only a draft. I'm working to turn it into an Excel and GoogleDoc. I posted it to see if anybody would see any mistakes I missed.

Well, you could find those mistakes (even more easily) with an Excel-sheet, too - no ? (and you could update your Excel-downloads anytime in the same way you do this with other stuff... ) - no criticism, though.

True, but I like doing it this way first, so I have raw numbers that I can open with anything on a phone, laptop, PC, etc. I can then organize the numbers on Excel much more cleanly. It's more hassle for me to do it the "easy way"

[OrnluWolfjarl]

I have placed the information in an Excel sheet (see attachment in original post), and have also uploaded it on Google Sheets here

[frankycl]

I have placed the information in an Excel sheet (see attachment in original post), and have also uploaded it on Google Sheets here

Oh wow - that's pretty good stuff, imho - thank you very much.

(But why is it called "DW..." - is this from/for DW1, too ?)

[OrnluWolfjarl]

I have placed the information in an Excel sheet (see attachment in original post), and have also uploaded it on Google Sheets here

Oh wow - that's pretty good stuff, imho - thank you very much.

(But why is it called "DW..." - is this from/for DW1, too ?)

You are welcome

It's not called DW2 because a Gravillex interrupted me while building it

(Just something I didn't think about, I'll fix it next time I update - It won't work on DW1, since resources and planets are different)

[Siddham]

Thanks you for making these resources

[Buio]

It's not called DW2 because a Gravillex interrupted me while building it

I can hear the sound.

Thank you for the sheet and notes!

[OrnluWolfjarl]

UPDATE 2 April 22nd

The work continues...

I have added:

• List of all Technologies...
• ... with all their costs, components/hulls/planetary facilities/bonuses they unlock, races/situations they are specific for, IDs, requirements, research bonuses they benefit from (some need confirmation, which I will do later this week), and their possible paths in case of randomized tech tree
• List of all Components...
• ...with all their stats (across all their versions), costs, types, sizes

Please see the zip files marked as CURRENT attached below

xlsx - Excel 365 sheet (what I work with currently)

xls - Can be opened with older versions of Excel, as well as Open Office (which you can get for free)

Web - Can be opened through your browser, no internet connection required

[OrnluWolfjarl]

Updated the Google Sheet to the latest version

[OrnluWolfjarl]

UPDATE 3 - May 4th

The work continues...

I have added:

• List of all Planetary Facilities: with all their costs, bonuses they provide, troops they can produce, defensive capabilities, races/situations they are specific for, IDs, requirements, how many can be build per Colony/Empire/Galaxy.
• List of all Troops: with all their stats, costs, types, sizes, races - (Dhayut Regular Infantry not included yet)
• List of all Races: with their habitability, biases towards other races, governments allowed (if playable), characteristics, unique technologies/components/planetary facilities, starting research, preferred components (if AI) special features (Aurora DLC only), troops and victory conditions - (Hulls will be filled in next version)
• List of all Governments: with their political system, stability, biases towards other governments, diplomatic outlook, bonuses they provide, starting events and additional features (Aurora DLC only)
• List of all Artifacts: with the bonuses they apply, governments they unlock, techs they unlock or complete, and requirements for the bonuses to apply

Furthermore:

• Added some rudimentary formatting for easier readability (particularly if one uses the WEB version) - This is only a placeholder and better/easier to use formatting will come in the near future.
• Added information on which game files and game version this Cheat Sheet applies (can be found in "Notes"). In addition, some specific entries now are marked as "Vanilla" or "Aurora DLC". In the near future, all entries will have a "Source".
• In the compact Reference Lists sheet: Technologies and Components lines now include the Race they are specific to (otherwise that column is left blank).
• Corrected a few errors and typos.
• Added a key for abbreviations (found in NOTES)

Please see the zip files marked as CURRENT attached below

xlsx - Excel 365 sheet (what I work with currently)

xls - Can be opened with older versions of Excel, as well as Open Office (which you can get for free)

Web - Can be opened through your browser, no internet connection required

Consider other versions obsolete

The Google Sheet is NOT UP TO DATE YET (still version 2)

COMING UP NEXT

• List of Hulls
• List of Events
• Corrections and Formatting for better readability

[OrnluWolfjarl]

I have updated the Google Sheet to version 3 - Found here.

[frankycl]

Great work, as always - thank you very much.

However, I'm wondering: What do you do, when the DEVs change some of the values, etc. - like they frequently do with e.g. governments or characters, etc. (just to name a view) ? - I haven't seen any update-/-change-logs in your threads so far...

[OrnluWolfjarl]

Great work, as always - thank you very much.

However, I'm wondering: What do you do, when the DEVs change some of the values, etc. - like they frequently do with e.g. governments or characters, etc. (just to name a view) ? - I haven't seen any update-/-change-logs in your threads so far...

Thanks!

I am using the official version so far. I am planning to finish everything I intend to include with those files (hopefully before the next official update), then I'll use a tool to compare for changes in game files and add them or change their values.

Honestly, between Notepad ++ and Visual Basic included in Excel, I'm not that worried about it.

My main goal right now is to have a database of all things and all their possible properties (which is why there's a lot of "None" values in there, instead of leaving it empty or 0). After that I can automate the process and just check to ensure changes are made correctly.

I could automate it right now, but going through everything one by one helps me to ensure fixing mistakes and that the structure of the tables is correct.

[frankycl]

Thank you very much for your again detailed answer; - really looking forward to its completion.

[OrnluWolfjarl]

Thank you very much for your again detailed answer; - really looking forward to its completion.

You are welcome

[Kahnite]

WOW! Thank you VERY much. Saved be a lot of trouble.