Difference between revisions of "Spreadsheets and Theorycrafting"

From Melvor Idle
Line 31: Line 31:
 
| Kidbiz20
 
| Kidbiz20
 
| style="background-color:#E8FFEB;" | 0.18.2
 
| style="background-color:#E8FFEB;" | 0.18.2
 +
|-
 +
| [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.
 +
| Aurora Aquir#4272
 +
| style="background-color:#FFE8E8;" | 0.18.2
 
|-
 
|-
 
| [https://drboomtown.github.io/?hp=1000&dr=29&ae=3&style=Melee&mode=Normal Can I Idle This? Web App]
 
| [https://drboomtown.github.io/?hp=1000&dr=29&ae=3&style=Melee&mode=Normal Can I Idle This? Web App]

Revision as of 18:29, 14 January 2021

This page is out of date (v0.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 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
Dragon Jav Calc Calculator for Dragon Javelin Money Making method Nomeru 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 0.18.2
HP Required Dungeon Charts Reference Chart for necessary DR and HP to idle dungeons Aurora Aquir#4272 0.18.2
Melvor Idle Rate & Resource Calculator Comprehensive sheet that helps calculate time, gain and resource usage till some level. Kidbiz20 0.18.2
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.18.2
Can I Idle This? Web App Web app version of Calculator for Damage Reduction requirements for doing Dungeons Boomtown 0.18.0
Can I Idle This? Calculator for Damage Reduction requirements for doing Dungeons Boomtown 0.17.0
Bank Slot Cost Calculator Calculates cost for bank slots based on current amount and desired amount Aether 0.16.3
God Dungeon Money Making Calculates GP/H from God Dungeons based on clear times Breindahl 0.16.3
Melvor Alching Calculator Calculates the shop price above which it's worth alching items vs. selling Spectroscopy 0.16.3
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
Seed Mastery Amounts of herb and allotment seeds needed for it to become selfsustaining JHawk55 0.16.3
Thieving Calculator Calculates time to reach desired Thieving level based on selected target Nomeru 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 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
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 8892/Aurora 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 v0.19.2 (Released: 1st April 2021)
Combat.svgCombat:
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
Alternative Magic (skill).svg Alternative Magic
Other:Man (thieving).svg Beginners Guide Guides.svg Guides Bank Slot (upgrade).svg Bank Combat.svg Combat Mastery.svg Mastery Coins.svg Money Making Shop.svg Shop Easter.svg Easter Eggs Finn, the Cat (pet).png Pets Golden Golbin (pet).svg Golbin Raid
Reference Tables: Items, Equipment, Experience Table, Upgrading Items, Dungeons, Chest Loot Tables, Monsters, Monster Loot Tables