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

Please post here for questions and discussion about data, event, art and sound modding and the game editor for Distant Worlds.

Moderator: MOD_DW2

OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 3 (4/5/2023)

Post by OrnluWolfjarl »

Kahnite wrote: Sun May 21, 2023 9:53 pm WOW! Thank you VERY much. Saved be a lot of trouble. :)
You are welcome!

Be on the lookout for a new update soon.
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 4 (26/5/2023)

Post by OrnluWolfjarl »

UPDATE 4 - May 26

The work continues...

I have added:
  • 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.
  • 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.
Furthermore:
  • Added formatting to all tables for improved readability (this was done using Visual Basic coding through Excel - the code will be published at a later date, when finalized)
  • All entries are now color-coded.
  • Corrected a few errors and typos.
-----------------------------------------------------------------------------------------------------------------------------------

COMING UP NEXT
  • Update all data to Hyperdrive update
  • Create tools that will automate the update process from now on (which will be publicly available, in case of author death, dismemberment or, worst of all, dreadful laziness).
As usual, the updated files are posted under the original post.
Last edited by OrnluWolfjarl on Sat May 27, 2023 9:11 am, edited 1 time in total.
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

A diary in place of an update 1

Post by OrnluWolfjarl »

Hello everyone,

It's been a while since my last update, and seeing as the Hyperspeed update has released some days ago, I thought I'd let you know on the status of the project.

Rest assured, I am still working to update the Cheat Sheet to the next game version (1.1.4.4).

As a reminder, the Cheat Sheet reflects game version 1.1.2.4. However, most of the information it contains should be accurate, except to anything the devs have implemented in HyperSpeed (like reactor fuel usage or the new way shields use energy to recharge themselves).

However, updating the Cheat Sheet is taking a bit longer than expected. The reason is threefold:

a) Due to the nature of my work, the end of May is an extremely busy period every year, and I've had to put work on the Cheat Sheet to the back-burner. I've still found time to work on it, but it's been quite slow. Thankfully, this busy period has passed for now.

b) I've been creating a tool that will format each list for easier readability. You've already seen a part of the final product in the current Cheat Sheet version (v4), with all the nice borders and coloured rows. When the Hyperspeed update was released, I was still working to eliminate any kinks and add a bit more functionality to the tool.

c) I've decided to create another tool that will allow me to import the values from each XML file in Excel, and then have Excel check which values in the Cheat Sheet are correct. This should help me eliminate typos or anything I missed while I was constructing the Cheat Sheet. This will also allow me to update the Cheat Sheet quickly in the future, as well as keep up with the frequent beta updates that the game is receiving. Furthermore, this tool will be rolled in the Cheat Sheet to allow users to do their own updating (possibly with some modifications needed on the user's end, but I'll see about streamlining the process as much as I can).

I've already started working on coding this updating tool (on the VBA developer tool provided by Excel), but it's still in its early stages. I'm fairly certain I've completed the basic architecture, so now I have to adjust the code for each XML game file. I estimate this will take me at least another 2 weeks to finish and be ready to release version 5 of the Cheat Sheet. I'll possibly release an early 4.5 version bringing at least some of the information on the Cheat Sheet up to date with Hyperspeed, but I can't make any solid promises yet.

Thanks for all the support, downloads and thank yous :D. It gladdens me to see this project is useful to people!

Have a good one!
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

DW2 Cheat Sheet update to v5!!!

Post by OrnluWolfjarl »

UPDATE 5 - June 20

The work is almost done... Sorry it took a while!!!

Changes:
  • UPDATED ALL ENTRIES TO GAME VERSION 1.1.4.4 - HYPERDRIVE UPDATE
  • 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
Furthermore:
  • Formatting has been improved for easier readability
  • All entries now contain a source (vanilla or DLC)
The google sheet will be updated at a later date
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 5 (20/6/2023)

Post by OrnluWolfjarl »

UPDATE 6 - February 23, 2023

The work is done finally... Once again, sorry for the long wait!!!

Certain events in life (do not worry, all is well now), have delayed me significantly in updating this Cheat Sheet. I want to assure you that the project is not abandoned.

