WotLK DPS spreadsheet - Page 140

areomas · 09/02/09, 11:20 AM

The stats for this item on the spreadsheet don't match the ingame stats. [Cuirass of Calamitous Fate]

Shandara · 09/02/09, 11:58 AM

Originally Posted by Kharthus

Minor regemmer issue:

Running regemmer results in 5dps less than the gems I currently have. Couldn't find the post where you walked thru the logic it uses so I'm not sure if this is something that is easy to fix or even worth fixing.

The problem arises from the fact it puts a yellow +hit/+agi gem in your legs, but later on it doesn't take the socket bonus. So it overvalues the yellow socket in your legs. It should put that +hit/+agi gem in your weapon instead. I'll have this fixed for the next version.

Mr Tazza · 09/02/09, 9:34 PM

Since ArP is apparently getting nerfed on PTR, would it be possible to get a PTR version of the sheet with the new values?

http://elitistjerks.com/f31/t29453-c...1/#post1371248 for numbers.

Murgli · 09/03/09, 4:41 AM

Hi Shandara,

the infused dreadstone comes up with 15stamina and MP5, but it should be 20AP and MP5.

There seems to be not many BM Hunters here

Absolut graet work your sheet! Thank's a lot for your work.

Shandara · 09/03/09, 4:29 PM

Originally Posted by moondo

My question is: in the gear planner section most of my items are given a green suggestion to regem. The thing though, is I can't for the life of me figure out what regem option would translate into an actual dps upgrade. Is there a section in the spreadsheet that I'm not looking at that tells me what the regemming suggestions are? Or are we to figure out this by ourselves and just be thankful for the fact that it was even pointed out that we need regemming?
/btw, thanks a million for the spreadsheet!

You click the button conveniently labeled 'Regem' on the Gear tab.

Lactose · 09/03/09, 11:32 PM

Spelling error:
Sylvanas' Cunning listed as Silvanas' Cunning in spreadsheet.

Meylos · 09/04/09, 1:16 AM

Any plans on adding the new Relentless pvp gear in the next update?

Tsook · 09/04/09, 12:55 PM

[Attrition] should be marked 25-man.
[Shoulderpads of the Intruder] should be marked 25-man.

[Pauldrons of the Devourer] should not be marked 25-man.

Thorinson · 09/04/09, 2:30 PM

I would like to know what the general consensus is on using the Rotation Test vs. using calculated frequencies.

I'm asking this because I used to turn the Rotation Test off because I think I once read a statement from Shandara saying that it should be within 1% of the calculated frequencies. So I never really bothered. I did bother this week and found the results of the Rotation Test to differ quite a bit from the calculated frequencies.

When I use the Rotation Test for my SV spec it estimates the DPS to be ~300 lower than with the calculated frequencies. The opposite happens when I use the Rotation Test for my MM spec; it estimates it to be ~200 higher than with the calculated frequencies.

This makes it hard to compare SV with MM: the outcome depends completely on whether or not I should use the Rotation Test.

Any thoughts?

Shandara · 09/04/09, 3:58 PM

Update:

- Added cuirass/vest of calamitous fate normal versions
- Corrected steel bladebreaker itemID
- Small change to iAoTH calculations in the rotation test
- Small logic change to regemmer
- Sylvanas' Cunning spelling corrected
- Infused Dreadstone now gives +20 AP instead of +15 Stamina
- Loading a talent spec now also runs the rotation test if it's enabled
- Hand Adjust values are now saved with profiles, includes pet and target adjustments from the Buffs tab as well.
- Exporting/Importing on the overview tab will now also store/load the current information in the sheet (rather than only saved profiles).
- Overview tab now has a box for globally adjusting certain things like Critical Strike Damage Bonus, Haste%, Physical Damage modifier, etc.. These are all applied at the very end of the calculations, representing certain boss buffs/debuffs.
- Default L&L proc chance now 20%, adjust down on Settings tab if you desire so
- Armory import will auto-detect professions and level now
- Added Runic Mana Injector and made Engineering increase the effect by 25%
- Removed the warning box about rotation test from the load profile button macro

allanonxi · 09/04/09, 5:16 PM

In spreadsheet version 91g, under the shot rotation tab, the Kill Shot low hp gain box is not populating resulting in a difference of over 100 dps from the previous version of the spreadsheet 91f. Yes, I do have kill shot in my rotation.

I am not sure if this has been already addressed, but when I load my profile from armory it always shows I am using frostbite bullets when I know I have mammoth cutters.

Shandara · 09/04/09, 5:36 PM

Originally Posted by allanonxi

In spreadsheet version 91g, under the shot rotation tab, the Kill Shot low hp gain box is not populating resulting in a difference of over 100 dps from the previous version of the spreadsheet 91f. Yes, I do have kill shot in my rotation.

I am not sure if this has been already addressed, but when I load my profile from armory it always shows I am using frostbite bullets when I know I have mammoth cutters.

The Kill Shot Low HP gain box should never be visible, unless you:
a) Aren't using the rotation test AND
b) don't have Kill Shot in your rotation AND
c) have the appropriate boss hp% set on the settings tab

The ammo issue is a quick hack fix (it's been like that for a bit). It's purely cosmetic since ammo type doesn't matter.

Lactose · 09/04/09, 5:58 PM

Originally Posted by Shandara

The ammo issue is a quick hack fix (it's been like that for a bit). It's purely cosmetic since ammo type doesn't matter.

The issue is that ammo DPS does matter. Loading my gear from a fresh download sets ammo to Frostbite Bullets, and Total DPS to 8221,38. Swapping to the ammo I actually use (Saronite Razorheads) increases Total DPS to 8352,90.

Would expect that loading gear from armory would select correct ammo DPS (correct ammo type isn't as important), and if this is not possible, would expect ammo to remain unchanged, cleared, or set to a (user defined?) default value.

Beattamer · 09/04/09, 6:51 PM

In the latest version of the spreadsheet, the pet tab isn't functioning correctly.

Whenever I change my pet type from Wolf to Cat and attempt to change his skill rotation, the only option I can see is "Bite."

Shandara · 09/04/09, 7:33 PM

Re-uploaded v91g, fixing both issues hopefully.

Lactose · 09/04/09, 8:36 PM

Spreadsheet damage range for [The Diplomat] (Heroic) seems to be incorrect compared to live stats.
Damage range on live seems to be 419-719 (2.8 speed, 203.2 DPS).

Note that this seems like a Blizzard itemization bug, since I'd expect the stats to be identical to [Widebarrel Flintlock] (Heroic), but this is currently not the case.

EDIT: There is also a bug with faction settings for these weapons.

				Currently		Should be
Widebarrel Flintlock		Horde			Horde
Widebarrel Flintlock (H)	Alliance		Horde
The Diplomat			Alliance		Alliance
The Diplomat (H)		Horde			Alliance

Neruse · 09/04/09, 10:52 PM

The ArP nerf has been confirmed, specific values: http://elitistjerks.com/f31/t29453-c...1/#post1371053

As well, Mortal Shots is supposed to affect the crit damage of Serpent Sting with 2pc T9 but this isn't the case with the spreadsheet, currently.

akbinhil · 09/05/09, 3:20 AM

I broke the spreadsheet. I do calc attributes, and now it says 0 for ArP. I didn't even mess with anything after downloading the new one except hand-adjusting. Hmmm

Whalehunt · 09/05/09, 5:19 AM

I heard that [Death's Verdict] and [Darkmoon Card: Greatness] always activate same time. How about including such effect into calculation tab.

NarzulHF · 09/05/09, 7:07 AM

Hello Shandara.

Thanks a million for the spreadsheet.

I am a BM hunter with the conventional gemming of +ap \ +ap & +stam \ +ap & +crit (all epic). The "Regem" function swaps all of my +ap with +agi gems. Also, it puts pure +20 agi gems in blue sockets.

Might be worth mentioning that after swapping all of my +ap gems (420 ap) with their +agi counterparts (210 agi), there is less then 1 overall dps loss from my normal gemming.

snail · 09/05/09, 10:30 AM

Originally Posted by NarzulHF

Hello Shandara.

Thanks a million for the spreadsheet.

I am a BM hunter with the conventional gemming of +ap \ +ap & +stam \ +ap & +crit (all epic). The "Regem" function swaps all of my +ap with +agi gems. Also, it puts pure +20 agi gems in blue sockets.

Might be worth mentioning that after swapping all of my +ap gems (420 ap) with their +agi counterparts (210 agi), there is less then 1 overall dps loss from my normal gemming.

In the settings tab you can change the regemming options for different coloured slots based on what your preferences are. The preset defaults are for agility gems.

NarzulHF · 09/05/09, 1:25 PM

Thanks, didn't notice it.

However, Excel tells me the sheet is protected when I try to make the adjustments.

Trickytrout · 09/05/09, 2:34 PM

Use the column to the right and use the custom settings option.

Shandara · 09/05/09, 2:48 PM

Update:

- ArP nerf: Now takes 13,9957 ArP per %
- Mortal Shots now affects T9 2-set bonus

These are PTR stats, the previous version can be found via the link on the first page. As more PTR changes pop up I'll make changes to this version.

NarzulHF · 09/05/09, 7:32 PM

Originally Posted by Trickytrout

Use the column to the right and use the custom settings option.

Thanks.

Regem still puts red gems in blue sockets. Also the less then 1 dps difference between +agi to +ap gems for a BM hunter is very weird.