Armor penetration on gear affecting pets also, if you didn't get around to already fixing it!

(e) To clarify when I'm actually seeing it. If I set armor to a nonzero amount, and switch to the pet calculations tab, you can see it in effect at the correct mitigation based on the results tab. If you equip the choker of serrated blades, you'll see the armor value drop on both the results tab, and the pet calculations tab.

Ah, I never thought of chcking that. I guess I'll have to compute pet armor mitigation separately. Easy enough to do. Thanks.

Yep, no problem. I tested it on a blasted lands mob for a couple thousand shots just to make sure, my pet ended up with the exact same average damage, high damage, and one lower for the bottom end. Which makes sense, because the choker drops my attack power a little.

Both Excel and OO versions are available (there are no histories kept for OO)

Change Log:
- Fix Draenei racial to actually be counted as +1% to hit.
- Added new gear (Halaani Razorshaft, Halaani Grimshot).
- Fixed the fact that Madness of the Betrayer was always in effect, even if you didn't have the trinket.
- Updated model of Dragonspine Trophy to include a user-provisionable cooldown. Default is 20 seconds. The model had to completely change to support the internal cooldown, setting it to 0 will not generate the same numbers given previously. Please use version 28 of the spreadsheet to get numbers for 2.1 with the Dragonspine Trophy
- Provided the user the ability to select 2.1 or 2.2 Haste Rating conversion rates. (This will be removed when 2.2 goes live.)
- Corrected some equations that would cause "Divide by 0" errors in certain shot rotations.
- Allow for multiple, user-named gear sets. 5 different sets can be maintained. The last DPS value of that set is stored as well. (This feature not available to Open Office users.)
- Added AutoOnly buttons to the Shot Rotations. This should make it easier to hand-build custom rotations. (This feature not available to Open Office users.)
- On a brilliant suggestion from Lactose, there is now a button (CalcAttributes) on the gear page which will instantaneously give you the DPS advantage of adding one more Agility, AP, crit, or hit. You can also enable this feature to recalculate the values every time you change gear or hand adjustments. Set Loads are exempted from this recalculation because it made loading agonizingly slow. (This feature not available to Open Office users.)
- Added an Attribute Equivalency Matrix to the 'Settings and Results' tab to easily compare item stat values.
- Pets no longer benefit from Hunter's armor penetration stat.
- Corrected some gear stats (Belt of the Black Eagle).
- Adjusted proc rate of Don Santos Famous Hunting Rifle to be 5%. My initial testing has been bettered by more thorough work.

Thank you cheeky

Lactose:
I know you are looking into armor of bosses/mobs, I ripped this from the shaman dps topic:
Credit to Rava

Thank you so much, Cheeky... again.

The [Dragonspine Trophy] is going to make difference, I'm just not sure how much of one. When I do this same test for my gear I get numbers that are exact for AP, and 0.01 off (probably rounding/display error) for Crit and Agility. Also, try re-generating the "+1" numbers after putting the -50 hit, but before adding in the other stats, to give yourself an accurate baseline.

Found something else. It seems when blessing of kings is selected AND rank 2 (67agi) or rank 3 (77agi) GoA is selected the values computed for agility are roughly 2x what they should be. If you set GoA to no and put 67 or 77agi under a custom offhand you get the same result. If you modify the number by 1 up or down the value for agi drops in half again.

e.g. BOK & 77agi custom offhand = 1.06dps per agility. BOK % 78agi = 0.53dps per agility.

I got these results with a 41/20BM build and a 21/40 SV build. I did not get this result with a 5/47/9 MM build. For the BM and SV builds I had 5/5 lethal, 5/5 Eff, 2/2 GFTT, 2/2 rapid, aimed, and 5/5 Mortal. for the MM build I had 5/5 IAotH, the marks tree filled up including 5/5 Imp Arcane, and 9 points in the bottom tier of the surv tree.

I just tried it looking more at the MM talents. I get this 2x result until I put points in combat experience at which point it goes away. I also reset all talents to zero, got the 2X issue, put two points in combat experience and it went away. for whatever reason if I start with a SV or BM build though putting points in CE does not make the issue go away. In all cases having an agi value other than 67 or 77 in combination with BOK does make it go away.

Nice job on the CalcAttributes button! I just use the hand-adjust section, so never thought to make the suggestion.

