Shandara

Update:

WotLK Hunter DPS Spreadsheet

 

Ravenfire

Has anyone else noticed a strange phenomenon regarding Explosive shot and % damage modifiers? Last night I noticed that several of my explosive shot ticks seemed to be instantly effected by switching between AotV and AotDH. I did some very quick tests on a target dummy and confirmed that switching on AotV will instantly cause the last tick(s) of a single explosive shot to suffer the damage reduction. Likewise switching AotV off instantly will cause an increase of damage if explosive shot was initially applied while AotV was on. Further testing showed that even Focused Fire has an immediate impact on Exposive shot ticks. I didn't think to test Noxious Posions, but I did notice that this seems to only be effected by % damage buffs as going from no aspec to AotDH on did not cause a damage increase between ExShot ticks and neither did applying Hunter's Mark to a target after hitting it with an Explosive Shot.

Of course I wanted to know if our other dot was likewise effected and did the same tests of Serpent Sting. Results on that were conculsive: % damage buffs do not change sting ticks between applications. Serpent Sting MUST be reapplied before damage modifers register. What this means is that fights (Thaddius, Malygos) where % damage buffs/debuffs affect us will instantly cause explosive shot to increase/decrease EVEN IF Explosive shot was applied before the buff/debuff affects us.

I don't know if this is an intended mechanic or not as Explosive Shot is (as far as I know) the only dot that can crit.

As for how to model this accurately in the spread sheet I am unsure as to whether or not it is valid. I know personally that when I have AotV on I tend to hold off using Explosive Shot if I am about to switch OUT of AotV while I likewise delay going into AotV if Explosive Shot's cooldown is about to be up. My new information would imply that doing so isn't worth it as Explosive shot's damage is affected either way and thus it would be better to ensure that it never comes off cooldown.

 

Seoman

In terms of bug vs. feature, you might want to open a GM ticket on this and see what they say.

 

Dch48

This is meaningless as far as dps goes but in the interests of accuracy, the 2 piece gladiator bonus is 50 resilience, not 35.

 

alienangel

As I understand it (not very well mind you), periodic effects that can crit aren't applied as just regular DoTs, but as some sort of periodic damage aura from you - hence each tick of ES is a distinct attack, affected by whatever your current buffs and debuffs are (this is also why you get an aspect of the viper proc each tick of ES, while you don't from normal DoTs like serpent sting).

edit:
e.g.: Serpent Sting - Spell - World of Warcraft
vs.
Explosive Shot - Spell - World of Warcraft

 

Khallas

Can [Elixir of Accuracy] be added to the Battle Elixir list.

 

Bloodleaf

