I’m not sure exactly where this came from. I mean, I made it–but I’m not entirely sure why I made it.
It started when I was going to make myself a Google Docs spreadsheet where I could quickly calculate for myself the various combat table coverage (CTC) percent that an item was worth to me. I shared the spreadsheet with Antigen, since he was always asking me about two different tank items and which would be better, and then it hit me I could go and make the spreadsheet public for the benefit of my readers.
Showing it to Meloree, he pointed out that the sheet was severely incomplete without calculating diminishing returns and, slapping my forehead, I went to work on that. And yet, boy did I not know what I was getting myself into. Hours later–after gallons of blood, sweat, and tears–I finally had everything worked out. Now I’m proud to now offer this spreadsheet to you all.
[ Download CTC Stat Calculator.xls (v1.1) ]
Basically, the way it works is you go to your armory page and fill in the Dodge, Parry, and Agility fields. Dodge and parry came from the tool tips’ non-diminished numbers. I have mine plugged in to prevent half the sheet being !#DIV/0 errors.
Once those are set, plug in the various mitigation/avoidance stats from the piece you’re evaluating. The sheet will calculate your current level of diminishing returns affliction and then use that to figure out how much CTC the item is worth to you.
If you want you can also put negative values in the boxes to represent the stats your losing from the piece you’d be replacing. And then in the next section give your block percent and figure out your total CTC including base dodge and parry and miss chance.
So, for example, if you wanted to compare the Necklace of Strife versus the Ironstar Amulet, plugging both in you’d see that the former is worth 2.32% CTC, while the latter is worth 1.18% CTC.
The sheet is still a work in progress. I need to add raid buffs functionality so you can see the value of Kings, Horn of Winter, etc. on your totals. But it’s a good starting point and a great way to evaluate gear based on their total CTC worth to you. Hopefully it’ll be a big help for you.
Lastly: I’m not a math whiz, so if I missed something somewhere, please let me know. Also, the sheet uses the Paladin-specific conversion of agility to dodge, and Paladin-specific DR constants, so it really can’t be used by Warriors. If there’s a demand though, I’ll make a separate page for Warriors.
This is brilliant, thanks for sharing.
Something I would be interested to build on, include raid buffs.
Definitely coming in the near future.
The macro to check what your in game CTC is seems relevent enough to link:
/run DEFAULT_CHAT_FRAME:AddMessage(“Need 102.4 combat table coverage. Currently at: “..string.format(“%.2f”, GetDodgeChance()+GetBlockChance()+GetParryChance() +5))
I’ve been known to slap on my tia’s grace, pop a mastery pot, and go chase down the nearest warrior for battleshout spamming this macro, to make sure my “CTC cap” set stays at the cap while I swap around gear.
Guess I’m going to be sharing my rogue husband’s “I (heart) spreadsheets” coffee mug from now on…
Oh… I see how it is…
So, you stepped down from GM and RL duties to now indulge yourself in number-crunching, spreadsheet-conjuring, snobbish elitism, eh? I likes it! This will serve nicely for my Paladin re-roll (oops!).
On a serious note, great work on the spreadsheet, and keep up the good ‘ol blog. Oh, and grats on the WoW Insider article. (Yes, us lurkers and stalkers need good reading material, damn it!)
And to all the ES peeps, miss you all. (Except the progression wiping.) I kid, I kid – (sorta). :P
Thanks for the spreadsheet. I finally found a way to prove to myself that Mastery Reforged Belt of the Ferocious Wolf (2.87 Mitigation, 3.37 total CTC) is a better tanking item than Hardened Elementium Girdle (2.12/3.12). Am I using it right?
My bad. I was using it right, but skipped a gem slot. Now it says what it’s supposed to say. Also, I reforged Crit->Dodge instead of Mastery, which was already on there.
You can’t reforge Belt of the Ferocious Wolf into mastery. Ferocious is less mitigation. In my head, it’s roughly 1.7%, vs 2.25% mitigation, and 3.3% vs 3.7% CTC. Hardened wins, hands down.
Ferocious v Hardened
20 mastery 149 crit v 169 dodge.
Both have a blue socket, air on the side of your conclusion and socket 40 mastery in both.
Reforging 149 crit gets 59 dodge. 20 mastery and 90 crit is definitely a lot worse than 110 dodge, at any level of DRs. ~1/3rd the CTC, ~1/6th the mitigation.
Even if we allow the impossible reforge into mastery, 79 mastery is only slightly more CTC, and only half the mitigation of 169 dodge.