I would suggest you add int, haste rating, and armor penetration as well, as they also affect dps (that's what I use in my item rating spreadsheet.)

I heard a rumor that the Blizzard developers are using your spreadsheet to analyze hunter dps. Maybe you can check if the computer running the spreadsheet is in the blizzard domain and silently degrade dps by 15%...

Could you provide more information? Specifically:

1 - What application are you using?
2 - Are you talking about the "+1" valuations? Realize they do no automatically re-generate values unless you change gear. Otherwise you have to click the "CalcAttributes" button on the 'Gear' tab.

Testing this with my gear and build, everything looks normal, same with swapping around to a MM build:
Base: Agi +0.74, AP +0.37, Cirt +0.66, +Hit 0.00
Kings: Agi +0.74, AP +0.38, Cirt +0.66, +Hit 0.00
Kings + GoA (2): Agi +0.75, AP +0.38, Cirt +0.66, +Hit 0.00
Kings + GoA (3): Agi +0.75, AP +0.38, Cirt +0.66, +Hit 0.00
GoA(3): Agi +0.74, AP +0.38, Cirt +0.66, +Hit 0.00

If you would like to email me a copy of the spreadsheet with all your values filled in, contact me via pm for an email address.

I compared your +1 Attribute numbers to the ones I calculated myself and all the numbers matched except the number for +1 agility. My +1 agility looks to be about 10% higher, which leads me to believe your version isn't using Blessing of Kings, or is it supposed to be a comparison without buffs?

I wonder if a new thread should be made for raid boss armor values. It seems like we have the info spread across all kinds of different class threads, and it would be nice to have input from people that may have already tested them all. I've seen armor values tossed around in this thread, the other hunter ones, some other class ones... I'm sure everyone could use them for theory crafting purposes.

just a quick question:

when i skill imp hunters mark, do the melees gain all the 440 ap or just the 110 base ap?

Bullshit. I can't imagine they would need my spreadsheet, with all it's assumptions and inaccuracies when they can just check their own models. It would be super-cool if this was true, but I ain't buying it. If you have real sources I would love to hear about it. Just when I thought my ego couldn't get any bigger....

I can add those in. It's pretty easy now to expand it. I just hope there isn't a real fundamental flaw that QuiggyB has uncovered.

I'm planning on doing something like this as soon as I get the chance. I want to test some more boss values before posting anything, since I only have a couple of Karazhan bosses right now.
Yay for forgetting when I have the opportunity.

Just the base 110 AP.

I figured it out, I believe. I use a Floor() function on the final attributes of the 'Gear' tab. This is adding some problems, because with everything you set up the first point of Agility added translates to +2 Agility after Kings and Lightning Reflexes, but the second point of agility translates to +3. It adds a stair-step look to the data that shouldn't be there.

In the next version I will remove the floor() function, but change display settings to not show decimal values, even though I'll carry them through the rest of the equations.

Cool problem to find. Maybe I should change the macro to add +10 of each, and then divide the difference by 10? This would suck for hit rating, but I can do it for the others.

There are going to be times (because of the floor function) where +1 Agility is seen as +2 through multiplicative buffs and times when it is seen as just +1. This is exactly what you were seeing in the version you hosted. Those times it translates into +2 are going to provide double the DPS gain as when it is +1.

The fix is to carry more specific digits of data through all of the calculations. I'm doing that in the beta version and it seems to address the problem, as well as be more accurate overall.

This is exactly what I was doing by hand prior to ver. 29. Seemed to really help smooth out the value of each stat and minimize the times Lightning Reflexes/Master Marksman/Survival Instincts will be at a point that +1 Agility/AP is enough to change a rounding down to a rounding up and report a value that is more inline with a +2 stat increase, instead of just +1.

Makes perfect sense, thanks =) For things like hit where +10 could waste points by going over the cap, would it work to just subtract 10 and compare the smaller value against the current value. It would be the same as saying your last point of the stat got you this much dps instead of saying gaining a point would increase it by this much. I think the actual numbers would be the same. Can also just add dps to the end of the x axis on the attribute matrix rather than having two windows. i.e. an agi is worth x ap, crit, hit, int, armor pen, dps.

Might just be that I've messed up my spreadsheet somehow (using Open Office), but when I try to plug Icon of Unyielding Courage into a Trinket slot my DPS values at the top display as "#VALUE!"

Can someone else test this and see if it is a bug?

It's a bug. Thanks for finding it. When I sober up I'll figure out how to correct it.

Is the Darkmoon card: Crusade (blessings deck) correctly calculated?
I'm thinking about switching from hourglass to crusade but when I switch to crusade in the spreadsheet it looks like it dosen't give anything at all. (Thank you for this great tool Cheeky and Lactose) <3