'Complete' Protection Warrior DPS/TPS spreadsheet

[Airowird]

Now updated with some small fixes

[Airowird]

Just a question; would people be interested in a tab with defensive stats?

Considering how many defensive stats I already needed for the Parry haste, adding a few more to calculate avoidance & EH numbers wouldn't be too hard to add I reckon. As long as anyone is actually interested in them

[Trondhjem]

I'd be very interested.

The more a spreadsheet tells you (while staying clean and simple), the less different spreadsheets you need.

[r9sid9nt9vil]

Awesome sheet, it puts allot of light on why I was having aggro/threat issues. Def. sheet waould be a great idea.

http://eviscerated.net

[Airowird]

Working on it now, V1.05 will contain T10 bonuses & defensive stats!!

[drae]

Last night on Tankingtips.com, a guest appearance by Wartotem's Spreadsheet.


That's right, Vene refers to your illustrious spreadsheet in his latest blog.

You are slowly becoming famous Wartotem

[Airowird]

I noticed the attention, the # of downloads ofthe latest version doubled today O_o

More incentive for me to keep working on it, knowing people use it

[drae]

Keep up teh good work man, it is appreciated

[Rashor]

Nice that you're getting so much attention. A thing that doesn't really matter than much since prot warriors rarely have ArP while tanking anyways. I did some testing the other day and I believe there is an error in cell "E17" Actual Boss Armor.

When Sunder Armor or similar is used on a target you are reducing the Armor and then also the "ArP cap".

If I have understood everything in your sheet this is the "ArP cap"

From cell E17:
MIN(E9;(E9+400+85*E8+4,5*85*(E8-59))/3)

You are using the base armor when it should be the armor after the armor% reducing debuffs:

MIN(E9*(1-(E43+E44));(E9*(1-(E43+E44))+400+85*E8+4,5*85*(E8-59))/3)

Unfortunately I didn't save my test values but if you don't believe me, I can do the testing again. Keep up the good work!

[Airowird]

Hmmm, thought I had it right, I'll look into it.

I'll slam some sunders on a dummy and throw some conc blows & shockwaves at it

[bryn]

This may be overkill, but have you given any thought into including Damage Shield?

It's usually only a small threat number, but when I'm in a full unhittable set for Anub Hard, I see Damage shield hits around 1200 (with SB and trinkets popped).

[Airowird]

I've thought of adding Damage Shield, but I didn't consider it worth it for pure TPS output, because I needed so much more stats for it. Now that I am working on a complete spreadsheet, that will be one of the things I will add, as well as Retri aura and Thorns.

@Rashor: Think I'll need some test results because it seems I only have 78 ArP in my bank, which I find too small to provide accurate testing results.
If you or anyone else could give me the numbers of the armor reduction on a dummy for:
* Unbuffed
* Sunder stack
* High(pref 300+ atleast) ArP rating
* Both of the above
I'ld be very greatful

[Karilyn]

Small Warning: I use OpenOffice.org for spreadsheets, which I then convert to .xls format to upload it here. This could possibly give problems in future versions when certain code is incompatible with Excel. Unfortunately, I can't do anything about that except upload the original file in a zip everytime, so if you have problems with the MS-Excel format and wish to see the original .ods file, let me know.

I would certainly appreciate the .ods file.

[Rashor]

I've thought of adding Damage Shield, but I didn't consider it worth it for pure TPS output, because I needed so much more stats for it. Now that I am working on a complete spreadsheet, that will be one of the things I will add, as well as Retri aura and Thorns.

@Rashor: Think I'll need some test results because it seems I only have 78 ArP in my bank, which I find too small to provide accurate testing results.
If you or anyone else could give me the numbers of the armor reduction on a dummy for:
* Unbuffed
* Sunder stack
* High(pref 300+ atleast) ArP rating
* Both of the above
I'ld be very greatful

I'll try to find the time in the beginning of the week.

[Airowird]

I would certainly appreciate the .ods file.

I'll upload an ODS zip as well tomorrow then.

[Rashor]

Ok, here we go. I used Thunder Clap for the testing since it hits for the same every time(more or less) and it has a shorter CD than CB and Shockwave. Before I started testing I tried doing Thunder Claps on a friend to make sure I had the formula correct(since I know his armor). My testing shows me that a boss dummy has 11 621 Armor. This is the specc I used:

Talent Calculator - World of Warcraft

Damage formula for Thunder Clap:

(Basedmg+AP*APcoeff) * Defstance * Mitigation * imp. TC * 1h-spec.

(300+AP*0,12) * 0,95 * Mitigation * 1,3 * 1,1

Armor formula:
Armor/(Armor+400+85*(Target level+4,5*(Target level-59)))

ArP Cap formula:
This is where our formulas differ:

WarTotems formula:
MIN((Armor+400+85*Target level+4,5*85*(Target level-59))/3;Armor)

Rashors formula:
MIN(((Armor*(1-0,04*Sunders))+400+85*Target level+4,5*85*(Target level-59))/3;Armor*(1-0,04*Sunders))

Where "Sunders" is the number of sunders on the target. The difference is that my formula reduces the ArP cap aswell when you put up sunders(and buffs that reduces armor by a %).

So the actual armor with my formula will be:
Armor*(1-0,04*Sunders) - ARPrating/1400 * MIN(((Armor*(1-0,04*Sunders))+400+85*Target level+4,5*85*(Target level-59))/3;Armor*(1-0,04*Sunders))

Which is then inserted in the Armor Formula and you get the mitigation that is used in the Thunder Clap formula.


I got the "Actual DMG" from doing 10 Thunder Claps with each setup and then took the average value.





The only case where our values should differ is with both Sunders and ArP Rating and as you can see my model is more exact. On a sidenote: If your model was correct that would mean that it would be possible to reduce the armor by more than 100%, in theory. I'm a bit tired so please check it for errors.

[Airowird]

You're right, it would be able to penetrate more than 100% total armor (assuming the separate ArP cap is 100%)

Thanks for the numbers, I'll change it now & update it when I release the next version

[Airowird]

V1.O6 release: Now with Stat Weights!!

[Zkall]

According to the spreadsheet my heroic throw appearently does more threat than devastate/shockwave/concussion blow, anyone else getting this?



Every thread i read so far they say Shield slam > CB/SW > Deva for tps, seems a bit odd.

[tom]

Aye. For me it says that Heroic Throw is slightly more threat than Shield Slam (even with glyph), which is entirely possible. I have yet to confirm this.

There is (I think?) a small amount of travel time involved with HT even at close range. You still probably don't want to use it unless everything else is on CD and your rage is very low.