Idle - Planet Miner Spreadsheet New

A spreadsheet will show you that colonizing a planet to Level 5 gives a 2x bonus. It won't tell you that doing this during a Tournament gets you sniped by PvP raiders. Always colonize after a tournament begins, not before.

You can copy this structure into a new sheet:

[Column A] Planet Name
[B] Base Ore Value
[C] Mining Rate (from colony/upgrades)
[D] Manager Bonus (%)
[E] Room Bonus (%)
[F] Total Value/sec =B2*C2*(1+D2)*(1+E2)
[G] Upgrade Cost to +1 level
[H] ROI (hours) =G2/(F2*3600)

💡 Freeze row 1, use conditional formatting to highlight ROI < 24 hours green. idle planet miner spreadsheet new

When you press "Sell Galaxy" for a Challenge (24-hour reset), ignore your long-term spreadsheet. Use a temporary tab that focuses solely on Copper, Lead, and Glass – the "speed run" trifecta.

Since recent updates added crew members:

Critical for avoiding bottlenecks. Example with 6 smelters and 4 crafters: A spreadsheet will show you that colonizing a

| Item | Input | Output | Time (sec) | Needed per 10 min | Smelters Required | |------|-------|--------|------------|-------------------|--------------------| | Copper bar | 10 copper ore | 1 bar | 60 | 10 bars | 1 smelter full time | | Wire (crafted) | 1 copper bar | 1 wire | 30 | 20 wires | → needs 20 bars → 2 smelters |

Balance formula:
Smelters needed = (Crafter demand for bars per hour) / (Bars per hour from one smelter)

Use conditional formatting (red/yellow/green) to show bottlenecks. 💡 Freeze row 1, use conditional formatting to

Can't find a sheet you trust? Build one in 30 minutes using these four simple formulas. You only need Google Sheets (free).

The game’s community updates sheets frequently. Check:

Example known community sheets (search these exact names with “latest”):

⚠️ Avoid sheets older than 6 months — the game’s market rates, room bonuses, and crafting trees change, making old data misleading.