WotLK DPS spreadsheet - Page 20

Tynobu · 11/02/08, 11:30 AM

Originally Posted by samfisher

Hmm? I think I still get my Food buff, I just never get my Scroll buff. Will check again next raid.

Yeah, your Food buff will stack with those other buffs from players. It's just your scroll buff that goes away.

Food and Scrolls stack
Food and other player buffs stack.

Scrolls and other player buffs do not stack.

samfisher · 11/03/08, 2:16 AM

Ah ok thanks for the clarification.

Ravenfire · 11/03/08, 1:50 PM

Shandara, any chance you could add Darkmoon Card: Greatness to the sheet? The comments seem to have reasonable information on its internal cooldown though the spell details show a 35% chance to proc, instead of the 100% the comments hint at.

Shandara · 11/04/08, 4:45 AM

Update:

- Owl's Focus and Feeding Frenzy now only work for Cunning pets
- Added Darkmoon: Greatness card (+agi version)
- Glyph of TSA no longer increases the AP bonus

EDIT:

- Implemented Gorilla Thunderstomp
- fixed some focus costs of pet abilities and damage ranges according to Petopia
- Implemented Bear Swipe 
- Implemented Poison Spit
- Implemented Ravage
- Implemented Demoralizing Screech

Tazlin · 11/04/08, 2:01 PM

Are the changes with todays patch already in the spreadsheet? Like for barrage and aimed shot and the change to thunderstomp?

Shandara · 11/04/08, 2:03 PM

Originally Posted by Tazlin

Are the changes with todays patch already in the spreadsheet? Like for barrage and aimed shot and the change to thunderstomp?

Barrage/Imp. Barrage affecting Aimed Shot have been in since a few revisions back (ever since they were announced). I only implemented Thunderstormp today but yes, it only uses a magical coefficient.

Sienna · 11/04/08, 3:14 PM

Arcane shot crit multiplier is not acting as it's supposed to?

My arcane shot hits for 926, but crits for 2202. Arcane shot crit is only effected by mortal shots and relentless earthstorm diamond. So the crit multiplier must be 2.3*1.03 which would make it crit for 2193. Where's the extra 9 damage coming from?

Path · 11/04/08, 3:16 PM

Pet Tanking stats are a bit off:

Pet Armor - Natural Armor - the formula uses K6 for the value for tenacity pets; should be m6.
Pet Dodge Chance - doesn't take 'Catlike Reflexes' talent into account.
Pet Health - Great Stamina - the formula uses K5 for the value for tenacity pets; should be m5.

Ravenfire · 11/04/08, 4:47 PM

Pet ability errors/typos:

Rake and Spirit Stirke both incorrectly use the base cool down instead of the Longevity affected cool down to calculate Focus per second (referece pulls CD data from the base ability instead of using the CD calculated 3 rows up).

Thunderstomp and Poison Spit both use incorrect references from the Buffs tab for Target Debuffs (should use Buffs!K73 which is the +nature damage debuff cell).

Sienna · 11/04/08, 5:37 PM

Chimera shot crit multiplier isn't 2.3 btw. Tested with mortal shots and without relentless, and the crit multiplier seems close to 2.4 without using marked for death. What is the deal with it?

Shandara · 11/04/08, 5:38 PM

Originally Posted by Sienna

Arcane shot crit multiplier is not acting as it's supposed to?

My arcane shot hits for 926, but crits for 2202. Arcane shot crit is only effected by mortal shots and relentless earthstorm diamond. So the crit multiplier must be 2.3*1.03 which would make it crit for 2193. Where's the extra 9 damage coming from?

The crit damage calculations aren't quite what you'd expect.

It's like this. Your standard crit bonus is 100%. You add Mortal Shots to it and end up with 130%. THEN you multiphy with the relentless earthstorm diamond, but it counts twice. So 130% * 1,06 = 137,8%. Add the base damage (i..e 100%) to that.

So 926 * ( 100% + 137,8% ) = 2202,028

Don't ask me why the relentless diamond counts twice, though. It just seems to match the facts.

Update:

