Sheet | Columns | column header | row key | get method |
---|
Temperature |
|
|
|
|
| A | 'week' | 1-52 |
|
| B-L | year (2004-2014) | temperature (C) | input |
| M | Norm(C30-yr) |
| input |
| N-X | year (2004-2014) | Degree Week | if year temp > 22 add temp to row above |
| Y | DWNorm |
| if norm temp > 22 add temp to row above |
| Z-AJ | year (2004-2014) | Degree week diff | subtract DWNorm from year degree week |
| AM-AW | year (2004-2014) | 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' | 1-52 |
|
| B-L | year (2004-2014) | weekly precipitation (cm) | input |
| M | Norm(cm-30yr) |
| input |
| N-X | year (2004-2014) | Abnormal weekly precipitation (cm) | temp minus norm for week of year |
| AA-AK | year (2004-2014) | 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 (1-52) for year |
| C | cumulative weeknum |
| input (1-572) for all years |
| D | Abn DW (30 yr) |
| Get - Temperature - Degree Week Difference |
| E-H | Abn Wks [season] (C) |
| Get - Abnormal Temperature - by year and season |
| I | Abn 1 Wk Prec (dm 30 yr) |
| Get - Precipitation - abnormal weekly precipitation |
| J-M | abn yrly wks [season] (dm 30yr) |
| Get - precipitation - abnormal season |
| N | Dayighthrs |
| Input |
| O | Ind 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) |
|
|
|
|
|