You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
Next »
Sheet  Columns  column header  row key  get method 

Temperature 




 A  'week'  152 

 BL  year (20042014)  temperature (C)  input 
 M  Norm(C30yr) 
 input 
 NX  year (20042014)  Degree Week  if year temp > 22 add temp to row above 
 Y  DWNorm 
 if norm temp > 22 add temp to row above 
 ZAJ  year (20042014)  Degree week diff  subtract DWNorm from year degree week 
 AMAW  year (20042014)  each season temp  average of all temperatures for season of given year 


 each season abnormal temps  season temp  average of season of all years minus season for year 
Precipitation 




 A  'week'  152 

 BL  year (20042014)  weekly precipitation (cm)  input 
 M  Norm(cm30yr) 
 input 
 NX  year (20042014)  Abnormal weekly precipitation (cm)  temp minus norm for week of year 
 AAAK  year (20042014)  season precip  average of weeks precip / 10 


 season abnormal precipd  average if weeks precip minus average all years season average 
Model 




 A  year 
 input 
 B  weeknum 
 input (152) for year 
 C  cumulative weeknum 
 input (1572) for all years 
 D  Abn DW (30 yr) 
 Get  Temperature  Degree Week Difference 
 EH  Abn Wks [season] (C) 
 Get  Abnormal Temperature  by year and season 
 I  Abn 1 Wk Prec (dm 30 yr) 
 Get  Precipitation  abnormal weekly precipitation 
 JM  abn yrly wks [season] (dm 30yr) 
 Get  precipitation  abnormal season 
 N  Dayighthrs 
 Input 
 O  Ind Model_1838 
 =IF(AND(B54<44,B54>17),$T$4+$T$5*D53+$T$6*D52+$T$7*D51+$T$8*D50+$T$9*I53+$T$10*I52+$T$11*I51+$T$12*I50+$T$13*D53*I53+$T$14*D53*I52+$T$15*D53*I51+$T$16*D53*I50++$T$17*D52*I53+$T$18*D52*I52+$T$19*D52*I51+$T$20*D52*I50+$T$21*D51*I53+$T$22*D51*I52+$T$23*D51*I51+$T$24*D51*I50+$T$25*D50*I53+$T$26*D50*I52+$T$27*D50*I51+$T$28*D50*I50+$T$29*E54+$T$30*F2+$T$31*G2+$T$32*H2+$T$33*L54+$T$34*M2+$T$35*J2+$T$36*K2+$T$37*N54+$T$38*N53+$T$39*N52+$T$40*N51+$T$41*N50,0) 




