Science & Industry

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.