These forums have been archived and are now read-only.

The new forums are live and can be found at

Science & Industry

  • Topic is locked indefinitely.

Cap Ship Cost Calculator

0utside Bet
Brothers of Tangra
#1 - 2017-03-29 22:23:42 UTC  |  Edited by: Chl0e
Hi all,

I have recently come back to game cant believe i left lol.

I used to have an amazing speed sheet for capital ship and super capital ship build cost calculation, it was created by Aaron Nielsen.

This is a link to the one i used Old Copy

This is a link to the one started to edit, very much a work in progress so if anyone can help :) Newer copy semi edited

Is there something new available that would be worth checking out?

Many thanks
Zarek Kree
WiNGSPAN Delivery Services
WiNGSPAN Delivery Network
#2 - 2017-04-02 06:21:26 UTC
I saved this when you first posted but just got around to looking at it carefully. I like the core functionality of this very much. I've been building my own industry spreadsheet (not cap focused, but it includes some small caps). I scratched my head for a few days trying to figure out how to make a spreadsheet behave like a database. I finally gave up and used a rather inelegant brute force solution that works well but just feels wrong. Yours uses a rather elegant approach relying on the MATCH and OFFSET functions to make it behave like a true database that's easily configurable and expandable. I like this very much.

A couple of points that you may already know:

1. The notion of wastage has been eliminated and has been replaced by material efficiency of the blueprint and production facility. The formula for materials is now defined as:

Required Materials = max(runs, ceil(round(runs ∗ baseQuantity ∗ materialModifier, 2))

MaterialModifier is a product of the ME modifier (1.0 to 0.90 or 0% to 10% reduction) and the facility modifier.

2. I'd recommend having a sheet dedicated to pulling in current price data on all of your materials and components using API calls though a script. That's what most people do these days.

3. I also suggest running build vs buy costs for each of your components. Many components can periodically be much cheaper to buy instead of build.

4. Maybe include blueprint, job and selling costs as well so that you get an estimate of true expected profit.