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

Exrex · 08/05/11, 10:40 PM

Great work with this spreadsheet!

Though, I have a problem regarding opening it, it's probably something tedious as I don't see anyone else posting about it or anything suggesting how to solve it.

When I open the spreadsheet it says it has found unreadable content and if I want to recover the contents and I click yes to this (as clicking no simply just doesn't open the sheet). It then attempts to recover it and after two attempts it stops, saying it has recovered the document by removing or repairing unreadable content and the following error message is supplied:

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Replaced Part: /xl/worksheets/sheet4.xml part with XML error. Unexpected end of input. Line 2, column 18873838.
Removed Records: Worksheet properties from /xl/workbook.xml part (Workbook)
Removed Records: Document Theme from /xl/workbook.xml part (Workbook)

If anyone has got any help regarding this It'd be highly appreciated. On a side note I did NOT have this problem with the previous beta version. I've also tried downloading the sheet several times but it comes back to the same error.

landsoul · 08/06/11, 1:05 AM

Hopefully this will go away with the new upcoming BETA build! /crosses fingers

Elmor · 08/06/11, 1:46 AM

Originally Posted by landsoul

Questions are:
If it crits does it do double damage
Does it scale with Spell modifiers
What crit rate does it use
etc

Tested Fiery Attack(100RB):
1.Crits do double damage
2.Yes, tested with CoE
It also can be dodged and parried, uses melee special hit cap(8%, no misses with 12% hit)

No CoE on dummy:
ImageShack� - Online Photo and Video Hosting

CoE on dummy:
ImageShack� - Online Photo and Video Hosting

Exrex · 08/06/11, 2:59 AM

Originally Posted by Exrex

Great work with this spreadsheet!

Though, I have a problem regarding opening it, it's probably something tedious as I don't see anyone else posting about it or anything suggesting how to solve it.

When I open the spreadsheet it says it has found unreadable content and if I want to recover the contents and I click yes to this (as clicking no simply just doesn't open the sheet). It then attempts to recover it and after two attempts it stops, saying it has recovered the document by removing or repairing unreadable content and the following error message is supplied:

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Replaced Part: /xl/worksheets/sheet4.xml part with XML error. Unexpected end of input. Line 2, column 18873838.
Removed Records: Worksheet properties from /xl/workbook.xml part (Workbook)
Removed Records: Document Theme from /xl/workbook.xml part (Workbook)

If anyone has got any help regarding this It'd be highly appreciated. On a side note I did NOT have this problem with the previous beta version. I've also tried downloading the sheet several times but it comes back to the same error.

Arh, I forgot to include a significant point here (I guess that's what no sleep does to you

), The spreadsheet is EMPTY once it's been attempted repaired. The only thing that remains are the titles of the sheet tabs.

squishye · 08/06/11, 2:27 PM

Originally Posted by Elmor

Tested Fiery Attack(100RB):
1.Crits do double damage
2.Yes, tested with CoE
It also can be dodged and parried, uses melee special hit cap(8%, no misses with 12% hit)

No CoE on dummy:
ImageShack� - Online Photo and Video Hosting

CoE on dummy:
ImageShack� - Online Photo and Video Hosting

1. Does the Off-Hand proc do MH weapon damage or OH weapon damage? (what happen if I have a weaker off-hand)

2. As silly as it sounds, are those Fiery Attack parry/dodge/miss due to it procing off RB parry/dodge/miss?

DemisedOne · 08/06/11, 11:12 PM

i get run time error 1004 when i try to import my profile

this is the string

Worksheets(spec).range(name & "Equip" & spec).value = Worksheets("Lookup").range(name & "LookupAnchor").Offset(Application.WorksheetFunction.Match(item.id, Worksheets("Lookup").range(name & "ID"), 0))

this happens right after the chest is looked up

squishye · 08/08/11, 10:38 PM

BETA2 SS:

In Fury Calculation from Z279 all the way down (Enrage up), you are using the basic 9% for Enrage. Need to multiply $BA$185 by (1 + %from Mastery).

landsoul · 08/08/11, 11:31 PM

Originally Posted by squishye

BETA2 SS:

In Fury Calculation from Z279 all the way down (Enrage up), you are using the basic 9% for Enrage. Need to multiply $BA$185 by (1 + %from Mastery).

This is the check to see if Enrage is up, not what the DIM is.

The basic DIM is 10%, not 9% also.

squishye · 08/09/11, 5:12 PM

Originally Posted by landsoul

This is the check to see if Enrage is up, not what the DIM is.

The basic DIM is 10%, not 9% also.

Got it

So I modifidied Beta2 SS hoping that it'd verify the DPS improvement on different SMF rotation. Since I'm not sure what I did to the SS is even valid, I'm gonna put the results in this thread.

First thing I did was changing Fiery Attack proc chance to 60% in order to simulate RB off-hand proc.
Then put on SMF BiS w/ 6 expertise rating over cap, and w/ hit > mastery.
DPS: 37492.9084
# of Slam used: 30.4
# of RB used: 26.17

Then I changed style to TG, added SMF 20% DM back, removed Slam Off-hand restriction. So now I use RB over Slam no matter what.
DPS: 37584.6724
# of Slam used: 18.22
# of RB used: 44.39

Then I changed the Slam priority a bit (w/ previous changes), so that if CS debuff is up, I use Slam over RB. RB over Slam otherwise.
In Slam formula (column AY), I replaced AZ280 with IF(R280 = 1, 0, AZ280).
In RB formula (column AZ), I added IF(R280 = 1, AY280, 0) in (1-AW280-AX280-BD280), so it's now (1 - AW280 - AX280 - BD280 - IF(R280 = 1, AY280, 0))
DPS: 37989.5342
# of Slam used: 20.99
# of RB used: 42.81

The last one improves DPS by quite a bit. So I wonder if what I did is correct.

squishye · 08/10/11, 12:00 PM

Originally Posted by squishye

The last one improves DPS by quite a bit. So I wonder if what I did is correct.

Ok, I found out what I did wrong. I forgot to add restriction for T12Shout when CS Debuff is up. So there are times when it uses Slam and T12Shout at the same GCD.

I switched Slam, RB, T12Shout priorities inside CS debuff and here are the results for different SMF rotations:

Original SMF priorities:
DPS: 37492.9084
Slam#: 30.4
RB#: 26.17

CS debuff up: T12Shout > Slam > RB
normal TG priorities otherwise
DPS: 37726.3841
Slam#: 19.68
RB#: 41.99

CS debuff up: Slam > RB > T12Shout
normal TG priorities otherwise
DPS: 37834.0042
Slam#: 21.00
RB#: 42.41

CS debuff up: Slam > T12Shout > RB
normal TG prioritiees otherwise
DPS: 37862.6251
Slam#: 21.07
RB#: 41.94

The DPS from the last SMF rotation is almost the same as TG with 391/391 2H swords.

Zodiac2049 · 08/10/11, 3:10 PM

T12 4pc calculations do not appear to account for fiery attack crits being able to proc deep wounds and flurry:

13:53:24> [Your] [Raging Blow] hit [Training Dummy] 1 Physical. (13094 Overkill) 
13:53:24> [Your] [Raging Blow Off-Hand] hit [Training Dummy] 1 Physical. (6909 Overkill) 
13:53:25> [Your] [Fiery Attack] hit [Training Dummy] 1 Fire. (13710 Overkill) (Critical) 
13:53:26> [Your] [Deep Wounds] afflicted [Training Dummy]. 
13:53:32> [Your] [Deep Wounds] dissipated [Training Dummy]. 
13:53:40> [Your] [Flurry] faded [You]. (this is exactly 15 seconds after the crit occurred, which is flurry's duration)

landsoul · 08/11/11, 2:03 AM

So is the crit rate based on

A: spell crit rate (different buff/debuff set)
or
B: physical crit rate

???

squishye · 08/11/11, 9:57 AM

Muspel · 08/11/11, 11:01 AM

The itemID for Coren's Chromium Coaster is currently listed as 70141 in the spreadsheet (cell EO11 on the "lookup" page), when it should be 71335. I believe this is the cause of the bug reported by vellox:

Originally Posted by vellox

When importing my character from the armory, Dwyer's Caber comes up as Coren's Chilled Chromium Coaster.

I manually edited in the correct itemID, and it fixed the issue.

Zodiac2049 · 08/11/11, 3:26 PM

Originally Posted by landsoul

So is the crit rate based on
...

judging from my guilds parses last night, after 82 procs, Fiery attack had a crit rate of 25.6%, which is awfully close to my melee crit rate of 24.8% for the night. Obviously this sample size is too small to say with absolute certainty, but it seems to be based off melee crit rates. I'll see what I can do about increasing the sample size over the weekend.

Cymoril · 08/11/11, 8:38 PM

Error value on Dwyer's Caber. Cooldown is 45 seconds not 100 listed on the trinket selection of the look up tab.

Zodiac2049 · 08/12/11, 12:18 AM

Originally Posted by Zodiac2049

I'll see what I can do about increasing the sample size over the weekend.

using a melee crit chance of 29.5% and a spell crit chance of 24.67%, after 1200 procs I observed a crit rate of 30.2%. So the answer is it's based on melee crit rates.

Grayson Carlyle · 08/12/11, 1:15 AM

Originally Posted by Zodiac2049

of the landslide for example in the lookup lists as hit/expertise, when it game it's hit/crit.

No it's not. Where are you getting your information? You're even wearing an Earthshaker ring that's hit/crit.

Cloudburst Cloak - Item - World of Warcraft is a quick, easy way to see what the suffixes are.

Memnor · 08/12/11, 2:44 AM

When I try to retrieve my character from Armory, I get the following error:

Run-time error '1004':

Luokan WorksheetFuntion ominaisuuden match saanti ei onnistu.

Yeah, I'm running Finnish Excel, so the error message is in Finnish, but in English that would be approximately something like "Cannot get/retrieve the feature match for class Worksheet fuction", or in the same order "Class WorksheetFunction feature match cannot be got/retrieved."

..okay, this is weird.
I thought that before posting, I would try once more after making sure I'm logged out in pve gear and spec and Armory having me in the correct spec and gear.

And voila! It works perfectly.

But yeah, getting a run-time error in pvp gear doesn't really seem that awesome. If it really causes the error instead of something, maybe the spreadsheet introduction could mention something along the lines of "The spreadsheet might not work at all if you are in pvp gear/spec". (Should it matter, the run-time error seems to pop around the time my pvp shoulders got put in the sheet.)

Zodiac2049 · 08/12/11, 2:45 PM

Originally Posted by Grayson Carlyle

No it's not. Where are you getting your information? You're even wearing an Earthshaker ring that's hit/crit.

Cloudburst Cloak - Item - World of Warcraft is a quick, easy way to see what the suffixes are.

I'm getting this information because I am an idiot and didn't notice the fact that the suffix that was picked up from the armory lookup wasn't the same as the suffix of my ring in game, which is likely due to the armory not tracking the random enchantment very well.

Aw1195 · 08/13/11, 10:52 PM

Originally Posted by Memnor

When I try to retrieve my character from Armory, I get the following error:

Run-time error '1004':

Luokan WorksheetFuntion ominaisuuden match saanti ei onnistu.

Yeah, I'm running Finnish Excel, so the error message is in Finnish, but in English that would be approximately something like "Cannot get/retrieve the feature match for class Worksheet fuction", or in the same order "Class WorksheetFunction feature match cannot be got/retrieved."

..okay, this is weird.
I thought that before posting, I would try once more after making sure I'm logged out in pve gear and spec and Armory having me in the correct spec and gear.

And voila! It works perfectly.

But yeah, getting a run-time error in pvp gear doesn't really seem that awesome. If it really causes the error instead of something, maybe the spreadsheet introduction could mention something along the lines of "The spreadsheet might not work at all if you are in pvp gear/spec". (Should it matter, the run-time error seems to pop around the time my pvp shoulders got put in the sheet.)

I'm getting something similar to you but I tried logging out with correct spec + gear (without pvp) and it's still giving me 'Run-time error' Unable to get the Match property of the WorksheetFunction class.

Can anyone help me with this?

jtxdriggers · 08/14/11, 3:58 PM

Originally Posted by Aw1195

I'm getting something similar to you but I tried logging out with correct spec + gear (without pvp) and it's still giving me 'Run-time error' Unable to get the Match property of the WorksheetFunction class.

Can anyone help me with this?

Your Vicious Glad belt might have something to do with it.

To Landsoul: Is this bug a problem with resilience gear in general, or perhaps the new ilvl 371 season 10 gear?

Quiks · 08/14/11, 6:57 PM

Originally Posted by landsoul

So is the crit rate based on

A: spell crit rate (different buff/debuff set)
or
B: physical crit rate

???

It is physical crit rate. My guildy tested it on a sample size of 1500 procs. I'll bug him later for a recount screenshot.

NavySWO91 · 08/15/11, 12:05 PM

Item Update: At some point, [Terborus's Rotating Bands] was revised to 99 Hit & 101 Mastery. The spreadsheet still shows 92 Hit & 112 Mastery.

Also, on the 346 [Thundercall] I noticed that the spreadsheet lists it with 22 Crit. Is this leftover from beta? It actually has 56 Parry, which can be reforged to 22 Crit, but that parry can also be reforged to 22 Exp (which I found myself doing). Can this parry be modeled so that it can be reforged into other secondary stats?

As others have said, thanks much for your hard work.

Cheers!

NavySWO91 · 08/15/11, 6:04 PM

Not sure of the cause on this one, but spreadsheet won't allow reforge of Mastery to Crit on [Volatile Alchemist Stone]. It only allows reforge to Expertise.

Cheers