Karr

Running it all through the spreadsheet I actually get within almost the exact DPS (about .6 dps) out of sacrificial gauntlets (w/ str even) using CotBD + CHT more than DB + CHT with edgemasters (haste enchant).

http://ctprofiles.net/16388

 

livenletdie

With that info Ren would you say +hit is only more effective than +crit if you've cap'd your +crit given your current +hit? Or am I mis reading what you are saying.

 

Khalim

Oh god we are back to comparing crit vs hit.

Please read Celendo's posts about using the Excel solver to work out exactly what your crit to hit ratio to AP ratio is, its going to be different based on what your current crit, hit and AP is, there doesnt seem to be static ratio that you can use to say hit is worth 50% of crit at all times.

For my gear, raid buffed to get 10 more dps 1% crit = 2.07% hit, roughly 50% but thats at 1874AP, 27crit 16 hit, +7skill, 2 haste. Yours will be different.

Also have a look at the graph of data points, its generally better to get a combination of crit, hit and AP rather than soley focus on one. Ussually you will have to trade some of one or two to get more of the other with the spreadsheet and the ratio's you can work out if the tradeoff gave you more total potential dps which is its main purpose.

In my experiance Rishna generally makes a lot of points (some valid, some just opinion) without much backup evidence.

http://ctprofiles.net/2868856

 

ildon

I noticed it seems like your spreadsheet isn't accounting for booming voice? It's only 10 rage saved in a 3 min fight (or slightly more but still pretty negligible in longer fights), but it'd make me feel better about spending the points there for pvp/grinding. ;) Yeah, yeah, unbridled wrath is better for pure dps... I know...

Or are you just assuming (since you seem to be assuming all optimal conditions on the spreadsheet) that someone else is keeping it buffed for you?

 

snurre

We don't have a talent named Malice, btw.

 

spotmaxdog

I've been playing with this spreadsheet a long time now, and now that I'm in a BWL guild and in the posistion to pick up a CTS or Crul I have a rather disturbing situation happening on the spreadsheet.

My CTProfile is at http://ctprofiles.net/865385 under the DPS tab.

Basically my problem is that Crul+Sickel of Unyielding Strengh and CTS + Maladath are outdpsed in the spreadsheet by the Warblades of the Hakkari with and without equipping Edgemaster's to compensate for lack of +skill. How is it that weapons from ZG outclass two 55dps+ weapons from the end of BWL? Have I made an error somewhere in my spreadsheet plugging, or are the Warblades the best weapons for me until Naxx?

 

Igniter

Anyone done theorycraft on Ashbringer WITH the proc vs MoM? I think it could be rather close, since the PPM is really really high...

*seem to be unable to use the file myself

The BB, where being accepted matters

 

• frmorrison

Blizzard itemized the those swords for Fury warriors very well, the stats + speed is ideal for smashing stuff, and you don't have to wear statless gloves when you use the set.

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

 

TL-Seria

So 48 and 50 dps weapons with +6 skill > 58 and 56 dps weapons with +4 skill? It can't really be THAT much :(

 

Grayson Carlyle

HS spam is probably the answer.

 

Celandro

Nah.. Id put the answer as execute spam.

I bet if you compare the pre 20% dps, the slower weapons are about the same if not better but the 20% dps for the faster weapon hakkar set is going to blow away the slower weapons. Faster MH weapons are much much better for execute spam on the spreadsheet and in the game (but possibly slightly overweighted on the spreadsheet since offhand speed is not considered and offhand crits should give enough rage for an execute).

 

Deathwing

Anyone feel like theorycrafting with me? I think I finally got down the equation for the chance that there was a WF/HoJ/SS non-crit between the 3rd and 2nd melee swing in the flurry cycle(meaning it eats the last flurry charge and your current hit ends up not being flurried).

The only thing that worries me is the chance seems a bit high, almost 15% with WF.

 

• sekdar

There's more to it than that. Weapon speed is very significant at the top range of DPS, as faster weapons give more rage-efficient HSs and let you execute every single global cooldown. Not only that, but matching-speed weapons give you an effective fourth flurry charge. When you add that all up together you've got a winner.

 

K-Muflage

Wouldn't a mainhand swing timer reset break this(HoJ or WF)?

Also, I have a small request. Is it possible to add racial abilities to the spreadsheet(orc blood fury and troll berserking)? Berserking is pretty significant since you can activate it together with deathwish.

 

Latham

how does the spreadsheet work with the lvl 70 talents and lvl 60 calculations? Do you just change player lvl and mob lvl and thats it?


Also I tried doing a comparison of Mh castigator oh iblis and mh servo oh iblis. Why does the servo end up like 5 dps ahead? the proc? didn't make sense to me since they are both maces and servo lacks stats.

 

Deathwing

Yes, just change the EnemyLevel and PlayerLevel fields, you should be set.

MSA procs a lot. I have it estimated at 3.5 PPM, just a guess for now.

 

Cordrisap

I did a ton of research before posting in this thread, tried different programs etc... but in the end i have to ask.

Is there a program besides microsoft excel that can open this spreadsheet without errors so i can use it?

Iv tried openoffice, error city. Iv tried excel viewer, no drop down lists etc.

Is there a free program out there?

Ty

 

Dralmoo

Could someone explain how to use the Solver to figure out hit/crit/ap relative values in a little more detail? I get the idea but I'm an excel noob.

Thanks!

 

TL-Seria

I see, so when I have Iblis, MPSA and Maladath, the best combination would be Iblis * Maladath?

 

Stereophonics

I was quite surprised when I found out that Jom Gabbar gave less dps than Diamond Flask.

Edit : The Castigator + Anubisath also deal less dps than Misplaced Servo's Arm + Anubisath :o

I think the proc dps for Misplaced Servo Arm is too high. It's currently listed as 20 dps increase on the spreadsheet. From my last 2 Patchwerk kill, their proc dps seems to average out to 8 - 9 dps for me.

 

kickz

the best combination is Gressil with Hungering Cold

 

Dralmoo

Also, I have to say some of the results don't make a lot of sense to me, for example Iblis + Maladeth does less DPS than Claw of the Black Drake/Core Hound Tooth, with no other+skill? Shouldn't just the reduction in glancing blows cause an increase in dps, not even counting the much higher dps on Iblis?

 

• Ren

MSA + Iblis is better than Iblis + Maladath, for humans anyways. At execute time, just swap your weapons.

 

Huthuthike

It appears as though both Diamond Flask and Jom Gabbar are modelled incorrectly.

Diamond Flask is listed in the current version as a 37.5 str bonus. However, it only grants 12.5 str on average.

Jom Gabbar is listed as granted a 30 ap bonus. It averages out to 60 ap, though (rounding to the nearest whole).

Earthstrike is listed as a 47 ap bonus, which appears to be in line with the averaging out the ap bonus. Bonus * duration / cooldown, or 280 * 20 / 120 = 46.666666667.

I'm assuming Earthstrike is modelled correctly, and that Jom Gabbar and Diamond Flask have been overlooked somehow. Is there something else I am missing here?

 

◊ Zoroaster

I'll get Procwatch and go farm in Silithus for a couple hours sometime this weekend and see if this is correct. I wouldn't be suprised if the proc rate is indeed 3.5ppm, it goes off a LOT. Is Procwatch still one of the better mods out there for figuring out the proc rates? Its been a while since I had a weapon whose proc rate I wanted to figure out.