WotLK DPS spreadsheet - Page 95

Midnight · 01/25/09, 4:14 AM

Originally Posted by Pyewacket

Yeah, the macro thing messed me up for a while, too. They are enabled now, however and I still can't make any changes to the drop downs on the settings tab.

I appreciate the reply, though. I'll keep poking around.

Edit: It has my crit rating correct, however when it is translated into a %chance to crit, it seems to calculate it differently than the armory. The difference in AP is apparently due to the spreadsheet factoring in AOTH and Furious Howl.

On the one hand the spreadsheet averages out effects like Master Tactician leading to a higher critchance than what the armory shows. On the other hand it also includes a 4,8% crit depression against boss level targets lowering it again. So you can´t really compare the armory value with the spreadsheet value because the latter tries to predict the actual crit chance more precisely than the armory does. Check the calculations tab to find out how exactly it arrives at the value it does.

Pyewacket · 01/25/09, 4:17 AM

Thank you. That is good to know.

Now that you have explained what is going on, it is quite easy to understand. My apologies for being dense. It's just that the final crit rate was so close to the crit rate in my armory profile that I thought I was doing something wrong.

Runningelk · 01/25/09, 12:14 PM

Nevermind.... I'm an idiot .... nothing to see here ... just point and laugh ....

{BUG - I'm making the switch to a ravager for the changes in 3.0.8 and I noticed with the latest version of the spreadsheet that the ravager comes up as a CUNNING pet instead of a FEROCITY pet. Both wowhead and petopia have it listed as ferocity.}

Kureel · 01/25/09, 12:23 PM

Originally Posted by Runningelk

BUG - I'm making the switch to a ravager for the changes in 3.0.8 and I noticed with the latest version of the spreadsheet that the ravager comes up as a CUNNING pet instead of a FEROCITY pet. Both wowhead and petopia have it listed as ferocity.

Ravagers are Cunning Pets. And both Wowhead and Petopia have it listed as cunning.

Runningelk · 01/25/09, 1:24 PM

Originally Posted by Kureel

Ravagers are Cunning Pets. And both Wowhead and Petopia have it listed as cunning.

Raptor, ravager... why do they have to be so damn close... please excuse me while I sit in the corner and bludgeon myself with my dunce cap.....

ElDoc · 01/25/09, 5:08 PM

As of sheet v82 Savage Cobalt Slicer is erroneous

Savage Cobalt Slicer on live are :
- 30 agi
- 20 hit
- 40 pa

Iroared · 01/25/09, 9:41 PM

Well the spreadsheet still shows BM as best DPS. Fix?

Iru · 01/25/09, 9:49 PM

For your current gear perhaps. This thread says otherwise however.

Decker · 01/26/09, 12:30 AM

Originally Posted by Iroared

Well the spreadsheet still shows BM as best DPS. Fix?

You'll have to explain further. What numbers are you using and did you setup your shot rotation correctly?

♦ arison · 01/26/09, 1:41 AM

Right now, it seems like the spreadsheet models IAotH as averaged haste. This is a problem because of how haste interacts with Steady Shot cast times; it easily can change rotations, which I don't think the spreadsheet's approach properly handles (basically, 100% of SSs become less than 1.5s rather than the average uptime percentage of Quick Shots being less than 1.5s). For me, it shows a constant 1 ES/3 SS cast, and yet that definitely isn't the case in reality.

Would it be possible to model this differently? Even a "shot" in shot rotations where it procs every N shots, rather than randomly, would model things a bit better. I believe currently haste is a bit undervalued since it is easy to get the average haste effect from IAotH to bring SS low enough for a constant ES/SS/SS/SS rotation, and yet, in practice, it doesn't quite work out that way. Averaging out AP, etc, in general seems fine, but something that can have a more significant change, such as rotations, seems like it needs to be handled a bit more delicately.

Iroared · 01/26/09, 2:12 AM

Mhm yea I guess BM did more dps because I forgot to change rotation.

Now I got it showing 5474 DPS for my gear and SV rotation, and I don't see how I am supposed to get that much. With full (or almost full) raid buffs I will probably pull around 4k, maybe 4.5k, but not 5.5. What is wrong?
Unbuffed DPS is 2800 which is close to what I get on a dummy, but I don't see it doubling with raidbuffs.

Synergy · 01/26/09, 10:32 AM

I have a question that me and my guild members were discussing a few days back that I can't seem to figure out.

My question is why am I doing so much less DPS than my spreadsheets says I should be doing with my gear and spec?

First of all, yes I use the spreadsheet, I'm not retardedly specced or glyphed and I believe I know how to play. Assume that I'm not an idiot when answering my question. The spreadsheet says I should be doing 5600 or more DPS but I'm not. I normally do around 4000 which is a pretty large gap. Though... my dps is normally at the top or very near the top of my guild's. My guild has been doing Naxx 25 and Maly and stuff since week 2 of WotLK so we are geared but none of us do the crazy 5k or 6k dps I see in some WWSs. My only 2 ideas are 1. our sever lag is horrible (we play on Burning Blade US or affectionately known as "Broken Blade" or 2. our raid buffs/debuffs suck. We run kinda melee heavy.

If anyone could help me out and tell me why there is such a large gap in my spreadsheet dps compared to my actual DPS I'd be grateful.

Fierra · 01/26/09, 10:46 AM

Originally Posted by Synergy

I have a question that me and my guild members were discussing a few days back that I can't seem to figure out.

My question is why am I doing so much less DPS than my spreadsheets says I should be doing with my gear and spec?

First of all, yes I use the spreadsheet, I'm not retardedly specced or glyphed and I believe I know how to play. Assume that I'm not an idiot when answering my question. The spreadsheet says I should be doing 5600 or more DPS but I'm not. I normally do around 4000 which is a pretty large gap. Though... my dps is normally at the top or very near the top of my guild's. My guild has been doing Naxx 25 and Maly and stuff since week 2 of WotLK so we are geared but none of us do the crazy 5k or 6k dps I see in some WWSs. My only 2 ideas are 1. our sever lag is horrible (we play on Burning Blade US or affectionately known as "Broken Blade" or 2. our raid buffs/debuffs suck. We run kinda melee heavy.

If anyone could help me out and tell me why there is such a large gap in my spreadsheet dps compared to my actual DPS I'd be grateful.

The spreadsheet comes loaded with Shandara's buff/debuff loadout for her group. Tailor yours to reflect what you actually have. Also, make sure you're actually following through with whatever shot priority/cycle you've put in the spreadsheet.

faerr · 01/26/09, 11:23 AM

I think it would also be great if we could create "Pet" profiles to compare how our DPS changes between different pets. ie: Quickly comparing the DPS loss or gain by taking a Cunning pet for Roar of Recovery, thus extending the time to OOM, vs. Ferocity pet for Rabid, generating more direct DPS. Currently we can leave the talents for each tree intact, but the ability rotation need to be manually adjusted each time.

Faerdael · 01/26/09, 11:46 AM

Originally Posted by arison

Right now, it seems like the spreadsheet models IAotH as averaged haste. This is a problem because of how haste interacts with Steady Shot cast times; it easily can change rotations, which I don't think the spreadsheet's approach properly handles (basically, 100% of SSs become less than 1.5s rather than the average uptime percentage of Quick Shots being less than 1.5s). For me, it shows a constant 1 ES/3 SS cast, and yet that definitely isn't the case in reality.

Would it be possible to model this differently? Even a "shot" in shot rotations where it procs every N shots, rather than randomly, would model things a bit better. I believe currently haste is a bit undervalued since it is easy to get the average haste effect from IAotH to bring SS low enough for a constant ES/SS/SS/SS rotation, and yet, in practice, it doesn't quite work out that way. Averaging out AP, etc, in general seems fine, but something that can have a more significant change, such as rotations, seems like it needs to be handled a bit more delicately.

There is a Rotation Test tab, and an option under settings "Use Rotation Test results instead of frequencies" which will calculate based on actual rotation, rather than averages, which you may like better, and is generally more kind toward haste, presumably for the reasons you mentioned. The thing is, the rotation test tab does not currently appear to incorperate IAotH, thus probably overvaluing haste to a degree. I imagine this would be a difficult thing to model.

I would also like to add a list of enhancement requests toward Shandara; natually don't expect them all, but things that I could definitely make use of:

*Add Kill Command to DPS values. Currently does not affect DPS values when defined in Shot Rotation; ratio = 0%. Also under Rotation Test, Kill Shot is never incorperated.

*Ability to manually model rotation via Rotation Test tab.

*Add option to set Rotation Test duration to the Boss Fight length.

*Add support for IAotH procs in Rotation Test

*Under Gear, add support for adding Blacksmith sockets to Hands and Wrists.

*Under Gear, Move Haste and Pen columns more to the left (perhaps between "Hit" and "Mp5"). It is a slight nuisance to have to scroll past things like resilience to get to actual dps stats.

*Under Buffs, enable Swift Retribution and Sanc. Retribution Aura under your pre-saved Level 80 Raid.

Also, I think its safe to say you can remove the Aldor/Scryer setting from the spreadsheet, since that was really there for handling the Shattered Sun necklace proc, and that item no longer is on the spreadsheet.