Elitist Jerks
Register
Blogs
Urban Rivals
Forums
New Posts


Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Warlocks
Elitist Jerks Login

gamerDNA Login

Welcome to Elitist Jerks
We're testing some new features on the site regarding OpenID registration and coordination with gamerDNA. If you experience any issues with registering an account, please take the time to fill out a report and send it to this e-mail address. We would appreciate any assistance you could provide in making sure everything is functioning as intended. Thanks!

If this is your first visit, please be sure to check out the FAQ and the forum rules. Users must register to post and new registrations are subject to a one day "mute" period to get acquainted with the community.

Reply
 
LinkBack (187) Thread Tools
Old 12/10/08, 3:35 PM   177 links from elsewhere to this Post. Click to view. #1
Bakka
Von Kaiser
 
Orc Warlock
 
Kalecgos
Leulier's Warlock DPS Spreadsheet

WoW Warlock DPS Spreadsheet

Now at version 3.0.3e.
 
User is offline.
Reply With Quote
Old 12/10/08, 4:39 PM   #2
Nicarras
Piston Honda
 
Undead Warlock
 
Scilla
Need to add all the new Meta's, there are some missing. Mark of the War Prisoner is a blue trinket, but still viable at endgame so it should be added. Also, not related to the spreadsheet but everyone with a Belt Buckle will have to set that to custom as Armory still doesnt show Belt Buckles.
 
User is offline.
Reply With Quote
Old 12/10/08, 5:54 PM   #3
Ossifrage
Glass Joe
 
Gnome Warlock
 
Kil'Jaeden
1-Any chance of adding an option for doom/infernal?
2-Missing Engineering Goggles

<3 :: thank you for your hard work.
 
User is offline.
Reply With Quote
Old 12/10/08, 6:11 PM   #4
heemo
Glass Joe
 
heemo's Avatar
 
Gnome Warlock
 
Magtheridon
First of all, thanks! Here's a few things that might need to be fixed/added unless I am overlooking something:

-Spellstones/Firestones not adding the 1% damage boost to dots/direct damage spells.
-Potions - Speed, Wild Magic, Runic Mana
-Scribe Shoulder Enchant: Master's Inscription of the Storm - Spell - World of Warcraft

