plopinou

Hi there,
I'm reading this post and using your spreadsheet for quite a time now. I find it really awesome and sincerely thank you for your hard work.

In the version 0.483, i already saw that with a WF totem, being in battle stance and DW with a very slow MH or use a 2H, was as effective, if not more, than being in berserker stance. Spamming Hamstring on top of the auto-attacks and others specials habilities lets you have a suffisant amount of dodges to make the improved overpower dps very interesting.

But in 0.484, the overpower dps seems to be a lot higher. In fact, it's clearly too high. I'm finding 5 dodges in 2H per mn where i found 3 in 0.483.
So i searched a little, and i believe you just did a little mistake when you changed the overpower equation for the OH. The OH weapon speed is set to 1.0 if no weapon speed are detected, which gives a probability of 25% to have 1 or more dodges in 5s, instead of 0% as it must be.

OH calc in the right part of the C63 cell should be then (1-WhiteOHDodges/100)^(5/SI(FinalOHSpeed=0;99999999999999E+20;FinalOHSpeed)) or something like that, if i'm not mistaken.

(My apologies for any grammatical or orthographic faults, because i'm not really good in english :-( )

 

• Ren

When you set your execute swap weapon to Axe or Sword, that means you're not using a main hand weapon at all, so you can't execute.

 

livenletdie

lol see I knew if was a mistake on my part.

 

Deathwing

My current version is at work now, so I'll take a look on Monday. Thanks for catcthing that error.

 

snurre

I just can't get this to work.. In Excel at work it crashes whenever I try to change anything, and in OpenOffice Calc at home I get this error in all fields with calculations:

 

Deathwing

What version of Excel do you have at work? As for the OpenOffice error, does it refer to a certain cell?

 

snurre

Excel 2003 Professional SP2

I didn't have time to see if the errors in OpenOffice referred to anything specific. I had to leave for work :/

 

damgyeah

Off the topic,

I have few options here,

1st - "Hatchet of Sundered Bone" + "Crul'shorukh, Edge of Chaos", with Edgemaster's Handguard. or
2nd -"Hatchet of Sundered Bone" + "Blessed Qiraji Pugio" with Gauntlets of Annihilation. or
3rd - "The Castigator" + "Anubisath Warhammer" with Gauntlets of Annihilation

I have those items in my invent. and having hard time deciding the right combo for the best dps in PvE(Raid).

Any Suggestions? or Advices?


Current PvE Dps Gear http://ctprofiles.net/1391524


P.S, The Dps SpreadSheet is hard to understand...

 

◊ Zoroaster

Damgyeah:

Are you a human? If your a human you have the +5 maces bonus, which would be very nice for bosses. I currently use the Hatchet + Pugio and Edgemaster's, Edgemaster's are a bit better then Annihilation if both of your weapons are effected by the +skill. Also I am human and have an Anubisath Warhammer in the bank and am trying to grab the next Servo arm that drops, had really bad luck with Servo's, only 2 so far and we have 10 bosses on farm.

Btw, thanks for all the work you've put into this Deathwish, much appreciated.

 

damgyeah

yea.. unfortunatly I am not orc/human.. so I don't have that +5

and we never had servo dropped for us... I am still trying to figure out what +7 weapon skill would do for me.

knowing the fact that im losing around 70ap, chance to hit, and crit. still curious if it's worth over all that lose...

anyway i can see that castigator/servo + anub hammer(+4 mace) would work out great. but i am not too sure about wielding

weapons with same speed, example (castigator + hatchet, or servo+servo, etc..)

 

snurre

The Edgemasters vs the rest kinda depends on the fight.. On fights like C'Thun, Loatheb or Patchwerk I wouldn't use Edgemasters, as such a small portion of the hits will be white. But on more aggro sensitive fights where you can't spam HS and stuff, Edgemasters gets a little edge I guess.

 

Khalim

Thanks Celando, I knew you would come up with something usefull with it. Guess not much more can be done with the graphs without putting it into a statistical package for conture graphs etc.

Using the solver for ratios is nice though mine for 10dps using zerg/ww is:
Ratios
2.07 Crit to hit
16.74 Hit to AP
34.56 Crit to AP

Handy to know

http://ctprofiles.net/2868856

 

Asraji

I´m not that into the theorycraft like the others here, i´m more in testin.

So i startet with a MSA + Anubisath WH, a few weeks ago. Now i finally got the Castigator too.

I´m human so i decided to use MSA + Castigator and i just think im doin more dps but its quite difficult to see with swstats cause its pending all the time and not quite exact i think.

Wonder what your opinion to the Weapon choice with these 3 Weapons would be.

-------

Other thing i cant work with your actual Version. When starting it its filled up with Errors in the DPS Calculation in the lines of the Crusader enchants and i cant get rid of that.

 

kickz

has anyone ever thought about fetish of the sand reaver? i think ill try it out on my fury warri

 

◊ Zoroaster

I'd agree that GoA > Edgemasters for Loatheb/C'Thun, but I love having Edgemaster's on for Patchwerk. I get more rage from my white hits, so I can keep Heroic strike Q'd up the entire time and hit 2-3 hamstrings per BT cooldown to proc overpower.

Sometimes it can be hard to tell the difference, when possible I try the different gear on the same boss and just look at the meters, when learning Patchwerk I did better with Edgemasters, so I stuck with them. Your playstyle will also have an impact on what is the best for you.

 

Celandro

On agro sensitive fights its easily the best trinket available. In addition, it allows you to deathwish at the start of the fight which can be a significant boost. Its especially good if you have a fast MH weapon like Silithid Claw or Iblis.

 

kickz

what do you mean? you use hamstring to deal dmg when you switch to battle stance to use overpower?

 

Deathwing

Ok, got a lot of work cut out for me for the next release, so don't hold your breathes for a new version soon. Lots of theoretical stuff to work out.

Celandro, about standard deviation for executes. I was thinking, could it be implemented the same way flurry and crusader are? FinalSpeed/(1 - (chance last swing didn't generate enough rage)). I think the equation needs some work, but what I'm going for is that in the same way for flurry you check if there was a crit in the last three white swing, with execute you check if the last swing generated enough rage.

Snurre, I use Office XP at home, not sure what I use at work, but it works fine in both places. I'm really not sure how to help you, I don't know shit about debugging Excel crashes, and I know even less about OpenOffice.

Asreji, are you saying you open up the spreadsheet and it's already full of errors?

Damgyeah, what did you find confusing about the spreadsheet? I will admit it's hard to just jump into, but in order to push forward and achieve more accuracy and flexibility, the complexity will have to increase as well.

I'm going to trust the person earlier that says SS and HoJ eat flurry charges, and extend that onto WF unless any Horde players can object.

 

Celandro

Deathwing: that may be the simplest way to handle it although i have reservations about how it will handle very fast weapons and offhand crits (since offhand crits should generate enough rage for an execute). Its really tricky with mismatched main and offhand and I dont want to think about it today :P.

 

Avam

Hi!

This is my current gear/spec/raid boss buffs as a DW spec Warrior:

www.nethead.com/~fatalis/DWBoss.xls

I've used your spreadsheet for awhile since it's pretty damn accurate.

Now, the other night I got Severance and decided to plug it in the spreadsheet with my current DW gear with 10% to hit just for kicks and giggles >< . I took off the OH 2% crit and changed my 4 points in DW to 4 Slam.

Results:

www.nethead.com/~fatalis/2HBoss.xls

How is it possible that with worse gear(10% to hit is partially wasted) this 2hander can out dps DW by so much ?

Did I do something wrong when plugging it in ? Or is there some calculation on the spreadsheet that s way off ?

 

• frmorrison

I saw a dps difference of 12 dps (deep wounds is not included it that, with a 2H that would make it more).

I don't know that his spreadsheet shows that WF eats flurry charges, he made a comment about it earlier.


Anyway, there have been a few screenshots that show 8.6% to hit has a use with 2Hers on bosses, so most of your hit gear may have a use.

DK - Ashbane Failure is the condiment that gives success its flavor.

 

Deathwing

I haven't upped the +hit limit, I'm still waiting on more solid info before I change it.

Besides that, 2 reasons I can see right away, 1 of them a bug. I don't use enchant on Execute Switch yet, because I haven't found an elegent way of combining the stats if you do use Execute Switch. So for now, take the enchant off.

Second, Windfury heavily favor's 2H, simply because it won't proc off OH swings.

Oh, one other thing. You aren't fully utilizing all your time on the DW sheet. Go to the calc page and look at your yellow swing field. That field can go all the way up to .66666, which is 1/1.5s. The 2H sheet is pretty much at the limit.

 

snurre

Lol, when I open the DWBoss.xls, all calcs work fine. When I open 2HBoss.xls I get the same errors all over the place as I do when dl'ing the standard one.

There must be some setting in the sheet that breaks everything in OpenOffice, gonna try fooling around and see wtf is going on


Edit: Was swapping out some gear here and there. When I changed the boots in the DW sheet from General's Boots to Chromatic boots all fields with any calculation ended up with an "Err: 523"

 

Avam

Went back and fixed them....

#1 Took off Overpower for both since its bugged (Prob hurts 2H more)
#2 Took off the enchant on the Execute Switch
#3 Now both sheets full utilize time .... both close to .66666

Here are the updated links:

www.nethead.com/~fatalis/DWBoss.xls

www.nethead.com/~fatalis/2HBoss.xls

So according to spreadsheet .... 2handed DPS is far superior to DW due to WF ?

 

Khalim

Can't notice any mistakes on the spreadsheet but your DW talent spec is DW pvp not max pve. Try with standard 17/34 build for max pve single target dps
http://www.wowhead.com/?talent=pbhxbhbZVV0VgxoVo

you're missng 1 in DW and imp execute. With that build I get 758 dps on your DW set, 4 dps higher than your 2H build.

Other factors in it being so close as far is I can see:
- You have the bare minimum hit for DW, 10% is low, get up towards 15% and you will notice definate difference in DW. Even lossing 3 crit to gain 5 hit will get you 8 more dps

- Not useing egemaster gloves - use with say crul or a sword with pergio for more dps than castigator. Only mace worth using is prob MSA and again only if DW MSA or using with Anub warhammer (unless human of course) - if u didnt know glancing blows suck and yeah its a stupid mechanism :)

- more DW items: use ony neck if you have it, get a better cloak (you should have access to a lot better), wristguards of veng or quraji bracer is also nice, DFT > seal for DW

- check the difference with no consumables just raid buffs, DW draws further ahead

- the slam on Deathwings spreadsheet is highly optimised (i.e directly after a white swing), this is actualy pretty difficult to time in a messy boss fight (i.e most of naxx) therefore giving a further advantage to DW where you only have to watch BT, WW c/d's and use excess on ham/hs.

- You have one of the best 2H in the game duh :)

http://ctprofiles.net/2868856