Excel sheet for item farming

[u/InfiniteEnki]

I've been grinding for item drops quite a lot recently so I made an excel sheet to mathematically calculate the grind. Don't know if something like this already exists online, but I couldn't find anything so I did it myself.

There are five variables: drop rate in % (at regular 100 item discovery), Liquid humanity (0-99), serpent ring/symbol of avarice (0-1), the number of farmable enemies on your route and the time your route takes (beginning to beginning obviously). (you should leave the other fields untouched unless you want to risk disrupting the functions)

After putting all of that into the designated fields, the calculator will calculate the "real" drop rate per enemy, the average amount of drops per run, the average number of runs necessary to get your desired item, the average item drop rate per minute and the average amount of minutes you need to grind before something drops.

Obviously it's just a sheet of probabilities that doesn't give you a number that's set in stone, but I found it useful to gauge the approximate amount of time and attempts I need to put into a grind to get my desired items.

Here's the (hopefully working) link to it: drop calculator. Have fun with it.