Archive

Archive for the ‘Utilities and Addons’ Category

Shield Tank Spreadsheet v. 4.3.0.1 on Google Docs

February 1, 2012 Leave a comment

Hello my lovelies,

After nearly a month without a computer I’m back in business, with a shiny ‘new’ desktop. Raiding is now prettier, but significantly less comfortable.

At the request of some guildies who don’t have Excel, I have uploaded the DR spreadsheet to Google Docs, and done the necessary adjustments to make it functional and user-friendly in that environment. None of the math has changed since I uploaded the Excel version of 4.3.0.1, so you should use whichever format you prefer.

Any future updates to the spreadsheet will be done in parallel on Google Docs and the Excel version.

Read more…

Advertisements

Shield Tank Spreadsheet v. 4.3.0.1

December 18, 2011 2 comments

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

Well I have some egg on my face.

I was messing around with full shield block uptime on Ultraxion and caught a basic probability error in my Hold the Line calculation. An egregious error which brings shame upon family. (My parents met in a graduate-level math course, to give you an idea of the magnitude of this shame).

I have corrected the error, and you can find the updated spreadsheet here: damagereduction_4.3.0.1 .

Thankfully, while the fact of the error was monstrous, the amount of error it introduced into the spreadsheet’s “recommendations” was very small. Warriors talented into Hold the Line may see a slight difference in their optimum dodge:parry ratio for overall damage reduction, but paladins, warriors without Hold the Line, and warriors gearing for CTC instead of damage reduction shouldn’t be affected by the change.

Thank you for your patience, and I’d just like to reiterate how very contrite I feel for having published this error.

Shield Tank Spreadsheet v. 4.3.0.0

December 10, 2011 Leave a comment

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

Here’s the most recent spreadsheet: damagereduction_4.3.0.

Changes from version 4.2.2.0:

  • Raised the cap on Shield Block and Holy Shield uptime to 100%, to allow modeling of the Ultraxion encounter
  • Changed CTC calculation to include Shield Block if its uptime is at 100%
  • Fixed a few formulas broken by the above changes.

I was also unable to replicate on my home computer a bug in the last version’s Yes/No dropdowns. Hopefully this means it resolved itself. If you experience this bug in the new version (you’ll know it when you see it) please drop me a line, either in the comments below or at uncrittable AT gmail DOT com.

Shield Tank Spreadsheet v. 4.2.2.0

August 31, 2011 Leave a comment

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

If I’d been a little more timely in updating this space, this would have been version 4.2.0.1, but whatever – it’s not like warriors or paladins received any survivability changes in this patch or in the recent hotfixes.

Read more…

Shield tank damage reduction spreadsheet – updated for 4.2

June 25, 2011 Leave a comment

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:”

damagereduction_4.2.0

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.

Read more…

Tanking Add-Ons

September 26, 2010 Leave a comment

Blizzard’s UI is lacking in some key elements for every role in the game, and tanking is no exception. For the most part you can make do without addons, but for a few vital bits of functionality, here’s what I recommend every tank have: Read more…