[Warrior] Tanking TPS sheet. - Page 11

Zaroua · 10/14/07, 1:20 AM

Has anyone done the math on the TPS gained from having expertise?

[Gauntlets of Enforcement] 21 expertise rating
[Brooch of Deftness] 21 expertise rating
[Bracers of the Ancient Phalanx] 22 expertise rating
[The Brutalizer] 21 expertise rating

85 expertise rating, or 21 expertise points (rounded down). Add in an extra 6 points from Defiance and you've negated Dodges/Parries on lvl73 mobs (assuming 5.6% for each?). Or you could remove 1 item from that list and take down the chance of a 73mob to Dodge/Parry to 0.1% for each.

Would using these items be the single best way to increase TPS and reduce insta-gibs from mob Parries?

Healranktwo · 10/14/07, 3:13 AM

Originally Posted by Zaroua

Has anyone done the math on the TPS gained from having expertise?

[Gauntlets of Enforcement] 21 expertise rating
[Brooch of Deftness] 21 expertise rating
[Bracers of the Ancient Phalanx] 22 expertise rating
[The Brutalizer] 21 expertise rating

85 expertise rating, or 21 expertise points (rounded down). Add in an extra 6 points from Defiance and you've negated Dodges/Parries on lvl73 mobs (assuming 5.6% for each?). Or you could remove 1 item from that list and take down the chance of a 73mob to Dodge/Parry to 0.1% for each.

Would using these items be the single best way to increase TPS and reduce insta-gibs from mob Parries?

I do believe expertise is single best stat by far atm for a tank with how it works. I do think mobs have a higher chance to parry then dodge though, since I notice mobs parry my attacks far more often then they dodge it.

Punscho · 10/14/07, 9:38 AM

My data suggests about double the parry chance for level 73s.

Expertise should be the best stat point by point. 1 expertise (~4 rating) is 0.5% less avoidance. Compare that with 0.5% hit which requires ~8 hit rating. Plus the reduced instagibbing it should come out on top with ease.

Punscho · 10/15/07, 1:45 AM

New version finarry.

nilme · 10/17/07, 12:46 PM

Last version does have some errors for me, excel whines about some data lost and half of the sheet is skewed with div/0 errors (excel xp/2k version). I'm using Excel XP

Punscho · 10/17/07, 1:07 PM

Heh, probably because OO crashed on me when I tried to export to XML. I don't have Excel myself so I'll just try to export again and upload it and let you test it.

Edit: done.

nilme · 10/17/07, 2:52 PM

Originally Posted by Punscho

Heh, probably because OO crashed on me when I tried to export to XML. I don't have Excel myself so I'll just try to export again and upload it and let you test it.

Edit: done.

Same error again

Guess Ill have to install OO

Punscho · 10/17/07, 4:06 PM

Strange, OO 1.1 always made working .xls.

I'll try googling for some answers later, soccer @ TV atm.

I added an Excel 95 version aswell hoping it will work. I find it strange the other version doesn't work since I don't use any fancy stuff at all.

nilme · 10/19/07, 6:48 AM

Originally Posted by Punscho

Strange, OO 1.1 always made working .xls.

I'll try googling for some answers later, soccer @ TV atm.

I added an Excel 95 version aswell hoping it will work. I find it strange the other version doesn't work since I don't use any fancy stuff at all.

I'm starting to think it has something to do with my computer. Thing is, I used this spreadsheet like 2-3 weeks ago and had no problem.

Baraz · 11/17/07, 3:36 PM

I have some #N/A errors when using XP Office myself, so I don't believe it's just your computer there nilme.

Isidur · 11/17/07, 5:02 PM

Here is updated my personal version. (4.1)

* 2.3: Expertise change
* 2.3: Hit affects to shouts & thunderclap (still not fully modelled)
* Added Mob specific values. (Extra Parry, see: WoW Forums -> Raid and Dungeon Encounter Update)
* Added TEP calculation (based on first cycle)
* TPR for Thunderclap with no Imp thunderclap fixed

Note: For Orc and Human racial expertise should manually added since there is no weapon information, or put your expertise number in "outside of defensive stance"

Download

Borodin · 11/17/07, 7:56 PM

Originally Posted by Isidur

Here is updated my personal version. (4.1)

* 2.3: Expertise change
* 2.3: Hit affects to shouts & thunderclap (still not fully modelled)
* Added Mob specific values. (Extra Parry, see: WoW Forums -> Raid and Dungeon Encounter Update)
* Added TEP calculation (based on first cycle)
* TPR for Thunderclap with no Imp thunderclap fixed

Note: For Orc and Human racial expertise should manually added since there is no weapon information, or put your expertise number in "outside of defensive stance"

Download

The change to +Hit was for Taunt and Challenging Shout only, not Thunder Clap.

galzohar · 11/17/07, 8:30 PM

Leveling weapon skills (from rather low level), I noticed I get a LOT more parries than dodges/misses/glances, which settles well with bosses having more than the "0.2% per level" of extra parry. Nothing new, I know, but then again it was never really proven so I figured taking very low weapon skills would make it clearer that the high parry for bosses is probably correct.
Maybe I'll parse it next time I'm leveling a weapon, although does WWS have any way of tracking the actual weapon skill you had when you landed the attack?

Kamgha · 11/19/07, 2:41 AM

#N/A problem is dealing with macros I believe, since when I load this up in OO it asks me about macros and when Enabled it works fine. But I believe macros are disabled in my Office...

Quick thing I wanna link from Satrina's A Guide to Threat from tankspot.com (EvilEmpire is being updated atm)

Battle Shout ________________________ 68 (Split)
Cleave ______________________________ 130 (Split)
Commanding Shout ____________________ 68 (Split)
Concussion Blow _____________________ 0
Demoralising Shout __________________ 56 (Split)
Devastate ___________________________ 109/119/134/148/162/176 (see below)
Disarm_______________________________ 104
Execute _____________________________ 125% Damage (Unaffected by Stance Multiplier)
Hamstring ___________________________ 181
Heroic Strike _______________________ 196
Mocking Blow ________________________ 290
Piercing Howl _______________________ 0
Revenge _____________________________ 200
Shield Slam _________________________ 307
Spell Reflect _______________________ 100% Damage
Sunder Armor ________________________ 301
Thunderclap _________________________ 175% Damage
Whirlwind ___________________________ 100% Damage (Unaffected by Stance Multiplier)

Devastate/Revenge/HS/SS in the newest version 4.1 seem to be off. I am also unsure whether this is closer to correct or Omen is closer to correct in game as sometimes i can do 1.1-1.2k TPS Sustained vs. this spreadsheet showing myself maxing out under 1k.

Truthfully this spreadsheet is awesome and helped me get my rotation/gear choices up til now and prolly will for the future. Great job on this

Punscho · 11/20/07, 2:46 AM

You probably have to tweak the target's armor reduction. There's a thread in this forum that deals with armor values for raidbosses.

Nice work on the update, since I stopped raiding several months ago I'm not that inclined to update it quickly or even that often anymore. Of course I have some thoughts on the update but until I get off my ass and update it myself I should just be quiet right.