Glory

I think some Racials are a bit bad in Numbers

Gnome: Escape Artist 150 Points? I got Warbringer, every 15 Sec Charge +30Sec Intervene

Dwarf: Stoneform 10% Armor only 50 Points (Its an additional Trinket nice for Maexxna and Patchwerk enrage ... Well timed worth much more than 50 Points, the Bleed remove can be nice, rest is not needed because if there are really bad poisons/diseases they should be dispelled immediatly. Uptime*24k Armor from Items(if Buffs don't count) is about 100 Points.

Draenei: Hit Aura -> one other Draenei in your Raid which would be a shaman you bring in for Heroism and this bonus is gone.
Gift of the Naruu -> if you really need it you cant use it, because if you cast something your Parry/Dodge is 0% so you better let it be, correct me if this doesn't count for Gift of the Naruu.

Nightelf: 2% Miss is not worth 4% dodge, sure it is better than 2% dodge (Bosses can miss if your Stunned) and has no diminishing return. Well i'd calculate it as 2,5% dodge. Well they are still best tanking Class now.

Human: Dont know how often you can use Every Human for Himself on a Raid Boss. If its very useful its as good as your inferior Trinket so about 1500 Points in this single Fight.
Expertise for Swords Mace nothing to say.

Orc: Stun is about ok, you may can get hit once less on stuns where it works. Expertise for Axe nothing to say.

Troll: amout the same as Gnome, i got warbringer but i think thats not in your number. Haste can be ok, but remember Parry Haste :P.

Undead: Fear is no Issue for Warriors. You can use Berserker Rage in Defensive stance. If a boss Fears more often than every 30sec you have still Priests to help you. If thats not enough you may got 2 Warrior tanks who Taunt after fear and Tank till next fear. There is almost no Boss you cant Taunt.

Tauren: dont know how Base Health is exactly defined but looks about right.

 

Taliafears

Yeah, the AEP for the racial abilities has always been pretty intuitive. I never really took them seriously, since they're outside of what the sheet can calculate and (therefore) the AEP for a race is basically just cosmetic. I think you're spot on in your assessments there; warbringer certainly does reduce the value of escape artist and stupid human trick, and draenei racials are of limited usefulness. I guess I never looked closely enough at Stoneform to see the armor bonus, heh.

 

jlafleur

Great spreadsheet. Thanks for making it.

The base attack power for warrriors is 220 at level 80 instead of 190.

 

Jayde

Great spreadsheet, I've found it extremely useful so far.

That said, I did notice that [Barricade of Eternity] was classified as Malygos-25 in the sheet last I looked, when it appears to be a Malygos-10 drop from various reports I've seen and the Wowhead comment/datamining.

 

Taliafears

New release:

- fixed GemList to include all gems again
- updated Amulet of Wills (+25 dodge rating, -25 defense rating)
- added Patchwerk25 to boss list
- added parry mechanic toggle for bosses, like Patchwerk, who do not speed up attacks after parrying one of your attacks.
- adjusted mob block value to 76, appears to be the new value at 80
- adjusted AEP for various racial specials, these are still pretty intuitive so don't put too much stock in a race's AEP
- changed the proc on Darkmoon Card: Greatness to 300 Str (it picks whatever non-stamina stat is currently highest on your char)
- adjusted Executioner enchant, never got updated when ArP changed to a rating
- updated source of Barricade of Eternity to Malygos10 rather than Malygos25 (it drops in both)
- moved Base AP to the Numbers sheet, changed it to 220

 

Vysogota

Are you sure that it drops in both versions? As far as I know, 25-man Malygos drops only ilvl 226 items and 10-man Malygos drops only ilvl 213 items. This shield is ilvl 213, so it shouldn't drop in heroic version.

 

pman1088

Incredible work!! I would like to add a suggestion:

Mining (500 HP at 450)
Weapon Chain (Hit being the Important stat I think)

 

Opostrophe

When weighing towards Threat and DPS, it seems like Block Value is always getting 0 weight. Shouldn't it have some relevance because of its affect on Shield Slam damage? Or am I reading something wrong?

Great work and keep it up!

 

Taliafears

I've acted on the last few postings here but have little to say that won't be in the change notes (thanks for the reports).

I wanted to quickly post a finding I just made: according to the character sheet and wowarmory, austere earthsiege's bonus armor and the toughness talent are multiplicative, so your total armor gain is 1.1*1.02=1.122 or 12.2% more armor.

 

bung

Thanks for this, but I have one question.

I do not know excell well enough to back figure where you have defined your constants like "BaseMiss" (I do appreciate your use of them to make the formulas readable). Where can I see these constants you've used?

EDIT: Never mind, I gave up too soon. Insert > Define > Names, is where I found it in openoffice3.0

 

Taliafears

The actual values to change will be on the Numbers sheet, which I try to hide before I make a release to avoid confusing people with gory details (as if the sheet isn't confusing enough). You can see it by going to Format -> Sheet -> Show (in OpenOffice), and then select "Numbers".

 

Taliafears

I forgot to reply to this. There are actually quite a few Naxx items that wowhead has listed as "Drops in both Normal and Heroic". I can't personally verify that info so I simply trust that it is true. However, on the sheet I just list those items as Naxx10, because it helps you get a sense of how difficult it is to obtain, and that's primarily how I use the source column.

 

t0x1

Thank you for the hard work.

I'm surprised about the high AEP of Expertise. I thought Expertise was only to avoid being parried, avoiding the next attack time increase it causes. Am I missing something?

 

Taliafears

Expertise can have a very high value because it helps with all aspects of tanking. By reducing parries it lowers both the average damage the boss does and reduces the possibility for a burst. It also increases your TPS/DPS and if your expertise is lower than 25 or so (buffed) the sheet will show it being twice as valuable as hit (since you'd still be removing dodges).

Unfortunately there seem to be a number of bosses that do not parry-haste (due to a soft enrage or absurdly high damage like Patchwerk). We know for certain Patchwerk doesn't parry-haste, and I think Maexxna is another. I don't know which other bosses have that flag set but it's possible a good number of them do. So I am considering turning boss parry haste OFF by default, but I'm still looking around for information.

 

Taliafears

Well I've been wanting to work set bonuses into the sheet but I think I'd rather do it a little more carefully than I have time for in the next few days. So I've uploaded an update with a big fix for the threat/dps value of BV/Str.

Changes:
- repaired a problem where NxtStat BV and Str were not being added to Shield Slam damage
- added Titanium Weapon Chain
- added 500 HP bonus for miners
- adjusted Toughness to reflect that it stacks multiplicatively with Austere Earthsiege
- adjusted Austere Earthsiege's special AEP to reflect multiplicative relationship with Toughness

 

◊ Birdemani

WotLK Level 80 boss AP - TankSpot

Has this come up elsewhere?

Relwin: Besides, the BB is not some ivory tower of WoW knowledge, it's just less stupid here than elsewhere.
DeeNogger: Not less stupid, better stupid. The BB takes stupid very seriously. Now if you will excuse me, I have to go misspell the word fire.

 

Taliafears

I don't really deal with it in the sheet, I just assume demo shout is up in the WWS parses I use to figure out boss damage. However the data from that post looks pretty good; I'm willing to believe 5/5 imp demo is worthwhile.

 

bung

EDIT: Deleted

 

Taliafears

I see you figured out that it's correct after all. It's very confusing but it turns out that your dodge from your base agility is NOT subject to diminishing returns.

 

Vysogota

While I hold WoWhead in high esteem, it's not always 100% correct, especially when it comes to drop locations. Mixing normal drops with heroic ones is a known issue there and this shield is a good example. If you check it on Armory, you'll see only "The Eye of Eternity" as a drop location, which means 10-man version (25-man would be listed as "The Eye of Eternity (Heroic)"). Items that drop in both versions are listed like this.

There is a change to that in the lastest PTR patch notes - it will be 50 Stamina instead of 500 HP.

 

Edgewalker

Thanks for the work brother.

 

illusive_2008

Any chance Snapper Extreme (40+ hit) could be added for list of Food buffs please? Also any support for Jewelcrafting Trinkets to show im using Figurine - Monarch Crab with (2) Solid Dragon's Eye. Nothing game breaking but helps me figure out overall stat weight for what I actually have in game.

 

illusive_2008

Also just to make sure I am viewing this great sheet correctly and making what I think to be spot on gear choices. On Conversions on the gearlist page, the Conversions is base stat weight and Calculated Conversions is stat weight with my current gear on the Fitting Room with Gem choices?

AC Str Agi Sta Def Dod Par Res Blk BV Hit Crit Exp AP Has ArP B R Y

1.0 3.5 8.1 14.0 10.5 8.8 7.6 0.0 3.5 4.0 4.0 1.1 5.0 0.5 0.8 1.2 336 238 252

Calculated
1.0 3.3 8.3 11.3 9.4 8.8 6.7 0.0 5.0 3.5 3.0 1.2 13.8 0.5 1.0 1.4

From everything I have read from responses Expertise weighs so high since it works till Parry cap? I just figured as Tauren Stamina would still hold higher weight per point. Just curious is all since I want to make sure I am working towards best in slot based on overall stats. Thanks for help, was just concerned with I saw + hit so low when I am only at +164 rating.

 

Nyxie

Remember that Endurance only increases base health by 5% now.

 

illusive_2008

Yep I completely understand that, was just wondering how Expertise was higher then Stamina really and hit so low. Hey numbers are numbers, and this sheet has been spot on for me. Just want to make 100 percent forsure im reading it correctly.