Diablo IV, Diablo 2 and Diablo 3 Forums - Diabloii.Net
Magic Finding Efficiency Spreadsheet
Hi,
I've written an excel tool for calculating and/or comparing your Magic Finding efficiency. By inputing your run time, your MF, player settings, hork% and how many monsters you kill, you can see exactly how many of a given unique (I've chosen Death's Web) you will find, on average, over time. It's written primarily with the Pit, AT and Pindle in mind, but I imagine the information could be used for some other things as well, especially with some tweaking.
Click here to download the spreadsheet
Before I go over it and explain everything, a disclaimer. The numbers the spreadsheet spits out are only as accurate as the numbers you input, so you might want to take them with a grain of salt. If you estimate that you kill an average of 7 boss packs per run, but your "true average" is only 5,8 boss packs per run, obviously this inaccuracy will also be reflected in the resulting numbers.
Below I will explain what all the stuff means, and how to interpret the numbers. If you have any questions about how it works, what it tells you, or anything like that, I would ask you to please read the below section(s). Chances are it's explained in there, otherwise I'd be happy to answer any questions of course.
Area 85 Level Running
Here's a screenshot of what this page looks like:
The top section and the bottom section are identical; essentially you have two calculators on the same page, so you can compare two different setups at the same time.
All the stuff on the right, ilvl/qlvl/BaseChanceUnique/Divisor/QualityFactor/DropChance, are numbers used to calculate the drop chance of the item we're looking at (Death's Web). You don't need to understand or worry about these numbers, unless you want to change the item you want to calculate the chance for. For more information, check out the excellent Item Generation Tutorial in the Statistics forum, particularly section 8.
The other numbers on the right concern the player setting you want to use. More on that later.
The numbers in cells C4-C7 are the drop chances of the Unique item from the corresponding type of monster, given the MF amount you've input. In cell C4, the number 110870 means there's a 1/110870 chance of a Boss dropping a Death's Web, given this amount of MF.
Values you input
MF (hork), MF (kill) (B9-B10): Here you put down how much MF you're wearing. If you don't use Find Item, you can leave the "MF (hork)" field blank, or leave it at some other number; it won't be used in the calculations. The reason there are two different MF fields is for Barbarians who have one "kill switch" (perhaps a high-damage weapon) and one "hork switch" (perhaps something with FCR, MF and/or +skills). If you hork with the same amount of MF as you kill with, just input the same value in both fields.
Player setting (B11): This is not very elegant looking, but it works fine. Look at the numbers in cells U15-X15; these are the values to input here in B11, and the drop odds of Minion and Regular monsters will be adjusted correctly. Hint: If you put "=X15", the value from cell X15 will be copied, and you get p7 conditions without having to copy down that number by hand.
Hork% (B12): This is for Barbarians only. Put the % chance of a successful Find Item. When using horking in these calculations, it is assumed that you hork all Bosses and Champions, and no Minions and Regulars. Non-Barbarians can input 0 here, or leave it blank.
Run Time (s) (B13): How fast your average run is, in seconds.
# (D4-D8): The numbers in these cells represent how many monsters of each type you estimate you kill per run, on average. These numbers might be difficult to get completely "right" (see the above disclaimer), but your best estimate will probably not be too far off. These numbers can't be 0, as it will return a "divides by 0" error. If you want to ignore one or more type of monster, putting something like 0,000001 will do the trick.
Interpreting the numbers
Chance/Run (C16): This number tells you how many runs you have to do, on average, to find one Death's Web (or whatever item you've changed it to). Put another way, there's a 1/8252 chance per run of finding a Death's Web, in the screenshot above.
Hours/Drop (C17): This number tells you how many hours you have to run, on average, to find one Death's Web. If you're looking to compare Magic Finding efficiency, this is the most important number of all.
% After # Runs (C20): Input a number of runs in the B19 cell. In C20, you can then see how many % chance you have of finding at least one Death's Web after that many runs. So given the conditions in the example screenshot, there's an 11.41% chance of finding at least one Death's Web per every 1000 runs you do.
% After # Hours (C22): This is the same thing as above, but with hours instead of runs. Input a number of hours in the B21 cell, and this number will tell you how many % chance you have of finding at least one Death's Web after running for that many hours. For instance, with the conditions in the example screenshot, you'd have a 44.11% chance of finding at least one Death's Web if you ran for 100 hours.
In the top section of the example screenshot, I've put the numbers of my Pit running Berserk Barbarian. In the bottom section of the example screenshot, I've put the numbers of my Pit running Poison Necro, doing p7 full'ish clears, although the Necro numbers are very rough estimates, and I'm not vouching for their accuracy
Pindle
This page looks nearly the same as the A85 page, and so does not warrant a screenshot. The information about Champion and Regular monsters is removed, as those monsters don't exist in Pindle running. Other than that, it works exactly the same, except one thing. In cell E6, you input how many of the minions you hork on average, if you're a Barbarian. As far as I know, some people try and hork only Pindle, and others hork the minions as well. This number can't be 0, as it will return a "divides by 0" error, but if you don't use hork, this number won't affect any calculations.
The numbers the screenshot comes with, is my Pindle running WW Barb from the 2010 Summer MFO in the top section, and my 2011 Winter MFO teammate jDer's Lightning Amazon's numbers in the bottom section (taken from here). I hope he won't mind
That's it. I hope you find this tool useful for something. If you have any questions or comments, please let me know and I'll do my best to answer them. If you read this and the download link has stopped working, you can email me at fabbe _ sjoblom @ hotmail . com and I'll reply with the spreadsheet.
Thanks for reading!
Hi,
I've written an excel tool for calculating and/or comparing your Magic Finding efficiency. By inputing your run time, your MF, player settings, hork% and how many monsters you kill, you can see exactly how many of a given unique (I've chosen Death's Web) you will find, on average, over time. It's written primarily with the Pit, AT and Pindle in mind, but I imagine the information could be used for some other things as well, especially with some tweaking.
Click here to download the spreadsheet
Before I go over it and explain everything, a disclaimer. The numbers the spreadsheet spits out are only as accurate as the numbers you input, so you might want to take them with a grain of salt. If you estimate that you kill an average of 7 boss packs per run, but your "true average" is only 5,8 boss packs per run, obviously this inaccuracy will also be reflected in the resulting numbers.
Below I will explain what all the stuff means, and how to interpret the numbers. If you have any questions about how it works, what it tells you, or anything like that, I would ask you to please read the below section(s). Chances are it's explained in there, otherwise I'd be happy to answer any questions of course.
Area 85 Level Running
Here's a screenshot of what this page looks like:
The top section and the bottom section are identical; essentially you have two calculators on the same page, so you can compare two different setups at the same time.
All the stuff on the right, ilvl/qlvl/BaseChanceUnique/Divisor/QualityFactor/DropChance, are numbers used to calculate the drop chance of the item we're looking at (Death's Web). You don't need to understand or worry about these numbers, unless you want to change the item you want to calculate the chance for. For more information, check out the excellent Item Generation Tutorial in the Statistics forum, particularly section 8.
The other numbers on the right concern the player setting you want to use. More on that later.
The numbers in cells C4-C7 are the drop chances of the Unique item from the corresponding type of monster, given the MF amount you've input. In cell C4, the number 110870 means there's a 1/110870 chance of a Boss dropping a Death's Web, given this amount of MF.
Values you input
MF (hork), MF (kill) (B9-B10): Here you put down how much MF you're wearing. If you don't use Find Item, you can leave the "MF (hork)" field blank, or leave it at some other number; it won't be used in the calculations. The reason there are two different MF fields is for Barbarians who have one "kill switch" (perhaps a high-damage weapon) and one "hork switch" (perhaps something with FCR, MF and/or +skills). If you hork with the same amount of MF as you kill with, just input the same value in both fields.
Player setting (B11): This is not very elegant looking, but it works fine. Look at the numbers in cells U15-X15; these are the values to input here in B11, and the drop odds of Minion and Regular monsters will be adjusted correctly. Hint: If you put "=X15", the value from cell X15 will be copied, and you get p7 conditions without having to copy down that number by hand.
Hork% (B12): This is for Barbarians only. Put the % chance of a successful Find Item. When using horking in these calculations, it is assumed that you hork all Bosses and Champions, and no Minions and Regulars. Non-Barbarians can input 0 here, or leave it blank.
Run Time (s) (B13): How fast your average run is, in seconds.
# (D4-D8): The numbers in these cells represent how many monsters of each type you estimate you kill per run, on average. These numbers might be difficult to get completely "right" (see the above disclaimer), but your best estimate will probably not be too far off. These numbers can't be 0, as it will return a "divides by 0" error. If you want to ignore one or more type of monster, putting something like 0,000001 will do the trick.
Interpreting the numbers
Chance/Run (C16): This number tells you how many runs you have to do, on average, to find one Death's Web (or whatever item you've changed it to). Put another way, there's a 1/8252 chance per run of finding a Death's Web, in the screenshot above.
Hours/Drop (C17): This number tells you how many hours you have to run, on average, to find one Death's Web. If you're looking to compare Magic Finding efficiency, this is the most important number of all.
% After # Runs (C20): Input a number of runs in the B19 cell. In C20, you can then see how many % chance you have of finding at least one Death's Web after that many runs. So given the conditions in the example screenshot, there's an 11.41% chance of finding at least one Death's Web per every 1000 runs you do.
% After # Hours (C22): This is the same thing as above, but with hours instead of runs. Input a number of hours in the B21 cell, and this number will tell you how many % chance you have of finding at least one Death's Web after running for that many hours. For instance, with the conditions in the example screenshot, you'd have a 44.11% chance of finding at least one Death's Web if you ran for 100 hours.
In the top section of the example screenshot, I've put the numbers of my Pit running Berserk Barbarian. In the bottom section of the example screenshot, I've put the numbers of my Pit running Poison Necro, doing p7 full'ish clears, although the Necro numbers are very rough estimates, and I'm not vouching for their accuracy
Pindle
This page looks nearly the same as the A85 page, and so does not warrant a screenshot. The information about Champion and Regular monsters is removed, as those monsters don't exist in Pindle running. Other than that, it works exactly the same, except one thing. In cell E6, you input how many of the minions you hork on average, if you're a Barbarian. As far as I know, some people try and hork only Pindle, and others hork the minions as well. This number can't be 0, as it will return a "divides by 0" error, but if you don't use hork, this number won't affect any calculations.
The numbers the screenshot comes with, is my Pindle running WW Barb from the 2010 Summer MFO in the top section, and my 2011 Winter MFO teammate jDer's Lightning Amazon's numbers in the bottom section (taken from here). I hope he won't mind
That's it. I hope you find this tool useful for something. If you have any questions or comments, please let me know and I'll do my best to answer them. If you read this and the download link has stopped working, you can email me at fabbe _ sjoblom @ hotmail . com and I'll reply with the spreadsheet.
Thanks for reading!