Idle Planet Miner Spreadsheet [updated] -

The "Idle Planet Miner Master Spreadsheet" is the gold standard for players looking to optimize their galaxy growth. The most current and widely used version is maintained by the community on Reddit and Discord. Core Spreadsheet Resources

The Mastersheet: A comprehensive tool for tracking everything from manager bonuses to room efficiency. Recent updates have focused on credit calculators and optimal upgrade paths.

Idle Planet Miner Wiki: Essential for checking base data like Room Max Levels (e.g., Engineering and Forge max at level 60) and Upgrade Strategies. Key Data Tracked in Spreadsheets

Spreadsheets are typically used to calculate these high-priority metrics: idle planet miner spreadsheet

Manager Optimization: Determining which managers to promote to 5-star status (prioritizing Mining primary and secondary skills).

Mothership Room Efficiency: Calculating the ROI for rooms like the Lounge (for more credits) versus Astronomy (to reduce planet prices).

Galaxy Selling Thresholds: Tracking when to sell your galaxy (starting at $10M) to maximize Credit gain per hour. The "Idle Planet Miner Master Spreadsheet" is the

Resource Ratios: Maintaining the "Golden Rule" where Shipping and Cargo levels should be roughly half the level of your Mining to avoid overspending. Quick Progress Benchmarks Early Game

Aim for $10M Galaxy value in under 10 minutes to farm credits. Research Prioritize Advanced Mining (+25% bonus) in your routine. Beacons

Invest points into the first 16 planets for maximum early-run speed. Section 1: Setting Up Your Spreadsheet (Google Sheets

Since Idle Planet Miner is a game about balancing ore processing, smelting, crafting, and planet upgrades, a spreadsheet is the best way to track efficiency and plan your next steps.


Section 1: Setting Up Your Spreadsheet (Google Sheets or Excel)

Create 4 main tabs at the bottom: Planets, Production, Research, and Upgrade Planner.

2. Motherlode Mine (offline) Efficiency

Offline income = (Cargo * Speed * 60 * Hours offline) * Ore value
Compare different cargo/speed upgrade costs to find the best upgrade order.

4. Smelting & Crafting Calculator

Input your ores → output ingots, alloys, and high-tech items (circuits, lasers, etc.). Tracks:

  • Smelt time per ore
  • Crafting tree dependencies
  • Bottlenecks (e.g., low Titanium → limited Alloy production)