Spreadsheets and Theorycrafting: Difference between revisions

From Melvor Idle
(Replaced Nomeru's dragon javelin calculator with 0.17 compatible version)
m (Update versions)
 
(48 intermediate revisions by 10 users not shown)
Line 1: Line 1:
{{V0.16.3}}
<!--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/1mRHezrM3r8Xto_EmInI61m1SpdjbH4qxl2yfMra08xo Dragon Jav Calc]
| [https://docs.google.com/spreadsheets/d/1hfNEleLT6LhQXgILBKgT6OkdRPWUO6_oO0O8ELdAe3A Bank Slot Cost Calculator]
| Calculator for Dragon Javelin Money Making method
| Nomeru
| style="background-color:#E8FFEB;" | 0.17
|-
| [https://docs.google.com/spreadsheets/d/19v7esGmm7w0X-VIMMsOsaS9vFy5JTCDNeNa5mm5CztY Melvor Dragon Javelin Profit]
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Spectroscopy
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/1atMfJZXYqiWflIavX1EFY48SRFN1h7IbdaFYkRfrkew Melvor Farming Seed Calculator]
| Calculates how many seeds you need to reach a particular mastery level
| Spectroscopy
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/15jtOEFXpiwrw4w934uiWcwhX0gbaMnZPytPx8jRnQgQ Melvor Alching Calculator]
| Calculates the shop price above which it's worth alching items vs. selling
| Spectroscopy
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/15wc6RvTlrxFJ3h-KWSA7lR3yYtyA3j7Ouk51lltzabs 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
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/1m0RWhdF-oqrIoyq-RJJzkD_yISwjeE-ThuRV_ztvf6A Seed Mastery]
| Amounts of herb and allotment seeds needed for it to become selfsustaining
| JHawk55
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/11gnKaLR4Cc_kPwYNuW4d2FpOwBJW9aoS_-ouX_HsVhQ God Dungeon Money Making]
| Calculates GP/H from God Dungeons based on clear times
| Breindahl
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/1ltY-h5FtP99H-X-naMsI1KRTTBkrqK-2bys9jqEOpww Thieving Calculator]
| Calculates time to reach decired Thieving level based on selected target
| Nomeru
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/1Y_U826Z02Ip0v2htIafAh-RwkrjLToyEspuXczAu7zU Can I Idle This?]<br>[https://drboomtown.github.io/?hp=1000&dr=29&ae=3&style=Melee&mode=Normal Can I Idle This? Web App]
| Calculator for Damage Reduction requirements for doing Dungeons
| Boomtown
| style="background-color:#E8FFEB;" | 0.17
|-
| [https://imgur.com/a/lgRkT4f HP Required Dungeon Charts]
| Reference Chart for necessary DR and HP to idle dungeons
| Aurora Aquir#4272
| style="background-color:#FFE8E8;" | 0.16.3
|-
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator]
| Calculates cost for bank slots based on current amount and desired amount
| Calculates cost for bank slots based on current amount and desired amount
| Aether
| starrazer<br/>Aether#7777
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.3.1}}
|-
|-
| [https://imgur.com/a/AmPxfz0 Combat Leveling]
| [https://docs.google.com/spreadsheets/d/1iOafXHZponuxGm-p95sHLGQpanVtetCnL8h9kjFFX18 Melvor Idle Rate & Resource Calculator]
| Highest XP/HR Targets for Combat Leveling.
| Comprehensive sheet that helps calculate time, gain and resource usage till some level.
| Trippledot
| [https://discordapp.com/users/564658310272516098 Kidbiz20#2026]
| style="background-color:#FFE8E8;" | 0.16.1
{{VColor|1.2}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1GIbmSDIvYrk3Xnewr_ZXvGhH_Rf-L9MwYVHaCmq9QOY Endgame Weapon Comparison Thingamajig]
| [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table]
| Spreadsheet comparing DPS of all endgame weapons (All combat styles)
| Experience/Level table and lookup up to level 1999.
| Trippledot
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.16.1
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1pO5SOdBmZAQHJJsemO686Bn45iI9nQF06rlbbAwk4BU XP/HR Chart]
| [https://docs.google.com/spreadsheets/d/1gqvUroU6IDaUJMHzeuJvtMoRImCNFyYnWR5IhzT-C1A/edit?usp=sharing Signet A Drop Chance]
| Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels.
| Shows [[Signet Ring Half (a)]] drop chance for every skilling action.
| Trippledot
| [https://discordapp.com/users/483005368587386905 Foxy#5937]<br/>[https://discordapp.com/users/156771111239942144 <nowiki>mazunki [they/them]#3247</nowiki>]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|1.1.1}}
|-
|-
 
| [https://docs.google.com/spreadsheets/d/1caJNSMYi6fjqEpSe3vhU4MXgqimAy8JePyk-NqXoKjY Thieving GP Calculator]
| [https://docs.google.com/spreadsheets/d/1hV9l3XIY_ekigPbIi_o8bVvd3RDDxs-8dFJ7xMkw8OA Fish Prep time vs HP Healed]
| 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].
| Figure out what gives you the best food in a given time (HP/Second).
| geedunk#3987
| Levgre
{{VColor|1.1.1}}
| style="background-color:#FFE8E8;" | 0.15.4
|-
|-
| [https://levgre.itch.io/mastery-calculator Mastery Calculator]
| [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s]
| Calculator for how many tokens you need to max mastery.
| Healing values from cooking, fishing, and farming. Accounts for all modifiers.
| Levgre
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| 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/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy]
| Comparison between Elite Strength and Elite Glory amulets
| Raw comparison of additional Hidden Levels against Global Accuracy.
| Trippledot
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1Dsm8YHwCKPd2jpiS1KcVzV3y5UbjNi7N-QJmuSbrDoY Melvor Idle Calculations]
| [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables]
| Calculator for various money making methods
| 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].
| Rhaelyx
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1w4gX26OMkTqAiO5L6wGYEaAoGOqM4G5vKf50DVwpRQI Melvor Idle Calculators & Tools]
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc]
| A collection of calculators and tools
| Calculator for Dragon Javelin Money Making method
| Alexiea#6630 and NotArcanus#3825
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| 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/176i4mV1hIrjGO9jN8HbCZ8YbEOXMtojHA6cD-heMN4U Melvor Idle Corruption Calculator]
| Creates a monsterIDs Array based on ticked boxes and items equipped for use with [[Scripting_and_Extensions|SEMI]]
| Calculator for Chaos Mode Corruptions.
| 8892/Aurora
| [https://discordapp.com/users/267111261634822144 Hetaku#3546]
| style="background-color:#FFE8E8;" | 0.15.2
{{VColor|0.20}}
|}
|}


