First, let me thank Bolche for creating such an awesome spreadsheet.

I just downloaded 2.1 and noticed that a few items were showing errors on the item sheet (Err:502). I have tried to track down the problem but haven't been able to find it yet. The specific items are Voidheart Robe, Trousers of the Astromancer, and Girdle of Ruination. Also, I use Open Office.

I've found a minor stat discrepancy with the Carved Witch Doctor's Stick. The spreadsheet has it listed at 19 intellect instead of the actual value of 15. So far I haven't noticed any other items with incorrect values but if I spot any I will be sure to let you know.

*EDIT* Icon of the Silver Crescent is currently listed in 2.1 as +dmg (all)=43+153/6 when it should be +dmg (all)=43+155/6.

I've found 2 little issues on items:
- Voidheart Robe has 13 crit rating instead of 13 hit rating
- Destruction Holo-Gogs are missing

Fantastic upgrades recently Bolche. I've been using your spreadsheet for a looong time and you have recently taken this to project to dizzying heights. Keep up the great work!

I know it's old school, but the [Neltharion's Tear] is still pretty pimp, damn you Illidan... drop your skull! Anyways, any chance you can add it in?

You have made some nice improvements to the spreadsheet recently. Keep up the good work. If you get a chance, please consider adding two items to the item tab of the spreadsheet :

1.) Crimson Bracers of Gloom (Blue from heroic ramparts but better than many epics)
2.) Scryer's Bloodgem (Also a blue but has alot of spellhit plus clicky damage increaser)

Please add Scryer's Bloodgem (32 hit rating and 25 damage).

Life Tap's change is being reverted, so at least for 2.4 we still will have our spell damage enhanced Life Tap.

Wow I didn't even notice 2.1 until I started telling another warlock in my guild about this spreadsheet. Holy crap does all the work you have done help out a lot. The best part about it all was I was hoping someone would do something like this, mostly so I don't have to bother thinking about anything..


Anyway, could you possibly add [Sextant of Unstable Currents] to the spreadsheet? I have no idea how to play with the values in order for it to take my actual current crit % so that the sextant gets proper representation for my current gear selection, I think this would be a great way for me to tell if the Sextant I have been using (since I can't seem to get anything better) is as junk/great as I think it is.



Is it possible for the future to add a table similar to the socket bonus tab that displays the best possible value out of your currently selected items, gem choice wise? I'd rather have something that tells me "hey! your best bet for this red socket is a haste/dmg gem and not that crit/dmg gem moron!" kind of thing.

SimulationCraft/Trinkets/Warlock - Shadowpriest.com Wiki
This site has a good weight on trinkets, but the exact calculations are based off the spec used on the site.

While the shadowpriest.com wiki is still good for a 1st approximation, it might be a good time to revisit the data/simulations there, as the builds/stats they used are a little outdated at this point.

Example, these are the assumptions for a 21/40 shadow build:
It's pretty commonly accepted that immolate & corruption aren't included in destruction cycles. It doesn't include any haste effects, and 1417 +shadow is low for a T6 warlock. It also doesn't take into account any ISB effects (which are probably a minor consideration WRT trinkets, but should still be looked at for completeness).

It's also pretty easy to put trinkets into a single expression for expected stat values. Also since most of these depend upon variables that can be found within the spreadsheet, you can see how a trinket's value might change based on other changing factors.

The sheet 'Pet-TNS' isn't updated with the spells you choose in the 'Pet-DPS' sheet (under Used), resulting in some strange numbers in the Next Stat section in the 'DPS' sheet.

For example: Activate the succubus as you pet, turn on the Used/Option in the 'DPS' sheet and then activate her Lash of Pain in Pet-DPS. Then check the Next Stat section for some strange results

Im experimenting with the calculator with my current items, raid buffs etc, with 66% ish sb up time as calculated again by the worksheet. 0/21/40 raid dps (1455,63dps) is significantly lower than 0/21/40 fire (1538,81 dps), (both calculated with cos/coe with malediction, shadow priest and imp scorch buff). 2.4 emberstorm isnt selected for the calculation. Most of the guides i have read till now said shadow destro dps is superior to destro fire dps. Is there something wrong with the calculator or with this shadow>fire argument. If the calculator is correct with the new emberstorm, the difference will be even higher.

stats copied from the sheet.
Add shad 1456
Add fire 1425
Total crit % 29,43
Hit % 16,00
Stamina 787
Intellect 556
Haste % 2
mp5 334
HP 11514
Mana 10991

Firstly, I would like to thank Leulier for all the effort he has put into this spreadsheet, it is greatly appreciated. Secondly, I am curious as to whether or not Warlocks at a similar gear level (4-piece T6, best in-game in almost all slots) have experienced stat weightings similar to the ones I have got with consumables and full raid buffs (no group ones):

My values were:

1 crit rating = 1.08 damage
1 haste rating = 1.35 damage (with 2.4 GCD)

At first glance I was a bit surprised, as I was under the impression that damage was better than crit rating point for point, even if by a small margin at the gear level I'm at - but then I realised that that assumption was based before the CSD was released, and as a result it would make sense that crit rating would scale with damage in a sense, seeing how the CSD is a % of crits, and the more damage one has the bigger said crits would be. Keep in mind that I haven't done any maths to back up my assumptions, it just makes sense and I guess I am sharing my reasoning.

At any rate, I was wondering if any other Warlocks with top end gear received similar results to the ones I have - as while they do make sense once I think about it, it is something that I simply did not expect.

Try modifying your shadow users raid make up on the other tab. Once I changed mine to reflect similarly geared warlocks the value of my crit dropped down to about .85 when it was at 1.01 just before. My haste is at 1.25 (pre 2.4) though.

If you have Raid ISB set up crit-values include added DPS via ISB uptime. If that isn't active, you can see how the different stats affect your personal DPS.

Wow this spread sheet has come along ways since I first started using it. I just jumped from 1.16 to 2.1 and damn nice job. So here's a feature request for you. A way to save and load the gear choices. Even if it's through an import/export to a csv file would be great.


Thanks,
Bakka

Internal Cooldown is definitely 45s, although I've never honestly ran a mod to check the true proc rate of that (and sometimes its damn fustrating when it doesn't proc crit after crit)

