The following info is old. Look at the one i made on the third page of this thread. There is also a download link for the new calculator.

Glad to be of help. According to what we have figured out until now I have made an easy to use Critical cap calculator in Excel.


A. You need to insert info only at the red boxes. Those are your Hit rating, your unbuffed Agility and Critical chance char sheet value (add also the full amount of Agility or Critical chance any trinket procs you may have).

B. At the green colored boxes there is various information for the current status of your character.

C. At the yellow box it shows you how much more room for critical you have before you reach the cap with your current hit rating.


There is one table for Non-Draenei and one for Draenei. The tables assume Elemental devastation, Thundering Strikes and Dual-wield Specialisation taken, and also a fully buffed raiding environment. Also, if you aren't expertise capped, you should subtract your chance your attacks have to dodge from the final number.


Edit: Make sure you have knowledge of the crit cap mechanic. Those tables are only meant to speed up the calculation process, not to tell you something you don't already know.

A spreadsheet is overkill isn't it? Rawr now does this (use Combat Table (White) to view) and soon ShockAndAwe in game will do this.

Well I am not aware how advanced the various other classes' spreadsheets are, but all this table is doing is get your base crit, adds 9% from ED, then crit from raid buffs (5% buff, 3% debuff, MotW, SoE), finally calculates your total agility to calculate Kings and adds it all together. Then it sees your chance to miss, tells you how much more Crit you can have before the cap. Its pretty primitive and simple, made in 10 minutes.

Levva, i was also wondering to how much AEP hit rating is rising to, when someone isn't White Hit capped but is White Crit capped. That means that for whatever hit rating someone at that situation gets, hit is converted to crit immediately.

My rushed calculations over some of my WWS parses showed a value of in the area of 2.2 AEP per 1 hit rating, but it may be helpful to implement this new AEP value to the simulator, so we can see if it's worth it to gem for hit when crit capped or not while in various gear setups. I will post some analysis on the matter a bit later.

None of the simulators use EP or AEP in any way shape or form they are a by product of adding stats and doing a calculation and are provided as a convenience to humans to give you a ROUGH guide to how the stats shape up against each other. As far as either simulator is concerned neither of them are using EP values AT ALL. In fact with the new graphs in Rawr (introduced 3-4 months ago) you are advised never to refer to EP values again as the graphs give you a far far better at a glance view of the interaction of your stats as the amount of added/subtracted stat changes.

It is a source of some concern that people still think after all this time that the simulators use EP values in their calculations THEY DON'T!!! Simulators use formulae for percentage hit, miss, crit, haste etc etc etc and work out how that affects the damage components of each of your abilities. The difference between the two sims is that Rawr.Enhance uses a averaged stat closed form solution and so is very quick but is assuming that everything is averaged out over time. Whereas EnhSim actually runs thousands of hours of actual combat blow by blow simulation rolling dice for every single event seeing if its a hit, crit, miss, checking if something procs etc.

PLEASE PLEASE get it into your head that EP values are MEANINGLESS, they provide a VERY ROUGH guide to what stat with THAT gear is providing the most improvement but as soon as you change the stat the EP values change, this is especially true of hit & now crit where we are dealing with caps.

Post it, I'm curious and I don't think EP is such a bad thing provided people are aware of it's limitations.

The thing is you can see very very clearly with the graph feature in Rawr how Hit suddenly rises then falls back around the crit cap. This is similar to using EP values but not for a single value but for multiple values. ie: The program takes the current gear and say ok what's the dps if I add 5 hit rating, then 10, then 15 etc etc.

EP values do the same idea it adds a fixed amount specified in the EP values section of your EnhSim config. However all you end up getting is a SINGLE point on the graph. Now if you happen to have a graph where values are rising and falling due to caps what you are doing with EP values is taking a single set of values at a single point on the graph and trying to make declarations of behaviour at other points on the graph with the invalid assumption that its constant.

If instead you look at the graph as a whole you get a clearer picture. You see the rises and falls, you see where the graph levels off.

