The model for Drain Soul does not seem to include Imp SB:

*With SB as filler the DMG listed for SB increases substantially.
When you set Filler to SB>DS the damage of SB drops and is no longer affected by Imp SB.

I'm trying to trace the equation back to figure out what's causing this but I'm running into a wall.

**Ran a search for "imp_sb" to try to trace it back and I realized that Imp_Sb isn't working for Haunt either when sb>ds is used as filler. It must have something to do with the "isb_uptime" in the formula but its over my head.

The Hit* Value column (Column T) on the Items tab no longer uses any formula. Rather it's just a list of static values. Also, Mainhands and Offhands are not sorting by dps.

Thanks for doing this and for the fixes!

Master conjuror talent is not currently affecting the spellstone/firestone values on the gear_buffs sheet.

Demonic tactics is adding only 5% crit to the pet, it should be 10%

Pet dps is currently not close to accurate (at least in the case of the felguard). In my gear with raid buffs, the spreadsheet calucaltes his dps at 434.57. Normally in raids atm, my pet is between 750 and 1050 dps, with a max of 1525 dps on razuvious (heroic). I'm not sure of the specific issue here, but wanted to make you aware. (Manually adjusted the pet cirt rate to 15%, that only increased the dps to 458, so that's not the problem)....does the pet model include WF totem and other melee buffs that didn't apply in TBC?

A couple problems I've been having with this spreadsheet. I am using Office 2007.

1. When I open the spreadsheet, I get a message box labeled "Repairs to 'warlock_dps_v303f.xls.'"

First message is "Excel was able to open the file by repairing or removing the unreadable content."

Second message is "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

2. I'm assuming that because of that message box the "Load Gear from Armory" or "Load Talents from Armory" won't work once I've put in my name & server on the ArmoryInfo tab.

Is there a way to fix this?

Specs for you Bakka:
Haunt/Ruin:
Affliction
Suppression 3
Imp corrup 5
I. Drain Soul 2
Imp LT 2
Soul Siphon 2
Imp CoA 2
Amplify Curse 0
Nightfall 2
Emp corrup 3
Shadow Embrace 5
Improved Felhunter 0
Shadow Mastery 5
Eradication 10
Contagion 5
Malediction 3
Deaths Embrace 3
Pandemic 3
Everlasting Affliction 5
Demonology
Improved Imp 0
Demonic Embrace 0
Demonic Brutality 0
Fel Vitality 0
Dem. Aegis 0
Unholy power 0
Sacrifice 0
Master Conjuror 0
Mana Feed 0
MD 0
Demonic Empowerment 0
Demonic Knowledge 0
Dem. Tactics 0
Fel Synergy 0
Improved DT 0
Demonic Empathy 0
Demonic Pact 0
Metamorphosis 0
Destruction
Imp SB 5
Bane 5
Molten Core 1
Cataclysm 1
Demonic Power 0
Devastation 0
Imp SP 0
Dest. Reach 0
Imp. Imo 0
Ruin 5
Emberstorm 0
Backlash 0
Soul Leech 0
S&F 0
Imp. Soul Leech 0
Backdraft 0
Empowered Imp 0
Fire and Brimstone 0

Haunt/DemoAegis
Affliction
Suppression 3
Imp corrup 5
I. Drain Soul 2
Imp LT 2
Soul Siphon 2
Imp CoA 2
Amplify Curse 0
Nightfall 2
Emp corrup 3
Shadow Embrace 5
Improved Felhunter 0
Shadow Mastery 5
Eradication 10
Contagion 5
Malediction 3
Deaths Embrace 3
Pandemic 3
Everlasting Affliction 5
Demonology
Improved Imp 3
Demonic Embrace 4
Demonic Brutality 0
Fel Vitality 3
Dem. Aegis 3
Unholy power 0
Sacrifice 0
Master Conjuror 0
Mana Feed 0
MD 0
Demonic Empowerment 0
Demonic Knowledge 0
Dem. Tactics 0
Fel Synergy 0
Improved DT 0
Demonic Empathy 0
Demonic Pact 0
Metamorphosis 0
Destruction
Imp SB 0
Bane 0
Molten Core 0
Cataclysm 0
Demonic Power 0
Devastation 0
Imp SP 0
Dest. Reach 0
Imp. Imo 0
Ruin 0
Emberstorm 0
Backlash 0
Soul Leech 0
S&F 0
Imp. Soul Leech 0
Backdraft 0
Empowered Imp 0
Fire and Brimstone 0

