According to the notes- I think it was discussed a bit somewhere in the thread, but I haven't really tried out prot DPS cycles so I don't know how flexible the sheet is if you are actually DPSing as a prot warrior

I think that would be the best solution.. i'd highly appreciate that :P

I added a few more items to the list, and removed some that I consider to be obsolete.

http://files.filefront.com/Warrior_0.../fileinfo.html

Hmm, is it something with openoffice or is the haste showing up as '###0' DPS increase for everyone else in the spreadsheet aswell in the later versions of it?

This has probably been asked before, but its a 50 page thread....the paste sheet in the file, the graph, what exactly is behind those numbers? Does it include any warrior abilities? If so, which ones?

Has anyone even gotten this to work with OpenOffice? All I ever get with it is #NA for DPS.

Since I have no idea where to find that option, I couldn't tell you.

Hello again! I'm currently working on a combat simulator for Warrior DPS.
Because our raidgroup failed and disbanded I've stopped raiding with my Warrior so I thought I can ask you for some values.

What I currently don't know is the new glancing blow value, both the chance to get a glancing blow and the damage reduction. I searched a bit at some forums but I didn't saw any hard statistics (I'm blind?).
I've just finished the melee attack system which calculates XY minutes of just autoattacking with the entered base stats as AP, Crit, Hit and talents like Dual Whield Spec and Flurry, yes I can calculate Flurry over a long time!

I currently got 1 major problem with my simulations and that is that I'm writing it in VB(.NET) and I just use the default Rnd() function of VB which isn't really exact.
If you got some expierience in programming (C, VB) and you may want to help me just throw out a PM.

Look for posts by Theras, Aldriana and XP-Dolphin in one of the weapon skill threads. Both glancing chance and reduction are between 24-26%, I think.

I'm having a problem (using Open Office) when trying to enter items that aren't in the spreadsheet. I tried to create Traitor's Noose and it just said "Invalid Value" when I did so. Am I screwed or is there some way to get around it?

Found an error. Mace isn't in the list for normalized attack speed.
Suddenly Dragonstrike is much better

If you find one that is Hiyono, I'd love to see it

It kinda does. Create a weapon with the type 2hAxe, change talents and that should be it.

It doesn't work like that, because it still keeps all the OH stuff in the formula, and then excel goes haywire because it does not like dividing by 0.

Anyone have any testing done on the miss rate of special attacks? It seems the spreadsheet uses 5.6%. Ive read a lot that indicates its higher but I cant find anything definitive. Same about specials using 2 rolls.

Ok from what i have read in this forum a good +hit number to shoot for with precision is about 15% to hit or around 170-180 but per the spread sheet If I replace any +hit gem with + Crit it is always a Dps increase no matter what my + to hit is. can anyone enlighten me on the math behind the spreads sheets value or Crit and Hit

Don't forget that procs can't occur on a miss. Windfury totem, Mongoose enchant, etc give a big boost to the value of hit rating.

If your rage generation is suffering, there is literally nothing in game that generates more stable rage per itemization point than hit _ASSUMING YOU HAVE WINDFURY_.

At sufficiently high levels of AP, or for 2h fury, it's probably the same thing for damage based purely on the rogue's rule of "White damage wins eventually under haste".

At attainable levels of gear, you're probably better off with crit in the abstract, simply due to lack of choice on itemization, and as it increases flurry uptime and for many players they simply don't have 100% flurry yet. Personally, I prefer to rock more hit at the cost of other stats simply because I find the rage stabilization to provide more value than a theoretical gain of 40 dps that I then toss away through spikey rage generation. As a raid leader I will _Never_ perform my dps role to 100% efficiency, so I choose the itemization that is most forgiving of me having to yell for someone to get out of the way. Remember that the spreadsheet, unlike a simulation, cannot accurately model "overflow rage" from a "lucky" string of crits. As a result, it will tend to value crit slightly higher than real world performance would suggest.

As with all things in math, it's not just about arriving at the right mathematical answer, it's understanding the model well enough to know what it's telling you.

The spreadsheet indicates that your priority should generally be Crit > Hit > Str > AP > AGI in a theoretical "best case averages" scenario. In practice, crit adds spikes of rage as well as direct and secondary flurry uptime, hit stabilizes rage (and as a secondary function flurry uptime), STR adds damage, and AP adds slightly less damage. Crit's advantage over hit is that it is more effective for increasing flurry uptime. Crit's disadvantage is that the added rage from crit is noticably spikier and thus may be wasted.

So the spreadsheet suggests:

Maximum Theoretical DPS: Crit > Hit > Str > AP > AGI
Most Stable DPS: Hit >= Crit >> Str > AP > Agi

Choose your poison to your taste. If you are able to make use of the spikier rage from crit, or you have bad flury uptime, go crit. If you are not able to make use of said spikey rage, consider hit. Regardless, you care more about the ratings than the STR/AP, for almost all cases.

I suspect that with a combat simulator as opposed to a spreadsheet, you would see more equivalence between crit and hit. The spreadsheet works on averages, like Anaias said, but to see "real life" expression of those averages you need a large sample size (easily seen by looking at some of the parsing done in these forums).

I'll assume you are referring to miss streaks and such.
I run with what some seem to consider a low amount of hit, 107(6.79%) + precision, and I haven't had any problems with missing where it would interrupt my cycle. However I do use a fast OH (Dirge) and don't get WF most of the time. At least for me, and possibly others, I still haven't seen any reason to 'go out of your way' to get hit rating.

I still am working on how WF affects it with my own sheet, which is why I'm trying to find what the miss rate for specials is still. 5%? 8.6%?

PS. Would Bloodthirst/Victory Rush proc WF or MH mongoose? Thanks.

Yes, although I don't know why when you are not actually hitting with a weapon.

is this assuming you have blessing of kings and imp zerker stance? STR and AGI gain more from kings, whereas i don't think crit and hit benefit from it. i probably must have missed the answer, sorry if i did.