hm.. you mean that 1,5 * 0,03 = 0,045 and that ruin is not +50 percentage points but crit_bonus * 2?

I'd love a preconfigured "Perfect Item Set", I'm always getting asked by a few warlocks what they should wear because they are too lazy to check for themselves. So I, polite as I am, always click around in your spreadsheet a few minutes. What about a function to autmatically add the current best items from the "Items" tab to an item set?

By the way, that should be the best available: (You are welcome to flame me if I did something wrong =D )
Dark Conjuror's Collar
Amulet of Unfettered Magics
Mantle of the Malefic
Tattered Cape of Antonidas
Sunfire Robe
Bracers of the Malefic
Sunflare
Chronicle of Dark Secrets
Wand of the Demonsoul
Handguards of Defiled Worlds
Belt of the Malefic
Leggings of Calamity
Boots of the Malefic
Loop of Forged Power
Ring of Omnipotence
The Skull of Gul'dan
Shifting Naaru Sliver

Runed Crimsons for red sockets and Reckless Pyres for yellow ones (+1 Veiled Pyre), the two blue sockets are Lambent Chrysoprases(Need to check if they're unique)
--> 2636dps with *all* selfbuffs (including dark runes + super manas), *all* raidbuffs (+ Imp. Divine Spirit) and *zero* partybuffs (shadowpriest 0).
And by the way, I'm an orc

Yeah, this is how it works.

Forgive me if this has already been mentioned but the search window comes up under the ad banner at the top so I can't use it.

Scryer's Bloodgem reports 25 +dmg(all) when it does not do any plus dmg in game
Icon of the Silver Crescent reports 69 +dmg(all) when it does only +43 dmg in game

I suppose these numbers could represent some sort of average with constant use of their Use: feature which increases dmg done temporarily but I am mentioning this in case it is a bug.

All trinkets are itemized in the spreadsheet to include their on-use benefit as if you popped it at every opportunity.

Thats what i got on my spreadsheet to but you are almost always gona have a shammy and his 1% hit aura, so id just put a dmg/stam gem in the helm and t6 shoulders to take care of the 2 blues and not get any Lambent Chrysoprases.

The gear set is correct, however wouldn’t gemming 2 Forceful Seasprays for Blue gems and using 2 more Veiled Pyre for the Hit net you more DPS?

I'll plug this into the sheet in a sec

Edit: Quoted wrong person

Edit2:

ran it through the sheet with what i suggested above and this is what i got *DPS is at 2679* with full raid buffs inc IDS shad priest = 0 no drums/bl. I'm not totally sure why you have 13 more crit in your setup however


Also interesting is that if you use the Mana Attuned Band over Ring of Omnipotence, you wont need to gem any Veiled Pyre and can go Pure 12 Dmg in red & Reckless Pyres in yellow and 2 blues of choice and you still come out with almost the same *DPS @ 2670* I used 2 Glowing Shadowsongs for Blues in this calc, was 3 DPS better then Forceful Seasprays

I'm calculating dps for a fellow Warlock right now and he is using Xi'ris Gift as a trinket right now. Though this is not an ideal trinket, I'd like to calculate dps nonetheless.
Could you please help me setting up this trinket as a custom trinket? I know how to enter values in the spreadsheets item section, though I can't figure out the trinkets dps according to its proc.
Thanks.

Oh my, I just found this per accident.

Still... the values of the other trinkets do not match those under the 'items' section in the spreadheet, so I still don't know which value to put where in the 'Full Stats' and 'Hit''s 4 columns of the 'items' section in the spreadsheet.

I will probably stop WoW in a few weeks.

So, I won't be updating my spreadsheet anymore. I'm very sad because I really enjoyed making a tool that many players used and liked, but I'm sure that many fellow warlocks will update it better than I did in the last weeks.

I want to say thank you to everyone who help me improving it.

I can continue to host the spreadsheet for a long time, so if you are interested in continuing the project, please post here and I can give you access to the leulier.com admin if you need it.

Thanks for your hard work!


Hopefully someone will want to test all those mechanic and pet changes and possible Drain Life/Soul changes once they are settled in.

No, it's not, but there is a quick fix.

in L27 add this at the end of the formula you find there:

This will multiply by 2 the previous value only if your filler is Searing Pain

thanks for all the work you put into this, I really loved using your spreadsheet so hope others will continue it.

Thank you Bolche. Really appreciate your effort in creating this spreadsheet. This brought me far through the game and helped a lot in choosing equipment and gems. I'm very sad to hear you are quitting WoW and stopping the development of this spreadsheet.
I hope someone will pick up where you left off, though you left a very high standard behind.

One question to those who know their way around this spreadsheet more than I do:
With my current equipment the spreadsheet tells me, I will put out higher dps, when using immolate, corruption and CoA in my rotation, but e.g. Recount shows a lower dps the more dots I actually use.
According to recount I get the highest dps with pure SB spam. This is when trying on Dr. Boom.
Could someone please explain this to me, and maybe shed some light on which values are 'correct', so I could determine the best rotation.
Thank you for your help, and please excuse my ignorance if this has been discussed before.
(the search thread function came up with no results searching for 'recount' e.g.)

Being raid buffed, which the spreadsheet takes into account, makes a massive difference in your performance. However, it is significantly easier to get close to ideal dps when doing nothing but spamming shadowbolt than it is to maintain DoTs with limited down time. Your latency will also impact you far more. Try changing to spreadsheet to a higher value for Lag and DoT gap and you may find even the spreadsheet doesn't think you will do more dps with them any more. Your individual conditions and playstyle may mean you are better suited for SB spam than adding in DoTs.

I'm sitting at around 1500 dmg and 100 haste, 202 hit,

By all my own simple calculations, including hit and crit of course...
+10 haste outweighs +12 dmg...however the spreadsheet is still telling me that dmg is better, not by much but it is still better. Playing around with the values in the spreadsheet, I've still got a bit more dmg to go before +1 haste becomes at least equal to +1 dmg...

Formulas I'm using on my own calculations:

non_crit_sb = ( (spell_dmg*1.0571) + ( ( (603-541)/2 ) + 541) ) * 1.15 (succy)

sb_hit = (non_crit_sb * hit) + (non_cit_sb * hit * crit)

cast_time = 2.5 * ( 1- (haste_rating/1576) )

dps = sb_hit / cast_time

What am I missing/doing wrong that is making my calculations show that haste is much better than dmg?

As was pointed out, you have the wrong formula for haste.

At your gearing level, 1 haste is better than 1 damage, however 10 vs 12 is likely a wash in the end. You can use a 5 haste/6 damage gem instead to get half of both.

Thx for the haste forumla fix....but even after fixing the formula, my calculations STILL show haste as being significantly better.....I want to know why does the spreadsheet show that +dmg is still better for me than +haste

ie. which one should I be listening to

Adding the default 50ms lag to your casting time further closes the gap.

Try to hit recalculate in your spreadsheet application several times, sometimes the stat values change a little bit (but should become stable after a few hits).

If you did not make mistakes in configuring the spreadsheet I believe its results should be more accurate.

You are not taking into account mana consumption as pointed out before. Life Tap is a huge factor and it scales only with +dmg.

That's the reason the spreadsheet shows +dmg being better than your own calculations.

Ah hmm ic, that makes sense.

However, why do people (and not just people here, but in other forums and in game) say that with those stats that I have, I should be going for haste over dmg?

hey mate, i really liked your spreadsheet.. it's always a good referral for me to weigh what gems/gears i shld replace for my current stats to give out best dps. btw, was wondering if you'll be working on 3.0.2 when patch comes? haha, hope there'd be