mmo-champion.com had news today that darkmoon card: death was having its trinket changed from haste to crit at patch.

3.0.8 Changes, Blue posts, Dark Legacy

assuming the number stays the same, it would now be

Equip: Improves crit rating by 85
Equip: Each time you deal damage, you have a chance to do an additional 744 to 956 Shadow damage.

I would be interested to see how this fared now. I didn't see it or the older version on the spreadsheet.

Thanks for all the great work!

I actually have this same bug, though. I get 2 mirrors of truth listed on import.

Ketari: Like in my case, your armory does not show the trinket; hence the spreadsheet not being able to import it (assuming the background XML feed misses it too). We both have Mirror of Truth listed as a first trinket and the sheet probably does not "clear out" this value in case it encounters null for the second slot; hence two MoTs showing up.

This problem seems to be limited to EU armory profiles: All EU players that I know to have the trinket have an empty trinket slot in theirs. The US Armory does seem to list the trinket properly, hence people telling you that it works.

Thanks, I actually already read that thread before asking, but since it was focussed on FA, I thought it would not be relevant. In any case, I read up on the previous thread, which elaborated a bit more on the unclear loss of about 4-5% in crit, but actually I could not find a really hard number in any of the threads, because all of them had different results and it was yet unclear if any of the talents have anything to do with it. But lets say the common consens hovers about the 4.8% (while the spreadsheet shows me 4.2%), I was under the impression that all of the tests have only been done with autoshot and not the specials, but the spreadsheet lowers the overall crit by x%.
Did I miss where it was stated as a fact that the loss also applies to yellow damage?

In case I did miss it, to add something valuable I wanted to remind on the part of my first post, saying that the dps breakdown of hunter and pet does not lead to the total in the overview, as can be seen in the screen I linked.

ImageShack - Image Hosting :: ptryz8.jpg

@Fierra & Sean - so the answer is, I'm NOT seeing things, Tracking IS better? The point about specials is key - thanks Fierra.

@ankah - Manually adjusting up to 50% Crit, 5/5 IT & 2/5 MS still beats out 5/5 MS and 2/5 IT on the spreadsheet (albeit narrowly). I think Fierra's point about specials is the answer.

As far as I can tell, serpent sting is subject to partial resists. This should be implemented in the spreadsheet (I think the assumed resist rate is roughly 2% per level?).

Wow Web Stats

Somewhat of a side note, I'd love to see more testing on those shots of ours that deal magic damage. The WWS I just posted is hardly a large sample, but I am not seeing any full resists for serpent sting with 265 hit and a draenei + misery in some situations - so I would still see 3% miss if it needed spell hit cap. I'm just wondering if explosive shot should be reexamined for the spreadsheet, for the chance that it is still subject to partial resists but is "hit" capped at the physical hit cap (8%). Currently the spreadsheet has it using magic cap (17%) and partial resists.

When you export a profile that has an [Arcanum of Ferocity] applied and then import it into another spreadsheet, it imports as 'Glyph of Ferocity' and breaks.

The spreadsheet is the most accurate model I've seen for gear selection.

The only caveat I would put on using the spreadsheet is to actually equip the items in the gear tab to see their effect and not just mindlessly believe the gear planner sheet. On a number of occasions, items that showed as DPS gains in the planner tab were dps losses when equipped, usually because I dropped under the hit cap or something similar.

In addition to what Iru said above, also be sure to load your current gear, spec and set your buffs/shot rotation, and then click the re-calc button.

Don't just download the spreadsheet and expect it to be accurate for you.

All these things can make a MASSIVE difference to if gear is an upgrade or not.

There are several slots with undisputed best in slot items. There are also a couple slots with 2-3 items very close at the top and the best depends on your other gear (primarily your hit rating). However just knowing what items are best in slot doesn't mean you have them, and it doesn't mean those are the items that will drop.

Among the functions of spreadsheet, there are two in particular I would emphasize:

1. Allows you to figure out (within the accuracy of the model) what is the best gear/gem/talent combination among the gear that is in your possession. There isn't a magic button for this but you can try out different things. For example, if you think you have an upgrade but there's no hit on it, does it make sense to equip? Can you mitigate the dps loss by changing talents, gems, enchants, etc.?
2. Allows you to see the relative value of immediate single slot upgrades. Because a lot of DKP systems only work well when you know how much something is worth to you, it's very nice to have something that can answer that question. Not only do you have the list ready, but if you get one upgrade you can update all your lists immediately to help you bid on the next drop.

