Elemental, Shaman, Spreadsheet, WoW

ZAP! 1.2.2

I don’t like spamming the blog with new spreadsheet versions, but once again it’s a minor update that’s quite important.  Version 1.2.2 changes:

  • Item Ranking Links: Wowhead, LootRank and Pawn ranking links have been added to the Calculator tab.  This happened so quickly because I was very kindly invited to copy the “code” out of SEIC.
  • Phylactery of the Nameless Lich: These items are now in-game and as such we finally know their internal cooldowns to be 90 seconds, which changes the value of the trinkets somewhat.
  • Glyph of Elemental Mastery: there was a mistake in the way this interacted with 2t10 which I only became aware of when somebody else pointed it out to me.  For the details, check the thread on EJ.

The upshot of the Phylactery and Glyph of EM changes is:

  1. Normal Phylactery is about even with normal Reign of the Dead, and Heroic Phylactery is about even with heroic Reign of the DeadHeroic Spyglass is slightly better than the normal version of either trinket, but not as good as the heroic versions.  DFO is secure at the top of the table.
  2. Glyph of Elemental Mastery is simply never going to challenge Glyph of Totem of Wrath at any gear level.  It seems that as we approach BiS level, the dominant glyphs will remain Glyph of Lightning Bolt, Glyph of Flame Shock and Glyph of Totem of Wrath.  Even Glyph of Lava slips well behind once we get rid of 4t9.

(That reminds me, I need to update the BiS post now that the Lich King’s loot is known.)

The new item ranking links are on the Calculator tab – just click the relevant links to use them.  For Pawn, you need to click the “Update” button and then copy the contents of the relevant cell to the Pawn import option.

Download v1.2.2Download v1.2.2 Compatibility



9 thoughts on “ZAP! 1.2.2

  1. That’s a shame about Glyph of EM – I had high hopes that we wouldn’t be relegated to the three exact same glyphs by a large margin. Definitely a good catch on the calculations, although I’m surprised that the change was that drastic (over 60% reduction in effectiveness with my gear situation)

    Posted by Shkarn | February 5, 2010, 6:34 pm
    • I think the change looks drastic because it’s gone from just allowing an extra EM to be used to …not (with default settings). If you turn on smooth haste effects the result is less dramatic, but then GoEM DEP was lower with haste smoothing on in most situations anyway. Without haste smoothing, the value will depend largely on fight time – in default settings it goes from a low of 20 to a high of 50 depending on time.

      Posted by Charles | February 5, 2010, 7:49 pm
  2. Hey there!

    Long time reader – sometime poster, here.

    I’m really surprised that Glyph of EM didn’t perform better. I have been using it and I thought I was doing pretty well.

    I had tried to use Glyph of ToW and was really surprised how poorly I did perform with it.

    Without getting too much into the technical talk, what is the reason it’s not helping? Are we casting too fast? I’m about the 1100-1200 haste range and I loved it. I popped it everytime it was up.

    Could someone clear this up for me, with some great explanations that I’m used to from you guys? 🙂


    Posted by Ushapti | February 8, 2010, 9:38 pm
    • EM itself is a reasonable DPS boost (though, in the big scheme of things, still rather small). 2-piece tier 10 is also a decent bit of extra DPS because it has a dramatic effect on how many times we can use EM in a fight – potentially doubling the usefulness of the effect.

      Glyph of EM, however, does not have much effect on how often we can use EM. At best it seems to work out to one extra usage per fight, maybe two in a very long fight. And that’s … not a lot of extra DPS. It’s not terrible, but it takes up a valuable glyph slot that could be filled with something better.

      Of course, all our major glyphs – the Big Four as well as Flametongue and EM – are separated by only about 100 DPS value. That’s too small to really observe in play, as our DPS can vary by thousands on the same encounter with the same raid setup and stuff. Still, even though we wouldn’t lose a “lot” of DPS by using Glyph of EM, I can’t see why we’d want to.

      Posted by Charles | February 8, 2010, 11:54 pm
  3. Thanks very much for the explanation!

    A guildie of mine and fellow ele shaman discovered a thread on EJ about what stats represent for us and there was a number on there that 966 haste was some sort of cap for how much haste you may need and then should be going for straight spellpower.

    What are your thoughts on this? How much haste is too much? Should we be gemming for sp/haste or just sp and if so, at what point?

    As always, your help is greatly appreciated.

    Posted by Ushapti | February 9, 2010, 2:56 pm
    • I presume you’re referring to this post? The 40% haste mark isn’t a “cap” of any kind, it’s just the highest value of haste tested for to produce the following graphs. Bear in mind this was back when having more than 900 haste seemed very unlikely.

      In terms of minmaxing, we should never gem pure haste: a Runed (SP) gem is always better than a Quick (haste) gem, and a Reckless (SP+Haste) gem is only worth considering to get a good socket bonus.

      (I also looked at the “haste cap” question in the post “Updates and Questions“.)

      Always gem for Spellpower (Runed) unless:
      a) you need to activate your metagem (requires 2 blue gems – use glowing or royals) or
      b) there is an achievable, worthwhile socket bonus which requires one or more yellow gems, in which case use Reckless or Veiled, or
      c) you need hit rating from gems, in which case use veiled gems wherever possible to get yellow socket bonuses. Rigid gems are an absolute last resort.
      I do intend to write a post on this fairly soon, but Totemz has a post on stat priorities already and the information in the Primer is still accurate 🙂

      Posted by Charles | February 9, 2010, 3:16 pm
  4. Not to be particular, but what would you consider to be a “good” socket bonus?

    Even with using orange gems to meet a socket bonus, it’s usually going to give you less total spellpower than you would have gotten, if you had just gemmed for raw spellpower.

    And if we’re going with the theory that spellpower is better to gem for than anything else, I don’t see a case where gemming for sp/haste would ever compare.

    Just from what I’m gleaning of course. How far from the mark am I on that? 🙂

    Posted by Ushapti | February 9, 2010, 5:22 pm
    • It’s to do with stat weightings, the relative worth of each stat compared to the other, also described as “EP”. The spreadsheet I write is basically a giant calculator to figure out stat weightings precisely so that we can decide what a “good” socket bonus is and when it’s worth gemming Reckless over runed (and the next release will have a socket suggester tool, too).

      Example using pretend numbers:
      Say Spellpower is worth 2 damage/point (DEP) and haste is worth 1.5 damage/point and you have a red and yellow socket with a 5 spellpower bonus.
      Without bonus: 2x Runed
      2*23sp = 46 spellpower = 92 damage points
      With bonus: 1x Runed and 1x Reckless
      23sp+12sp+5sp+10haste = 40 spellpower and 10 haste = 95 damage points
      ==> so it’s better to socket the reckless.

      Posted by Charles | February 9, 2010, 5:33 pm
  5. Boy, you just cover everything don’t you!

    I would love to get you on Vent/TS sometime and just pick your brain for a while – you seem like a pretty big fountain of knowledge, for those of us out there trying to make a career of this.

    And I feel bad for spamming your site with my constant questions – lol

    Thanks for the help so far and keep up the good work.

    Posted by Ushapti | February 9, 2010, 5:48 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Get emailed about new posts!

Join 27 other followers

We write about

%d bloggers like this: