WotLK DPS spreadsheet - Page 7

Shandara · 09/02/08, 8:49 AM

Originally Posted by KraxisSingular

Shandara, whenever I set my own talents and I pick Bestial Wrath the total DPS doesn't go up, The Beast Within does give a litmited value (as does the Bestial Wrath glyph). That makes BM DPS slow to a relative halt.

Also with that glyph what is the cooldown for Bestial Wrath set to? 64 or 70 seconds?

The Glyph is applied first, then Longevity. So with 3/3 Longevity and the Glyph it'll be 70 seconds. (I believe this to be the 'intended' effect, which of course can be wrong in reality)

The Beast Within thing is a bug, apparently moving things about made it check the wrong talent (it was checking Invigoration).

Ravenfire · 09/02/08, 12:09 PM

Shandara,

Marked for Death and Imp. Steady Shot both got changed last patch. Marked for Death went back to its original 5% damage 10% crit damage for max, while Imp. Steady Shot is now 15% chance to proc a 30% bonus damage, 25% mana reduction on Arcane/Aimed/Chimera shot.

Edit: Both trinket gem slot #2 are broken and only have one option (don't even have the option of selecting "none").

Edit #2: On the buffs tab. Selecting zero buffs causes incorrect calculations in the "Haste" column which results in "#DIV/0!" errors all over the place. More specifically, both you and your pet must have Windfury Totem and Swift Retribution set to "YES" to be able to get anything other then the divide by 0 error.

Shandara · 09/02/08, 12:31 PM

Originally Posted by Ravenfire

Shandara,

Marked for Death and Imp. Steady Shot both got changed last patch. Marked for Death went back to its original 5% damage 10% crit damage for max, while Imp. Steady Shot is now 15% chance to proc a 30% bonus damage, 25% mana reduction on Arcane/Aimed/Chimera shot.

Edit: Both trinket gem slot #2 are broken and only have one option (don't even have the option of selecting "none").

Trinkets aren't broken, I just uploaded the sheet without re-enabling automatic updates for the cells, so the code that puts in the right gems does nothing. Blame me.. I should have an update later this evening which fixes it.

Small update:

- Bestial Wrath talent now properly activates and deactivates based on the right talent point
- Marked for Death back to 1/2/3/4/5% damage instead of 2/4/6/8/10%
- Improved Steady shot now a 30% damage bonus and 25% mana reduction (from 15% damage, 40% mana)
- Fixed Haste bug when there are no buffs
- Trinket slots should work now

Ravenfire · 09/02/08, 3:29 PM

Shandara,

I apologize. I logged on during lunch and noticed I am wrong on the Imp. Steady Shot change, you'll need to revert it back to 15% damage and 40% mana. Also, ATM Marked for Death is currently bugged, it grants 2/4/6/8/(5!!)% and 2/4/6/8/10%. I'd leave it as you have it at the moment since there is no telling which it will end up as. Sorry for making you do extra work.

Ebonleaf · 09/02/08, 4:49 PM

Couple things. First thanks for trying to pick up the spreadsheet.

When i do an armory grab and my gear overwrites yours, it still keeps the slots for the trinket, applying them to my DST, instead of removing the option for them.

Also I noticed in the shot rotation tab is has chimera lists as the top option in fire order, even when you spec BM for 51, which as you know wouldn't allow you to actually have chimera shot. It still applies the DPS and everything else as if the shot were still available.

Shandara · 09/02/08, 5:24 PM

Originally Posted by Ebonleaf

Couple things. First thanks for trying to pick up the spreadsheet.

When i do an armory grab and my gear overwrites yours, it still keeps the slots for the trinket, applying them to my DST, instead of removing the option for them.

Also I noticed in the shot rotation tab is has chimera lists as the top option in fire order, even when you spec BM for 51, which as you know wouldn't allow you to actually have chimera shot. It still applies the DPS and everything else as if the shot were still available.

The trinket thing is a bug I'll look in. Unfortunately I know that it doesn't update the shot priority list if you change specs or load from armory. I haven't found a way yet to dynamically change the validation lists involved with it so you'll have to re-do it manually every time you make a big change (it's only 4-5 shots anyway so it's not that onerous).

Still, I have some ideas about it, but it's not straightforward.

Cranch · 09/02/08, 7:28 PM

Probably the easiest thing to do is just have 3 shot rotations available to choose from, and a button underneath them to choose one. Then you can make them different based on talent, or just experiment with different rotations with the same talent. A little note that says you don't check the shot rotation against the talents would be good enough for me.

Indora · 09/03/08, 12:51 PM