Lets take Rouncer's gear from the armoury. He's already optimised it (far too efficient for his own good) so I unoptimised it by changing a 20 hit gem in his gloves to a 20 haste gem. This then gave what he saw before the conversation about crit caps emerged.



Now note two things the way that expertise hits the zero line considerably to the left ie: perhaps a little over capped, also note that the hit rating does some funny things it changes angle twice. Once at the point off to the left where he passes the spell crit cap and once where he can overcome the melee crit cap with some extra hit.

I also stuck a red line on the map to show you what you'd get from EP values ie: you'd get hit EP of around 2.3, haste around 2.05 and AP at 1, the rest would be below 1 (note that haste & AP are almost on top of each other ie: haste is only just ahead of AP).

Now what does 2.3 EP hit rating mean?? The idiots out there would have you believe that means "regem for hit" ie: change your gear around and replace your haste gems for hit gems. Is this right? CLEARLY not. We can see that hit rating tails off significantly after Rouncer adds about 10 hit rating. So what does the graph tell us that EP cannot tell us?

The graph shows that he needs about 10 more hit rating before it tails off and that he's about 10 expertise rating too much. Lets test that theory and change his leggings gem from 20 expertise to 10 expertise and 10 hit rating. If you do the calcs in the sim you see that this is a BIG upgrade over any other gem choice for that slot. Once that single gem choice is changed you get the following graph...



Note that the kinks have been dealt with and now haste and AP are neck and neck with hit rating no longer an issue.

So what does this all mean? Well from the graph I was able to see that LOSING some expertise and gaining some hit was what was required. No amount of massaging EP values would EVER have seen that solution. In fact traditional use of EP values would have wrongly suggested that "stacking" hit was a good idea when clearly it wasn't. This is to me damning proof that EP values can be fatally flawed and whilst potentially useful for quick comparisons in game have no place in serious discussions about how we should gear.

In this example the only EP values available are represented by the vertical red lines. As you can see they are a tiny snapshot of what is going on and since the EP values (the red lines) were in the "wrong place" they gave a false indication of how Rouncer should gear. The only way you could have found this out with EP values would have been to run the sim dozens of times with lots of different EP steps ie: effectively producing a graph.

In fact my little tweak using the graph raises his dps from 9098.45 to 9112.04 which is a 14 dps rise from changing a gem. In fact that's the upgrade he'd get from his OPTIMISED gear. The change of a single gem from graph 1 to graph 2 was changing 20 expertise to 10 expertise 10 hit changing dps from 9085.39 to 9112.04 ie: using the graph and changing a single gem gave a 26.65 dps upgrade.

I just got the 258 gloves last night so hadn't had a chance to rework my gemming to account for the additional expertise on the gloves.

Levva would it be possible to add a way to zoom in and out on the graph? Maybe give an option to control the size of the Stat Change variable in the X axis? I'd love to be able to zoom into the 20 or 40 stat change area to see what is going on when they are all clumped up like that.


As for the talk of the EP value of hit when just over the crit cap, I would be interested in seeing the math for it's value since that goes into determining the value of adding hit past the spell hit cap when it would also be increasing the value for crit on white strikes as well. Logically it makes sense that hit would then be the best stat to gem for until you got back under the crit cap when Elemental Devastation (as a high uptime proc) was active but seeing the math may help to quantify it better.

This line is wrong. You don't have to subtract the 4.8% for the crit depression. If you read through this thread you'll see where Rouncer showed very clearly that this 4.8% crit depression has no effect on the amount of crit required to reach the cap.

It should look more like this:

Yeah, that's left over from the old macro and shouldn't be there. I was mostly interested if the first one is correct since I won't raid until sunday.

While I enjoy receiving credit for things in this case that was just me repeating the argument Bestpike made that managed to get my brain to wrap around how it actually worked.

Would one of you mind fixing up that script and posting it in a single [ code ] block so people can have a correct script to use? Pretty sure two of them will be necessary though, since you will need one when there is a Heart of the Crusader, ToW or Master Poisoner debuff on the target and one when it is not present.

Also anyone who has a flawed or incorrect script in their post would you mind going back and editing it out so there is less confusion for people following this thread.

Graph scale in Rawr.Enhance now user definable.