== 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 20:28, 3 March 2025

This article is about listing spreadsheets and spreadsheet based calculators. For scripts, extensions, and other tools, see 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 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
Bank Slot Cost Calculator Calculates cost for bank slots based on current amount and desired amount starrazer
Aether#7777 		1.3.1
Melvor Idle Rate & Resource Calculator Comprehensive sheet that helps calculate time, gain and resource usage till some level. Kidbiz20#2026 1.2
Experience Table Experience/Level table and lookup up to level 1999. Foxy#5937 1.1.1
Signet A Drop Chance Shows Signet Ring Half (a) drop chance for every skilling action. Foxy#5937
mazunki [they/them]#3247 		1.1.1
Thieving GP Calculator Calculates GP per hour rates for Thieving. Based on the original spreadsheet created by Nomeru#4261. geedunk#3987 1.1.1
Cooking HP/s Healing values from cooking, fishing, and farming. Accounts for all modifiers. Foxy#5937 1.0.5
Hidden Levels vs % Global/Style Accuracy Raw comparison of additional Hidden Levels against Global Accuracy. Foxy#5937 1.0.5
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.5
Dragon Javelin Calc Calculator for Dragon Javelin Money Making method Nomeru#4261 0.20
Melvor Idle Corruption Calculator Calculator for Chaos Mode Corruptions. Hetaku#3546 0.20

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
Retrieved from "https://testwiki.melvoridle.com/index.php?title=Spreadsheets_and_Theorycrafting&oldid=85473"