On the items page, how would I go about making a separate DPS value column that ignores hit on gear?

On this topic I tried disabling all the default buffs (with a default spreadsheet) and still ended up with these stats:

Dmg Dps Bonus - .74
Hit Dps Bonus - 1.22
Crit Dps Bonus - .88
Haste Dps Bonus - .90

Every spreadsheet that I have seen since before this beta has always valued damage above any other stat no matter what, so I am skeptical that Haste and Crit would be so much more valuable now. If these numbers are true that would mean all end-game locks would start socketing their gear with pure +crit/haste gems instead of +dmg (spinels). Forgive me if you changed your calculations due to new testing but I just want to make sure there is no bug that is skewing the results. I played around with the settings for quite a while and couldn't get anything that looked "normal" when it comes to these point bonuses.

Hi Bolche

Can you add [Eye of Magtheridon] ?

Thx!

If Raid TNS is turned on, haste and Crit are heavily favored, as they both increase ISB uptime. Also, Haste affects GCD, so it has a double dps boost.

That's because of Raid TNS option in Improved SB options which adds a value relative to the ISB uptime based on how your next stat affects it.

That depends obviously on how you configured your Raid ISB tab.

Edit: What Lock said

- [Eye of Magtheridon] added
- 4 New Epic gems
- [Alchemist's Stone] and [Item not found!] added
- Slightly modified the bonus of destruction pots. It now assumed that you don't LT during the potion effect (increase effect by ~5% in the default setup).
- [Item not found!]
- Changed 2.4 LT to 20% HP / 20% MP
- Added a new column on the Item tab : it shows the dps value difference between the item and the one you wear, ignoring +hit rating on both.

--> http://www.leulier.com/spreadsheet/w...v2.0-beta5.xls

Even with the 2.4 LT option, the [Item not found!] is far from the other Metagems. This is what I get with the default destruc build and early T6 stuff :

Chaotic Skyfire Diamond 35,69
Ember Skyfire Diamond 14,00
Imbued Unstable Diamond 10,57
Mystical Skyfire Diamond 26,17
Swift Starfire Diamond 9,06

I think you should change the bonus from gem for this one [Frozen Shadoweave Shoulders]

It's +3 hit and not + 4hit

Even when disabling the Raid TNS option and messing around with Raid ISB models the difference is negligible and haste/crit still come out ahead of +dmg.

I have to say, this is by far the best Warlock tool ever. Not only being able to calculate your dps, but doing so with easy to use drop down menus, and being able to compare gear in real time against your TNS values in phenomenal. I made a lot of bad gear choices going through Hyjal and BT. This spreadsheet has me fully prepared to easily find best in slot items to that I don't make those mistakes again in Sunwell.

Some things I've noticed on the 2.0b5 sheet (haven't checked the 1.x sheet yet):

Soul Siphon still shows up as 2%/5%. It was recently changed in 2.3 to increase amount drained by 2%/4% for each Affliction effect on the target (up to 60%). Not a huge change, since you shouldn't be DPSing with Drain Life, but for completion's sake, it should be updated.

The comment on Imp Searing Pain states 3/7/10% increase, though the dropdown is correct at 4/7/10%.

Enchant for head item is not a dropdown list like many of the others. I know everyone uses the same one, but perhaps a "None" option should be added.

Should the Demonic Knowledge buff be calculated based on the talent from the DPS page? Currently, I can select it on Gear Buffs page even with my affliction spec entered.

I'm having trouble getting the imp to work correctly with an affliction build. It stays Out of Combat the entire time (phase shift), but the OOC regen isn't enabled. I think the MP5 for the lock is fine, and certainly accounts for mana gained from Dark Pact. However, on the pet tab, it'd be nice to see the total MP/s value including the OOC regen if the pet is not casting fireball. A second note, if the pet IS casting fireball, the dark pact value doesn't change, and it definitely should. The Imp being used or not doesn't propogate to the Pet DPS tab, either. If the Imp is casting fireball, some change needs to be made for it's mana regen and frequency of fireball since it can't chain cast without mana feed or other regen.

In 2.4 Options, the first line is 2.4 CGD...should probably be GCD. Also, Demonic Knowledge is being changed from 5/10/15% to 4/8/12%.

For 2.0b5:

Maybe I misunderstand how the gear works, but it looks like Slippers of the Seacaller isn't picking up any gems.


Also, and this is very weird:

The gear selection I chose shows up as 203 hitrating on the spreadsheet, but 198 on my gear. The funny thing is, if I go down the +hit column manually in the spreadsheet and add it up, it adds up to 198. I can send you a copy of the spreadsheet I have, that might be easier than listing out the gear for you to see if you can replicate it.

Nice updates!

Got some more for you:

- The Meta gem in the helm is counted regardless of the gems available in the helm slot. For example, in the current download on WoW Warlock DPS Spreadsheet by Leulier, the Spellstrike Hood is selected, and the 12 crit from the CSD shows up anyway, even though that helm has no meta slot. Also, any plans to enforce meta requirements?

- For Demonic Knowledge, the Gear Buffs tab assumes everyone has it regardless of the talents entered on the DPS sheet. Changing the formula to read at the end of it fixes that issue.

