To create an effective spreadsheet, you'll need to set up several key sections:
This is the engine of your spreadsheet. Use this to determine if upgrading your mine is worth the cost or if you should save for a smelter upgrade. idle planet miner spreadsheet new
| 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 ) | To create an effective spreadsheet, you'll need to
Once you have the basics, add:
This is the "new" secret sauce. Old sheets ignored manager secondary skills. New sheets use a weighted ranking system. Old sheets ignored manager secondary skills
Example Calculation:
Before diving into the specifics, let's consider why a spreadsheet is a valuable tool for Idle Planet Miner players: