WotLK DPS spreadsheet - Page 253

snail · 12/07/09, 8:45 PM

Noticed 2 more errors in the ptr version of the spreadsheet, this time related to pets.

1) Owl's Focus is in the 4th tier of pet talents instead of the 2nd -- I can't even confirm this is an error except via Wowhead since I don't have a cunning class pet myself.

2) Wolverine Bite, when placed into the pet's ability use list results in a circular loop error.

Thanks for the sheet update as always.

foox · 12/08/09, 3:54 AM

It would be nice to have an option that would ignore the set bonuses for Gear Planer and DPS calculations, making it easier to compare basic item stats and finding upgrades like "replace a set item with a non-set item an regain the bonus by equipping another set item".

Currently I'm recreating the sets on the Custom Gear tab which is getting a bit nasty in transitioning times where you mix items from 2 different sets.

Neonias · 12/08/09, 4:48 AM

I have testet the steady shot glyph as a marksman myself on the PTR an it was fixed. but in the spreadsheet there is no difference if i take none or that glyph. needs to be fixed i think.

Without Glyph of steady shot
ImageShack® - Image Hosting
With Gyph of Steady shot
ImageShack® - Image Hosting

Hunters Mark up 100% Serpent Stin uptime 100% fired about 60-80 shots(just wanted to make sure the bug is there or not)
No Trinkets.

numbers without Glyph
Hit
min: 1122 max: 1361 av: 1224
Crit
min: 2605 max: 3383 av: 3042

With Glyph:
Hit
min: 1232 max: 1356 av: 1494
Crit
min: 3126 max: 3743 av: 3463

Weapon was Fezzik's Autocannon with Frostbite Bullets.

Cranch · 12/08/09, 12:48 PM

Originally Posted by foox

It would be nice to have an option that would ignore the set bonuses for Gear Planer and DPS calculations, making it easier to compare basic item stats and finding upgrades like "replace a set item with a non-set item an regain the bonus by equipping another set item".

Agreed. There's a simple work-around though -- just equip 3 (or 5) items and then run the gear comparison.

arlen · 12/09/09, 1:08 AM

Wodin's Lucky Necklace is listed in the spreadsheet and on wowhead as giving 46 hit rating but it actually only gives 38 hit rating. Verified in game equipped.

nbuubu · 12/09/09, 3:40 AM

I just had the Deathbringer's Will drop in our first (depressingly easy) clear of the first wing of ICC.

I then ran a couple heroics using it ... and can confirm it only ever procs Agility, Attack Power, and Crit. I never saw another transformation.

It also seems to proc very often ... I didn't time it exactly, but I'd guess it's on a 2min internal CD. So either 600 AGI, 600 Crit, or 1200 AP for 30 seconds every 2 minutes.