The cheat sheet has become much more powerful now, as it includes tools that help you import XML data files from the game, and automatically scan each Cheat Sheet for errors or for any needed updates. These tools utilize Excel VBA code to work, and to enable them, some set-up might be required on your end. Excel 365 is required to use this version of the Cheat Sheet. You can find it on the Google Drive link in the main post.

Changes:
  • UPDATED ALL ENTRIES TO GAME VERSION 1.2.0.5
  • Components & Hulls Overview: can now filter by name, type and group
  • Added tools: which can help you keep your DW2 Cheat Sheet updated on your own, found on the INTERFACE worksheet.
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 6 (23/2/2024)

Post by OrnluWolfjarl »

The Google Sheet is now updated to version 6 (1.2.0.5) as well.
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 6 (23/2/2024)

Post by OrnluWolfjarl »

Just wanted to let people know that I was working on an update for the Cheat Sheet with the previous beta, but decided to postpone it, till the Shakturi DLC gets released.
Colwolf77
Posts: 54
Joined: Fri Apr 24, 2015 12:01 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 6 (23/2/2024)

Post by Colwolf77 »

OrnluWolfjarl wrote: Sun Oct 13, 2024 11:08 pm Just wanted to let people know that I was working on an update for the Cheat Sheet with the previous beta, but decided to postpone it, till the Shakturi DLC gets released.
Fantastic work with the cheatsheet! its great to see how dedicated the community is to this excellent game. I was wondering, are there any plans to update it to the latest version of the game? would be greatly appreciated.
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 6 (23/2/2024)

Post by OrnluWolfjarl »

Colwolf77 wrote: Sun Apr 13, 2025 11:48 pm
OrnluWolfjarl wrote: Sun Oct 13, 2024 11:08 pm Just wanted to let people know that I was working on an update for the Cheat Sheet with the previous beta, but decided to postpone it, till the Shakturi DLC gets released.
Fantastic work with the cheatsheet! its great to see how dedicated the community is to this excellent game. I was wondering, are there any plans to update it to the latest version of the game? would be greatly appreciated.
Im working on an update right now. Sorry for the delay but life sort of got in the way this past year. I've done races, governments and techs so far and working my way through components. Conponents and Hulls will take a while (Techs took me about 2 weeks to finish), but the rest should be relatively quick.
Colwolf77
Posts: 54
Joined: Fri Apr 24, 2015 12:01 pm

Re: DW2 Cheat Sheet - A reference list of everything - Version 6 (23/2/2024)

Post by Colwolf77 »

OrnluWolfjarl wrote: Thu Jul 03, 2025 1:24 am
Colwolf77 wrote: Sun Apr 13, 2025 11:48 pm
OrnluWolfjarl wrote: Sun Oct 13, 2024 11:08 pm Just wanted to let people know that I was working on an update for the Cheat Sheet with the previous beta, but decided to postpone it, till the Shakturi DLC gets released.
Fantastic work with the cheatsheet! its great to see how dedicated the community is to this excellent game. I was wondering, are there any plans to update it to the latest version of the game? would be greatly appreciated.
Im working on an update right now. Sorry for the delay but life sort of got in the way this past year. I've done races, governments and techs so far and working my way through components. Conponents and Hulls will take a while (Techs took me about 2 weeks to finish), but the rest should be relatively quick.
Ah that's excellent news! thank you.
OrnluWolfjarl
Posts: 317
Joined: Fri Oct 20, 2017 8:36 pm

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

Post by OrnluWolfjarl »

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
User avatar
frankycl
Posts: 402
Joined: Mon Mar 01, 2021 5:16 pm

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

Post by frankycl »

Great to see/read that you're still updating this ! :D

Thanks a thousand times (again). :)

EDIT: But your link in the OP in Steam... leads to a Matrix page with "The requested topic does not exist." (in case you read more often here than in Steam ;) )

But I also have a little question/suggestion:

Do you still have some older versions for this, too ? If so, it would be great if we could download them additionally/optionally ! 8-)
The reason for this is that if you use a legacy version of DW2 (or even a more older one), it's often a bit confusing, because sooo many things have changed already... :?
Post Reply

Return to “Design and Modding”