Spreadsheets and Theorycrafting: Difference between revisions

Updated versions & sort by version desc, name asc
(Replaced Nomeru's dragon javelin calculator with 0.17 compatible version)
(Updated versions & sort by version desc, name asc)
Line 1: Line 1:
{{V0.16.3}}
{{V|0.18.0}}
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:
| Calculator for Dragon Javelin Money Making method  
| Calculator for Dragon Javelin Money Making method  
| Nomeru  
| Nomeru  
| style="background-color:#E8FFEB;" | 0.17
| style="background-color:#E8FFEB;" | 0.18.2
|-
|-
| [https://docs.google.com/spreadsheets/d/19v7esGmm7w0X-VIMMsOsaS9vFy5JTCDNeNa5mm5CztY Melvor Dragon Javelin Profit]
| [https://imgur.com/a/8JEtE6g HP Required Dungeon Charts]
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Reference Chart for necessary DR and HP to idle dungeons
| Spectroscopy
| 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]
| Calculator for Damage Reduction requirements for doing Dungeons
| Boomtown
| style="background-color:#FFE8E8;" | 0.17.0
|-
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator]
| Calculates cost for bank slots based on current amount and desired amount
| Aether
| style="background-color:#FFE8E8;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
| [https://docs.google.com/spreadsheets/d/1atMfJZXYqiWflIavX1EFY48SRFN1h7IbdaFYkRfrkew Melvor Farming Seed Calculator]
| [https://docs.google.com/spreadsheets/d/11gnKaLR4Cc_kPwYNuW4d2FpOwBJW9aoS_-ouX_HsVhQ God Dungeon Money Making]
| Calculates how many seeds you need to reach a particular mastery level
| Calculates GP/H from God Dungeons based on clear times
| Spectroscopy
| Breindahl
| style="background-color:#FFE8E8;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
Line 32: Line 42:
| style="background-color:#FFE8E8;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
| [https://docs.google.com/spreadsheets/d/15wc6RvTlrxFJ3h-KWSA7lR3yYtyA3j7Ouk51lltzabs Time for X Resource Calculator]
| [https://docs.google.com/spreadsheets/d/19v7esGmm7w0X-VIMMsOsaS9vFy5JTCDNeNa5mm5CztY Melvor Dragon Javelin Profit]
| Comprehensive sheet that helps calculate time for X amount of resources (including multiple skills) and a combined clear time calculator for dungeons
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Foxy
| 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
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
Line 40: Line 55:
| Amounts of herb and allotment seeds needed for it to become selfsustaining
| Amounts of herb and allotment seeds needed for it to become selfsustaining
| JHawk55
| 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
| style="background-color:#FFE8E8;" | 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 decired Thieving level based on selected target  
| Calculates time to reach desired Thieving level based on selected target  
| Nomeru
| Nomeru
| style="background-color:#FFE8E8;" | 0.16.3
| 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]
| [https://docs.google.com/spreadsheets/d/15wc6RvTlrxFJ3h-KWSA7lR3yYtyA3j7Ouk51lltzabs Time for X Resource Calculator]
| Calculator for Damage Reduction requirements for doing Dungeons
| Comprehensive sheet that helps calculate time for X amount of resources (including multiple skills) and a combined clear time calculator for dungeons
| Boomtown
| Foxy
| 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
| Aether
| style="background-color:#FFE8E8;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
Line 77: Line 77:
| style="background-color:#FFE8E8;" | 0.16.1
| style="background-color:#FFE8E8;" | 0.16.1
|-
|-
| [https://docs.google.com/spreadsheets/d/1pO5SOdBmZAQHJJsemO686Bn45iI9nQF06rlbbAwk4BU XP/HR Chart]
| [https://docs.google.com/spreadsheets/d/1r5MwwMu1hXV3jtDqD4R3AEgW6mVE4fE6Jw3yLm4escs Elite Strength or Elite Glory]
| Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels.
| Comparison between Elite Strength and Elite Glory amulets
| Trippledot
| Trippledot
| style="background-color:#FFE8E8;" | 0.15.4
| style="background-color:#FFE8E8;" | 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).
Line 91: Line 90:
| Calculator for how many tokens you need to max mastery.
| Calculator for how many tokens you need to max mastery.
| Levgre
| Levgre
| style="background-color:#FFE8E8;" | 0.15.4
|-
| [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
| style="background-color:#FFE8E8;" | 0.15.4
|-
|-
Line 106: Line 100:
| A collection of calculators and tools
| A collection of calculators and tools
| Alexiea#6630 and NotArcanus#3825
| 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
| style="background-color:#FFE8E8;" | 0.15.4
|-
|-
Line 115: Line 114:


== 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]]