Your Smelters and Crafters run at different speeds based on your Manager bonuses, Beacon upgrades, and Room levels in the Mother Ship. A spreadsheet calculates your exact production rates. It tells you if your Smelters can produce Bronze Bars fast enough to keep your Crafters running without idling. 3. Calculating True Return on Investment (ROI)
| Item | Input 1 | Qty | Input 2 | Qty | Time (sec) | Output Value | Value/sec | |------|---------|-----|---------|-----|------------|--------------|-----------| | Copper Bar | Copper Ore | 3 | - | - | 5 | 6 | 1.2 | | Iron Bar | Iron Ore | 2 | - | - | 10 | 8 | 0.8 | | Bronze Bar | Copper Bar | 1 | Iron Bar | 1 | 15 | 20 | 1.33 |
| Planet | Ore Type | Base Mining Rate | Current Level | Upgrade Cost | Adjacent Bonus | |--------|----------|------------------|---------------|--------------|----------------| | Terra | Iron | 12/s | 25 | 5.2M credits | +10% from Moon | idle planet miner spreadsheet
Let’s get into the dark mechanics. Once your spreadsheet is running, you will notice three undeniable truths.
The Mothership has billions of Science points available but limited Cells. You cannot max everything. Your Smelters and Crafters run at different speeds
Many players hit a wall where upgrading mining speed or ship speed blindly yields diminishing returns. A dedicated spreadsheet solves this by calculating the exact mathematical bottleneck in your production line. 1. Visualizing Complex Crafting Trees
If you are looking to dive into the data, these are the primary tools developed by the community: The Mothership has billions of Science points available
Resource Cost Reductions (from the Astral Pod and Laboratory rooms) Step 3: Apply the Formulas
What are you currently crafting? (e.g., early-game Wires/Batteries, mid-game Circuits, or late-game Tech?)
