[Warrior] DPS Spreadsheet 2.3 and beyond - Page 35

• landsoul · 03/17/08, 10:30 AM

moved the thread on discussion of my sheet here: http://elitistjerks.com/f31/t23083-w...adsheet_2_4_a/

Daavee · 03/17/08, 5:59 PM

Hi guys/gals, long time lurker, first time poster!

Anyway, I have been using the Warrior DPS Spreadsheet v.313, and have noticed a couple of strange things.

First of all, when using the Gear1 tab, using the exact same gear set, spec, buffs and also with none of the manual entries changed from zero, I am getting a buffed AP value of less than the other Gear tabs when using the exact same gear set, spec etc. I have tested out my own gear sets as well as the other ones that are there upon downloading the spreadsheet and have produced the same results. Is anyone getting this discrepancy with buffed AP values between Gear1 tab and the others?

The second issue I have is more gear specific. Since the beggining of S2 I used this pair of swords [Merciless Gladiator's Slicer] and [Merciless Gladiator's Quickblade], both with Mongoose, lovely weapons might I add! Anyway, since ZA I was lucky enough to get [Fury] on release night, enchanted it with Potency and placed [Crimson Sun] in the socket. I replaced my Quickblade with this, assuming that superior stats and slower speed with the WW change would offset the fact that is has lower DPS, and make it a superior offhand. Since plugging it all through the spreadsheet though, the [Merciless Gladiator's Quickblade] has come on top by quite a significant amount, and I am very surprised! Should I be? Also, the two Merciless swords are coming out on top of the new fist weapons from BoJ in 2.4, is this correct too, are the Merciless swords REALLY that good? I honestly thought it that is was a bug with the spreadsheet.

Thanks alot of all the effort put in by dr_AllCOM3 and Grim13 as well as all the others who have contributed, it is a great resource!

Rezarel · 03/17/08, 6:11 PM

Originally Posted by Daavee

The second issue I have is more gear specific. Since the beggining of S2 I used this pair of swords [Merciless Gladiator's Slicer] and [Merciless Gladiator's Quickblade], both with Mongoose, lovely weapons might I add! Anyway, since ZA I was lucky enough to get [Fury] on release night, enchanted it with Potency and placed [Crimson Sun] in the socket. I replaced my Quickblade with this, assuming that superior stats and slower speed with the WW change would offset the fact that is has lower DPS, and make it a superior offhand. Since plugging it all through the spreadsheet though, the [Merciless Gladiator's Quickblade] has come on top by quite a significant amount, and I am very surprised! Should I be? Also, the two Merciless swords are coming out on top of the new fist weapons from BoJ in 2.4, is this correct too, are the Merciless swords REALLY that good? I honestly thought it that is was a bug with the spreadsheet.

The spreadsheet heavily penalizes using slow matched speed weapons in the execute phase (since you'll only get rage to execute every 2.6 seconds instead of every 1.5 second global cooldown). In the top left, your dps is broken down into White, (normal) Cycle, and Execute portions. You can play around manually with which weapons give you the best White + Cycle dps, then swap to different weapons for the best White + Execute dps. Also, I think Grim's almost finished including an execute weapon swap feature into the sheet, so you could just wait for him to release that.

Opta · 03/17/08, 7:09 PM

I have a question expertise Racial bonus
I was looking at 3.13 wondering where is the racial expertise bonus caculated? (I am my case it's human mace and sword) i don't see it in the expertise total. is it in the sim page? anyway expertise is always 0 for me i was wondering if this is normal or not.

Daave i think there are some changes in 3.13 for set1 that have not been propagated to the other set. Just load and save you gear in set 1 to get the current simulation data.

Grim13 · 03/18/08, 4:26 PM

Originally Posted by Opta

I have a question expertise Racial bonus
I was looking at 3.13 wondering where is the racial expertise bonus caculated? (I am my case it's human mace and sword) i don't see it in the expertise total. is it in the sim page? anyway expertise is always 0 for me i was wondering if this is normal or not.

It's done behind the scenes, in the Sim sheet.

Originally Posted by Opta

Daave i think there are some changes in 3.13 for set1 that have not been propagated to the other set. Just load and save you gear in set 1 to get the current simulation data.

There were a few minor updates that were done and didn't get pasted into all of the sheets. I hope to have them all discovered. Currently I have all 6 sheets giving the same result for the same gear in both 2h and DW, so I think I got them. Should have a release later today.

Grim13 · 03/18/08, 9:04 PM

v320beta 3/18/2008

I'm calling this a beta release, as there were significant changes in mechanics. I think I have it all ironed out but it doesn't hurt to be sure.

The implementation I ended up using for execute was to duplicate the entirety of the Gear and Set sheets, having 6 of each for cycle and 6 of each for execute. It's a bulky method, but it works, and doesn't require a macro. I'll see if I can clean it up at all further down the road, but right now, I am primarily concerned with functionality.

Also, I redid the windfury model to provide an accurate % chance to proc per swing. Previously 20% was assumed. Now misses, dodges, and Heroic Strikes are taken into account. At the moment, I can't remember if I updated the model for both DW and 2h or just DW. I'll have to look at that tomorrow perhaps. The inaccuracy was significantly more pronounced when dual wielding, due to heroic strike and auto attack having a 19% difference in base miss chance. For those who really care, all that sort of stuff is circular referenced to, like 30 iterations, I think. WF, Flurry, and a whole buch of other shit I can't remember right now.

Also, as to the RotSK proc, it's coming out to about .97 rps MH and .67 rps OH, which is translating to about 15 DPS MH and 10 DPS OH. Seems about right, but I've never used the thing. Those of you who were clamoring for it, make sure to take a look and let me know what you think.

Anyways, have fun with the new model, I will continue working on fine tuning and coming up with more accurate models.

Please post any issues you come across so that I may correct them.

Changelog:
Applied tsunami/hourglass update to sets 2 - 6.
Made Set(x) sheets only calculate cycle DPS and replicated all 6 of them as sExe(x) in Warrior_Sim.xls to make separate sheets to calculate execute DPS
Added execute weapon selection to Gear(x)
Added Exe(x) sheets in Warrior_DPS.xls to feed sExe(x) sheets
Corrected crit meta gem in Set1
Corrected bug w/ DW WF damage calculation
Modelled Rod of the Sun King proc @ 6ppm
Remodeled WF to account for DW miss penalty on white dmg and yellow miss chance on HS

Kaan · 03/18/08, 11:44 PM

Downloaded it and wanted to enter my equip, to see how things changed, but no matter what I enter in the Cells, nothing changes the DPS or racials etc. Note: I use Excel 2002.

Shha · 03/19/08, 4:56 AM

Same here, seems like you broke your sheet with the new release

Darkrenown · 03/19/08, 6:14 AM

Originally Posted by Graul

Also, off topic, but did Blizzard recently change the stats on the Onslaught boots? The first time I looked they were not very impressive to me, but then someone recently mentioned them being the best boots in 2.4, and I looked at them again and they seemed improved.

Shortly after they were seen on the PTR they had all the stam converted into dps stats.

Beefcakes · 03/19/08, 6:17 AM

Originally Posted by Rezarel

The spreadsheet heavily penalizes using slow matched speed weapons in the execute phase (since you'll only get rage to execute every 2.6 seconds instead of every 1.5 second global cooldown). In the top left, your dps is broken down into White, (normal) Cycle, and Execute portions. You can play around manually with which weapons give you the best White + Cycle dps, then swap to different weapons for the best White + Execute dps. Also, I think Grim's almost finished including an execute weapon swap feature into the sheet, so you could just wait for him to release that.

What you say about the speed of the weapons is correct. However there is a real issue with the calculations of the spreadsheet concerning slow weapons with identical speed.

An example:

MH: [Rising Tide] spd 2.6, OH: [Talon of Azshara] spd 2.7. Spreadsheet indicates to use execute.

Now changing the OH with say the [Vengeful Gladiator's Chopper] spd identical to the rising tide, and what you get is that you should not use execute and actually execute dps drops a woping 100dps.
Change the offhand to the [Syphon of the Nathrezim] spd 2.8. What we get is to use execute.

So to sum this up there's something wrong going here when weapons have identical speed concerning execute calculation.

Khurzog · 03/19/08, 6:29 AM

well I don't think it is wrong...
Idetical (slow) speed means you get the benefit from WW doing more dmg, more flurry uptime because of more instants which can crit in between 3 white hits and also the flurry"bug" (feature?^^) with 4 flurries strikes instead of 3 when wearing weapons with identical speed...
So all in all you will make more dmg by retaining your normal rotation with matched speeds than by executing.

And waht plays a role is that you just get rage every 2.6seconds with matcehd speeds while when not matched your rage generation is muczh smoother...

Hoonboof · 03/19/08, 6:42 AM

Originally Posted by Khurzog

well I don't think it is wrong...
Idetical (slow) speed means you get the benefit from WW doing more dmg, more flurry uptime because of more instants which can crit in between 3 white hits and also the flurry"bug" (feature?^^) with 4 flurries strikes instead of 3 when wearing weapons with identical speed...
So all in all you will make more dmg by retaining your normal rotation with matched speeds than by executing.

And waht plays a role is that you just get rage every 2.6seconds with matcehd speeds while when not matched your rage generation is muczh smoother...

Because we're going to take your napkin math as gospel when you don't even seem capable of using the preview post button. Somehow I doubt that matched weapon speeds account for a 100dps difference during execute phase, the WW damage thing is fairly insignificant too because you're only hitting for 62.5% of your offhands damage with your offhand WW swings anyway, the AP contribution probably accounts for more damage.

Grim13 · 03/19/08, 2:03 PM

Originally Posted by Beefcakes

What you say about the speed of the weapons is correct. However there is a real issue with the calculations of the spreadsheet concerning slow weapons with identical speed.

An example:

MH: [Rising Tide] spd 2.6, OH: [Talon of Azshara] spd 2.7. Spreadsheet indicates to use execute.

Now changing the OH with say the [Vengeful Gladiator's Chopper] spd identical to the rising tide, and what you get is that you should not use execute and actually execute dps drops a woping 100dps.
Change the offhand to the [Syphon of the Nathrezim] spd 2.8. What we get is to use execute.

So to sum this up there's something wrong going here when weapons have identical speed concerning execute calculation.

This is intentional. Matched 2.6 speed weapons will ONLY be able to execute every 2.6 seconds. With a 2.6 and 2.7, the two weapons will be out of phase much of the time, meaning that when the OH crits by itself, it will likely generate enough rage to execute. Because of this fact, 2.6 + 2.7 has a better execute cooldown than 2.6+2.6. I have manually simmed this out to about 50 swings or so to verify my thoughts. The result was that when average weapon speed is greater than about 1.75s, the fact that speeds are NOT matched becomes much more important than the actual speed. This of course only applies to execute DPS. If you are using matched 2.6 spd weapons you need to either continue using cycle DPS <20% or get a non 2.6 spd weapon to use during execute phase.

Downloaded it and wanted to enter my equip, to see how things changed, but no matter what I enter in the Cells, nothing changes the DPS or racials etc. Note: I use Excel 2002.

You're right. I was so concerned with making sure all the shit i changed worked individually, that I missed this issue. I will check it out ASAP, and get a revision out. Good thing I called this a beta release, eh?

**Edit** Press F9 after changing any gear, and it will force a refresh. For some reason it isn't doing it automatically. I'm working on a fix as we speak.

Fixed. In Tools > Options > Claculation, "Calculations" needs to be set to Automatic. I never set it to manual, but that's what was wrong. I'm re-uploading now, or you can fix it yourself.

btw, the theoretical 4th flurry swing from matched speed weapons is NOT modeled in the sheet. It has never been confirmed to my knowledge. If it has been, and I can be shown convincing evidence, THEN it will be added to the model.

turtleneckboxers · 03/19/08, 2:08 PM

Also, Onslaught Greaves is supposed to have 1 Blue socket.

Kaan · 03/19/08, 2:42 PM

Thanks for the quick fix.

Now, when I deactivate or activate Execute-Weapons, the Spreadsheet bugs and isn't fixable by the button. Though everything else works fine.

Grim13 · 03/19/08, 2:47 PM

Originally Posted by Kaan

Thanks for the quick fix.

Now, when I deactivate or activate Execute-Weapons, the Spreadsheet bugs and isn't fixable by the button. Though everything else works fine.

Sorry, I am unable to reproduce this issue. It's working fine for me. For reference, I am doing this in Excel 2003, so it should be compatible with most/all excel versions, I would think...

I checked Onslaught Greaves, and they already do have 1 blue socket in the sheet...

alaa_m · 03/25/08, 8:08 AM

I have OpenOffice 2.3.1 but there seems to be something wrong! When I open Warrior_DPS file, the cells have #N/A so I click "Fix It!" but get the following error message:

A Scripting Framework error occured while running the Basic script
vnd.sun.star.script:Standard.FixIt?language=Basic&location=document

Message: BasicProviderImpl:getScript: no script!

Any ideas how to fix this?

Thanks

Edit:
I'm guessing nothing will work with VB scripts in OpenOffice, this might be the problem?

Mardraum · 03/25/08, 2:05 PM

Yep, I believe grim has stated his sheets are not compatible with OO.

Axodry · 03/25/08, 3:25 PM

Originally Posted by Kaan

Thanks for the quick fix.

Now, when I deactivate or activate Execute-Weapons, the Spreadsheet bugs and isn't fixable by the button. Though everything else works fine.

Is the most uptodate version v321b? I'm still getting the same issue as you stated above with the DPS not updating and it appears to be working for you for the most part if I understand you correctly. Anyone have any idea's? I trying to determine what direction I need to go with the new badge loot and this spreadsheet seems like the best resource for that.

Thanks,

Mithgaur · 03/25/08, 7:30 PM

Hey there. I'm trying to download the spreadsheet but I can't enter the page. Anyone else experiencing this issue?

Gruntle · 03/26/08, 7:14 AM

Originally Posted by alaa_m

I have OpenOffice 2.3.1 but there seems to be something wrong! When I open Warrior_DPS file, the cells have #N/A so I click "Fix It!" but get the following error message:

A Scripting Framework error occured while running the Basic script
vnd.sun.star.script:Standard.FixIt?language=Basic&location=document

Message: BasicProviderImpl:getScript: no script!

Any ideas how to fix this?

Thanks

Edit:
I'm guessing nothing will work with VB scripts in OpenOffice, this might be the problem?

Yup, grim13's sheets do not work in OO. You can try my modded version in this thread (but about 10 pages back), but a better option is to get the sheet by landsoul (he's got a separate thread for that) that was built in OO from scratch. I'm using his sheet now so my sheet is not (and won't be) updated for 2.4.

Grimrage · 03/26/08, 11:20 AM

I have no problem adding static items, but I'm having a bit of trouble figuring out how to add trinkets with "chance on hit" procs. Specifically, I'd love to check the new [Shard of Contempt]. I can add the static expertise, but where do I add the proc? I tried to copy from the [Tsunami Talisman], but I can't find where the proc is modeled. Thanks for the great work.

Kaan · 03/26/08, 1:07 PM

The proc is worth about ~85 AP. Try entering a empty trinket, and the 44 Expertise + 85 AP manually.

Grimrage · 03/26/08, 1:17 PM

Thanks! I'll do that.

Grimrage · 03/26/08, 2:24 PM

Grim13, the DPS Summary tab on the Warrior_DPS.xls file has #REF! errors in Set 1. I fixed it on mine by changing:
'[Warrior_Sim.xls]#REF'
to
[Warrior_Sim.xls]Set1

Not sure what else it may affect in the broken state.

Edit: Cell X18 also has the problem on the Gear1 tab of the Warrior_DPS.xls file