Spreadsheets and Theorycrafting: Difference between revisions
From Melvor Idle
(Update versions - Anything functional for 1.0.2 also works for 1.0.3) |
(Update for v1.0.4) |
||
| Line 16: | Line 16: | ||
| Comprehensive sheet that helps calculate time, gain and resource usage till some level. | | Comprehensive sheet that helps calculate time, gain and resource usage till some level. | ||
| [https://discordapp.com/users/564658310272516098 Kidbiz20#2026] | | [https://discordapp.com/users/564658310272516098 Kidbiz20#2026] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table] | | [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table] | ||
| Experience/Level table and lookup up to level 1999. | | Experience/Level table and lookup up to level 1999. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937] | | [https://discordapp.com/users/483005368587386905 Foxy#5937] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s] | | [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s] | ||
| Healing values from cooking, fishing, and farming. Accounts for all modifiers. | | Healing values from cooking, fishing, and farming. Accounts for all modifiers. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937] | | [https://discordapp.com/users/483005368587386905 Foxy#5937] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1gqvUroU6IDaUJMHzeuJvtMoRImCNFyYnWR5IhzT-C1A/edit?usp=sharing Signet A Drop Chance] | | [https://docs.google.com/spreadsheets/d/1gqvUroU6IDaUJMHzeuJvtMoRImCNFyYnWR5IhzT-C1A/edit?usp=sharing Signet A Drop Chance] | ||
| Shows [[Signet Ring Half (a)]] drop chance for every skilling action. | | Shows [[Signet Ring Half (a)]] drop chance for every skilling action. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937]<br/>[https://discordapp.com/users/156771111239942144 <nowiki>mazunki [they/them]#3247</nowiki>] | | [https://discordapp.com/users/483005368587386905 Foxy#5937]<br/>[https://discordapp.com/users/156771111239942144 <nowiki>mazunki [they/them]#3247</nowiki>] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy] | | [https://docs.google.com/spreadsheets/d/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy] | ||
| Raw comparison of additional Hidden Levels against Global Accuracy. | | Raw comparison of additional Hidden Levels against Global Accuracy. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937] | | [https://discordapp.com/users/483005368587386905 Foxy#5937] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables] | | [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables] | ||
| Table listing required Damage Reduction & HP values required to safely idle dungeons.<br/>Inspired by [https://imgur.com/a/8JEtE6g HP Required Dungeon Charts] by [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]. | | Table listing required Damage Reduction & HP values required to safely idle dungeons.<br/>Inspired by [https://imgur.com/a/8JEtE6g HP Required Dungeon Charts] by [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]. | ||
| [https://discordapp.com/users/91970544789897216 Nomeru#4261] | | [https://discordapp.com/users/91970544789897216 Nomeru#4261] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1iRPDZznC5HizeWyyADt7bymFMWxN_jzFP1dGl8Xa4P4 Thieving GP Calculator] | | [https://docs.google.com/spreadsheets/d/1iRPDZznC5HizeWyyADt7bymFMWxN_jzFP1dGl8Xa4P4 Thieving GP Calculator] | ||
| Calculates GP per hour rates for Thieving. | | Calculates GP per hour rates for Thieving. | ||
| [https://discordapp.com/users/91970544789897216 Nomeru#4261] | | [https://discordapp.com/users/91970544789897216 Nomeru#4261] | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1fvrCzdQZYAn9-Y6A6RGfLpJzcv9dmxxoe0SG-DMBULA/edit?usp=sharing Combat Level calculator] | | [https://docs.google.com/spreadsheets/d/1fvrCzdQZYAn9-Y6A6RGfLpJzcv9dmxxoe0SG-DMBULA/edit?usp=sharing Combat Level calculator] | ||
| Enter your skill levels, get your Combat level. | | Enter your skill levels, get your Combat level. | ||
| Dreaddead#1115 | | Dreaddead#1115 | ||
{{VColor|1.0. | {{VColor|1.0.4}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc] | | [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc] | ||
Revision as of 22:19, 11 June 2022
Many people have created spreadsheets to optimize advancement in the game. There is an active community of people trying to Theorycraft certain aspects of the game, creating new spreadsheets in the process, on the Melvor Idle Discord.
Disclaimer: There is no guarantee of the accuracy that a spreadsheet provides, calculations may be flawed. The version number is the game version for which the spreadsheet was last updated for, this does not necessarily mean that the spreadsheet will not work.
List of Spreadsheets
| Name | Description | Author | Version |
|---|---|---|---|
| Melvor Idle Rate & Resource Calculator | Comprehensive sheet that helps calculate time, gain and resource usage till some level. | Kidbiz20#2026 | 1.0.4 |
| Experience Table | Experience/Level table and lookup up to level 1999. | Foxy#5937 | 1.0.4 |
| Cooking HP/s | Healing values from cooking, fishing, and farming. Accounts for all modifiers. | Foxy#5937 | 1.0.4 |
| Signet A Drop Chance | Shows Signet Ring Half (a) drop chance for every skilling action. | Foxy#5937 mazunki [they/them]#3247 | 1.0.4 |
| Hidden Levels vs % Global/Style Accuracy | Raw comparison of additional Hidden Levels against Global Accuracy. | Foxy#5937 | 1.0.4 |
| Dungeon Damage Reduction Tables | Table listing required Damage Reduction & HP values required to safely idle dungeons. Inspired by HP Required Dungeon Charts by Aurora Aquir#4272. |
Nomeru#4261 | 1.0.4 |
| Thieving GP Calculator | Calculates GP per hour rates for Thieving. | Nomeru#4261 | 1.0.4 |
| Combat Level calculator | Enter your skill levels, get your Combat level. | Dreaddead#1115 | 1.0.4 |
| Dragon Javelin Calc | Calculator for Dragon Javelin Money Making method | Nomeru#4261 | 0.20 |
| Melvor Import Template | A template for use in other spreadsheets, it allows the ability to import data directly from a savegame via a script in the Script editor. | Aurora Aquir#4272 | 0.20 |
| Melvor Idle Corruption Calculator | Calculator for Chaos Mode Corruptions. | Hetaku#3546 | 0.20 |
| Mining Companion | Calculator for Mining, listing skill XP, GP, and resource gain per hour for each ore | Xphan0z#6365 | 0.19.2 |
| Time for X Resource Calculator | Comprehensive sheet that helps calculate time for X amount of resources (including multiple skills) and a combined clear time calculator for dungeons | Foxy#5937 | 0.18.2 |
| Can I Idle This? | Calculator for Damage Reduction requirements for doing Dungeons | Drboomtown#0982 | 0.17.0 |
| Bank Slot Cost Calculator | Calculates cost for bank slots based on current amount and desired amount | Aether#7777 | 0.16.3 |
| God Dungeon Money Making | Calculates GP/H from God Dungeons based on clear times | Breindahl#2660 | 0.16.3 |
| Melvor Alching Calculator | Calculates the shop price above which it's worth alching items vs. selling | Spectroscopy#9979 | 0.16.3 |
| Melvor Dragon Javelin Profit | Calculates profit from creating dragon javelins. Lots of options to configure! | Spectroscopy#9979 | 0.16.3 |
| Melvor Farming Seed Calculator | Calculates how many seeds you need to reach a particular mastery level | Spectroscopy#9979 | 0.16.3 |
| Seed Mastery | Amounts of herb and allotment seeds needed for it to become selfsustaining | JHawk55#8345 | 0.16.3 |
| Thieving Calculator | Calculates time to reach desired Thieving level based on selected target | Nomeru#4261 | 0.16.3 |
| Combat Leveling | Highest XP/HR Targets for Combat Leveling. | Trippledot | 0.16.1 |
| Endgame Weapon Comparison Thingamajig | Spreadsheet comparing DPS of all endgame weapons (All combat styles) | Trippledot | 0.16.1 |
| Elite Strength or Elite Glory | Comparison between Elite Strength and Elite Glory amulets | Trippledot | 0.15.4 |
| Fish Prep time vs HP Healed | Figure out what gives you the best food in a given time (HP/Second). | Levgre | 0.15.4 |
| Mastery Calculator | Calculator for how many tokens you need to max mastery. | Levgre#1415 | 0.15.4 |
| Melvor Idle Calculations | Calculator for various money making methods | Rhaelyx | 0.15.4 |
| Melvor Idle Calculators & Tools | A collection of calculators and tools | Alexiea#6630 NotArcanus#3825 | 0.15.4 |
| XP/HR Chart | Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels. | Trippledot | 0.15.4 |
| Slayer Skip list | Creates a monsterIDs Array based on ticked boxes and items equipped for use with SEMI | 8992#7954 Aurora Aquir#4272 | 0.15.2 |
How to Use?
Usually to use the spreadsheet it has to be copied into your own account (On Google Sheets via File->Make a copy). Then fill in the parts of the spreadsheet that is meant to be filled in (Should be differentiated from the rest).
| Melvor Idle version v1.3.1 (Released: 30th October 2024) |
|---|
Error creating thumbnail: File missing Combat: Error creating thumbnail: File missing Attack • Error creating thumbnail: File missing Strength • Error creating thumbnail: File missing Defence • Error creating thumbnail: File missing Hitpoints • Error creating thumbnail: File missing Ranged • Error creating thumbnail: File missing Magic • Error creating thumbnail: File missing Prayer • Error creating thumbnail: File missing Slayer • Error creating thumbnail: File missing Corruption
|
| Skills: Error creating thumbnail: File missing Farming • Error creating thumbnail: File missing Township • Error creating thumbnail: File missing Woodcutting • Error creating thumbnail: File missing Fishing • Error creating thumbnail: File missing Firemaking • Error creating thumbnail: File missing Cooking • Error creating thumbnail: File missing Mining • Error creating thumbnail: File missing Smithing • Error creating thumbnail: File missing Thieving • Error creating thumbnail: File missing Fletching • Error creating thumbnail: File missing Crafting • Error creating thumbnail: File missing Runecrafting • Error creating thumbnail: File missing Herblore • Error creating thumbnail: File missing Agility • Error creating thumbnail: File missing Summoning • Error creating thumbnail: File missing Astrology • Error creating thumbnail: File missing Alternative Magic • Error creating thumbnail: File missing Cartography • Error creating thumbnail: File missing Archaeology • Error creating thumbnail: File missing Harvesting
|
| Other: Error creating thumbnail: File missing Beginners Guide •  Guides • Error creating thumbnail: File missing Bank • Error creating thumbnail: File missing Combat • Error creating thumbnail: File missing Mastery • Error creating thumbnail: File missing Money Making • Error creating thumbnail: File missing Shop •  Easter Eggs •  Pets • Error creating thumbnail: File missing Golbin Raid • Error creating thumbnail: File missing Full Version •  Throne of the Herald •  Atlas of Discovery • Error creating thumbnail: File missing Into the Abyss
|
| Reference Tables: Items, Equipment, Experience Table, Upgrading Items, Combat Areas, Slayer Areas, Dungeons, Strongholds, The Abyss, Monsters |
