High Guard 2022 Ship Design Spreadsheet Walkthrough

[AnotherDilbert]

How to use this spreadsheet:
https://forum.mongoosepublishing.com/threads/high-guard-2022-ship-design-spreadsheet.126250/

 

[AnotherDilbert]

Let's build a simple tramp trader, something like a Free Trader:

Start with TL and basic setting, TL 12 seems reasonable:



The basic setting controls a lot of default values. Specify "0" for a standard ship.



Collapse all the grouped cells with the "1" button top-left, they are generally not necessary for a basic ship:

 

[AnotherDilbert]

Specify a 200 Dt hull:


Specify Jump 1 and Man 1:

 

[AnotherDilbert]

Specify some passenger capacity:


And we are essentially done...

 

[AnotherDilbert]

Use the filter in cell A9 to hide rows that are not needed:



Resulting in:

 

[AnotherDilbert]

To get an estimated economic projection, select if the ship is a Custom or Standard design in cell C200:

Not great...


You'll find a CT-style description of the ship on the "Description" tab:

 

[AnotherDilbert]

If we change the basic setting to "-1" (Budget ship) and refresh the filter, we get budget hull and drives:

Saving about MCr 10.


Leading to a potentially profitable tramp trader:

 

[AnotherDilbert]

Let's build a small warship:

Let's specify TL15 and military setting:


500 Dt:


Jump-4 and 9 G:

 

[AnotherDilbert]

Add some weapons:

A Particle barbette,
two laser turrets,
two mixed defensive turrets.

Add tech upgrades, e.g. Accurate barbette and Long Range laser turrets:

 

[AnotherDilbert]

We seem to have run out of space, so go back and reduce the drives a bit, e.g. Jump-3:



Add an external Ship's Boat in a Docking Clamp:



Add some Sensor Operators:

Some Sensor Workstations are added automatically.


Make sure we have enough space for supplies:



Since we have some space over, add a mission module:

 

[AnotherDilbert]

We are looking about done, so set the filter in cell A9:



Result: