WotLK DPS spreadsheet - Page 285

llwynog · 04/22/10, 10:58 AM

im currently seeing windrunners heartseeker (normal) and twig of nordrassil (normal) as upgrades over zod's (normal) and distant land (normal), does that pan out the same for other people or have i just set something up dodgy? slightly makes sense looking at the stat weights but id rather be sure.

UnstableFluxx · 04/22/10, 12:43 PM

Originally Posted by UnstableFluxx

Looking at my profile quick on Female dwarf my stat values are as follows:
- Agility: 1.995
- Arm Pen: 1.622
- Haste: 1.178

Distant Land (Gemmed 2x Delicate ruby, +110AP enchant):
Agility - 186 (371.07)
Haste - 108 (127.224)
Value: 498.294

Tainted Twig (Gemmed 1x Deadly Ametrine, 1x Delicate ruby, +6 agil bonus, +110AP enchant):
Agility - 173 (345.135)
ArmPen - 90 (145.98)
Value: 491.115

So according to Femaledwarf, these two items are nearly identical for me.

Keep in mind, that spreadsheets do inflate the value of Haste some because they are modeled in a perfect world where you never have to move. For me personally as an SV hunter I would still want Tainted twig over Distant Land. The Armpen on Twig has more of an effect than the haste on DL (For Aimshot/SS with SS glyph) because of the amount of movement in ICC. For MM its no question you want Twig over Distant Land (why an MM would want DL is also beyond me). As far as the bows go, it really depends. Since ES doesn't scale with weapon damage I could see gaining the passive stats from Windrunner as a slight dps advantage for increased AP/Crit for ES. For MM you still want Zod's since the MM shots scale with weapon damage very well. The small bow dps increase from Windrunner's to Zod's is still better than passive stats from what I've seen via the spreadsheet in my testing for MM.

Hagen · 04/23/10, 4:37 AM

Don't forget that MM also scales better with weapon speed. The slower speed makes Windrunner's better than Zod's.
At least that is the case for me, but I doubt that I'm alone with this.

UnstableFluxx · 04/23/10, 9:18 AM

Originally Posted by Hagen

Don't forget that MM also scales better with weapon speed. The slower speed makes Windrunner's better than Zod's.
At least that is the case for me, but I doubt that I'm alone with this.

I thought that with the normalization of our attacks that the factor speed played into it was severly diminished? Or am I misinterpruting this?

Esoth · 04/23/10, 11:16 AM

For aimed and chimera, only the AP bonus are normalized to 2.8. The weapon and ammo damage are not.

AnthonyB · 04/27/10, 4:00 AM

Was curious as to why the spreadsheet rates the (normal mode) Saurfang's Cold-Forged Band over Band of the Bone Colossus

Saurfang's Cold-Forged Band
+72 Agility
+70 Stamina
Yellow Socket
Socket Bonus: +8 Attack Power
Item Level 251
Equip: Improves haste rating by 45 (1.37% @ L80).
Equip: Increases attack power by 114.
Equip: Increases your armor penetration rating by 53 (3.79% @ L80).

Band of the Bone Colossus
+90 Agility
+90 Stamina
Yellow Socket
Socket Bonus: +4 Agility
Item Level 264
Equip: Improves hit rating by 54 (1.65% @ L80).
Equip: Improves haste rating by 57 (1.74% @ L80).
Equip: Increases attack power by 105.

Thelegend · 04/27/10, 4:14 AM

If you are already a the hit cap then there are potentially 54 wasted rating points (in DPS and therefore rating terms) on the Band of the Bone Colossus.

To my knowledge the spreadsheet doesn't yet offset lost hit rating for un-equipping a particular ring.

Allara · 04/29/10, 3:13 PM

Microsoft Office 2010 has been released (available to MSDN/TechNet at the moment). Using the RTM build, I receive the following errors when clicking Recalculate DPS (93i). This is the 64-bit build -- I'm not sure if they changed anything in the VBA system. I believe some 32-bit users of 2010 beta were mentioning this issue as well.

kabes · 05/01/10, 10:12 AM

Originally Posted by Allara

Microsoft Office 2010 has been released (available to MSDN/TechNet at the moment). Using the RTM build, I receive the following errors when clicking Recalculate DPS (93i). This is the 64-bit build -- I'm not sure if they changed anything in the VBA system. I believe some 32-bit users of 2010 beta were mentioning this issue as well.

You can disable the progress bar in the settings tab.

Allara · 05/01/10, 3:00 PM

Originally Posted by kabes

You can disable the progress bar in the settings tab.

It's a compile error. Disabling the progress bar does not solve the problem.

ZobbL · 05/02/10, 3:05 PM

I hope i'm allowed to ask something about femaledwarf.com

It's not a specfic femaledwarf question, but im using it more often than the other. I know that stat weights for haste are not really representative, but it says, that haste has the highest stat weight after hit (focused aim 2/3)
it's not a big difference between agility and haste, but im still wondering why these are meant to be my stat weights.

Rivkah · 05/02/10, 4:16 PM

There is actually a separate thread for femaledwarf.com (under Hunter DPS Analyzer) but since this is a problem which can pop up just as easily on the Excel spreadsheet I'll respond here. Usually when you have an extremely high haste stat weight, this is caused by your shot breakdown being in a temporary haste rut which causes small increases in haste to have a higher dps value than they would normally, since they shift your shots around in such a way as to gain significant dps. It won't necessarily translate into the same results in game however since chances are your shots won't work out exactly the same in game.

Haste in general is hard to model accurately as it has somewhat of a stairstep effect (you don't really see significant gain till you gain an extra shot from it, then it shoots up in value), not to mention that in a movement fight you're going to lose some shots affected by haste which reduces its value. So any automated tool will generally overvalue haste and you should take those values with a grain of salt. Settings such as latency, wait time and your current haste values will factor into whether you hit these kind of haste ruts as well.

Ayn · 05/03/10, 4:05 PM

Distand Land (H) is missing in the spreadsheet.

Also, how do I tell the Regem tool to use ArP gems if they yield higher dps than Agi? When I change the default setting for DPS to Arp Gems, the regemmer starts using Shifting Dreadstones in blue sockets.

Shandara · 05/04/10, 7:43 AM

Originally Posted by Ayn

Distand Land (H) is missing in the spreadsheet.

Also, how do I tell the Regem tool to use ArP gems if they yield higher dps than Agi? When I change the default setting for DPS to Arp Gems, the regemmer starts using Shifting Dreadstones in blue sockets.

This was a bug, I have fixed in the new version:

- Plague-soaked Leather Leggings stats (normal and heroic) corrected per Armory
- Njordnar -> Njorndar
- Handgrips of Frost and Sleet/Scourge Stranglers, heroic versions now marked as such for gear planner
- removed PTR tag for Ferocious inspiration changes, now always on
- Serpent Sting crit damage bonus changed to 100% base
- Added distant land (h) to gear drop down menu
- Fixed bug with regemmer involving ArP gems and shifting dreadstones

mako · 05/04/10, 10:33 AM

The spreadsheet version available for download right now has not been updated to 93j. (i.e. no distant land (H), nor are the update notes present).