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.


A a quick, light-hearted Friday post I wanted to share some factoids about armor that aren’t widely known or understood. Hopefully you’ll join me in falling in love with this stat as much as I have this week.