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

Faxe · 09/22/11, 8:07 AM

I have found some mistakes with items, too.

Every Ruthless Gladiator's weapons max weapon damage ist one point too high.
Example: Ruthless Gladiator's Bonegrinder - Spreadsheet: 2142 - 3215. Ingame: 2142 - 3214. Not a huge mistake but it's a mistake.

Zaspera · 09/22/11, 9:33 PM

When trying to use Battle.net lookup, I get an error:

"Run-time error 429"
"ActiveX Component can't create object"

Any idea how to fix that? I enabled use of all macros in Excel 2010.

Ronninn · 09/23/11, 12:21 PM

I just picked up a Moonwell Chalise to experiment with the mastery cheese at the start of a fight. It appears as soon as you swap trinkets the moonwell disappears, and we no longer benefit from the mastery buff. I tried this swapping LTS, and Vessel with the same results. If anyone can confirm this has been hotfixed it so warriors can't use this anymore, maybe it's time to remove this from the spreadsheet.

EDIT : Please disregard/delete this post as it's already been addressed earlier in this thread, and I didn't try using Deathwish before the trinket swap.

Top86 · 09/23/11, 7:00 PM

Any word on what kind of dps gain a mastery heavy set with trinkets and deathwish prepull yield?

I'm curious at what level of mastery that would become a dps gain and how significant it would be.

landsoul · 09/23/11, 8:11 PM

I would assume only a couple hundred DPS over an entire fight.

Rallik · 09/24/11, 4:32 PM

Originally Posted by Top86

any word on what kind of dps gain a mastery heavy set with trinkets and deathwish prepull yield?

Im curious at what level of mastery that would become a dps gain and how significant it would be

I'm just going to use my stats to napkincraft here. I have 1094 mastery in my normal gear, and 5555 mastery in the best mastery set I have at the moment with chalice up(the highest you can reach is somewhere around 6400). 1094 mastery puts DW at a 29.07% increase in damage. 5555 mastery puts it at 56.94% increase. I'll also assume a fight with 3 death wishes and the worst possible fight length of 430s(just before DW comes off CD again).

Without pre-fight mastery stacking: 90/430*.2907 ~= 6.08% increase in damage.
With stacking, assuming you lose about a GCD worth of effectiveness due to precasting: 28.5/430*.5694 + 60/430*.2907 ~= 7.83% increase in damage.

1.0783 / 1.0608 ~= 1.0165, or a 1.65% increase in damage over a fight. Assuming about 35k dps as a decent average, that'd be a gain of 577 dps. In practice, the gain should be higher, since fight lengths will essentially always be more favorable, and your first DW is a larger contributor to damage than the others since you'll get every other CD stacked with it as well. I'd say 750 dps(at 35k dps prior) is a decent ballpark for the gain.

kratorus · 09/24/11, 5:10 PM

