As proof that you can do pretty much anything if you’re bored enough and have enough time, I’ve finished the first release candidate for my spreadsheet project.
It’s called ZAP! – Zamir’s Elemental Spreadsheet!
Yes I’m fond of being glib, especially if the opportunity arises during something that sounds like it should be serious (like say, writing a spreadsheet).
What is ZAP!?
ZAP! is an Excel 2007 spreadsheet which you plug your stats and talents and buffs and such into, and it returns a DPS figure. That is to say, it reduces elemental shaman DPS to a formula for the purposes of helping a player explore how different factors might affect their damage output. The design is heavily based on Binkenstein’s SEIC spreadsheet, but it is an entirely new project written from scratch using my own methods and formulae.
It also features a “Sandbox” rotation editor, which allows a user to play around with configuring their own spell cast sequence while adding/removing stats to compare DPS results.
Zamir is one of my various Internet aliases. It has the advantage of starting with a ‘Z’, which makes it inherently cool.
Hey this looks a lot like SEIC
Yeeees it does. That’s because I was a long-time user of SEIC and loved the simple, one-sheet UI design compared to the complex designs of other classes’ spreadsheets. ZAP! is meant to seem familiar and obvious to any previous SEIC users, but I also tried to design the front page from the ground up to be intuitive and user-friendly. I may or may not have succeeded.
Seriously though did you just copy/paste from SEIC
OK seriously who are you? Oh wait it’s me. OK then. Well, no. This spreadsheet is entirely, completely my own work. I manually typed every formula into every cell based on my own understanding of the maths. This involved a lot of research and checking and in-game testing.
Having said that, one of the most helpful tools available to me while designing ZAP! was SEIC, because I could check every result my work gave against SEIC’s results. Frequently this allowed me to quickly track down mistakes or omissions in my own work; sometimes it meant spotting mistakes in SEIC. So yeah, SEIC was an incredibly valuable resource. And like I said, it’s the spreadsheet I’ve personally used until now and it deserves a lot of respect and recognition.
What can ZAP! do?
The main feature of ZAP! is returning a DPS figure based on:
- Your character’s stats, talents, glyphs and set bonuses
- Your personal and raid buffs, debuffs and consumables
- Encounter variables such as fight time, heroism use, etc.
It also provides some interesting stats like how many spells you cast and how much mana you used.
ZAP! also features a DEP system where each stat, glyph, set bonus etc. is converted into damage equivalency points – that is, how much DPS they theoretically translate into. Like SEIC, there’s a tool to compare items/gems/enchants etc based on their DEP, as well as a trinket list which can be sorted according to each trinket’s DEP.
The final feature of ZAP! is the Sandbox rotation editor, which was actually the main reason I started this in the first place. It’s very similar in style to the pseudo-simulation that SEIC used to calculate DPS, only the user selects which spells to cast and when, any stat buffs to add/remove, and how long the cycle goes on for.
Ultimately, ZAP! is a formulator. That is distinct from a simulator. It uses average values, expected results, normalised scenarios, and so forth. The value it returns is to help you make a choice between one item or another, or between one rotation style and another, and is not a “target” or “maximum”.
OK so what now
I need some folks to try ZAP! and play around with it to check it works properly and make suggestions/give feedback where helpful so that I can improve it and possibly release it to a wider audience. You can download it here. Update: there’s also a compatibility version here.
It’s in Excel 2007 format and I’ve no idea to what extent this is or isn’t compatible with other spreadsheet packages, sorry.
Also, it’s a macro-enabled spreadsheet as it uses a macro to sort trinkets by DEP – opening it without enabling macros will not affect the functionality of the rest of the spreadsheet.