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
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