Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Class Mechanics » Warriors

Closed Thread
 
LinkBack Thread Tools
Old 10/16/07, 10:56 AM   #1
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
Tanking Spreadsheet

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

Last edited by Taliafears : 10/27/08 at 11:50 AM.

Offline
Old 10/16/07, 12:31 PM   #2
Tylerlee
Von Kaiser
 
Human Warrior
 
Stormrage (EU)
dead link

Offline
Old 10/16/07, 12:37 PM   #3
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
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.

Last edited by Taliafears : 10/24/07 at 7:16 PM.

Offline
Old 10/16/07, 12:43 PM   #4
Meyla
Von Kaiser
 
Meyla's Avatar
 
Night Elf Warrior
 
Bronzebeard (EU)
Originally Posted by Tylerlee View Post
dead link
Working for me. Nice thing.

Poland Offline
Old 10/16/07, 12:59 PM   #5
Edimus
Glass Joe
 
Night Elf Rogue
 
Malfurion
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.

Last edited by Edimus : 10/16/07 at 1:06 PM.

Offline
Old 10/16/07, 1:08 PM   #6
Tylerlee
Von Kaiser
 
Human Warrior
 
Stormrage (EU)
Firefox can't find the server at MWC06 - News.

Thats what i get.

Tried in both my browsers :S

Offline
Old 10/16/07, 6:47 PM   #7
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
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.

Offline
Old 10/17/07, 3:50 AM   #8
Xerophyte
King Hippo
 
Xerophyte's Avatar
 
Awnh
Tauren Warrior
 
No WoW Account (EU)
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.

Last edited by Xerophyte : 10/17/07 at 3:57 AM.

Sweden Offline
Old 10/17/07, 9:46 AM   #9
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
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.

Last edited by Taliafears : 10/17/07 at 9:54 AM.

Offline
Old 10/17/07, 10:17 AM   #10
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
Come to think of it, as a Tauren warrior could you tell me about the health bonus?

I implemented it as a 1.05 HP multiplier after all health sources. Is that the way it works? When you get fortitude, is it 5% better because you're a Tauren? When you drink an elixir of fortitude does it work 5% better than the rest of us?

Offline
Old 10/17/07, 10:34 AM   #11
Xerophyte
King Hippo
 
Xerophyte's Avatar
 
Awnh
Tauren Warrior
 
No WoW Account (EU)
Originally Posted by Taliafears View Post
I implemented it as a 1.05 HP multiplier after all health sources. Is that the way it works? When you get fortitude, is it 5% better because you're a Tauren? When you drink an elixir of fortitude does it work 5% better than the rest of us?
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.

Sweden Offline
Old 10/19/07, 7:27 AM   #12
Meyla
Von Kaiser
 
Meyla's Avatar
 
Night Elf Warrior
 
Bronzebeard (EU)
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!

Poland Offline
Old 10/19/07, 9:58 AM   #13
Derrewyn
Glass Joe
 
Draenei Shaman
 
Bloodscalp (EU)
Block totally underrated

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.

Last edited by Derrewyn : 10/19/07 at 10:17 AM.

Offline
Old 10/19/07, 10:12 AM   #14
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
I don't particularly want to argue about math in this thread, you can adjust the weights as you see fit. However, I was assuming Shield Block, so that's why Blk came out to a ridiculously low value. I ran my algorithm with boss speeds ranging from 1.25 attacks/sec to .5 attacks/sec and Blk regularly came out with a dismal AEP. I can't recall if Blk was cutting into crushes at that point; I may run the numbers again but I doubt I'd come up with anything larger than 5.

The big reason to increase Blk's weight is to achieve crush immunity without Shield Block. This spreadsheet is already your most useful tool for that goal (get your dodge/parry/miss/block to 100% in the fitting room). You will not want to sacrifice very many other stats, so the low weight is still helpful, in my opinion.

I uploaded a new version of the sheet with the necklace and weapon, and more enchants. I just skipped the +8 stamina kit in favor of +10 since it is coming in 2.3 and trainable by any Leatherworker.

Last edited by Taliafears : 10/19/07 at 10:21 AM.

Offline
Old 10/19/07, 10:24 AM   #15
Taliafears
Piston Honda
 
Taliafears's Avatar
 
Night Elf Rogue
 
Malygos
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.

Offline
Closed Thread

Go Back   Elitist Jerks » Class Mechanics » Warriors

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
[Tanking] Java Tanking Simulator Twid Class Mechanics 12 05/08/07 5:50 AM
TBC Tanking Movies - Druid Tanking by Athinira Athinira Public Discussion 139 02/05/07 11:14 AM
MC Tanking Help? TheCrunkOne Public Discussion 18 02/02/06 3:56 PM

« - | DPS Compendium »