vsop

Thank you so much. Now I can totally geek out at work.

 

Dalmasca

From what I can tell, the T9 bonuses are not active yet in the spreadsheet, but I have found similar results of a ~200 dps increase from 4pc-T8.5 to 2pc-T9.0

In addition, with some favorable RNG, you might potentially notice a high burst difference between the two. Think of it as the lock version of Hot-Streak, but for your imp, lol. Mages will be green with envy... or chaos bolts to the face.

 

Thebeave

I am still getting #### on a couple items like the Talisman of Volatile Power.... I'm also not entirely sure what the two columns are even for. The DPS column and Hit column.... does anyone care to explain (sorry for being a nub with the spreadsheet). I also find it strange that some items are inconsistent... example: most items are default normal versions, however the Talisman of Volatile power is the heroic version

Also, the trinket: Flare of Heavens does not have the correct value of crit on it.

another question i have is whether the dps values for the trinkets are accurate.... I'm not seeing any values listed for procs... Its very strange to see the scaling of stats listing spell power being worth 2x other stats, yet Talisman of Volatile Power is listed as a HUGE dps increase over Scale of fates.... 125sp < 126crit?

sorry for the big post

 

Marklar

Since Duffry seems to be busy at the moment, I have posted a developmental version on the spreadsheet wiki, with support for T9 bonuses and implementation of the patch 3.2 empowered imp changes, along with a few bug fixes.

Warlock DPS Spreadsheet : Developmental_variants

 

Mordekhuul

After entering my character name, region, and server, I go to the gear_buffs sheet and click "Load from Armory". I get a pop-up error window reading:

It only partially loads the gear.

Stand in the fire? CHAOS BOLT!

 

duffry

Thanks for this Marklar.

I doubt anyone follows my site but any who do might have seen that it's been a bit of a weird time for me recently. This is now on the up with time to work on this project opening up again. I've not forgotten the sheet though and have been looking over the things that need doing with a mind to addressing them (or some of them at least) this week. It's been too long without an update especially with so many things left half done. Sorry to all for the hassle.

I'll try and pick out the changes from the version above and include them as appropriate but if you have a changelog that would help.

 

Marklar

It seems the new lines for the OH gem socket broke the gear loaders. Fixed in new version, download link replaced.

 

Aer

Using Marklar's latest developmental version, I loaded my gear from the Armory and tried to save it to one of the custom gear sets, but locked Excel in an endless loop. I tracked the problem down to the VBA code for the Save Item Set button. The Save_item_set subprocedure is missing code that temporarily disable automatic recalculations. These 2 lines of code can be copy/pasted from the Load_item_set subprocedure to the Save_item_set sub. This fixed the problem for me.

Line 148 in Load_item_set inserted as Line 169 in Save_item_set:
Line 161 in Load_item_set inserted as Line 169 in Save_item_set:

 

Aer

Now I am also getting the same Run-time error '91' as Mordekhuul when I click the Load From Armory button in the warlock_dps_v320a.marklar1.xls file.

 

Zaeolos

I believe it may be because the armory is down or something. I get the same thing with the warlock_dps_v320a version.

After checking things out a little more. The item-info.xml page on the Armory is not returning any data. This is causing the issue.

 

Marklar

While it never locked up on me, the save macro was extremely slow. Good catch, implemented in new version.

Also according to Ghostcrawler, the T9 4pc bonus is fixed now. It's not confirmed on live yet, but I've put the change in for now. If it turns out to be wrong, I'll take it back out.

New version posted.

 

cynics

Thanks for the update Mark.

one question i am seeing a bug or some sort of DPS discrepancy when I use the "Talent" Dropdown loader on the "DPS" page.

For example if i leave that page untouched using the default gear and stats you have saved it is 8145.07 DPS for the spec 0/13/58. however it if hit the load button for the exact same spec it drops down to 6744.18.

i am not sure if it is a bug or not but might want to take a look as i tried looking at the hidden pages to see what was a miss but was unable to find anything.

 

Aaliyäh

This is because the glyphs are reset.

 

cynics

Well Played!

thanks i swear i looked at that page and it was fine, but you are 100% correct. THANKS!

 

kenneth20001

•Enchant Weapon - Black Magic now cause your harmful spells to sometimes increase haste rating by 250.

will it not be better in 63 sp or 81 sp now and dps will go up? on p3.3

 

Anthraxx

For a destro lock (rough numbers SP=1.56 Haste=1.15):

63 sp on 1-hander - weight 98,28
Haste needed to match that - 98.28/1.15 = 85.46.
Enchant uptime needed to match that - 86.46/250 = ~34%.

Seems a lot if you ask me. In fact, it should be maybe 40% (pure guesstimate) to cover for "wasted" procs (during transitions etc.).

 

dazmar

I have noticed 3 items in my gear set are 'not supported' in the spreadsheet, and I must use the custom item.

Felspark Bindings (232)
Polished Dragonslayer's Signet
Symbol of Transgression (245)

Not sure if you keep a list to add on the next version, so if you do, here are 3.

 

duffry

The item list is my main concern for updates at the moment.

 

dazmar

Here are a few others I found not in there.


Felspark Bindings (245)
Symbol of Transgression (258)
Felspark Bracers (245)
Felspark Bracers (232)
Leggings of the Demonic Messenger (232)
Leggings of the Demonic Messenger (245)
Runetouch Wristwraps
Shard of the Crystal Heart
Nemesis Skullcover (232)
Nemesis Skullcap (245)
Signet of Soft Lament
Boots of the Grieving Soul (232)
Boots of the Grieving Soul (245)
Gloves of Looming Shadow (232)
Gloves of Looming Shadow (245)
Firestorm Ring (232)
Firestorm Ring (245)
Firestorm Band (232)
Firestorm Band (245)
Mithril Pocketwatch
Sharpened Fang of the Mystics

 

vl0071

Thanks for doing this guys.

Mark I have a question regarding the spreadsheet. Is the calculation for the talisman of volatile power correct? According to the spreadsheet, the talisman would add approximately 200dps over my scales of fate with my current gear. This is unusually high.

 

Marklar

The official version of the spreadsheet incorrectly implements the proc for talisman/fetish of volatile power as 100% uptime (ie 512 static haste). The proc from reign of the dead/unliving is also missing.
Both of these trinkets (including normal and heroic versions) are modeled in my latest developmental version.

I have released a new developmental version with a large number of new items from Onyxia and ToC, as well as more bug fixes. You can find it on Duffry's spreadsheet wiki here.

 

Serok

I noticed an bug with the spreadsheet. I use the Sunreaver Disciple's Blade. When I select the 10N version (which is what I have) the spreadsheet will automatically switch it to the 25N version.

 

Naforce

there is no such weapon from 25man. There is however another one with the same name from 10H!

 

Syrophenikan

That's because 10h and 25n have the same iLevel, hence why you see it that way on the spreadsheet.

 

Marklar

Fixed. Sunreaver Disciple's Blade should be properly distinguished from Sunreaver Disciple's Blade (heroic). Also fixed a typo in crit calculations. Download has been updated.