More correct would be to say the sheet can not model it correctly at this time. The value of ArP proc trinkets depends heavily on a few things:
- If you would not exceed the cap (the cap is modelled in the sheet so you can never exceed 100% ArP rating-derived reduction) with the proc the sheet is fairly correct since none of the ArP is ever wasted. The amount of ArP is averaged out, which isn't ideal but not entirely wrong either.
- If you would exceed the cap the sheet is wrong because it averages out the ArP effect while the shots that are affected by the proc do not use all of it. The only way to properly model this situation is to completely simulate the hunter's shot sequence and see which shots are and which aren't affected. (or do it manually by comparing dps with and without the proc and computing your average dps out of that).

I´ll update the OP with a new version if someone does the work to compile all the information posted since the last update (on page 18) in a new spreadsheet and uploads it. I´m not going to maintain another spreadsheet myself, sorry.

So I decided to see what the best dps looks like using the MM spec with armor pen gems, but not Mjolnir. I achieved 8493 dps, then added Mjolnir over Greatness and achieved 8578.33. I've ran the CalcAtributes and Ranged Weapons twice and made sure setting were selected yes for default, so this is pretty much iron clad. My main issues are the extra 12 hit rating I can't seam to get rid of, regemming a little bring it to 1.04% over cap leaving me with a useless floating talent point and 8544 dps. I'm still seeing if there is anything else I can tweak before I post a full listing, but here are the stats:

Hunter DPS 7512.85
Pet Dps 1065.48
Total DPS 8578.33
Ranged Critical Hit Chance vs. Level 83 54.02%
Ranged Hit Chance vs. Level 83 100.37%

Buffed total ArP is 871.

Attribute DPS
Agility + 1 1.660
AP + 1 0.712
Crit + 1 1.356
Hunter Hit + 1 1.938
Pet Hit + 1 0.284
Int + 1 0.804
ArP Rating+1 2.040
Haste + 1 0.954

I wonder if there is a way to include [Schematic: Biznicks 247x128 Accurascope] into the dps sheet and end up with as much or more overall dps.

Because hit gems and crit gems both give a value of 16, switching the 40 crit scope with a 30 hit scope is less efficient.

I think the idea is that we don't to gem for hit OR crit if we can help it, because it should all be agi/ArP. So it would be the benefit of 40 crit vs the benefit of 32 agi (Biznik's vs 2 hit gems). Once Epic gems come out, Bizink's will be even better, provided you only need 30 hit to cap. I've had situations in the past where Biznik's was the best scope for me, but I doubt you'd run into a situation like that anymore, now that Focused Aim counts for your pet.

The current best MM dps spec uses 3 points in focused aim. Talent Calculator - World of Warcraft

Yes those 3 points in Focused aim should be in Imporved arcane shot.

Please research the context before making claims like this. The current highest DPS MM setup with that talent spec uses gear lacking in hit rating and uses Focused Aim to make up for it. Yes, it is higher DPS than using gear with more hit rating. Arcane Shot is NOT USED in said setup's shot rotation.

Best MM DPS setup is based on ArP, that doesn't works with spelldmg = Arcane Shot, so Arcane Shot is useless with ArP.



Maybe is a stupid question but I didn't understand if I have to stack 550-650ArP (with GT or MR) then stacking AGI or go ahead with ArP

This has been stated on previous pages. You only need enough ArP to allow the trinket to bring you to the cap that recently went live. Stacking ArP any further should result in a dps loss since the trinket proc will not be used fully, thus devaluing the trinket. Stacking Agil gear after you hit the soft cap should result in a dps gain. Be mindful that not reaching the the very small window surrounding the soft cap is also a dps loss vs agil. Again please refer to previous posts for more specific numbers.

I dno´t think there´s a bug with the spreadsheet. Did you run a recalc on the ranged weapons?

It won't be a dps loss. It just won't be as nice as before the cap, but it will still be better than Agi for quite a while because the trinket doesn't have a 100% uptime.

Is this a valid statment? There are too many conflicting posts about ArP.

Logically it is, as even past the point where a trinket proc will not be as effective, you are still shooting when you dont have said proc active thus your dps outside of the procs will be higher and ina closer proximity to the dps when you have an active proc.

