Magicka DPS Templar Skill Comparison

Solinur

In order to figure out how to improve my rotation I made myself a spreadsheet to see how effective my available skills are in different situations:

https://docs.google.com/spreadsheets/d/1QYdyTKJw9W0Ej8yYeiy14osPUiNpiVmHMDJoI7jY6sg/edit?usp=sharing

For solo situations I end up with a result like this:


Note that all this is a rather heavy on theory crafting.
The values are calculated based on theory data completely. It uses skill coefficients from UESP and tries to take everything into account that affects the damage, including CP's, buffs, procs like Burning and Burning Light. The yellow fields are those that can be adjusted to fit different situations (Raid buffed, Uptimes, bonus damage of Radiant Oppression)

Feel free to make a copy of this and play around with it. There are editable fields on both sheets.