- Pet dodge/health/armor now reference the correct talents for tenacity pets
- Pet dodge affected by Catlike Reflexes
- Fixed some bad references in pet calculations (mostly the damage per focus calculations)

Sienna · 11/04/08, 5:51 PM

Originally Posted by Shandara

The crit damage calculations aren't quite what you'd expect.

It's like this. Your standard crit bonus is 100%. You add Mortal Shots to it and end up with 130%. THEN you multiphy with the relentless earthstorm diamond, but it counts twice. So 130% * 1,06 = 137,8%. Add the base damage (i..e 100%) to that.

So 926 * ( 100% + 137,8% ) = 2202,028

Don't ask me why the relentless diamond counts twice, though. It just seems to match the facts.

Update:

- Pet dodge/health/armor now reference the correct talents for tenacity pets
- Pet dodge affected by Catlike Reflexes
- Fixed some bad references in pet calculations (mostly the damage per focus calculations)

Yeah I just worked it out, it's being counted twice for some reason. But I kinda figured it out why it's counted twice. You have your 100% crit bonus. So your shot should crit for 200 instead of 100. Then Diamond multiplies 200 with 1.03 so your shot now crits for 206. So right now, your crit damage bonus is 106, since your original shot hit for 100. So that 106 is being multiplied by 1.3 from mortal shots, and added to your original shot, which is 100. The result is 137.8%. But actually the diamond is being counted once, not twice. Just not at the point we assume it'd be counted.

Sienna · 11/04/08, 5:52 PM

Originally Posted by Sienna

Chimera shot crit multiplier isn't 2.3 btw. Tested with mortal shots and without relentless, and the crit multiplier seems close to 2.4 without using marked for death. What is the deal with it?

Ok here it is. Chimera shot crits are bugged right now if you take marked for death. Whether or not you have hunter's mark on the target, Chimera shot will always use the 2.4 crit. The only difference of having hunter's mark on the target is the 5% damage and extra attack power. But crit multiplier part of chimera is bugged.

KraxisSingular · 11/04/08, 10:10 PM

Originally Posted by Sienna

Yeah I just worked it out, it's being counted twice for some reason. But I kinda figured it out why it's counted twice. You have your 100% crit bonus. So your shot should crit for 200 instead of 100. Then Diamond multiplies 200 with 1.03 so your shot now crits for 206. So right now, your crit damage bonus is 106, since your original shot hit for 100. So that 106 is being multiplied by 1.3 from mortal shots, and added to your original shot, which is 100. The result is 137.8%. But actually the diamond is being counted once, not twice. Just not at the point we assume it'd be counted.

Correct, note that is says "3% Increased Critical Damage", not bonus. So it is the entire crit damage that is affected. Obviously since most other stuff says "increases critical strike damage bonus" it is easy to miss the slight difference.

Azurei · 11/05/08, 3:35 AM

Ran across a couple mistakes in the Gems tab:
Perfect Vivid Dark Jade (7 Hit, 11 Sta) is marked as 11 Int instead of 11 Sta
Perfect Solid Chalcedony (21 Sta) is marked as 21 Agi instead of 21 Sta

Sienna · 11/05/08, 5:16 AM

Btw right now in the game RWS and Improved Stings don't stack. You get 30% on your serpent sting if you take both, not 30% and another 5%.

Sienna · 11/05/08, 5:17 AM

Originally Posted by KraxisSingular

Correct, note that is says "3% Increased Critical Damage", not bonus. So it is the entire crit damage that is affected. Obviously since most other stuff says "increases critical strike damage bonus" it is easy to miss the slight difference.

Well it's not that. Assume your hit is 100. When you crit, without the gem, you crit for 230. So if the gem was really giving you 3% more critical damage, then you'd just multiply 230 with 1.03 and be done with it. But the gem doesn't work that way. It's just bugged, and 1.03 is being added before mortal shots.

Shandara · 11/05/08, 6:17 AM

Originally Posted by Sienna

Btw right now in the game RWS and Improved Stings don't stack. You get 30% on your serpent sting if you take both, not 30% and another 5%.

