WotLK DPS spreadsheet - Page 151

baklava · 11/14/09, 11: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, 10: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, 11: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, 1: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/19/09, 12:53 AM

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, 8: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, 5: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/21/09, 12:04 AM

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, 1: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, 6: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, 8: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, 2: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, 4: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, 11: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, 2: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.

kabes · 11/23/09, 10:53 AM

If the trinket works like DMC Madness then it may even remove haste from the list of procs as Madness did for hunters.

Equip: Your ranged attacks have a 4% chance to cause you to instantly attack with this weapon for 50% weapon damage.

It looks like this averages out to giving you about 12 procs or 6 autoshots over a 6min fight. Procs are fun but I'm not sure how this compares to 3 passive stats instead.

Alduin · 11/23/09, 11:24 AM

Deathbringer's Will really seems to get interesting but in my opinion with the 155+600ARP proc it is worse than Mjolnir, with 155ARP+600Agi it is better than Death's Verdict. I hope it will have a class consideration/specc consideration/gear consideration (e.g. gemming for ARP or reaching the hardcap via gear + ARP procc seems to be able).

btw there are some new items
-ring with haste/arp ilvl 264 here
-same ring ilvl 251 here
-new gloves ilvl 264 here
-gloves with ARP and hit ilvl 251 here
-a bow ilvl 251 here
-waist ilvl 251 here

and some reserved positions
- crossbow #51802
- gun #51845, bow #51927
- crossbow #51940
- polearm at #51949 (just behind the 10man heroic ilvl277 axe so perhaps Lich King loot?)
- crossbow #50733
- bow #50638

Yes I know nothing confirmed etc. But I am pretty sure about it especially the "reserved" ones have new shiny icons and we should keep an eye on.

PS: Re-editing format.

Seoman · 11/23/09, 2:50 PM

I'm seeing Culling the Herd 3/3 in the Spreadsheet (which is still red-ed out on the Pet Talent page, btw) as a straight 3% damage buff to all shots except SrS. Is it supposed to apply to SrS as well?

Esoth had a "napkin math" post a while back (#3669) which seemed to show 83% uptime assuming a 20% pet crit rate and a 1.25 sec pet GCD. The spreadsheet seems to show 100% uptime for me, with a 21.01% pet crit chance buffed.

If 1/5 pet hits (20%) crit on average - once every 6.25 seconds (1.25 sec GCD x 5) - and the effect lasts for 10 seconds, 100% uptime seems reasonable since your pet would have to not crit for 8 hits for the buff to fall off. Possible of course, but unlikely on average. Is 100% right?

Shandara · 11/23/09, 6:59 PM

You are correct. Since the ability can refresh itself it's better to model it the way Esoth did, which is calculate the chance it will NOT refresh.

Esoth · 11/23/09, 9:06 PM

I'm not sure how much item correction you are planning on doing while it's still on the PTR, but here's a couple:
Toskk's Maximized Wristguards - the haste should be ArP, for heroic and regular
Scourge Hunter's Vambraces - same as above

Alarsonra · 11/25/09, 5:25 PM

For some reason the spread sheet is telling me needle-encrusted scorpion is a downgrade on the gear planner tab compared to mjolnir, which is clearly impossible since they have the same stats only the scorpion has more. In the calculations tab the sheet says the average Arp benefit is less even though it was the same calculate uptime. Maybe something is calculated wrong there.

kabes · 11/25/09, 5:59 PM

That's because it has a 10% chance to proc off crits, whereas mjolnir is a 15% chance to proc off any hit.

kabes · 11/26/09, 12:39 PM

We have a new trinket from 10 man ICC. The normal 251 version:

Whispering Fanged Skull
Binds when picked up
Unique: Whispering Fanged Skull (1)
Unique
Miscellaneous
Trinket
Requires Level 80
Item Level 251
Equip: Improves critical strike rating by 131.
Equip: When you deal damage you have a chance to gain 1100 attack power for 15 sec.

Whispering Fanged Skull - Items - Sigrie

Plugging this in with a 10% proc puts it above Mjolnir but below 245 Death's Choice.

Also if possible you might want to restrict people from equipping both the normal and heroic versions of this as it appears to be limited to one at a time. This is also the case for the two Deathbringer's Will trinkets.

dkobeb · 11/29/09, 12:40 AM

I am having trouble clearing the information that's already inserted in the spreadsheet, how can i clear it so that i can input my own information?

dvorjak · 11/30/09, 12:23 PM

Why does the spreadsheet assume that each ISS proc will be used by a Chimera Shot? Many time I will get ISS right after I fire my Chimera shot and the only alternative I have to to have my Aimed shot eat it or let my aimed shot sit there and fire off 5 steadies.