Magician DD Spreadsheet

View the Forums for extra details

Please Note: Until further notice, there are no plans for future versions of this spreadsheet, so you can consider this a final version.

Magician DD Spreadsheet v2.45
(Excel '97 format 158k)

Download the Microsoft Excel Viewer

What it is: Compiled by Sage Xalmat this spreadsheet will compare for you all offensive Magician spells from level 1 to level 65.

Update History

v0.2 (March 12, 2003) - Added damage focus effects. Code is VERY sloppy and I like it that way, so don't mess with it

v0.8 (March 12, 2003) - Added cast time and mana preserve focus effects. Added Specialization and SCM. Also cleaned up some of the code

v1.0 (March 31, 2003) - Added Spell Casting Fury. Added a separate tab for Adjusted and Non-Adjusted stats. Adjusted stats account for average values of focus items and Spell Casting Fury. Non-Adjusted shows theoretical maximums. Adjusted stats also account for a (tested) 20% resist rate on rains

v1.01 (April 2, 2003) - Minor formatting change. Copied the header from the top of the table to the bottom.

v1.1 (April 7, 2003) - Based on recent and updated research, the values for Spell Casting Mastery are changed from "2.5%, 7.5%, and 15%" to "2.5%, 5%, and 10%"

v1.11 (April 14, 2003) - Changed the average value of adjusted Damage and Mana focus items to be more precise.

v1.5 (April 15, 2003) - At last! Separate entries for Magic and Fire based focus items. Also included Magi'Kot's Gloves of Convergence, Riziona's Call of Flame, Blessing of Reverence, and potion focus effects.

v1.55 (June 25, 2003) - Fixed a few bugs, don't remember which ones.

v1.60 (August 1, 2003) - Added Elemental Gloves of the Prime effect to Sun Vortex.

v1.70 (October 3, 2003) - Fixed the bug with spell haste. Rizlona's and Blessing of Reverence should no longer interfere. Also corrected a few minor bugs, and added our LDoN nukes Burning Sand and Wind of the Desert.

v1.80 (January 13, 2004) - Added +% Specialize Evocation and Conjuration, as well as dual specialize Evocation + Conjuration (in response to Secondary Forte, an upcoming GoD AA). Also note the Spreadsheet has a new URL

v2.0 (February 10, 2004) - Added some new focus effects, new AAs, and new spells. Some bugs mysteriously popped up in this version, so bug hunters please track them down!

v2.01 (February 12, 2004) - Minor bug fixes

v2.1 (February 24, 2004) - Based on some research done by magicians, the values for Spell Casting Fury, Fury of Magic, and Fury of Magic Mastery have been altered. Also, added individual values for Evocation and Conjuration Specialization.

v2.2 (March 1, 2004) - Fixed more bugs (elemental gloves namely), and added Echo of the Trusik bard effect

v2.3 (May 9, 2004) - Added Sylvan Fire, which affects both Sun Vortex and Ancient Chaos Vortex. Added a new category called Down Time Damage Per Second, which is directly related to your mana regeneration (also included mana regeneration input)

v2.35 (May 17, 2004) - Removed Sylvan Fire, due to changes to Taelosian Geomancy.

v2.45 (June 16, 2004) - Updated Burning Sand, Black Steel, Sun Vortex, and Rock of Taelosia, and Ancient Chaos Vortex to reflect their new values.

Guide To Use

Step 1: Click the above link to download it to your computer. Open it in Microsoft Excel.

Step 2: Decide between Adjusted and Non-Adjusted stats.

Adjusted shows mathematical averages to all spells. If you're comparing the efficiency of several spells, or a single spell over time, you want Adjusted.

Non-Adjusted shows mathematical maximums, including maximum damage done by criticals. Use this if you are only interested in maximum possible damage.

Step 3: Select your conditions. Choose your level, primary specialization, level for spell casting mastery, and level for spell casting fury.

Step 4: Select your worn focus effects, including Fire DD Focus, Magic DD focus, Mana Preservation, and Spell Haste.

Step 5: Select "Extra" effects, like percent specialization, ornate gloves, etc. They should be self explanatory.

Step 6: Scroll down to the desired nuke and view the results.

You can adjust the focus effects and the data at any time.

Explanation of Terms:

• Level - Level you can scribe the spell
• Name - Name of the Spell
• Type - Type of spell. Different spells have different effects, and should be used carefully
• Resist - Resist check on the spell
• Damage - Damage done by the spell, depending on focus effects, spell casting fury, and whether you are using adjusted or non-adjusted. Adjusted shows mathematical averages, Non-Adjusted shows maximum.
• Mana - Mana cost of the spell, depending on focus effects, specialization, spell casting mastery, and whether you are using adjusted or non-adjusted. Adjusted shows mathematical averages, Non-Adjusted shows maximum.
• Cast Time - Cast time of the spell, including focus effects.
• DPS - Damage Per Second, or simply the damage divided by the cast time. To be more precise, this is the burst DPS figure of a single cast, and not the long term dps of multiple casts.
• DPM - Damage Per Mana, or the overall efficiency of your spell. The higher the DPM, the more efficient the nuke.
• MPS - Mana Per Second, or how much mana it costs per cast per second. To be more precise, this is the burst MPS figure of a single cast.
• SDPS - Sustained Damage Per Second, or the damage divided by the cast time and recast time. This is a long term figure useful for longer fights or multiple casts chained back to back.
• SMPS - Sustained Mana Per Second, or the mana cost divided by the cast time and recast time. This is a long term figure useful for longer fights or multiple casts chained back to back.
• DTDPS - Down Time Damage Per Second, or damage divided by the quotient of mana cost over mana regeneration. This is a figure of "steady state" long term damage, where mana in equals mana out (also known as OOM state).

Version: 2005.04.03