First of all nice work on the new sheet. Anyway, I was checking out the new Brewfest trinket, [Coren's Chilled Chromium Coaster], and I noticed that the sheet doesn't count the attack power proc even when correctly using the event matrix section. After doing some experimentation with custom trinkets, I believe the sheet doesn't count any attack power proc or use effects on trinkets.

Also looking ahead at upcoming holiday events, it might be nice to add [The Horseman's Horrific Helmet] to the available helmets in a future build. This item looks to be slightly better than the 378 offset helm from FL due to strange reallocation of item budget from stamina to strength.

landsoul · 09/25/11, 4:23 AM

Well I guess I need to add AP as an option to trinket procs.

Zodiac2049 · 09/27/11, 10:21 AM

For anyone else who is OCD about the uptimes section in the fury tab not being complete, here are some things you can do to display the various uptimes:
Death Wish: ='Fury Calculation'!BA182
BzR: go to the fury calculations tab, find an empty cell and paste

=SUM(IF($T$279:$T$679<Fury!$J$43,$Y$279:$Y$679))/SUM(IF($T$279:$T$679<Fury!$J$43,1))

CTRL-SHIFT-ENTER
Then go back to the Fury Tab and set the E122 equal to the cell you pasted the above equation in to.
Enraged: In the Fury calculations tab Find an empty column (I use the S Column) and paste:

=IF(D279,1,(1-(1-Z279)*(1-Y279)))

hit Enter, then drag that equation (the little square at the bottom right of the cell when it's selected) down until you reach the end of the timeline (Row 679). After that's done find an empty cell and paste:

=SUM(IF($T$279:$T$679<Fury!$J$43,$S$279:$S$679))/SUM(IF($T$279:$T$679<Fury!$J$43,1))

(Note that if you use a row other than 'S' you will have to change the above equation to reflect that)
CTRL-SHIFT-ENTER
Go back to the Fury tab and set E123 equal to that cell.
Executioner(5): =(J43-Y54)/J43
Hero/Lust/Warp: =40/J43 Note that this won't be accurate for fights with a duration greater than 10 minutes.

valMichael · 09/28/11, 2:08 PM

When I load my char. (Tashirae, Shu'Halo, US) into the spreadsheet, it shows both Titan's Grip and SMF with talents.
Does SMF get credit for the 20% damage increase and the double handed slam in this case or is it using the TG calc.
The sheet shows me 24.73% below max.

Colso · 10/02/11, 9:31 AM

Don't know if it's a bug, but if i equip my DMC:H, I get the following pic shown in the Spreadsheet:

8beece2b7b53cde90f57211806aa5fd8.png

In addition, I got FoA equipped before, and concerning the Lookup page, DMC:H should give me a DPS gain around 200 DPS, but if i run the Spreadsheet, it doesn't even gave me 50 DPS.

landsoul · 10/04/11, 11:39 AM

Originally Posted by Colso

Don't know if it's a bug, but if i equip my DMC:H, I get the following pic shown in the Spreadsheet:

8beece2b7b53cde90f57211806aa5fd8.png

In addition, I got FoA equipped before, and concerning the Lookup page, DMC:H should give me a DPS gain around 200 DPS, but if i run the Spreadsheet, it doesn't even gave me 50 DPS.

What it should be doing is adding the damage proc under the "OTHER DD" classification on the Fury Page. The #NV comes from a cosmetic problem due to a missing entry in an abbreviations list. I need to add a few more things for it to show it in the damage breakdown on the Fury page: in cell BA220:

=OR(G144="Avalanche",P144="Avalanche",P110="Darkmoon Card: Hurricane",P124="Darkmoon Card: Hurricane")

should allow that box to show true which will light up the display in the main UI.

It should be calculating as long as there are counts in the OTHER DD box in Fury Calculation.

Valmichael: Both talents are set to be on and the sheet picks the appropriate style and bonus based on which weapons are equipped.

Colso · 10/04/11, 12:01 PM

Originally Posted by landsoul

What it should be doing is adding the damage proc under the "OTHER DD" classification on the Fury Page. The #NV comes from a cosmetic problem due to a missing entry in an abbreviations list. I need to add a few more things for it to show it in the damage breakdown on the Fury page: in cell BA220:

=OR(G144="Avalanche",P144="Avalanche",P110="Darkmoon Card: Hurricane",P124="Darkmoon Card: Hurricane")

should allow that box to show true which will light up the display in the main UI.

It should be calculating as long as there are counts in the OTHER DD box in Fury Calculation.

Well, the box shows true now, but the #NV is still showing on the main UI. In addition, there are no changes with the estimated DPS.

Zodiac2049 · 10/05/11, 10:22 AM

Fiery Attack's crit chance is being affected by recklessness in the spreadsheet when in-game it is not.

FIX (assuming I did this right):
Change Cell DG279 from:

=IF($AU$215=FALSE,0,1)*MIN(1-$AU$218,(1-$AU$218)*($AU$217-HLOOKUP($N$2,BaseSpellHitTableShared,3,0)+AND(B279=TRUE,C279=FALSE,E279=FALSE)*IF($V$116="Crit",$V$115,0)/'Shared Tables'!$C$4/100+AND(B279=FALSE,C279=TRUE,E279=FALSE)*IF($V$130="Crit",$V$129,0)/'Shared Tables'!$C$4/100+AND(B279=FALSE,C279=FALSE,E279=TRUE)*'Shared Tables'!$P$62+AND(B279=TRUE,C279=TRUE,E279=FALSE)*(IF($V$116="Crit",$V$115,0)+IF($V$130="Crit",$V$129,0))/'Shared Tables'!$C$4/100+AND(B279=FALSE,C279=TRUE,E279=TRUE)*(IF($V$130="Crit",$V$129,0)/'Shared Tables'!$C$4/100+'Shared Tables'!$P$62)+AND(B279=TRUE,C279=FALSE,E279=TRUE)*(IF($V$116="Crit",$V$115,0)/'Shared Tables'!$C$4/100+'Shared Tables'!$P$62)+AND(B279=TRUE,C279=TRUE,E279=TRUE)*((IF($V$116="Crit",$V$115,0)+IF($V$130="Crit",$V$129,0))/'Shared Tables'!$C$4/100+'Shared Tables'!$P$62)))

To this:

=IF($AU$215=FALSE,0,1)*MIN(1-$AU$218,(1-$AU$218)*($AU$217-HLOOKUP($N$2,BaseSpellHitTableShared,3,0)+AND(B279=TRUE,C279=FALSE)*IF($V$116="Crit",$V$115,0)/'Shared Tables'!$C$4/100+AND(B279=FALSE,C279=TRUE)*IF($V$130="Crit",$V$129,0)/'Shared Tables'!$C$4/100+AND(B279=TRUE,C279=TRUE)*(IF($V$116="Crit",$V$115,0)+IF($V$130="Crit",$V$129,0))/'Shared Tables'!$C$4/100))

Then click/drag the black box on the lower right corner of the cell all the way down to DG679

theclarkofben · 10/06/11, 7:12 AM

I've just compared two gear sets and have observed un-expected results which may suggest the spreadsheet's calculations are incorrect. I would appreciate your review and comments.

Gear set 1: 5540 STR; 2570 CRIT; 840 EXP; 666 HASTE; 944 HIT; 711 MAST = 26191.0426 DPS
Gear set 2: 5540 STR; 2850 CRIT; 784 EXP; 597 HASTE; 944 HIT; 620 MAST = 25961.2965 DPS

The only difference between the gear sets (apart from re-forging) is that gear set 1 has [Heart of Rage] (359 version) equipped and gear set 2 has [Coren's Chilled Chromium Coaster] equipped instead. Landsoul's spreadsheet informs me that CCCC is a better trinket than HoR. With that in mind and the fact that gear set 2 provides almost 300 more crit I am confused by the spreadsheet's conclusion that gear set 1 is a dps increase over gear set 2.