Hunter Talent Build - Page 5

Boevis · 08/29/06, 6:54 AM

Well, unless you're gearing all your hunters identically, you'll be best off having a mix of LR and TSA anyway because some gear is definately better for LR.

Farstrider · 08/29/06, 7:48 AM

Originally Posted by Boevis

Well, unless you're gearing all your hunters identically, you'll be best off having a mix of LR and TSA anyway because some gear is definately better for LR.

well now you're moving into a whole new nightmare, because what your really talking about now is comparative advantage - i.e. given that we might not get enough X drops, what is the next best thing for your hunters to grab. But they'll still do more damage in 5/31/15 even in slightly subpar gear or all the max agility gear.

Next point to ponder. Outside of raids (read PvP) how would you value the rank 11 gloves with +4% dmg to multishot compared with DS gloves?
-2 agi, -1% crit, +4% to multishot.

I guess if you reckon that more than 25% of your damage comes from multishot that makes them better, I reckon in a proper shot rotation you get about 1/3 of your damage from multishot, but that's not really that relevant to PvP. On balance it's probably not worth breaking up 8/8 DS for even though the 8/8 set bonus is of *very* limited use in PvP.

Boevis · 08/29/06, 7:54 AM

Originally Posted by Farstrider

Originally Posted by Boevis

Well, unless you're gearing all your hunters identically, you'll be best off having a mix of LR and TSA anyway because some gear is definately better for LR.

well now you're moving into a whole new nightmare, because what your really talking about now is comparative advantage - i.e. given that we might not get enough X drops, what is the next best thing for your hunters to grab. But they'll still do more damage in 5/31/15 even in slightly subpar gear or all the max agility gear.

Last time I ran it through a sim, one of our hunters with 8/8 DS, Darkmoon, Shrouded Mist, Godslayer, Brood-Conquerers ring, Blackhands, Royal Seal, Barb, and Rhok was about 16 DPS better off with a LR spec than a TSA spec. I'll check it on Thugs sheet in a sec.

Edit: I'm getting an odd error when trying to click the buttons in Thugs spreadsheet using OpenOffice. "A Scripting Framework error occured while running the Basic script vn.sun.star.Script:Standard.<script here> Message: BasicProviderImpl::getScript: no script!" :(

Just finished running it through with entering the items by hand. LR Spec listed him as 602 DPS on a 9 second rotation when leeching TSA from another hunter, 586 DPS when not getting TSA. A TSA Spec puts him at 581 (I'm sure this would be higher if selecting Imp Hawk did anything) So in a raiding situation, like against patchwerk, this guy is better off LR.

Farstrider · 08/29/06, 8:21 AM

Originally Posted by Boevis

Last time I ran it through a sim, one of our hunters with 8/8 DS, Darkmoon, Shrouded Mist, Godslayer, Brood-Conquerers ring, Blackhands, Royal Seal, Barb, and Rhok was about 16 DPS better off with a LR spec than a TSA spec. I'll check it on Thugs sheet in a sec.

That sounds wrong. It's not far off what I've got which is why I say it sounds wrong.

Farstrider · 08/29/06, 9:36 AM

Originally Posted by Thug

Boevis: Unfortunately, my spreadsheet isnt open office friendly. Plus all the buttons go out of position and it looks like crap. grrr

Thug - I'm playing with your spreadsheet and I like it a lot, the only thing is that the equations are not that clearly handled so I am struggling to see where it is going astray from what I am used to seeing in the Hunter Simulator - although I am coming to the conclusion that your spreadsheet is more accurate as I play around with it more...

At current agility levels your spreadsheet is implying a MUCH smaller gap between MM & SV builds than I had previously estimated for certain gear choices, as indeed Boevis had implied earlier - i.e. for high agility, relatively low base crit gear profiles, SV comes within a handful (as close as 5) of dps of MM build.

Meh don't want to turn this into a personal attempt to try and work out what's _more_ correct.. back to trying to find the glitch..

EDIT:- Thug am I right in thinking the numbers in the grey section T40:W62 in the calcs sheet is not working properly yet? Struggling to see what hitting the calc button does that just F9-ing the whole sheet doesn't.

Farstrider · 08/29/06, 12:13 PM

Originally Posted by Thug

Basically, what happens when you hit the "Calculate DPS Values!" button it activates a macro that goes through and compares the final dps value against the dps value -1 agility, -1 crit etc.. and then it goes and organizes the dps gear and ranged weapons sheets by dps value. When you hit that button it should look like everything is going haywire for a few seconds. hehe
(Not sure what you mean by F9-ing)

I work at a bank so we disable auto-updating when u update a cell, so I hit F9 to force calculate the whole workbook.

But it doesn't look like any of those -1agi/-1crit etc values are actually showing up for me, as all the values in R45:R50 are identical, hence their partials are all 0, after I run the macro... :(

edit:- also, sorry to be a bore here, but it looks like (this may be due to said macro having a little "wrinkle") that "calculation" macro seems to be overvaluing AP & AGI relative to +%crit. i.e. valuing 1agi = 1%crit which is a bit of a stretch. That's leading to some strange item valuations i.e. Bloodsoul Shoulders > Dragonstalker.

Farstrider · 08/29/06, 12:43 PM

Originally Posted by Thug

I would have to say the problem is coming from the limitations your work environment has on the spreadsheet. Using my gear (which I forgot to take out of the spreadsheet and is saved as template #10) I come up with the following values:

1 crit =
5.58dps
32.53ap
12.44agi

yep, you are right - the problem stems from the fact that my sheet does not autocalculate every time you change a cell.

I would suggest (just for those of us who don't like auto calculate) that you either put a warning on the front reminding people to enable autocalc - or, more sensibly, add a step that forces sheet calculation at every partial step of your macro, then it will work regardless.

Glad I got to the bottom of it, and I'm now appreciating the sheet even more!!