Here's an idea I implemented on my copy, dunno if others would like it or not. On the items list (very nice job there!), I've modified some of the conditional formatting. I removed the first rule that seemed to use about 15-20 different ranges and didn't appear to serve any real purpose. On the Gear Buffs sheet, where you list the currently equipped gear, I named each cell that corresponded to a specific piece of gear (equipped_head, equipped_neck, etc). Then on the Items sheet, I added a format applying to each section that would color the line light yellow if that item was equipped. I know the value is 0.00 and bold/blue, but having the line highlighted for me made it much easier to read. I'm still playing with the best way to determine the equipped item and highlight the line since Excel has strange limitations where Conditional Formatting is involved.

beta5 issue found.

If you are hit capped, the Items tab doesn't correctly identify dps loss from dropping hit.

Ex.

Armory

Putting in this gear, if I look at the Chest section on Items tab, [Tormented Demonsoul Robes] shows a 39 DPS upgrade. However, selecting it is a loss of 5 dps, due to loss of 23 hit on T5 chest. I believe the badge robes are a small DPS upgrade, but it requires swapping in hit elsewhere.

The DPS change column assumes current item-values. Unless I'm mistaken, creating a "true" DPS-change by using an item over the current one would require a separate sheet for every single item.

When I choose items I select every slot as if I were not hit capped (I set hit % to be below 16% by enough that TNS section shows full value from hit rating. Then I make sure I have 4PT6 by swapping out items with the lowest DPS loss to get the bonus. After that I let hit% be a true value and go by DPS change ignoring hit (which essentially shows gained DPS by trading out hit rating) and swap in items until I am within 1 item of the hit cap. Maybe I need to dig up my Linear Programming textbooks, but I think that's the best solution to the problem.

We already have a '0 hit' column to evaluate those values. Why not automatically assume the value of hit to be at its maximum (For example, on an item with 20 hit, calculate the value of 1 hit at 182 hit) in the first column?


Is it possible to add flamecaps to the consumable section?

Partially fixed : in the versions before 2.1, if you were hit-capped, the item value was equal to the "Ignore hit" value. Now the Item value show the value of the item if 100% of its hit is used.
Now, if you are hit capped, the hit value in TNS section, will be the dps gain from going from (16%-1/12.6) hit to 16%. I made this change because the information that more hit will make you gain 0 dps while capped is not very interesting ;-)

Fixed, thanks
No, but that should not be hard. I will take a look at it.


Here is the 2.1 version, with, as promised, some basic but useful macros :
- Template+options selector : allow you to select talents and usual options for the most common templates. Currently :
0/21/40 Shadow, 0/21/40 Fire, 0/21/40 hybrid, UA, Affli/Ruin, FG 7/43/11, FG 1/44/16, 0/40/21 Succ, 21/0/40, 24/37/0 PVP
Of course, you can, and I some case should adjust some options to fit exactly your template/options. "Templates" are composed of talents, and includes the following options :
Filler spell, Pet, Immolate, Corruption, Siphon, Unstable affli, NF Proc, Dark Pact, Pet DPS

- Item Sort : 2 buttons to quickly sort items by dps value and by dps value ignoring hit.

--> WoW Warlock DPS Spreadsheet by Leulier

1) I knew nothing about Excel Macro before starting this project, so the may be very badly coded. If you have some comments about macro, please post them or PM me.
2) I googled a little about it but it does not seems to be an easy way to make macro compatible with Open Office. If someone as already dig the problem, I'm looking for advices !


Planned :
Items sets system. Same thing as template : a few pre-made gears, like "pre raid 25", T5, T6, some automatic one, like "best in-slot", "best gear set" (this one is really tricky !), and the possibility to save you own gear set (like let's say 3 different sets). I will try to make a "best available", with somewhere checkboxes for you to set what content is available to you. This idea is taken directly from the very nice rogue_dps_spreadsheet, wich is a model for many things.

Is there a way to get Flamecap usage in for Incinerate users?

Hi Bolche, I'm loving the new spreadsheet to bits! Great work. I have found what I think is a bug though with the shadow priest mp5 calculation. Perhaps I'm not thinking clearly, but assuming 100% VT uptime, mp5 regen should be:

mp5 = Shadow priest dps * 0.05 (VT mana returned) * 5 (seconds)

1600 shadow priest dps is estimating 304 mp5 where I suspect it should be more like 400mp5?

Sorry if I'm way off.

Unless i'm mistaken there is currently no way to model incinerate hitting a immolate debuffed boss unless you put immolate up yourself.
Would it be possible to add immolate in the debuff list, ala cos etc?
Thanks!

You can uncheck Immolate from your DPS tab and it will simulate Incinerate spam without casting Immolate.

Incinerate damage is the same whether Immolate is checked or not.

Wait a second. If i uncheck immolate and check incinerate is it considering the damage that an incinerate would do IF the target was consumed by immolate? My guess is that if i uncheck my own immolate the incinerate values considered are the ones in the case that the boss has no immolate on him.

EDIT: my bad, unchecking immolate changes incinerate dps by 1. I guess that the scenario that is missing, noone is casting immolate, makes it worthless so there is no point adding it. Thanks for the reply.

Yes, I divided by 5 instead of 4 (0.05*5 = 0.25 = 1/4) Fixed.


I confirm that incinerates assumes incinerate is always up.