I can confirm one changed build ( without IHM and IAS ) rebuild it to the builds like few post before, changed glyph KS into Hawk, deleted Arcane shot from rotation and I gain dps boost. But when I'm trying to replace my agi gems into ArP gems I'm loosing my dps.

Downloaded that arp_dps.xls file from few pages before, uploaded my gear, changed gems into ArP still that same - I'm loosing dps on every ArP gem. have you any suggestions why ?


it looks that:

1 set ( no arp gems , agi gems ) got 7894 dps with 281 ArP
2 set ( arp gems ) got 7871 dps with 552 ArP

rotation + talents + glyphs are the same
P.S
sorry for my english

I think there is a little confusion here (at least there is in my mind) because while stacking ArP can never be a "dps loss" there are regions in which stacking agility is more effective from what I can tell, I've quoted the two relevant posts below to clarify:

From what I understand (and please correct me if I'm wrong because there is a ton of information to sift through on ArP) Argg0's statement could refer to two instances of the phrase "dps loss" from Beachwanderer's post (I've bolded both instances).

Each refers to a different set of circumstances - the first is stacking ArP beyond the soft cap (567 with Runestone). In this sense, continuing to stack ArP was found to be not as effective as stacking agility as shown by Cranch's table. So while continuing to stack ArP won't be a dps "loss" persay, it will be less dps than if you gemmed for agility after this point.

In the second case, Beachwanderer is referring to not actually being able to even hit the small window surrounding the soft cap. If you can't gem/flask/food your ArP to hit that window (I'm refraining from giving an actual number since I'm not 100% sure what it is) then again dps will still go up if you stack ArP but not as much as stacking agility would contribute. As a simple example, again referring to Cranch's table - in the 0-300 ArP range, agility still offers more dps/point that ArP does.

deleted

I didn't really understand how he calculated the value of 1 ArP with the proc, but...

The meanDPS remains higher than the +100 Agi DPS until 800 ArP.

My answer was based on that... maybe I'm not interpreting well the data. If I'm wrong, I'm sorry.

While the table isn't 100% correct (since 700 ArP was used for the proc), it still gives a pretty good idea.

The +100 agil number doesn't take into account the proc at all, the +100 agil was simply how he calculated the dps/point of agil. Comparing the +100 agil column and the MeanDPS column doesn't really provide all that much information. What that is comparing is the DPS you would have by adding 100 agility to your current setup, opposed to adding the ArP proc to your current setup.

If there was an additional column calculating "+100agil MeanDPS", it would then be appropriate to compare that column to the "MeanDPS" of the row below. Therefore you'd be able to see what is of more advantage to gain - 100 agil? or 100ArP? while still maintaining the proc trinket.

Armor pen gives pretty much the same +DPS% regardless of target armor as long as its over 8317 as per wowwiki.
Also I'm pretty sure the 100% cap is unaffected by sunders/whatnot since those effects actually reduce target armor whereas armor pen only ignores it (e.g. if you were the boss and you looked at your character pane you would only see armor reduction from sunders). I am not sure how it stacks with armor ignore talents like serrated blades/mace spec but it doesn't apply to hunters anyway.

I might have misunderstood you, but isn't that what the pawn string in overview is for?

So I was looking at the DPS per point of ArP on the SS and i noticed that my dps simply stopped increasing at 1103 ArP. It took me awhile to figure out why this was happening because even with Mjolnir's Runestone your dps should increase with more ArP up to 1232 because 80% of the time you do not have the runestones buff. What I found the spreadsheet to do with Mjolnir's Runestone is to simply add the average amount of ArP gained to your current ArP.

655*0.1978 = 129 - approximate bonus due to proc
1232-129 = 1103 - cap the spreadsheet uses

This shows that the spreadsheet simply adds 129 ArP to your current value to deal with the proc. This doesn't account for the ArP cap and skews the dps to favor Mjolnir's Runestone even though it becomes worse than the Greatness Card as you get more ArP.

--Edit - Looked up the actual proc for Mjolnir's Runestone and found it to be 655--