Here's a sample spreadsheet for a colony ship.
![[Image: Colonizer-Sample.png]](https://i.ibb.co/wQ6t8WK/Colonizer-Sample.png)
Note that this is just an example. The figures aren't precise, and this doesn't list all the available early tech. Raven includes them in his original spreadsheet, on which this is based, but I simplified here for clarity.
The blue text is for tech available at start. Black-text tech is for upgrades. You could also calculate Thrust and Structural Integrity, but these aren't likely to matter for early turns.
See Expanding Your Empire for suggestions on early ship designs.
Note that this is just an example. The figures aren't precise, and this doesn't list all the available early tech. Raven includes them in his original spreadsheet, on which this is based, but I simplified here for clarity.
The blue text is for tech available at start. Black-text tech is for upgrades. You could also calculate Thrust and Structural Integrity, but these aren't likely to matter for early turns.
See Expanding Your Empire for suggestions on early ship designs.