Altyera

Hmm, that's something that's really difficult to quantify and also subject to spec, set bonuses and party composition. I wouldn't assign a fixed DPS value to stamina. The value for Int is precisely 0.27 times your DPS per crit value, since 1 point of int adds crit percentage at that ratio.

Oops, fixed the Cuffs. The socket bonus thing is noted in the small print at the top of the sheet.

Yeah, with permission future releases could include a "bundled" version fused into the current version of Leulier's workbook (if your reading this, give a thumbs up or thumbs down ).

An easy way to do that would be to simply edit the base stats of the item you're looking at to only include the portion of its hit allotment that would fit under the cap in a given situation. Dirty but effective.

 

lasider

I'm wondering if there is anything used to alter ISB uptime compared to overall crit percent. I can't think of a great way to model this (having had a lengthy debate on the WoW forums), but I feel that it's contributing to crit being underrated as a stat, and that's why people are noticing with a destruction build and crit gear, higher dps totals than they would have otherwise thought they could obtain.

 

Altyera

It's really a multidimensional equation with many variables. There's no right answer. A good answer? 3.

I usually model based on an average of three utilized charges per proc. With a raid full of nuke spec locks averaging 4,200 damage Shadow Bolts, thats 12,600 direct damage benefitting from the proc. Throw in an extra 2,400 from DoTs and you get a nice round (15,000 x 20%) 3,000 bonus raid damage per ISB proc. Yes, this is a high estimate based on a very powerful raid.

3000 ÷ 100 = 30 bonus damage per % crit… 30 ÷ 2.5 = 12 bonus DPS per % crit… 12 ÷ 22.1 = 0.54 bonus DPS per point of crit rating.

So I add 0.54 DPS bonus raid DPS to my personal DPS per crit rating. It makes crit the most valuable stat to stack for DS/S&F.

 

lasider

Awesome Altyera, this is exactly what I was looking for. I think 3 charges is probably a good estimate with the chance to overwrite existing debuffs, and also the occasional (very occasional) loss of a proc due to extreme movement, or other factors (Naj'entus's shield).

I need to find out what the average shadowbolt/mindblast/shadow word death damage is for our raids, and find out on average how much dot uptime we have per shadow dot, and average damage per tick. I think you're pretty close with your numbers to the areas our raid normally operates in though. Thanks for the response.

 

Arelenda

You realise that ISB boosts all shadow damage, not just non-periodics, right?

ShadowSeer will give you more or less reliable data on ISB, it's why I wrote it. Until 2.4 it's probably as good as it gets.

 

Altyera

You must have a pretty good cross-section of samples via feedback. What would you say is the average per-proc utilization of a typical BT raid (say 2 Destro locks, 1 Affliction lock, 2 Shadow priests)?

 

Arelenda

It heavily depends on how many targets are available, and how long they live. It fluctuates a whole lot.

For reference, on our last raid we wiped a couple of times on Gurtogg. Data for that raid (Gurtogg attempts + trash) shows 320 shadow bolt crits by the raid, and an average of 2000 damage added per crit. That was with two destros, an affliction and two shadow priests.

Gurtogg is one single boss, no adds.

 

Vazeroth

Kings or Wisdom for the most DPS?

 

• frmorrison

Wisdom is 41 mp5, so over a 5 minute fight that is 2460 mana.

Kings is 10% more stam and int, so assume you gain 900 health/mana, but then your health will get refilled many times over 5 minutes, so Kings is better than Wisdom for mana.


However, if you can only have one Blessing, Salvation will give the most dps.

 

PSGarak

If you have Demonic Knowledge, kings would add maybe 50ish to each stat (probably less to int, maybe more to stam). IIRC, DK makes stam/int->dmg at a 16:1 ratio, so that's 6 spell damage. So yeah, negligible.

Although, if you're affliction you want Wisdom on your pet, and if you're demonology you want Kings on your pet, possibly more than Might. And Morrison is correct, above all you want Salvation. I can't believe I raided for a year and a half without it.

