sneh_122

Thanks, i tried this new spreadsheet. However, the calculation doesn't seem to tabulate after i corrected my latency and Debuffs/Buffs i have selected on the Dps tab.

and still, i can only get 1.3+ dps compared to the computed 2k dps. Sigh.

 

boondoggle

I downloaded the spreadsheet, and noticed something peculiar. Looking at the Items tab, I see that the
Dps value for all the items appears to be negative. Is this a consequence of the TNS being out of whack or
something?

EDIT: I found out what was making all my TNS stats and item dps values go negative, it was whenever I tried
putting Timbal's crystal into my gear buffs. Without that, everything seems to work ok.

 

Abidos

Haunt is affected by Improved Shadow Bolt

 

shadrage

The mana return stated by Life Tap and the mana return actually gained from Life Tap in game differ. I have all the same settings and buffs and triple checked this.

Incinerate seems (I could be wrong) to have a miscalculated mana cost with and without cataclysm, thus resulting in inaccurate DPS readouts when setting Life Tap to the "Needed" option in the spreadsheet.

The Lag calculations don't calculate in to the DPS output at all; I can change this number as much as I like and the DPS is not affected.

Hope this helps =)

 

Bakka

Latest information/version for the spreadsheet can be found at : WoW Warlock DPS Spreadsheet

 

Trickykid

Looking good, the TNS Spirit section is pretty effed, currently. It looks like a lot of the formulas are not using updated values from your recent changes:
-It counts immolate for MC uptime
-Uses a different formula for CoA in the MC uptime from the DPS tab
-Uses the damage-table from +1 spelldamage instead of +1 spirit table.
-The MPS per spell is calculated differently from the DPS tab

On the backdraft sequence, you might want to include some of the instant DoTs as well. Not sure how it pans out with recent updates, but one of my earlier versions had casting corruption during backdraft as an upgrade.

EDIT: More comments:
-I think by turning on Chaos Bolt as well as including it in the Backdraft sequence, we're double counting it. Either CB is in the sequence but turned to off, or not in the sequence and turned on.
-Flametongue totem is missing, should take a max of demonic pact, ToW, Flametongue for the spell power buff
-ISB uptime on the TNS tabs is calculated incorrectly. It's multiplying SB cast time by SB cast time, rather than multiplying SB cast time by SB cast ratio
-Shadow DoTs on the TNS Spirit tab are using ISB still

 

Bakka

TNS-spirit is on the todo list as i really don't like how TNS is handled to begin with. I'm going to try and keep the major ones up to date while I figure out a better way to handle TNS.

One thing to realize about this spreadsheet is that it won't be as accurate as a real time calculator because it determines most things based on averages. As such there's no way casting a dot in a backdraft slot would ever be a dps improvement. The only thing haste affects for a dot is the gcd. Insta cast dots also have the lowest 'cast time' of all spells so it makes no sense that shaving off less time from an insta cast, than that of a spell with a >1.5sec cast time would ever be a dps increase. From a real time perspective (which this spreadsheet is incapable of performing) it may make sense to cast corruption while backdraft is up if the dot is about to drop.

As for chaosbolt, if you're using it in the backdraft, then it does need to be turned off on the main dps part. If you're not using it during backdraft, then you can set it to on and it's assumed you're casting it sometime in the middle.

I'll look into adding FT in a future version, thanks for noticing.

ISB, will be fixed in next version. Thanks for finding that.

 

Trickykid

Yeah, that's true. However there needs to be some way to factor in that by not casting CoA/Corr during backdraft, you will lose uptime from them (as well as MC uptime).

TNS is hard to do in another way (I gave up on my sheet, by the way, because TNS turned into a nightmare with haste, spirit and misses -- sometimes by adding 100 spirit, you'd lose DPS since it'd push the simulated spell rotations into a rut that lose CB cooldowns, or something like that). Other ways involve finding derivatives based off of the sheet, which becomes a pretty giant pain in the ass.

If you do decide to stick with the current TNS method, there's also an issue with Pet TNS, as well as any Dark Pact builds having different "Max DP Frequency" on different TNS tabs.

 

fip

Need to add in Misery/Imp. FF so that we can bring our hit up as it would be in a raid.

 

Bakka

RE: Fip - it's there on the DPS sheet under the debuffs section

