Bolche

2.2 - 2008/03/11

* Gear Set Load and Save
* Fixed imp stamina
* Added Sextant of Unstable Currents
* Sorcerer's Alchimist Stone changed to 63 damage

I'm also still working on the gems and socketing optimization, but it is not ready yet, and I wanted to release the save/load gear feature asap, because it is very cool ! :-D

The premade Gear set (KZ Tailor, Mid T5, Early T6, T6) are just a selection of good items a warlock is likely to wear at this gear level, they are absolutely not the best gear set you can have at this level. For exemple, the first two lack of hit, while the "T6" set has 221. Maybe I'll update them, but I just wanted to focus on the feature itself.

Warlock DPS Spreadsheet

 

sickecek

Vindicator pendant of conquest somehow breaks the table. I guess when it is selected it has a gem slot but is empty. this creates the problem.

 

Tyralia

Ok so this cast time the spreadsheet comes up with in the Raid ISB tab, is not really the cast time its using in its calculations?

 

thetrueavatar

Still a small parenthesis problem in pet stamina formula.
Your formula is :
Problem is that 0.3 is applied only on bold part while if should be on the whole stamina of the warlock (with the $DPS5.N6 part).
so formula should be

 

Bolche

Fixed, thanks.

Warlock DPS Spreadsheet

 

Akj

The value of Sextant of unstable currents seems incredibly high on the spreadsheet. This is in stark contrast to the shadowpriest wiki . My question is

i) Which value is it closer to?
ii) How does the shiffar nexus horn compare to other trinkets since its basically a blue version of the sextant?

 

Evilwilly

I have an idea for a modification you may want to do to the next version....

I've tweaked the spreadsheet to have a "casted weight" column before the cast time frequency column. I can change CoA, Corr, UA "weights" to 3 for example, to simulate a 3-pull. This cuts the cast frequency in third, and the SB filler adjusts. This isn't a "true" way of simulating this, but I can't see any reason why it wouldn't be accurate from a 'final number' standpoint.

I then modify the dot gap and lag values to simulate the harder scenario of keeping dot gap small on 3 mobs as well as the fact that dots will fall off before they tick to completion. (The latter is hard to quantify, so I just crank lag up a little to "fudge" it).


TNS calcs don't work after I do this, because however TNS calcs the new DPS, it doesn't have weighted columns. I haven't been able to find that yet.

Not sure if you want to work that into your next version, but I find it very fun to play with multi-pull simulations like that.


Second change i make...

Is I add in 3 columns next to the damage calcs for each spell. One for average non-crit SB/incinerate. Then one for avg crit. Then one for ISB SB crit. I change the hit % to 100% for each of those, so that hit doesn't change the value. This is another "fun" column that shows how hard your SB will hit for in the new spec/gear - separate from calculation modifiers like hit/critrate/isb uptime, etc... which, when present, just modify the "average" SB value. Not sure if that was clear or not, but it's a fun stat to know.


Lastly, I'm having problems loading up the spreadsheet on my computer, it says that it's locked and I can't even open it for viewing. On my other comp it works fine though. Anyone know the problem? This comp is running Vista so that may be why....

 

Trickykid

You need to unhide the "TNS-[stat]" sheets and make the changes there as well so they link up.

I think it's just because the sheet has 40 hit instead of crit.

 

Akj

Nice catch. However, I corrected the values in the spreadsheet and the sextant still comes out as the 3rd best trinket after Skull of Guldan & Hex Shrunken Head. Reiterating my initial questions

i) Is Sextant really the 3rd best trinket or is this value inflated?
ii) How does Shiffar-Nexus horn compare?

 

Eph

[Shroud of the Highborne] [Skullfish Soup] [Blessed Weapon Coating]
Any chance to add these?

 

Bolche

As Trickykid said, there was an error with the sextant having 40 hit instead of 40 crit. It is now fixed.

I think the simulation @ shadowpriest.com are pretty good, but lack of flexibility. Also always remember when comparing item with crit rating that the value of crit changes significantly when you (un)check the "Raid TNS" option.

This are the +dmg value I found for my (20% crit only) gear :
Shiffar's Nexus-Horn : 23,43 +dmg
Sextant of Unstable Currents : 29,67 +dmg
What makes the Sextant a 40 crit / 30 dmg trinket. If you take 1 crit = 0.9 dmg, this makes the sextant a 66 dmg trinket.

Warlock DPS Spreadsheet

 

Bolche

1) done. Nice catch, this is indeed a very good cloak, on par with [Cloak of the Illidari Council]
2) done ("20 crit rating" food)
3) I did not found the proc rate, so I can't add it yet.

Warlock DPS Spreadsheet

 

Flamingcloud

Found a problem, When I load the t6 gear set and tried to tweak it to my gear, bracers of nimble thought had a socket in them that was active/adding stats.

Edit: The enabled number reads 0 like the other socket disabled items, however it still gives the bonus.

Edit2: There is something wrong with the wand ignore hit field, none of the items are at 0.0... Or atleast I assume that means something is wrong, considering every other slot has an item as base.

 

Bolche

Fixed x2, thanks !

Warlock DPS Spreadsheet

 

Trickykid

Sort item macro does something bizarre with the weapon slot. Either a bug or it's doing something I can't figure out!

 

thetrueavatar

hello,
could you add a none slot for every enchant ?
I have tried to add them by myself but the sheet suddenly blow up and I was oblige to redownload it.

 

Trickykid

I think everyone who is using this sheet to maximize their DPS is going to enchant their gear.

 

zarikdon

There seems to be some issue in v2.2 with selecting boots with gem sockets. Doing so will break the DPS calculation.

 

thetrueavatar

Indeed everyone want to enchant its gears but sometimes I keep my stuff without enchant cause I don't have the money or mats. So if I want the gear to reflect the current situation of my warlock I need to set none as enchant ^^

 

weet

Just manually edit the enchant values then, the point is anyone who cares about damage is going to enchant their gear - as looking to a spreadsheet for dps upgrades without enchanting current gear is somewhat pointless as unenchanted t6 level gear is in cases worse than enchanter t4 level gear.

 

Pidge

The talent loader, gear save, and gear load macros don't seem to work for OpenOffice. Is there any way I can work around this?

 

Tyralia

yep I am getting the same problem

 

Bolche

I does not do anything yet. The way I defined the "items_mh" table would break the "MH/2H" info.

I will add it.

Fixed. he default gems were "none", instead of " none"

Yes, It does not seems possible to make macro compatible with both, so I would have to write 2 versions of the macro and maintain 2 versions of the spreadsheet. Perhaps when the version are more stable in their features.


If your make a mistake or id there is a bug that suddenly fills you spreadsheet with "#N/A" :
- Find the "local" problem and fix it (or just undo what you did).
- Go to the "DPS" tab, in the life tap option (B30), select 0. This should remove all the "#N/A".
- You can select back the "oom_time" option.

Warlock DPS Spreadsheet

 

• dragon12

The formula in C26 of the Gear_Buffs tab is not correct for cases where there are three gem slots (it currently is the formula to check if sockets 1 and 2 are matched).

Edit:
If I load the T6 set and then select Hood of Hexing, N/As pop up.

 

thetrueavatar

Macro call works for me on openoffice 2.3.
Don't forget that macro usage in openffice is disable by default for security reason.
You have to activate it int tools>options>openOffice.org>security>macro security