Took everyones advice, did some research, corrected my mistakes, and added new features, heres...
WotLK Mage Spec Comparison Chart:
WotLK Spec Comparison Chart.xls
Version 2.0, Last Updated: 6/7/08
Changes:
Changed page organization to make it easier to read.
Added Information at the top.
Added New Input Stats which include:
-Spell Hit
-Spell Haste
-Number of Mages
-Travel Time + Latency
Added Calculations for Winter's Grasp using a simple formula of:
-Uptime = WGDur/(WGProcRate^-1*CastTime)
-TotalUptime = 1-(1-Uptime)^NumMages
-NumBolts = ROUNDUP(TotalUptime*WGProcRate^-1)
-TotalNumBolts = NumBolts+IF(EmptyWGTime<TravelLatency,1,0)
-WGCrit = TotalNumBolts/WGProcRate^-1*.5
Added rough calculations for Combustion
-If someone could post the algebraic formula for how much crit Combustion gives, I will add it as soon as I can.
Corrected how Critical Bonus was calculated.
Corrected how Multiplicative Damage Increase was calculated.
Corrected how Multiplicative Mana Decrease was calculated.
Haste now effects mana cost of spells
-Since time is not calculated in to reflect the effect of haste of mana spent.
If you find any more errors please tell me and I will fix them as soon as I can.
If you have any suggestions to make it better, please tell me, I would be happy to make it better.
If anyone knows more about excel then I do, could you please help me make graphs that use a variable spell damage or variable crit as the X axis, and the dps of the 5 specs as the Y axis?
The calculations are a lot more perfect then they were before, so don't expect any large changes in the results at this point forward.
Thank you and enjoy.