| 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 | |
| season abnormal precipd | average if weeks precip minus average all years season average | |||
| Model |
Overview
Content Tools