Spreadsheet: 26695d1219084139-formula-that-has-an-if-and-needs-a-reset-august-section
Sheet: Sheet1

2005-01-01 00:00:00 | 0 |  |  | 1900-01-01 00:00:00 | OFF | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 303.9 | 1 | 1 | 1
2005-01-02 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 0
2005-01-03 00:00:00 | 1.9 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 2 | 2 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 | 0 | 0 | 0
2005-01-04 00:00:00 | 1.8 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 2 | 2 | 3.7 | 3.7 | 3.7 | 3.7 | 3.7 | 3.7 | 0 | 0 | 0
2005-01-05 00:00:00 | 3 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 2 | 2 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 0 | 0 | 0
2005-01-06 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 3 | 3 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 1 | 1 | 0
2005-01-07 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 4 | 4 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 1 | 2 | 0
2005-01-08 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 5 | 5 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 6.7 | 1 | 3 | 0
2005-01-09 00:00:00 | 1 | 13:00:00 | 17:00:00 | 04:00:00 | ON | 5 | 5 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 | 7.7 | 0 | 0 | 0
2005-01-10 00:00:00 | 1 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 5 | 5 | 6.8 | 8.7 | 8.7 | 8.7 | 8.7 | 8.7 | 0 | 0 | 0
2005-01-11 00:00:00 | 3.1 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 5 | 5 | 8.1 | 11.8 | 11.8 | 11.8 | 11.8 | 11.8 | 0 | 0 | 0
2005-01-12 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 6 | 6 | 5.1 | 11.8 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 1 | 0
2005-01-13 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 7 | 7 | 5.1 | 11.8 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 2 | 0
2005-01-14 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 8 | 8 | 5.1 | 11.8 | 45.89999999999999 | 11.8 | 11.8 | 11.8 | 1 | 3 | 0
2005-01-15 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 9 | 9 | 5.1 | 11.8 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 4 | 0
2005-01-16 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 10 | 10 | 4.1 | 11.8 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 5 | 1
2005-01-17 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 11 | 11 | 0 | 0 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 6 | 1
2005-01-18 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 12 | 12 | 0 | 18 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 7 | 1
2005-01-19 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 13 | 13 | 0 | 0 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 8 | 1
2005-01-20 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 14 | 14 | 0 | 0 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 9 | 1
2005-01-21 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 15 | 15 | 0 | 0 | 11.8 | 11.8 | 11.8 | 11.8 | 1 | 10 | 1
2005-01-22 00:00:00 | 0.8 | 07:00:00 | 12:00:00 | 05:00:00 | ON | 15 | 15 | 0.8 | 0.8 | 12.6 | 12.6 | 12.6 | 12.6 | 0 | 0 | 0
2005-01-23 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 16 | 16 | 0.8 | 12.6 | 12.6 | 12.6 | 12.6 | 12.6 | 1 | 1 | 0
2005-01-24 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 17 | 17 | 0.8 | 12.6 | 12.6 | 12.6 | 12.6 | 12.6 | 1 | 2 | 0
2005-01-25 00:00:00 | 1.2 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 17 | 17 | 2 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 0 | 0 | 0
2005-01-26 00:00:00 | 0.7 | 07:00:00 | 10:00:00 | 03:00:00 | ON | 17 | 17 | 2.7 | 14.5 | 14.5 | 14.5 | 14.5 | 14.5 | 0 | 0 | 0
2005-01-27 00:00:00 | 0.3 | 15:00:00 | 17:00:00 | 02:00:00 | ON | 17 | 17 | 3 | 14.8 | 14.8 | 14.8 | 14.8 | 14.8 | 0 | 0 | 0
2005-01-28 00:00:00 | 2 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 17 | 17 | 5 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 | 0 | 0 | 0
2005-01-29 00:00:00 | 1 | 09:00:00 | 16:00:00 | 07:00:00 | ON | 17 | 17 | 5.199999999999999 | 17.8 | 17.8 | 17.8 | 17.8 | 17.8 | 0 | 0 | 0
2005-01-30 00:00:00 | 1.1 | 13:00:00 | 17:00:00 | 04:00:00 | ON | 17 | 17 | 6.299999999999999 | 18.9 | 18.9 | 18.9 | 18.9 | 18.9 | 0 | 0 | 0
2005-01-31 00:00:00 | 0.4 | 07:00:00 | 12:00:00 | 05:00:00 | ON | 16 | 17 | 6.699999999999999 | 19.3 | 19.3 | 19.3 | 19.3 | 19.3 | 0 | 0 | 0
2005-02-01 00:00:00 | 2.6 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 15 | 17 | 8.1 | 21.9 | 21.9 | 21.9 | 21.9 | 21.9 | 0 | 0 | 0
2005-02-02 00:00:00 | 3.4 | 07:00:00 | 18:00:00 | 11:00:00 | ON | 15 | 17 | 10.8 | 23.4 | 25.3 | 25.3 | 25.3 | 25.3 | 0 | 0 | 0
2005-02-03 00:00:00 | 2.1 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 15 | 17 | 12.6 | 23.7 | 27.4 | 27.4 | 27.4 | 27.4 | 0 | 0 | 0
2005-02-04 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 16 | 18 | 10.6 | 20.7 | 27.4 | 27.4 | 27.4 | 27.4 | 1 | 1 | 0
2005-02-05 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 16 | 19 | 9.6 | 20.7 | 27.4 | 27.4 | 27.4 | 27.4 | 1 | 2 | 0
2005-02-06 00:00:00 |  |  |  | 1900-01-01 00:00:00 | OFF | 16 | 20 | 8.5 | 20.7 | 27.4 | 27.4 | 27.4 | 27.4 | 1 | 3 | 0
2005-02-07 00:00:00 | 4.9 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 15 | 20 | 13 | 25.6 | 32.3 | 32.3 | 32.3 | 32.3 | 0 | 0 | 0
2005-02-08 00:00:00 | 2.3 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 15 | 20 | 12.7 | 26.9 | 34.59999999999999 | 34.59999999999999 | 34.59999999999999 | 34.59999999999999 | 0 | 0 | 0
2005-02-09 00:00:00 | 2.1 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 15 | 20 | 11.4 | 28 | 36.7 | 36.7 | 36.7 | 36.7 | 0 | 0 | 0
2005-02-10 00:00:00 | 2.2 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 15 | 20 | 11.5 | 27.1 | 38.9 | 38.9 | 38.9 | 38.9 | 0 | 0 | 0
2005-02-11 00:00:00 | 2.3 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 14 | 20 | 13.8 | 29.4 | 41.2 | 41.2 | 41.2 | 41.2 | 0 | 0 | 0
2005-02-12 00:00:00 | 0.8 | 07:00:00 | 12:00:00 | 05:00:00 | ON | 13 | 20 | 14.6 | 30.2 | 41.99999999999999 | 41.99999999999999 | 41.99999999999999 | 41.99999999999999 | 0 | 0 | 0
2005-02-13 00:00:00 | 0.9 | 12:00:00 | 17:00:00 | 05:00:00 | ON | 12 | 20 | 15.5 | 31.1 | 42.89999999999999 | 42.89999999999999 | 42.89999999999999 | 42.89999999999999 | 0 | 0 | 0
2005-02-14 00:00:00 | 1.1 | 07:00:00 | 14:00:00 | 07:00:00 | ON | 11 | 20 | 11.7 | 32.2 | 42.09999999999999 | 43.99999999999999 | 43.99999999999999 | 43.99999999999999 | 0 | 0 | 0
2005-02-15 00:00:00 | 1.9 | 07:00:00 | 17:00:00 | 10:00:00 | ON | 10 | 20 | 11.3 | 34.1 | 42.2 | 45.89999999999999 | 45.89999999999999 | 45.89999999999999 | 0 | 0 | 0