| 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 |
Overview
Content Tools