WotLK DPS spreadsheet - Page 251

baklava · 11/14/09, 10:53 AM

Originally Posted by sefren

The other day I decided to recheck my dps and fiddle around with the spreadsheet to see how certain talents would work for me. To my amazement it is now saying that dropping Arcane Shot from my rotation nets dps. The reason i say this is that I don't use an arp trinket, I don't gem arp and I have even specced into Arcane Shot. All this being said it still is telling me that Arcane Shot in the rotation is a dps loss. I looked over parses from some raid fights and its showing that Arcane hits for about 300-500 more on average than Steady Shot. Also the spec I'm checking out doesn't pick up IMP SS so I have no idea what is going on. Is there anything I'm overlooking or did Steady somehow miraculously beat out arcane shot at some gear level?

I have the same problem, normally in an encounter, I hit 6k to 7k with arcane shot critically, but spreadsheet says I can crit maximum as 5k. What could the reason be?

Rezdan · 11/15/09, 9:41 PM

There could be several reasons your Arcane Shot seems to be hitting for more. The first reason is that you're possibly using ISS procs on Arcane Shot and the second reason is that Procs are averaged in the spreadsheet. In a real raid setting though, you may see some bigger Arcane (or any other shot) hits than theorycrafted when multiple procs are up.

mistla · 11/16/09, 10:59 AM

Originally Posted by Whitefyst

With using the attackers level to determine the armor cap, we ignore the same amount of armor on a level 80 and level 83 target with the same base armor; however, since level 83 targets will tend on average to have higher amounts of armor than level 80 targets due to the higher armor constant, more of the armor on average level 83 targets will be unpenetratable.

Whitefyst, after going over the calculations in the spreadsheet and the wowwiki explanation of the armor pen cap, I believe you are correct.

I think the error is on wowwiki (resulting from an error in a blue post) indicating that the target level should be used in the calculation for the armor pen cap. This approach results in a higher armor pen cap (more armor penetrated) for a higher level target, which is just plain wrong.

It makes more sense that the attackers level is used in the calculation for determining the armor pen cap and that is exactly what the spreadsheet is doing. Thanks for clarifying.

Allara · 11/18/09, 12:59 AM

Just in case people are wanting to try it (the public beta opens soon), so far the spreadsheet appears to work just fine in Office 2010 Beta.

Zokathra · 11/18/09, 11:53 PM

This fix requires a minor change to two functions in the ArmoryImport module. If you are comfortable with VBA, you can make these changes yourself, but remember that downloading a new copy of the spreadsheet would remove this fix. At least until Shandara incorporates it, if at all.

Make the changes in red/blue below, replacing the blue proxy info with your own. Only include the SetProxyCredentials method if your proxy server requires authentication.

Function GetDataXLS(URL, searchterm)
    Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0")
    objXMLHTTP.SetProxy 2, "192.168.3.137:8080", "<local>"
    objXMLHTTP.Open "GET", URL, False
    objXMLHTTP.SetProxyCredentials "UserID", "Password"
...
Function GetSingleDataXLS(URL, searchterm)
    Set objXMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.4.0")
    objXMLHTTP.SetProxy 2, "192.168.3.137:8080", "<local>"
    objXMLHTTP.Open "GET", URL, False
    objXMLHTTP.SetProxyCredentials "UserID", "Password"

Please note that MSXML2.ServerXMLHTTP.3.0 does not support the SetProxy method. You must use MSXML2.ServerXMLHTTP.4.0 or later.

My suggestion for Shandara would be to add a proxy setting to the Settings tab and to use the info from there, if set, for the armory imports.

GwolfGarona · 11/19/09, 7:38 PM

Anything that uses the statusbar control (gear planner, gear optimizer, rotation test) is not working for me in Excel 2010 Beta

atuin · 11/20/09, 4:35 AM

Originally Posted by GwolfGarona

Anything that uses the statusbar control (gear planner, gear optimizer, rotation test) is not working for me in Excel 2010 Beta

Same situation for me - excel 2010 beta 64bit

From errors it looks that they changed few names of vbasic components in forms and thats causing problems. One of those is progress bar during DPS recalculation.

Base calculations work ok (atleast as far as i could check) - im geting same numbers in excel 2003 and 2010. Thers also no problem with reading data from armory

Allara · 11/20/09, 11:04 PM

I'm still using the 32-bit version of Excel 2010 Beta, and it's all working just fine (including the progress bar calculations). I'll try the 64-bit version later on. Seems odd that the VBA API would differ between the two.

Shandara · 11/21/09, 12:30 PM

I've started work on implementing the current PTR status:

