The results on rares should still be valid, although there was no testing done to confirm this 100%, if I recall correctly. Regarding the doubling of the legendary drop rate: the excel file has been changed to reflect this change, but the initial number (0.001) was never 100% confirmed due to the rather low drop rate of legendaries. However, the results outputted from the excel file seem to reflect my average legendary drop rate quite well, on a 'per run' basis. So the number shouldn't be too far off.
I wonder how many people are still whining now that they don't find any legendaries. I did one key hunt yesterday in act 1 on MP3 (getting 5NV stacks, killing warden and butcher and then keywarden) and got inna's set helm dropping from keywarden (I've got almost 300MF now after switch, excluding NV stacks and monster power, so close to max). At first I thought: "Yay, key", since the key is legendary too and has the same animation with the light coming from the sky..
But sir, 16 legendaries on one day is just ... preposterous!
I suggest you download a copy of the 'legendary drop rate calculator' excel file in the first post and use that to determine which monster level works best for you. What you do is fill in the MF you have at that monster level in the sheet, input your typical run (of which I guess you by now how many elites and how many trash mobs you encounter) and look at the average amount of legendaries dropped during this run. For my run, this is about 0.35 in patch 1.04. Then you just time how long you do over this run at every monster level and divide the average number of legendaries by that time to get the normalized value.
My run takes about 40 minutes, delivering 0.35 legendaries on average, so I should have about 1 legendary dropped every 2 hours (every 3 runs), which is correct according to the amount of legendaries I'm getting. Last night 35 million IK gloves. Nice!
I must say I have been finding a lot of legendary items lately (not in PTR). I'm just doing the famous Alkaizer run (+ keep depths lvl 1 and 3 also) and finding a legendary like every 2 runs. Last week I had a legendary drop in 3 consecutive runs. And I'm only at 275 MF with switch and NV. So doubling the legendary drop rate will be insane, especially with the increased MF from monster level. They should have maybe just doubled it for set items compared to legendary items, but I think legendary item drop rate was pretty okay as it was. Or I might just have been on the lucky side for the last month. I think I have found about 3 set items and 25 legendaries on in total about 175 hours of in-game time.
I guess we will have to do another 0 MF drop sequencing quest to find out. I still haven't played my wizard since 1.04, so I can still get about 110 elite kills sequenced on that one at 0 MF. The only thing is, we should have about 750 elite kills as last time, but maybe for every monster level, to be sure of what is changing. And that will require some time. In any case, I'm willing to help out.
Would the level of the monster scale with the Monster Power, so that with higher Monster Power, you also get higher affix quality? I wouldn't see any reason why they else would have changed that affixes roll based on monster level instead of item level. Because indeed, farming act 3-4 will even be better now compared to act 1 and 2, which is really strange (I thought they wanted people to play the entire game?)
You will be able to set Monster Powers from 0 to 10 before the game starts. The higher the number the more life and attack the monsters will have. Elite packs may even drop more loot than normal. This also increases gold reward and loot quality.
No information was give on the increased amount of loot drops from elite packs. But I guess we'll find that out quickly once the PTR hits by sequencing some elite kill drops.
Nice graphs. I assume you add 3% MF on top of the 0 and 75 starting MF for every paragon level, so that in the end you have 300 or 375 MF?
It would be nice to add some other curves too, like starting MF (without NV) of 50, 100, 150, 200, 250 and 300 (only from equipment!), so people can relate the curves to their current MF values. They can calculate back their equip MF value by substracting 3MF * current pLvl from their current MF value, so they are watching the right curve.
You could also make a curve like this for 5-6 affix ilvl 62-63 items.
i think it's a nice idea of having the metric of legendaries per experience amount in stead of per time (like I suggested), because then the metric is not based on whether you are playing fast or slow. Good idea, Thundersteele!
I found what's wrong. The '_xlfn' was added by excel because it didn't recognize the excel function following it, namely binom.dist. However, my excel (office 2007) does know the function 'binomdist' (without a dot in between). If I remove the '_xlfn' and remove the dot, all works fine. No idea why noone else has problems with this.
The overal input and output of the file seems great to me! A few suggestions:
- Add a time per run parameter (in minutes or seconds), so you can also calculate the number of legendaries per hour
- Display the average number of legendaries found (y-axis) versus the time played (x-axis) in an automatically updated graph, so people can see how much legendaries they will find on average when playing for 2 hours, 5 hours, 10 hours, etc.