 |
10/27/07, 10:57 AM
|
#276
|
|
Glass Joe
|
Originally Posted by frmorrison
For feedback, I would like to be able to enter a value for stamina, like you have for int. While stam will not kill a boss for you, it will help you live and fuel your life taps, so I give personally give it a value of .15.
|
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.
Originally Posted by frmorrison
Edit: More feedback, Cuffs of Devastation have a yellow socket (no socket is shown) and when sockets are there, you assume the same color is used and that turns on the bonus. If you want it to remain that way, I think you should write a note.
|
Oops, fixed the Cuffs. The socket bonus thing is noted in the small print at the top of the sheet.
Originally Posted by Trickykid
It's also worth noting you can "move" this sheet into Leulier's and make "The Next Stat" numbers plug directly in.
|
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  ).
Originally Posted by Trickykid
I might use your sheet though since certainly it is prettier  -- I'll probably add "non-capped DPS-increase Per Hit" since that's how I make my tradeoffs when I'm above the cap.
|
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.
|
|
|
|
|
10/30/07, 4:38 PM
|
#277
|
|
Glass Joe
|
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.
|
|
|
|
|
10/30/07, 5:09 PM
|
#278
|
|
Glass Joe
|
Originally Posted by 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.
|
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.
|
|
|
|
|
10/30/07, 6:30 PM
|
#279
|
|
Glass Joe
|
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. 
|
|
|
|
|
10/30/07, 6:52 PM
|
#280
|
|
Don Flamenco
Human Warlock
Argent Dawn (EU)
|
Originally Posted by 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. 
|
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.
|
|
|
|
|
10/30/07, 7:17 PM
|
#281
|
|
Glass Joe
|
Originally Posted by 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.
|
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)?
|
|
|
|
|
10/30/07, 8:46 PM
|
#282
|
|
Don Flamenco
Human Warlock
Argent Dawn (EU)
|
Originally Posted by 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)?
|
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.
|
|
|
|
|
10/30/07, 10:47 PM
|
#283
|
|
Glass Joe
|
Kings or Wisdom for the most DPS?
|
|
|
|
|
10/30/07, 11:41 PM
|
#284
|
|
Protector
Ashstorm
Human Paladin
No WoW Account
|
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.
|
|
|
|
|
10/31/07, 3:11 AM
|
#285
|
|
Bald Bull
|
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.
|
|
|
|
11/03/07, 6:03 AM
|
#286
|
|
Von Kaiser
|
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.
|
|
|
|
|
11/03/07, 6:15 AM
|
#287
|
|
Protector
Ashstorm
Human Paladin
No WoW Account
|
Pets have 5% crit or really close to that number without talents/buffs.
|
|
|
|
|
11/03/07, 6:56 AM
|
#288
|
|
Glass Joe
Human Warlock
Kirin Tor (EU)
|
Originally Posted by Altyera
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.
|
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.
|
|
|
|
|
11/03/07, 9:38 AM
|
#289
|
|
Don Flamenco
Human Warlock
Argent Dawn (EU)
|
Originally Posted by 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.
|
Please do research before asking questions. This info is in the compendium.

|
|
|
|
|
11/03/07, 10:20 AM
|
#290
|
|
Glass Joe
Human Warlock
Kirin Tor (EU)
|
Originally Posted by Arelenda
Please do research before asking questions. This info is in the compendium.
|
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 ?
|
|
|
|
|
11/03/07, 10:35 AM
|
#291
|
|
Piston Honda
Night Elf Druid
Black Dragonflight
|
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.
|
|
|
|
|
11/03/07, 11:20 AM
|
#292
|
|
Don Flamenco
Human Warlock
Argent Dawn (EU)
|
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.
Last edited by Arelenda : 11/03/07 at 11:41 AM.
|
|
|
|
|
11/08/07, 10:58 AM
|
#293
|
|
Glass Joe
|
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!
|
|
|
11/08/07, 1:24 PM
|
#294
|
|
Don Flamenco
|
Originally Posted by 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?
|
Post #223 in this thread...
|
|
|
|
|
11/08/07, 7:00 PM
|
#295
|
|
Glass Joe
|
What mod is that Arelenda? That is exactly what im looking for please help thanks!
*EDIT* SPELLING lol
|
|
|
|
|
11/08/07, 8:05 PM
|
#296
|
|
Glass Joe
|
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?
|
|
|
|
|
11/08/07, 8:16 PM
|
#297
|
|
Bald Bull
Blood Elf Paladin
Darksorrow (EU)
|
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.
|
|
|
|
|
11/13/07, 11:45 AM
|
#298
|
|
Glass Joe
|
Originally Posted by Trickykid
|
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?
|
|
|
|
|
11/13/07, 1:45 PM
|
#299
|
|
Don Flamenco
|
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.
|
|
|
|
|
11/19/07, 2:28 PM
|
#300
|
|
Piston Honda
Gnome Warlock
Earthen Ring
|
Has anyone modified the spreadsheet for the crit damage bonus from [Chaotic Skyfire Diamond]? Any tips on how to go about it?
|
|
|
|
|
|