(Updated 2/20) Fury DPS Spreadsheet 3.0.1a - Page 3

Nimchip · 07/07/11, 10:39 PM

I think it's not taking into account human racial expertise. I kept reforging on the sheet because the spreadsheet said i was undercapped on Rating Caps, but when i checked in game im 1 point undercapped and it still gave me dps increases as i kept reforging expertise up to as well as displayed that i was still "under" in the Rating Caps.

landsoul · 07/07/11, 11:28 PM

Originally Posted by Nimchip

I think it's not taking into account human racial expertise. I kept reforging on the sheet because the spreadsheet said i was undercapped on Rating Caps, but when i checked in game im 1 point undercapped and it still gave me dps increases as i kept reforging expertise up to as well as displayed that i was still "under" in the Rating Caps.

Did you read the "known issues?"

Yverson87 · 07/09/11, 6:10 AM

Hey Landsoul,

first of all i want to thank you for your great work! I'm a huge fan since i discovered your spreadsheed at the times bc - lvl 70!
It's a great piece of work and a big help for every warrior who cares about facts and not "feeled dps".

1. The stats for "Voodoo Hunting Bow" are missing in your Sheet.
2. If i want to correct my Sheet with your formular from Post 1 my excel gives me an Error :'(

30% Bleed Debuff was not always on when "Full Debuff" is selected. To fix, in 'Fury Calculation' select cell AU176 and modify to the following:

=1+IF(Fury!O36="Full Debuff",'Shared Tables'!K58,IF(Fury!O36="Custom",Fury!Q52*'Shared Tables'!K58,0))

Error:

Greetings and big Thanks
Yverson

NinJOu · 07/09/11, 10:06 AM

Hello,

I got the same issue. To solve this, I had to replace ',' by ';' in the posted formula (I have a french Office version).

That should do it.

Valu · 07/09/11, 1:11 PM

Originally Posted by NinJOu

Hello,

I got the same issue. To solve this, I had to replace ',' by ';' in the posted formula (I have a french Office version).

That should do it.

Same "Fix" works in the German version. Seems to be a localisation "problem" with US and EU office.

Mansch · 07/11/11, 9:43 AM

Alliance/Horde switch in Tab:lookup, cell C6 does not work.

Another in the first post:
"Off-Hand Dodge values was incorrectly referring to the Expertise value in the Main-Hand. To fix, in Fury Calculation, N5:X5 should have its VLOOKUP row changed from 8 to 9."

VLOOKUP should read HLOOKUP (i know very minor)

Sophitia · 07/11/11, 4:25 PM

The formulas in the gem bonuses for the trinkets in the lookup sheet are giving #N/A because the vlookup is referencing the wrong column. It should be 23 not 21. (I was using Volatile Alchemist Stone)

Here are some corrections
'Fury Calculation'!S135

=VLOOKUP(VLOOKUP(P124,Trinket2Lookup,23,0),SocketBonusLookup,15,0)

'Fury Calculation'!S136

=IF(AND(P135=TRUE,Q135=TRUE),VLOOKUP(VLOOKUP(P124,Trinket2Lookup,23,0),SocketBonusLookup,VLOOKUP(S135,GemLookupVlookupNameCodes,2,0),0),0)

'Fury Calculation'!S121

=VLOOKUP(VLOOKUP(P124,Trinket2Lookup,23,0),SocketBonusLookup,15,0)

'Fury Calculation'!S122

=IF(AND(P135=TRUE,Q135=TRUE),VLOOKUP(VLOOKUP(P124,Trinket2Lookup,23,0),SocketBonusLookup,VLOOKUP(S135,GemLookupVlookupNameCodes,2,0),0),0)

Grive · 07/11/11, 8:16 PM

Originally Posted by Darian_TruBlade

Double check the "Custom Event Matrix" portion of the spreadsheet. I saw the same behavior and noticed that Apparatus was only being used once over the course of a fight. Filling in the next 2-3 uses put Apparatus well ahead of License to Slay.

Minor nit pick, but could you elaborate on the values that should be assigned to the "Up" section on "Time 2" and "Time 3"? I have yet to completely understand the importance of the numbers within the custom event matrix area and the numbers I am currently trying are not looking correct. (35,000 DPS?!!)
As to not have to pull up the sheet again.. currently the values are:

Time 1 Time 2 Time 3
UP Down Up Down Up Down
10 25 0 0 0 0

Grive · 07/11/11, 8:29 PM

Also just noticed that the Inscription shoulder enchants don't appear on the spreadsheet when "Inscription" is selected as a profession.

Lionsmane Inscription
130 Str 25 Crit

landsoul · 07/11/11, 10:46 PM

Originally Posted by Grive

Minor nit pick, but could you elaborate on the values that should be assigned to the custom event matrix area

It's really simple. All you have to do is enter each timestamp in the "Up" column (seconds/decimal) when the corresponding buff activates. It automatically assigns when the buff expires.

I can't put it any simpler than that.

Shadowhide · 07/12/11, 3:31 AM

If i use fury of angerforge in trinket spot 1 and licence to slay in trinket spot 2, then if i try to switch around the two trinkets the dps changed around 1000 dps.
I tried downloading a fresh copy of the sheet but had same problem.
if you need the rest of the gear setup i'm using it's in my armory profile to the side.

it's only around 4% dps change but maybe it's worth mentioning

P.S. It seams like if the highest SEP trinket is in the 1st trinket spot i gain more dps.

Mansch · 07/12/11, 3:59 AM

Caelestrasza's Will -> Caelestrasz's Will (typo)

These items are not available to players (do not know if this they were added on purpose):
Bladed Flamewrath Cover (H)
Alpheus Legguards (H)
Choker of the Pure Heart
Stoneheart Choker (H)
Serrated Brimstone Signet (H)
Essence of the Eternal Flame (H)
Cinch of the Flaming Ember (H)
Gigantiform Bracers (H)

Knova · 07/13/11, 4:12 PM

Originally Posted by Shadowhide

If i use fury of angerforge in trinket spot 1 and licence to slay in trinket spot 2, then if i try to switch around the two trinkets the dps changed around 1000 dps.
I tried downloading a fresh copy of the sheet but had same problem.
if you need the rest of the gear setup i'm using it's in my armory profile to the side.

it's only around 4% dps change but maybe it's worth mentioning

P.S. It seams like if the highest SEP trinket is in the 1st trinket spot i gain more dps.

Did you read the rest of the thread? It is almost certainly a problem in the custom event matrix, and such problem has been described and a fix posted more than once.

Make sure that you have the spreadsheet using the trinkets correctly by putting the value (time fight position in seconds) in the CEM.

chuthoong · 07/14/11, 11:44 AM

Thanks landsoul for this awesome spreadsheet. I discovered an error: Akirus the Wormbreaker(H) has the same damage range as Heroic Ashkandi, while still having 3.6 weapon speed. Same problem with Shalugdoom.

landsoul · 07/14/11, 4:45 PM

Originally Posted by chuthoong

I discovered an error: Akirus the Wormbreaker(H) has the same damage range as Heroic Ashkandi, while still having 3.6 weapon speed. Same problem with Shalugdoom.

Those weapons have the correct ranges. Maybe there is something wrong with your sorting functions somehow.