, you need more than just quick taps; you need data. Whether you are aiming for a sub-hour Galaxy Reset or pushing for deep-space Vibranium, the latest community-driven spreadsheets are essential for calculating your Return on Investment (ROI) and optimizing your crafting chains. 1. Why You Need the New Spreadsheet
: 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.
Which item should you be crafting right now based on market prices? 3. Galaxy Worth & Credit Calculator
To create a spreadsheet, you can use any spreadsheet software, such as Google Sheets, Microsoft Excel, or LibreOffice Calc. Here's a basic template to get you started:
Since recent updates added crew members: idle planet miner spreadsheet new
Go to the "Settings" or "Mothership" tab. Enter your current levels for the Engineering Room, Forge, Workshop, and Astronomical Lab.
List your active managers and their star levels to see real-time production shifts. 4. Advanced Strategies Using Data The "7-Planet Rule":
Use the calculator to determine if it is more profitable to sell raw alloy bars or convert them into completed items based on your current workshop bonuses.
List upcoming costs so you don’t waste resources. , you need more than just quick taps; you need data
💡 Freeze row 1, use conditional formatting to highlight ROI < 24 hours green.
Determining if the hours required to craft a Radio Tower are more profitable than simply selling the thousands of Silver Bars required to make it. The Mother Ship Factor:
Use the data from the Idle Planet Miner Wiki to set up your base values. 2. Smelter and Crafter Optimization This is the heart of the spreadsheet. It should show: Input/Output Ratio: For example, 10 Iron Ore →right arrow 1 Iron Bar. Crafting Time: (e.g., 5 seconds)
Open the link, click on File in the top menu, and select Make a copy . You cannot edit the master community file directly. Why You Need the New Spreadsheet : This
Visit the official Idle Planet Miner Subreddit or join the community Discord server. Search for the pinned "Master Spreadsheet" or "Tools" channel to get the most recent Google Sheets link.
“You outgrow Kaphor's sheet fairly quickly but still one of the best out there for completeness - at least, as far as it goes.” Reddit · r/IdlePlanetMiner · 11 months ago Usage Tips & Known Limitations
Instantly know which alloy is most profitable based on current market prices and your smelting rates.
[Mothership Bonuses] + [Manager Multipliers] │ ▼ [Spreadsheet Inputs] ──► [Calculates True VPS] ──► [Identifies Best Planet to Upgrade] ▲ │ [Ore Badges] + [Alchemy Project Levels]
often mirrors the most stable versions of these calculators. Always look for spreadsheets that include a "Planet 1-30 Optimization"