Luckyshot, on 04 June 2012 - 03:42 AM, said:
I have tested out this spreadsheet, the numbers with all damage buffs off (sharpshooter and steady aim) are about 200-300 dps too high. The stats in the spreadsheet match perfectly with my toon so the only thing I can think of is maybe it is how blizzard handles rounding? Otherwise it worked good enough for me to make a decision on a weapon upgrade.
Do you have increased attack speed on your weapon? My 2H-xbow has a 19% increase in attack speed, and the tooltip speed reads as 1.31. But that's not accurate, because 1.1 * 1.19 = 1.309 (1.1 = base 2h-xbow attack speed * 1 + 19%). So on the spreadsheet I changed my attack speed to 1.309, and voila, the spreadsheet displays the exact DPS as the in-game stat sheet.
@Renelan - I left you some comments on Reddit, but I don't think you saw them. I think it might be valuable to show a different figure for DPS with sharpshooter as opposed to a simple 100% crit rate. It will be much more complicated to figure out, but it would be really valuable if some assumptions were made and SS was valued at a straight X% additional crit, as that is more like real life than a 100% crit rate. One of the big reasons for this is that, as your gear gets better, the DPS increase from SS should go down, and it would be helpful for people to understand when the passive stops being useful for them.
Edited by Daen, 07 June 2012 - 07:44 PM.