RE: Trick - But there's no way to do that without a real time simulator as you cant know if the dot needs to be refreshed during that time or not. The only thing you can do is hit a target dummy and figure out what kind of an uptime on dots you actually have and then use dot_gap as a sort of damage offset. I honestly expect anywhere from 5-10% inaccuracy in reported dps. If I ever see greater than 10 and its not due to a formula being wrong, I'll probably give up working on maintaining this.

 

sneh_122

btw thanks alot for the updates! Just want to highlight that, Nethervoid cloak doesn't add 53 shadow damage anymore. It has 43 spell damage.

 

shadrage

Thanks for the updates as well! I'm about to check out some of the math again after I finish setting up gear choices. I forgot to mention this last time and it hasn't been added last time but:

"Boot Enchant: Surefooted" now grants the user 10 hit and 10 crit

This should be added as a usable enchant now.

Also the lightning capacitor is not a selectable trinket. I know that it's somewhat of a retarded choice for a Warlock to use, but seeing as my crit coming out pretty up there now and my Incinerate is a 1.88 second cast time, I'd be interested in seeing just how good the trinket might be now.

Also, the Ashtongue Talisman seems to be a little bit weird mathy, but I can't tell you exactly why... Not that I use this trinket, but I like to be able to fool around with gear on the spreadsheet and check some things out for knowledge's sake =)

Thanks again!

P.S. Little pet-peeve here but could you remove the extra Runed Crimson Spinel as a gem choice and some of the other duplicates? I realize that there are some duplicates in the game due to for example the Kael'thas 5 man quest giving a soulbound version of some gems, but I don't think anyone is that peculiar about it =P Thanks again, your hard work is appreciated by the community.

 

shadrage

After tinkering around a bit I found that the Haste calculated in the top right corner is either a) inaccurate or b) accounting for backdraft -- however I believe the prior to be the truth. My ingame haste rating is 292 = 18.52% ---- the haste in the spreadsheet is 20%. I tried changing this number manually to 18.52% but it just rounded it up to 19%.

Then I tried taking off the Quags Eye in Gear buffs and it went down to 18%, but once again my ingame haste is still 18.52% without this trinket equipped. I am NOT using the spellstone so that is not being calculated, and I'm not including any extra buffs on either end.

 

Bakka

Haste factors in procs, or any on use gear, and assumes you're using it constantly in order to determine average haste. The cell itself doesnt display digits beyond the decimal point. So if you want to change it feel free and then verify that it's reporting the correct number once you've removed any items that contribute to haste.

The same goes for spell damage by the way. eg. hex lords head from ZA accounts for more +dmg than is listed, so if you have it equipped the spreadsheet will display more +dmg than your ingame tooltip.

 

Bakka

New version 3.0.2c on WoW Warlock DPS Spreadsheet

 

shadrage

Ah, thank you for the explanation Bakka =) and thanks for the update.

 

tkoreaper

I can't seem to get the spreadsheet to work correctly. all I see is #VALUE! everywhere and i choose my build under the drop down menu and click load and nothing happens.

 

Tauraherion

I know this is not as urgent as getting things to work properly, but could you find a way to get the sheet to import our gear directly from the armory?

Every time I update the sheet with a new version I copy my gear column to the new sheet. But it would be much easier if we could just import it.

 

Bakka

Merry Christmas! Don't say I never gave you anything Currently it only supports gear loading. I hope to have talent loading as well within the next few days or so.

New version 3.0.2d at WoW Warlock DPS Spreadsheet

 

Trickykid

This was circumvented by making the TNS-hit actually subtract 1 point (either from current or "max" hit) and then the TNS value was -1*DPS_lost.

Useful for at least keeping a value for hit in there and tells you what the last point gave you...

 

• fallenman

By any chance did this include molten core? If so, how did you model the uptime?

 

sneh_122

Hey Bakka, I tried your spreadsheet, but I could never get 2.2k dps according to what the spreadsheet says that I could provide. Instead I'm only doing 1.5k dps. Could you advise me what went wrong? This spreadsheet was intended for 3.0.2 patch @ 70 right?

 

Bakka

No clue. Spreadsheet could be inaccurate. Start by comparing individual spell damage values and compare what you're seeing to what is reported.

Ahh I see. Ugh tns makes my head hurt. I'm leaving it as is for now and perhaps an epiphine will occur and i'll have a better way to handle it all.

Molten Core has been in every 3.0+ spreadsheet I've released. The model for it is under the Models sheet.

 

tkoreaper

Some help would be greatly appreciated.

 

Bakka

Sorry, can't help you.