For some reason, when loading my gear/talents directly from my armory and disabling all buffs the spreadsheet shows my crit % as 37.29%, whilst I actually only have 36.09% according to my character sheet - anyone have any idea why this would occur?

Negative, it does save the flask on another profile and about anything else that influencing the overall dps that´s linked to a profile.

Please add Greater Inscription of the Gladiator, a new shoulder enhancement that gives 30 stamina and 15 resilience.

Edit: I'll also second putting the Rift-Stalkers set back in the spreadsheet, in certain circumstances the set bonus is well worth the DPS hit. For example, up until this week I was using my scorpid in raids, and the set bonus along with talents allowed me to tank the caster four horsemen with little to no help from a healer.

I apologize in advance for the noob question. I just started using the spreadsheet and for whatever reason, even though I have created and saved a new profile, the numbers for dps on the overview tab do not change those to reflect new talents or other changes in the other tabs. The numbers on the overview tab remain exactly as they were when I first downloaded the spreadsheet. Can someone please explain what I am doing wrong? Thanks.

You will need to hit the Save Profile button on the gear tab before the values shown in the overview tab will change.

Post deleted as question is moot.

First, THANK YOU for this spreadsheet. I spent several weeks reading the boards and familiarizing myself with this tool but one question remains unanswered and it echoes Snafoo's post (above). Both of my AP and Crit are slightly off compared with my armory. I have checked and rechecked every page of this spreadsheet and I can't seem to find the discrepancy. I have disabled all buffs, as well.

Lastly, how do you change anything on the "settings" tab? I'm afraid this problem has outsmarted me too.
<edit> I can access the drop down menus to change the defaults, but when I try to change any of them I get a dialog box telling me that it is protected.

There is an option to enable macros if you're using Excel 2008, that messed me up a bit too. As for the AP and Crit, I don't know, but I know it's doing this for me too.

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.

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.

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.....

As of sheet v82 Savage Cobalt Slicer is erroneous

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

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

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

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.

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.

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.

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.

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.