Deathwing

(598.5 + 1586)*1.05*1.13*1.1*1.15*1.15 = 3770, seems like his damage is right on track. I'm assuming the 1586 number you quoted about 5 posts up is spell damage as it applies to Incinerate(as in, after S&F)?

 

scheod

The multiple immolates from more than 1 warlock was one of the first things I tested when I was grouped with another warlock. It doesn't appear to stack based on total immolates...however I think you can get the dmg bonus from anyone's immolate.

I was also wondering about lifetap theory, Lifetap as needed, or lifetap to full (keep dots up) and continue full cycles? I've done both and don't really *notice* a differance (except possible wasted imp SB when only LTing once before reopening). what do you guys do for Lifetap/DP in your cycles?

 

Demi9OD

What does it take to make a42 on the spreadsheet give this number, because with 17% hit and 0% crit I should always be getting full damage non crits, and its taking me close to 1900 add fire to attain a 3700 incinerate. Thats the part I don't understand.

 

Deathwing

Wow, I'm an idiot. Didn't scale the +damage total to casting time.

(598.5 + 2.5/3.5*1568)*1.05*1.13*1.1*1.15*1.15 = 2966, which is pretty much what the spreadsheet gets. So, the video does seem off. Are you sure you're reporting what his +damage would be correctly?

Noticed he was using conflag in his rotation, does he know something I don't? I thought conflag was lower DPS than another incinerate.

 

Demi9OD

No, he probably just didn't know any better. 1586 should have been his total +damage in the video with both procs up. The equation I quoted above does not include S+F, and I guess that explains 3700s (1880 effective spell damage for incin), but just plugging 1568 and 5/5 S+F in the sheet does not.

 

Tryst

Ok, you're right about the crit, I didn't remove that before. I removed both the crit and hit calculations out of the incinerate formula and nulled out all the multipliers. With zero SnF, 1586 total fire damage, the spreadsheet shows 1730.9.

598.5 + (0.714*1586)= 1730.904.

Ok, so far so good. But when I put in 5/5 SnF, the spreadsheet is showing 1957.38.

598.5 + ((0.714 + 0.2) * (1586)) = 2048.104.

The spreadsheet is calculating SnF differently.

(598.5 + 0.714 * 1586 * (1.2)) = 1957.38

Am I miscalculating SnF here? 0.714 is 2.5/3.5 to account for casting time. SnF is 20% bonus or 0.2 added on to the coefficient, bringing the total to 0.914, correct?

Deathwing, for your total of 2966, you're not accounting for SnF, instead using just the base coefficient of 71%. If I use an additive value of SnF:

598.5 + (0.914 * 1586) * 1.05 * 1.1 * 1.13 * 1.15 * 1.15 = 3535.15

A lot closer to what was seen in the video.

 

sylveni

I'm a bit confused about where the value of 1586 fire damage came from. Tryst posted earlier that given his current profile with all the buffs shown in the video, he should be at 1753 fire damage. I know he has obtained new gear since the video was made, but a 175 spell damage discrepancy seems rather large.

 

Tryst

Looking more closely at his current gear and the video, I'm going to guess that he picked up the Prince dagger and at least one piece of spellstrike since then, because I do not see the lesser spell blasting buff. If that's a continuum blade, then you're looking at 50 or so damage on the weapon, and depending on what spellstrike he picked up and what he replaced, that's another good source for more damage.

 

Demi9OD

I was looking at his gear very shortly after the video was made, and accounted for all buffs and arrived at 1586. You can give or take 20 but that was very close to the correct number. He was not wearing pvp gear.

 

Bolche

I'm almost certain you are right and that the above formula is correct. I'm using the same for empored corruption ( 900+add_s*(0,94+0,36) ) and the results match my in-game values.

Can someone with S&F do a quick test to confirm this ?

Warlock DPS Spreadsheet

 

Deathwing

That method is incorrect. If you added .2 to the spell coefficient, that extra 20% isn't scaled by Incinerate's coefficient. That's why you have to do (1.2)*(spell damage)*(spell coefficient).

 

Zoner

The empowered talents and SnF are spell damage coefficient modifiers. Their bonus is added to the base coefficient.

 

sylveni

I have to confirm that s&f is additive. I was curious and decided to test for myself.

I cast incinerate on Dr. Boom until he died (without immolate). I have 955 spell damage, with emberstorm, ruin, and s&f. If s&f was multiplicative, my max crit should be

(514 + 1.20 * 0.714 * 955) * 1.10 * 2.0 = 2931

If s&f was additive, my max crit would be

(514 + (0.714 + 0.20) * 955) * 1.10 * 2.0 = 3051

My maximum crit on him was exactly 3051.

 

Bolche

1.10 - 2007/04/11

Correction of the way Shadow and Flame was applied to Incinerate and Shadow Bolt:
incinerate base dmg (with 5/5 S&F) is now 598,5+add_f*(0,714+0,2) instead of 598,5+add_f*0,714*1,2
(same for SB)


I'm still working on pet dps, but it does require quite a lot of data gathering, even only for the imp ! the FG will be a kind of rogue spreadsheet, it will be fun

Are the following assumptions correct ?
- pets crit % (melee and spell) : 5%
- pets have 17% spell miss against a +3 target
- pets melee have 40% glancing blow that hits for 65% of a normal attack
- the following talents don't affect pet spells : ruin, shadow mastery, amberstorm
- lash of pain is not affected by armor reduction but can be dodged / parried / blocked

Warlock DPS Spreadsheet

 

eoy

