I want to compare lair boss drops and try out a spreadsheet simulator. What should I record, and how should I interpret the simulated results?
How would you track lair boss farming results in a spreadsheet?
Answers
Keep one row per kill for your actual farming results. Record the boss, whether a Mythic dropped, and any item or greater affix outcome you care about. Then count the kills and drops for each boss so you can compare them.
I'd keep simulated kills on a separate sheet. Mixing them with real drops would make the results pretty confusing.
Reply to this answer
The simulator needs assumed drop probabilities for each outcome. You can generate a random roll for each kill and use those assumptions to decide what drops, then repeat it to see how much results can vary.
Those numbers are inputs, not discoveries. A simulated dry spell or lucky streak doesn't establish the game's actual drop rates, especially if the probabilities are guesses.
Reply to this answer
Start simple: pick one boss and a couple of outcomes you actually want to compare. A count of kills before a Mythic or a particular greater affix drop is more useful than a huge sheet full of stats you won't look at.
Reply to this answer
Add your answer
Answers are reviewed before publication.
comboLearner+Scone:
Recording kills with no notable drop matters too. Otherwise the drop counts won't have a useful total to compare against.