High Guard 2022 Ship Design Spreadsheet

AnotherDilbert

Emperor Mongoose
Design Peculiarity: You start with a complete ship, vaguely like a Scout. Lots of features are defaulted, but can be changed. With every change you make the spreadsheet tries to adjust so that you still have a complete ship. Change things in any order. The ship is done when you don't want to change anything anymore...


Only change values in grey cells. Start with TL at the top. Columns are added together at the top, green good and red bad. Empty space is allocated to Cargo.

Tech Advantages are input as numbers between -2 to +3 with 0 being Standard, -0.5 Budget. You get as good a advantage as can be achieved at the given TL, so you might not get exactly what you asked for. Only a few advantages are supported.

You should be able to get more Weapon and Screen rows by copying an entire row and inserting a new row. You can get more Mixed Turrets by inserting 4 new rows and copying the existing 4 rows.

If you need more rows insert entire rows, not just a few cells.

Red numbers means something is wrong...
https://www.dropbox.com/scl/fi/uvb6...ate.xlsx?rlkey=bbdch0obo01zw0fp3gw90kh7g&dl=1
 
Last edited:
New feature:
Colour-coded sections with shortcut buttons in the header:
Skärmavbild 2025-12-24 kl. 02.38.04.png

Click the blue "Hull" button in the header to go to the hull section marked with blue.


Some rows are grouped, so they can be easily hidden, e.g. artificial gravity options:
Skärmavbild 2025-12-24 kl. 02.59.25.png
If you don't want to bother with that, hide those rows with a click on the square "-" button:
Skärmavbild 2025-12-24 kl. 03.00.32.png
The values are still being used and calculated, just not shown.
 
Last edited:
Back
Top