Trax

Figured It was all the attackpower as stated in char screen. Then spreadsheet then gives me 1400 dps and I did 1380 on teron last night so it seems correct

 

keshian

Didn't see an option to select Executioner for OH for DW spec, which translates to higher uptime = more dps. Or does it assume executioner OH? Hmm....

 

Barmbul

I believe the current thought on executioner OH is it doesn't stack only refreshes so you get better returns from a second enchant like mongoose or potency. they probably did not include it for that reason.

Armory profile

 

dr_AllCOM3

Doing some stuff right now.

Actually an interface is the hardest part. I hope there are some libraries for the things I need.

Edit: Basically the calculations work.

 

Barmbul

My guild just made the Jump to Hyjal so I’m using the newest spreadsheet to plan my epic gem slots. We all know the red gems will be hard to get as they are coveted by many classes. Max dps shows the best gems to use are +10 STR except where you can gain a good socket bonus then +5str +5crit for the yellow slots. My sep values for the set I have put together are 6.5 str and 6.0 crit which seems to support the opinion of the other sites. Here’s is the question, when socketing if I use all +5str +5crit stones my dps increases by about 5 dps above the Str gems. There is a small increase each time a str crit gem is switched in and not a large jump, which rules out a skill rotation jump like an extra HS. What are you guys in BT/Hyjal socketing with? I think the orange gems will be easier to come by than the red ones.

 

Machinator

Well thats not a good reason to exclude it, as a spreadsheet would be the only way to tell if a second enchant is better than dual executioner. I manually added in DW executioner for testing and there was little change. Two executioner enchants are not automatically bad. This is something I am trying to dispel since I did a lot of work on it.

While we are on the subject, what proc rates is the sheet using? I cant look now but last I saw I think it was off from what testing was showing.

"Information is ammunition."

 

facesmasher

Pretty much exactly as you said. 10str > 5str&5crit.

I also have 2 blues for metagem, which fit nicely in belt/bracers.

edit: this is for a fury based build, I personally haven't even looked at pve arms.

 

Gruntle

Don't trust maxdps.com. If you're able to use the spreadsheet why do you use the inferior calculations at that site. From what I can tell, they do not model rage generation at all, and has no Heroic Strike damage. Also, their SEP values seem off, at least when I put in my stats (getting 1 str = 0.6 crit, crit cannot be that low).

Extra HS should not be an issue in the sheets any longer. Not sure which version you're using but I think (haven't tried all of the sheets around now, I know for sure in dr_ALLCOM3's sheet and my OO version) damage is now calculated over many cycles and the extra rage summed over all of them (and then transformed to HS), this change made the infamous HS jumps go away.

If your SEP values show that str>crit, then you should gain more from a +10 str gem than a str/crit gem (not counting socket bonuses). Maybe you're having some problems with the sheet not updating properly. Try to manually update it a couple of times after changing each gem.

 

dr_AllCOM3

Get 5/5 gems. Everyone needs red gems (my SEP show crit>str, so I take yellow ones).

 

buah

first of all, thanks a lot for this incredible spreadsheet

I am a mostly t5 equipped fury warrior and I was curious to know the dps difference that the season 3 1hand mace would make over my dragonstrike hammer... to my surprise, my dps dropped by 40 dps !! did i do something wrong or is the dragonstrike mace still that good?
thanks,

buah

 

buah

oh nevermind..
i found that the spreadsheet i'm using is calculating the haste effect of the dragonstrike twice..

the season 3 1h mace would give me a 2 dps increase over the dragonstrike.. lol ^^

 

rayijin

Str is better than crit until you reach a certain point. I have s3 MH / s2 OH andabout ~900 armor pen with a few bt pieces, but only 32ish unbuffed crit in zerker. For me, crit now outpaces strength.

Once you have really good weapons / lots of armor pen/strength, the value for crit increases relative to strength. Socket for crit for better dps once you achieve optimal gear as well as because having to compete that heavily for spinels is dumb.

 

Barmbul

I don't use Max just compare it when the spread sheet shows something that contradicts current theorycraft Like the STR > crit thing. As far as gear levels I’m using the spread sheet to plan my dream set so it’s the best of the best. Using that Gear socketed with all +10 Str (except for 2 RB or YB for meta bonus) the spread sheet shows sep values of 6.5 Str 6.0 Crit. Which you would think justifies socketing all +10 str, however I’m showing about a 2.5 Dps increase when socketing +5str/+5crit instead of +10 Str. It’s a small increase but an increase nonetheless. Also after socketing with the Str/Crit the SEP values still show 6.5 str 6.0 Crit.
I’m using the latest sheet comprising of Warrior_DPS, Warrior_Sim, and Warrior_Items.
Anyone have any thoughts on why it might be showing them as a better upgrade?

