For me, changing the "Use Kill Shot" option has no effect on DPS, and on the Shot Rotation tab, Usage of Kill Shot box, everything in that box is 0. I have "Boss Fight Length" at 8, "Time spent sub 20%" at 2, and "Use Kill Shot" at "Sub-20%". If there is something else I need to change, it's unclear.
It's not a very big deal because 1 or 2 kill shots is not going to make a signficant difference to PvE dps no matter how much damage they do.
Here's what the Shot Rotation area has:
Usage of Kill Shot
Current Kill Shot frequency 0.00
Possible Kill Shot frequency 0.00
Current Steady Shot Frequency 1.80
New Steady Frequency 0.00
Old Kill Shot DPS 0.00
New Kill Shot DPS 0.00
Old Steady DPS 1400.74
New Steady DPS 0.00
% of time spent sub-20% 25.00%
DPS gained using Kill Shot 0.00
I don't know much about spreadsheets but is it possible to import gear info from one sheet to another or do you always have to manually change the sheet to your gear when downloading the next version? I've tried the Export to File and Import to File but they don't seem to do anything at all for me. Thank you for all the hard work on the sheet.
Hood of the Furtive Assassin
Helm of the Avenging Protector
I'd check more, but I think the items need a good once over again.
Surefooted: Reduces the duration of movement impairing effects by 30%. As such should be highlighted to red. Purely cosmetic, but want to ensure that the talent isn't using its old information. (+hit).
I'll be looking it over further today at work. I do a lot of excel stuff, and I always love to help this document as much as I can as it has helped me significantly.
As an aside I'd really love to make a proposal to finalize items in this spreadsheet. I'm in favour of grandfathering old TBC items and only including WOTLK items. With this I'd love to see more definition between what we currently have. As it stands we don't really have a good outline of the items. My proposal is to have the following for item designations/filtering (for the gear planner).
Does it matter where it comes from? An upgrade is an upgrade is an upgrade. We can check Wowhead for the why's and wherefor's. I personally like the selection we have now.
It does matter. The reason is for preplanning. Even though I'll be the level 80 raider in the end game instance I'll just tick everything off. For the alts and people that are new to this I think we should be a lot more caring.
Sure they can use Lootrank.com or something, but why can't this item be the one stop shop for everything hunter related. I think we can work towards being a lot more inclusive than exclusive. We'll get a whole hell of a lot more people here if we do and more good comes from that then bad.
Yea, I get the preplanning. I do that. I look for potential upgrades, find out where they drop, and compare them to the list i currently have. I plan and plot my gear as much as i can. I just didn't see the need for 17 different option on/off toggles. Either way is fine I'd think.
I was missing around with haste in the latest version, and the Haste to Cap cell seems to be reporting lower. It seems to indicate that 401 haste is needed to be haste capped instead of the 523 for an MM build. This is the value that came out repeatably for me after hitting Calc Attributes and with adding the current haste rating from gear with this value. This was done with no haste buffs.
Is this an error? Or am I misunderstanding how that field works?
Thanks for all the hard work on this great spreadsheet!