Book of Heroes

War Mage Super Spreadsheet (DPS calculator)

japster

ModeratorSun Jan 13, 2013 9:14 am
Version History
2/9/2013: Updated for v1.5.3. Weapon enchant formula updated. Fire and Ice elemental damage enchant formula added. "Burning" theoretical DPS properly calculated now with new DoT mechanism.

Quick Introduction
Hey all War Mages, out of a love for the class, I made a spreadsheet that calculates damage of all our spells, both theoretical and raw damage output. It SHOULD be accurate as of v1.5.3. Feel free to plug in any values and let me know if there are discrepancies from your actual character.

Lastly, I may be severely WRONG in my approach. Do let me know if something is erroneous. Thanks.

Quick explanation.

Plug-and-play!
You ONLY need to plug in values in the yellow cell, which are basically values you can easily obtain from your in-game character sheet.
1. weapon min damage,
2. weapon max damage,
3. magic bonus,
4. weapon speed,
5. crit%,
6. crit power%,
7. haste
8. enchant weapon damage % bonus (if any, if not leave as 0%)
9. enchant elemental damage % bonus (if any, if not leave as 0%)
10. spell ranks of all skills learnt (except time void, ice shield, snap cast, inner focus not included)

Lastly, there is a cell which asks if you have used a Fire Rune, if you use a Fire Rune during a fight, just change the value to "1", and if not, "0". This cell has implications for calculating Fire Blast damage!

Theoretical DPS versus Theoretical Damage
Both are theoretical numbers, obviously. DPS refers to the damage divided by the cast time, while damage is just damage of the spell when cast.

Full Rotation Theoretical Damage/DPS
This refers to a simple rotation (Fire versus Ice), where all 3 Fire spells are cast once each VERSUS all 4 Ice spells are cast once each. For fire rotation, it assumes Incinerate is cast first, then has 2 options, either Fire Blast as the 2nd spell in the rotation or as the 3rd spell. The DPS value is probably of more significance since that determines the amount of damage you unload with the simple rotation.

Unfortunately there are limitations to the spreadsheet for more complex rotations. If you require complex rotation calculations, you have to do the maths yourself by taking the theoretical damage of each spell you're casting, add them up, and then divide it by the total cast time of all these spells. The values of these figures are obviously in the spreadsheet =)

Fire Blast
This has to be one of the more tricky theoretical values to derive. Basically, due to the fact that Ignite isn't 100%, and I assume we cast Fire Blast as a 2nd OR 3rd spell in the rotation, the probability of burning differs. Therefore there are separate values for Fire Blast, whether you cast it as the 2nd spell in the rotation, or 3rd spell. Of course, if you aren't interested in mathematical nonsense, just take the absolute values, which are reflected in Fire Blast (without burning) and Fire Blast (with burning).

Limitations
Ice comes out lower than Fire in terms of dps of a full rotation of spells (simple rotation), but I have yet to factor in –15% enemy ice resist from Freeze, which may happen due to Deep Freeze proc as well as the various slows and stuns that Ice causes. Lastly, Ice reduces enemy dodge, which represents a greater theoretical damage increase. Dodge was not factored at all in this spreadsheet.

Basically, Ice DPS has to be calculated against specific monster data, which is extremely laborious and probably unobtainable.

Download Link

https://www.dropbox.com/s/sgg99df5n27rv ... .3%29.xlsx

Bj_Knows

ModeratorSun Jan 13, 2013 9:59 am
TCG_japster wrote:
Ignite should be made 100%. The damage from the DoT can be reduced, really, but making Fire Blast a reliable double damage spell may also be a method of boosting fire dps. Note that when Ignite is 100%, Fire Blast truly becomes powerful (look at the absolute value of Fire Blast with burning), even without tweaking any other number.

v1.5.1 Major/ Minor Fire Rune is 100% Burn, which works with Fire Blast. Minor Fire Rune stacks with both another Minor Fire Rune and Ignite. Major Fire Rune stacks with another Major Fire Rune.

I do not know about stacking Major Fire Rune and Ignite or stacking Major Fire Rune and Minor Fire Runes. I do not have enough Major Fire Runes left to do the testing.