[Gronnstalker's Boots] are missing

 

Fierra

Most BC equipment was removed; check back in the thread.

 

atuin

Just noticed that Race Base Health value for Dwarf and Dranei is wrong - too low by about 3k HP

 

Groznar

Blood Fury must have a typo or something somewhere now, it causes a divide by zero error on the shot rotation tab in this version.

 

Shandara

This will be fixed in the next release. It's not a bug with Blood Fury per se, but if the 'Use Rotation Test results' setting on the Settings tab is set to 'Yes" then it will try to use the value for Blood Fury from there and if you haven't pressed the button there after you've made the change it will have no value yet.

Either disable the 'Use Rotation Test results' setting or hit the 'Test Rotation' button on the Rotation Test tab for now.

WotLK Hunter DPS Spreadsheet

 

Breakerone

Is it possible to add volley to the reference table of shots, so you could see how much dps you would do on a single target with the current buff settings, to make the decision easier at what count of targets to start using volley compared to doing single target dps + maybe multishot?

 

jmlsteele

Elixir of Deadly Strikes isn't working properly on the buffs page. Loads the data for Elixir of Brute Force instead.

Also, Numeric Total for the Strngth Column doesn't appear to take into account food/elixirs (not that this is too big a deal, but for perfections sake )

 

Sylvand

Feature request--

I'm using a fair number of +hit gems with total disregard for socket bonuses. At the same time, there are very nice upgrades available that include +hit. These would allow me to regem for +agility, but this is in no way reflected in the gear planner.

I know it would be a lot of trouble to look through gems/enchants and see what could go from +hit to +agility, but would it be possible to allow the user to enter some maximum value? E.g. if I have precision enchant and a +16 hit gem, I would set the MAX = 36. Then gear with X extra hit would have its dps calculated as if it had min (MAX, X) agility instead.

This idea could probably be developed further, but I think it would be a cool enhancement to the gear planner.

 

Rezdan

Small gear error: [Chestguard of Flagrant Prowess] is actually from Sarth10 +2D/+3D not from Sarth25. Cheers!

 

Enishi

I am not sure if this has been addressed (and sorry if it has), but is there a reason why aimed shot does not change the hunter's dps when chosen as a talent point or is this something that might be wrong on my end?

 

Glodd

Is there a version of the sheet that is fully compatible with OpenOffice.org Calc? I have no access to Excel.

 

Rezdan

You have to include Aimed Shot in your Shot Rotation tab as well to get its full affect on your rotation.

 

Vitaro

It is my experience that the spreadsheet does not check whether you properly specced into Aimed Shot the moment you put it into your rotation.

Edit: As a techy; saying you do not have Access to Excel is funny. Also, you must have missed the BIG FAT BOLD WARNING in the OP not to ask for an OO version.

 

Bechamel

I am using the spreadsheet very often and I love it. Thank You, Shandara, great work.

Most questions got answered by thinking it over and reading the thread. A few left.

In the Gear Planner I got these values for my equipped rings (after pressing CalcAttributes, RangedWeapons and Sort):

Strong-Handed Ring 0 / -4,36
Ring of Invincibility -25,85 / 0

each worse than the other?

In the Overview I got these values for haste (after pressing CalcAttributes):

Haste + 1 0,363 0,363
Haste Cap+1: 0,385 Haste to Cap 79

Haste valued higher after it is capped?
I have 334 haste from gear, that shows as 10.19% Haste in the Charscreen. Together with the 15% Haste from my quiver I have more than 25% Haste. Isn´t it enough to cap my steady shots (75% of 2 sec is 1.5 sec)? Why is there still 79 Haste to cap?

After these questions I have a big wish!
Handling the Spreadsheet is very easy, exept the regemming (as often noted before). I am German and have to translate each time - it´s a pain. Everything would help a lot:
- coloring the names of the gems in the list
- sorting colors
- sorting attributes
- option in the Settings to reduce the gems to show only the best

I hope I did not frustrate You with childish wishes.
Bechamel

 

◊ Lactose

You're doing Haste math wrong.

Steady Shot cast time with 10.19% Haste from gear and 15% quiver Haste:
2/(1.1019*1.15) = 1.58.
With your amount of Haste, Steady Shot still takes longer than the global cooldown to cast (almost 0.1 seconds longer).

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

Mr.Tusks

hello, first off I'd like too say that I've only recently started using the spreadsheet and I'm not sure if my question is moot due too inexperience , but here i go. I had been trying too see what if any Dps increase using Anvil of Titans over Mirror of truth would bring, but at first the listing in the gear tab wasn't applying any stats for the Anvil, so i went into the custom gear tab and entered the stats as best i could,( I had left the min/max dmg slots blank as i wasn't really sure if they were applicable or not). When i had the spread sheet calculate the dps with the anvil in place of the mirror, it showed a 30dps gain. Basically i was wondering if someone could verify this, just too be sure that the gain isn't due too an error on my part. Also, i had the anvil paired with the Fury of the Five flights, if that is of any help.

 

jmlsteele

Mr Tusks: There is indeed a problem with the spreadsheet.

On the Trinkets page Anvil of The Titans should be renamed to Anvil of Titans

So when you modeled it in the custom tab you should be seeing the proper value, making it better for you than the mirror of Truth, assuming you modeled it correctly.

However, on proc effects aren't displayed on the gear page normally, but rather in their own section on the Calculations page.

 

◊ Lactose

EDIT: Seems I hastily misread the tooltips. Read later posts before commenting.


I doubt it was modeled correctly.
[Mirror of Truth] vs [Anvil of Titans].
Both have the same proc, so we can ignore it for easier comparing the items. [Mirror of Truth] has a DPS stat (Critical Strike Rating) while [Anvil of Titans] has a defensive/PvP stat (Resilience Rating).
Given the same proc rate and cooldown on the trinkets, there is no way for 84 Resilience Rating to to yield a higher DPS in the spreadsheet than 84 Critical Strike Rating.

Look, Lactose, we'd rather you didn't eradicate the whole human race.
- Sam & Max

 

Ufthak

I beg to differ, unless the tooltips are wrong, the Mirror requires a crit whereas the anvil requires a hit. That could have implications I guess.