Hi it's Eoy from Forte here friend just pointed me to this thread. First of all, at the time of the movie I believe I had 2 part spellstrike, I wasn't just a tailor back then. I recently went tailoring though and got 1079 spelldmg atm without felarmor. In the future I'm going to keep a note of my stats when I make movies for all you guys who care

Second, I was quite concerned when I saw you asking about why I conflag in my rotation? Maybe I'm just doing it wrong or something, I just always figured that since I try to time my conflag so I do it with 0.5sec left on my immolate it's nice dmg / mana. It's not like I'm gona incinerate without immolate up anyways, and using immolate more frequently than I already do would just drain me too much. And seeing as I top the meters atm I don't see any need to change my rotation. About lifetapping cycles.. I usually lifetap to full unless boss it at low hp - then I try to estimate around how much mana I'll need before it dies and tap to a good amount. Our CoE lock is indeed Malediction. But in the movie he forgot to do CoE on the 1st add at least, don't know about the others.

Sorry about crappy grammar currently raiding so can't read through

 

Canadianpimp

Anyone else not able to open the spreadsheet anymore?

 

Noximus

It works.

Extih <Apocalypse> - Raid Leader - 70 Warlock (Retired)
Noximus <Apocalypse> - 70 Warrior (Retired)

 

• frmorrison

The Felguard is similar to VW and Felpuppy, except they have different AP and only Felguard has a melee special attack. Succubus has a special unaffected by armor. I would ignore Parry/Block since you can position the pet behind a mob, but 5% dodge still matters.

The melee pets have a base 5% melee crit (can get 10% with the talent), I am unsure about the Imp.

The Imp should have a 17% spell miss rate on bosses, but I parsed Felguard's Cleave at 9% miss rate, but only have done it once.


The Demo talent that gives 20% more melee damage to pets is going to affect the Imp's firebolt in 2.1.0 (not sure if it does now).

 

Kruthal

I was trying to extend this spreadsheet to automatically calculate how often I needed to Life Tap, given a set encounter length (quite often I know roughly how long our guild takes on a given boss). Among other things I wanted an easy way to see how much(/little) raid-buffs like BoW etc benefited me, and it just felt incomplete to me like it was now

Is this something you've considered adding Bolche? Just so I'm not doing the same work you are doing (assuredly better than me). If not, I was contemplating calculating the time and thus mana spent by keeping up dots/curses/spending NF procs, and then adding in the time needed to regain this mana from Life Tap/Dark Pact. Then divide the remaining time in the encounter by shadowbolting and the time spent gaining back the mana for the shadowbolts. Does this sound like it should work, so I am just bad at excel for not getting it to work?

Also, I'd like to thank you for making this spreadsheet. Apart from really makeing it easy to compare items, it finally prompted me to go out and research my lag-problems when I realized how far I was from reaching the dps I should optimally be doing. Suffice to say I have Supercast and some /stopcasting macros now

 

Mondragon

Would you be so kind as to write the macros in this thread..would be nice to see what some people are doing to get round MS.

 

SchLing

This spread sheeet is very good I love playing around with it.

Putting points in Dem.Aegis doesn't have effect on your DPS. I guess it's because it would get confused with the Add shadow and fire damage?

I would love to see your total damage pool aswell as your estimated DPS on a spread sheet like this. A bit more complicated of course, but I think the damage pool is almost more important in longer fights than your DPS.

 

Deathwing

At your levels of +damage, conflag does less dps than casting incinerate(or recasting immolate). By your 0.5s comment, do you mean it's possible to mess around with server lag to cast conflag but still get the last tick of immolate?

Damage meters are relative to the guild you're in, so that's no reason to not improve your damage cycle. If you were threat capped, maybe.

 

Deathwing

You can do the lifetap thing easily enough already. Just turn on lifetapping, and then adjust the frequency until you get to 0 M/S(infinite sustainability, healer mana withstanding) or some negative number that would represent draining your mana pool to 0 just as that certain fight was ending. Automating such a feature would be more work for Bolche, while removing user interaction. User interaction is important at keeping the user informed as to why certain cycles or mechanics are better.

Raid buffs are easy to add as well. Just affect your mana regen, spell damage, crit, etc by how much the buff would affect you.

Your second paragraph is a bit confusing. From what I can understand, everything you mention is already in the spreadsheet, except for the mana part. You want to separate what the mana you lifetap back is for?

 

dakalro

Tried my dps tonight on Dr. Boom (16% hit from gear in spreadsheet) and spreadsheet and have to say I found it quite accurate once I got the Life Tap/Dark Pact counts in. Not sure about the ISB model. 15% total crit on SB and just me there ...

Also found that casting CoS + dots/SB would give me near infinite sustainability (3/3 FS set provided 14.5k healing, Siphon 65.5k). Casting CoD I had to use HS and 2 Death Coil. Still I think just using Death Coil is enough for a very large amount of continuous casting.

Overall pretty nice. I'll keep using it since it showed me what I have to work on to improve my dps, luckilly it's got nothing to do with dot rotation and more with 3 fps during a boss fight where stuff moves and my movement habits on, of course, movement fights

 

Kruthal

All I use is Supercast combined with a shadowbolt macro like this:
I need to learn to be more precise I see . I know I can do this, this is what I do now after all. I wanted to see if I could automate it, in part to play around with Excel as well, since I haven't done that for some time.

That's not a bad point actually, hadn't thought of that.

Again, I should have expressed myself more clearly . All I wanted was to automate all of this, since I often play around with the spreadsheet for quite a bit, so I wanted a lot of this done automatically. I know how to add in all raid-buffs manually, cut me some slack here . The second paragraph was really just me asking how I'd go about automating life tap etc, since I couldn't get it to work correctly earlier today.