Formula to convert raw resources per minute to refined item production. 3. Profit Maximizer (The "Sheet" Goal)
| Planet | Base Ore Value | Mining Rate (per sec) | Current Level | Total Value/sec | Upgrade Cost | ROI (hours) | |--------|----------------|----------------------|---------------|----------------|--------------|-------------| | Earth | 1 | 10 | 20 | 10 | 500 | 50 | | Luna | 2 | 5 | 15 | 10 | 400 | 40 |
Example: Shows if using an alternate recipe for Nav Mods saves you 1 out of 5 crafter slots, allowing you to run another production line simultaneously.
Frequently pinned in the #guides or #resources channels. Summary Checklist for Maximum Efficiency Spreadsheet Use Mining Keep levels high. Monitor Ore/Min vs. Capacity. Cargo Only upgrade when needed. Ensure Cargo ≈is approximately equal to Mining Level [2]. Smelting Active smelters 24/7. Calculate Profit per Minute (PPM). Projects Research strategically. Calculate Raw Material Cost. Challenges Every 72 hours [4]. Track GW per hour.
Helps you simulate the best placement for your Mine, Smelt, and Craft managers. idle planet miner spreadsheet new
Knowing exactly when a planet is no longer worth upgrading.
Use the manager slot calculator to test different manager combinations before spending dark matter to unlock slots or promote staff. This ensures you always run the most optimal mining and speed combinations.
Are you focusing on or long-term deep galaxy runs ?
Aggregate totals (put in summary area):
Compare your Smelter Production Speed vs. Required Input Rate to immediately see if you are running out of raw ore. Conclusion: The Path to Galactic Domination
Do not use outdated sheets from years ago, as item values and room costs change with game updates. Visit the official Idle Planet Miner Discord server or the dedicated Subreddit. Navigate to the "Guides" or "Resources" pins to locate the pinned Google Sheets link. Step 2: Create Your Personal Copy
Tells you exactly which planet to upgrade next for the highest return on investment (ROI).
Calculate the raw ore required for high-tier projects to avoid wasted production time. Formula to convert raw resources per minute to
Since recent updates added crew members:
Discord is where you'll find the most up-to-date information. The official Idle Planet Miner Discord server usually has dedicated channels for #guides , #resources , and #tools-and-calculators . These channels are perfect for finding spreadsheets that are actively maintained and updated with the latest game patches.
: The sheet tells you the exact net drain on your inventory. For example, it will flag if crafting 2 Circuits per minute will deplete your Copper Wire stock faster than your smelters can produce it. Tab 3: The Mothership & Manager Planner