Cheeky

Ideally you want to test with a 3.0+ speed weapon and the GM Bullseye. That would definitely prove whether it is PPM or PPA. My money would be on PPM, like the Romeo's Poison Vial is. (See www.TKASomething.com DPS spreadsheet thread starting here for the data and analysis)

Cheeky of Havoc

 

◊ Lactose

I really don't see how it matters when we're talking about a proc that's on the ranged weapon - you can't swap the ranged weapon to something with a different base speed and do the test when there's only 1 ranged weapon that has the proc we're talking about :P

SNAKEBALL™

 

Sheshini

hi i tried the spreadsheet and was pretty surprised with the results

i tried a survival built and a marks built
the surprising thing was doing a full rotation of only stead shots and a full rotation of everything ie arcane shots and multi yields about the same dps. the difference was like 10 dps max.

is this true? does that mean if i go builts like survival i just spam steady/autos since i dont have improved multis.

i messed with it for quite some time with different gear and builds. but the results were the same. Stead/auto rotation yields better or slightly lesser maybe ard 10 dps compared to full rotations.

puzzled.

 

The Iron Colonel

I stand corrected. This is good information to have in the future.

Also, note that I tend to differentiate between weapon speed and attack speed - the terminology seems to be confusing. Perhaps as a group we should adopt something of a standard - whether it's "modified weapon speed", "attack speed", or whatever.

 

◊ Lactose

I tend to use:
Weapon Speed - speed listed on weapon
Hasted Speed - speed after haste modifiers

HastedSpeed = WeaponSpeed / ((1+aHaste%)*(1+bHaste%)...*(1+nHaste%))

SNAKEBALL™

 

◊ Lactose

Which spreadsheet? Sounds like Cheeky's?

SNAKEBALL™

 

Cheeky

I really have to pay attention when I post. For some reason I thought we were talking about the Mark of Conquest (different conversation I was having with a guildie). With a specific weapon we can get a % rate that should be consistent regardless of haste.

There has to be some event to track, since refreshes tend to be picked up by buff countdown mods.

Cheeky of Havoc

 

Sheshini

ya cheeky's

 

Zeorn

Cheeky, I noticed that having the 4-piece Demon Stalker bonus doesn't seem to effect multi-shot's mana on your spreadsheet.

I would like to thank you and Lactose though for putting the time and effort into all this. I have been using your spreadsheets to test different talent specs and play around with gear selections and they really do help.

 

soulesschild

Cheeky thanks so much for your hard work, I have one request though, is it possible to have a seperate tab to say, have different gear changes/saved gear setups? unless theres already one and im retarded lol

 

The Iron Colonel

This has been asked a few times; there is no separate tab for comparing gear in Cheeky's sheet. I recommend either using Lactose's sheet or opening multiple copies of Cheeky's sheet to compare gear. Hope this helps!

 

Rivo

Hey guys... I just stumbled upon your forums and spreadsheets while trying to research some Hunter spec questions i had...

First I want to say, "Wow!"... i downloaded your Hunter Dps Calc sheet and have been messing with it for about an hour... it is extremly badass!... you guys did a great job with the level of detail.

Second, I was trying to turn on True Shot Aura on the buffs tab of the spreadsheet to factor in the AP bonus and it was not changing from Zero. Might be something i was doing not totally sure...

But again, Thanks guys! I am sure that took a lot of work.

Rivo

 

Cheeky

Thanks for your compliments. True Shot Aura gets applied either through the buff, or the talent. If you specify the TSA talent I add it in on the Calculations page that way, and I set the Buff value to 0 on the buffs list. That is intended for BM/Survival Hunters who want to "leach" TSA from the Marks Hunter.I don't want to "double count" the benefit.

Feel free to send me questions via personal message here. It keeps the thread free of clutter.

Cheeky of Havoc

 

Sympa

Lactose, ETA on an update?

Looking specifically to compare 5/5 IAotH & MT

 

gimpynerd

-never mind-

 

Djinn

Cheeky

Possible to add curse of shadow to your spreadsheet?

 

Cheeky

Sure. I'll go ahead and add a "Target Debuff" section. I'll put in Improved Hunter's Mark and Expose Weakness from other Hunters in there. Anything else we should add?

Cheeky of Havoc

 

Djinn

Not that i can think of right now, but i do have a question. The Gladiator gloves 4% multi shot bonus show up on the shot rotation tab? Or the Calculation tab?

 

Cheeky

It should be listed as PvP bonus on the Multi-Shot Damage adjustment section of the Calculations tab. That value is used throughout the Shot Rotation.

Cheeky of Havoc

 

khel

The talent TBW does not increase the hunter or pet's overall dps, which it should really as it would be up 18 seconds every 2 minutes and provide a significant change to dps.

 

Meanereth

Thanks for the awesome work guys.

Just posting a couple of socket issues I've noticed in gear on Cheeky's Spreadsheet (if someone has posted about them already, my bad):

Void Reaver Greaves and Vengeance Wrap keep says "No Socket" although these items have those.

And... That's all for now. :P

 

Rhoi

id love to see something like the "next Stat" as on the warlock dps spreadsheet.

it shows the dps bonus, damge, hit rating, crit etc that you would gain for the next 1 point each stat and also how much each stat is worth on the item point distribution thingo so that you can compare the profitability of one stat to the other

i thought that maybe the hunter one could use something like that for AP Agi Crit Hit etc...although it would be a pain to figure out with the way ap/agi/crit scales

 

◊ Lactose

That sounds similar to what I've done in mine.
The only difference is that I compare the stats in a matrix.

SNAKEBALL™

 

Fimbo

I've looked through both spreadsheets and this thread but i can't find any maths which calculated the difference +to hit makes on bosses.

Lactose's sheet includes to hit up to a 5% cap (so presumably 70 vs 70) but also notes that it isn't integrated correctly.

I’ve got these results so far:
Using Lactose’s sheets everything else at default:
RAP 1800 at 0% versus 5% to hit gives: 641 vs 668 DPS (difference of 27)
RAP 1900 0/5 gives: 661 vs 689 (28)
RAP 2000 0/5 gives: 680/709 (29)


Basically i'm trying to convince our hunters of the import of running with the 8.6%/126 to hit rating on bosses. But people are arguing anecdotally that they aren’t missing on bosses etc.

What I’d like to calculate is actually the value of “to hit” versus RAP.
I’ve always ran under the impression it’s vital to max out to hit (probably a throw back to tranq shotting) but I’ve really no idea what it’s exact value is now.

So what difference in DPS against a lvl 73 mob is there between 5% and 8.6% to hit at 2k RAP against the difference in DPS between 1900 and 2000 RAP.

Is this in the sheets and I’m being a user?
Or can someone point me at some maths on this somewhere?

 

Cheeky

If you look at the Calculations tab in my spreadsheet you can see how hit rating and mob level work together to generate a chance to hit. Against level 73 mobs with typical Defense you need 8.6% hit to not miss. And 136 (not 126) rating is needed for non-Survival Hunters to get +8.6% ranged hit.

You can hand code in different levels of RAP and hit on the gear page (blue section) and see how that changes overall DPS. It is not going to be a linear relationship.

Without running a tool like WWS or Recap it's very hard to tell if you miss a few shots on a long boss fight.

Cheeky of Havoc