Leulier's Warlock DPS Spreadsheet - Page 7

Whitetooth · 01/10/09, 3:10 AM

The new Glyph of CoA now adds 2 extra large ticks of 290 damage (0 talents and 0 spell power) in 3.0.8

=(1740+add_s*1.2+IF(glyph_coa,(290*2+add_s*0.2),0))

15:28:32> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (71 Overkill)
15:28:34> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (72 Overkill)
15:28:36> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (71 Overkill)
15:28:38> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (71 Overkill)
15:28:40> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (144 Overkill)
15:28:42> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (144 Overkill)
15:28:44> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (144 Overkill)
15:28:46> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (144 Overkill)
15:28:48> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (216 Overkill)
15:28:50> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (217 Overkill)
15:28:52> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (217 Overkill)
15:28:54> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (216 Overkill)
15:28:56> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (289 Overkill)
15:28:58> [Your] Curse of Agony damaged [Expert's Training Dummy] 1 Shadow. (289 Overkill)
15:28:58> [Your] Curse of Agony dissipated [Expert's Training Dummy].

Pet Stats:
Imp Stam (is actually 0.344 instead of 0.3, stam tooltip is wrong) (floor after calculation)

=(135+FLOOR(stam*0.344,1)+C9+C11)*(1+fel_vit*0.03)
*(1+0.02*C12)
+ synergy*0.05*stam

Imp Intellect (floor after calculation)

=(369+FLOOR(DPS!N7*0.3,1)+C10+C11)
*(1+fel_vit*0.05)
*(1+0.02*C12)
+ 0.05*synergy*int

Imp Mana

=(1175+(B17-25)*5)*(1+fel_vit/20)

Whitetooth · 01/10/09, 5:02 AM

Pet updates

Felhunter Stam

=(355+FLOOR(DPS!N6*0.344,1)+C9+C11)
*(1+fel_vit*0.05)
*(1+0.02*C12)
+ 0.05*synergy*stam

Felhunter Int

=(150+FLOOR(DPS!N7*0.3,1)+IF(C10=0,48,C10)+C11)
*(1+fel_vit*0.05)
*(1+0.02*C12)
+ 0.05*synergy*int

Felhunter AP

=608+pet_ap+other_ap

Felhunter Mana

=(1559+B41*11.1)*(1+fel_vit/20)

Felhunter Auto attack

=(346.5+B42/8.888888888)*(1+IF(Race="Orc",0.05,0))
*(1-melee_miss+fh_melee_crit-(1-glancing_red)*glanc_perc-target_dodge)
*armor
*(1+0.04*unholy_po)
*(1+md*0.02)

Felhunter Shadow Bite

=(118+B47*1.5/3.5)*(1+SUM(DPS!B26:B30)*0.05)*(1+B46+0.06*glyph_felhunter)*(1+IF(Race="Orc",0.05,0))

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

Felguard Stam

=(328+DPS!N6*0.3+C9+C11)
*(1+fel_vit*0.05)
*(1+0.02*C12)
+ 0.05*synergy*stam

Felguard Int

=(150+DPS!N7*0.3+C10+C11)
*(1+fel_vit*0.05)
*(1+0.02*C12)
+ 0.05*synergy*int

Felguard Mana

=(1344+B32*11.55)*(1+fel_vit/20)t

Felguard Auto attack

=(515+fg_ap/5.6)*(1+IF(Race="Orc",0.05,0))
*(1-melee_miss+fg_melee_crit-(1-glancing_red)*glanc_perc-target_dodge)
*armor
*(1+0.04*unholy_po)*(1+md*0.01)

Felhunter Cleave

=(515+fg_ap/5.6+124)*(1+IF(Race="Orc",0.05,0))
*(1-melee_miss+fg_melee_crit-target_dodge)
*armor
*(1+0.04*unholy_po)*(1+md*0.01)

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

Succubus Stam

=(328+DPS!N6*0.3+C9+C11)
*(1+fel_vit*0.05)
*(1+0.02*C12)
+ 0.05*synergy*stam

Succubus Mana

=(1344+B23*11.55)*(1+fel_vit/20)

Succubus Auto Attack

=(455+sc_ap/6.36)*(1+IF(Race="Orc",0.05,0))
*(1-melee_miss+sc_melee_crit-(1-glancing_red)*glanc_perc-target_dodge)
*armor
*(1+0.04*unholy_po)
*(1+md*0.02)

Succubus Lash of pain

=(237*(1+IF(Race="Orc",0.05,0))+0.429*pet_dmg)*(1+IF(Race="Orc",0.05,0))
*(1-melee_miss+sc_melee_crit-target_dodge)
*(1+0.04*unholy_po)*(1+md*0.02)
*coe

Edit: This is PTR 3.0.8 data.

Bakka · 01/14/09, 11:51 AM

New version K at WoW Warlock DPS Spreadsheet

Tumah · 01/14/09, 7:14 PM

I'm still kind of a noob and I tried using the spreadsheet but i really wasnt 100% sure of what i was doing- according to the sheet i should have about 2500 or so dps when my dps actually fluctuates between 1600-1900 is there some way to post instructions on how to fill it out correctly? i think my trouble may have been trying to figure out how to get my rotation in as a 0/41/30 i put CoA in the curse and incin as the filler and then on the dps box i put corruption immolate and incinerate and my felguard- if thats what i was supposed to do then i have no idea what i am doing wrong

mdl060374 · 01/15/09, 12:38 PM

Originally Posted by Tumah

I'm still kind of a noob and I tried using the spreadsheet but i really wasnt 100% sure of what i was doing- according to the sheet i should have about 2500 or so dps when my dps actually fluctuates between 1600-1900 is there some way to post instructions on how to fill it out correctly? i think my trouble may have been trying to figure out how to get my rotation in as a 0/41/30 i put CoA in the curse and incin as the filler and then on the dps box i put corruption immolate and incinerate and my felguard- if thats what i was supposed to do then i have no idea what i am doing wrong

Check page post #78 on page 4... there is a document file that a user made that explians things pretty well.

Debby · 01/15/09, 12:40 PM

I tried the newest version but I get at the Next Stat table 1.0 at dmg (logical) and 0.5 to ALL others. Something is wrong. I also get some weird numbers at DPS diif at items sheet. When I say weird I mean >12K dps diff etc...

mdl060374 · 01/15/09, 12:54 PM

I have been trying to figure this out regarding my spec vs the spreadsheet default "haunt" spec. I am currently running a 53/0/18 (only difference is I put 3 into cataclysm and took 2 away in the aff tree from Eradication, and didnt put any in imp drain soul.

When I calculate the difference, my current spec produces 4116 DPS while the haunt is a 5039 (using Sbolt=>drain soul option for both specs.) I dont understand how such small differences in those points could cause such a change..

So my next logical move was to breakdown the difference in specs, and I noticed the points for certain spells (siphon life) have 2 talent points, when the game only allows 1. Same for eradication 3 allowed (spreadsheet gives 4.)

What am I missing here? I am not what changes to make etc based on this info.

Debby · 01/15/09, 1:46 PM

At Glyphs tab when I set Felguard Glyph to "1" I don't get a DPS increase even though I have already set Felguard as my pet at DPS sheet.

Trickykid · 01/15/09, 2:20 PM

Originally Posted by mdl060374

I have been trying to figure this out regarding my spec vs the spreadsheet default "haunt" spec. I am currently running a 53/0/18 (only difference is I put 3 into cataclysm and took 2 away in the aff tree from Eradication, and didnt put any in imp drain soul.

When I calculate the difference, my current spec produces 4116 DPS while the haunt is a 5039 (using Sbolt=>drain soul option for both specs.) I dont understand how such small differences in those points could cause such a change..

So my next logical move was to breakdown the difference in specs, and I noticed the points for certain spells (siphon life) have 2 talent points, when the game only allows 1. Same for eradication 3 allowed (spreadsheet gives 4.)

What am I missing here? I am not what changes to make etc based on this info.

Eradication's possible values are 4,7,10 (for the % buff, rather than the talent points in it). If you put it to 1, that's part of the reason. If I were you I'd start at the "Haunt" Spec again and change your talents 1 point at a time and see what DPS changes by, then we can figure out which talents were responsible.

mdl060374 · 01/15/09, 2:32 PM

Originally Posted by Trickykid

Eradication's possible values are 4,7,10 (for the % buff, rather than the talent points in it). If you put it to 1, that's part of the reason. If I were you I'd start at the "Haunt" Spec again and change your talents 1 point at a time and see what DPS changes by, then we can figure out which talents were responsible.

Gotcha. I figured it was something like that.

Also, I figured out the discprepancy. I didnt notice your rotation changes when you load talents.. Hence, my rotation wasnt including immolate and Corruption..

Once I include those it makes alot more sense.

Debby · 01/15/09, 3:45 PM

Ok, all my above observations happen only when I select Felguard as my pet in DPS tab at Main Options. Can you fix it please?

Bakka · 01/15/09, 4:27 PM

Originally Posted by Debby

I tried the newest version but I get at the Next Stat table 1.0 at dmg (logical) and 0.5 to ALL others. Something is wrong. I also get some weird numbers at DPS diif at items sheet. When I say weird I mean >12K dps diff etc...

Originally Posted by Debby

At Glyphs tab when I set Felguard Glyph to "1" I don't get a DPS increase even though I have already set Felguard as my pet at DPS sheet.

Originally Posted by Debby

Ok, all my above observations happen only when I select Felguard as my pet in DPS tab at Main Options. Can you fix it please?

Fix what? I changed pet to felguard per your instructions on how to reproduce this problem and am incapable of reproducing your observations.

Debby · 01/15/09, 5:38 PM

I do the following

1. set Armory Data

2. Load Gear from armory

3. Load Talents

4. Set raid buffs etc

Till now every thing normal

now I

change Filler spell to incinerate (ok)
set Corruption and immolate to (1)

now I set pet as Felguard <---- this is where all happens

Trickykid · 01/15/09, 8:12 PM

Originally Posted by Debby

I do the following

1. set Armory Data

2. Load Gear from armory

3. Load Talents

4. Set raid buffs etc

Till now every thing normal

now I

change Filler spell to incinerate (ok)
set Corruption and immolate to (1)

now I set pet as Felguard <---- this is where all happens

I've tried making this happen with several variations and the glyph continues to work for me. Do you:
A) set the pet to felguard in cell H4?
B) have your options set to auto calculate?
C) have iterations turned on?
D) use excel 2007?

