Quick Wowhead Score DPS De-Conversion:

As has been mentioned here before, Wowhead 'normalizes' the DEP stats from Bink's spreadsheet to derive the Wowhead Item Score. In order to convert the Wowhead rankings to back to "actual" DPS - you can perform the following calculation:

("Wowhead Score" x "Sum of Wowhead stat values") / ( 100 / "Highest DEP Value from Bink's Spreadsheet") = Actual DPS

Where: "Wowhead Score" = Wowhead score for the item - the number in green; "Sum of Wowhead stat values" equals the sum of all Wowhead provided stat weightings (the highest should be 100); and "Highest DEP value..." should be self explanatory - use the highest of the 5 stats (or 4 if no hit is being used).

I am putting together a gear spreadsheet and wanted to work this out, you might find this helpful too if you prefer Wowhead to Lootrank (which I do.).

Wowhead gives a better "presentation" layout, which is useful for comparing items on a one-off basis. LootRank is better for generating consistent figures over time. In other words, I use both.

I appreciate the work you've done bink and its helped a lot, but one thing I want to ask is, when reign of unliving is listed under trinkets in the spreadsheet is that the heroic or normal version?

Given the fact that I'm completely re-writing the rotation calculations, I'm going to have to redo that too, so it'll be whatever I want it to be (probably normal at this rate).

If you click a number in the score column at Wowhead, it will switch to a score that's not normalized by the sum of the stat values, rather only displays the sp*spValue+crit*critValue+etc.

Interesting.

To finish getting the Reign trinkets updated, I'll need to confirm whether charges are generated from overloads & FS dot crits.

With the new FS buff is it now worth glyphing LB, Lava (assume T9 4 set bonus) and Wrath rather than the current LB, Lava, FS?

My gut feel says that 89 SP is better than the FS crit for static fights and FS better for high movement fights.

New version out: http://elitistjerks.com/blogs/binken..._seic_r19.html

Unfortunately, it looks like the Glyph Quandary just became a bit more complicated. The change to Shamanism has increase the value of ToW, and adding CL has decreased the value of LB. There's now a smaller difference between the glyphs, and it will depend on what settings you have to which glyphs will be more useful.

The EP values are calculated on the Rotation dps, rather than the Estimated. The latter is the current rotation + no cl to hit the end of the fight on zero mana.

Think that's everything I need to mention.

Heh, these numbers are funny. ToW adds me 126 dps, while lava gives 128 dps, which means ToW would be superior on gimmick fights that increase haste (thus adding higher damage percentage from LB and CL), whereas Lava would be superior on a highly mobile fight in which Lava Burst would be a greater percentage of our dps. So, we can either stack up on glyphs and change every fight, or just go with whichever we prefer and be done with it (side note, 16k lava burst crits are fun, so there's my choice )

Or have two elemental specs with alternate glyphs.

Bink, I think there might be a bug in your latest SEIC r19 sheet. If you set the Demonic Pact value higher than the SP granted by Totem of Wrath, and then remove Totem of Wrath, the dps goes down, and again back up if you enable Totem of Wrath.

Demonic Pact and Totem of Wrath don't stack, so shouldn't the spreadsheet use the higher Demonic Pact value, and nullify if Totem of Wrath is down at all? (Unless you are using the 3% crit modifier as part of the ToW calculations, which is where the dps increase/drop is coming from). But if that's the case, you have a separate Crit listed in the debuff section, is that the same 3%, if so, then it's definitely a bug.

Right, what I'm saying is ... next to Demonic Pact there is a field that is set to 2000 (I presume that's the Warlocks spell power, that it does the 10% calculation off of). So if you set that to some ridiculous amount (say 4000, thus 400 sp which is > Totem of Wrath), leave the Debuff column "Crit" set to Yes, then disable Totem of Wrath your dps values go down.

If you re-enable Totem of Wrath, dps values go back up ... is that dps going up from the Glyph for Totem of Wrath? Or is it a bug?

You are using r19, right?

I think the issue he's talking about occurs in the sp calculation line. If ToW is set to off it also sets the glyph to off even though it's still possible to drop it for the bonus.

I could be wrong but it looks like it comes from the area in the line saying
IF(I42="Yes",280*(1+glyphtow*0.3),0)) in box d4

The question there becomes: how do you expect to get the ToW glyph bonus without having ToW as a buff?

Unless it's changed recently, you can drop the totem and then drop searing after and retain the buff for the 5 minute time period. If the fight lasts long enough for a 2nd set of totem drops you'd obviously have to waste a global dropping it again and then searing/magma again.

Err yes I wasn't asking you to, and wasn't really asking you to change anything either. I was mentioning that I believe his problem is caused by that.

If ToW is set to off it assumes you don't have the the glyph working when it is possible to have it up. Meaning that any sp value set for the warlock that is less than ToW+glyph won't show and that turning off ToW causes it to not count the glyphs buff in the bonus spell power section.

edit: realized the section I mentioned was wrong if he adds the value of the ToW glyph into the if statement of demonic pact it should give you the values you want Veratu.

Yep, that's exactly what I'm doing .. drop ToW, get the 5m glyph buff, then switch to a dps totem, and rely on Warlock DP.

Thanks for the response Kasouti, it seems that's the issue.

I was just wondering where [Abyssal Rune] rates in the trinkets aswell. I realize that its the same as sundial of the exile except with haste substituting the crit but doesn't it make it A LOT better? not in the ranks for IDS or anything but I've been having bad luck with trinkets lately and I was wondering if its a worthy pick up.

[Abyssal Rune] is right up there with [Embrace of the Spider]. Less passive part but more on the proc. I dropped my [Dying Curse] recently because of hit issues and am now using Abyssal Rune over Embrace of the Spider along with [Illustration of the Dragon Soul]. With Embrace up I have like 1450 haste, which puts me under 1 sec. Lightning Bolts while under heroism.

Using Bink's EP values. [Abyssal Rune] has an EP value of 280.

Edit: Not important