RReDC Solar Models: Corrections to SPCTRAL2

	Bird Simple Spectral Model: SPCTRAL2
RReDC Home > Solar Index > Solar Models > Simple Solar Spectral Model > SPCTRAL2 > Corrections

Corrections to the SPCTRAL2 Workbook

2003-06-12
Two calculations have been corrected:
1. Column G24 G24=$B$20*EXP(-$B$21*(LOG(B24/0.4))^2) is replaced by -> G24=$B$20*EXP(-$B$21*(LN(B24/0.4))^2)
2. Grouping of terms in Column Q24 is incorrect:
  Q24=C24*COS($F$13)*I24*K24*J24*O24*H24^1.5*(1-N24)*(1-0.5*EXP(($I$13+$I$14*COS($F$13)*COS($F$13))))*$F$16
  Last set of 4 parentheses should be 3 parentheses, and there should be 2 parenthesess after next to last occurance of Cos($F$13)
  -> Q24=C24*COS($F$13)*I24*K24*J24*O24*H24^1.5*(1-N24)*(1-0.5*EXP(($I$13+$I$14*COS($F$13))*COS($F$13)))*$F$16