[Warrior] DPS Spreadsheet 2.3 and beyond - Page 21

Grim13 · 01/31/08, 12:43 PM

Originally Posted by 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

A few posts above I have just updated my modification of dr_Allcom3's spreadsheet that includes items, enchants, etc, which is in large part a modification of his older sheet to use the guts of his new stuff.

Halle · 01/31/08, 1:12 PM

Nice job Grim, however I'm getting a server error on trying to download your latest version.

Hoping its just a temporary glitch with the hosts.

Elumako · 01/31/08, 1:57 PM

Originally Posted by Halle

Nice job Grim, however I'm getting a server error on trying to download your latest version.

Hoping its just a temporary glitch with the hosts.

I was able to make it to the download link, but what it downloads isn't the spreadsheet, unfortunately. (Read: 0 KB junk file)

Hopefully it will be fixed soon, or simply re-uploaded (anyone besides the author have a working copy of the latest version to share?), so we can all get back to "work".

Grim13 · 01/31/08, 2:46 PM

OK, fuck filefactory. I've got it on rapidshare now. previous link updated. Sorry for the hassle.

here is the new link:

The new shit

edit: found a bug in Talents and corrected it.

Hyou · 01/31/08, 5:32 PM

The spreadsheet bugs if I choose Human as my race, I can't seem to find a way to fix it if I have that race on. Anyone else experiencing this?

BTW Thanks for doing this ss Grim13

Diamedes · 01/31/08, 5:55 PM

Some have started to hint that BT is actually better damage than execute at 30 or more rage and got me thinking about just adding execute to my BT macro.

/cast Bloodthirst
/cast Execute

pretty sure this would try to bloodthirst and if less than 30 rage would just execute, can anyone who's better at macros confirm this would be ideal or maybe give a better macro

Grim13 · 01/31/08, 6:03 PM

Originally Posted by Hyou

The spreadsheet bugs if I choose Human as my race, I can't seem to find a way to fix it if I have that race on. Anyone else experiencing this?

BTW Thanks for doing this ss Grim13

I spelled "human" wrong in the new buffs sheet I made. It is corrected and links are updated.

The new shit mk.II

Or, to fix it yourself, go to cell J7 in the Buffs sheet in Warrior_DPS.xls. Spell Human correctly, then go ahead and select human, and you're good to go. Make sure you do the correction BEFORE you change the race. Warrior_Sim.xls goes ape-shit when it gets bad data fed to it, and is a real bitch to recover.

Speaking of recovery, for the more confident folks, if you don't want to reload the sheet if it bugs out, I find that changing cell H3 in the 6 Setx sheets in Warrior_Sim.xls to the OPPOSITE of what they currently are. ie: if it is 1 make it 0, and if 0, type in a 1. Then change it back to it's original value. Things should be recovered now. Don't forget to hit ctrl-z (undo) twice to put H3 back the way it was. It should contain the formula =IF(F21=1,IF(ISERROR(N15),0,1),IF(ISERROR(Q16),0,1))

Hyou · 01/31/08, 6:11 PM

Originally Posted by Grim13

I spelled "human" wrong in the new buffs sheet I made. It is corrected and links are updated.

Much Appreciated. Thanks

Barmbul · 01/31/08, 6:17 PM

the sheets I down loaded seem to have a link bug and are missing some of the gems that were on the previous sheet

Apate · 01/31/08, 6:18 PM

Originally Posted by Diamedes

Some have started to hint that BT is actually better damage than execute at 30 or more rage and got me thinking about just adding execute to my BT macro.

/cast Bloodthirst
/cast Execute

pretty sure this would try to bloodthirst and if less than 30 rage would just execute, can anyone who's better at macros confirm this would be ideal or maybe give a better macro

That should fail, and these kind of macros are what the current system was designed to prevent.

BT is better at a certain amount of AP. You could /castrandom Bloodthirst, Execute to attempt a bloodthirst roughly half the time. I suspect that if you are ion this position and really want to increase damage, you would be better served by sticking a big rage bar on your screen somewhere and pressing the appropriate key based on what you see.

Diamedes · 01/31/08, 6:35 PM

I definitely need to get a ragebar mod, and the macro I linked does work but you have to spam it which I don't like either. I guess manually deciding is the way to go for now, and by the way I think the number of AP to make BT better than execute was right around 3k AP.

Grim13 · 01/31/08, 6:47 PM

Originally Posted by Barmbul

the sheets I down loaded seem to have a link bug and are missing some of the gems that were on the previous sheet

I decided to drop the heroic drop gems for the sake of tidiness. If you need them, you can add the one(s) you need pretty easily.

