Here are the features I will add in a future version. You can request features in the comments
Would be nice if you could conver this excellent spreadsheet to an opensource format, f.ex. OpenOffice Calc 
I’ll be looking forward to the ability of seeing the raid dps loss from warlocks going from shadow to fire.
Is there any way you could incorporate some way of showing how much mana and health the shadow priests would regain less for their groups too?
Could you add the option for the BM hunter’s buff that increases all damage by 6%
@Hadin: isn’t ferocious inspiration 3%?
I have the trinket “Icon of the Silver Crescent” (Unique). A good upgrade for this would be “Icon of the Silver Crescent”.
Would be great if the upgrades list were separated into two different sections for each ring / each trinket so it doesn’t list Unique things you already have in the other slot
Is there any way to load up your gear/enchants/gems/talents via an “Armory Import” feature, like that used in Cheeky’s hunter spreadsheet? It takes me forever to gem my gear via the dropdown cells, mainly because I don’t know the gems by heart -_-
Is it possible to have Curse of Shadow properly affect DPS shown (or is it assumed that someone ELSE is using it?) Every time I use it on the sheet, my DPS goes -down- (only slightly though) worse than if I hadn’t even cast it at all?
If so, can a talent cell be put in for us malediction locks, pretty please?
The base assumption is that someone else is casting the curse. The reason you see a minor DPS loss when you enable casting it yourself is because it consumes a global cooldown reducing your effective spam time.
@Vux:
I don’t want to sound like a pessimist or prick… but isn’t that kind of lazy? If you really feel the need just make a macro to copy all the trinkets to two seperate tables and eliminate the one equipped from each list respectively, then alter the vlookup target to your new tables. If you want to see how much of an upgrade something is, you should be looking at the Items sheet anyways, not Gear_Buffs.
@Jubalong:
It works just fine in Oo. Macros work differently in Excel and Oo and are not compatible with eachother. Just delete the present macros and write some new ones of your own, it only take 10-15 mins at most. Compared to the hours Leulier has already put in for us without pay, I think that is more than fair. Here is my edited version. I hope I’m allowed to post links.
http://www.geocities.com/tonyhatesschool/warlock_dps_v24_Oo.zip
Btw, the reason it is in zip format is Geocities would not allow me to upload .sxc
Just a couple of v small bugs which I thought I should report through to you. Nothing extraordinary. Good work on the upkeep of the spreadsheet.
On the “Gear_Buffs” sheet it looks like the drop-down for the Leg enchant type has been overwritten with the Raw Text of Runic Spellthread.
Also, the following item locations do not allow for a “none” to be placed in the Enchant Type drop-down : Wrist, MH, Hand, Feet,
The Back location doesn’t seem to have room for any enchant at all. Even though subtlety doesn’t generate any extra dps, it does reduce threat - so perhaps it is a valid enchant ?
Thanks for your time.
kbd@dragonblight.
ow sorry, I had meant to add this to my last comment, but is there a way for your spreadsheet to take into consideration popping a Destruction Potion in conjunction with Bloodlust and/or Drums.
The reason I ask this is that your spreadsheet evaluates the consumption of Super Mana pots as higher than Destro Pots, however, my intuition tells me that the consumption of Destro Pots during a Bloodlust (plus trinket and other CD’s) yields a greater dps boost.
Maybe I’m wrong - but it would be nice to add itt to the sheet.
Just thinking, a “Length of Fight” input would be nice. It could be used to adjust the values for “On Use:” gear, Bloolust(Heroism), and OOMTime Lifetap/Darkpact.
A copy in Open Office format would be excellent as many of us won’t pay the price for MS Office
I posted one a few days ago Chelm. Scroll up.
An option to calculate an item either without, with, or average value of a proc if it has one, or use would be nice. esp since you cant pop 2 trinkets at the same time, but since the spreadsheet uses just average value you cant mess with it to see with one proc or no proc.
also for people that, like me, are dropping chanting for LW but will chant things like the loop of forged power but wont have chanting when i get the ring from M’uru, seperate chant options for each ring rather than one option for the same thing on both rings would be nice.
The Excel AutoFilters only lets you filter 2 things out (when using the Custom Filter.)
Here’s an easy way to implement filtering for as many sources as you want
I have a little area on the spreadsheet (cells AB5 - AB11) with sources that are “Inacessible” to me (either because I don’t have the professions, or my guild doesn’t do these raid zones):
Sunwell
Hyjal
Black Temple
The Eye
Engineering
Jewelcrafting
World Boss
Then I have next to it:
=OR(ISNUMBER(SEARCH($AB$5,$V5)),ISNUMBER(SEARCH($AB$6,$V5)),ISNUMBER(SEARCH($AB$7,$V5)),ISNUMBER(SEARCH($AB$8,$V5)),ISNUMBER(SEARCH($AB$9,$V5)),ISNUMBER(SEARCH($AB$10,$V5)),ISNUMBER(SEARCH($AB$11,$V5)))
- $V5 = the field with the source. (Honor, Sunwell Plateu, The Eye, etc.)
- $AB$5 = Sunwell, $AB$6 = Hyjal, $AB$7 = Black Temple, etc. These values have $ on both row and column because they should always refer to the same area on the spreadsheet.
What it does is it searches the Source field against any of the stuff I defined above. If it finds a match, it sets it to True. If not, False. And then you can use the AutoFilter to show ONLY the False items, and those are the items that are “Accessible”
Here’s a screenshot for a good visualization:
http://img217.imageshack.us/img217/3164/leulierfiltering2no9.png
You can also use “0″ for placeholders / future filters. That way if you want an extra filter, you don’t have to modify the above formula with an extra “ISNUMBER(SEARCH” field and then copy it down the entire list of items. You can just have 1 formula with like 10 “ISNUMBER(SEARCH” fields and wherever you have defined your raid zones, just put a 0 for placeholders. (Blank will always yield true, so must put a 0.)
———-
Also, for even more added fun! In the screenshot I have a “Both Negative?” column. I wanted a way to filter out all items in which I would lose DPS on “Full Stats” and I would lose DPS on “Ignore Hit”. In that case, the item is completely useless to me, since it would never yield a DPS increase. The equation for that is:
=AND(ISNUMBER(IF(S28<=0, 1, “No”)),ISNUMBER(IF(U28<=0, 1, “No”)))
———-
Anywho, hope this makes it easier to implement zone-filtering on the Items tab
Vux
Dragonblight-US
P.S. About the 2 rings/trinkets, I figured it out. In Gear/Buffs, I just put the same ring/trinket for both slots (even if unique) and that works great =]
I just had a PC crash so I dont have MS Excel installed back yet, but Vux, isn’t exactly what the “avalaible” column does ?
The avaliaible value is determined by the checkboxes in the Gear_Buff tab (T6:T32)
I just had a PC crash so I dont have MS Excel installed back yet, but Vux, isn’t exactly what the “avalaible” column does ?
The avaliaible value is determined by the checkboxes in the Gear_Buff tab (T6:T32)
——————–
Aw damn it. I didn’t even SEE the available column because the word is cut off from the column being too small. Blah
I always clicked those check boxes and I assumed they were broken and didn’t do anything.
Especially since at the top of this very page it says that you’re planning to implement for a future version: “Show/Hide items based your “availability” selection (A list of checkbox like Alchemy, Arena, Badge of Justice, Black Temple, etc.)”.
So I thought it wasn’t in yet.
Bleh.
Well, try out the “Both Negative” formula I have above. That’s a good one. It was always a problem filtering the Full Stats DPS for > 0, since it might filter out DPS increases for Ignore Hit. And the same for filtering Ignore Hit for > 0.
So now this formula looks at BOTH and filters out everything so that you only see things that are a DPS increase on either side!!
Hi,
I’d like to recommend adding the Naxx-Saphiron Shoulder Enchant to the Shoulder Enchant Section
It looks like the spreadsheet doesn’t know if you fill your meta socket requirements was wondering if you could add that.
i read there is a 2 sec casttime for imo in the sheet
but in the tooltip there is it 1,5 …
is this a bug or good?
I notice your spreadsheet does not add any dps value for the SS Pendant of Acumen’s proc, which I would think is non-negligible.
i am not sure if this is a bug, but as soon as i change the boots to my boots, frozen shadowweave, all the cell entries for dps, dmg of shadowbolt, -everything- vanishes, there is only left #WERT!
i am using the german open office calculator. i don’t want to buy the microsoft thing, as i do not need excel etc exept for this spreadsheet.
i got tips on the blizzardforum, like press enter again after choosing the item, but that didnt help, so aktually i can’t use the spreadsheet 
and my second trinket is not included in the spreadsheet, i am using x’iris gift, as i didn`t get anything better since 6 months.
i would be happy if someone could help me with th #WERT! thing.
greetings
Zessa
warlock on Sen’jin DE
edit- i just checked that open office version that was posted aduro, but theres the same thing- i choose frozen shadowweave boots an almost every cell now has #WERT!
i apologize for my bad english, i do not use english that often.
It would be great if we could select 0 for any/all of the Debufs.
Nevermind, figured out that 1=no debuff.
@souris: um did you not fill out the bane talent on the spreadsheet? remember it reduces immolates cast time by .5 seconds also thus bringing the normal 2 second cast down to 1.5
I hope the item update with the new S4/BG gear will come out soon.
why do the capes shadow damage not read out right, the nethervoid cloak has false as shadow damage.
Hi,
Here some comments :
- the gem “Radiant Deep Peridot ” is YB (Y actually in the sheet)
- The Waist “Malefic Girdle” is +37 dmg (34 actually in the sheet)
- is it possible in the item sheet to add the diff between items in percent for the type and in percent for the global DPS ?
- is it possible to add the none option for all enchant location ?
Thanks this is very helpfull
Would also be nice if u could add in the value of the proc on the Blade of Wizardry.
It is selectable in the list already, but does not have the proc factored in.
Could you please add Xiris Gift to the Trinketlist - it ist still used by many WL but not in includet
Could the Wand of Cleansing Light be added. Without +hit needs, it is one of the better wands if you don’t have Demonsoul.
14dam
8haste
red socket - 12dam
26dam/8haste
This is not undergoing any development anymore?
Just since the Warlock talent trees are not updated.
I noticed a few things are missing from the spreadsheet. I would like to see malediction added, and curse of shadows taken away. Coe should be entered to included increased shadow damage as well. Also, unless I’m looking at it wrong, there seems to be no shadowburn in the destruction field.
This is a great spreadsheet by the way. Thanks for making it!
