Tells you exactly when to stop upgrading cheap rooms and start saving for expensive, game-changing rooms like the Lounge (bonus credits per galaxy sell). How to Set Up Your Spreadsheet
| | How It Helps | | :--- | :--- | | Investment Optimizer | Ranks upgrade candidates (Planet levels, Rooms, etc.) by ROI, showing the mathematically best next steps. | | Project Tracking | Tracks research and Space Station nodes (like Alternate Recipes and Colony Expansions), showing when to begin long projects. | | Market Adjustments | Allows you to input current ore/alloy prices to guide what you should be smelting and selling. | | Custom Bonuses | Accounts for your unique stats (Managers, Beacons, Rooms) to ensure the math is tailored to your galaxy. | | Resource Planning | Helps manage complex production chains for high-value items, from basic ore to advanced products. |
If your goal is to craft a , select it from the dropdown menu in the Crafting Calculator. The spreadsheet will break down the absolute totals required: Total Copper, Iron, and Lead Ore needed. Total Wire and Batteries required. idle planet miner spreadsheet new
Getting started with a community spreadsheet takes less than ten minutes. Follow these steps to set up your document correctly:
During weekend tournaments, speed is everything. Use these spreadsheet strategies to secure a top spot in your bracket: Tells you exactly when to stop upgrading cheap
If you can't find a recent sheet, creating one is a great alternative:
: This specialized tool focuses on the Mothership and Space Station . It includes tabs to calculate the "Best Thing to Craft" based on your current managers and room levels, helping players plan their galaxy growth. | | Market Adjustments | Allows you to
: Recent updates on Reddit have added interactive logic for all three Alchemy tiers, allowing users to see visual highlights of set tiers and immediate value updates. Legacy "Mastersheet" Note
planet. This is the planet where your mining rate, combined with resource stars, produces the most wealth. Focus your best managers here. Balance Your Logistics:
| Column Header | Description / Formula Logic | | :--- | :--- | | | Name of the celestial body (e.g., Terra Prime, Ice-9). | | Resource | The specific ore being mined (e.g., Copper, Iron, Gold). | | Current Level | The current upgrade level of the mine. | | Production Rate (min) | Ores produced per minute. (Manual entry or calculated) . | | Multiplier (x) | The total multiplier active (Research + Mothership + Artifacts). | | Net Production | = Production Rate * Multiplier | | Upgrade Cost | Cost to reach next level. | | Cost per Unit | = Upgrade Cost / Net Production Increase (Lower is better). | | ROI (Minutes) | = Upgrade Cost / (New Production - Old Production) (How long to pay back the cost). |