top of page

Spreadsheet New - Idle Planet Miner

| Calculation | Formula Example (Google Sheets) | |-------------|----------------------------------| | Time to next upgrade | =(Target_Level - Current_Level) * Cost_Per_Level / Total_Income_per_sec / 3600 | | Ore needed for alloy | =Alloy_Craft_Count * Ingots_Per_Alloy * Ore_Per_Ingot | | Smelter utilization | =IF(Total_Ore_Input >= Ore_Required, "Saturated", "Ore Shortage") | | Best manager to upgrade | =Max( (New_Bonus - Old_Bonus) * Affected_Planets_Total_Value ) |

Input a target item (e.g., 10 Radio Shacks). The sheet automatically calculates total raw materials needed (Copper Wire, Microchips, Silicon, etc.).

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. idle planet miner spreadsheet new

When creating a new spreadsheet for Idle Planet Miner, consider the following features:

Set cells to turn if consumption is higher than production (meaning you will run out of resources while away). | Calculation | Formula Example (Google Sheets) |

Older spreadsheets calculate smelting speed based on raw level 1 stats. Recent patches changed the efficiency curves for Copper, Iron, Silver, and Gold. Using an old sheet might tell you to smelt Lead bars when Alloy smelting is now 40% more efficient in the early mid-game.

List the highest planet you currently have unlocked. The sheet will automatically populate the ore distribution percentages (e.g., Planet 10 producing Iron, Lead, and Silicon). Input your current Mining level for those planets to track your raw income generation. Step 3: Set Your Production Targets The official Idle Planet Miner Discord server usually

This tab calculates the net value of all produced items, factoring in the time required to craft them.

A: Yes. The save file syncs. However, Steam runs slightly faster (frame rate affecting ore animation). Add a +5% fudge factor to your "Ore per minute" tab if you are on PC.

Did you find this guide useful? Bookmark it and share it with your Galaxy Clan. If you have created a new spreadsheet variant, tag the author in the Discord to get it added to the master list.

Let me know what's on your mind

Thanks for submitting! Expect a response between 24-48 hours.

Echo Mag. All rights reserved. © 2026

bottom of page