I've put together a kind of gear spreadsheet for tanking warriors and thought I'd share it.

I use an armor equivalence points (AEP) system to score items. All values are fully adjustable to suit your needs, but I arrived at the numbers in the chart fairly rigorously.

It takes care of all your gemming for you at any quality level. It analyzes the value of the socket bonus and decides whether you should stack your best gem (usually full +stam) or try to get the socket bonus. There is a threshold you can adjust in case you like to meet socket bonuses when the decision is close. If the socket bonus is worth getting, it also calculates the best gems to place in each slot based on the stat weights.

It has a fitting room where you can try on gear and have it predict all kinds of stats (buffed or unbuffed) like your average damage taken per second, your average TPS, etc etc. Use the options tab to indicate your relevant talent choices.

I'd love for some folks here to take a whack at it and let me know what I should fix.

Currently the sheet is being upgraded for the pre-WotLK patch 3.0. When the expansion is released I'll begin adding new gear; for now just making the sheet accurate for Burning Crusade under 3.0.

http://www.mythgaming.net/wow/armorwarr20081027.xls

ALTERNATE LINK - Savefile.com
Last Updated: Oct 27, 2008

Strange.. works when I click it.

I added a savefile.com link to the opening post, in case anyone else is having trouble with my mythgaming.net server.

Working for me. Nice thing.

Nice spreadsheet. Few things I've noticed you are missing:

Trinket: Commander's Badge

Commander's Badge - Items - World of Warcraft

Buff:

Leader of the Pack

Cape Ench:

+120 Armor

Hand Ench:

+8 Sta Kit

Consumables:

Flask of Fortification

Also, are we to assume that this does not account for talent specs? I've noticed that my health was way off, and I'm guessing that the missing HP is from the 10% Str and 5% Sta talent? Would be a nice addition to have this accounted for, at least an option for whether you have selected the talent or not.

Just checked out the options page. Nevermind on the talents thing.

The health seems to be off. I'm missing almost 600 HP on my sheet.

The reason the sheet predicts 600 less HP for you is because you are stacking solid stars in every slot. The sheet recommends a more balanced approach, stacking solid stars only in items with crappy socket bonuses. You can adjust that behavior by changing the threshold in the Options tab to a negative number, or by adjusting the value of dodge/def/parry/agility down below stamina.

I realize the stam/avoidance debate has valid points on both sides, I just went with the numbers I derived - which were aimed at max survivability between heals. This is because in the content I run, the only time I die is when healers are silenced, killed, or moving to avoid an AoE. Your mileage may vary, but that's why the weights are adjustable.

Nice work! I don't precisely agree with the weightings but that's why I can easily edit them after all.

Anyhoo, small issues:
- [Destroyer Legguards] appear to have had their socket eaten
- [Darkmoon Card: Madness] and [Belt of the Guardian] are missing. I'm guessing a few of the good +spell damage tanking items from BT are out as well, didn't specifically check. I realise that most people don't wear these things and have decent belts with no caster stats, but some of us are more hated by the Loot Gods than others.
- The "Ign" column doesn't appear to update correctly when altering the weightings, at least in OO. Image:

The StaBonus, SockBonus & Final columns have updated as they should with my prefered weightings, but the socket ignore setting has not. This may well be working as intended or a bug in OO, I don't rightly know.

Edit: I should add that the last line on that screenie is the red socket for T5 legs that I added myself, it still doesn't behave as I imagine it should.
Edit 2: Gah, nevermind. I didn't realise Socket Bonus Threshold defaulted to a non-zero value. It feels a bit unintuitive, but that may just be me 'course.

Yeah, I have the threshold set to 20.. that's my baggage, seeing greyed out numbers just irks me unless absolutely necessary.

I didn't add madness because if you're gonna spend a ton of money in the AH, you may as well get vengeance for the threat. I suppose you could get both and have 102 stamina.

Paly gear I didn't add because I don't want to clutter up the list. The more "junk" data is there, the harder it is to skim over and look for loot you really want. It's true there is a big gear gap for warrior tanking belts, but when 2.3 hits we are all gonna have access to iron-tusk anyway. It's worth thinking about.. maybe I could make a sheet full of "alternate" gear, that you could still select in the fitting room?

I uploaded a new version with T5 legs fixed, and the enchants/buffs Edimus listed. Couple of other bug fixes I found too.

Your implementation is entirely correct, that's how it works. I get 525 health from a Flask of Fortitude, you get 500. I can't think of any effect that's somehow applied after my multiplier.

Few things are missing:

- ZG enchant for head
- [Pendant of Titans]
- [The Unbreakable Will]
- as stated above +8sta kit for gloves is still missing

Should be all I think, keep up good work!

Very nice spreadsheet, I think it was quite a lot of work.

And now my notice:

The AEP values for Block is way too low. Running Karazhan block is not that significant, but later it is important to have a healthy amount of block chance as a warrior with shield.

The 19 AEP for dodge compared to the 2 AEP for block is far from reality in my opinion. The reason why you could have this result is the lack of block value, as you have more and more of it, block becomes better.

Just a few numbers

19 AEP for a dodge rating means that 1% of dodge is 19*18,9=359,1 AP
2 AEP for a block rating means that 1% of dodge is 2*7,9=15,8 AP

359,1/15,8=22,73

So 1% of dodge worths 22,73% of block?

6k hits from a boss, 100 hits
you dodge one, that's 6k less incoming damage.
you block 22,73 for an average amount of 600, that's 13,6k less incoming damage.

And there are also crushings removed by block, quite a lot of burst damage can be mitigated by some bosses via basic block even if you spam shield block.

Forgot to mention, since agility is a simple hybrid of dodge/armor/crit, I changed the weight for agility to derive from those other weights as a formula. You should never have to update the weight for agility yourself.