Turpin

This worked for me and i suspect it will work for others. Thanks Elic :-D

Edit: well it worked for a while /sigh still getting circular errors but i think this was one of the issues at least

Edit 2: ok it now does seem to fix the whole issue. But when i try to copy over items from an old sheet i have to do it line by line or else it seems to break.

 

dr_AllCOM3

### 0.9.6
- Error fixes *yawn* Report please
- Almost finished for now

Oh, I use the german Office 2003 version to be exact^^. They've translated _everything_ and it's kinda annoying. Especially when you have to use Visual Basic (in english) on top of that.

 

Turpin

Faerie Fire seems to alot more dps than expected if sunder armor is also enabled. But if sunder is not enabled it seems right.

Edit: nm i think i figured it out

 

Hozz

I played with Swiftsteel Bludgeon/Tracker's Blade combo last night. Both 1.5 speed. Disappoining. Even if I am getting another flurried swing every flurry proc, the DPS was significantly worse than a Dragonstrike/Tracker's Blade (or Swiftsteel Bludgeon) combo, even with the haste nerf and the Dragonstrike procing less.

 

dr_AllCOM3

Is the error gone?

 

Gruntle

Haven't been able to use the circular refs since the first two versions, but then I'm using Open Office (no macros work) so my feedback is probably not worth much.

edit: and still doesn't work in this version, neither with nor without Mongoose

 

amethyst

I was receiving errors through 0.9.4 etc.

New version works fine for me. No errors! #

 

Aced

Works fine for me too.

 

Hozz

Works great, thanks!

 

Turpin

New Error:
2 Hand Spec not calculating right.
To fix just change "K9" to "B9" in cell M6 on buffed dps sheet.

 

dr_AllCOM3

### 0.9.8
- New ITEMS.xls because Sets+Talents are saved now too.
- Download here
- Don't just use your old items.xls, but you'll know by now
- Errors fixed
- Some stuff added like set bonus, all talents and more

 

Turpin

YouTube - Rick Roll ???

 

Chadw

The recent patch buffed up some of the SSC weapons which haven't been changed in the items.xls, only took a few seconds to fix but yea.

 

Natural

For those who haven't been reading the other DPS warrior thread, I've put together a spreadsheet that lets you determine which is more threat efficient: HS or Cleave.

Please have a look and share your comments. The procedure is as follows:

1) Fill in the green highlighted sections to obtain the "special attack" bonus damage. This number represents the expected increase in damage from converting a white attack to a special attack.
2) Use the number from (1) as the X-axis point on the threat efficiency graphs.

Here's the spreadsheet. cleave_vs_hs_v003.xls - FileFront.com

Let me know if you find any errors.

 

Turpin

Weird Potential Error i found:

when L7 on Gear sheet goes from 3210 to 3215 (from -armor gear and - armor talents) all of a sudden the total dps jumps by 100. But when i take L7 from 3215 back to 3210 again the dps does not go down by 100 but only by a small amount. I have to go down to about 3000 before it drops the 100 points of dps again, so it is a bit asymmetrical. When i did this test i never touched any yellow cells. I just made some new items with -armor to test it so like -500, -600, -700 armor etc. Also you have to turn off Faerie Fire to test it because having both Sunder armor and either Faerie fire or COR turned on takes L7 above 3215. You can just turn on only sunder and then put on an item that has -610 armor and then compare to putting on an item that has -620 armor and you can see it.

 

Turpin

Ok the source of this seemd to be that it affects the dps cycle significantly. Basically before enough armor reduction the cycle includes 4 slams, 2MS, and 0 WWs. But once you get enough armor reduction there is enough rage for 1 more WW (presumable because of more rage gen from more armor reduction and maybe more flurry.

Now it has been stated that the best Slam Cycle includes 4 slams, 2 MS, and 1 WW and of course it is impossible to get this all the time. But Perhaps we should just fix this with the dps cycle and not have it be dependent on armor reduction.


Edit: seems like the fomula in H51 is bugged for me. G51 is 25 but H51 wont resolve to "1". I tried setting the formula to greater than or equal to (i.e. >= instead of >) but that didnt fix it. Changing WW rage to 24 in C21 did fix it but not a good resolution lol

 

Turpin

Some more comments:

Maybe model Mighty Rage potion instead of Heroic potion- it seems to be better. Also you could do insane strength potion

For Heroic potion and Haste potion it seems you model based on a 1 min potion cooldown instead of 2 min.

Also: Items after line 51 on the Mainhand weapon tab in the items spreadsheet do not show up in the dropdown on the Gear tab.

 

dr_AllCOM3

You're right about the >=, but for the rest I can't follow you. You can use the green cells at the bottom for testing values, it's easier.

Yes, I extended it in the wrong sheet.


### 0.9.9
- SSC/TK weapons
- Slam improved
- Minor errors

 

Turpin

Will you add deep wounds to model or maybe its not worth it?

 

Aurethios

I've always thought that one of the biggest benefits of haste in items like DST and the blacksmithing mace is that the speed boost helps churn out more heroic strikes (provided that aggro isn't a problem), and thus compensate for a lack of stats like crit rating or AP.

So my question is, with the changes to haste, does the same hold true? Given how PPMs are affected by haste now, just how much of a benefit is it to have those haste procs versus items that could go into the same slots but with AP/Hit/Crit? I'm not sure how to get that info into the existing spreadsheet, so any suggestions are more than welcome.

Cheers.

 

Caesar

Deep wound is bugged (since ever) and is very hard to model theoretically in a spreadsheet like this. best possible model would be to add a flat % of your average damage for your different abilities in some way. but even then it shows v little of actual dps. Further on Deep wounds is increased by mangle etc too so there are several factors to account.

 

dr_AllCOM3

No, not really important.

Choose items in sheet, look at DPS?

 

• frmorrison

I tested the sheet via swapping to DW and 2H and did not see issues with that setup, while on previous version I did.

Once you hit version 1.0 of the spreadsheet, I think you should start a new thread, like DPS Warrior Spreadsheet for TBC.

 

Machinator

How is it bugged? Unless you mean it resets on each crit. Would the formula not be just the chance of you not getting a crit for 3/6/9/12 secs?

"Information is ammunition."

 

• Ren

I looked around but I didn't see this question answered: is the spreadsheet using the post-2.2 values for haste? (15.6 haste rating = 1%)