Awesome! Thanks

Hello,
First tank you for this spread sheet which is really incredible.

However I have found some mistakes in the imp stamina calculation.

Indeed the formula is :

which provide 329 stamina(573 stamina for my warlock) for my imp while it's 420 in the game.

I have made some search and found 3 mistakes in this calculation.

• First problem
  the fell stamina must be computed only on the warlock stamina.
  So you don't have to take the base 114 into account.
  this means that your formula should be writted:
  
  
  

   =(114+(((DPS!N6)*0,3+C9+C11)*(1+fel_stam*0,05))*(1+0,1*C12))

  I don't know for the bless of king but I guess it still have to be computed on the whole stamina.
  
• Second and third problems are related to blood pact which isn't taked into account.
  
  So you have to add the buf to the warlock stamina and to the pet stamina.
  
  However I have noticed that blood pact isn't 70 but 80 for my warlock and 81 for my pet.
  As I didn't took improved imp I have found this very strange.
  
  I suppose that for my warlock, demonic embrace add 15% of stamina to blood pact and the.
  same for imp with fell stamina.
  So I get 80.5.
  I guess my stamina was more like 572.7 round to 573 for display and for my imp more like 329.4 round to 329.
  With blood pact on real value I get 572.7+80.5=673.2 round to 673 and 329.4+80.5=319.9 round to 420 for my imp.
  This probably explain why blood pact seems to add 80 and for my Imp 80.
  
  
  So whith all those explanation my formula became:
  
  

  =(114+(((DPS!N6+70*(1+DPS!D4*0,03))*0,3+C9+C11+70)*(1+fel_stam*0,05))*(1+0,1*C12))

  Which gives the right value 420.
  
  I have hardcode the 70 value of the blood pact. Maybe this should be externalized.

Hope it was clear enough. Feel free to ask any precision.

BTW I think that the first problem should be corrected as well for other pets. I have also noticed that the base stamina for succubus isn't correct too.

I'd like to thank everyone who has helped out on this spreadsheet. Keep up the good work.

Here are a couple of possible corrections in v2.1:
- CoD mana cost (lists!H3) is listed as 300, should it be 380?
- TNS-hit!hit is set to:
Should it be:
?

Thank you thetrueavatar for your comments, I'll check this and make the need corrections in the next release.

tandem :
No, I changed the way TNS hit is determined. Now the dps of the TNS_hit is the dps with 1 hit rating less. So the dps value of 1 hit is : -('TNS-hit'!dps-dps)

This changed was made to be able to keep an estimation the value of hit even while hit capped.

Hi Leulier, very nice spreadsheet, great work

I just had a couple of questions:
-I have an average ping of 500ms, so for the lag field I put 0.5 correct?

-I notice that it says my dps cast time is therefore 2.87 (I have some haste) but I thought that now if you spam your shadowbolt key, it will actually start casting as if you had no lag? So only the first shadowbolt you cast will be of the long cast time. The way I pictured it (with 500ms ping and 2.5 sb cast time) is:

time
0 - you press sb
0.25 - server starts casting sb
0.5 - you see sb start being cast
2.75 - server casts sb, you've been mashing sb key so the new sb starts getting cast now on the server
3 - you see 1st sb being cast and a new one starts being cast immdediatley
5.25 - server casts sb, you've been mashing sb key so the new sb starts getting cast now on the server
and so on....

So it just seems to be like lag only affects the first sb cast.

Lag only really affects the first SB in a stand and nuke situation like the spreadsheet simulates. Blizzard's 2.3 casting system takes care of it.