WotLK DPS spreadsheet - Page 70

Esoth · 12/24/08, 9:00 AM

The "Sub-total for Stings" in the Hunter Damage Adjustment calculation is still not giving the benefit of Improved Tracking, which is assumed to be the behavior on the PTR. This post suggests that it is getting it already, despite what the tooltip says.

TrevvyTrev · 12/24/08, 9:52 AM

Originally Posted by Cynddl

Hello everyone. This is my first time posting, though I am an avid reader. There's something that's somewhat bothering me, however, and I can't quite dig up an answer for it. Shandara's spreadsheet is showing me that dual-wielding 2x Major Intellect (or Exceptional Intellect) is pretty much the best enchant I can get for 1-handers. It boggles me that the +26agi and Accuracy enchants are providing less DPS than +45 intellect. Has anyone else noticed this, or am I missing something?

Yes, I've noticed it too, although as someone else said the +45 int enchant hasn't made it into the game yet. You would get 90 RAP from the int enchants, as opposed to 52 from the agi, and at least at current gear levels AP generally edges out agi for BM hunters because of the additional benefits to pets. You also get 1350 mana, which translates to quite a few extra shots before having to dip into Viper. In order for +agi to surpass it, it would have to make up for the several thousand points of additional damage these shots would cause each cycle. Additionally, the extra mana means you recover more from abilities that replenish based on max mana (like invigoration, which you have), which also increases the time you can spend in Hawk before running out of mana.

Keep in mind that switching to Viper is a hefty penalty for you -- you lose 390 AP, your pet loses 22% of that, you lose imp. hawk haste, and you take a 40% penalty to your damage. If you're doing 2000 dps, a mere 10 second difference in Hawk v. Viper uptime would be 8000 damage just from the Viper penalty, without even accounting for the lost AP, etc.

One last thing is that the spreadsheet assumes a longer fight time (6 mins I think) so longevity gets weighted more. If you adjust the fight time to be less than your predicted "time to oom", then you should see how things stack up against each other in situations where you don't use Viper at all.

Samba · 12/24/08, 10:27 AM

Originally Posted by snail

Someone can correct me if I'm wrong but the 100% assumes 8% hit on the hunter while pets require 9% hit to be capped.

Why would this ever be the case. Ive never seen anything that would suggest that. I have read that it is better to be a few points over cap to guarantee no misses from your pet, but Ive never seen anything that says 1% over the cap. Can someone verify this please?

Esoth · 12/24/08, 11:19 AM

Originally Posted by snail

Someone can correct me if I'm wrong but the 100% assumes 8% hit on the hunter while pets require 9% hit to be capped.

I think you're a bit confused on how hit transfers to pets. It appears to only transfer in whole numbers, rounded down. So if you have 7.99% hit your pet gets 7% and if you have 8.01% hit your pet gets 8%. So for this reason it's better to be slightly over the cap than under, but the cap is still 8%...

Anal · 12/24/08, 12:36 PM

Shandara,
Thank you for all of your hard work on this. I do have a question though, would it be possible to unlock the gem assumptions on the spreadsheet? I think I could get a more accurate read out of the gear planner if I could get it to assume that all sockets get 32ap gems rather than having to match color. What leads me to this is that the eaglebane bracers consistently rank very high on my list but swapping out the other bracers and adding 32ap to any sockets usually shows a dps increase. This may not be possible though as it would screw with the socket bonuses of the gear for the gear planner.

Samba · 12/24/08, 12:44 PM

Originally Posted by Esoth

I think you're a bit confused on how hit transfers to pets. It appears to only transfer in whole numbers, rounded down. So if you have 7.99% hit your pet gets 7% and if you have 8.01% hit your pet gets 8%. So for this reason it's better to be slightly over the cap than under, but the cap is still 8%...

this is exactly what I thought. With that in mind my original "bug" still remains. The gear planner does not update when going from "assume 100% hit" to not assuming 100% hit, when it should change.

grim4o4 · 12/24/08, 1:21 PM

I don't know if anyone else agrees with me, but I find guiding through the gem menu to be very time consuming, is there a way to remove gems from the big list that I would never use, like +int, mp5? Also, I'd love to see rankings for gems and echants in the gear planner menu.

Thanks for all the hard work.

TrevvyTrev · 12/24/08, 1:39 PM

Originally Posted by Shandara

The next release will have Roar of Recovery and Wolverine Bite scaling with pet AP (anyone has any numbers on this, it has proven difficult to test accurately).

I have some numbers using a level 80 Chimera against the heroic testing dummy on the PTR. Dummy was low health, so feeding frenzy was active, and ferocious inspiration procced as the pet crit, of course. Pet AP was 1408, Spellpower was 448. The "min" numbers may be a bit off because I messed up and went into viper during the test, which would have lowered the pet's AP. Test ran approximately 5 mins.

                              Min           Avg        Max
Melee
Hit                           241           263        286
Crit                          486           526        569

Bite
Hit                           253           288        328
Crit                          513           577        639

Froststorm Breath
Hit                           336           434        509
Crit                          569           637        725

Wolverine Bite
Hit                           585           603        622
Crit                          1171         1196       1209

rthiago · 12/25/08, 8:54 PM

Just a minor bug, if you set "Assume 100% hit" to Yes on the gear planner and hit CalcAttributes it gives a zero div error.

Thanks for the awesome work Shandara.

ElDoc · 12/26/08, 12:26 PM

Hello Shandara,

I've spoted a mistake on the gear list.
You've misspeled "Jagged Dagger Pendant". It should be "Jade Dagger Pendant" instead.

And a big thank for your work on Cheeky's legacy

evlchicken · 12/27/08, 5:09 PM

On the Delta +/- dps column on the gear planner, are gems assumed to be filled based on default gems in the settings tab? Or is that the ungemmed delta?

danglebombs · 12/27/08, 7:25 PM

Hrm, it may be just me but I find it odd that its trying to tell me that Nerubian Conquerer is better than Envoy of Mortality >_<

I noticed that its because on my spreadsheet it shows 0 stats for Envoy, same for Final Voyage.

dragoonvengance · 12/27/08, 7:46 PM

Mega Mammoth Meal is missing 80ap 40stam

Esoth · 12/27/08, 8:24 PM

Originally Posted by evlchicken

On the Delta +/- dps column on the gear planner, are gems assumed to be filled based on default gems in the settings tab? Or is that the ungemmed delta?

Default gems in the settings tab

Shandara, a couple things I would put on a wish list:
1. What about adding weapon damage/dps to the Calc Attributes section?
2. It would be interesting if the talent tab showed a delta between adding/removing a talent point for the DPS talents. I realize this would probably take a lot of work and a complex macro...

Also, is there any reason that the sheets are locked except to prevent user error? There are times when I wish I could tinker around behind the scenes a bit.

Meshach · 12/28/08, 2:53 AM

It doesn't look like Glyph of Rapid Fire is taken into account on the shot rotation model.

Excellent spreadsheet tool btw...but Ima sure u know that already