Traja

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

 

SAViOR

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

 

Arnath

Yeah, this is how it works.

 

Darthgnomer

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.

 

Sydane

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

 

Dragones

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.

 

RunsWithScissors

His post states he is an orc so I doubt he'll ever get the draenei hit aura

 

Melbuframa

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

 

dualaud

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.

 

dualaud

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.

 

Bolche

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.

Warlock DPS Spreadsheet

 

supplicium

Well, on Behalf of warlocks everywhere, Thank you for your effort over this long stretch of time Bolche. I really hope some one picks this up.

 

• frmorrison

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.

 

Asmodaeus

Is the TPS of searing pain correctly calculated by the spreadsheet? I've been using it to compare the TPS of SB spamming with SP spamming, both with a succy sacced (for capernian) and the TPS of searing pain is lower than its DPS, and exactly the same with 0 points in destructive reach.
I recall reading somewhere that SP does 2 thread per 1 dmg. Can someone confirm this?
Also, it would be nice if you could activate/deactivate Blessing of Salvation in the buffs tab, it seems to be completely ignored in the TPS calculations.

I'm using version 27 of the spreadsheet.

 

Gaborn

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

 

supplicium

ok, So here's a question, since bolche is gone, there's a major error in the spread sheet.

If I have Hex shrunken head in trinket spot 1 (the top one) and say...shifting naaru silver in the lower one. My dps comes out at 2080, if i swap them, it's 2137.

How would i go about fixing this and or has some one decided to take this over?

Edit/ps

Any one know which one is actually right?

Thanks

 

Caven

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

 

dualaud

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.)

 

Sydane

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.

Empathy does not imply approval.

 

Tyralia

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?

 

Kalle

Casting time is base_casting_time/(1+haste_rating/1577). In addition, the spreadsheet takes into account the mana consuption, so +dmg has a minor advantage because it increases damage per mana.

 

• frmorrison

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.

 

Tyralia

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

 

Kalle

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.

 

Gaborn

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.