I want to ask a question; Why doesnt "Rapid Killing" change any dps for the hunter as SV Spec? I just used Sample SV Spec and when I changed the talents with Rapid Killing I don't get any improvement with dps.

Because the spreadsheet runs with a 6 minutes fight. Assuming you prio Rapid Fire so it starts at once you will with Rapid Killing still only get to use it twice (0 seconds and 180 seconds, when it is up agian the fight is over), like you would with the normal cooldown. If you set it to 7 minutes I'm sure you would see a DPS increase.

Glyph of Aimed Shot is broken for Rotation Test calculations in 92a.

The CD in the Reference Table is updated to 8 secs correctly, but the rotation test itself is firing it every 10 secs (showing a frequency of 10.x secs in the lower table), so the result is exactly the same as with an empty glyph slot. It works fine with shot frequency calculations though.

Thats because you set the pirority of Aimed below Chimera. Aimed and Chimera will be ready nearly the same time and the sheet will wait for Chimera.

Just to get things right as it seems that I misunderstood the "Max time to wait for CDs" setting: It doesn't mean wait for and use the first non steady shot that comes off CD during that period, but: from all shots that come off CD this many seconds after a GCD use the best one (as defined by its priority)?

I'm not sure why this is happening and would appreciate something enlightening me. When I add heroic gear to the list and hit recalculate dps my dps goes from like 8200 to 3200. The only way I can get it to go back is to load someone else and then load my character again (After I've turned heroic raids off).

Ok, I posted something about this a few weeks ago in the 'Best Possible DPS' thread, but in retrospect that doesn't quite make sense. As I didn't get any constructive feedback, I'm hoping to get some here, since its more relevant to this thread.

Since the wolf pet benefits much less from it(the pet special is a buff not an attack), I am seeing raptor and other pets with a damage special like cats being much closer to wolf once the 4 piece t9 bonus is attained.

For raptors specifically...
Savage Rend(raptor special): Slashes the enemy with the raptor's talons for 59 to 83 damage, and causes the target to bleed for 21 to 27 damage every 5 sec for 15 sec. Successful critical strikes with this ability temporarily boost the raptor's damage by 10% for 30 sec.
Focused Fire: All damage caused by you is increased by 1/2% while your pet is active and the critical strike chance of your pet's special abilities is increased by 10/20% while Kill Command is active.

Both Savage Rend and Kill Command have a 1 minute cooldown. As such, they can be linked in a macro and cast simultaneously to increase the raptor's crit chance by 20% while he is casting savage rend, and thus greatly increasing the chances of proccing the bonus pet damage.

My concern is that spreadsheet is not able to account for this behavior, and is thus unable to correctly value a raptor pet's dps for hunter's with Focused Aim. Savage Rend is such a tiny % of a raptor's dps (<5% in my case), its important to take this into account since the shared cooldown of the 2 abilities is probably not an accident. Just about every marks build goes 7 deep in beast for Focused Fire, so this seems relevant to me. Is there some way the spreadsheet can take this into account?

A note for people making a macro to utilize this: It is necessary for the macro to be a cast sequence, so that Kill Command actually happens before the Savage Rend, and not literally simultaneously. Since Kill Command is off the global, and Savage Rend is a pet attack, you can just spam the button a few times, and both will happen correctly, off the global as normal. If you just use a /cast kill command/cast savage rend macro, savage rend will never benefit from KC, which is the opposite of what you want.

I often use the Calculations tab of the spreadsheet to better understand mechanics of the different stats. I was looking at the Armor Penetration calculations and did not understand one of the equations. The Armor Penetration Constant in cell E21 is being calculated using the variable Level_Selected. Level_Selected points to the player's level.

Shouldn't the equation be using the target's level (variable TargetLevel). Not a big deal in the grand scheme of the calcuations, but i was just trying to understand some of the details and this seemed backwards.

Thanks.

Rawboe,
I don't think the spreadsheet is using anything other than base crit for savage rend proc uptime, but I don't think it will matter anyway. Even assuming the best of conditions (100% crit on savage rend) and some impossible ones that would favor a raptor (100% uptime on 4pc proc), you're looking at about 60-70 DPS from savage rend for a Marks hunter in BiS gear. Slightly more for Survival. In early T7 it may have been different, but pet damage is so far behind now that my napkin math still favors furious howl because it buffs the hunter.

delete please

What page is the option to turn off the Marked For Death bug on?

Hi,

Love the spreadsheet.

The other day I got an idea to investigate the effect the different buffs/debuffs have on my dps. This can be done done by either starting from a no buff state and add one buff and see the effect, or from a "full" (25man) buff state and remove one.

Then I thought that maybe this could be added as a feature. Something similar to the way the gear planner works. i.e. the calculations is made from the fully equipped model, then one piece of equipment (or buff in this case) is removed and the change in dps is that items "value".

Maybe a column could be added to each buff and debuff row on the "Buffs" tab stating the dps value.

This would help in seeing which buffs you as a hunter would value the most.

(a simpler way as a "first implementation" could just be to use the calculated weighs on the overview page and just multiply with what the buff gives).

I downloaded the spreadsheet , and it wont let me modify any of the cells , i have macros enabled

*edit

it wont let me modify anything on the overveiw page

the only pre onyxia spreadsheet worked fine for me.

Small update:

I just tried out 92b and after running the test rotation it's giving me nothing but Explosive Shots. Is there a new setting that needs to be changed to make the rotation test use all of my shots again?

I noticed the same thing with the most recent version of the spreadsheet. If you go to the Rotation Test tab and under the setting Max Time to Wait for CDs - enter the value 0.8 - the spreadsheet was saved with a value of 0,80 (using a comma instead of a period).

I'm having a similar problem as described above; when I first load the spreadsheet it shows all the shot rotation values fine, as in the last version. But once I try to load my character from the armory, some of the shots zero out. This is a screenshot of the marks rotation and build, if I reset everything for survival it shows 0's in the Steady shot and Multi shot rows. I'm running windows 7, with all the latest patches and Office 2007, if that is any help at all to you in tracking this bug down.

I am seeing a small issue where I need to swap some gems around after regemming.

Basically if I have both the 245 Windrunner legs (blue and red sockets for a +6 agility bonus) and the 245 Collar of Unending Torment (a blue socket for a +4 agility bonus) it will always put the nitemare tear in the neck and break the leg set bonus by putting a 20 agility gem in there, I manually have to swap those two around and gain 2 agility with no los elsewhere.

I am also getting a bug with the new spreadsheet, Time to OOM is listed as infinite and only Chimera Shot and Silencing Shot are being fired in the rotation test. This error seems to occur after I click CalcAttributes.

I was having the same issue. It appears the "Max time to wait for CDs" entry in the recent version was "0,8" in mine. I changed it to "0.8" and it worked as expected.

Hi all,

What's this change to crit damage bonus, as per version 92b? I can't seem to find info on it.

Could someone direct me where this new calculation is?

Or even a quick answer - is the new crit damage a buff or a nerf to our crit and overall dps?

It's a localisation issue unfortunately. I'm still debating how to solve it elegantly.

One possible way is to convert it to milliseconds (much like latency) so it only uses integer numbers.