Home > Gear, Spreadsheets, Utilities and Addons > Shield tank damage reduction spreadsheet – updated for 4.2

Shield tank damage reduction spreadsheet – updated for 4.2

Well, I never did publish this in 4.0. And by 4.1, I figured it was pretty much unnecessary.

But 4.2 is coming up, and there have been some major changes in stat weights for plate tanks!

  • Agility is now worthless as a mitigation stat for plate tanks.
  • Parry from strength has been slightly increased.
  • Holy Shield has been redesigned away from 100% uptime, making the value of mastery to paladins more dependent on playstyle.

I feel like this is as good an excuse as any to release the damage reduction spreadsheet I keep alluding to. So here it is, in its full, updated-for-4.2 “glory:”


If you’re reading this in the future, the above link may be broken or out of date. Please see the Spreadsheets category for the most recent version.

The spreadsheet is appropriate for both paladins and warriors.

The main difference between my spreadsheet and the other gearing tools/spreadsheets I’ve seen for shield tanks is that it takes into account Shield Block (and now Holy Shield) uptime in its calculations, which slightly boosts the value of mastery, parry and strength for warriors* (and now mastery for paladins) the higher its uptime is.

Feel free to play around with the spreadsheet, and please point out any errors you notice.

*Now, that’s not to say that warriors should seek parry over dodge as a secondary stat: on the contrary, the removal of agility’s conversion to dodge, and the increase in strength’s conversion to parry, puts our parry farther into diminishing returns than it’s been since 3.3.5. It’s more a question of how much parry should be reforged into dodge. While paladins and death knights want to reforge parry into dodge until their parry and dodge are in equilibrium, warriors want to reforge parry into dodge until they are a few percentage points away from each other – the exact number depending on the warrior’s dodge, parry, and mastery stats, as well as their Shield Block uptime.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: