zaon

I also noticed that on the Buffed DPS sheet the offhand factor seems to be calculated incorrectly w.r.t. dual wield spec. With 5/5 dw spec it lists 55% instead of 62.5%.

 

Darkrenown

I noticed something odd. Going from the t4 dps helm with a RED and +8cr to fel-steel warhelm gives me a 10.5 dps increase in the latest spreadsheet, but all I gain stats-wise is 8cr and 1 str while I lose the +critbonus from the RED (hit doesn't matter as I am 2h and hitcapped with either). I don't understand how I gain 10.5 dps from that. If this were correct the +12 cr meta would be a much better choice than a RED.
Edit. Raidbuffed I have 42% crit on the spreadsheet, just in case you think I have a low crit % and that's making the RED crappy

 

dr_AllCOM3

62,50% for me.

No error, there is always a point where you take the next step in a cycle (=moar dmg).


### 9.1.1
- Some error fixes
- Brainlag(tm) for Slam
- Extra rage trough dmg taken

 

luke2kz71

will ring enchants ever get added to this?

 

dr_AllCOM3

There is free space at the bottom, where you can add whatever you want.

 

luke2kz71

thanks i got that figured out...


what about the wrath darkmoon card? would that even be possible to add in?

 

Eliminate2

I'm having a problem with the spreadsheet.

The gear, buffs, and buffed dps sheets all look fine and yeilds no errors.
But clicking on the buffed trheat sheet. #N/A everywhere. Try different buffs/gear setup with no avail.

Is what I'm looking at, hitting the fix it button doesn't work.

http://img36.picoodle.com/img/img36/...dm_baad993.jpg
direct link that can be zoomed on to see the values. Not quite good with hosting, sorry.

 

Gruntle

Don't know but it seems that it's the circular refs that's messed up somehow. The Fix It button should in principle work to solve this so maybe something else has gone wrong. To set the circular refs off without using the button go to cell C2 on the gear page (yes, it's the cell behind the fixit button), and set this to "=TRUE()". That turns off the circular refs, if you want to turn it on again just set the cell to FALSE (or press the fixit button).

If this doesn't help, download the sheet again and use the "clean" copy of *DPS.xls (you should be able to keep you ITEMS sheet).

 

Rhaeti

I noticed at approximately 3400 AP, 40% crit, 17% hit that 10 crit rating added slightly more DPS than 10 strength so I'm wondering where other points of crit/hit/AP that a certain stat is more beneficial than the others.

 

buah

Hi there.. i was wondering the same thing

I just downloaded this spreadsheet noticed that for me 10 crit rating gives me a bigger dps increase than 10 str

My gear stats unbuffed: crit 30%, hitrating 177, ap 2000

I always thaught that AP > all and put my gear together according to that rule.. now i'm a bit confused

thx

 

Hozz

I think crit just scales better than STR/AP after a certain point, for DW Fury. STR is king for a long time though.

The simple way I would look at it is, STR>all until you have access to T6 gear, then STR=Crit.

 

buah

well that's what i thought, but the spreadsheet tells a different story

The gear I entered is kara/t4 level and according to the spreadsheet:

fully raid buffed 10 crit > 10 str
With only my battleshout and no other raid buffs / drugs: 10 crit = 10 str
without my battleshout: 10 crit < 10 str

And I am only kara/t4 geared..

I'm confused ^^

 

Graul

Changing [Rising Tide] to this:

215 - 321 (103 DPS)
46 AP
23 hit rating

Makes it a clear upgrade in both the main hand and off-hand. I have not seen anything about Blizzard upgrading Hyjal and BT weapons either. It makes sense that they would given their track record, but I don't feel I should take something that is an upgrade *right now* for some, but not me based off of the assumption that they are going to buff the weapons for sure.

Also, according to the spreadsheet [Boundless Agony] is the best off-hand you can get before the Warglaives, and even the Warglaive isn't really a big upgrade over it. I'm not sure if the spreadsheet is factoring in the set bonus when you have both or not though either.

 

Eliminate2

That seemed to have fixed the problem. Anyway to avoid this problem in the future? or is it always going to be like this?

Also, ya, I was looking for where it takes in consideration of the Azzinoth haste buff, and didn't see it. I'm sure I can just tack it on the bottom in the extra's section. But what is the speed haste buff modeled as for the warglaives? Prob close to DST pre nerf? like 90 haste constant? anyone know?

 

Jalinda

Is there a version of this spreadsheet which runs without full Excel?
I Have only Open Office and that won`t work...

 

Eledorian

Setbonus isn't taken into account in the latest version as far as I know.

 

Cairnam

Hello,
I've recently been given this tool and according to my gear, talents & all I should be able to put out 1392 dps with the default raid configured fight. The lenght is comparable to what it takes us to kill magtheridon, and I've only been able to put out 797 dps on the fight last time I did it, with incoming damage for more rage (but I was clicking, which while taking me out of the fight for a few second was providing me with a good chunk of rage if I had just used it all which I was trying to, and intercepting back).

So, I was wondering, how close to the generated number are you at ? (WWS parsed data)

The other question is quite simple, how many MS/WW is computed with the 4slam, ms > ww in 13.88 second, considering that with enough rage it could be possible to do 2 ms & ww in that, depending on the rage available. I usually slam after every hit and try to MS whenever possible but anyway.. is it computing the available rage for this ?

Well it should be easy to answer

Thank you!

 

Gruntle

You can run the spreadsheet in OpenOffice. You won't be able to use any of the macro's though (i.e. no saved setups, nor SEP calculation, but most annoying you can't run the FixIt macro).

Start by opening the DPS sheet and answer "No" when it asks you if you want to run macros. The sheet should start without errors, but probably give N/A as dps. To make it work you should then save both the DPS and ITEM sheets as .ods files (OO indigenous file format). Reopen the DPS sheet and got to Edit -> Links, then modify the link to point at the ods file instead of the xls file. Save and reopen (always answer no to the macro question, otherwise you will get an error when starting).

To fix the circular ref problem (ie. getting N/A) do what I told Eliminate2 above. You may need to do this a couple of times (and probably have to turn off Mongoose before).

 

luke2kz71

i use it more of a benchmark than anything...

 

Gruntle

My dps from the sheet is about 30% more than what I see in reality (due to not doing damage all the time, some badly timed BTs/WWs, reaching the aggro ceiling and so on). The dps given is the theoretical maximum, you will only be able to achieve this if you're playing like a machine. As the above poster, I use it as a benchmark to compare different gear setups.

The slam cycle uses the 2MS, 1WW cycle. If you don't get the rage to support this I guess the sheet will instead use a different cycle (2MS, 0.5 WW or something). Anyway, I suspect that if you haven't got the rage to do the full cycle you will do a lot less dps.

 

Turpin

i must agree the fact that crit is slightly better than strength at most gear levels is one of the interesting results of the model. A few things to note:
*Remember to press the SEP button every time you change your gear or load a new set because it wont update autmatically like your DPS will. Remember to save after this for your base set.

*The difference range between strength and crit ranged between 12 to even in either way. By putting in different gear amounts its rare that 10 strength equals anything less than 8 crit or more than 12 crit in the extremes.

*In some ways crit being worth more does make sense. It has the added benefit of burst dps (for pvp) and the drawback of inconsistent dps (for pve). So even if crit gems increase your dps by more than strength gems it may make sense to just go with strength to eliminate some inconsistancy in results that could be frustrating. Spike threat also means you have to be more careful at the start of a pull. So these results do seem to make sense with game design principals, and in that light are not as much of a surprize.

 

Rhaeti

Well, it makes sense to me because once you start getting all those raid buffs your AP is going to be huge and a crit is going to be double damage or 2.2 times on specials with impale. It works this way for other classes as well, for example for mages when you have a ton of spell damage with buffs and MH/BT gear crit becomes more valuable.

 

• Ren

Is it possible for you to implement the T6 set bonuses? It's difficult to compare items without them modeled.

 

Eliminate2

They are modeled. Look at the top right corner of the gear sheet. It say t4, t5, t6, 2 pc, 4 pc, false or true. True will cause an effect in the DPS sheet, which is factored in.

 

• Ren

That's the part that doesn't seem to happen. Going from [Destroyer Shoulderblades] to [Onslaught Shoulderblades] increases DPS by 20, which seems rather low if it activates 2pc. Going from [Grips of Silent Justice] to [Onslaught Gauntlets] lowers DPS by 8, despite the fact that wearing the T6 gloves activates 4pc.