You can manually enter the items. Just click on the tabs at the bottom according to slot.

i do like how you can manually make the items yourself, but some items seem harder to make than others. like the 3% increased crit damage meta gem and armor penetration. not sure how to include those in there.

I know this is a lazy question but...is there an updated version of this anywhere? This one (the one linked on page 12) does not seem to have the Season 2 Arena stuff and is missing some other PVE gear as well.

Yeah, this is true. It's easy to add most items. I think I could add the gem, but I'd be even happier to see that someone who was more confident in their excel did it

When I add stuff, gear that is not included or not updated, other stuff gets fucked up but I cant really see why. Maybe it is because I am not using Excel, but Open Office.

When you add an item, I find that it works better (on both software) to add it to a new row in the middle of the list. Beyond that, I'm not sure. OO works for me.

Where is the latest version of the spreadsheet ?

And is it worth using to give values to Warrior DPS items both for 2h and DW ?

I've made a few additions/corrections to the spreadsheet.

1. Added a bunch of SSC/TK items.
2. Fixed the doomplate 2 piece bonus not being detected correctly. (Gloves weren't being detected due to the "Set Bonus" column containing "Doomplate 2 piece" instead of "Doomplate")
3. Added support for the relentless earthstorm diamond.

I'd like others to test my implementation of the diamond to make sure it is correct.

Summary of methodology:

-Added diamond to gems sheet.
-Added entry under "Set Bonuses" on the "Gear_Buffs" sheet to detect diamond's presence. (There might be a better place to put this.)
-Changed crit calculations on the "Unbuffed DPS" and "Buffed DPS" tab to include the extra 3% crit damage.

The file can be found at:

http://files.filefront.com/Warrior+0.../fileinfo.html

Could you possibly add support for the Thundering skyfire diamond aswell.

I'd try it myself but I'm not that good @ excel/OO stuff.

ty for the update.

i was a little disappointed that it still doesn't support 2h builds yet but it's a good start. the relentless earthstorm diamond update was really huge, helps me out a lot.

i decided to get a SEP value for each dps stat as close to 2H MS/Slam spec as possible with the best gear available on the spreadsheet. and here are the results (only take then as a grain of salt)

Str: 1
Agi .94
AP: .45
Hit Rating: .76
Crit Rating: 1.29

some things to note during the experiment:

- used DW mechanics with 24% miss rate and such. this will overvalue hit rating and other stuff (used S2 Gladiator sword for MH and Death's Sting without enchants on offhand)
- results with the new spreadsheet are with relentless earthstorm meta (not doubting it yet but it may have some flaws in it's beta formula)
- no imp slam incorporated into the cycle
- socketing as much crit while getting the socket bonuses
- 31/30 build
- buffed stats: 3365 ap, 43.82% crit, 8.54% hit

results: even after stacking your sockets with crit, crit is still more dps per item stat budget at endgame raiding. agility is still the best stat for warriors who sometimes tank in dps gear. my thoughts on buffs giving too much ap and not enough crit, therefore, making crit more worthy was right.

but further testing is needed. one with a spreadsheet capable of working with 2H weapons, incorporating imp slam into it's cycle, and BT/Hyjal gear is what we need.

Probably not that worthwhile. +weapon damage doesn't scale any better with haste than any other stat and is generally balanced for faster weapons than warriors use (i.e. daggers or, better yet, cat form). It's easy enough to do a decent equivalent AP approximation for the trinket.

Assumptions:
- Infinite fight, the trinket is better than this in any fight of finite length
- 2x 2.3s weapons, the trinket is stronger for faster weapons. Whirlwind & OP make the weighting favor the mainhand, 2.3 should be a decent average for most warriors.
- We ignore that AP affects BT and +weapon damage does not, which is probably the most significant error and will cause an overestimation.

With those assumtpions we get 7/2.3 + 216/6 = ~79 AP.

That's likely a fair overvalue for the majority gear setups and also about 6 AP less than a Bloodlust Brooch, which scales just as well with haste rating. It's certainly not bad for a blue, but not exactly mind-blowing either. Leave it to the kittens.

I noticed that the spreadsheet values crit heavily over hit and haste rating. I thought hit and haste, especially haste, would be the best stats for a warrior. The only reason crit is valued so high is keeping Flurry up, I guess.

Is this correct?

Agree it's probably not much good for a warrior (love it on my druid). But:

Worse than any fight of finite length. In 2.5 minutes you can use it 3 times.

Missing assumption is that you use the trinket on cooldown rather than trying to line it up with effects that scale AP - ofc this will result in using it less frequently and may well be a net loss, but worth mentioning.

Err, yes, that was my point. I think you mentally removed the "this" or somesuch

Yes, read the above comments

Updated
http://files.filefront.com/Warrior+0.../fileinfo.html

Just reviewed the haste formula. I believe this is more accurate.

whoa, that was a fast update. thx

after messing around with it a little, i noticed that haste rating is the best DW stat when UNBUFFED. it's dps value seems to diminish A LOT when buffed. why is that? is it because flurry/mongoose makes it diminish? or is that a bug on the formula?

also, now that haste seems to be a constant stat on high end gear, can we possibly add haste into the SEP conversions? adding armor penetration would also help out a lot but that seems too complex right now (at least for me lol). this could also help implement BT/Hyjal loot that have haste/armor penetration into the spreadsheet.

That's because he forgot to add the haste value from items (Q116 I think) again .

Haste scales very good. Dragonstrike seems to be the best weapon by far with my estimated 46-65 haste (That's only 2-3% chance).

I'm wondering if haste rating is as good for 2H mortal strike / slam dps than for dw dps.

White damage is around 30% of my dps, white hits are often followed by a slam and I often spam slam while WF procs are generating rage.


Haste rating will reduce the delay between 2 white hits
I guess it would also reduce the delay between and the landing of a slam and the next white hit.

Will it impact slam cast time ? or the GCD between 2 slams ?

Just a quick question guys, I just downloaded the latest version of the spreadsheet and it seems you can't select a 2h weapon. Is this tailored for DW fury only?

Haste rating is good, but the effectives diminishes as rage generation goes up. Burst haste rating in a raid situation is just about impossible to utilize in a good rotation, however, it's great to get you started when you were off a mob for a while and have no rage coming back to it. Haste Rating does not from what I've seen, affect the cast time, and it definately does not affect the GCD. There is no point to getting haste rating + flurry to reduce your swing time below 2.5s (higher even, when you take into account your ping); it just results in delayed white hits in your slam/special rotation, so it doesn't add any more damage at all.