WotLK DPS spreadsheet - Page 213

Croto · 08/04/09, 9:52 AM

The Relentless Gladiator's Shotgun is incorrectly labeled as a Bow, throwing off the racial calculations for Trolls and Dwarves.

rageundersilk · 08/04/09, 11:42 AM

I am encountering an error using the latest version of your DPS spreadsheet Version 91a.

I am using Excel 2003. If this is the root of the issue, please let me know. As far as I know, spreadsheets are relatively backwards compatible.

The error occurs when I try to mouse over the "Load Gear from Armory" button on the "Gear" tab. The MS Visual Basic debugger comes up and two error messages are displayed. They are the same and say: "Compile Error: Automation Error".

The debugger highlights the Private Sub Worksheet_Change(ByVal Target As Excel.Range) function when this occurs.

Thank you. I appreciate your work on this spreadsheet.

• VRoscioli · 08/04/09, 11:54 AM

Would it be possible to add a check to the regemmer to check to see if the post-regemming DPS meets or exceeds the pre-regemming DPS, and if not it reverts to the previous gemming?

[e]: And the same with the gear planner, if possible.

Sedona · 08/04/09, 1:47 PM

Granted there isn't a lot on BM hunters these days. I am trying to figure out a new BM build for today's patch, but it seems that every time I spec into Catlike Reflexes that I lose DPS. From what I have read, CR was speculated to be a DPS increase. I cannot replicate any of these findings. Is there something I am missing with the spreadsheet?

tonic316 · 08/04/09, 2:56 PM

Is it just me or if you have mostly BiS gear the only upgrades are from hard mode loot (ilv258). At least thats what the spread sheet is showing.

Trickytrout · 08/04/09, 4:05 PM

Try using the new t9 2 pc bonus with the t8.5 2 pc. It's about a 400dps increase. Seems that it will be worth keeping the t8.5 helm and chest for the set bonus.

tonic316 · 08/04/09, 4:54 PM

Now I try using the optimizer and it throws in all 3.2 gear which boosts my dps from 7800 to 9800, but the gear planner shows all my current gear as better dps upgrades. I think my gear planner is messed up or something.

Ginbar002 · 08/04/09, 4:55 PM

Originally Posted by Sedona

Granted there isn't a lot on BM hunters these days. I am trying to figure out a new BM build for today's patch, but it seems that every time I spec into Catlike Reflexes that I lose DPS. From what I have read, CR was speculated to be a DPS increase. I cannot replicate any of these findings. Is there something I am missing with the spreadsheet?

I also noticed a "dps loss" when talenting into CR, ss showed a few hundred dps loss....curious to me that a talent intended to increase dps when specced, actually shows a loss?

I think maybe I'm missing something also, just not sure what.

Any thoughts out there?

• VRoscioli · 08/04/09, 5:09 PM

Originally Posted by Ginbar002

I also noticed a "dps loss" when talenting into CR, ss showed a few hundred dps loss....curious to me that a talent intended to increase dps when specced, actually shows a loss?

I think maybe I'm missing something also, just not sure what.

Any thoughts out there?

My guess is that since 3.2 causes pets to be expertise capped that the only DPS benefit of this talent is to provide a lower CD on Kill Command. It has previously been shown that in some cases where you go OOM and need to use Aspect of the Viper, the DPS lost from extra Viper time (from Kill Command) is actually greater than the DPS gain from Kill Command itself. Therefore, it is a net DPS increase to not use Kill Command if you have mana issues (in some cases).

tonic316 · 08/04/09, 5:10 PM

Anyone have any idea why gear planner shows everything as a dps downgrade, but when I equip the dps downgrade item my dps calculation goes up.

Esoth · 08/04/09, 8:26 PM

Originally Posted by VRoscioli

My guess is that since 3.2 causes pets to be expertise capped that the only DPS benefit of this talent is to provide a lower CD on Kill Command.

I think you're misreading the talent - it increases the dodge for you and your pet, not reduces the target's chance to dodge. Using kill command with Bestial Wrath up is also the best way to go, which means either 1 minute (plus a bit of wait time to go with longevity and the glyph) or 30 seconds. I don't think there's any reason to do anything other than 0/3 or 3/3 with that talent.

Ginbar002 · 08/05/09, 2:38 AM

Originally Posted by VRoscioli

My guess is that since 3.2 causes pets to be expertise capped that the only DPS benefit of this talent is to provide a lower CD on Kill Command. It has previously been shown that in some cases where you go OOM and need to use Aspect of the Viper, the DPS lost from extra Viper time (from Kill Command) is actually greater than the DPS gain from Kill Command itself. Therefore, it is a net DPS increase to not use Kill Command if you have mana issues (in some cases).

So assuming mana is not an issue, then the 3/3 CR specced should be a dps increase in theory; cd on KC is lowered to 30 secs, meaning more pet crit damage over the 3 attacks..

Maybe a setting on the SS could show this; like hawk always up or something?

TY for replies..

Ginbar

• VRoscioli · 08/05/09, 10:10 AM

Originally Posted by Ginbar002

Maybe a setting on the SS could show this; like hawk always up or something?

Aspect of the Dragonhawk/Aspect of the Viper uptime can be found on the Rotation Test tab.

nego · 08/05/09, 10:57 AM

Originally Posted by Shandara

Make sure you enable Dragon's Eyes on the settings tab (since you are a JC).

**** I got it****

• VRoscioli · 08/05/09, 11:03 AM

The most recent version of the spreadsheet does not appear to have Cuirass of Cruel Intent - Items - Sigrie (Horde) or Breastplate of Cruel Intent - Items - Sigrie (Alliance). Both drop from Northrend Beasts 25 (regular: iLevel 245).

[e]: Also, on the Custom Gear tab, there is nowhere to set iLevel, so the custom items don't get picked up by the gear planner unless you (1) set the iLevel threshold to 0; or (2) Go to that gear-type's sheet and manually enter the iLevel.