Spreadsheets and Theorycrafting: Difference between revisions

From Melvor Idle
m (version change- boomtown)
(marked v0.16 compatible spreadsheets as potentially outdated)
Line 15: Line 15:
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Calculates profit from creating dragon javelins. Lots of options to configure!
| Spectroscopy
| Spectroscopy
| style="background-color:#E8FFEB;" | 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/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
| Spectroscopy
| Spectroscopy
| style="background-color:#E8FFEB;" | 0.16.3
| style="background-color:#FFE8E8;" | 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
| Spectroscopy
| Spectroscopy
| style="background-color:#E8FFEB;" | 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/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
| Foxy
| Foxy
| style="background-color:#E8FFEB;" | 0.16.3
| style="background-color:#FFE8E8;" | 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
| JHawk55
| JHawk55
| style="background-color:#E8FFEB;" | 0.16.3
| style="background-color:#FFE8E8;" | 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
| Breindahl
| Breindahl
| style="background-color:#E8FFEB;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
| [https://docs.google.com/spreadsheets/d/1ERtAoeE5j61RwtndHKFne7cRk4Q-JqfWW7SnCkJ7k1Y Dragon Jav and Plate Calc]
| [https://docs.google.com/spreadsheets/d/1ERtAoeE5j61RwtndHKFne7cRk4Q-JqfWW7SnCkJ7k1Y Dragon Jav and Plate Calc]
| Calculator for Dragon Javelin and Dragon Platebody Money Making methods
| Calculator for Dragon Javelin and Dragon Platebody Money Making methods
| Nomeru
| Nomeru
| style="background-color:#E8FFEB;" | 0.16.2
| style="background-color:#FFE8E8;" | 0.16.2
|-
|-
| [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 decired Thieving level based on selected target  
| Nomeru
| Nomeru
| style="background-color:#E8FFEB;" | 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/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]
Line 60: Line 60:
| Reference Chart for necessary DR and HP to idle dungeons
| Reference Chart for necessary DR and HP to idle dungeons
| Aurora Aquir#4272
| Aurora Aquir#4272
| style="background-color:#E8FFEB;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
| [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
| Aether
| style="background-color:#E8FFEB;" | 0.16.3
| style="background-color:#FFE8E8;" | 0.16.3
|-
|-
| [https://imgur.com/a/AmPxfz0 Combat Leveling]
| [https://imgur.com/a/AmPxfz0 Combat Leveling]

Revision as of 13:51, 18 October 2020

Template:V0.16.3 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 Dragon Javelin Profit Calculates profit from creating dragon javelins. Lots of options to configure! Spectroscopy 0.16.3
Melvor Farming Seed Calculator Calculates how many seeds you need to reach a particular mastery level Spectroscopy 0.16.3
Melvor Alching Calculator Calculates the shop price above which it's worth alching items vs. selling Spectroscopy 0.16.3
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 0.16.3
Seed Mastery Amounts of herb and allotment seeds needed for it to become selfsustaining JHawk55 0.16.3
God Dungeon Money Making Calculates GP/H from God Dungeons based on clear times Breindahl 0.16.3
Dragon Jav and Plate Calc Calculator for Dragon Javelin and Dragon Platebody Money Making methods Nomeru 0.16.2
Thieving Calculator Calculates time to reach decired Thieving level based on selected target Nomeru 0.16.3
Can I Idle This?
Can I Idle This? Web App
Calculator for Damage Reduction requirements for doing Dungeons Boomtown 0.17
HP Required Dungeon Charts Reference Chart for necessary DR and HP to idle dungeons Aurora Aquir#4272 0.16.3
Bank Slot Cost Calculator Calculates cost for bank slots based on current amount and desired amount Aether 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
XP/HR Chart Weapon comparisons focused on XP/HR (Melee only). Using mid-tier gear/levels. 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 0.15.4
Elite Strength or Elite Glory Comparison between Elite Strength and Elite Glory amulets Trippledot 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 and NotArcanus#3825 0.15.4
Slayer Skip list Creates a monsterIDs Array based on ticked boxes and items equipped for use with SEMI 8892/Aurora 0.15.2

How to Use?

Usually to use the spreadsheet it has to be copied into your own account (On googlesheets 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).