Armory profile

 

Chirality

Part of the issue is that an SEP estimate is an argument that "increasing my strength by x increases my dps the same amount as increasing my crit by y"....It does not account for the interaction between strength and crit--it's a first-order approximation. The only way to make this calculation would be to include a SEPERATE basis vector for 5crit/5str and give THAT an SEP value. Which, by the way, is actually a fairly good idea. There was a thread about this a few weeks ago--something like 'Taylor Series and First Order Approximations in SEP".

"Mixing" of coordinates is nontrivial when the value of Str scales with Crit and the value of Crit scales with Str, and so on, so I'm not at all surprised that 5str/5crit gems is better than either 10str or 10crit grems.

Edit: The thread i'm referring to is [Math] Stat Equivalence and Taylor Series

 

Gruntle

Hmm, I'm actually getting this as well, even for my T4+ZA gear setup.

My SEP values are 1 for str and 0.92 for crit. Adding 10 str results in a dps increase of 6.51, while adding 5/5 str/crit gives me a dps increase of 6.52. The way we calculate SEP is just not good enough it seems, the difference is tiny but the main thing is that the SEPs are not accurate. As Chirality write, including a separate SEP vector for str+crit should give slightly more accurate results.

Problem is that if I go ahead and change all of my +8 str gems to +4/+4 ones, I get a dps decrease in the sheet. I'm not sure what's happening, seems really weird.

 

Mogwai

From a gem demand perspective, i master loot all epic gems and distribute them individually according to the item being socketed.

On a scale of 1 to 10 with 10 being me getting inundated with requests:

Shadowsong Amythst - 10
Crimson Spinel - 9
Pyrestone - 6
Lionseye- 2
Empyrean Sapphire - 1.5
Seaspray Emerald - 1


Contrary to popular belief i get far more tells for Amythsts than i do Spinels.

 

dr_AllCOM3

Found the offhand racial bug. See first post.

 

NayNay

I have a question about execute, how much dps does execute actually do in raids, without recklessness and close to the best gear, with 17/44.

I know arms warriors don't actually execute, but what about fury warriors?

About 1150 dps without sunders on a servant with normal rotation and 1600 with execute btw.

 

DKP-Borgar

I noticed a thread in the german warrior forum that made me thinking about the spreadsheet's implementation of armor values.

We know that armor values of bosses are mostly 6200 and 7700. Is there a cell (in the spreadsheet) where I could manually change the mob's armor? ArP does have a significant influence on damage at T6 content and most certainly at sunwell. That's why an overall evaluation must imply the mobs armor values. At least it would be helful to compare certain gear choices.

 

Kream

For some reason, prot DPS is showing me as never Heroic Striking. It seems the formula that calculate how much rage I'll have after Dev/WW is off. See Warrior_Sim, Tab Set1, J121. This is probably causing the excess value attributed to +hit.

 

Grim13

Integrated Warrior DPS 1/31/08


1/31/2008
Corrected bug with talent point drop-downs

1/30/2008
Added corrections to Devastate and Attack Power in order to be consistent with Dr_AllCOM3's work, as Warrior_Sim.xls is just his sheet with a few modifications by me
Re-wrote Buffs sheet from scratch in Warrior_DPS.xls, and referenced it from Warrior_Sim.xls
Re-wrote Talents sheet from scratch in Warrior_DPS.xls, and referenced it from Warrior_Sim.xls
Worked the Talents sheet up into something more akin to a talent calculator
Corrected various proc bugs introduced by the integration of the two sheets, to include the Drangonstrike bug
Added hyperlink from "Lag Factor" on Cycles sheet leading to Lag Factor input on Buffs sheet
Added 10s 1/PPM uptime to be used for Warglaives model
Modeled Warglaives set bonus, without bonus anti-demon AP. Manualy enter 200 AP in the appropriate "Gear" sheet if you wish to add it in



Sorry for taking my time. Been a little busy. Hopefully that takes care of all known issues.

Updated link to new host.

 

Chirality

I attempted to download via the link you just gave...but the zip file seems to be empty.

 

Grim13

Something was wrong with the uploded file. I have re-uploaded and it appears to be good now.

 

Torgus

I was in the process of building an end game setup and mix matching gear to see what would be the highest dps set. The way I was doing it was looking up all the gear then adding up the str, hit, crit, etc then adding the total stats into the spreadsheet. I was wondering if there would be a way to add some sort of item database into the spreadsheet or maybe if you guys know of some sort of web based program that does that, or if anyone knew of a faster way. Regardless the spreadsheet has been very helpful and fun to mess with when I get bored in class. Thanks

 

Gruntle

I believe Grim13's version of the sheet has an item database included.