It should definitely rank much higher on the spreadsheet. Testing it on the dummies in Org I noticed a huge improvement over the Greatness Agi deck it replaced (my guild had horrible luck with the trinket from TOGC.

*edit*

Just did more testing. The proc is 100% on hit, with an internal cd of under 2 minutes.

Started Stopwatch.

Proc on first autoshot. Just left my hunter autoshotting the dummy. 1200 AP.

Next Proc at 1 min 48 seconds. 1200 AP.

Next Proc at 3 min 42 seconds. 600 AGI.

Next Proc at 5 min 35 seconds. 1200 AP.

Next Proc at 7 min 23 seconds. 1200 AP.

Next Proc at 9 min 21 seconds. 600 Crit.

Next Proc at 11 min 10 seconds. 600 AGI.

Next Proc at 12 min 56 seconds. 600 AGI.

Then I stopped. Anecdotally while running heroics, I noticed the Taunka (AP) and Vykul (AGI) procs more often than the Iron Dwarf (Crit). They're probably equal chance to proc though, but with only 3 buffs to choose from it's easy to go on a streak of one buff.

Put these numbers into the spreadsheet as a custom trinket (30 sec duration, 120 cd, plugged in the AGI, AP and Crit seperately) got the following upgrade numbers over my old Greatness Deck:

204 DPS upgrade with AGI proc.

160 DPS upgrade with Crit proc.

149 DPS upgrade with AP proc.

So yeah. It's kinda dipped in awesomesauce.

Whalehunt · 12/09/09, 5:03 AM

Originally Posted by nbuubu

Started Stopwatch.
Proc on first autoshot. Just left my hunter autoshotting the dummy. 1200 AP.
Next Proc at 1 min 48 seconds. 1200 AP.
Next Proc at 3 min 42 seconds. 600 AGI.
Next Proc at 5 min 35 seconds. 1200 AP.
Next Proc at 7 min 23 seconds. 1200 AP.
Next Proc at 9 min 21 seconds. 600 Crit.
Next Proc at 11 min 10 seconds. 600 AGI.
Next Proc at 12 min 56 seconds. 600 AGI.
Then I stopped.

CD of [Deathbringer's Will] would be 1 min 50 sec.

	Proc	CD	Stat
1st	0:00:00		AP
2nd	0:01:48	0:01:48	AP
3rd	0:03:42	0:01:54	AGI
4th	0:05:35	0:01:53	AP
5th	0:07:23	0:01:48	AP
6th	0:09:21	0:01:58	Crit
7th	0:11:10	0:01:49	AGI
8th	0:12:56	0:01:46	AGI
Av.		0:01:51

* added after further calculation *
Further calculation shows that CD of DW would be 1 min 45 sec and the chance for proc would be 15%. Spreadsheet shows that, in such case, average time between procs will be 110.51 secs, i.e., 1 min 50 sec.

nedm · 12/09/09, 7:52 AM

Not sure if this is an error or what, but [Wodin's Lucky Necklace] and [Band of the Bone Colossus] are both missing their sockets in the spreadsheet, confirmed linked on my character here.

alienangel · 12/09/09, 9:18 AM

Someone still needs to do a bit of testing with Deathbringer's Will. I've seen 2 plausible theories so far on how it works:

There are three different animals, Iron Dwarves, Taunka, and Vrykul. Each animal has two buffs, each class gets one of those two. Dwarves are Crit/ArP, Taunka are AP/Str, Vrykul are Agi/Haste. So the only ones we'll get are Crit/AP/Agi.

looking at both the hunter's stats that posted their proc results..
I've come up with the thought that MAYBE the trinket takes your three highest stats out of agi/str/ap/arp/haste/crit.

Three people I've seen post also get procs that are consistent with both theories - still need someone to experiment a bit with gear to check which it is:
The World of Warcraft Armory (hunter) gets AGI, Crit and AP
The World of Warcraft Armory (rogue) gets AGI, ARP and AP
The World of Warcraft Armory (hunter) get AGI, Crit and AP

Maybe it's a combination of the 2 systems posted, where it'll pick from the 3 pairs of animal buffs as someone posted, but which buff out of a particular pair it picks isn't fixed by class, it goes by which of those 2 stats you have the most of? That sounds like a fairly good way to pick the stats, except it breaks down badly as soon as anyone tries to hard-cap ArP :/

nbuubu, could you try swapping some gear so your total crit rating is lower than your total ArP, and see if it still procs you Crit instead of ArP?

Alduin · 12/09/09, 10:07 AM

If the theory about choosing only the highest 3 is true then it will never procc ARP because with 800ARP rating, ARP will just be number four on the list. Cause we cap ARP with 1400ARP (which is avaible) every ARP proc from the trinket then would be a waste.
On the other hand the 2 per "race" combination makes some sense. If it's right, it looks like MeleeAGI gets AGI/Crit/AP and MeleeSTR gets ARP/STR/Haste...

Perhaps it would make sense to train naked (to see what can procc), with an ARP item (ARP>rest), an AGI item, haste etc. Perhaps lvl5 greens will be enough.

So some new Ranged weapons:

Ranged:
Stakethrower, an ilvl 264, 3sec Gun with ARP. Looks like a new MM ARP Gun. It is listed in the armory as a Blood Queen drop. link

Njordnar Bow, an ilvl 264 2.9 bow with hit/crit. Looks like a Lady Deathwisper drop (GOGO week 1-3!! link

Weapons:
Hersir's Greatspear, an ilvl 264 polearm with ARP(looks like Prince Valanar 10) link

Bloodfall, an ilvl 277 polearm with Haste (Blood Queen 25hm) link

Neck:
Rimetooth Pendant, an ilvl 264 ARP pendant from Sindragosa 10hm link

Feet:
Taldron's Long Neglected Boots, ilvl 264 ARP feet, Festergut 10hm link

I am still searching the armory. Some items look REALLY delicious.

Shandara · 12/09/09, 10:43 AM

Update:

- A few more items added
- Culling the herd model changed
- Fixed Needle-Encrusted Scorpion to calculate the ArP Correctly
- Changed Herkuml War Token to use the same calculation as the Fury of the Five Flights
- Glyph of Steady Shot / Marked for Death bug fixed in 3.3 so change reverted to normal behavior
- Resorted Cunning pet talents to match wowhead
- Wodin's Lucky Necklace now has +38 hit rating and a yellow socket. Same as Band of the Bone Colossus
- Deathbringer's Will (normal and heroic) proc implemented
- Fixed Wolverine Bite circular reference

For the Deathbringer's Will (normal and heroic) it averages out each proc's worth at a 33% contribution. Please report any changed items here so I can fix them. It seems there are some discrepancy between what was mined and what's really live.

Bluesfear · 12/09/09, 10:48 AM

I am going to take it that you will be able to stack both Deathbringer's Will trinkets from normal and heroic just like Death's Verdict/Choice? I see both have different spellID and follows the same "Unique" labeling.

Ryannktsu · 12/09/09, 12:39 PM

Found an error - the Icecrown Rampart Bracers are supposed to have a red socket and a 4 agi bonus. No Socket, No bonus in the sheet.

Thanks for the hard work!

benisapha · 12/09/09, 12:43 PM

In response to stacking heroic and non heroic items, in the patch notes it stated that this will not be possible for ICC items.

nbuubu · 12/09/09, 12:56 PM

Originally Posted by alienangel

nbuubu, could you try swapping some gear so your total crit rating is lower than your total ArP, and see if it still procs you Crit instead of ArP?

This was pretty easy to test actually.

Removed gear so I had 798 Arpen and 740 Crit.

First autoshot procced the trinket, 600 Crit Iron Dwarf.

Second proc was AP at 1:42.

Third proc was Crit at 3:30.

So I can pretty much confirm that Hunters will never get the Arpen buff, unless there's something strange I'm missing. With this trinket we get Agi/AP/Crit.

I'm also starting to question if it's a 100% proc chance. I may just have been lucky with that first proc several times last night. I seem to remember it taking a couple shots to activate once last night and had assumed it was just patch lag, but the proc chance may be a bit lower than 100%. Like maybe 25% or 50% chance to proc.

Since I'm only autoshotting, not going through a normal rotation like I would in raid, the fact my procs are often more frequent than 110 seconds, with a slow weapon autoshotting, makes me think the internal CD might in fact be even lower ... like 90 seconds with a 25% or 50% chance to hit. So the trinket's effective uptime would be slightly higher in raid during a full rotation.

Don't know how to test proc chance in these conditions, other than starting autoshot and seeing how many shots fire before my hunter transforms. Guess I could run a log, but it's not such a good idea to close my office door and pretend to be working while testing proc rates.

Test One: Proc on first shot.
Test Two: Proc on second shot.
Test Three: Proc on first shot.
Test Four: Proc on third shot.
Test Five: Proc on fourth shot.
Test Six: Proc on first shot.

Totally unscientific, I know ... but doing the best I can on a craptastic mac work laptop.