Elemental, Shaman, Spreadsheet, WoW

ZAP! for patch 3.3.2

I’ve completed the major revision of the ZAP! spreadsheet that I’ve been working on, and it’s now fully up-to-date for patch 3.3.2.  The entire guts of the thing have been rewritten and a lot of new features have been added, some old ones changed, and others have gone altogether (at least for now).  The user guide is not yet updated and I will hopefully get that sorted tomorrow.

Until then, the new version is 1.2.1 and these are the download links:

Download ZAP! v1.2.1

Download ZAP! v1.2.1 (Compatibility Version)

Both versions now ship in .zip file for various exciting reasons.

Note that some of the default settings have changed: most trinkets now proc slightly more often and miss chance/partial resists are on by default.  Also, some stuff has been moved around: trinket DEP has moved to the new Trinkets tab and the Compare Things Thingy is on the new Calculators tab along with ratings converters, a haste calculator and normalised EP.  In addition to this, there’s a so-called Snapshot tab to provide a window on what rotations the spreadsheet is using to work out DPS.

The main additions are an enhanced model including fire totems, multiple targets (AoE) and more haste effects (berserking, hyperspeed accelerators) – all of which are, naturally, fully accounted for in DEP calculations!

Ultimately it’s meant to be a lot more accurate and powerful than the last release as well as being fully up-to-date for patch 3.3.2, so please let me know what you think of the changes.

Full, er, “patch notes” (what? 😦 ) are after the clickthrough.

Here are the changes since the last version that I posted about on the blog, which was version 1.1.5.  There is rather more detail on some of these in the thread on EJ.

New stuff

  • DPS and DEP calculators entirely redesigned. They now pseudo-simulate a full “rotation”.
  • Chain Lightning can now be used on cooldown if desired. You can still elect not to use it during EM/Heroism. Note that the setting for EM use applies to trolls’/engineers’ abilities too.
  • Fire totems:
    • Fire Elemental totem is now fully modelled based on data from the EnhSim project (thanks especially to Levva for this). As it gets some benefit from STR/AGI and AP, there are now stat/buff options for this. Please note that shortcomings in the model are my own fault and not EnhSim’s.
    • Searing and Magma totem are also fully modelled.
    • “Placement time” advanced option increases the amount of time spent “casting” fire totems, e.g. if you have to run into melee range and back.
    • “Time on target” can be reduced if you think your fire totem(s) will be out of range or not attacking for a portion of the fight.
  • You can now select your race and profession bonuses in the buffs menu.
  • Hyperspeed Accelerators and Berserking now fully modelled.
    • Uptime for these and Elemental Mastery can now be toggled between “actual” and “smooth”. The latter models uptime as duration/cooldown*fightlength and the former determines exactly how many seconds they would be active for if you used them on cooldown every cooldown given the fight duration.
  • Limited “Cleave”-style AoE modelling
    • Selecting Chain Lightning, Fire Nova, Magma Totem or Fire Elemental Totem plus more than one target will generate additional damage based on number of targets.
    • The model is rudimentary at present and does not properly affect Clearcasting or spell priorities.
    • Debuffs selected will be applied to all targets.
  • You can now see a “snapshot” of the “rotations” the spreadsheet is using to work out your DPS. My hope is that this may be helpful for new players, as one of the most helpful things to me early in WotLK was going under the hood of SEIC and seeing how it constructed its “rotation”.
  • Flame Shock‘s duration and Elemental Mastery‘s cooldown, as affected by set bonuses and stuff, are now displayed near the set bonuses themselves.

Changed stuff

  • Enhanced movement modelling.  This is mostly only relevant to so-called “advanced” users, but here’s the overview:
    • “Movement per LvB” advanced setting works similar to the old “Rotation delay”, only now the calculator can cast spells (frost shock, fire nova or both) during “movement” if allowed by the options.
    • Spell damage can now be universally modified by the “Deflate spells” advanced option. You can use this to reduce the damage done by all spells of a certain type.
      • Reducing Lightning spells affects both LB and CL and will also reduce the number of Lightning spells factored in to 2t10 EM cooldown calculations.
      • Reducing “AoE” spells affects the primary hit of CL as well as subsequent ones. Sorry.
  • Some default options have changed:
    • Miss chance and partial resists – now turned ON by default. Now also apply to DEP calculations.
    • “Cast delay” is now an Advanced Option. Still set to 0 by default. I hope to model latency and reaction time better in a future build.
    • Trinket proc setting is now at 55 seconds instead of 60. I may do a proper uptime model for every trinket later.
    • “Rotation delay” is redesigned into the new movement stuff.
  • Trinket, racial, profession and potion DEPs are now on a separate tab.
  • Reign of the Dead/Unliving trinkets are now included in DEP calculations, if selected.
  • Haste DEP no longer has freaky dips and peaks at certain values. Instead the spreadsheet performs two separate calculations for haste DEP and selects the most reasonable one to use. This should eliminate most “haste anomalies” from DEP, though not from DPS.

