Spreadsheets and Theorycrafting: Difference between revisions

From Melvor Idle
(remove many dated sheets/dead links →‎List of Spreadsheets)
(43 intermediate revisions by 9 users not shown)
Line 1: Line 1:
{{V|0.18.0}}
<!--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/1iOafXHZponuxGm-p95sHLGQpanVtetCnL8h9kjFFX18 Melvor Idle Rate & Resource Calculator]
| Calculator for Dragon Javelin Money Making method
| Comprehensive sheet that helps calculate time, gain and resource usage till some level.
| Nomeru
| [https://discordapp.com/users/564658310272516098 Kidbiz20#2026]
| style="background-color:#E8FFEB;" | 0.18.2
{{VColor|1.1.1}}
|-
| [https://imgur.com/a/8JEtE6g HP Required Dungeon Charts]
| Reference Chart for necessary DR and HP to idle dungeons
| Aurora Aquir#4272
| style="background-color:#E8FFEB;" | 0.18.2
|-
|-
| [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]
| [https://docs.google.com/spreadsheets/d/1-AJnjTeWfqMS2jBu5h5Xvk-ASCdDoCDd9EEyXvk0wUI Township Spreadsheet]
| Calculator for Damage Reduction requirements for doing Dungeons
| Contains a number of town templates for achieving optimal XP & GP rates, plus blank templates for designing your own town. Also has a few Township focused reference tables, calculators, and links to other guides.
| Boomtown
| [https://discordapp.com/users/262460368645914625 Spitzer#3603]
| style="background-color:#FFE8E8;" | 0.17.0
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator]
| [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table]
| Calculates cost for bank slots based on current amount and desired amount
| Experience/Level table and lookup up to level 1999.
| Aether
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/11gnKaLR4Cc_kPwYNuW4d2FpOwBJW9aoS_-ouX_HsVhQ God Dungeon Money Making]
| [https://docs.google.com/spreadsheets/d/1gqvUroU6IDaUJMHzeuJvtMoRImCNFyYnWR5IhzT-C1A/edit?usp=sharing Signet A Drop Chance]
| Calculates GP/H from God Dungeons based on clear times
| Shows [[Signet Ring Half (a)]] drop chance for every skilling action.
| Breindahl
| [https://discordapp.com/users/483005368587386905 Foxy#5937]<br/>[https://discordapp.com/users/156771111239942144 <nowiki>mazunki [they/them]#3247</nowiki>]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.1.1}}
|-
|-
| [https://docs.google.com/spreadsheets/d/15jtOEFXpiwrw4w934uiWcwhX0gbaMnZPytPx8jRnQgQ Melvor Alching Calculator]
| [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s]
| Calculates the shop price above which it's worth alching items vs. selling
| Healing values from cooking, fishing, and farming. Accounts for all modifiers.
| Spectroscopy
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/19v7esGmm7w0X-VIMMsOsaS9vFy5JTCDNeNa5mm5CztY Melvor Dragon Javelin Profit]
| [https://docs.google.com/spreadsheets/d/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy]
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Raw comparison of additional Hidden Levels against Global Accuracy.
| Spectroscopy
| [https://discordapp.com/users/483005368587386905 Foxy#5937]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1atMfJZXYqiWflIavX1EFY48SRFN1h7IbdaFYkRfrkew Melvor Farming Seed Calculator]
| [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables]
| Calculates how many seeds you need to reach a particular mastery level
| 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].
| Spectroscopy
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1m0RWhdF-oqrIoyq-RJJzkD_yISwjeE-ThuRV_ztvf6A Seed Mastery]
| [https://docs.google.com/spreadsheets/d/1iRPDZznC5HizeWyyADt7bymFMWxN_jzFP1dGl8Xa4P4 Thieving GP Calculator]
| Amounts of herb and allotment seeds needed for it to become selfsustaining
| Calculates GP per hour rates for Thieving.
| JHawk55
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|1.0.5}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1ltY-h5FtP99H-X-naMsI1KRTTBkrqK-2bys9jqEOpww Thieving Calculator]
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc]
| Calculates time to reach desired Thieving level based on selected target
| Calculator for Dragon Javelin Money Making method
| Nomeru
| [https://discordapp.com/users/91970544789897216 Nomeru#4261]
| style="background-color:#FFE8E8;" | 0.16.3
{{VColor|0.20}}
|-
|-
| [https://docs.google.com/spreadsheets/d/15wc6RvTlrxFJ3h-KWSA7lR3yYtyA3j7Ouk51lltzabs Time for X Resource Calculator]
| [https://docs.google.com/spreadsheets/d/10vcxrmaPr3Ay8TZW3nZVyesFYojqxyJy5tfOblA50LQ Melvor Import Template]
| Comprehensive sheet that helps calculate time for X amount of resources (including multiple skills) and a combined clear time calculator for dungeons
| 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.
| Foxy
| [https://discordapp.com/users/185851310308982804 Aurora Aquir#4272]
| style="background-color:#E8FFEB;" | 0.18.2
{{VColor|0.20}}
|-
|-
| [https://imgur.com/a/AmPxfz0 Combat Leveling]
| [https://docs.google.com/spreadsheets/d/176i4mV1hIrjGO9jN8HbCZ8YbEOXMtojHA6cD-heMN4U Melvor Idle Corruption Calculator]
| Highest XP/HR Targets for Combat Leveling.
| Calculator for Chaos Mode Corruptions.
| Trippledot
| [https://discordapp.com/users/267111261634822144 Hetaku#3546]
| style="background-color:#FFE8E8;" | 0.16.1
{{VColor|0.20}}
|-
|-
| [https://docs.google.com/spreadsheets/d/1GIbmSDIvYrk3Xnewr_ZXvGhH_Rf-L9MwYVHaCmq9QOY Endgame Weapon Comparison Thingamajig]
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator]
| Spreadsheet comparing DPS of all endgame weapons (All combat styles)
| Calculates cost for bank slots based on current amount and desired amount
| Trippledot
| Aether#7777
| style="background-color:#FFE8E8;" | 0.16.1
{{VColor|0.16.3}}
|-
| [https://docs.google.com/spreadsheets/d/1r5MwwMu1hXV3jtDqD4R3AEgW6mVE4fE6Jw3yLm4escs Elite Strength or Elite Glory]
| Comparison between Elite Strength and Elite Glory amulets
| Trippledot
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [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).
| Levgre
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [https://levgre.itch.io/mastery-calculator Mastery Calculator]
| Calculator for how many tokens you need to max mastery.
| Levgre
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [https://docs.google.com/spreadsheets/d/1Dsm8YHwCKPd2jpiS1KcVzV3y5UbjNi7N-QJmuSbrDoY Melvor Idle Calculations]
| Calculator for various money making methods
| Rhaelyx
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [https://docs.google.com/spreadsheets/d/1w4gX26OMkTqAiO5L6wGYEaAoGOqM4G5vKf50DVwpRQI Melvor Idle Calculators & Tools]
| A collection of calculators and tools
| Alexiea#6630 and NotArcanus#3825
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [https://docs.google.com/spreadsheets/d/1pO5SOdBmZAQHJJsemO686Bn45iI9nQF06rlbbAwk4BU XP/HR Chart]
| Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels.
| Trippledot
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [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]]
| 8892/Aurora
| style="background-color:#FFE8E8;" | 0.15.2
|}
|}


Revision as of 22:45, 13 February 2023

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
Melvor Idle Rate & Resource Calculator Comprehensive sheet that helps calculate time, gain and resource usage till some level. Kidbiz20#2026 1.1.1
Township Spreadsheet Contains a number of town templates for achieving optimal XP & GP rates, plus blank templates for designing your own town. Also has a few Township focused reference tables, calculators, and links to other guides. Spitzer#3603 1.1.1
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
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
Thieving GP Calculator Calculates GP per hour rates for Thieving. Nomeru#4261 1.0.5
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
Bank Slot Cost Calculator Calculates cost for bank slots based on current amount and desired amount Aether#7777 0.16.3

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.2.2 (Released: 15th November 2023)
Combat:
Attack (skill).svg Attack
Strength (skill).svg Strength
Defence (skill).svg Defence
Hitpoints (skill).svg Hitpoints
Ranged (skill).svg Ranged
Magic (skill).svg Magic
Prayer (skill).svg Prayer
Slayer (skill).svg Slayer
Skills:
Woodcutting (skill).svg Woodcutting
Fishing (skill).svg Fishing
Firemaking (skill).svg Firemaking
Cooking (skill).svg Cooking
Mining (skill).svg Mining
Smithing (skill).svg Smithing
Thieving (skill).svg Thieving
Farming (skill).svg Farming
Fletching (skill).svg Fletching
Crafting (skill).svg Crafting
Runecrafting (skill).svg Runecrafting
Herblore (skill).svg Herblore
Agility (skill).svg Agility
Summoning (skill).svg Summoning
Astrology (skill).svg Astrology
Township (skill).svg Township
Cartography (skill).svg Cartography
Archaeology (skill).svg Archaeology
Alternative Magic (skill).svg Alternative Magic
Other:
Beginners Guide
Guides
Bank
Combat
Mastery
Money Making
Shop
Easter Eggs
Pets
Golbin Raid
Full Version
Throne of the Herald
Atlas of Discovery
Reference Tables: Items, Equipment, Experience Table, Upgrading Items, Combat Areas, Slayer Areas, Dungeons, Chest Loot Tables, Monsters, Monster Loot Tables
Retrieved from "https://wiki.melvoridle.com/index.php?title=Spreadsheets_and_Theorycrafting&oldid=60488"