WotLK DPS spreadsheet - Page 72

Bokomatic · 03/02/09, 1:00 PM

I clicked "Debug" - debugger said error in the first string of following (If).

                        If Not Worksheets(sheet).Range(list).Find(bit, , , xlWhole) Is Nothing Then
                            ' Ok, the item matches the validation list for the cell so let's change the cell's contents
                            Cell.value = bit
                        Else
                            ' The item name didn't validate for this cell
                            MsgBox "Item " & bit & " is not a valid choice for your " & list & "."
                        End If

I changed nothing in downloaded spreadsheet.
I'd only opened it, pressed "Import Gear String" and got VB error.
I saved it in my Excel (now 2003), and upload here: Hunter_DPS_v85d.zip.
I hope it will be useful for solving problem.

P.S. Forgot to mention: Both of excel I use are localized (russified). However i have no problems with another features.

Shandara · 03/02/09, 1:09 PM

Thanks for uploading. Strangely enough I downloaded it and tried to import the string and it worked!

This leads me to believe it is some sort of localization problem (I assume by your realm name you're playing in a non-English windows/excel?). I will investigate some more. Hopefully other people can try the import and see if it works for them.

Bokomatic · 03/02/09, 2:14 PM

I've debugged it ^^ kek
Russified XL translated name of "INDIRECT" function in russian, so next "If" didn't work.

Patch for russified XL:

If InStr(list, "INDIRECT") > 0 Or InStr(list, "ДВССЫЛ") > 0 Then
                            sheet = "Gems"
                            list = "GemStats"

Sylvand · 03/02/09, 2:36 PM

Originally Posted by Rezdan

I haven't found any issues of items that aren't upgrades of the first slot (ring/1h,trinket) being overrated. It is sorted according to the first slot and was designed this way. Maybe what you'ld prefer is a separate Gear Planner thing for each ring/trinket/1H slot?

Here's the example given before:

As you can see, it is correctly sorted by the Delta of the First slot.

I'm not saying there's any bug in the implementation, and don't really see a need for a second list. It would just be nice I think for folks that happen to have their trinkets/rings/1H reversed so that they don't have to go in and swap them etc. Also in the case of dual wield it may make sense to have the items in the opposite sorting (i.e. better weapon in the MH) due to either the damage rating on the weapon itself, or one weapon being MH/OH only.

If it's a lot of trouble or there are other things to do and it doesn't get implemented, I'm sure it's fine. But if you're going to respond at least let me know why you think sorting by the max of delta 1 and delta 2 would not be better than sorting by only delta 1 always.

baklava · 03/02/09, 5:21 PM

"Wild Hunt is being changed to 10/20% extra AP from the master. There was a bug where the talent was just applying the hunter's AP to the pet twice, which is too generous.

If you have 6000 attack power, your pet probably gains 1320 attack power from you. With 2 ranks of this talent, it should gain 1580 attack power instead. Your pet's attack power will be higher than this by a few hundred from other sources. "

World of Warcraft - English (NA) Forums -> 3.1 Hunter Patch Notes Confusion

Bad news for BM hunters... Probably u should change the things in Excel for BM now Shandara...

Shandara · 03/02/09, 6:11 PM

Small update:

- Wild Hunt now 10/20% extra AP
- Fixed INDIRECT referencing for non-english locale with the gear string import

Tsook · 03/02/09, 9:08 PM

The gem list is unsorted for prismatic gem slots regardless of the gem sort settings.

Incidentially, the Eternal Belt Buckle stacks with the engineering belt enchants, counter to how the sheet indicates it (but none of the engineering enchants add DPS, so it's a minor issue).

Rezdan · 03/02/09, 9:45 PM

Originally Posted by Sylvand

But if you're going to respond at least let me know why you think sorting by the max of delta 1 and delta 2 would not be better than sorting by only delta 1 always.

Well, in the example screenshot, sorting by the Max of Delta 1 and Delta 2 wouldn't change the sorting at all and in cases where one of the trinkets caps your hit, it would just end up sorting by best non-hit trinket. My main reason though is that it would just increase the complication and reduce the intuitiveness of the spreadsheet. As I stated earlier, maybe the best bet would be to have two diff gear planner selections for each trinket, or have a [Sort by 1st/2nd Trinket] button.

Sylvand · 03/02/09, 11:00 PM

Originally Posted by Rezdan

Well, in the example screenshot, sorting by the Max of Delta 1 and Delta 2 wouldn't change the sorting at all and in cases where one of the trinkets caps your hit, it would just end up sorting by best non-hit trinket.

The max of delta 1 and delta 2 for the grim toll would be 0, so it would be sorted above incisor fragment.

Still, this is somewhat of a special case because the best +hit trinket is already equipped, so it's a moot point to talk about a +hit upgrade while being at or near hit cap.

However for the case where you have sphere of red dragon's blood in the second trinket, the only point upgrade for that slot might be grim toll. Depending on your first trinket, it might very well also be the best trinket upgrade for you, but because of the trinket ordering it shows up at the bottom, not to mention in some future patch with additional trinkets it might fall out of the top 10 all together.

Making a second planner would be fine, but I think sorting on max delta may be better, and it should be a much simpler change.

edit: This will be my last rant on the subject. I hope my point has got across and we can move on.

baklava · 03/03/09, 6:46 AM

Shandara, Why does Resourcefulness increase the dps? We assume we use traps or it is about something else?

Jerem · 03/03/09, 7:07 AM

It might be interesting to note that on PTR, the damage range of the Darkmoon Card: Death has been increased.
It actually should now be slightly higher than the Bandit's Insignia's procs, possibly taking the Card a few ranks higher.
Live: [Darkmoon Card: Death]
PTR: [Darkmoon Card: Death]

Shandara · 03/03/09, 7:08 AM

Originally Posted by baklava

Shandara, Why does Resourcefulness increase the dps? We assume we use traps or it is about something else?

If you are testing SV it is because Resourcefulness affects Black Arrow's CD.

Sirael · 03/03/09, 7:55 AM

Originally Posted by Jerem

It might be interesting to note that on PTR, the damage range of the Darkmoon Card: Death has been increased.
It actually should now be slightly higher than the Bandit's Insignia's procs, possibly taking the Card a few ranks higher.
Live: [Darkmoon Card: Death]
PTR: [Darkmoon Card: Death]

i just put this stats in version 85e and the card climbed from rank 8 to rank 5 with a survival spec.
it's still a bit worse than bandit's insignia, but better as Loatheb's Shadow

what i've noticed is that the [Darkmoon Card: Death] is considered a 15% proc chance in the spreadsheet whereas wowhead says that it's a 35% proc chance

Nooska · 03/03/09, 12:01 PM

This morning very early before I could fall asleep I started thinking.

Shandara, how hard would it be to incorporate a dps variable in the sheet?

I'll explain further;

We have seen a lot of "Why don't I reach the dps the spreadsheet shows" questions, and the answer in most cases is RNG. On a typical bossfight we shoot very few shots compared to whats needed for rng to even remotely even out.
I was specifically thinking of the swing in crit that we saw in the "Focused aim reducing crit" threads data sets - and without having looked if 'we' found a reliable variance to compensate for this, would it be possible to make a single section in the overview tab that calculates the dps swing based on the RNG variance expected for the number of shots fired (which is determined by shot rotation, haste and length of fight - all three are in the sheet).

I know I rarely achieve my spreadsheet dps - I know that latency can be a big issue, especially when its variable during the fight - but I also think it has a lot to do with RNG fluctuation over a 4 minute fight compared to the averaging of crit we get in the spreadsheet.

Bokomatic · 03/03/09, 12:34 PM

Originally Posted by Nooska

Shandara, how hard would it be to incorporate a dps variable in the sheet?

I know formula

Number of crits possible from n shots has binomial distibution

Afaik, all these elementary functions have realization in the excel.

Argg0 · 03/03/09, 12:38 PM

We can't put Thunderstomp for Tenacity pets on its rotation.

Shandara · 03/03/09, 12:44 PM

Originally Posted by Argg0

We can't put Thunderstomp for Tenacity pets on its rotation.

This is a small bug in the sheet. A work around for now is switch pet families after you set the talent for Thunderstomp, it'll be in the list then.

grim4o4 · 03/03/09, 3:36 PM

Originally Posted by Sirael

what i've noticed is that the [Darkmoon Card: Death] is considered a 15% proc chance in the spreadsheet whereas wowhead says that it's a 35% proc chance

It is listed at as a 35% proc chance on wowhead, but it also has an internal cooldown like every proc trinket, of 45s, so that will lower it's actual ppm, which may be what the 15% is in reference in the spread sheet. Also, the ptr version is here. Damage went up from 744 to 956 to 1750 to 2250 per proc.

Thelastdeadmouse · 03/03/09, 3:46 PM

Originally Posted by grim4o4

It is listed at as a 35% proc chance on wowhead, but it also has an internal cooldown like every proc trinket, of 45s, so that will lower it's actual ppm, which may be what the 15% is in reference in the spread sheet. Also, the ptr version is here. Damage went up from 744 to 956 to 1750 to 2250 per proc.

A blue post has implied this might be a bug.

I noticed that on the PTR Darkmoon Card: Death had its proc damage increased from 744-956 to 1750-2250 while still having 85 crit as a 200 level item. Will the extract of necromantic power also be getting a buff as it currently has 95 crit and procs for 788-1312 damage as a level 213 item?

Thanks for the report, we'll look into this.

It seems pretty likely that this is either a bug or is going to be adjusted.

Gada · 03/03/09, 5:17 PM

Explosive Shot damage reduced, rank 4 now deals [ 14% of RAP + 386 ] - [ 14% of RAP + 464 ] fire damage. (down from [ 16% of RAP + 428 ] - [ 16% of RAP + 516 ])

is it whats currently on live ? Quote is from latest ptr notes.

Shandara · 03/03/09, 5:26 PM

Small update:

- Darkmoon Card: Death updated to PTR stats and correct proc chance (35% per wowhead)
- Thunderstomp now added to pet ability list once you select the talent
- Gorilla's Pummel now 30 second cooldown (up from 10 second)
- Explosive Shot damage adjusted to latest PTR (9637)

BM and SV are really close now (at least if I use my Beast-Tamer's shoulders as BM). No doubt the difference is different when properly gemmed/geared for each spec (and with proper specs in any case since I haven't tried many out yet).

Esoth · 03/03/09, 5:41 PM

Originally Posted by Gada

is it whats currently on live ? Quote is from latest ptr notes.

The coefficient is the same, but it looks like the base damage got lowered.

Edit: Shandara, are you using BiS gear? I'm seeing a gap of about 200 DPS between Survival and Marksmanship and another 200 DPS gap between Marks and BM.

kurukulla · 03/03/09, 6:51 PM

The last two PTR spreadsheets have only given me the option of using wolf abilities in the pet tab regardless of what pet I select.

Needless to say, this makes comparing the overall dps impact of various pets difficult.

Sean · 03/03/09, 6:54 PM

A Wild Hunt change just went through on PTR - but it's not the change they announced. It no longer gives +40% scaling in the really overpowered manner it did, but is still 20/40% on its Ranks and is giving it in the manner that GC said they intended to (IE Pet gets 1000 from you base, it'll get +1400 from you now). Hopefully it stays this way, as 10/20% was really too much of a gut of the ability.

Neruse · 03/03/09, 7:05 PM

Aye, with my current gear I'm seeing BM about 300 dps lower than MM, which is then about 200 dps lower than SV.

Also, wolves appear to be only 25 net dps less than devilsaurs. Considering the devilsaur hitbox issues are still there, this seems to be a no brainer.