Building capital ships like a boss, part 6: Spreadsheets

Index:

1. Introduction
2. Ship blueprints
3. Component blueprints
4. Researching your blueprints
5. Moving capital blueprints safely
6. Spreadsheets (you are here)
7. Location, location, location
8. Moving minerals
9. Actually building stuff, finally
10. Selling your ships


There probably aren't any more spreadsheet screenshots to post, so we might as well get around to posting the spreadsheet.

Here you go (LibreOffice Calc).

To use it, you must first go to the 'capital ship components' sheet and enter the material levels of your component blueprints. Then, go to the 'build tool' sheet at R2 and edit the component requirements to reflect those of your ship blueprints.

The actual production part of the 'build tool' sheet consists of three parts:

Component tool: Enter quantities of ships in the 'quantity' column and it will tell you how many components you need.

Mineral buying tool: Tells you what quantity of minerals you need to build the components shown in the component tool, and whether it is cheaper to get them from sell orders or with a buy order.

Blueprint tracker: I use this to keep track of the status of the ships I'm building. The 'next run' column is so you can build the next run's components while the hull is still under construction.

 

(my personal copy, with builds in progress)

The spreadsheet also includes the component calculator you saw in part 3, the hull blueprint material level table from part 2, a profit tool where you put in mineral and hull prices to see profits, and a sheet named 'component calculator' (which is the production area of the original spreadsheet) where you can select a ship and material level to see the component requirements.

Note: Whenever the spreadsheet accounts for tax, it assumes 1.25%.

Note: It's possible that the mineral quantities read slightly low. I'm not actually sure this is true - it's not easy to test during production - but when you're buying minerals you might want to round the third digit of the quantity upward to be safe.

Attribution:

The original spreadsheet came from here.


Go to part 7: Location, location, location