The main variables I account for are pet dps time and boss buffs/debuffs. The spreadsheet assumes you and the pet both have 100% dps time. However there are times where this is just not the case, e.g. Heigan, Malygos, Sapphiron, etc. Also fights like Loatheb and Thaddius increase your dps while they don't do the same for your pet. For these and other reasons I don't always hold hunter dps and pet dps in a 1:1 tradeoff. Along similar lines you can hold the fight length as another variable, especially if you're trying for some particular goal (3 min patchwerk is a prime example).

I have a question raised by the spreadsheet. Others have mentioned it earlier in the thread, but they didn't get resolution and I'm encountering it as well. As such, I'm wondering if it's either a bug in the spreadsheet, or something I'm not understanding about the Hunter class. Either result is positive to me!

In the latest version of the spreadsheet:

• I'm hit capped. Actually, over the (8%) hit cap due to some good drops in tonight's session.
• I do not have any points in the Focused Aim talent.
• I have a Cat pet setup, running Rake and Claw. No pet "magic" attacks, which may or may not have a different (higher) hit cap. (As an aside, it's my understanding that no concern should be given to the spell hit cap; it's just not smart itemization?)

However, in the spreadsheet Overview tab, Hit is still being rated as being worth 0.250 per point / per item budget. Pet Hit is still being rated as worth 0.135 per point / per item budget.

Manually adjusting Hit in the Gear tab doesn't affect the DPS calculated by the spreadsheet.

Bug? Or something I'm missing with regard to DPS generation?

The +Hit rating value shown on the Overview tab is calculated as if you had 0 hit (actually it is an average of the value of hit from 0 hit to hit-cap). Even if you are hit-cap we need this value to determine the worth of +hit on the gear planner if you swap in an item with no hit for an item with a lot of hit currently equipped and you would drop below the hit-cap then.

Best-In-Slot gear will vary very widely depending on what individual pieces of gear that you have; simply use the spreadsheet, it updates what it believes to be your best gear based on what it sees for your spec, hit, crit etc. There is no hard and fast rule for best spec gear right now; it depends on what you already have.

I tried to use the rotation test numbers for shot frequency (to get some different numbers for explosive shot frequency) but it seems like the dps calculation for the shots on the shot rotation tab still uses the normal frequency (although the rotation test frequency is displayed in the same table).

The normal frequency calculation for Serpent Sting does not include the changes to the glyph.

I don't know if you spotted this one yet.

On version 81e, Overview sheet, Pet DPS Breakdown table:

I get con a cat:

Melee DPS: 1128.73
Special DPS 807.28
KC DPS: 22.84
Claw DPS: 653.44
Total Pet DPS: 2612.29

While in other part of the spreadsheet Pet DPS is 1958.85 (The Sum of the first 3 lines only).

I guess that on the Pet DPS Breakdown, Claw is included in Melee DPS and then you are adding it twice.

Hi haven't checked this in a while, having a glance at the sheet now few issues (not sure if they've been mentioned or I've got the wrong idea)

- Explosive Shot additional damage was posted by a blue as being 428 now, not 462.
- Curious as to how the spreadsheet handles IAOTH lowering the SS cast time. Seems it doesn't factor this in atm. (maybe I overlooked a averaging option)
- The darkmoon card greatness procs aren't being scaled with LR and Kings I noticed, is this confirmed by anyone yet?

Explosive Shot: I don't think the new damage range (428 and 462 are both averages) for Explosive Shot's base damage has been posted yet.

Regarding IAotH and SS cast time. I suspect this might have something to do with when Shandara made the following change "When determining the value of +haste the CalcAttributes button will now discount the effects of dynamic haste procs (rapid fire, item procs, heroism) to determine the cap"

DC:G procs also don't scale with Combat Experience.

Undocumented changes on MMO.

The skinning bonus for Master of Anatomy ranks 5 and 6 are 20 and 32 crit rating respectively on PTR

The crit chance used in the " Go for the Throat" calculation should be the CompositeShotCritRate not Base Crit Chance.

Thanks for your DPS Sheet!

I am playing in Kokr Server.

But your DPS Sheet don't include Armory in Kokr server.

Can you include Armory in Kokr server?

My inclination is that this is not the case, but I'm curious - does the gear planner consider enchants at all when calculating comparisons between 1h and 2h weapons? The planner indicates that some 2h weapons are significantly better than the 1h combo I have equipped, and I can only assume it's not taking accuracy enchants into account.

It is not considering enchants yet.