Also try downloading a new version of the sheet, I wonder if you accidentally hit a key while on an important cell and saved without noticing.

radiskull · 01/16/09, 1:17 AM

I noticed that the spreadsheet doesn't change the overall DPS when you change the number of points in Improved Felhunter. Shouldn't the increased effect of Fel Intelligence improve one's overall DPS?

Trickykid · 01/16/09, 1:27 AM

Originally Posted by radiskull

I noticed that the spreadsheet doesn't change the overall DPS when you change the number of points in Improved Felhunter. Shouldn't the increased effect of Fel Intelligence improve one's overall DPS?

Not if you have divine spirit selected for raid buffs.

Mardal · 01/16/09, 10:54 AM

Hi thx for a great spreadsheet!

How is the Haunt dmg calculated? becuz the dmg in the spreadsheet is way higher than what i can see in my WWS

Daidai · 01/16/09, 12:17 PM

Your Spreadsheet works great now, thanks for your work.
I get 5780 DPS, 6 lifetaps for a 220s fight. On 220s PW last ID i did 6036, with infernal at the end and 6-7 lifetaps.
The values are looking really good, respecting that this tool is made for the next patch.

Thanks again

radiskull · 01/16/09, 2:51 PM

Originally Posted by Trickykid

Not if you have divine spirit selected for raid buffs.

