Originally Posted by Sapa
Cheeky,
I downloaded your spreadsheet, great work, but i have some comments and questions.
It seems I'm missing Imp.HM in pet data.
Thing is I'm BM but leeching HM from MM hunter.
Maybe you could make extra tab: Target
* level - already done
* mob/boss - already done
* armor - already done
* debuffs (Imp.HM, CoS(arcane), Arms warrior 4% debuff, gift of arthas  , Hemo,...) - the hard work... but would imho be interesting insight on hunter synergy. I'm specially interested in question, what if target has dazed effect all the time (blade twisting, shield bash, concossive barrage...).
Tab: Equip compare
I know i can always change things in gear tab and compare. But socketing 3slot items 10x in row can be fun 
Something like:
Item1 vs Item2
*agi
*ap
*hit
*crit
[top] Erap or dps, or change VS current gear.
I don't remember or i didn't saw. Agi
Crit = AP conversions with final gear/talents/rotation.
(something i find extremely useful in Lactoses sheet, that provides Item1 vs Item2 with next to 0 tinkering)
How do you model TBW in? I always fire TBW up with Rapid Fire / Trinkets(abacus/kiss) / Troll Zerking or Bloodlust. It results in more shots fired with +10% damage modifier, and also that means pet usually has far better focus regain at that time (doing more specials at 50% boost, in case of BL with greater speed also). I'm no math expert but seems logical to me that damage should be better this way instead of giving haste and tbw some static average % increase. |
I'll look into adding Improved Hunter's Mark to the pet buff listing. That shouldn't be too hard to do. I'm not sure when I'll get around to researching all the other debuffs you list and figuring out exactly how to incorporate them. But they are good ideas for future development.
I
have thought about modeling Concussive Barrage to see how often a target will be dazed by a Hunter and it's effect on his Steady Shot DPS in a long fight. But I don't know any Hunter who actually put any talent points into it. If I do a target debuff table I'll make sure to incorporate daze into it.
Doing an equip compare is problematic in a presentation sense. I'll think about how I can do that in a way that makes for simple comparisons. I probably will not have the items full effects modeled into a complete DPS total. For anything with a speed differential (haste, weapon speed, etc.) it requires rebuilding a shot rotation. But just doing normal calculations requires me to double the effort made to compute DPS. While doing that isn't prohibitive, keeping both sets of equations up to date is more maintanence than I'm willing to undertake. Others have pointed out that making copies of the spreadsheet is the best way to do full equipment set compares.
The same comment reagrding multipe equation sets applies to adding in Lactose's X AP = Y crit = Z Agi matrix. It's easy enough to hand code in 1 extra stat in the blue row on the Gear page and see what the benefit is.