http://sig.gamerdna.com/quizzes/INFL...erks/Garak.png

 

Yaha

Curious-- has anyone done tests to find out the Felguard's base crit% at lvl 70? I'm unable to access the spreadsheet so apologies if that info is there.

From my lvl 60 lock's pet pane I get a +5% melee crit from his agility score, but I'm wondering if he has a base crit chance above his agility bonus.

 

• frmorrison

Pets have 5% crit or really close to that number without talents/buffs.

 

Parlique

What would be the add from an affliction warlock casting shadow bolts half of the time ? 0.3 DPS per crit rating too ?
I've read somewhere that 1 point of +damage is .6 DPS and one crit rating add 0.3DPS to their personnal damage.
Would it means that +damage is equivalent to crit rating for them ?

No irony in my post, I've done my own approximative calculation showing that 1 crit rating is equivalent to 0.9-1 +damage point for an affliction warlock considering the whole raid. But the least I can say is that it is not commonly accepted.

 

Arelenda

Please do research before asking questions. This info is in the compendium.

 

Parlique

I did read the compendium. Nobody talks about damage for the whole raid, just for individual damages. Warlock critic increases damage for other people too. What I wanted to know was : Have some people experienced that affliction builds need to rely on critic and if yes for how many shadow magic users ?

 

Antoine

Personally, I'm shocked your "damage added per ISB" is so low on that SS. Is it a weird fight with lots of stops and starts, or a tank and spank? How do you calculate it? Do you just take all shadow damage done while your ISB debuff is up and take 20% of it? You push ShadowSeer on everybody but I've never seen anything about how it works.

 

Arelenda

I don't really remember what the screenshot info was gathered from, it's a screenshot I took to illustrate the use of the addon months ago. Judging from the damage, it's probably from one boss plus trash, together with some outdoor farming. That would account for the low ISB factor and low hit rating bonus.


As for Shadowseer, detailed info is in the readme, but here's the basics for ISB:

ShadowSeer monitors for ISB debuffs, tries to filter out the priest ones (Shadow Weaving debuff is also called Shadow Vulnerability). It tries to figure out who's ISB debuff it is by monitoring Warlock crits on the target. It counts Shadow damage done to the target when vulnerable. It takes 1/6th of that damage and counts it towards that Warlocks ISB contribution.

It's been tested a lot under solo/party circumstances and was accurate. It's been tested on raids and matched the combat log data on the fights I checked.

Unfortunately it's not 100% reliable in raids, since you can be out of range and therefore not register the debuff application, WWS has the same issues. I've noticed issues on Naj'entus with it, since I tend to stay at max range and Absorbs are ignored.

The range bug is a flaw in WoW combat logging. I'm hoping that with 2.4 and the revamp of the combat system some things get fixed in that area. I've put development on hold until then.

 

Telkster

Is anyone else having a problem with a circular reference in the spreadsheet all of a sudden? Or is my version of Excel just F'd in the A?

Boo creepy foot doctor! Hooray beer!

 

Trickykid

 

venoms0050

What mod is that Arelenda? That is exactly what im looking for please help thanks!

*EDIT* SPELLING lol

 

venoms0050

Ok I found the mod but I have zero Idea how to report the data. It says to report data use the keybinding lol What are the bindings?

 

galzohar

The spreasheet atm is giving me wierd errors and not showing the menus properly (just shows plain table with the same data). It's possible this is caused by me using a hebrew excel version, although I've never seen it happen to me before and one of the older versions of the spreasheet did work perfectly fine.

 

Murdoch

I got a D in calc, and that was only because my calc prof had pity on me and my 'limitless' mind.

Can we just ask Leulier and Piztai to update the formula for us non-mathematically inclined?

 

Trickykid

If you read the post, you'll find out the circular reference is intended. Nothing to update

I think PSGarak had a closed-form way to do it but either way it's pretty simple to set one excel option.

 

Crepe

Has anyone modified the spreadsheet for the crit damage bonus from [Chaotic Skyfire Diamond]? Any tips on how to go about it?