They get banned or can't stand the increasing amout of noob posts here. Just look at all the useless dummy dps tests.

More like folks just lurk now. The math posted here will still hold true post 3.1 Just need to apply any modifications listed on patch notes. If anything folks should be commending the OP for the amount of work and depth of math applied.

Thanks for the time and effort you've put into this. I'm at work at the moment, so I haven't yet had a chance to plug in my individual stats, but I'm excited to see the results. And I'm interested to see the changes to stat weights 3.1 brings about, what with Unholy losing 2% of it's strength bonus and whatnot.

Keep up the good work.

Perhaps this is a stupid question, but I'm curious about the value given to Agility relative to Crit Rating. For example, using the default results in the spreadsheet...

AP 1.00
Crit 1.17
Hit 0.75
Expertise 0.75
Haste 0.61
DPS (Weapon) 4.91
Strength 2.66
Agility 0.30

...Crit Rating is 3.9x more valuable than Agility. If WoWWiki is correct (and it's not the greatest source, I know), then, at level 80, 45.91 Crit rating = 1% crit and 62.5 AGL = 1% crit. If that's true, then wouldn't it stand to reason that 1 crit rating = 1.36 AGL, not a 1:3.9 ratio?

Agility only affects melee crit, while crit rating affects both melee and spells.

Ah, I understand now. Thanks!

I was under the impression that DKs used melee crit for their abilities like Paladins do (since their abilities scale with AP as Ret-Paladins now do). It would appear, then, that I would do well to not place undue emphasis upon items itemized like the [Battlemaster's Breastplate] while leveling my DK. (Though the BC plate quest rewards are roughly split 50/50 between items with crit rating and items with agility, which is annoying.)

On a related note, is this spreadsheet contingent upon the DK being level 80 fighting a raid boss, or will the math still work to provide the relative value of stats while leveling? Obviously it is intended for the former and has assumptions built into it for that, but I was hoping it would still be better than my "gut" for evaluating items I acquire while leveling. (Though I suppose it doesn't really matter—leveling isn't exactly hard.)

That only works correctly for hit chance. In case of expertise there seems to be another small bug in the spreadsheet: The expertise cap is 6.5%, yet all expertise checks are done with 8%. To fix this yourself you'll have to replace all instances of

on the Weights tab in the Expertise column with

You need to use the latter check in cell K33 too.



The decreased value of crit chance for IT, HB and OB due to Killing Machine Hidden mentioned on the last page seems to be a valid concern. I'm not a math person, so I can only hope it can be fixed somehow. Aside from that, thanks for this great spreadsheet, Darkside!

There's only a few minor things I'd like to see included: Armor in the weightings due to the Bladed Armor talent, Armor Penetration (but you already said it's difficult) and a Pawn string or extra values for things like gem slots - although I can probably add this in myself. Also of interest may be racial bonuses like the Draenei hit aura oder increased expertise based on weapon type.

Getting a number for the expertise "weight" based on weapon type and racials is fairly simple.

For each 1 point of expertise you reduce your chance to be dodged/parried by 0.25%. It takes exactly 32.79 expertise rating at level 80 to reduce your chance to be dodged/parried by 1%. Therefore, the racial weighting can be calculated as:

1.25 (5 points, Orcs and Dwarves) or 0.75 (3 points, Humans) x 32.79 x <your expertise weighting>

So for example, I add the following entry on the weights tab somewhere:

This value can be entered into a Pawn scale, Lootrank etc and used as you would expect.

After pouring for the new loot for the last few hours and crunching numbers I punched this into google docs for ease of sharing it. This is the best combination of gear (post 3.1) while maintaining the 4pc t8 bonus. Might be a nice reference for anyone who hasn't felt like adding up the numbers yet.

t8 best in slot - Google Docs

If I missed something please let me know, as this will be all that I am bidding on at this point.

I seem to be having this problem as well, and I assume its me being stupid, anyone care to throw me a bone?

Still looking for an answer from anyone on this, PMd the OP and another active in the thread and have found no help so far, its an amazing tool, and I would love to get some function out of it, I just cant get it to show me 2h instead of DW, Having 2h set to on and DW set to off does nothing, anything i'm missing?

Dont get me wrong man, I wasnt complaining, i just want to be able to use it! if I knew more about Excel or Trig in general, I would be helping you right now, Just sucks that it seems to only work for DW