Home > Spreadsheets, Utilities and Addons > Shield Tank Spreadsheet v. 4.3.0.1

Shield Tank Spreadsheet v. 4.3.0.1

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.

About these ads
  1. Hanago9
    December 19, 2011 at 5:34 pm

    Impressive work sir. I love how easy to use the spreadsheet is.

    Most enlightening thing for me was the Reduction/Observed Reduction results.

    • December 20, 2011 at 3:51 pm

      Thank you! It’s very flattering to hear that someone else finds my work useful.

      It’s ma’am though :)

  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

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: