Your calculations in Part 1 rely on accurate multipliers. If you swap a manager for a +50% mining buff, your
In the mid-to-late game, manually tracking production ratios, market fluctuations, and project costs becomes overwhelming. A spreadsheet helps you:
This is the gold mine. Search for posts from users like @JakeTheData or @IPM_Math. Look for files named IPM_Calculator_v2.3.xlsx or later. The date modified must be within the last 60 days. idle planet miner spreadsheet new
Iron Ore → Iron Ingot (smelt)
Iron Ingot + Carbon → Steel Ingot
Steel Ingot + Silicon → Hammer
Use this tab to see where your bottleneck is. If hammers are slow, check Steel supply.
| Manager Name | Assigned Planet | Skill (Mining/Shipping) | Buff % | Buff Type | | :--- | :--- | :--- | :--- | :--- | | Chief Engineer | Terra Prime | Mining | +50% | Copper/Iron | | Cargo Master | Ice-9 | Shipping | +20% | All Ice Ores | | Scientist X | Molten Moon | Research | +10% | Tech Speed | Your calculations in Part 1 rely on accurate multipliers
If you are aiming for the Top 10 in Platinum League, one spreadsheet isn't enough. You need a suite.
The new meta strategy: Copy the values from Sheet A into Sheet C, run a goal-seek algorithm (Sheet > Add-ons > Goal Seek), and find the absolute perfect upgrade order for the next 72 hours. This is the gold mine
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.