I made some modifications to your sheet. I added item list so u can get item stats just by using the name. I fixed/ add some stuff in 2h, like: Added polearm spec in 2h, Added MS to the dps in 2h, Modified impale in white dmg, Added sword spec in 2h, Added Deep wounds in 2h, Added Rage Spent per Sec, Added abilities per x sec,
Changed execute in 2h

Sheet

Impale doesn't affect white damage. Also, I'd like to keep control of the releases of this spreadsheet. You're free to modify it, but please note that in the spreadsheet if you decide to release. I don't want many versions of my spreadsheet floating around out there.

Additionally, I don't agree with your modeling of Deep Wounds since it's very easy to overwrite itself.

Problem with Thunderfury is it's alot harder to model I think. Or at least need a proc model included that is good, which tend to not be the case. I'm pretty sure that TF should beat all the pre Naxx combo at least due to it's "hability" to use more from to hit then normal combos via the proc and potentially haste.

Also for that list, the order would change assuming different buffs level. For example slow weapons are better with less buffs since you get more out of WW/OP but with full buffs, especially with WF, the faster your 1-h the more dmg you will do, changing the order. So at least a list that account for full buffs would be usefull.

Also you have to do 2-h imo. My own calculations tell me that 2-h is pretty close to what dw fury can do, would be nice to dispell the myth also that DW fury is all there is for warriors atm.

If windfury is available, 2H pulls about even with DW. Windfury is better for 2H because you can spam hamstring.

There is no problem with overwriting deepwounds, it just had a minor mistake. If u consider the chance that deepwounds is up at anymoment its 1-Chance to not crit all your atacks in the past 12 secs, that is 1- ( 1- Chance to crit) ^ Number of Atacks in 12.

I like the data this provides, but would it be possible to have it just input data like the first spreadsheet? Being a user of CTProfiles, its kinda frustrating to have to look up each item and input its stats manually each time.

EDIT : This would also allow for diffrent races of warrior, given that's something CTProfiles already calculates.

Also while I'm guessing the answer is no is there accurate modeling for HoJ yet?

Yes I am referring to your spreadsheet. I want to give it a whril, but the extra time in inputting the gear is a bit intimidating, so to speak.

Honestly I really liked the UI in the first spreadsheet, because from a CTProfile page I could copy a few things over and be good to go. I think Chalon uses extra sheets (not sure the terminology, its how you seperated DW from 2H on your sheet) for the item database, but its a bit...sparse.

The sheets are hidden sheets. Go to Format>Sheet>Unhide and select the option for what item you want.

How exactly is it sparse? I've got every reasonable item a rogue could be using more or less. Let me know what else you think should be there :P.

I've been to AQ40 maybe twice so far :P Hell I still have blue shoulderpads off of Bloodlord in ZG :p

Its not a huge deal, but it kinda stinks to see maybe 3 or 4 of your items recognized by the spreadsheet.

Your comments on the spreadsheet indicate that "The first column for total dps [edit: cell B62] is just White + BT + WW + Hamstring + Full bar execute."

The actual calculation for cell B62 is
which translates to
From my perspective, it makes more sense to include the whirlwind DPS in that calculation, unless I missed something along the way.

Otherwise, the spreadsheet looks quite nice. Just want to make sure that's a typo and not something I didn't understand. Thanks

You're right, that's a mistake on my part. I'm leaning towards just throwing out that model all together because it only accounts for 1 full-bar execute. Which in no way models sustained DPS at all, only DPS on short trash mobs, and I'm sure no one here really cares about that. I'll make sure to change my notes to point out that the 80%/20% model is the one I think models sustained warrior DPS the best. THe 55/45 one is crap as well.

Chalon, how do you make those pulldowns?

Its not that big a deal, a lot of people that use calculators are on a bit more of the cutting edge of gear. I see the value in listing items seperately, I'd just like a way to input all the stats at once (unbuffed AP, battle critrate, hit, skill, weapon damage range, speed) and see the totals. Plus taurens start with diffrent stats than gnomes :p

Also I'm not sure if the dropdowns work in OpenOffice, I had to type in the names manually.

Yeah for those sheets a "overwrite" gear section where you supply unbuff stats that matter like the previous poster said would be nice. Basically if there is something int aht column use that value if not take it from the gear total.

That wouldn't work too well because of stat's interaction with BoK, and hopefully, vitality soon.

I'm leaning towards using Chalon's method of gear input because it's more convenient for most people instead of having to change stats around each time.