As to the "link bug" I have no idea what you mean. Please be more specific as to what the issue you are having is, and I will try and take care of it.

dr_AllCOM3 · 01/31/08, 7:15 PM

Does one charge of Flurry always fully haste one swing, even when the offhand takes the last swing while the mainhand isn't finished? I'm asking, because Flurry is an aura.

Chirality · 01/31/08, 10:54 PM

Originally Posted by dr_AllCOM3

Does one charge of Flurry always fully haste one swing, even when the offhand takes the last swing while the mainhand isn't finished? I'm asking, because Flurry is an aura.

For that matter--when you gain flurry via an instant attack in the middle of a swing...is the remaining part of the auto-attack swing sped up and a charge consumed on hit? The conclusions in the Flurry Mechanics thread were...less concrete than could be hoped.

Flurry mechanics. <sigh>

Edit: Well, re-reading the Flurry Mechanics thread at least answers my question: attacks are not hasted mid-swing. Further, my reading of the thread is that if the offhand takes the last swing while the mainhand isn't finished the mainhand's swing is not "unhasted" mid-swing.

dr_AllCOM3 · 01/31/08, 11:43 PM

Originally Posted by Chirality

Edit: Well, re-reading the Flurry Mechanics thread at least answers my question: attacks are not hasted mid-swing. Further, my reading of the thread is that if the offhand takes the last swing while the mainhand isn't finished the mainhand's swing is not "unhasted" mid-swing.

I've tested today with a cheap 3.8 speed weapon and a 29ms ping. Attacks are hasted the instant Flurry is upand vice versa. First I did a Hamstring right after an autoattack until the HS crits, then I did Slam.
Slam shows it very well. Chaining it doesn't use up charges and every autoattack would be hasted. Since it resets the swing timer it's always a "new" autoattack.
Try cancelling the buff, you'll notice the delay.

As a conclusion I can more or less say, that Flurry is globally active the instant it's up and vice versa. I don't know why noone noticed this in the archived thread.

Chirality · 02/01/08, 12:17 AM

Originally Posted by dr_AllCOM3

I've tested today with a cheap 3.8 speed weapon and a 29ms ping. Attacks are hasted the instant Flurry is upand vice versa. First I did a Hamstring right after an autoattack until the HS crits, then I did Slam.
Slam shows it very well. Chaining it doesn't use up charges and every autoattack would be hasted. Since it resets the swing timer it's always a "new" autoattack.
Try cancelling the buff, you'll notice the delay.

As a conclusion I can more or less say, that Flurry is globally active the instant it's up and vice versa. I don't know why noone noticed this in the archived thread.

Well..what's the limit on this? The slam mechanic seems pretty intuitive--but does the following occur?

(3.8 delay weapon, 3/5 flurry)
0.000 You attack for 100 damage
3.800 You attack for 100 damage
7.400 Your hamstring crits for 120 damage (.2 seconds left on swing, hasted to be .2/1.15 = 0.174 left)
7.400 You gain flurry (3)
7.574 You attack for 100 damage, consuming one flurry charge that made of a difference of all of 0.025s
10.978 You attack for 100 damage. 1 charge of flurry left
14.182 You attack for 100 damage
14.182 Flurry fades from you
17.982 You attack for 100 damage

The use of /cancelaura is certainly a good way to test this. As a wild guess based on comparing to other known mechanics, i would think that a swing can't be hasted if there's only 40% of the swing left, like how parry works. This would yield

(3.8 delay weapon, 3/5 flurry)
0.000 You attack for 100 damage
3.800 You attack for 100 damage
7.400 Your hamstring crits for 120 damage (.2 seconds left on swing, too short to be hasted.)
7.400 You gain flurry (3)
7.600 You attack for 100 damage, 3 charges of flurry left
10.904 You attack for 100 damage, 2 charges of flurry left
14.208 You attack for 100 damage, 1 charge of flurry left
17.512 You attack for 100 damage
17.512 Flurry fades from you.

Of course, I highly doubt that this would occur. Guess I should look into this further for my own little 2h combat simulator i've been slowly writing at work (instead of actually doing work).

By the way--Blessing of King's bonus is added after Mark of the Wild, Elixirs, Food, and Shaman Totems, correct?

And the side note is that if your theory is correct--offhand/mainhand attacks will stay synchronized and double the benefit of flurry unless you parry (which only speeds up your main hand)?

Chirality · 02/01/08, 12:17 AM

Edit: Double post

dr_AllCOM3 · 02/01/08, 12:50 AM

Originally Posted by Chirality

And the side note is that if your theory is correct--offhand/mainhand attacks will stay synchronized and double the benefit of flurry unless you parry (which only speeds up your main hand)?

