SheetColumnscolumn headerrow keyget method
Temperature




A'week'1-52

B-Lyear (2004-2014)temperature (C)input

MNorm(C30-yr)
input

N-Xyear (2004-2014)Degree Weekif year temp > 22 add temp to row above

YDWNorm
if norm temp > 22 add temp to row above

Z-AJyear (2004-2014)Degree week diffsubtract DWNorm from year degree week

AM-AWyear (2004-2014)each season tempaverage of all temperatures for season of given year



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




A'week'1-52

B-Lyear (2004-2014)weekly precipitation (cm)input

MNorm(cm-30yr)
input

N-Xyear (2004-2014)Abnormal weekly precipitation (cm)temp minus norm for week of year

AA-AKyear (2004-2014)season precipaverage of weeks precip / 10



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




Ayear
input

Bweeknum
input (1-52) for year

Ccumulative weeknum
input (1-572) for all years

DAbn DW (30 yr)
Get - Temperature - Degree Week Difference

E-HAbn Wks [season] (C)
Get - Abnormal Temperature - by year and season

IAbn 1 Wk Prec (dm 30 yr)
Get - Precipitation - abnormal weekly precipitation

J-Mabn yrly wks [season] (dm 30yr)
Get - precipitation - abnormal season

NDayighthrs
Input

OInd Model_18-38
=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)


Ind Model_18-38 translation

if week of year [17,44]

intercept + { dw_lag1 * deg_week_diff(row 1 up) } + { dw_lag2 * deg_week_diff(row 2 up) } + { dw_lag3 * deg_week_diff(row 3 up) } + { dw_lag4 * deg_week_diff(row 4 up) } + { preci_lag_1 * abnormal_weekly_precip(row 1 up) } + { preci_lag_2 * abnormal_weekly_precip(row 2 up) } + { preci_lag_3 * abnormal_weekly_precip(row 3 up) } + { preci_lag_4 * abnormal_weekly_precip(row 4 up) } + { (dwlag1 * precilag1) * deg_week_diff(row 1 up) * abnormal_weekly_precip(row 1 up) } + { (dwlag1 * precilag2) * deg_week_diff(row 1 up) * abnormal_weekly_precip(row 2 up) } + { (dwlag1 * precilag3) * deg_week_diff(row 1 up) * abnormal_weekly_precip(row 3 up) } + { (dwlag1 * precilag4) * deg_week_diff(row 1 up) * abnormal_weekly_precip(row 4 up) } + { (dwlag2 * precilag1) * deg_week_diff(row 2 up) * abnormal_weekly_precip(row 1 up) } + { (dwlag2 * precilag2) * deg_week_diff(row 2 up) * abnormal_weekly_precip(row 2 up) } + { (dwlag2 * precilag3) * deg_week_diff(row 2 up) * abnormal_weekly_precip(row 3 up) } + { (dwlag2 * precilag4) * deg_week_diff(row 2 up) * abnormal_weekly_precip(row 4 up) } + { (dwlag3 * precilag1) * deg_week_diff(row 3 up) * abnormal_weekly_precip(row 1 up) } + { (dwlag3 * precilag2) * deg_week_diff(row 3 up) * abnormal_weekly_precip(row 2 up) } + { (dwlag3 * precilag3) * deg_week_diff(row 3 up) * abnormal_weekly_precip(row 3 up) } + { (dwlag3 * precilag4) * deg_week_diff(row 3 up) * abnormal_weekly_precip(row 4 up) } + { (dwlag4 * precilag1) * deg_week_diff(row 4 up) * abnormal_weekly_precip(row 1 up) } + { (dwlag4 * precilag2) * deg_week_diff(row 4 up) * abnormal_weekly_precip(row 2 up) } + { (dwlag4 * precilag3) * deg_week_diff(row 4 up) * abnormal_weekly_precip(row 3 up) } + { (dwlag4 * precilag4) * deg_week_diff(row 4 up) * abnormal_weekly_precip(row 4 up) } +