One big problem with the spreadsheet atm is it doesn't seem to use or carry over the leftover rage in a cycle after HS is included anywhere; so stats that significantly increase rage generation and directly leads to more HSs are undervalued in comparison to those that have less of an influence. It also causes large jumps in DPS when the threshold is reached to allow one more or less HS per cycle. Removing the INT() from around the formulas in the HS column in the DPS sheet changes that to a more fluid value and shows +hit rating being about 10% better than the spreadsheet showed before. It may be a more accurate estimate overall.

Also, and this one seems much more difficult to model to me, execute spam atm is simply considered to be 1.5s cooldown and assumes as long as your RPS is over the cost of execute, you get one off every 1.5s. But, with slow/slow being a fair advantage in dps with both higher WW damage and more flurry uptime, and +hit being considered the weakest stat from a pure DPS perspective, it's quite possible that the choppier rage generation during execute range could lead to plenty of slack between a GCD being used and getting the hit or 2 needed to execute for the next. I currently just swap to Slow/fast to even out that out a bit, but i'd be very interested if anyone has any idea of how to model the actual percentage of times you reach 15 rage in a 1.5s window, and then the average slack afterwards for those GCDs where you don't beat the 1.5s limit in order to give a more accurate average cooldown time. If a formula for that is possible, which I vaguely think it would be from the probability course I slept through, then execute spam would be muuuch more accurately modeled and there could even be a swapped in weapons part of the Gear section to show which give the best execute DPS too. Considering it's 20% of the fight, it seems like the current formula oversimplifies the reality.

Lastly, the rogue DPS spreadsheet has an interesting Upgrade macro to compare swapping in each piece of gear and then tell you which give the largest dps upgrades. I'm not very experienced with Excel macros, so I wasn't sure how to attempt it, but it's a very cool feature that would be nice to see added.

I guess you're using the 9.1.6 version? In the test version the number of HS are computed over the full fight length and the excess rage is added over all of the fight (maybe not for execute phase though). The number of HS over the entire fight is then calculated from this rage. This will be a fair representation of the theoretical number of HS you can do. In reality, you will do even fewer. I agree that the implementation in the previous spreadsheet may have underestimated the HS damage since you never used the extra rage, but in the test version you do. Download that version and see what you think of it. The number is still rounded to integer, but keeping it a float will only add a maximum of 0.5 HS (to a number 50-100 or so).

Ofc, it simplifies reality, it's a model . I agree that this issue is real, and it's the reason you should always use fast weapons (both MH and OH) for maximum damage during execute phase. Furthermore, the same effect can actually also ruin your BT/WW cycle during the rest of the fight if you're unlucky. With a slow/slow setup and lowish +hit (i.e. 9-11% or so), you can get miss streaks that are so long that you will not have the rage to maintain the cycle, and lose a lot of dps compared with the model. With great gear, you'll probably get enough rage anyway, but if you're just starting 25-mans it might be better to stay away from that particular setup.

I don't think you can model this in a closed form, you'll have to run simulations to find it. I doubt you can make those simulations inside the sheet (but sure, I'm not an expert on spreadsheets so maybe it is). One could possible run some simulations with some predefined values for weapon dps AP, crit, hit, haste and so on, something like 20 setups or so, and then make a table with the 15/12 rage per 1.5 sec "uptime" for these setups. The spreadsheet could then use the "uptime" to calculate execute damage from the setup nearest to the one in the sheet.

That would be really nice.

Please test this:
1.0beta1
You'll figure out by yourself, what isn't ready yet.

Recently on TankSpot.com in the theories and guides section there has been a recent topic come to light upon Protection Spec PvE DPS (0/20/41). It has been known for a while now that Prot DPS has been around since the Devastate talent was introduced but I haven't located any true math craft sessions for it regarding the actual calculations.

Using the warrior dps sheet it's fine for entering in gear for Arms and Fury specs. Is there some way to add in the modified changes to support a prot dps spec such as 0/20/41. Aside from the talent data being added into the sheet the proper rotation would have to be added too. The rotation would consist of a 1 Whirlwind to 6 Devastates, a 1:6 ratio. Devastate does 50% listed weapon damage and an added 35 damage per application of sunder armor currently on the target and costs 9 rage per use when talented for, I'm sure most of the people here are aware of this already...

The reason why It might be a decent idea to add is for the warriors who like to do the off tank role yet stay in to dps on a said boss instead of sitting out. I know on our last few Teron Gorefiend attempts I let another warrior tank him since he has yet to experience the encounter while we were letting others get familiar with the ghost controls. To sum it all up as my full normal tank spec in my DW DPS gear I was pulling a consistent 850 to 890 dps without being grouped with a ret paladin, shaman, hunter, imp bs warrior, or feral druid. This was wasn't with the 1:6 ratio rotation but just going at it with devastate , it wasn't until after the raid that i went into deeper thought on the topic of prot warrior dps.

Summary:
- Possible to add a 0/20/41 Spec to the Sheet?
- Possible to add in a 1:6, WW to Devastate rotation?
- Theory craft on protection spec dps

Could you try the same setup in the test spreadsheet (i.e. not the beta above, but the version before, posted a couple of pages back). I think it's the same old problem that's been in the sheet all along, that extra rage is just enough to give you one more HS during one cycle (you can check that by looking at the number of HS you get for a certain cycle, and compare the different weapons). The test sheet changes this to calculate the number of available HS over the full fight. Why you get more rage using the fast s2 offhand I can't explain (maybe it's how UBW is modeled).

To drAllcom, I took a look at the beta sheet, but as it's no longer at all compatible with OO, I can't really do anything with it. The 2.3 (go-OO version) can't run the scripts in that sheet. Not sure if it's supposed to.

OO doesn't like Useforms, sorry. Tell me a way to convert them and I'll do it.

I've been using this spreadsheet for a while and it has definitely helped me. Thank you.

I am curious though - I've read that using a MH and OH with the same speed grants you 4 flurried attacks. Is this (a) true (b) factored in to the spreadsheet?

Maybe if I shift some cells around it'll do. Without a nice GUI of course.
Edit: I guess, marking things with a color and locking/hiding everything else will do.

I have a question about the way the spreadsheet models chance on hit enchants on the offhand during a whirlwind. Is this modeled into the spreadsheet calculations, because it could have an effect on the PPM rates of things like mongoose on the offhand, which were previously 1PPM but now could be more with WWs using the offhand weapon too. If so, would that make this enchant better than potency for a slow offhand? The spreadsheet says no according to my setup but that's why I wonder about the WW offhand proc issue.

Also, I noticed that the stats given on the mongoose enchant include the agility boost but not the attack speed increase. What kind of values should I be inputting into the haste portion of the enchant to make it truly accurate?

1.0beta2
Set2 is what it would look like for OO users. At least usable I think. There are no dropdown menus, it's just a preview.
I guess the whole sheet is correct and up-to-date now, since noone gave feedback.

dr_AllCOM3,

I'm trying to test the new spreadsheets but I got to say I'm at a loss for how to use it. I'm using Excel 2003 and the sheet appears to be very segmented. You mentioned that OO doesn't have dropdown menus, so I'm assuming that implies that Excel should show some but I don't see any. Is it just formulas that you want us to look at in this version?