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 |