Elemental, Shaman, Spreadsheet, Theorycraft, WoW

ZAP! updates

Christmas is over and it’s back to theorycrafting!  Well, not quite.  But I have been continuing to read and post on EJ over the last few days and this has led to some changes to the spreadsheet.

Changes (since version 1.1.2) – Version 1.1.4:

  • Reign of the Unliving/Dead trinkets are no longer treated as if they were affected by Elemental Fury.
  • Changed the way Reign of the Unliving/Dead proc frequency is calculated as per this discussion. The trinket should now be ranked slightly lower.
  • The Dislodged Foreign Objects trinkets’ procs are now correctly showing their DEP values rather than just their spellpower values (thanks for noticing this, Skajin!)
  • Added DEP for Enchant Weapon – Black Magic, as measured against Mighty Spellpower.

These changes are mostly of interest to those people trying to figure out best-in-slot lists for when the entirety of Icecrown Citadel is available and in heroic difficulty, and shouldn’t affect anyone’s current gear or trinket choices.

The Black Magic DEP thing measures it against Mighty Spellpower (that is, it subtracts 63 spellpower from its rotation calculations) so it will almost always be negative.  It’s basically just an awkward display of the maths I did for the earlier post on Black Magic and there’s presently no way to “equip” the enchant.  I might tidy it up a bit for a later version.

Download ZAP!

Download ZAP! compatibility version

About these ads

Discussion

15 thoughts on “ZAP! updates

  1. Hi, I just started to use ZAP! and it looks good so far, but the output hasn’t changed since I put my info in. Is there something else I need to do?

    Zyko

    Posted by Zyko | December 27, 2009, 6:49 pm
    • Hmm, someone complained of this same issue a long time ago when using OpenOffice but said it fixed itself when they reopened the spreadsheet.

      So first, I’d try saving and opening the spreadsheet again. If that doesn’t work, try downloading it again. If that doesn’t work, try using the compatibility version!

      It’s native to Excel 2007, and sometimes other packages play weirdly with the file format.

      Posted by Charles | December 27, 2009, 7:10 pm
      • Ok, so I tried all that, and still not changing output. But I do have a lolmac, so that could be it. I can open it and use the EP calc, but the output stays at 8211 :/

        Posted by Zyko | December 27, 2009, 11:39 pm
      • What happens if you flip the settings for Chain Lightning or Heroism on and off? Does that cause the other cells to update?

        Posted by Charles | December 28, 2009, 12:21 am
      • That didn’t help much, and I just noticed the DPS box isn’t a formula, just a number that was typed in. Not sure if this is a glitch or what, but I have tried both versions and they are both like this. Thanks for all the help by the way!

        Posted by Zyko | December 28, 2009, 4:06 am
      • The formula for the DPS output should be:

        =(DPS_Current+potwm+potspeed)*(1-Adv_MissChance)*(1-Adv_ParRes)

        If that doesn’t work, you could just try =DPS_Current

        Alternatively, you could un-hide the “Math-Fu” sheet and click across to cell D31, which is where DPS_Current is worked out to see if that is actually working correctly. If it is, the formula to link directly to that cell would be:
        =’Math-Fu’!D31

        I’m sure you’re not the first Mac user to try the spreadsheet, so this is all very odd.

        Posted by Charles | December 28, 2009, 12:28 pm
      • It’s saying that they are unsupported formulas for some reason :/. FYI I don’t use the Microsoft Office for Mac, I’m using iWork, if that makes a difference.

        Posted by Zyko | December 28, 2009, 11:33 pm
      • “DPS_Current” Isn’t a valid reference, or so it says.

        Posted by Zyko | December 28, 2009, 11:52 pm
      • In that case it seems unlikely the spreadsheet will work at all in iWork (ironically), as formulae of that kind are used throughout its guts.

        You could try using Irdx’s ESSE spreadsheet, which is in google docs, or if you feel brave you could give SimulationCraft a try. Both of these will allow you to compare stats and stuff, though obviously if I was totally thrilled with either one I’d have never bothered to write ZAP! :)

        Posted by Charles | December 29, 2009, 1:33 pm
      • Thanks for all the help! I have an old version of MO for macs around here, so I’ll probably dig that up to use yours.

        Posted by Zyko | December 29, 2009, 7:00 pm
  2. Hi, first of all thanks for a great blog.

    I just started using ZAP, and was wondering what the hit/no-hit was about, so I read about it here on your website and I think I get it now.

    But I think you made a small mistake in the “The Compare Things Thingy” in ZAP, it seems the ‘DEP (no hit)’ accounts for hit rating and ‘DEP (hit)’ does not. Hit/no hit seems to be fine in the trinket/racial section.

    Of course I could have missed something, I only just started using this :-)

    Best Regards
    Zeitgeist

    Posted by Zeitgeist | December 27, 2009, 10:50 pm
    • Haha, you’re absolutely right, they’re the wrong way around. Goodness gracious me, that’s been wrong for EVER and nobody’s noticed :D Ah well, I shall change that in the next release f’sho. Thanks for pointing it out.

      Posted by Charles | December 27, 2009, 11:11 pm
  3. For the trinkets, I currently have the heroic version of the talisman/fetish of volitile power, yet this trinket is not on the zap spreadsheet. Is the math to hard to consider due to having to proc each effect, and if so, whats an approximate dps increase from popping it every 2 minutes on cd, every cd?

    Posted by Octavaria | January 3, 2010, 9:56 pm
    • Honestly, it’s not in the spreadsheet because I resent how awful the trinket is :] In terms of DEP it should be lower than all the other 10-man/epic ilevel 200 trinkets including Embrace of the Spider, Abyssal Rune, Eye of the Broodmother, etc.

      I could add it to the next release, but yeah. It’s a horrible trinket and I find it insulting that it was apparently the 10-man equivalent to Reign of the Unliving.

      Posted by Charles | January 4, 2010, 2:07 am
  4. sorry and as well what would be the dep value in consideration of the lst from top to bottom dep values

    Posted by Octavaria | January 3, 2010, 9:58 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 27 other followers

%d bloggers like this: