How does regen vs magicka vs reduced cost affect my efficiency? What is my destruction spell damage?

Edit: various rebalances in patches since the below was posted (such as a particular spell's damage per cast) has made it inaccurate. I am afraid, therefore, that it seems that the author of the spreadsheet has taken down the link.

A Solution

I developed a basic spreadsheet that allows you to find out all the above questions, and more. V1 provides a full workup of magicka and all related enchanting effects, and provides detailed damage info for destruction spells.

A better VBA model I was 30% through is on hold while I enjoy a DLC to my favourite game :D

An basic example with my current mage: Magistra Circe

Mirror 1: SkyrimNexus

EDIT: the sheet is locked to prevent accidental deletion of a formula. You can unlock it (no password) under the "Review" Tab (in Excel).