WotLK DPS spreadsheet - Page 75

Charcoal · 03/16/09, 9:56 AM

The DPS value of Slime stream band doesnt change when going from not hit capped to hit capped in the spreadsheets gearplanning section

GwolfGarona · 03/16/09, 12:58 PM

This has been driving me crazy since v85d

On the Overview tab the column in the profiles section "Shot Queue" does not change its value no matter what I do In the Shot Rotation tab. The column references the hidden tab Profiles so I cannot see what it is it actually references.

Bug? or User Error?

Ufthak · 03/16/09, 1:08 PM

You can unhide sheets: Format->Sheet->Unhide and pick the one you want. Not sure how much help that will be though, the field appears to just be text, presumably written to when you save profiles (or not if you are corrrect). In fact after changing the shot rotation I clicked Save Profile on the Gear tab and that column did update.

On an unrelated note, I was trying to find the best pet and found myself having to flick between tabs to see the total DPS contribution, mainly for a wolf actually, would it be possible to have the hunter's DPS and total added to the pet tab please.

Edit:
Thirdly, with too much time on my hands at work, Combat Potency/Blood Frenzy seem to be 4% on PTR talents but only 2% in 85h.

Shandara · 03/16/09, 2:09 PM

Originally Posted by GwolfGarona

This has been driving me crazy since v85d

On the Overview tab the column in the profiles section "Shot Queue" does not change its value no matter what I do In the Shot Rotation tab. The column references the hidden tab Profiles so I cannot see what it is it actually references.

Bug? or User Error?

Are you saving the profiles though? It only updates after you save it, since it draws from the values on the Profiles tab.

Rivkah · 03/16/09, 5:11 PM

In the PTR version of the spreadsheet, changing pet families does not seem to change the pet abilities available. I can only seem to get bite, growl, cower, dash, furious howl available regardless of whether I set it to wolf, raptor or cat. Am I missing something?

Shandara · 03/16/09, 7:13 PM

It should automatically change the available skills when you change the pet family. Are macros properly working for you?

Esoth · 03/16/09, 10:46 PM

Kharthus noted that Sniper Training is not applying correctly to Explosive Shot: The Survival Hunter in WotLK
It looks like he's right; the end range of the product in K107 ends at K105 instead of K106. That should definitely up the relative value of that talent.

Rivkah · 03/16/09, 11:41 PM

Originally Posted by Shandara

It should automatically change the available skills when you change the pet family. Are macros properly working for you?

I'm using the Mac Excel 10.1.5 and a lot of the fancy features don't work in the spreadsheet, but the previous version of the spreadsheet I had no problem switching pet skills in the same version of Excel, so I'm not sure what change was made that caused it to no longer work on the Mac. I checked in Mac Excel 2008 and I get the same problem there.

GwolfGarona · 03/17/09, 12:36 AM

Ok i wasn't saving after every change.

But what struck me was what it says: "Sp/KS/MS/SS" is the value. My rotation in the tab at the moment is Rapid Fire, Bestial Wrath, Serpent Sting, Kill Shot, Multi-Shot, and Steady shot in that priority order. I can change MS to AS or add AS between KS and MS but I never get SpS to appear and have no clue what Sp is.

It may just be an OCD and not have anything to do with important calculations but I've trying to get the best rotation/gear for 0.2-0.4 sec latency so I've been looking at that column alot.

Sapa · 03/17/09, 5:37 AM

Bug (85h):
* Heavy Borean Armor Kit = 15 sta in spreadsheet when applied to legs. (it's 18 on other gear)

Iru · 03/17/09, 10:51 AM

Originally Posted by GwolfGarona

Ok i wasn't saving after every change.

But what struck me was what it says: "Sp/KS/MS/SS" is the value. My rotation in the tab at the moment is Rapid Fire, Bestial Wrath, Serpent Sting, Kill Shot, Multi-Shot, and Steady shot in that priority order. I can change MS to AS or add AS between KS and MS but I never get SpS to appear and have no clue what Sp is.

SpS = Serpent Sting

Kariuto · 03/19/09, 3:54 AM

Bug:

Explosive Shot is always getting the bonus of 5/5 Mortal Shots, even when it is not specced. I noticed people in the survival dps thread finding that 7/11/53 or 7/13/51 was the highest dps survival spec, which didn't make any sense at all considering survival's high crit rate. They are not losing nearly as much dps as they should when taking points out of Mortal Shots.

Shandara · 03/19/09, 9:48 AM

Update:

- Fixed Signet of Edward the Odd bug on gear planner and calculations page
- Efficiency now 3/6/9/12/15% reduction
- Heavy Borean Armor Kit now +18 stamina for leg slot
- Focused Aim works for pets again
- Mortal Shots now depends on talent points for Explosive Shot
- All ranks of Black Arrow implemented
- Added tier8 25/10-man sets
- Implemented 2/4-piece bonus. 4-set bonus assumed no ICD for now (needs testing)
- Added most known 3.1 loot (from Wowhead)
- Sniper Training now properly affects Explosive Shot

I used the following filter to get items from Wowhead:
Items - World of Warcraft

All leather/mail items without strength or spell-power, excepting those without stats (mostly trinkets) or those with placeholder names (mostly Argent Tournament items).

I tried checking MMO for each item to verify drop locations, but no doubt I've missed some or misplaced some. Please correct any errors you find.

KraxisSingular · 03/19/09, 10:34 AM

Well this should really change things a bit. Going to check how the various specs will look like.

[EDIT]
Alright tested out 0/15/56, 1/15/55, 2/15/54 and 7/13/51.

The first was perhaps not a clear winner, but a winner. The big loser was obviously 7/13/51, especially if you go Noxious Stings over Sniper Training. With ST it comes within 40 DPS of the first spec. But the fragility of the spec makes it unworthy to me. Good riddance I say.

Glyph of the Hawk in the two middle cases come a lot closer to Serpent Sting and Steady Shot, but it remains slightly less. Serepnt Sting and Steady Shot are basically a wash now. Within 1 DPS of each other. Personally I will pick Serpent Sting for the fewer applications, meaning more 'freedom' for me.

Nageya · 03/19/09, 11:01 AM

It appears as if the v86 available to download is actually still the v85h build of the spreadsheet.

KraxisSingular · 03/19/09, 11:02 AM

Mine is 86....?

Nageya · 03/19/09, 11:38 AM

Strange, I have re-downloaded it 5 times and it still shows 85h on the change log and the new ptr gear is not available. I will give it another go and see what I get.

Edit: Same issue v85h in the change log, no new gear available, downloaded onto a different pc and same issue. I went directly to the host site pulled the file over and had the same issue. I think v86 doesn't want me to use it....

Esoth · 03/19/09, 11:41 AM

Lotrafen looks like it's hidden from the weapon options. I can type it in though, so it validates.

GwolfGarona · 03/19/09, 3:24 PM

WHERE in the spreadsheet does it show tier bonuses
a) are active
b) active effect is

basically, where is the dummy light if i'm swapping 7.5 with 8 that says you have both 2 piece bonuses or you have 4-piece of either?

I'm looking for the point when for BM the stat gain is worth losing the 2pc tier 7 bonus if i'm going to do Ulduar 10 for practice before entering Ulduar 25 and I have 3/5 tier 7.5 + Blue Aspect helm + Gloves of Calc Risk to start with. And when I look at this sheet, the "Valorus Cryptstalker" and "Valorous Scurgestalker" start to blur.

Faerdael · 03/19/09, 3:58 PM

Originally Posted by KraxisSingular

Alright tested out 0/15/56, 1/15/55, 2/15/54 and 7/13/51.

The first was perhaps not a clear winner, but a winner. The big loser was obviously 7/13/51, especially if you go Noxious Stings over Sniper Training. With ST it comes within 40 DPS of the first spec. But the fragility of the spec makes it unworthy to me. Good riddance I say.

The thing to keep in mind here is the value of these specs are very dependant on mana conditions. As you need less mana, more points in BM, and less points in Surv becomes better than other specs. The default fight time on the spreadsheet is 6 minutes, which no one has done since Brutalus attempts. Comparing the best gearset pre-loaded on spreadsheet, with the default 6 minute time, I get something like this:

1/15/55 7072.44 (es,kill,steady glyphs)
0/15/56 7074.41 (es,kill,steady glyphs)
7/13/51 6987.73 (es,kill,srs glyphs)

Drop the fight time down to 4 minutes, and it turns into something like this:
1/15/55 7219.50 (es,kill,hawk)
0/15/56 7220.95 (es,kill,steady)
7/13/51 7263.83 (es,kill,hawk)

A 3 minute fight shows me:
1/15/55 7370.43 (es,kill,hawk)
0/15/56 7367.53 (es,kill,steady)
7/13/51 7463.47 (es,kill,hawk)

To get the best numbers you can out of a 7/13/51 variant at 6 minutes, you are dropping points from DPS talents to spend in mana talents and using a more mana efficient glyph (serpent sting), which defeats the benefits of the spec. I think 7/13/51 is the only logical version of 7/X/X to consider; if it leaves you mana starved, then the other specs are better. All that being said, I rarely find myself running oom, and thus using speed pots, which aren't very good for hunters. If I have the choice between using a speed pot+spec for mana vs. mana pot+spec for damage, I think the latter is going to work out better, provided I'm not still going oom on top of that.

Shandara · 03/19/09, 7:04 PM

As a note, I forgot to run the macro the build the melee drop-down lists. To do it manually, unhide the "Melee" tab and hit the "Classify" button at the top of the page, this should update the drop-down menus.

Boring · 03/19/09, 7:42 PM

Minor thing, but the "Level 80 Raid" buffset includes Superior Mana Oil. Didn't Blizzard make them unable to be applied to lvl 80 weapons like my Journey's End?

Shandara · 03/19/09, 8:46 PM

Originally Posted by Boring

Minor thing, but the "Level 80 Raid" buffset includes Superior Mana Oil. Didn't Blizzard make them unable to be applied to lvl 80 weapons like my Journey's End?

They did, I thought I'd turned it off but it must have regressed at some point.

Cattiebrie · 03/19/09, 11:25 PM

You probably left it in due to people using Savage Cobat Slicers early on, until they got nerfed.

Kharthus · 03/20/09, 1:41 AM

Judging by a lot of GCs comments about mana being more of an issue in Ulduar (they want it to actually matter), I'm guessing 7/13/51 may not work out so well.

Another interesting note, I'm seeing almost the exact same dps between 0/15/56 and 0/14/57. I'm more inclined to drop Aimed and get the last point in Hunting Party.