does that work for you Bakka?

The Load Talents from Armory macro has a problem with Improved corruption. Instead of putting the 5 points into Improved Corr it puts them in Improved Drain Soul.

well i seem to have som problems with it

dunno if it is my specc The World of Warcraft Armory But as i do the settings i get the completely wrong stats for what is DPS upgrades. LK Arena 6 sets is NOT the best there is to get ingame...

I think you can safely ignore the Arena sets as they are not available yet. Couple of issues I've found:

1. Talent importing has a minor error, specifically reporting 1/3 Improved Demonic Tactics instead of 1/2 Fel Synergy.
2. Spellstones & Firestones seem to lack the 1% DD/DoT dmg modifier they have respectively
3. The [Ember Skyflare Diamond] doesn't seem to factor the 2% int bonus.

Not a bug as such but the Trinket Comparison lacks proc or 'use' modifiers so is greatly skewed. Overall however, many many thanks for the update.

u can get Arena 6 parts from Vault of Archevon in Wintergrasp so, yes u can get them now

Would be arena 5 no?

While on the one hand the item is not in the game yet, I do believe that:
[LK Arena 6 Warlock Helm]
is DEFINITELY better than anything you can get in game currently. That's +31 spellpower and +30 crit rating over the Malygos helm. It can't even compare. So the numbers are completely right, the items just shouldn't be in the excel sheet yet since they don't exist.

Crit, haste, and hit all scale with spellpower which fel armor gives. That would be why you're seeing a dps increase/decrease most likely.

This still does not make any sense to me though. The spreadsheet shows the DPS increase of 1 spell power as 1.03 dps. If an item has 89 spirit on it that it would increase your spell power by approx. 28 with Fel Armor active. How does this not increase the DPS of the item by approx. 28? It only shows an increase of 4 DPS with Fel Armor active...

Version 3.0.3 g up at WoW Warlock DPS Spreadsheet

Using Fel armor does more than simply give items with spirit a dps increase. All items dps values change with the addition of fel armor because the hit, crit, and haste values become worth more with more spell power. Without knowing exactly what spec, items, etc. you're using, I can't really say whether or not there's a problem with my formulas or not.


No, use a talent calc and post a link.

Very impressive work as usual, Bakka. One question: does the spreadsheet not calculate the impact of latency anymore, or am I just blind and can't find the field?

I removed latency from calculations as it can no longer be modeled with the changes of casting being a combination of client and server side instead of all server side.

Right I understand that. What I'm wondering is if 89 spirit would = a significant DPS increase to an item, at least greater than 4. Regardless of spec or gear, at a bare minimum, Fel Armor increases your spell power by 30% of your spirit. If 1 spell power = 1 DPS, or even if it only = .5 DPS (which would be an extreme low ball), it would still be a significant increase to a particular item.

Again this is in reference to the Sulfur Stave DPS increasing by only 4 when Fel Armor is toggled on. I don't see how spec and gear would make a difference. I could very well be wrong and be missing an aspect of the spreadsheet.

With the new version of your spreadsheet I get N/A across the board for DPS values after loading from the armory

Spell power is almost 5x more important than spirit if you look at some of the weights people are throwing around.

53/0/18 Haunt/Ruin

Hardly. At the very worst it's 30% as effective - it can't possibly go lower.

I am unclear on how soul siphon talent points work - changing the talent value does not appear to alter the dps value at all. I am trying to model the relative utility of nightfall (which only shows about 10 dps/point) and soul siphon (which currently gets nothing per point although this seems wrong).

Soul Siphon only affects 2 things, drain life and drain soul. So unless you're using either of those (or the SB -> DS) as a filler, you won't notice a change.