| Planet | Level | Ore Type | Value (Base) | Qty/sec (Your mine) | Income/sec | Next Upgrade Cost | ROI (sec) | |--------|-------|----------|--------------|---------------------|------------|-------------------|-----------| | 1 | 15 | Copper | 1 | 25.0 | 25 | 12,000 | 480 | | 4 | 8 | Iron | 2 | 8.5 | 17 | 8,000 | 470 | | 8 | 3 | Gold | 15 | 1.2 | 18 | 25,000 | 1389 |
While the base stats for each planet are static, your spreadsheet can go further. The best sheets allow you to input your current manager bonuses and research upgrades. This lets the sheet calculate your real, effective mining rate and shipment throughput, giving you a truly personalized and accurate picture of your galaxy's performance. idle planet miner spreadsheet
Put this formula in your Ship Speed Level and Cargo Level cells (assuming Mining is in column B): =ROUNDDOWN(B2 / 2) 2. Calculate Total Galaxy Value | Planet | Level | Ore Type |