One blue that would be nice to have added, if you ever have the time to add them would be [Wand of the San'layn]
 
User is offline.
Reply With Quote
Old 12/11/08, 5:32 AM   #5
Phearbot
Glass Joe
 
Undead Warlock
 
Spirestone
It seems as if the spreadsheet is not calculating 3% + hit from suppression and cataclysm. The value of hit stays the same regardless of these talents. Can anyone confirm? Or am I just missing something?

Also the value of drain soul is not affected by the number of affliction debuffs on the target, only the value of drain life is.

Last edited by Phearbot : 12/11/08 at 5:37 AM.
 
User is offline.
Reply With Quote
Old 12/11/08, 7:27 AM   #6
fip
Von Kaiser
 
Gnome Warlock
 
Proudmoore
Originally Posted by Phearbot View Post
It seems as if the spreadsheet is not calculating 3% + hit from suppression and cataclysm. The value of hit stays the same regardless of these talents. Can anyone confirm? Or am I just missing something?

Also the value of drain soul is not affected by the number of affliction debuffs on the target, only the value of drain life is.
If you look at where hit is calculated into spells, the cast time, you will see what you are looking for. For example, on the DPS sheet, cell C61, Chaos Bolt Cast Time:
=(MAX(gcd,(2.5-bane/10)/(1+haste/100)))/(1-MAX(0,base_miss-hit-cataclysm)/100)

Basically, since Cataclysm/Suppression only work on certain spells and the spreadsheet is flexible enough to handle an Affliction build casting Destruction spells (such as Shadowbolt like everyone does) or vice versa (such as CoA which most Destruction Locks do) then it can't simply give you 3% more base hit because that would not correctly reflect your hit cap on all your spells.

Rest assured that your hit is being tracked properly.
 
User is offline.
Reply With Quote
Old 12/11/08, 7:27 AM   #7
Koshir
Glass Joe
 
Orc Warlock
 
Свежеватель душ (EU)
It would be nice to add belt socket
 
User is offline.
Reply With Quote
Old 12/11/08, 9:50 AM   #8
kaib
Don Flamenco
 
Undead Warlock
 
Dentarg (EU)
Whenever I try to put in my 31/40 demon/destro imp/incinerate spec and then on the DPS sheet click on load rom talents, the sheet switches out incinerate for SB. Any idea if I am doing something wrong or if that's a problem with the sheet?
 
User is offline.
Reply With Quote
Old 12/11/08, 10:15 AM   #9
Bessa
Von Kaiser
 
Human Warlock
 
Stormrage (EU)
Just readjust the spells to Incin instead, nothing major.
 
User is offline.
Reply With Quote
Old 12/11/08, 10:37 AM   #10
fip
Von Kaiser
 
Gnome Warlock
 
Proudmoore
Easier solution:
Format -> Sheet -> Unhide, choose Templates
in the Load From Talents column, set all the options for your talent build of choice. Save the spreadsheet. Now you will always have your talent build of choice able to be loaded on demand and compared against the default specs it comes with.

That's definitely one thing I'd like to suggest to Bakka is to update the default builds. These appear to still be the level 70 version of builds, for example Haunt doesn't have Ruin or many points in Destro, which drastically changes the dps for the build.
 
User is offline.
Reply With Quote
Old 12/11/08, 12:28 PM   #11
Daidai
Glass Joe
 
Undead Warlock
 
Proudmoore (EU)
I am not sure, but it seems pandemic is using the hole crit for ua and corr.
But i thought it is not affected by scorch and ToW, cause these are mob-debuffs.
 
User is offline.
Reply With Quote
Old 12/11/08, 7:21 PM   #12
heemo
Glass Joe
 
heemo's Avatar
 
Gnome Warlock
 
Magtheridon
One more quick bug: Demonic Pact and Totem of Wrath/Flametongue Totem are stacking though they shouldn't be.
 
User is offline.
Reply With Quote
Old 12/11/08, 8:45 PM   #13
Trickykid
King Hippo
 
Gnome Warlock
 
Turalyon
TNS-spirit doesn't count points in Demonic Aegis.
 
User is offline.
Reply With Quote
Old 12/11/08, 10:32 PM   #14
PSGarak
Bald Bull
 
PSGarak's Avatar
 
Undead Warlock
 
Hyjal
Originally Posted by Daidai View Post
I am not sure, but it seems pandemic is using the hole crit for ua and corr.
But i thought it is not affected by scorch and ToW, cause these are mob-debuffs.
While what you describe is how the game works, it's argueably a bug. The assumption that it's a bug and will eventually be fixed is often justification for not including the more complicated formulas in a spreadsheet. If you want, you can hack in a subtractive term that checks if iScorch/WC is enabled from the pandemic proc chance.

 
User is offline.
Reply With Quote
Old 12/12/08, 4:41 AM   #15
Aedius
Glass Joe
 
Gnome Warlock
 
Nathrezim
I'm currently using Microsoft Office Excel 2007 with the spreadsheet. There appears to be a few issues with the Hit* Value column (Column T) and "ignore after cap" hit option. There is a reference to the file's name which does not update when the file is renamed/moved. This I believe is an issue with Excel.

IF(hit_option="ignore after cap",MIN(MAX(445.91-'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\[wowhead.xlsm]Gear_Buffs'!$J$4,0),H23)*value_hit,0)
This is easily fixed but the next problem comes from the min function there. It does not seem to work correctly if one of the values is an empty cell. This seems to be fixed by filling up the empty cells with a value of zero, another issue with excel. Finally, the formula does not seem to take into account the base miss and misery/imp faerie fire options under the dps tab. I think that is should look something like this:

IF(hit_option="ignore after cap",MIN(MAX(base_miss*DPS!$L$4-misery*DPS!$L$4-Gear_Buffs!$J$4,0),H23)*value_hit,0)
 
User is offline.
Reply With Quote
Old 12/12/08, 10:57 AM   #16
Daidai
Glass Joe
 
Undead Warlock
 
Proudmoore (EU)
Originally Posted by PSGarak View Post
While what you describe is how the game works, it's argueably a bug. The assumption that it's a bug and will eventually be fixed is often justification for not including the more complicated formulas in a spreadsheet. If you want, you can hack in a subtractive term that checks if iScorch/WC is enabled from the pandemic proc chance.

Sure, i did that, i post it only as an information. I hope it is a bug and it will fixed (like SE).
Another point is DS, in the actual spreadhseet it is not working with the number of affliction debuffs.
 
User is offline.
Reply With Quote
Old 12/12/08, 11:27 AM   #17
Rozzenwyn
Von Kaiser
 
Undead Warlock
 
Exodar
Is Illustration of the Dragon Soul implemented? It is showing up on the gear page but showing no DPS in the DPS column.

It seems like some of the lookup columns on the gear_buffs tab aren't working.

A few examples:

40 Haste & 40 Hit foods - the stamina gets filled in but the haste & hit do not. there are no formulas in those 2 columns. I tried adding in the formulas myself counting columns and such to try to get the right one because the info is on the consumables page but just isn't getting looked up. However that didn't work and instead broke the spreadsheet and then I was getting NA for dps.

Leg Enchants - None of the ones with a spirit component work right. Spirit is not getting looked up. Again it is in the consumables tab but there is no lookup formula in the gear_buffs tab. That's kinda a big deal considering how much better spirit is for us these days.

Can you add Fire Seed (I think that's the caster version) as another consumable.
 
User is offline.
Reply With Quote
Old 12/12/08, 1:23 PM   #18
Bakka
Von Kaiser
 
Orc Warlock
 
Kalecgos
New Version 3.0.3f at WoW Warlock DPS Spreadsheet

Tricky, Wha?
 
User is offline.
Reply With Quote
Old 12/12/08, 1:31 PM   #19
Bessa
Von Kaiser
 
Human Warlock
 
Stormrage (EU)
Just me or theres no Spell Dmg listed on any item?
 
User is offline.
Reply With Quote
Old 12/12/08, 2:01 PM   #20
Trickykid
King Hippo
 
Gnome Warlock
 
Turalyon
Originally Posted by Bakka View Post
New Version 3.0.3f at WoW Warlock DPS Spreadsheet

Tricky, Wha?
On TNS-Spirit tab, cell B2 and B3 add +.3. They should add +.3+.03*daegis.

I just checked the Gear_Buffs tab and looks like the same thing. Cell G76 reads:
IF(B76,180*(1+daegis*0.1)+M4*0.3,0)

While it should read:
IF(B76,180*(1+daegis*0.1)+M4*(0.3+.03*daegis),0)

EDIT: Other comments:
-Brilliant Spell Thread (leg enchant) should have +20 spirit, not +20 mp5
-Belt needs buckle
-Need the new glove enchant +28 spell power
-Bracer enchants needs the Leatherworking +67
-Potion of speed doesn't load any stats
-No t7 bonuses included yet (all the proc items have the necessary stats calculated on Advanced infos tab)

Last edited by Trickykid : 12/12/08 at 2:32 PM.
 
User is offline.
Reply With Quote
Old 12/12/08, 2:33 PM   #21
turturin
Piston Honda
 
Gnome Warlock
 
Echo Isles
Originally Posted by Bessa View Post
Just me or theres no Spell Dmg listed on any item?
None of the haste/hit/crit/spellpower seems to be listed on any item atm.
 
User is offline.
Reply With Quote
Old 12/12/08, 3:39 PM   #22
Ossifrage
Glass Joe
 
Gnome Warlock
 
Kil'Jaeden
Arcanum of Dominance - Shoulder Enchant from Stone Keeper's Shards. 29 Sp 20 Resil
 
User is offline.
Reply With Quote
Old 12/12/08, 4:16 PM   #23
Rozzenwyn
Von Kaiser
 
Undead Warlock
 
Exodar
Originally Posted by turturin View Post
None of the haste/hit/crit/spellpower seems to be listed on any item atm.
Agree this does seem to be broken at the moment.
 
User is offline.
Reply With Quote
Old 12/12/08, 4:19 PM   #24
Bakka
Von Kaiser
 
Orc Warlock
 
Kalecgos
dmg,hit,crit,haste have been fixed

I'll add the demonic aegis and master summoner stuff in the next version.

I'm not touching belt buckles until the armory does.
 
User is offline.
Reply With Quote
Old 12/12/08, 4:32 PM   #25
Rozzenwyn
Von Kaiser
 
Undead Warlock
 
Exodar
Originally Posted by Bakka View Post
dmg,hit,crit,haste have been fixed

I'll add the demonic aegis and master summoner stuff in the next version.

I'm not touching belt buckles until the armory does.
<3 Thanks for getting so many fixes in so quick!
 
User is offline.
Reply With Quote
Reply

Go Back   Elitist Jerks > Public Discussion > Class Mechanics > Warlocks

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
(another) DPS Spreadsheet Bolche Warlocks 852 11/10/08 1:23 PM
DPS Spreadsheet Dontmindme Rogues 1453 11/01/08 2:24 AM
Simply unbeatable rock (Druid/Warlock) to my scissors(Priest/Warlock) in 2v2? tristantio Player vs. Player 34 11/06/07 5:22 PM
[Warlock] Shaman vs 24/37 Warlock - 1v1 strats/help Cronjob The Dung Heap 2 09/24/07 2:05 PM