Warrior DPS Calculation Spreadsheet - Page 6

ebs2002 · 12/11/08, 4: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, 5:02 PM

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

landsoul · 12/11/08, 8: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, 8: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, 6: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, 8: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, 2: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, 3: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, 12: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, 1: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/13/08, 11:36 PM

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

landsoul · 12/13/08, 11:49 PM

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

Rocco · 12/14/08, 2: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, 4: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, 7: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.