Thank you Shandara and everyone else for the great spreadsheet. I know I'll grow into all it's intricacies in time! I noted two items I think are missing from the Gear calculator. 1) Borean Armor Kit (not the heavy) is missing from available enchants for hand slot. 2) The Shattred Hand head enchancement (18 Sta, 20 Resilience) is also not listed.
I fully expect that this will take a very low priority, but it'd be great if you added three things that'd be a great asset to us crazy pet tanking hunters: Pet HP, armor, and TPS. Stamina and armor both use fairly straight forward formulas which can be found at Petopia or Bigredrhino.wordpress and I believe that most pets TPS would just be their DPS plus Growl. Gorillas' Thunderstomp generates threat at 2.5 times its damage IIRC, and I know the Screech ability causes a slight amount of AoE threat also.
V80 is taking the proposed nerfs coming in the next patch into account and should definitely result in lower dps numbers than 79a. My dps on a boss is showing a loss of 204 and 140 on Lvl80 mobs. I still think the crit adjustment that was made is excessive, however. I also run the sheet with no buffs applied.
I am specced 53-18-0 with points in careful aim. My shot rotation has always been Serpent,Arcane,Steady,Kill. With the proposed nerf to steady and the fact that I use the steady shot glyph, I think my rotation will be even more suitable after the nerfs. My character's name is Danielfboone and he can be found killing and skinning stuff on the Draka-US Realm.
Shandara, while doing some modelling of the upcoming changes (see here) I have found a weird change between version 79a and version 80.
Using identical gear, racial, talents and buffs, the version 80 spreadsheet produced a decrease of 4.2% crit (which I can understand from the lethal shots thread) and 120 AP, which I cannot explain. Are you calculating AP differently somehow now?
I've noticed the AP decrease as well. Part of it is due to lower crit rates meaning lower proc rates on some stuff (like the Mirror of Truth), but 120 AP is quite a bit.
@Discomonger: Good catch. The IAotH calculations are one of the few 'original' parts from the Cheeky's sheet and they are from way way back. I hadn't really touched them since the math involved is slightly more complicated than my expertise goes.
The only other reason I can imagine why your bow isn't showing up on the Gear Planner is because the v80 has 25-man loot filtered out currently (just tick the box on the Gear Planner and resort).
Thanks for maintaining this spreadsheet, Shandara. Great work, and glad to see this incredible resource continue in this expansion.
I use a Mac as well and as noted earlier, the macros are pretty much disabled in our Office version (thanks Microsoft), so there is no means of interacting with buttons or checkboxes. This wasn't an issue before but is becoming an issue now that we are doing 25man raids, I am unable to click on the 25-man loon checkboxes so that the 25man loot are no longer filtered out, and access the 25man loot.
Would it be too much trouble to leave on all the loot boxes as default?
A weird thing i just noticed while checking belts.
Default 80 raid buffs with all my regular gear and no belt equiped the gear planner says:
Vereesa's Silver Chain Belt: 132.05
Sovereign's Belt: 119.95
When i equip those items and add a belt buckle i get this dps:
Vereesa's Silver Chain Belt: 4588.18
Sovereign's Belt: 4590.55
Sovereign's Belt is lower in gear planner but gives a higher DPS. Am i using the gear planner wrong? This is after calculating atrributes.
I believe the gear-planner undervalues hit because it does not count hit past the hunter's own hit cap. In point of fact, hit rating on gear may still contribute to pet hit, even if it does not contribute to hunter hit. I actually found that 1 hit rating gave as much dps as 1 crit rating after maxing my personal hit due to the positive effect on my un-capped pet. This bug primarily relates to BM hunters with the focused aim talent.
All of this, of course, is from my non-visual-basic-savvy point of view, but I believe that's what's happening.
Edit: An alternative or addative cause may be the arpen on Vereesa's belt. I've noticed the gear planner and the spreadsheet proper do not always agree on the value of Arpen, even after calc attributes; the gear planner things the Incisor Fragment, for example, is a top-tier trinket, but plugging it into the spreadsheet proper yields significantly lower results. So in addition to hit rating as a possible culprit, Arpen may be the issue.
Last edited by Zeuxis : 12/12/08 at 1:58 PM.
Reason: Added information