WotLK DPS spreadsheet - Page 114

Shandara · 02/25/09, 12:00 PM

Originally Posted by ankah

Maybe it's just me and something I am doing wrong, but this newest version of the spreadsheet is not adding any dps for Kill shot, or aspect of the hawk

As long as Kill Shot is in your rotation the extra dps it provides sub-20% is automatically calculated and added.

I'm not sure what you mean with aspect of the hawk not adding dps though. It is properly giving the extra AP and with improved aspect of the Hawk is properly giving the auto-shot dps increase.

ankah · 02/25/09, 12:05 PM

Originally Posted by Shandara

As long as Kill Shot is in your rotation the extra dps it provides sub-20% is automatically calculated and added.

I'm not sure what you mean with aspect of the hawk not adding dps though. It is properly giving the extra AP and with improved aspect of the Hawk is properly giving the auto-shot dps increase.

Maybe its just my puter playing mind games with me, but on the talents page, it does not add or subtract dps with improved aspect of the hawk (I think I was not very detailed at first, my apologies).

I see what you mean about kill shot, and it is being calculated on the over all dps. I did not see it past timed used, so I thought it was not calculating properly, my apologies again.

Sartuk · 02/25/09, 12:09 PM

Originally Posted by Gaj

I'm doing something seriously wrong then. With close to the BiS surv gear, last night I only hit 4313 on Patch (2.37min kill). This isn't even close to what I can model on the Spreadsheet. Not trap dancing and manually weaving shots.

The biggest thing I'm noticing is the lack of non-Explosive/Serpent Sting special shots you fired. While your guild's Patch time was definitely short (and obviously affected the number of specials you could get off) you only fired a combined 22 Steadies/Multishots. In a 3.24 minute Patch last night, for example, I fired a combined 75 Steady/Aimed shots. While I'm not digging too deep into your WWS, it seems like you're having a *lot* of open time where you could be fitting in more multishots or at the very least more Steadies. For some reference here's the WWS

thehittmann1981 · 02/25/09, 12:27 PM

Originally Posted by Sartuk

The biggest thing I'm noticing is the lack of non-Explosive/Serpent Sting special shots you fired. While your guild's Patch time was definitely short (and obviously affected the number of specials you could get off) you only fired a combined 22 Steadies/Multishots. In a 3.24 minute Patch last night, for example, I fired a combined 75 Steady/Aimed shots. While I'm not digging too deep into your WWS, it seems like you're having a *lot* of open time where you could be fitting in more multishots or at the very least more Steadies. For some reference here's the WWS

Yep i noted same plus a whole lot more missing buffs / debuffs etc, sent PM Gaj

Bokomatic · 02/26/09, 4:59 AM

Two day ago I found new sevice at wowhead.com
It's Stat Weighting tool, curently in beta state.
There is a possibility to import there Shandara's weights and next browse top gear by wowhead interface.

I added wowhead-url generating feature in my shandara-postprocessor.
New version available here: PawnSplitter_v13.zip

It generates urls like these: Boko without hitcap and Boko hitcapped.
Clicking to scale values in these pages you can change normalization modes: autonormalized, not normalized and percent normalization.
For seeing numbers corresponding Shandara spreadsheet you should set up not normalized mode.

Kom · 02/26/09, 8:22 AM

Couple things:
Wild Hunt - atm its broken on PTR, doesn't do anything. But I'd imagine its 40% more than the current amount, not the current amount plus an additional 40%. As you can see by the default settings on the latest version it's giving 800 dps per pet talent point.

EDIT: seems wild hunt not working for me on PTR was a display bug. ignore this point I guess, nerf inc tho!

LnL - Late here, going to have trouble explaining this, but by my calculations the most accurate figure you can give shots replaced for LnL is 1.5 (no interleaving). Currently the spreadsheet only offers 1/2/3. I'll try do a diagram...

First row is without LnL procs, second is with.
X = explosive shot
- = filler

X---X---X---X---X---X---X---X---X---X---X
XXX---X---X---X---X---X---X---X---X---XXX

or more simply (2consecutive procs)

X---X---X
XXX---XXX

So your gaining 3 explosive shots from 2 procs. So 1.5 shots replaced every proc. Of course this is neglecting the fact the player will likely wait another 0.1 seconds before firing to ensure the final tick goes off... but thats probably beyond whats necessary.

Shandara · 02/26/09, 12:09 PM

Update:

- Fixed prismatic sockets dropdown menus
- Furious Howl now stacks with other AP buffs
- Furious Howl now 40 sec cooldown and (level*2-2)*2 AP bonus (i.e. double from before)
- Thunderstomp now a Tenacity pet talent, Pummel new Gorilla family skill
- Shark Attack now 3/6%
- Some profile fixes - don't count on previous ones loading correctly for the time being, sorry

Furious currently bugged on the PTR in that it only affects the pet, but I'm pretty sure that at least will get fixed. Level 80 Wolf gives +316 AP as per the formula above.

With all the changes going on profiles are a bit iffy. You can try importing and loading your old profile but don't count on it working correctly while I'm doing all these PTR releases.

Mikari · 02/26/09, 12:13 PM

Is it possible for you to make the spreadsheet use the system internet settings for connecting? I use a proxy server and the spreadsheet tries to connect directly so I can't use the armory feature, having to add my gear manually each time there's a change that breaks compatibility with older save files is getting quite time consuming.

Shandara · 02/26/09, 12:32 PM

Originally Posted by Mikari

Is it possible for you to make the spreadsheet use the system internet settings for connecting? I use a proxy server and the spreadsheet tries to connect directly so I can't use the armory feature, having to add my gear manually each time there's a change that breaks compatibility with older save files is getting quite time consuming.

I'll see what I can do, I'm not sure how Excel handles it actually. If anyone knows, PM me please. In the meantime I'll read up on it.

EDIT:
After some searching I turned up the following article:
VBA: WinHttpRequest with Login and Password - Misc Bloglines

One of the comments mentions that you need to use a Windows provided utility to set the proxy for all programs that use the standard windows http-request API, which Excel should use as far as I know.

From the article:

I found what I was looking for: you can use the Windows ‘Proxy Configuration tool’ (C:\windows\system32\proxycfg.exe) to set the proxy information for WinHttpRequest (I found a posting on a talkaboutsoftware.com forum)!

Using the command “proxycfg.exe -u” will set the current user’s Internet Explorer proxy settings for use by any application that uses WinHttpRequest! Woo hoo!

I tried this already and it works like a charm with Excel 2000 on Windows XP!

I have not (yet) found any way to set proxy settings from within Excel.

Komarm · 02/26/09, 1:17 PM

Originally Posted by Shandara

I'll see what I can do, I'm not sure how Excel handles it actually. If anyone knows, PM me please. In the meantime I'll read up on it.

EDIT:
After some searching I turned up the following article:
VBA: WinHttpRequest with Login and Password - Misc Bloglines

One of the comments mentions that you need to use a Windows provided utility to set the proxy for all programs that use the standard windows http-request API, which Excel should use as far as I know.

From the article:

I have not (yet) found any way to set proxy settings from within Excel.

Just tried that on my work PC, the proxy has been my bane with the spreadsheet for some time forcing me to manually add in gear and talents, and it work perfectly. I was able load everything from the armory, it used to error out and go to an Excel debug screen. Thank you for the great work on the spreadsheet.

** edit, ignore DIV/0 error report, working fine now***

Danzou · 02/26/09, 2:59 PM

I have a question. On the spreadsheet there is something fuzzy with the cast of rapid fire. As it is now on the ptr it does not procc GCD but it is still afflicted by it.

Here on the Screenshot you can see Start cast 1.6, Cast end 1.7. But then you see Start cast on Serpent Sting on 3.2.

As Rapid fire does not procc GCD should not the Serpent sting start cast on 1.7?

Hope someone can help me with this one.

Eraist · 02/26/09, 3:27 PM

Originally Posted by Gaj

I'm doing something seriously wrong then. With close to the BiS surv gear, last night I only hit 4313 on Patch (2.37min kill). This isn't even close to what I can model on the Spreadsheet. Not trap dancing and manually weaving shots.

I'm kinda in the same boat. I think I'm doing everything right. Right shot rotation, new macros, keeping up the stings, and ES. KC in macro to keep it up. Marking target, pet commands on auto. 8% hit capped, all AGI gems and enchants. 6/14/51 spec.

My DPS is just slightly better than last week on Patchwerk, 4666 this week, but no where near what I'm seeing in WWS for other people with the same or equal gear. 5700-6100 DPS is what I'm seeing, just not sure how they are getting those numbers without Trap dancing.

Methical · 02/26/09, 3:44 PM

RNG guys. Is your crit rate on every shot the same as the WWS you're comparing to? I myself have yet to have a Patchwerk kill where my crit was anywhere near where it should be.

Eraist · 02/26/09, 4:01 PM

Originally Posted by Methical

RNG guys. Is your crit rate on every shot the same as the WWS you're comparing to? I myself have yet to have a Patchwerk kill where my crit was anywhere near where it should be.

I randomly chose a couple hunters to compare. I don't know either of these guys or guilds.

WWS
Wow Web Stats
Armory
The World of Warcraft Armory

WWS
Wow Web Stats

Armory
The World of Warcraft Armory

Mine
WWS
Wow Web Stats

Armory
The World of Warcraft Armory

Gear is pretty close, specs vary slightly, but overall it's relatively close.

Now if you look at the overall damage, I did more than both, but their DPS was much higher than mine. They both have 3% more crit, but I cannot see that meaning 700-800 more DPS.

I'm just trying to figure out why their avg DPS is higher.

Gutchewa · 02/26/09, 4:08 PM

Originally Posted by Eraist

I'm just trying to figure out why their avg DPS is higher.

The length of the fight is the reason your dps is lower, 1m52s to your 3m10s.