|
Minor Haste enchant (and all other haste enchants) are not working. It should work out to 1% increase in white damage, 1% increase in cleave/heroic strike and some bonus damage from 1% more rage and is arguably as good as 15agi.
+15agi enchant should be added (to show what happens when dpsing with your tank weapon
Esk right claw should try to model the proc. Its 1ppm and is up 5/60 = 8.33% of the time (actually closer to 13% due to instants and flurry but this is minimum). When it is up, esk right claw is 30% faster so average speed is 0.08333 * (1.5/1.3) + 0.91667 * 1.5 = 1.47 48 * 1.5 /1.47 = 49.0 dps weapon at 1.47 speed. I see that kiss of the spider is modeled, so perhaps it just needs a bit more generic code. In general, a lot of the formulas seem rather long. Perhaps seperating them into multiple sub calcs on a hidden sheet would be helpful and reduce errors.
I didn't have enough time to analyze the heroic strike damage but it needs to take into account that there are no glancing blows and only 5.6% miss rate.
Mod Flurry Chance is too high. It should not be possible to get a 1.
The biggest issue I have with the spreadsheet is that it doesn't model what happens in real fights. Boss gets to 22% or so and I pop Diamond Flask + Death Wish + Recklessness and spam executes. Assuming I don't pull agro and die, stacking cooldowns amplifies dps dramtically. I fully realize this is difficult to model and sadly have no good answers for this.
Very good work in general though.
|