Ah, thanks. That fixes it.

Debby · 01/16/09, 9:08 PM

Originally Posted by Trickykid

I've tried making this happen with several variations and the glyph continues to work for me. Do you:
A) set the pet to felguard in cell H4?
B) have your options set to auto calculate?
C) have iterations turned on?
D) use excel 2007?

Also try downloading a new version of the sheet, I wonder if you accidentally hit a key while on an important cell and saved without noticing.

If you followed my steps you should see the Next Stat table values at DPS Sheet turning into 0.5 except +damage that remains 1.

Trickykid · 01/16/09, 9:38 PM

Originally Posted by Debby

If you followed my steps you should see the Next Stat table values at DPS Sheet turning into 0.5 except +damage that remains 1.

Mine do not go to 0.5. And actually what's wrong with being that low? Are you saying they're all exactly 0.5 and that feels wrong? Hard to fix things when there aren't a lot of specifics to work with.

Oth · 01/16/09, 9:44 PM

It might help if you gave your current name/server so that they could work with your exact information. (Dismay on Genjuros isn't it, at least not spelled that way?) It is possible, if however unlikely, that your talents and gear combination could lead to having +1 damage and +.5 for hit/crit/haste.

Debby · 01/16/09, 9:46 PM

Originally Posted by Oth

It might help if you gave your current name/server so that they could work with your exact information. (Dismay on Genjuros isn't it, at least not spelled that way?) It is possible, if however unlikely, that your talents and gear combination could lead to having +1 damage and +.5 for hit/crit/haste.

It is Dismay at Genjuros EU.

The DPS numbers are Items tab are also go crazy after setting Felguard :S

Viper007Bond · 01/16/09, 10:13 PM

Does anyone have a "For Dummies" guide for this spreadsheet? I can't seem to get it working (using OpenOffice 3.0.0).

I entered my char's name and server into the ArmoryInfo tab, visited the Gear_Buffs tab, pressed the "Load Gear from Armory" button, and nothing happens. No error popup, nothing.

Trickykid · 01/16/09, 10:35 PM

Originally Posted by Debby

It is Dismay at Genjuros EU.

The DPS numbers are Items tab are also go crazy after setting Felguard :S

Originally Posted by Viper007Bond

Does anyone have a "For Dummies" guide for this spreadsheet? I can't seem to get it working (using OpenOffice 3.0.0).

I entered my char's name and server into the ArmoryInfo tab, visited the Gear_Buffs tab, pressed the "Load Gear from Armory" button, and nothing happens. No error popup, nothing.

1) "Go crazy" doesn't help, as I pointed out above, and you still have not answered the questions I asked earlier that may affect your situation. You should also be able to right click any cells that "go crazy" and trace the error back to the offending source. I'd recommend doing that, taking screenshots and answering some of my questions before I try to replicate the problem again.
EDIT: one of your trinkets does not exist in the spreadsheet -- you might want to manually enter your gear.

2) My understanding is that it the macros do not work for Open Office. You can select your own gear yourself in a matter of minutes, though.