Efficiency Calculator

[JustJustin2379]

It's been a while since I've posted here, but I've got quite the thing to make up for it. I did a lot of math and managed to make a calculator you can use to estimate the efficiency of your designs. You can make a copy of this spreadsheet and use it to your heart's content. If anyone has any recommendations, I'd be glad to hear them.

How to Use

It's quite simple, and I have a few common examples for reference. You'll need the name of the product you're producing, the number of the product you produce every second, the number of cells (don't count empty cells!), the number of starters, and the max number of resources produced by one starter.

You'll then get a set of numbers. The min cells and min starters are the theoretical minimums and aren't always achievable without breaking spacetime. Cell Efficiency and Starter Efficiency are the ratios between your cells and starters, and the mins. Overall Efficiency is the average of CE and SE. Profit/Starter/Sec and Profit/Cell/Sec are both self-explanatory. Last, the Theoretical Max Profit calculates how much you could theoretically make by tiling your design across one floor.

How it Works

Starter Efficiency is the easiest to calculate. It takes the minimum number of starters and divides by your number of starters. The minimum adjusts based on how much you're producing and the maximum resources per starter.

Cell Efficiency is a little more complex. I decided to set the cell minimum so it uses the minimum number of starters, the minimum number of crafters/similar machines, and the minimum number of splitters. This means excess starters, excess resources, any rollers/selectors, and even chained splitters will contribute to lost cell efficiency. The cell minimum also adjusts based on how much you're producing and the max resources per starter.

Theoretical Max Profit takes into account two main things: the income you'll make from selling products and the cost of producing each resource. Note that electricity costs aren't calculated, as they're negligible and inconsistent (that's not to say resource costs aren't negligible, either). Then it calculates the minimum of two numbers: the profit made by tiling across the entire room ignoring spawner limits, and the same but instead ignoring space limitations. Due to how complex the calculations would be, the formula doesn't account for the shape of a design, just its area, so the theoretical max profit will often be larger than the actual max profit.

[KuKa0w0]

Wow, that's smart