I don't think the 1.06 value for the meta gem is accurate if we are seeing 50% base crit bonus - that number should only be accurate for 100% base crit bonus. The 1.06 is derived from (2*1.03-1)*1.3+1=2.378=1.06*1.3+1=2.378, a weird formula because the meta gem affects the entire crit damage whereas mortal shots only affects the bonus amount. In this case, the current value for H85 doesn't seem to make sense, unless mechanics have drastically changed since everyone tested Ruin/Oath with the meta, and mortal shots with the meta, back in BC. It's all moot if the change actually did go live though.

Edit

646*1.7085=1103.691

Allowing for a bit of rounding, I think my formula was correct.


Edit 2 (unrelated)
I'd like to request some calculations for volley in the spreadsheet - probably not as part of a rotation, but to at least get an estimate on volley damage. My testing so far showed the following.

Crit bonus: Crits for 237.8% (a hit for 100 crits for 238), so Mortal Shots and the meta gem do apply
Crit chance: 184 ticks yielded a crit rate within 1% of my character sheet crit chance as MM, so it seems safe to say Lethal Shots applies
Partial resists: subject to them
Multipliers: Ranged Specialization, Barrage, Improved Tracking
Expose Weakness: Can be procced from crits
Master Tactician: Can not be procced from volley hits
Haste: Haste from gear reduces the casting time (and increases tick frequency) making it roughly a multiplier, although there is some travel time that I do not not know how to calculate. The quiver effect does not appear to apply - naked casting time is 6 seconds.
ArP: It's arcane damage so this obviously has no effect.

I believe Marked for Death and Mortal Shots are additive, not multiplicative - (2 * 1.03 - 1) * 1.4 + 1 = 2.484 (or 148.4% over a regular hit)

Since v92 i get #NV dps results after reading from Armory (though items are imported without error). v91 still works fine - what changed?
(Excel 2002)

It would be nice if the Marked For Death vs. Glyph of Steady Shot bug will be modelled in the next version of the spreadsheet.

Bte, great work, go on!

Drape of the Faceless General had its stats changed in the recent patch -14 Agi +24 stam so gives 53 agility instead of the original 69 and 55 stamina instead of the original 31.

I got the following issue with some lastest versions of the spreadsheet (especially the 92PTR2) when optimizing my stuff :

Runtime error 13 : Type mismatch

It occurs on the following line :

hitToCap = Worksheets("Overview").Range("HitRatingToCap").value (in the regem method)

Sorry if the question has already been asked but I can't find any traces
Thx by advance for your help

There appears to have been some server-side hotfixing since yesterday for the serpent sting crit modifier when using 2pc T9 - it's critting for a lot more than it was last night.

I did some testing on some dummies, and it seems to be critting for about 225.4% fairly consistently, as both MM and SV (with mortal shots and RED meta), at various levels of AP:

I'm not quite sure how that number is coming about. If I understand it correctly, if the crits are now for 100% bonus, the crit would be:

(nonCrit * 2 + nonCrit * 0.3) * 1.03 = nonCrit * 2.3 * 1.03 = nonCrit * 2.369

which isn't what I'm getting. The spreadsheet of course counts the meta multiplier at 1.06 for attacks that crit at 200%, which gives the 2.438 that you have in your posts, but that's even further off the observed results.

So I'm trying to calculate the base crit modifier on SS ticks from first principles now. With the unknown crit modifier B, the total modifier should be:

(B*1.03-1)*1.3+1 = 1.339 * B - 1.3 + 1 = 1.339 * B - 0.3

Taking one of the samples, that means

1233 = (1.339 * B - 0.3) * 547

implying B = ~1.907

So if I'm not missing something and the meta works consistently with how the spreadsheet and your formula above have it for other shots, serpent sting is now critting for about 190% base, before meta and talents?

This would in hind sight be a lot easier to test if I just unspecced and took off my meta >.>

edit: Hm, I definitely seem to be missing something, since taking off my meta puts the crits at 215% consistently, with B at 1.885 consistently. B should stay constant if my math above is correct.

Hotfix to Crit multiplier:

World of Warcraft - English (NA) Forums -> Hunter T9 2pc Bonus Fixed.

Well serpent sting seems to follow this formula: (2*1.045-1)*1.15+1
In other words, it's using 50% of mortal shots but 150% of the meta gem. I have no idea why it's doing this - the formula they use is probably different but this one at least matches my results.

Hmm, very strange. Oh well, at least we have a consistent forumula now.

Thanks, but just a word of caution WoL logs from a raid don't really help figuring out the crit modifier, since the avg crit and avg non-crit values aren't what we need - the base tick and hence the base crit will change wildly from application to application of serpent sting based on your AP/buffs/debuffs at the time of casting, muddying the waters a lot. Whereas just firing a series of individual serpent stings at a target, and noting down the pair of non-crit and crit values for each individual application of the sting gives the values we want to compare (i.e. aggregating values from multiple different serpent stings is bad).

Push the button marked conveniently "Regem"