They should (the animation doesn't fit). You have to rightclick the mob before getting into meleerange or else your offhand starts like 0.5s later. I wonder if this is a positive effect regarding the 4x-Flurry-bug.

@ Case 1: Yes, seems like there are attacks that aren't fully hasted. Let's call it a 2,5 Flurry. I don't know about Flurry and under-40%-no-haste-whatever (edit: Cancelling Flurry <40% slows the attack; Getting a Ham crit <40% lets the autoattack consume a charge). I think it doesn't matter in this case.

Flurry should read "You get 25% haste after any crit until you hit three times with an autoattack.".

Gruntle · 02/01/08, 5:48 AM

Originally Posted by Chirality

And the side note is that if your theory is correct--offhand/mainhand attacks will stay synchronized and double the benefit of flurry unless you parry (which only speeds up your main hand)?

Well, to be honest, the tests were done with a twohand slow weapon. We don't know for sure that dualwielding + flurry works in the same way. The tests in the Flurry mechanics thread were only done with DW (I think?), maybe the mechanic is a lot trickier when dualwielding.

Wouldn't the easiest way to check for the 4*flurried attacks issue just be to compare the flurry uptime of a matched weapon setup to a non-matched setup? The way flurry is modeled in the sheet is to calculate the probability of a crit happening while Flurry is up, if you have an extra white swing (4 instead of 3) the flurry uptime will go up. I'm not sure if there are any addons around that can do accurate measurements of flurry uptime, but I guess it should be fairly easy to just parse the combat log for that info. The true dps increase from matched weapons would come from the increase in flurry uptime (since flurry uptimes for DW is on the order of 70-90%), at least when modeling.

Also, if the theory above is correct (i.e. flurry is applied instantly and all attacks get the haste applied on whatever remains of the swing time and the time until three swings have been made), wouldn't that mean that even without matched speeds you would experience 3-4 hasted swings. I.e. (with 25% flurry):
2.6+1.6 sec weapons
0.00 MH hits, OH hit
1.60 OH hit
2.60 MH hit
3.00 BT crit
3.00 Flurry aura gained (0.2 s left on OH, 2.2 left on MH => 0.16/1.76)
3.16 OH hit (-1 flurry charge)
4.44 OH hit (-1 flurry charge)
4.76 MH hit (-1 flurry charge)
4.76 Flurry fades (0.96 sec left of flurried OH swing, slowed to 1.2 sec)
5.96 OH hit

In total you would get in 1 MH and 2.25 flurried OH hits. Choosing a slightly better time to do BT you could end up with:
2.6+1.6 sec weapons
0.00 MH hits, OH hit
1.60 OH hit
2.40 BT crit
2.40 Flurry aura gained (0.2 s left on MH, 0.8 left on OH => 0.16/0.64 sec)
2.56 MH hit (-1 flurry charge)
3.04 OH hit (-1 flurry charge)
4.32 OH hit (-1 flurry charge)
4.32 Flurry fades (0.32 sec left of flurried OH swing, slowed to 0.4 sec)
4.72 MH hit

In total: 2 OH hits and 1.85 MH hits.

Just to be complete: 2*2.6 weapons would look like this:
0.00 MH hits, OH hit
2.60 MH+OH hit
3.00 BT crit
3.00 Flurry aura gained (2.2 s left on MH/OH => 1.76)
4.76 MH hit (-1 flurry charge)
4.76 OH hit (-1 flurry charge)
6.52 MH hit (-1 flurry charge)
6.52 Flurry fades (0.00 sec left of flurried OH swing, slowed to 0.00 sec)

6.52 OH hit
i.e., 2 MH and 2 OH flurried hits.

So you could end up with anything between 2-3 OH hits and 1-2 MH hits while flurried if using this setup. If it works like this, there is no "step function" that steps in for matched speeds, rather a continuum depending on where the instants fall and the exact speed of the weapons. How to model this in the spreadsheet is way above me. I also think some more testing on DW flurry needs to be done to make sure this is how it works.

cainor · 02/01/08, 8:14 AM

hi there, i wanted to compare the heartshatter breastplate with the midnight chestguard.
when i made a short calculation without the sheet, it clearly stated that the midnight chestguard is superior.
but since the scale with kings i wanted to proof. overall is like 30str+ 106 ap vs 63 str. (when u put str gems in it)
the crit + hit stats just vary -+1 or 2 so i think you can leave that.
what made me curious is what i saw on the sheet.

@1724 dps

@1715 dps

where is my mistake?

LittleHamster · 02/01/08, 8:31 AM

Grim, just a comment on the spreadsheet for those on the mac.

On the mac, the path separator is / not \. And so the correct way to specify a path seperator in basic is to not hardcode it, but uses the platform independent variable Application.PathSeperator.

There are two lines in your sheets that I need to modify everytime you update your sheets. It should really be

Workbooks.Open Filename:=ActiveWorkbook.Path & Application.PathSeparator & "Warrior_Sim.xls"

and

Workbooks.Open Filename:=ActiveWorkbook.Path & Application.PathSeparator & "Warrior_ITEMS.xls"

The SEP is also not working on the mac. However, I'm no visual basic expert (in fact i can't do visual basic at all), so I havent' been able to fix it.

