It seems that the 10% AP bonus from Trueshot Aura or Unl. Rage / Abo. Might no longer works.
It still says 10% in the respective buff rows, however the value in the multiplicative total row remains 0%.
Disabling the Buff also has no influence on my dps.

In the pet buffs, it correctly says 10% in the multiplicative buffs row, disabling the buff however does not influence pet dps either.

Sorry if this has been reported before and i missed it.

If you are MM spec (which I suspect you are testing in the sheet) then the values of both TSA and Abomination's Might/Unleashed Rage are not used on the buff tab. Instead the 10% AP bonus is done separately on the calculations tab.

Bug: "Improved Aspect of the Hawk" doesnt change the dps, is it normal?

It worked for me, did you hit "Test Rotation" afterwards?

http://static.mmo-champion.com/mmoc/...ndlessgaze.jpg

New relevant hardmode loot, more hit for us - awesome! It seems slightly weird, at only 70 Agi and 112 Attack Power. Compare that to the 82 Agi and 196 Attack Power of the tier headpiece. Usually there seems to be some balance between those two stats, an item with high AP will have low Agi and vice versa. This one seems to have both subpar Agi and AP compared to an item of lower ilvl. Somehow the item seems underbudget, anyone with knowledge of ilvl calculations that can investigate?

I've tried to fit it into the current spreadsheet, dropping gear so the 4T8 bonus does not play in and making sure I can use the hit. It only comes out as a 20 DPS upgrade compared to the T8 headpiece. Remember that it is using the full hit on the headpiece. Hit is a powerful stat and any item that has the full use of +2% hit should rank significantly higher. There's gotta be something wrong with this item. Comparing it to Circlet of True Sight, an item with almost identical stat distribution, makes it even more impossible to believe that this item is properly itemized.

The Circlet of True Sight is ilvl 219 and Boundless Gaze is 239, a 20 ilvl difference and not 13. Also comparing Boundless Gaze statpoint wise, which given that we just have the stat modifiers correct is not a precise but still decent comparison tool. Boundless Gaze comes out with 3.666~ statpoints more than the T8.25 helmet. Circlet of True Sight comes out at 24.666~ statpoints less than the T8.25 helmet. 24.666~ statpoints for 7 item levels and 3.666~ statpoints for 13 item levels, something is wrong. At least I hope this is so, because right now the helmet is utterly useless.

Well, not sure if this is the right place to discuss stat distribution on items here, but still:

Circlet of True Sight compared to Boundless Gaze (Boundless Gaze as base):
1056 Armor (-44)
+70 Agility (0)
+95 Stamina (-5)
+54 Intellect (-14)
Meta Socket, Blue Socket (+8 crit, -8 agi socketbonus)
Improves hit rating by 60 (-6)
Improves critical strike rating by 42 (-27)
Increases attack power by 156. (+44)

Now, considdering the equation part of Item level mechanics (Item Level Mechanics) you get a total of:
2/3 * 5 + 14 + (-8+8 = 0) + 6 + 27 - 44*1/2 = 50 1/3 - 22 = 28 1/3 more stat points for a 13 ilevel upgrade, which seems pretty decent. The fact that hunters would prefer another stat distribution is irrelevant to item level.

(edit: if compared to the 213 T7 helm, the circlet has: -14 + 16*2/3 + 7 (-8+8=0) + 7 + 5 + 22*1/2 = 26 2/3 stat points more, so the amount of stat points increased seems just fine for boundless gaze)

Not really a bug per se, but more a bit illogical in what it does. It basically assumes that if you check the buff for Hunter's Mark (other), that you don't cast it yourself.

I'll change it to use the better of the two instead.

RE: Armor Penetration procs and dps (in response to discussions in other threads as well).
Basically to properly value trinkets/abilities that have Armor Penetration as an effect you'd need to simulate each shot separately for them and see how much damage you gain. The sheet isn't really a full-blown simulation like that (although it does have some of it) and it would involve some radical changes to make it work.

Also it would make it nearly useless for the Gear Planner, since any simulation involves randomness which makes determining fixed stat values quite hard. Unless you'd have a great deal of iterations and eventually averaged out the values (like simulationcraft does).

Excel isn't really a suitable platform for that, because it's very SLOW.

I knew the ArP proc would be messy to calc appropriately. People just need to keep that in mind when plugging stuff into the spreadsheet.

@ Shandara
I'm noticing some anomalies playing with the MM Armor Pen list that was reported int he best dps thread. Some setups are wildly changing my Attribute DPS and Per Item Budget values from negative numbers to values over 6 when I hit the CalcAttributes button. Previously normal values were around 0 to 2ish. Was there some error in the way armor pen is being used?

I am a bit confused. I am hit capped with a rating of 269. On the sheet it is telling me "Needed to cap hit" -39 "Pet" -32. Would it have anything to do with Heroic Pesence?

Yes. It accounts for the 1% gained from the Draenei Aura.

That's pretty much a simpler explanation of what I proposed. The problem is that the way the spreadsheet is currently structured prevents this from happening. If i understand correctly, Total DPS is derived from each individual shot's contribution, which is calculated from the various stats. The above method would require the spreadsheet to maintain two calculations per shot in order do it correctly, which would be a lot of work to implement/debug. Like Shandara said, a proc like this is best suited for a full simulation, which this is not.

Blizzard is aware of it:

World of Warcraft - English (NA) Forums -> Something must be wrong here...

Since we are on the topic of new loots,

http://static.mmo-champion.com/mmoc/...10_9901_12.jpg
http://static.mmo-champion.com/mmoc/..._10_9901_7.jpg

Are both on live and should be included in the next spreadsheet.

Some folks are working on a new Hunter module for the Rawr app.

According to this thread: Rawr - Discussions

I noticed some different things going on with how they were dealing with hit vs. higher level mobs.

I posted this on the Rawr forums:

I got this response to my post:

The Improved Steady Shot talent seems to be broken. Load the Sample MM Spec 7/57/7 and change the talent points to 1,2, or 3; there is no dps change.

*edit* it's working in 89a, by the way.

It needs to be rare enough that running through 4000 arrows per night and not seeing a miss is common occurence. In the event hunters were still capable of missing, I would think the effect it would have on DPS numbers would be highly insignificant.

But i just think he's plain wrong. Hit cap is 8%, and there's thousands of hunters who can provide proof of this.

Not just hunters either, the other physical classes have accepted 8% as the cap for months with no recent reports of it being incorrect.

Could whoever found that quote from the RAWR people find the test results they base their conclusion on?

ok... i need help

My Gear at the moment:
The World of Warcraft Armory

Buffs, Pet all the standart things in the spreadsheet.

And the Gear Planner tells me, that T7,5 is BiS for my Equipment ... and i don´t know why.
Because i think, that Gloves of the fiery Behemoth should be much better.

Or do i oversee something?

Possibly the 2 piece bonus?

I have been running at 263 hit for a while now. I can't find a single parse that has a miss in it other than some absorbed shots on IC and Thorim (due to shields) and an occasional miss on Archavon due to the cloud hit debuff.

If you are referring to the Rawr discussion, the developers in that forum have recanted. They were using outdated theory-crafting and have switched to 8% hit as the baseline needed for bosses.