I did some more extensive testing on PTR while the bug still allowed me to.

First I tried to verify the two roll system. To do this I got myself a crit rate of more than 100% while staying at 0% hit rate.
Of 846 Auto Shots at Dr. Boom 791 (93,5%) were critical, 24 (2,84%) were blocked and 31 (3,66%) were misses.
Not only does this confirm Lactoses testing it also poves that just like with the melee table block pushes crit of the attack table - though this should really be a non-issue for "uncheated" Hunters.

The second test was to see if there really is an unhasteable 0,5s cast time for auto shot or if it can actually go off faster.
In 369,593s I shot exactly 1031 auto shots which makes an average of 1 shot per 0,359s where it should theoretically have been 0,253s. About 0,1s slower than expected but also 0,141s faster than it should be possibe if there was a hard 0,5s cap for auto shot "casting time".

Did the 24 blocks have been critical?

Cheeky - You mention Glau's tool i have searched high and low and cannot track it down. Can you provide a link, as someone who plays from the Caribbean high pings are a factor in my play and something to help me optimise my rotations to suit would be a big help.

Cheeky - Why is there no option for a custom trinket? I wanted to play around with the new Alchemy trinkets but couldn't find a way to do so.

Blocks and crits are mutual exclusive. They´re both on one attack table (the second one after the hit/miss table). Your hits can only be either norma, critical or blocked (which is normal minus some blocked damage).

Ranged attacks can be critical hits and blocked independent of each other. Most likely it's on the first roll (Hit/Block/Miss), while the second one determines critical hit or not.

Do you have any data for specials? I.e. are blocked attacks always hits on Auto Shots only, or for all specials?

G'day,

just wanted to download the newest sheet, URL doesn't work though.

Browsed through a couple of pages but didn't find an answer to my culprit. My char is on a EU Server, ergo when I try to import via the armory I get the german names coming in and thus error messages.
Is there a trick or do I have to manually weave the items into the sheet?

Regards, Patrick

Unfortunatly I didn´t think about testing specials at that time. So in answer to your question - the blocks were all auto shots only.

Cheeky, a question regarding mana/oom modelling if I may...

With the additon of the new "upgraded" Alchemist Stones (link), do you have any plans to re-model the "Time to OOM" to include different types of pots, the effect on your dps when switching to AOTV and average dps over pre-defined fight lengths, etc?

Personally, I tend to get lumped in the "random" raid group along with the Holy Priests, any excess Warlocks, etc. If I'm lucky I might get another Hunter or I'll get to buff the melee group which means I have serious mana problems over long fights and usually find myself in AOTV at some point.

Whilst I love your spreadsheet I often find myself wondering whether or not it's advantageous for me to take a lower dps item in favour of one that's likely to increase my time to OOM and thus stay in ATOH as opposed to AOTV. With the new Alchemist Stones I'm now seriously tempted to drop my [Hourglass of the Unraveller] and I'm sure many others will have similar questions.

Thanks for all your hard work.

2 Short Questions, please:
Its been a little bit tricky to fill in this incredible Spreadsheet, but I think I managed it quite ok. At the moment the calculate gives me a total DPS of 1282 (1007 + Pet). Is this realistic for a T6 Hunter? If it is, I am satisfied in doing everything right.

But one Question to the summary: Is the value of the Critcial-Chance with installation-counted (In the Total DPS)? (Translation by Babelfish) Or ist it DPS + Crit? Im quite sure, it is summarized in the dps, isnt it?

At last, thanks to "Cheeky" for this fantastic Sheet. Im sure, no one can imagine how many hours it took to build this. Thanks.

Well, I haven´t been able to decypher every column of the new combatlog but everything I read out of it hints towards that conclusion. If someone can point me towards a thread where the diffrent columns and their meanings are explained I´d appreciate it.

Meanwhile if you´re interested in the details I can describe how I´ve come to my conclusion:
At first I realized that there are two distinct damage ranges for all of my auto shots that did hit. One is between 271 and 382 (the supposedly blocked hits) and another between 736 and 1045 (the supposedly critical hits). Now I compared the lines with the blocked hits with those where I critted and realized that a) in every line with a block there was also a 49 in a certain column whereas there´s a nil in those lines where I critted (and blank when I missed completely). This seems to be the amount of damage that has been blocked (fits with the screenshot I posted). Last not least I realized there´s anorger column that only shows 1, nil or blank for all my autoshots and those too fit with my crits, blocks and misses.

All our attacks can be blocked. I've had critical arcane shots partially blocked. Our attacks are all considered physical, some of them just deal a different school of damage (yes, physical is a damage school).

From all the testing that has been done so far there are up to three rolls.

1) Hit/Miss/Block

2) Critical

3) Partial Resist

Most of the first two rolls is modeled in the spreadsheet.

I don't believe block is modeled as we don't really understand how much NPCs will block for. I also do not believe the partial resists for Arcane Shot are modeled (All bosses have a base 25 resistance to all schools that cannot be mitigated)

I'm sorry to bring up this old stuff, but I couldn't find any response matching my thought:

I don't see this as proof of a two-roll system. I see it as proof that misses push crits off of the ranged combat table before they push hits off. What am I missing here?

The real test is to have a lot of shooting with high crit and miss rates (thousands of shots), then to compare the ratios.

Someone did this with over 100% crit rate on the test realm with the stat stacking bug. With 0 hit rating they were still able to get misses and blocks.

Went and did some testing on the PTR.

Arcane Shot: Hit, Block, Crit, Crit + Block seen.
Steady Shot: Hit, Block, Crit, Crit + Block seen.
Auto Shot: Hit, Block, Crit seen. In several thousand Auto Shots I did not see any Block + Crit Auto Shots.

However, I do have a screenshot, dated October 6th, showing a blocked critical Auto Shot (Live server).

If no one beats me to it, I'll fly up and do a quick test within 24 hours on Live server.

EDIT: On another note, I've compiled all the bugs I've received so far. Keep in mind that 2.4 gear will most likely stay as is for a while. Cheeky is currently away for 2 weeks, and the gear might be seeing changes in every PTR build. If there's any incorrect stats, send them to me via PM, and I'll update my bug list as needed.

There's a blue line at the bottom of the gear tab made just for that ;-)

My google-foo strikes again.

Glaurong's Post w/ parser

That still sounds like evidence that misses push crits off the table. Am I missing something here?

I'm not saying that it isn't a two-roll system.... I'm just wondering if this is "for sure".

PS I thought I posted this before, but don't see it. Apologies for re-posting if it got deleted, but I'm going to blame my bad memory first.

In a 1-roll system, with 100% (or more) crits you shouldn't have a single shot that is a miss.
The test being done the way it has been, and misses appearing, it can not possibly be a 1-roll system.

Um, why not?

Imagine some total BS numbers: 130% crit rate and 50% miss rate, with everything left over as hits.

The misses (in my theory) then push some crits off of the table, to make room for themselves.

That leaves 80% crits, 20% misses, no normal hits, on a single-roll table So, there you go: Misses with over 100% crit rate on a single roll.

That might be different than melee attack table behavior, but we already know that the ranged attack table is different, as it doesn't have parries or dodges.

How do you imagine this should be calculated? No matter how I do it, I can´t really comprehend how you´re getting to 80% crit and 20% miss in your example.