Warrior DPS Calculation Spreadsheet - Page 4

• ebs2002 · 12/11/08, 5:40 PM

I was a big fan of the OpenOffice spreadsheet in BC, so I thought it was about time to get the new Excel version and start planning out my warrior's gear. However, after inputting all my current gear, the dps calculation has changed to "N/A". Likewise the SEP calculations, after I click on the green button, also all change to "N/A".

Obviously I'm doing something wrong. Could someone enlighten me? I'd love to start using this spreadsheet, but I have a feeling my inexperience with Excel may be getting in the way...

A lot of the time that this happens, it's due to a bug in the vlookup tables that's been reported already. I had this issue frequently as well, due to a few enchant selections bugging out.

If you're afraid of editing your file yourself, just wait for the new release and don't change the enchants. Otherwise, I expect that those issues will be fixed in the new release.

• landsoul · 12/11/08, 6:02 PM

The expected release is still Friday. I will include all of the patch stuff.

• landsoul · 12/11/08, 9:00 PM

Ah well, I went ahead and put it up now. Please note that you will use this version in the anticipation of the new patch, which is supposedly coming out in the future.

Lazeela · 12/11/08, 9:09 PM

i really appreciate all the work you put into the spread sheet. I was already worried about what to do with the changes and you already released the new sheet /bow

Roshi · 12/12/08, 7:34 AM

Im having a strange issue with dps calculation -

I have entered an equip with 123 expertise rating - the cap with 2/2 Weapon mastery is 148, so expertise should be valuable at that point.

The SEP values on the top even show expertise as being worth 1,2227 Strength. However, if i change a 16 STR gem with an 16 EXP gem my overall DPS value goes down. Is this a bug or am i missing something?

File with STR gems: Download Tseng WorkbookMax xlsm for free at Uploading.com
File with expertise gems: Download Tseng HitExpertiseCap xlsm for free at Uploading.com

Btw. I can post Gnome Warrior 80 stats later this day if you still need it.

EDIT:
To make it clear - to reproduce the "bug" you need to exchange 1x 16STR gem with 1x 16EXP gem in the first file.
Although the expertise cap is not reached and expertise is worth 1,2 points of str the change decreases dps.

Tesai · 12/12/08, 9:56 AM

I have a similar problem with expertise.

I have adjusted an equip with 140Expertise Rating. Then i raised my expertise rating to 150 through a gem and checked my dps value again. But nothing happened, i checked everything but couldnt find the reason for it. This only appears with expertise ratings above 100. Perhaps im missing something? Through Gear i have 140expertise, there are no Racials nor buffs which increase my expertise. But the main bar says that Expertise Value is 0. Surely im missing something, but i cant imagine what.

Additionally the entered expertise value for Zeliek`s Gauntlets is wrong. They only have 43 expertise, not 53.

But thanks for your good work on this, things like that really help alot when chosing gear.

so long
Stoke

Freddie · 12/12/08, 3:37 PM

Playing with the new sheet, seems to be a bug with Darkmoon Card: Greatness (should be 90 STR instead of 90 AP, and needs a PROC entry).

Also a question about 3.0.8 hit cap. Does the spreadsheet take into account the possible rage starvation issues at all? Running with 5-6% hit seems like it would have a much higher chance of running into situations where you get a series of white misses and can't do anything much at all.

• landsoul · 12/12/08, 4:26 PM

Yes that is true, and it probably would help with differentiating a bit, but I have not come across a reasonable model that I can use yet. It's been an issue brought up a few times and I do plan on addressing it.

I only need gnome HP now, I have everything else, but if you want to post those that is fine, I need to verify it I guess.

• landsoul · 12/13/08, 1:07 AM

I figured out what was wrong with the expertise. Its inside an INT() function which means that if the conversion rate doesnt click it over another .25% it doesnt count the full DPS. Your 16 exp gem is doing what an 12 exp gem and a 14 exp gem would also do. Working as intended, just gotta keep that in mind.

• landsoul · 12/13/08, 2:58 PM

Here's a big thing I missed in the current build:

Known Bugs
Whirlwind Formula: Missing off-hand multiplier. To fix it now, put (.5*.025*V13)* in front of the off-hand damage part of whirlwind calculated in D71. Oops, sorry guys.

Should be easy to fix

Update: New build soon with new hit table values and crit depression vs boss. Also updating optimal rotation delaying WW for slam proc and the 8 second glyph.

Rocco · 12/14/08, 12:36 AM

My weapon, [Final Voyage] isn't in the spreadsheet! Oh the horror!

• landsoul · 12/14/08, 12:49 AM

Oh my, I'll get that fixed, sorry. Wowhead fails me.

Rocco · 12/14/08, 3:15 AM

awesome job on the spreadsheet by the way, thanks for putting this together and updating it so nicely!

How did you come up with your numbers for the trinkets procs and what does the numbers mean? Why does it only say "4" on [Fury of the Five Flights] for example?

And why do you have all these polearms in the spreadsheet? Can't dual weild those anyway!

oh, and I get an error on the Lookup tab when i try to use the SEP macro there.

Error no. 438.

The Object does not support the method. (translated from swedish)

When i try and look whats wrong it says that in Module 6,

 Range("D1:S225").Select

    ActiveWorkbook.Worksheets("Lookup").Sort.SortFields.Clear

that this yellow marked text is whats giving the error.

zinv · 12/14/08, 5:48 AM

Hi, I have a question regarding the bloodsurge calculation.
in the current version of the spreadsheet the formula is :

(0.2/3*V23) *(3*(1-I66-I73)+7*L65)/10*B70*(1+0.1*B57)*(1+0.02*V24)*(1-I66-I73+L89*I70)*(O64+P62*IF(B29=80,250,140)*P64)

(0.2/3*V23) = chance check
B70*(1+0.1*B57)*(1+0.02*V24)*(1-I66-I73+L89*I70)*(O64+P62*IF(B29=80,250,140)*P64) = average bloodsurge damage

which leaves (3*(1-I66-I73)+7*L65)/10 for the numbers of attacks made per second of which Bloodsurge can proc,
because bloodsurge dps would be (chance to proc)*(attacks per second of which bloodsurge can proc)*(average damage dealt by Bloodsurge)

but that line says : (3*(1-(yellow miss chance)-(dodge chance on MH)+7*(heroic strikes landed per second)) / 10

I dont see how that includes the procchance from Heroic strikes, Whirlwinds and BLoodthirsts.
sorry if I am just not seeing the obvious.
If I am wrong and you have some time i would be much obliged if you could explain it to me

second thing I thought was that the average rage cost of a heroic strike would have to rise by 3 (15*0.2) because every Bloodsurge proc of a heroic strike decreases the rage available for heroic strikes equaling less overall heroic strikes.

Please excuse my english. I'm from germany and its damn early too.

• landsoul · 12/14/08, 8:41 PM

Right. (3*(1-I66-I73)+7*L65)/10 came from an older 10 second DPS period that I am changing now in the advent of the 8 second WW glyph. I'm changing it to a more complicated model in a 16 second period that takes into account combining percentage chances of Slam! and when it is up in relation to heroic, BT, and WW. You can see the new rotation table by scrolling all the way down to the 170's on the Set1 page.

Im am uploading it within the next few minutes.

• landsoul · 12/14/08, 8:48 PM

Why are there numbers next to trinket calculations? That's an ordered list it helps me keep track of things, I used it before but its not so needed now. How are trinkets calculated?

Average uptime * value of proc
Uptime = duration / (ICD + time to reproc)

Time to reproc can vary depending on the trinket

For example darkmoon card greatness has a 15 duration, 45 ICD and a 35% on all hits proc.

= $\frac{15}{45+\frac{1}{0.35*\text{HitsPerSecond}}}$

with 1.5 hits per second, this card gets 31.98% uptime.
thusly, the value of the proc is 95.94 strength.

DarkS · 12/15/08, 11:54 AM

About Enchants:

+32 Attack Power is unavailable. I know +16 STR is better but isn't available for Ring enchanting at this moment

Thanks for the awesome spreadsheet Landsoul.

zinv · 12/15/08, 1:01 PM

something seems to be off with the crit rating conversion to crit%
I have 33.28% crit unbuffed and the spreadsheet says i have 29.76 unbuffed and in the hit table it says i have a 26.63% chance to crit.
When i add the flat modifiers of BLood poisoning and Rampage the hit table critchance goes up to 34.65

Amyannirving · 12/15/08, 4:06 PM

Is there some kind of unknown bug with the way scourgebane works right now, or should it be better than +85AP against undead? Every version of the spreadsheet has reported scourgebane as not being as good as greater savagery against undead. This shouldn't be the case right?

• landsoul · 12/15/08, 7:18 PM

Scourgebane isnt put in yet. Why would you put Scourgebane on a weapon versus straight AP? In fact, I don't even know why I still have those names loaded in the list. I'll take them out I guess.

Zinv, if you have "Boss" in the Mlevel cell, it subtracts 4.8% from your crit rating. That is the crit rating depression found on bosses from new research. Due to your unbuffed crit being wrong, you should double check everything. Make sure "Berserker Stance?" cell has a 1 in it, make sure you are using the right gems, etc. Seems to work fine for me.

zinv · 12/15/08, 8:09 PM

i checked, twice

Slevin · 12/15/08, 8:35 PM

World of Warcraft PTR Patch 3.0.8

Hunters:

Call of the Wild: The benefit from this pet talent now applies to only the Hunter and their own pet.

WoW -> Test Realm Patch Notes

• Bluefish · 12/16/08, 4:14 AM

Landsoul, when I open the 2003 version of 2.110 in Office 2003 and flip to the Lookup tables, the gem SEP values for items with sockets are #VALUE!. On the black sidebar on the left, R Y and B are all #VALUE! and so is max. The SEP macro runs but doesn't fix any of the missing values, and the Sort button gives the following dialog: Microsoft Visual Basic popup, "Run-time error '438': Object doesn't support this property or method." One of the available options is Debug; when I hit that I am taken to the code of Module6, line:

ActiveWorkbook.Worksheets("Lookup").Sort.SortFields.Clear

It's basically the second line from the top. As far as I can tell I've followed the directions on the first page; in 2003, Excel Options -> Formulas becomes Tools -> Options -> Calculation, and the editable field (.many0s1) is max change, not min. Excel Options -> Trust becomes Tools -> Options -> Security -> Macro Security... and I have that set to no security.

Thank you for continuing to support 2003 for those of us who are broke and/or have stingy schools...

• landsoul · 12/16/08, 6:32 AM

I think I know what's wrong. '03 can't nest more than 7 times. I'll have to problem solve a little bit more to fix the logic of the gems.

Amyannirving · 12/16/08, 12:06 PM

Originally Posted by landsoul

Scourgebane isnt put in yet. Why would you put Scourgebane on a weapon versus straight AP? In fact, I don't even know why I still have those names loaded in the list. I'll take them out I guess.

Zinv, if you have "Boss" in the Mlevel cell, it subtracts 4.8% from your crit rating. That is the crit rating depression found on bosses from new research. Due to your unbuffed crit being wrong, you should double check everything. Make sure "Berserker Stance?" cell has a 1 in it, make sure you are using the right gems, etc. Seems to work fine for me.

Doesn't scourgebane give you 140 additional AP against undead? I would think that against undead mobs it would be better than the +85 you get from greater savagery or the +110 you get from massacre. So I just slapped it on one of those Ebon Blade rep swords for use as my "Naxx weapon". Does that not make sense?