Sorry for taking so much time to look through the Shot Rotation tab, our "Schützenfest" distracted me (It's comparable to the Oktoberfest).

Sadly, I wasn't able to find a lot of things

Calculations!N168 should be duration / frequency, not vice versa
Shot Rotation!O.. The frequency is limited by 1.7 I think 1.5 + CastLag may be a better idea
Shot Rotation!T.. It shouldn't be possible to have 3 Stings, simply change the cells to =IF(..;..;T(row-1))
Shot Rotation!U.. While Serpent Sting is refreshed, it results DpM instead of DpS (doesn't have any impact though)
Pet Calculations!F30 should use CrittingShotsPerSecond
Pet Calculations!I57 what about resists / crits with spell-specials?
Pet Calculations!L22 Misschance doesn't decreases the critchance of your pet
Pet Calculations!L38 will be 2% in WotLK

Ravenfire · 09/03/08, 1:13 PM

Shandara,

Some Dwarf base stats for you. I'm only posting the stats I am 100% sure on.

lvl 73
str 69
agil 156
sta 117
base mana 3882

lvl 74
str 70
agil 159
sta 119
int 81
spi 88
base health 3934
base mana 4018

lvl 75
str 71
agil 162
sta 121
int 82
spi 89
base health 4061
base mana 4200

lvl 76
str 72
agil 165
sta 123
int 83
spi 90
base health 4189
base mana 4381

Your intellect number of 131 at level 80 seems like a typo (matches the stamina value) as i just don't see us gaining 48base intellect going from level 76 to 80.

NOTE: I stripped and detalented at lvl 76. I also recorded the values gained from leveling from 74 to 75 and from 75 to 76 and as such simply subtracted those numbers from the lvl 76 values to obtain accurate vales that matched my calculated values (wowwiki formulas for base stats). At lvl 73 I am only sure on str, agil, and stam. I originally had lvl 73 as having 81 int but that would mean a gain of 0 intellect going from 73 to 74. The base mana I am sure on because i made it a point to calculate what my mana cost was for specific abilities and it matches perfectly with all the tooltips in game.

EDIT: not sure why I didn't put these in to start with...
lvl 75 ding granted:
1 str, 3 agil, 2 sta, 1 int, 1 spi, 127 health, 182 mana

lvl 76 ding granted:
1 str, 3 agil, 2 sta, 1 int, 1 spi, 128 health, 181 mana

I am starting to suspect that whom ever originally gave you the level 80 dwarf stats gave you some bad/incorrect numbers...

Shandara · 09/03/08, 6:25 PM

Thanks for the notices.

@Indora:
The magical damage adjustment shouldn't include because every magical pet skill currently does the resist/crit checks themselves, so the number 'Adjustment for Magic' is just all the bonus talents, excluding pet critical strike bonus damage and resist chances.

@Ravenfire:
Judging from the stat increases on leveling, it seems to be fairly linear (differences probably in rounding errors).

Update:

- Misc bug fixes and some more dwarf base stats
- Serpent Sting uptime now is duration/frequency instead of vice-versa
- Blood Frenzy changed to +2% physical damage (down from 4%)

Should hopefully have addressed the issues Indorra brought up.

Chul · 09/04/08, 2:40 AM

Was reading WoWhead comments for Chimera Shot and noticed this comment:

An Interesting thing is that while the 125% of weapon damage is reduced by Armor, the 40% of Serpent Sting isn't, so this essentially ignores 30% of Armor Reduction....

(Bold mine)

Looking at your spreadsheet, I didn't see where you adjusted the weapon damage for armour.

Shandara · 09/04/08, 2:45 AM

I was under the impression that Chimera Shot ignored armor completely. Did they fix the base damage to deal physical damage now?

KraxisSingular · 09/04/08, 7:56 AM

Originally Posted by Shandara

I was under the impression that Chimera Shot ignored armor completely. Did they fix the base damage to deal physical damage now?

I believe it was just a bug from the combination of the Chimera part and the sting part. Just like stings removed all armor on targets. In any case, 125% weapon damage plus 40% sting damage as nature is a pretty hefty ability.

Dedmon · 09/04/08, 9:19 AM

Just wanted to add my thanks also. Keep up the good work!

muwatallis · 09/04/08, 10:14 AM

Thank you for beginning this work. Just some small details that took my attention:

- Improved Arcane Shot is still 5/5, should be 3/3 and the new 15% ArS damage increase.
- The second talent point of Hunting Party is missing, it goes like 0/1/3/4/5
- The currently known glyphs are missing.

Maybe you are working on these already, just wanted to remind.