Stuff that’s gone which might come back later

  • Black Magic DEP
  • Encounter statistics
  • eDPS

Stuff I still want to add

  • Short term: Pawn and Wowhead loot rank links
  • Long term: Complicated new latency model

As ever, feedback is most welcome especially in some specific areas!



8 thoughts on “ZAP! for patch 3.3.2

  1. Hey Zamir, I’m not very good with the math thing. Check this out; it’s a Wowhead weighted list of Elemental gear:


    But these specific weights are outdated. How would I go about gathering your stat weights from your spreadsheet? To be specific, there is a Demo Warlock in the raid and I always drop fire damage totems. (I know that fire totems, for example, would not benefit from any haste rating, and therefore spellpower would have a higher weight value.) Help me out if you have the time; I like having a weighted Wowhead list. It makes it very easy to compare upgrades.

    Posted by Bergg | February 2, 2010, 2:40 am
    • Hi Bergg,

      If you look at the section of the spreadsheet that says “Start Here” you’ll see a column called DEP. That column of values will update as you plug stats in, and when I look at wowhead rankings, that’s what I plug in as values. I don’t use the 100 scale that wowhead generally does, but I use the actual DEP values from the spreadsheet and get the rankings in that way.

      Hopefully that makes sense and answers your question!

      Posted by Shkarn | February 2, 2010, 5:56 am
    • Adding a wowhead look rank list is something I’d like to do for the next minor release, as it’s been requested several times now.

      Until then you can do what Shkarn suggests, or you can use the weightings from the “Normalised EP” box on the “Calculators” tab which weights each stat to spellpower – just remove the decimal to multiply them by 100.

      (It won’t make any difference to the weights, so I’m not sure why I suggest it. Eh.)

      Posted by Charles | February 2, 2010, 12:21 pm
      • Thank you very much, you two!

        By the way, just got 4-piece T10 and dipped into 10-man ICC. I really, really like the bonus and the Shamanism buff. I think I’m going to do really well on 25-man.

        Posted by Bergg | February 2, 2010, 10:23 pm
  2. Wow. Playing with this for 3.3.2, and Lava manages to fall behind both FT and EM glyphs. It’s kinda depressing, the effect of this patch has forced us back into the same big 3 again, and I really don’t like the clunkiness of having to drop tow to get the benefit from a glyph.

    With t9 2pc/t10 2pc, CL comes with an approximate 80dps increase on my current gear, if used on cooldown. 40dps if used after LvB. I’m not sure if I’ll use it, since I tended to lose time mashing the wrong button due to miss timed casts.

    with t10 4pc, (although I don’t have correct stats for it yet) it appears that CL should either be used on CD or left out of the rotation entirely. EM takes a huge leap in value with t10 4pc as well, according to this new version, with Lava being outpaced even by FTW.

    Very interesting to see how it plays out once live.

    Posted by pewter | February 2, 2010, 9:49 am
    • I also don’t like the clunkiness of Glyph of ToW, but I’ve used it for a long time now and am pretty used to it.

      CL – well, I don’t actually use CL in most scenarios even though in theory it’s a slight DPS increase for me. As you say, the risk of losing DPS by using CL (due to lag etc) is very real and the extra mana usage is a concern. Sometimes during important burn phases without heroism I’ll suddenly start using it aggressively – if it’s a “maxx DPS or die” situation – but most of the time I just stick to LB.

      Posted by Charles | February 2, 2010, 12:25 pm
  3. I was wondering if you would ever implement a slot by slot gear entry method as opposed to a stat entry method. I have used Aldriana’s spreadsheet when tuning my Rogue, and I find that the slot by slot method is very useful for comparing upgrades and whatnot. In addition, a gem suggester (Like Aldriana’s) would also be a really cool feature.

    I realize that may not be your vision/design goal, just throwing my 2c in!


    Posted by FPS | February 3, 2010, 5:14 pm
    • Aldriana’s spreadsheet is one of those that I checked out while considering the overall design of ZAP!, though at the time I thought “wow, this is out of my league”. Now I’m more willing to consider that sort of thing, but exactly what form and how and when it will arrive, I can’t say.

      Posted by Charles | February 5, 2010, 4:37 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: