I found something somehow odd if not totally strange. I was playing with the sheet, adding small numbers to see how dps will increase and it increases more or less linear while adding various stats. However I noticed a very big 'gap' at some point.

So, I have this stats (my raid setup buffs, wf):

AP: 3356
Crit: 34.62%
Hit: 14.92%
Haste: 6.69%
-Armor: 3210

DPS shown is: 1097.8

Now, I increase hit with 30 then one point step by step:

+30 hit = 1107.9 dps
+31 = 1108.2
+32 = 1108.6
+33 = 1108.9 (17.01% hit chance)
+34 = 1125.2 !!! (17.08% hit chance)
+35 = 1125.5

There is another gap like this on the line of around ~8% hit, but I understand that, because you actually nullify the misses with special attacks and the increase of dps could indeed jump a bit more. But on 17% ?!! What happens there? Is there is a flaw in the formula? Or its simply a 'magical' sweet spot?

EDIT: I've did more tests using other stats also. I'm pretty sure there is indeed a flaw in the formula. I kept original stats and added 33 hit to reach the sensible point. After that, increasing any stat with 1-2 points leads to the big jump.

P.S. And btw, there is something wrong with mongoose, everytime I save/load a set I have to remove the mongoose from weapon, check/uncheck the error button box and put mongoose back or else I get a #VALUE error

I get the same problem with Savagery. Very nice spreadsheet though. Seems fairly accurate for what my DPS is.

Could you upload your files please? (Here or somewhere else) It's kinda hard to find by myself.

Mongoose is very tricky, I'm aware of that problem too (not a very high priority). Shouldn't happen with Savagery. Can be related to DW (switching from 2h to DW with Mongoose to be more precisely).

My sheet plus gear

Just change 33 to 34 in manual entry area and see the dps jumping.


Cheers

My find is that even in a 10-man with my current gear, speccing for BF/MS and losing Imp Zerk, Rampage, and Bloodthirst would still be preferable with only 1 or 2 other physical dps classes present.

And both 2H Fury builds far out-perform D/W Fury builds. And also I see the gigantic boost an enh. shaman can add.

Here's my question, does this sheet assume a perfect Slam (easier to do with that Quartz swing-timer mod,) and how is that cycle performed...

For instance, you label one cycle as 4 Slam, BT>WW. I presume that means you Slam, BT, AA, Slam, WW, AA, Slam, BT, AA etc?

Those were the sorts of cycles I read about in this thread: http://elitistjerks.com/f31/t12386-w...e_dps_warrior/ - which, as it is huge and I read at work, I haven't yet finished pushing through.

Also, can anyone tell me how you model Romulo's Poison Vial?

After so much time as a tank, and making general assumptions about viability of certain spec's for raids, and which offered more DPS and utility, this has certainly turned that around.

Its cool, warriors like getting bigass weapons to thump on people with, now it looks more like they can actually use them for something other than PvP.

Hi,

nice spreadsheet so far.

But you missed weapon skill for 1h axes on Buffed DPS S8 and S9

Just wondering if anyone can help me. I downloaded the latest spreadsheet. Have both files open. I get to browse through the items fine. Then when I can the talent layout, by selecting 17/44 and hit load. The DPS display says error. And going to the gear page and double clicking on the box on top doesn't help the situation. Anyone know what the problem is?

On a closer examination. It seems that the gear total agility displaying #value, and Total Crit is also displaying the same thing. Looking closer. Am I suppose to edit what mongoose suppose to do? It seems to be causing all the errors.

Edit: Got my sheet to work without mongoose on my mainhand. Anyone know what my issue is with it?

Edit2: nevermind, got it to work...

Hm, i think i found a bug..races with +weapon skill (orcs,humans) have 0% miss even with 0 hit rating and 0 points in precision(2h and DW). Bug or it's happening only to me?

It was the sweet spot between 3 and 4 Heroic Strikes in the Cycle .

Oh, yes. I was too lazy back then and forgot.

Ah yes, didn't test that and I'm a (damn sexy) Tauren.


### 0.9.2
- That fixes above
- 1000 Items by Sheit (Furaah, Ner'zhul EU)

Without that DW/Mongoose bug it could go 1.0 ....

Thanks for all the hard work Allcom, it's really been a joy working with your excellent sheet.

I have one nitpick though: You currently don't leave room for a cloak socket!

cloak of darkness - Wowhead Search
Vengeance Wrap - Items - World of Warcraft

It seems this was fixed by the guy that made the ITEMS file by simply slapping some extra stats onto the cloaks. It's still a valid something to nitpick about though, I hope

I'm getting crit and hit errors at a point I'm not really sure on, but adding a ring, then replacing it, then adding the original ring back will keep making hit climb. I ended up with 24% hit and 44% crit doing this. I also ended up seeing a theoretical 1824 DPS with a 2h and the highest I could reach DW was only 1462. This makes very little sense.

Still seeing really strange discrepancies in DW compared to a 2h rotation. According to this sheet, a 2h build with a perfect (which is pretty hard to do) rotation is a good 27% higher.

do it by hand and you will see 2h slam will be a lot higher dps than DW.

The bolded part is important here. In fact I would say that it's impossible. You cannot maintain the perfect slam cycle over a full fight (change in positioning, lag and so on), and this will lower the dps of these builds by quite a bit. Basically, don't try to use the spreadsheet to compare the damage output of 2h and DW builds, neither of the cycles model reality perfect (and the slam cycle is probably worse than the DW one for describing reality).

Yup, best way to work out your own efficiency with your slam cycle is monitor what dps you're running at compared to the spreadsheet and then make a note.

For me, the spreadsheet isn't a way of checking, "omg! It says I can do 1700 dps!" but more importantly a way for me to figure out and plan gear needs. Figure our what gear is actually an upgrade, how much of an upgrade and compare bits of kit to decide which to aim for.

I don't really care.

Hit cap?

It is for comparing items mostly. Everyone knows, that DW does more damage than 2h.

Oh, I was somehow thinking about +Weaponskill.

Weaponskill should still improve the damage output as it lowers the ammount of dodges.

Anyway thats not why I came here to post.
I have been having some problem lately. I used the 0.91 version of the sheet sucessfully for several days then suddenly excel complains about circular references as soon as open the spreadsheet and after that warning nothing what so ever happens with the dps values even if i change gear around.

I also tried to download the newest version 0.92 to see if that was any different but it wasnt, still getting the same warnings and having the dps values being static.

Yes I understand it's for comparing items, but it's comparing items at an optimal cycle, otherwise what's the point really? If you are throwing cycles out the window, then something that is shown to give you a 5-10 DPS boost may only really be giving you a 2-3 "real world". And by using the optimal setup, there doesn't seem to be any real upgrades until mid - late Hyjal/BT. Hell, there isn't even a better bracer than the one off of Gruul unless you start going after leather...which is fine after all of your Rogues and Ferals have those items. I can't find a single reason to take the Furious Shackles over Bladespire Warbands or Bracers of Eradication, unless you were just unfortunate enough to see neither of the previous bracers drop. Which is quite possible...16 Lurker kills and no bracer off of him so far.

I also don't know why my crafted axe is still showing up as the best MH I can get outside of the Warglaives, but it is. Hopefully they end up buffing the Hyjal/BT items similarly to how they are SSC/TK. Otherwise, I have no weapon upgrades to look forward to besides an extremely minor upgrade with the nerfed Swiftsteel Bludgeon. Although the sheet is showing the Fang of Vashj as being the best off-hand outside of the Warglaive, but we already have another two Rogues wanting that dagger first. I'm not trying to sound like I am whining if that's how it's coming across, it's just that I find it very annoying to be sitting in the same exact gear all through SSC/TK. Maybe I am just too spoiled in that I got two pieces of Destroyer relatively early, but then Kazzak decided to hold onto his shoulders until I got T5. We just got a raid keyed for BT, so the upgrades will come eventually...

Thats because of bug in spreadsheet. With Fang (and sword/axe if your human/orc) you will have 0% miss no mater what hit rating. Same bug like in main-hand some time ago, but it was fixed.

I'd like to find out if [Rising Tide] would be an actual off hand upgrade over [Merciless Gladiator's Hacker]. Logic says yes, but the spreadsheet says no. I'd rather have the Rising Tide/Swieftsteel Bludgeon combo, but apparently Rising Tide isn't a MH upgrade.

Sadly Graul thats how BT and hyjal loot is at the moment.Especially on weapons.I am wielding the combo of Dragonstrike and Bludgeon.There is no upgrade here until I get warglaives and that scenario is impossible since i am in a new guild and like 3-4 rogues and 1 dps warrior are infront of me.Now with the haste nerf many items are becoming same with SSC-TK gear its quite funny.Band of Devastation,Swiftsteel shoulders the Haste Belt from Hyjal(which was ridiculous allready) all those items are same level with SSC-TK gear not to say worse...even my pillager gaunlets will be worse than grulls.......hands....we are talking about 1st 25 man compared to last instance of the game at the moment...
I dont know but the way haste was budget on items showed that it was INTENTED to be WAYY better than 1 crit or 1 AP rating.Its obvious I mean every piece of gear that has haste lacks either crit or hit or even both.