dr_AllCOM3 · 02/01/08, 9:33 AM

Originally Posted by cainor

where is my mistake?

Doesn't look like one. First has like 20 more ap.

Originally Posted by LittleHamster

Grim, just a comment on the spreadsheet for those on the mac.

Mac isn't supported (my version _should_ work).

_____

I did a very small test with two 2.6 weapons and 5/5. Mainhand has 100dps, offhand ~5dps. Blasted lands while they don't attack. Ping was around 50ms. No parries.

2/1 13:49:06.189  You crit Servant of Sevine for 406.
2/1 13:49:06.385  You hit Servant of Sevine for 524. [.200]

2/1 13:49:07.087  You gain Flurry. (actually gained one hit before)
2/1 13:49:08.360  You hit Servant of Sevine for 198.
2/1 13:49:08.516  You hit Servant of Sevine for 510. [.150]

2/1 13:49:09.498  Flurry fades from you.
2/1 13:49:10.781  You crit Servant of Sevine for 407.
2/1 13:49:10.977  You hit Servant of Sevine for 511. [.190]

2/1 13:49:11.909  You gain Flurry.
2/1 13:49:12.994  You crit Servant of Sevine for 407.
2/1 13:49:13.165  You hit Servant of Sevine for 535. [.170]

2/1 13:49:15.115  You miss Servant of Sevine.
2/1 13:49:15.254  You crit Servant of Sevine for 1134. [.140]

2/1 13:49:16.321  Flurry fades from you.

[ several flurries and one mongoose later, 25secs ]

2/1 13:49:41.229  You hit Servant of Sevine for 197.
2/1 13:49:41.408  You miss Servant of Sevine. [.180]

2/1 13:49:43.822  You hit Servant of Sevine for 197.
2/1 13:49:44.061  You hit Servant of Sevine for 518. [.240]

2/1 13:49:46.483  You hit Servant of Sevine for 198.
2/1 13:49:46.634  You hit Servant of Sevine for 553. [.150]

The hits are always ~200ms apart, like at the beginning, with the offhand going first. (I with there was a mob you could hit for 10mins without parries

) The combatlog isn't very accurate, so the hits are more or less at the same time. The animation doesn't fit the combatlog. Flurry does seem to fade after 3 hits, but since it's an aura there are no such things as completely hasted hits. I would have seen larger gaps then.
This all fits to what I observed with a 2h weapon.
Flurry is an aura, that you gain after a crit and loose after three autoattacks. It is refreshable. (Bugs: It can't proc if 1 charge is left or if the Whirlwind offhand crits.)

Barmbul · 02/01/08, 2:27 PM

Is the sheet figuring in the party buff for this trinket? equipping it gives a 190 atk pwr increase per the new sheet.

Chilenohellcat14 · 02/01/08, 4:05 PM

I am quite new to fury. Have only had this spec for about 1 month and a half. I would really appreciate to find desired stats for a fury warrior in Tk/SSC. Hit rating-? AP-?(unbuffed) Crit %-?. I want to make fury the greatest dps in the game. I want to prove the genral belief that fury sucks wrong. I am in half pvp gear and still getting high dps. I just need to know how to break the barrier between my dps being acceptable and mind shattering.

Apate · 02/01/08, 4:24 PM

Originally Posted by Chilenohellcat14

I am quite new to fury. Have only had this spec for about 1 month and a half. I would really appreciate to find desired stats for a fury warrior in Tk/SSC. Hit rating-? AP-?(unbuffed) Crit %-?. I want to make fury the greatest dps in the game. I want to prove the genral belief that fury sucks wrong. I am in half pvp gear and still getting high dps. I just need to know how to break the barrier between my dps being acceptable and mind shattering.

Use the spreadsheet to see how the stats interact. I could tell you to get 8k AP, 75% crit and 20% hit, but that is unrealistic. It would be mind-blowing, though! You should instead look at the available items at your level of progression (don't forget badge rewards!). Especially at the T5 level, the choices tend to be fairly basic.