I really can't see how any hunter could do without this sheet, it really is just absolutely amazing

One thing though (sorry it might have been covered but I have not read all 95 pages of thread) why are we not getting the +3% Crit from Meta Gem "Relentless Earthsiege Diamond"

I also seem to be loosing crit somewhere else as in game my crit is 28.32% with no buffs and on the sheet it only shows 23.52% Crit

EDIT: The sheet also shows that I have 16 gems socketed where in actual fact I only have 13

If I have understood you correctly you are asking why you don't get 3% crit from the meta, right? Well, that's how the meta is. It doesn't give you crit (aside from what the Agi gives), what it does provide you with is 3% critdamage. Think of it like Mortal Shots (only it isn't exactly like that, though it along those lines).

The number of gems mentioned can be misleading. But this is only because it tracks the three colours individually, so purple, orange and green all count as two colours each. And a prismatic counts as three. That is why the count seems higher.

On the gear planner. Am i reading it right? the higher the delta the better the gear? I am seeing Lotrafen at 226.49 and my 2 1-handers at a total delta of 265.23, leading me to believe that they are superior to the polearm.

The delta is the difference in DPS. A positive delta means its a DPS gain and a negative means its a DPS loss. They are not the specific DPS value of the item.

Sorry looked again and noticed its 3% Crit Damage :s I have always read it as 3% Crit.

I am still loosing crit somewhere then as in game I have 28.32% and on the sheet I have 23.53%

The gem count is more a color count, it shows how much gems match either Red, Yellow or Blue. So multi-color gems will add to both colors.

You're not losing crit, but there's a few factors involved:
a) Your in-game crit displayed is versus a level 80 mob, versus a level 83 you will suffer some. Testing revealed a crit depression of roughly 4.2%.
b) The displayed crit % in the sheet includes procs from talents and gear (i.e. Master Tactician).
c) It also includes buffs on the target

After adding/subtracting all this the sheet ends up at 23.52% _effective_ crit rate.

I was thinking about how to design the UI so that it would be easier to make decisions around hit cap. The way the gear planner works currently, (assuming you are capped), it will nearly always recommend a new piece with hit for any slot that has hit in it already, and discourage a new piece with hit for any slot without hit in it already (because it simply looks at the DPS delta of subtracting the value of the stats on the current item and adding the stats of the new item). This makes it more difficult to make decisions that involve swapping more than one piece in order to stay hitcapped, or evaluate which of several hit-containing items is better in situations where you know you can maintain hit capped regardless with various banked items or gems.

"Assume 100% hit" is useful, and as was just suggested, "Assume 0% hit" could also be useful, but maybe we're thinking about the problem wrong. It doesn't matter where we get the hit from -- in some sense the dps value of hit on an item is interchangeable between items: 10 hit rating on your helm is the same DPS as 10 hit rating on your legs.

It seems like, in the gear planner, a breakdown could make this clearer: have two DPS numbers for each item. One number is how much DPS the item represents excluding the effect of hit, and the second number is just the amount of DPS that the hit on the item represents by itself (I suppose you might also want a third number which is just the total that we see today). So in a slot where you have a hit piece equipped, you can see at a glance that (e.g.) 20 of its DPS value is from the hit on it, and that other option that's 5 slots down in the list is actually much more DPS (if you can get hit capped elsewhere). I think it would still make sense to sort by the total DPS delta, just as it is today, as that's still an accurate representation of what would happen if you made that exact swap and only that swap.

I'm working on the Rawr.Hunter update and am in need of the base stats for each race at level 80. There is some debate on the variance in base health values used on this sheet. If someone could point me to the source for these values or how they were arrived at that would be greatly appreciated.

It's rather simple. It is the bane of BM being so petcentric and not having enough stats that gets transfered to the pet.
Agility is a better scaling stat, however it doesn't beat AP initially due to the amount of damage the pet does in relation to the Hunter.

A newly raiding BM will gain a lot more from AP than Agility because his pet does the amount of damage it does. But he gains new and better gear the pet will slowly lose relative DPS compared to the Hunter. And then at some point it becomes more worthwhile to boost hte Hunter's damage than the pet's.

nm.

Hi. Sorry if this has been mentioned before:-

- Custom gear import from Armory for Ranged Weapon speed seems incorrect, e.g. 2.80 becomes 0.28. It doesn't update the weapon type either, but that doesn't seem to affect anything.
- Custom ranged weapon in the Gear Planner shows as 0 dps when equipped.

Thank you for pointing this out. I have noticed the same thing also but was reluctant to post about it until I found a solution. What I have been doing lately is taking the calculated attributes values and using them as weights in wowhead. It works quite nicely but it would be great if it could be done directly in the spreadsheet itself.

Brilliant spreadsheet. Keep up the excellent work.

@Shilyunie: It currently applies the bonus to both the main CS damage and the -serpent part. I'm following the discussion and will probably have to make adjustments soon (unless a blizzard dev comes out and tells us it's a bug).

@Myuu:
Run the "ranged weapons" macro button on the Gear Planner after putting in the stats for the custom weapon. The linked dps values on the gear planner for ranged weapons are static and dynamically computed like other slots.
As for the gear import from the Armory, I suspect it is some sort of localisation problem. What locale of Excel are you using?

While that might be the case but i do not touch my gear to get so diffrent results it chancges compared if I am hit capped or not. Basicly if i am missing 1 PT in hit cap the values are; Agility + 1 1,030 1,030
AP + 1 0,625 1,250
Over 1 dps per 1 aggi or 2 AP but when i get hit capped the vaues of aggi and ap fall down a lot to:
Agility + 1 0,791 0,791
AP + 1 0,384 0,767


Wich tells me that I gain a lot less from AP and Aggi before i am Hitcaped. I belive that is not the case and I wonder if that might be a bug.

My armory: The World of Warcraft Armory


Not a native speaker so sorry for misstypes

Your armoury shows that you have just over 6.80% Hit (223 hit rating). This means that not only are you loosing a significant amount of DPS from lack of hit, your pet only has 6% hit rating (a 2% hit loss for your pet).

However, using +40 Hit food should bring you and your pt up to the hit cap (263).

Yes i am using Hit food but still havent gotten a response whay do, when I use hit food or get hit capped by other means the value of AP and Aggi point per point fall down so much. Is that supposed to happen or is it a bug.

Not sure why you say that, it is in the calculations section of arcane shot, and you can easily check it by adding the talent points and watching the arcane shot damage change. Make sure you are actually using arcane shot in your rotation.

You're correct. Somehow my macro security level got changed and it wasn't updating correctly in the calculations tab when updating the rotation.

My bad, thanks for the help!

Calculations!N21 has a check that effective armor is greater than 0, otherwise it just does a 0% armor mitigation. Current discussion suggests this isn't true; you can get a target to negative armor and have it act as a multiplier, meaning you do more damage than an unmitigated attack.

Not to speak for anyone, but I believe Shandara stated that he/she was watching the discussion closely and would make the change when/if it was decided for sure, or if a blue comes out and says something specific about it. It will be interesting to see if that's the case, since our gear in Ulduar has so much ArP on it.

They were mostly from in-game testing, values by myself and reports from others. They are in serious need of being re-checked, especially the lower levels.

Shandara already updated the mechanics to those expressed there, it just still has this 0 armor limit.