excerpt from a Draft
"-
v1.5.1 Minor Fire Runes stack up to 3 times giving 20%/ 40%/ 60% DPS for 5 seconds. All my characters use them against Onslaught Raid Bosses. Even better, the Burn stacks with War Mage's Burn. This will be insane when the Burn Bug is fixed. I now use them a lot.
-"

japster

ModeratorSun Jan 13, 2013 10:10 am
I'm aware of the benefits that a Fire rune confers onto a fire mage. That is why I factored it in the spreadsheet. But I am a bit uncomfortable with needing to use an item every fight in order to enable certain builds to maintain their dps.

Bj_Knows

ModeratorSun Jan 13, 2013 10:23 am
TCG_japster wrote:
I am a bit uncomfortable with needing to use an item every fight in order to enable certain builds to maintain their dps.

My Ice Mage gets awesome results using Deep Freeze rank p3 and a Minor Frost Rune first in a Combat Encounter or immediately after Ice Storm fails to Stun any Monster in a Triple Mob.

My Justicar gets awesome results using Rend rank p1 (when fixed Rend rank p3), and a Minor Fire Rune first in a Combat Encounter.

My Shadow Walker gets awesome results using Corrosive Blades rank p3 and a Minor Fire Rune first in a Combat Encounter.

Runes cost Silver Coin. Runes increase DPS.
First of all I examined the excel sheet and liked it very much.

Though fire mage has a great advantage in terms of damage, Ice mage rocks in terms of controlling the battle.

Since Icy Grasp cooldown time and stun time is the same at level 3 (3 sec), you can do unlimited damage to any boss in the game without taking damage theoretically, as long as the boss is not immune to magic like holiday goblin.

For 3 mobs, ice storm has a chance of 39% of freezing 1 mob at level 3 (if none of them frozen, a minor freeze rune has the same chance and can be used. In this case the probability becomes 63% -freezing a mob either using ice storm or rune-), and with icy grasp and time void, you may be hit 1 or at most 2 for most of the battles.

The problem is if ignite is effective, the above strategy gets meaningless since it will break the stun effects. Without ignite, fire blast and also volatility gets meaningless.

On the other hand without fire (only ice spells maximized), some battles will take too long, or you can't hit hard enough if the opponent has ice resistance. I personally take incinerate 3, and flaming pyre 3 and boosted them with fire mastery 3 to hit hard with fire, while sacrificing ice mastery all and 2 levels of frozen shard.

Considering the new Justicar and SW abilities, mage is one step ahead of the other classes. Boosting fire mage more with damage options will make the gap bigger, and may be a problem in balance issues I fear.

I think all of the classes should be changed a bit to get the balance, considering the bugs will be eliminated in 1.5.2.
Thanks Japster, this is very useful.

I was considering a re-spec towards more fire abilities after DOT gets fixed but I can now see this will not bring me much. My stats are not very different from yours: lower magic, slightly higher haste.
I looked at my pattern for both mobs and bosses waves and drew my conclusions based on those “realistic” (for me) rotations. I took into account the 15% ice damage increase after icy grasp, but not the dodge reduction of deep freeze (probably negligible).

First, I agree with you that volatility is a waste of skill points and that fire spells need a boost compared to ice spells. Venan is going in this direction, as they’re reducing the pushback time of ice lance and the probability to freeze with deep freeze. That also means I may have to change rotations after the patch and re-think all this.

Second, it seems ignite will only be useful for a mage using a staff and using fire spells as much as possible, even if that means being hit more. In my case, DOT won’t trigger against mobs and won’t trigger often enough against a boss to make a tangible difference.

Finally, I realised I barely use fire blast right now and don’t really have any reason to (since I’m giving up on ignite and never use runes). So, despite the potentially exceptional DPS, I’ll use those three points somewhere else until there are high level onslaught raids.

Thanks again for sharing this.

japster

ModeratorFri Feb 8, 2013 2:13 pm
BUMP! Spreadsheet updated for v1.5.3! New and improved! Check the version changes to find out what has been upgraded 8-)