- Added proxy settings to the settings tab. Only use if you have a version of Excel that supports ServerXMLHTTP 4.0. 
- Implemented Culling the herd
- Changed Wolverine Bite to proc on pet crits, 10s cd
- Added new ICC items, taken from Wowhead, need to check MMO.
- Added new crafted ammo
- Implemented Tier10 2-set/4-set bonuses. ASSUMED 45 sec ICD, NEEDS TESTING
- Adjusted cell width on Gear Planner because Blizzard keeps giving us longer and longer set names.

Notes:
- The proxy settings I can't test myself because I don't use a proxy. They basically implement what was posted earlier in this thread so hopefully they should work. Settings are stored in plain text so caveat emptor (well this is for free, but..).
- The tier10 bonuses have an assumed 45s ICD. Although with the 5% proc rate I'm not sure if there will be an ICD. This will need testing.
- Added a lot of ICC items using wowhead. Wrote some code to automagically import stuff but can't use the MMO-champion database because it doesn't provide XML feeds (or at least I could not find how to). If I missed any items, please PM/post. I'll scrounge manually over the MMO lists later on.

If I missed any hunter mechanic change please let me know too.

EDIT:
Re-uploaded. Added remaining items from MMO, weren't quite as many as I'd feared. Still missing a lot of heroic versions of items, though.

Farmbuyer · 11/21/09, 5:43 PM

Originally Posted by Dellimore

wondering, is it beneficial to stack 2 8.5 vs 4p t9, i didnt like the set bonus for T9 nearly as much as i like 2 piece t8

The set piece combination has probably been discussed somewhere, but "t8" and "t9" aren't valid terms for the forum search engine, so it's hard to tell for sure. Which is unfortunate, considering how they're the semi-official terms on the EJ forums.

Searching the hunter forums for "tier8 tier9" only shows hits in this very thread. If you point Google at this site, you might get hits on short terms like "t8 + t9", but I've only had occasional success with that trick. It's worth trying though.

There might also be notes or discussion or something in the actual spreadsheet, but I don't have Excel, so no clue there.

kabes · 11/21/09, 7:26 PM

Thanks Shandara. I'm a little surprised to see the new Deathbringer's Will trinket so low but I guess this is because of its chance to proc less helpful stats like haste and strength. Too bad.

I hope there doesn't end up being an ICD on the set bonuses. Seems very underwhelming.

Shandara · 11/22/09, 1:38 AM

Originally Posted by kabes

Thanks Shandara. I'm a little surprised to see the new Deathbringer's Will trinket so low but I guess this is because of its chance to proc less helpful stats like haste and strength. Too bad.

I hope there doesn't end up being an ICD on the set bonuses. Seems very underwhelming.

The new deathbringer trinket is missing the proc at the minute, because I forgot to implement it. Good catch. I recall seeing a post somewhere on what it did so once I find that again I'll add it.

Rivkah · 11/22/09, 3:33 AM

I found a thread on the proc here. I made an estimated implementation on my site with the proc assuming a cooldown of 90 seconds and a proc rate of 10%. I don't know what the actual proc rate and cooldown will be but those seem like reasonable guesses given a 30 second buff proc.

The heroic version was just slightly beating Death's Verdict non-heroic in my gear as SV, but as MM I saw a significant dps upgrade from the regular version versus the Death's Verdict non-heroic.

BTW there's also a new bow reported with a proc here.

alienangel · 11/22/09, 10:27 AM

I still haven't seen anyone confirming that the new Deathbringer's Will's procs can actually all occur for everyone - having it randomly proc STR for a hunter seems rather poor design. Although having one useless proc out of 6 isn't that bad, since shamans and some specs of DKs would find a different one of the procs useless too. Would be nice if had some logic in to prevent it proccing STR for hunters and rogues (and perhaps ArP for shamans or AGI for STR classes, although those aren't quite as useless as STR for hunters is)

The new bow just seems like it trades 3 green stats for passive haste which only affects your autoshots :/

Rivkah kindly added it to femaledwarf.com for comparison, but I can't find any other 255 DPS weapons to compare it to to evaluate the proc properly - it's only a 50ish DPS upgrade over BRK-1000 though, which seems to fit with the proc not being worth the passive loss of stats.

Repaxan · 11/22/09, 1:46 PM

Originally Posted by alienangel

I still haven't seen anyone confirming that the new Deathbringer's Will's procs can actually all occur for everyone - having it randomly proc STR for a hunter seems rather poor design. Although having one useless proc out of 6 isn't that bad, since shamans and some specs of DKs would find a different one of the procs useless too. Would be nice if had some logic in to prevent it proccing STR for hunters and rogues (and perhaps ArP for shamans or AGI for STR classes, although those aren't quite as useless as STR for hunters is)

If it's anything like DMC Madness was at 70, it'll take class into consideration when choosing a stat.