(Forgive me if this is the wrong place, didn't seem to exactly fit in the Addons forum.)

I've been featuring this on my blog for a while now, but I'd like to share this with a wider audience (and possibly get some suggestions/criticism). I made a spreadsheet that calculates combat table coverage, both for the value of a specific item, and for a raid-buffed situation so you can plot out gearing outside of a raid.

The way it works is you first plug into the sheet your non-base, non-diminished dodge and parry (you get this by mousing over your dodge/parry numbers on your armory page and take the "y" number from the "rating of x adds y% chance" statement).

They then gets run through the DR wringer. In the next section you can plug in the values for an item you're evaluating and the sheet will show how much CTC the item is worth while taking your dodge/parry DR into account.

Further down the sheet, you can select any buffs you want to add to your total, and plug in your total block as well. You'll then get your total CTC percent (base values and miss are added in at this point), as well as how close or far over the 102.4% magic number you are.

If over 102.4%, the sheet will tell you how much mastery rating you can shed, and how much stamina that would convert to using the ratio of 40:60 pure mastery gem:pure stamina gem.

It's not pretty, but it gets the job done. Hopefully it'll be a nice help!

It works, I like it. And I don't get hassled for having spreadsheets open at work.

I think the dodge/parry thing is slightly unintuitive, if there's any kind of way to enter the numbers as ratings or "read right off the armory page" it might be slightly easier to work with than the "undiminished number from the tooltip".

But I love that it tells me how much mastery to get rid of without having to do any of that tricksy maths.

Meloree wrote:I think the dodge/parry thing is slightly unintuitive, if there's any kind of way to enter the numbers as ratings or "read right off the armory page" it might be slightly easier to work with than the "undiminished number from the tooltip".

Thanks: that's very useful. If I could make a couple of suggestions: you might want to consider adding an option for the parry food buff, and it would be helpful, if I'm under the block cap, if it told me how much mastery I need to acquire to reach it.