Spreadsheets and Theorycrafting: Difference between revisions

From Melvor Idle
(Added many new spreadsheets)
(→‎List of Spreadsheets: Removed dead spreadsheet and old save system one)
 
(66 intermediate revisions by 13 users not shown)
Line 1: Line 1:
{{V0.16.1}}
<!--No version number since version is per tool/script
-->{{Otheruses|listing spreadsheets and spreadsheet based calculators|scripts, extensions, and other tools|Scripting and Extensions}}
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 [https://discord.gg/KNakXTh Melvor Idle Discord].
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 [https://discord.gg/KNakXTh Melvor Idle Discord].


Line 5: Line 6:


== List of Spreadsheets ==
== List of Spreadsheets ==
{| class="wikitable sortable"
{| class="wikitable sortable stickyHeader"
|-
|- class="headerRow-0"
! Name
! Name
! Description
! Description
Line 12: Line 13:
! Version
! Version
|-
|-
| [https://docs.google.com/spreadsheets/d/11gnKaLR4Cc_kPwYNuW4d2FpOwBJW9aoS_-ouX_HsVhQ God Dungeon Money Making]
| [https://docs.google.com/spreadsheets/d/1iOafXHZponuxGm-p95sHLGQpanVtetCnL8h9kjFFX18 Melvor Idle Rate & Resource Calculator]
| Calculates GP/H from God Dungeons based on clear times
| Comprehensive sheet that helps calculate time, gain and resource usage till some level.
| Breindahl
| [https://discordapp.com/users/564658310272516098 Kidbiz20#2026]
| style="background-color:#E8FFEB;" | 0.16.1
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1ERtAoeE5j61RwtndHKFne7cRk4Q-JqfWW7SnCkJ7k1Y Dragon Jav and Plate Calc]
| [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table]
| Calculator for Dragon Javelin and Dragon Platebody Money Making methods
| Experience/Level table and lookup up to level 1999.
| Nomeru
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#E8FFEB;" | 0.16.1
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1Y_U826Z02Ip0v2htIafAh-RwkrjLToyEspuXczAu7zU Can I Idle This?]
| [https://docs.google.com/spreadsheets/d/1gqvUroU6IDaUJMHzeuJvtMoRImCNFyYnWR5IhzT-C1A/edit?usp=sharing Signet A Drop Chance]
| Calculator for Damage Reduction requirements for doing Dungeons
| Shows [[Signet Ring Half (a)]] drop chance for every skilling action.
| Boomtown
| [https://discordapp.com/users/483005368587386905 Foxy#5937]<br/>[https://discordapp.com/users/156771111239942144 <nowiki>mazunki [they/them]#3247</nowiki>]
| style="background-color:#E8FFEB;" | 0.16.1
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1pO5SOdBmZAQHJJsemO686Bn45iI9nQF06rlbbAwk4BU XP/HR Chart]
| [https://docs.google.com/spreadsheets/d/1caJNSMYi6fjqEpSe3vhU4MXgqimAy8JePyk-NqXoKjY Thieving GP Calculator]
| Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels.
| Calculates GP per hour rates for Thieving. Based on [https://docs.google.com/spreadsheets/d/1iRPDZznC5HizeWyyADt7bymFMWxN_jzFP1dGl8Xa4P4 the original spreadsheet] created by [https://discordapp.com/users/91970544789897216 Nomeru#4261].
| Trippledot
| geedunk#3987
| style="background-color:#E8FFEB;" | 0.16.1
{{VColor|1.1.1}}
|-
|-
| [https://imgur.com/a/G8pI0nS HP Required Dungeon Charts]
| [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s]
| Reference Chart for necessary DR and HP to idle dungeons
| Healing values from cooking, fishing, and farming. Accounts for all modifiers.
| Aurora Aquir#4272
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#E8FFEB;" | 0.16.1
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1hV9l3XIY_ekigPbIi_o8bVvd3RDDxs-8dFJ7xMkw8OA Fish Prep time vs HP Healed]
| [https://docs.google.com/spreadsheets/d/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy]
| Figure out what gives you the best food in a given time (HP/Second).
| Raw comparison of additional Hidden Levels against Global Accuracy.
| Levgre
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|1.0.5}}
|-
|-
| [https://levgre.itch.io/mastery-calculator Mastery Calculator]
| [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables]
| Calculator for how many tokens you need to max mastery.
| 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].
| Levgre
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1r5MwwMu1hXV3jtDqD4R3AEgW6mVE4fE6Jw3yLm4escs Elite Strength or Elite Glory]
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc]
| Comparison between Elite Strength and Elite Glory amulets
| Calculator for Dragon Javelin Money Making method
| Trippledot
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.20}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1Dsm8YHwCKPd2jpiS1KcVzV3y5UbjNi7N-QJmuSbrDoY Melvor Idle Calculations]
| [https://docs.google.com/spreadsheets/d/176i4mV1hIrjGO9jN8HbCZ8YbEOXMtojHA6cD-heMN4U Melvor Idle Corruption Calculator]
| Calculator for various money making methods
| Calculator for Chaos Mode Corruptions.
| Rhaelyx
| [https://discordapp.com/users/267111261634822144 Hetaku#3546]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.20}}
|-
|-
| [https://docs.google.com/spreadsheets/d/15aU6FNP3FoUHH61fDb-47tL3PHerCtHPR-ZC43HEuuk Slayer Skip list]
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator]
| Creates a monsterIDs Array based on ticked boxes and items equipped for use with [[Scripting_and_Extensions|SEMI]]
| Calculates cost for bank slots based on current amount and desired amount
| 8892/Aurora
| Aether#7777
| style="background-color:#FFE8E8;" | 0.15.2
{{VColor|0.16.3}}
|}
|}


== How to Use? ==
== How to Use? ==
Usually to use the spreadsheet it has to be copied into your own account (On googlesheets via File->Make a copy).
Usually to use the spreadsheet it has to be copied into your own account (On [https://www.google.co.uk/sheets/about/ 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).
Then fill in the parts of the spreadsheet that is meant to be filled in (Should be differentiated from the rest).


{{Menu}}
{{Menu}}
[[Category:Guides]]
[[Category:Guides]]

Latest revision as of 22:32, 18 March 2024

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

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).