Well, the RWS talent says specifically only 'ranged weapons'. Since stings are in essence DoTs it's not so strange for it not to apply. Whether this is a real bug, I don't know.

Sienna · 11/05/08, 7:29 AM

Originally Posted by Shandara

Well, the RWS talent says specifically only 'ranged weapons'. Since stings are in essence DoTs it's not so strange for it not to apply. Whether this is a real bug, I don't know.

I'm pretty sure RWS did effect serpent sting before. It says ranged weapons, since you can't shoot a sting without a ranged weapon, it counts as a ranged weapon ability.

Sienna · 11/05/08, 7:31 AM

And the chimera shot crit bug is still in the game as of 3.03. The correct multiplier for chimera crit right now is 2.4 if you have taken marked for death+mortal shots. (Who takes chimera without taking marked for death anyway though).

ElginRoko · 11/05/08, 9:24 AM

Originally Posted by Sienna

Well it's not that. Assume your hit is 100. When you crit, without the gem, you crit for 230. So if the gem was really giving you 3% more critical damage, then you'd just multiply 230 with 1.03 and be done with it. But the gem doesn't work that way. It's just bugged, and 1.03 is being added before mortal shots.

I wouldn't say it's bugged, more that the tooltip is worded wrongly. Ask any ele shaman or destro lock how chaotic skyfire works, it's supposedly 3% crit damage, but the increase is implemented entirely in the crit damage bonus. In their case, that manes the crit bonus goes from 50% to 54.5% (154.5% = 150% * 103%). They then take their talents which increased their crit damage bonus by 100% and end up with 209% crits. Relentless should probably be worded "Increases your critical strike damage bonus by 6%", my only guess as to why they didn't do it that way is that they want to make chaotic and relentless look the same.

Edit:
New thing - Mages in particular on these forums have been reporting that JoW proc chance is 25% in beta. I've taken a peek at some hunter data from random half-a-day-old WWS reports which seem to back this up
Edit2:
Although I've seen some definite variance, balance druids normally seem low for example. Might be sample size, or might be something like the proc being PPM based. Yuck.

Mosc · 11/05/08, 4:16 PM

Hey Shandara,

Just a small thing I noticed with Glyph of Aimed Shot. In the spreadsheet it reduces the cooldown of aimed shot by 1 sec, but on live and beta Glyph of Aimed Shot actually "Reduces the mana cost of your Aimed Shot ability by 20%."

I checked this thread and the update notes but did not see anything about this, so I assumed it was just over-looked.

Starwind · 11/05/08, 5:10 PM

Shandara,

In the WotLK thread someone was asking about coefficient conversions, etc at 80 and I suggested that he take a look at your spreadsheet. I didn't see a specific section/table that lists the various coefficient conversion rates at 80, e.g., 1 Agil = x %Crit = y Crit Rating? Would you consider adding a section like this (maybe in the Hunter Statistics section on the Overview worksheet)?

Thank you for your hard work!

BTW, the specific question was:

Attribute Coefficients

--------------------------------------------------------------------------------

Would it be possible to have the original post in this thread updated with the known/suspected attriubute coefficients at level 80?

This thread is now almost 200 pages and it's getting very difficult to find the information that I'm looking for.

These are the values I have so far, and they have been deduced from screenshots of gear:

1% Crit = 62.6 Agility = 45.88 Crit Rating
1% Hit = 32.8 Hit Rating
1% Haste = 32.77 Haste Rating

I'm fairly certain that someone out there probably has more accurate numbers, I just haven't been able to find them with the search feature.

Shandara · 11/05/08, 7:08 PM

@Starwind:
Unhide the "Level" tab if you want to see the conversion rates I use in the sheet.

@Mosc:
Thanks, I must have missed this change.

Osse · 11/05/08, 7:23 PM

I don't know how the spreadsheet calculates damage under aspect of the viper but with MM spec serpent stings damage will keep ticking for full damage even if you refresh the sting with chimera shot. Also, if you pop blood fury and AP trinket before putting a sting up it will keep ticking for boosted damage even after you refresh the sting with chimera shot.