Spreadsheets and Theorycrafting: Difference between revisions
From Melvor Idle
(added Experience Sheet) |
(remove many dated sheets/dead links →List of Spreadsheets) |
||
(11 intermediate revisions by 3 users not shown) | |||
Line 12: | Line 12: | ||
! Author | ! Author | ||
! Version | ! Version | ||
|- | |||
| [https://docs.google.com/spreadsheets/d/1iOafXHZponuxGm-p95sHLGQpanVtetCnL8h9kjFFX18 Melvor Idle Rate & Resource Calculator] | |||
| Comprehensive sheet that helps calculate time, gain and resource usage till some level. | |||
| [https://discordapp.com/users/564658310272516098 Kidbiz20#2026] | |||
{{VColor|1.1.1}} | |||
|- | |||
| [https://docs.google.com/spreadsheets/d/1-AJnjTeWfqMS2jBu5h5Xvk-ASCdDoCDd9EEyXvk0wUI 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. | |||
| [https://discordapp.com/users/262460368645914625 Spitzer#3603] | |||
{{VColor|1.1.1}} | |||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table] | | [https://docs.google.com/spreadsheets/d/1ajdmQFfRKVBbxaR8Q0AjvfuN5juK4U75550JzNCeyVs/edit?usp=sharing Experience Table] | ||
| Experience/Level table and lookup up to level 1999. | | Experience/Level table and lookup up to level 1999. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937] | | [https://discordapp.com/users/483005368587386905 Foxy#5937] | ||
{{VColor|1. | {{VColor|1.1.1}} | ||
|- | |||
| [https://docs.google.com/spreadsheets/d/1gqvUroU6IDaUJMHzeuJvtMoRImCNFyYnWR5IhzT-C1A/edit?usp=sharing Signet A Drop Chance] | |||
| Shows [[Signet Ring Half (a)]] drop chance for every skilling action. | |||
| [https://discordapp.com/users/483005368587386905 Foxy#5937]<br/>[https://discordapp.com/users/156771111239942144 <nowiki>mazunki [they/them]#3247</nowiki>] | |||
{{VColor|1.1.1}} | |||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s] | | [https://docs.google.com/spreadsheets/d/1TJ4HnTk3n9HbS8MZkTrdyMdNwbIZEpEStwOsf1DOPDE/edit?usp=sharing Cooking HP/s] | ||
| Healing values from cooking, fishing, and farming. Accounts for all modifiers. | | Healing values from cooking, fishing, and farming. Accounts for all modifiers. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937] | | [https://discordapp.com/users/483005368587386905 Foxy#5937] | ||
{{VColor|1.0. | {{VColor|1.0.5}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy] | | [https://docs.google.com/spreadsheets/d/1UDIWcqGmBduOdaBW874ggYzNTm0NYm75IVsYRuUWP9s/edit?usp=sharing Hidden Levels vs % Global/Style Accuracy] | ||
| Raw comparison of additional Hidden Levels against Global Accuracy. | | Raw comparison of additional Hidden Levels against Global Accuracy. | ||
| [https://discordapp.com/users/483005368587386905 Foxy#5937] | | [https://discordapp.com/users/483005368587386905 Foxy#5937] | ||
{{VColor|1.0. | {{VColor|1.0.5}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables] | | [https://docs.google.com/spreadsheets/d/1oaAEh2S_lsXCcd9X035NVvSAr4w_KkT2qHaf4EP0rs4 Dungeon Damage Reduction Tables] | ||
| 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]. | | 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]. | ||
| [https://discordapp.com/users/91970544789897216 Nomeru#4261] | | [https://discordapp.com/users/91970544789897216 Nomeru#4261] | ||
{{VColor|1.0. | {{VColor|1.0.5}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1iRPDZznC5HizeWyyADt7bymFMWxN_jzFP1dGl8Xa4P4 Thieving GP Calculator] | | [https://docs.google.com/spreadsheets/d/1iRPDZznC5HizeWyyADt7bymFMWxN_jzFP1dGl8Xa4P4 Thieving GP Calculator] | ||
| Calculates GP per hour rates for Thieving. | | Calculates GP per hour rates for Thieving. | ||
| [https://discordapp.com/users/91970544789897216 Nomeru#4261] | | [https://discordapp.com/users/91970544789897216 Nomeru#4261] | ||
{{VColor|1.0. | {{VColor|1.0.5}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc] | | [https://docs.google.com/spreadsheets/d/1DHmHL7Gd2GW_N4nGW31pzuGHDdVuOq4rMU6594H36sY/ Dragon Javelin Calc] | ||
Line 67: | Line 67: | ||
| [https://discordapp.com/users/267111261634822144 Hetaku#3546] | | [https://discordapp.com/users/267111261634822144 Hetaku#3546] | ||
{{VColor|0.20}} | {{VColor|0.20}} | ||
|- | |- | ||
| [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator] | | [https://docs.google.com/spreadsheets/d/1TU5Pc1AwXWxCg9ROjzKA7pVV65jTFIElKpGovt6xuoU Bank Slot Cost Calculator] | ||
Line 87: | Line 72: | ||
| Aether#7777 | | Aether#7777 | ||
{{VColor|0.16.3}} | {{VColor|0.16.3}} | ||
|} | |} | ||
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:
| |||||||||||||||||||
Skills:
| |||||||||||||||||||
Other:
| |||||||||||||||||||
Reference Tables: Items, Equipment, Experience Table, Upgrading Items, Combat Areas, Slayer Areas, Dungeons, Chest Loot Tables, Monsters, Monster Loot Tables |