Spreadsheets and Theorycrafting: Difference between revisions

From Melvor Idle
m (Remove excessive whitespace)
(Update for v0.21; use Template:VColor)
Line 1: Line 1:
{{V|0.20}}
{{V|0.21}}
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 15: Line 15:
| 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]
| style="background-color:#E8FFEB;" | 0.20
{{VColor|0.21}}
|-
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc]
| Calculator for Dragon Javelin Money Making method
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
{{VColor|0.20}}
|-
|-
| [https://docs.google.com/spreadsheets/d/10vcxrmaPr3Ay8TZW3nZVyesFYojqxyJy5tfOblA50LQ Melvor Import Template]
| [https://docs.google.com/spreadsheets/d/10vcxrmaPr3Ay8TZW3nZVyesFYojqxyJy5tfOblA50LQ 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.
| 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.
| [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| style="background-color:#E8FFEB;" | 0.20
{{VColor|0.20}}
|-
|-
| [https://docs.google.com/spreadsheets/d/176i4mV1hIrjGO9jN8HbCZ8YbEOXMtojHA6cD-heMN4U Melvor Idle Corruption Calculator]
| [https://docs.google.com/spreadsheets/d/176i4mV1hIrjGO9jN8HbCZ8YbEOXMtojHA6cD-heMN4U Melvor Idle Corruption Calculator]
| Calculator for Chaos Mode Corruptions.
| Calculator for Chaos Mode Corruptions.
| [https://discordapp.com/users/267111261634822144 Hetaku#3546]
| [https://discordapp.com/users/267111261634822144 Hetaku#3546]
| style="background-color:#E8FFEB;" | 0.20
{{VColor|0.20}}
|-  
|-  
| [https://docs.google.com/spreadsheets/d/1fFsyHubwYfPPY15iAvrp4kPTXq2lGJ_JBouIb1oJHpQ Mining Companion]
| [https://docs.google.com/spreadsheets/d/1fFsyHubwYfPPY15iAvrp4kPTXq2lGJ_JBouIb1oJHpQ Mining Companion]
| Calculator for Mining, listing skill XP, GP, and resource gain per hour for each ore
| Calculator for Mining, listing skill XP, GP, and resource gain per hour for each ore
| [https://discordapp.com/users/256819070844796930 Xphan0z#6365]
| [https://discordapp.com/users/256819070844796930 Xphan0z#6365]
| style="background-color:#FFE8E8;" | 0.19.2
{{VColor|0.19.2}}
|-
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Jav Calc]
| Calculator for Dragon Javelin Money Making method
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.19.2
|-
|-
| [https://imgur.com/a/8JEtE6g HP Required Dungeon Charts]
| [https://imgur.com/a/8JEtE6g HP Required Dungeon Charts]
| Reference Chart for necessary DR and HP to idle dungeons
| Reference Chart for necessary DR and HP to idle dungeons
| [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| style="background-color:#FFE8E8;" | 0.18.2
{{VColor|0.18.2}}
|-
|-
| [https://docs.google.com/spreadsheets/d/15wc6RvTlrxFJ3h-KWSA7lR3yYtyA3j7Ouk51lltzabs Time for X Resource Calculator]
| [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
| Comprehensive sheet that helps calculate time for X amount of resources (including multiple skills) and a combined clear time calculator for dungeons
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.18.2
{{VColor|0.18.2}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1Y_U826Z02Ip0v2htIafAh-RwkrjLToyEspuXczAu7zU Can I Idle This?]
| [https://docs.google.com/spreadsheets/d/1Y_U826Z02Ip0v2htIafAh-RwkrjLToyEspuXczAu7zU Can I Idle This?]
| Calculator for Damage Reduction requirements for doing Dungeons
| Calculator for Damage Reduction requirements for doing Dungeons
| [https://discordapp.com/users/123658107690680322 Drboomtown#0982]
| [https://discordapp.com/users/123658107690680322 Drboomtown#0982]
| style="background-color:#FFE8E8;" | 0.17.0
{{VColor|0.17.0}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator]
| [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#7777
| Aether#7777
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://docs.google.com/spreadsheets/d/11gnKaLR4Cc_kPwYNuW4d2FpOwBJW9aoS_-ouX_HsVhQ God Dungeon Money Making]
| [https://docs.google.com/spreadsheets/d/11gnKaLR4Cc_kPwYNuW4d2FpOwBJW9aoS_-ouX_HsVhQ God Dungeon Money Making]
| Calculates GP/H from God Dungeons based on clear times
| Calculates GP/H from God Dungeons based on clear times
| [https://discordapp.com/users/190161169321951232 Breindahl#2660]
| [https://discordapp.com/users/190161169321951232 Breindahl#2660]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://docs.google.com/spreadsheets/d/15jtOEFXpiwrw4w934uiWcwhX0gbaMnZPytPx8jRnQgQ Melvor Alching Calculator]
| [https://docs.google.com/spreadsheets/d/15jtOEFXpiwrw4w934uiWcwhX0gbaMnZPytPx8jRnQgQ Melvor Alching Calculator]
| Calculates the shop price above which it's worth alching items vs. selling
| Calculates the shop price above which it's worth alching items vs. selling
| [https://discordapp.com/users/611609252695375883 Spectroscopy#9979]
| [https://discordapp.com/users/611609252695375883 Spectroscopy#9979]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://docs.google.com/spreadsheets/d/19v7esGmm7w0X-VIMMsOsaS9vFy5JTCDNeNa5mm5CztY Melvor Dragon Javelin Profit]
| [https://docs.google.com/spreadsheets/d/19v7esGmm7w0X-VIMMsOsaS9vFy5JTCDNeNa5mm5CztY Melvor Dragon Javelin Profit]
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Calculates profit from creating dragon javelins. Lots of options to configure!
| [https://discordapp.com/users/611609252695375883 Spectroscopy#9979]
| [https://discordapp.com/users/611609252695375883 Spectroscopy#9979]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1atMfJZXYqiWflIavX1EFY48SRFN1h7IbdaFYkRfrkew Melvor Farming Seed Calculator]
| [https://docs.google.com/spreadsheets/d/1atMfJZXYqiWflIavX1EFY48SRFN1h7IbdaFYkRfrkew Melvor Farming Seed Calculator]
| Calculates how many seeds you need to reach a particular mastery level
| Calculates how many seeds you need to reach a particular mastery level
| [https://discordapp.com/users/611609252695375883 Spectroscopy#9979]
| [https://discordapp.com/users/611609252695375883 Spectroscopy#9979]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1m0RWhdF-oqrIoyq-RJJzkD_yISwjeE-ThuRV_ztvf6A Seed Mastery]
| [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
| Amounts of herb and allotment seeds needed for it to become selfsustaining
| [https://discordapp.com/users/310577881803784202 JHawk55#8345]
| [https://discordapp.com/users/310577881803784202 JHawk55#8345]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1ltY-h5FtP99H-X-naMsI1KRTTBkrqK-2bys9jqEOpww Thieving Calculator]
| [https://docs.google.com/spreadsheets/d/1ltY-h5FtP99H-X-naMsI1KRTTBkrqK-2bys9jqEOpww Thieving Calculator]
| Calculates time to reach desired Thieving level based on selected target  
| Calculates time to reach desired Thieving level based on selected target  
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.16.3}}
|-
|-
| [https://imgur.com/a/AmPxfz0 Combat Leveling]
| [https://imgur.com/a/AmPxfz0 Combat Leveling]
| Highest XP/HR Targets for Combat Leveling.
| Highest XP/HR Targets for Combat Leveling.
| Trippledot
| Trippledot
| style="background-color:#FFE8E8;" | 0.16.1
{{VColor|0.16.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1GIbmSDIvYrk3Xnewr_ZXvGhH_Rf-L9MwYVHaCmq9QOY Endgame Weapon Comparison Thingamajig]
| [https://docs.google.com/spreadsheets/d/1GIbmSDIvYrk3Xnewr_ZXvGhH_Rf-L9MwYVHaCmq9QOY Endgame Weapon Comparison Thingamajig]
| Spreadsheet comparing DPS of all endgame weapons (All combat styles)
| Spreadsheet comparing DPS of all endgame weapons (All combat styles)
| Trippledot
| Trippledot
| style="background-color:#FFE8E8;" | 0.16.1
{{VColor|0.16.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1r5MwwMu1hXV3jtDqD4R3AEgW6mVE4fE6Jw3yLm4escs Elite Strength or Elite Glory]
| [https://docs.google.com/spreadsheets/d/1r5MwwMu1hXV3jtDqD4R3AEgW6mVE4fE6Jw3yLm4escs Elite Strength or Elite Glory]
| Comparison between Elite Strength and Elite Glory amulets
| Comparison between Elite Strength and Elite Glory amulets
| Trippledot
| Trippledot
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.15.4}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1hV9l3XIY_ekigPbIi_o8bVvd3RDDxs-8dFJ7xMkw8OA Fish Prep time vs HP Healed]
| [https://docs.google.com/spreadsheets/d/1hV9l3XIY_ekigPbIi_o8bVvd3RDDxs-8dFJ7xMkw8OA Fish Prep time vs HP Healed]
| Figure out what gives you the best food in a given time (HP/Second).
| Figure out what gives you the best food in a given time (HP/Second).
| [https://discordapp.com/users/227002148737515520 Levgre]
| [https://discordapp.com/users/227002148737515520 Levgre]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.15.4}}
|-
|-
| [https://levgre.itch.io/mastery-calculator Mastery Calculator]
| [https://levgre.itch.io/mastery-calculator Mastery Calculator]
| Calculator for how many tokens you need to max mastery.
| Calculator for how many tokens you need to max mastery.
| [https://discordapp.com/users/227002148737515520 Levgre#1415]
| [https://discordapp.com/users/227002148737515520 Levgre#1415]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.15.4}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1Dsm8YHwCKPd2jpiS1KcVzV3y5UbjNi7N-QJmuSbrDoY Melvor Idle Calculations]
| [https://docs.google.com/spreadsheets/d/1Dsm8YHwCKPd2jpiS1KcVzV3y5UbjNi7N-QJmuSbrDoY Melvor Idle Calculations]
| Calculator for various money making methods
| Calculator for various money making methods
| [https://discordapp.com/users/192688009252962304 Rhaelyx]
| [https://discordapp.com/users/192688009252962304 Rhaelyx]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.15.4}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1w4gX26OMkTqAiO5L6wGYEaAoGOqM4G5vKf50DVwpRQI Melvor Idle Calculators & Tools]
| [https://docs.google.com/spreadsheets/d/1w4gX26OMkTqAiO5L6wGYEaAoGOqM4G5vKf50DVwpRQI Melvor Idle Calculators & Tools]
| A collection of calculators and tools
| A collection of calculators and tools
| Alexiea#6630<br/>[https://discordapp.com/users/615898740607156234 NotArcanus#3825]
| Alexiea#6630<br/>[https://discordapp.com/users/615898740607156234 NotArcanus#3825]
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.15.4}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1pO5SOdBmZAQHJJsemO686Bn45iI9nQF06rlbbAwk4BU XP/HR Chart]
| [https://docs.google.com/spreadsheets/d/1pO5SOdBmZAQHJJsemO686Bn45iI9nQF06rlbbAwk4BU XP/HR Chart]
| Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels.
| Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels.
| Trippledot
| Trippledot
| style="background-color:#FFE8E8;" | 0.15.4
{{VColor|0.15.4}}
|-
|-
| [https://docs.google.com/spreadsheets/d/15aU6FNP3FoUHH61fDb-47tL3PHerCtHPR-ZC43HEuuk Slayer Skip list]
| [https://docs.google.com/spreadsheets/d/15aU6FNP3FoUHH61fDb-47tL3PHerCtHPR-ZC43HEuuk Slayer Skip list]
| Creates a monsterIDs Array based on ticked boxes and items equipped for use with [[Scripting_and_Extensions|SEMI]]
| Creates a monsterIDs Array based on ticked boxes and items equipped for use with [[Scripting_and_Extensions|SEMI]]
| [https://discordapp.com/users/266517729131888640 8992#7954]<br/>[https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| [https://discordapp.com/users/266517729131888640 8992#7954]<br/>[https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| style="background-color:#FFE8E8;" | 0.15.2
{{VColor|0.15.2}}
|}
|}


Revision as of 11:18, 14 September 2021

This page was last updated for (v0.21).

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 0.21
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
HP Required Dungeon Charts Reference Chart for necessary DR and HP to idle dungeons Aurora Aquir#4272 0.18.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
Retrieved from "https://testwiki.melvoridle.com/index.php?title=Spreadsheets_and_Theorycrafting&oldid=46345"