Spreadsheet: 767277d1644390254-trouble-with-countif-formulas-returning-the-wrong-values-solar-feedin-schedule
Sheet: Sheet1

Supply charge per day |  |  | 0.9001 |  | Highest Daily |  |  |  |  |  |  | Days above 3
 |  |  |  |  | Highest Profit |  |  |  |  |  |  | Days between 2 and 3
 |  |  |  |  | Average |  |  | 0 |  | Days with Zero |  | Days between 1 and 2
 |  |  |  |  | total |  |  |  |  |  |  | Days between 0 and 1
 |  |  |  |  |  |  |  |  |  |  |  | Days with Zero
 |  |  |  |  |  |  |  |  |  |  |  | Total days
Date | earned | charges | Suply charge | balance | App
2021-09-23 00:00:00 | 0.42 | 3.08
2021-09-24 00:00:00 | 0.89 | 2.41
2021-09-25 00:00:00 | 1.13 | 1.55
2021-09-26 00:00:00 | 1.06 | 1.58
2021-09-27 00:00:00 | 1.71 | 1.53
2021-09-28 00:00:00 | 0.56 | 1.88
2021-09-29 00:00:00 | 0.94 | 1.61
2021-09-30 00:00:00 | 0 | 3.62
2021-10-01 00:00:00 | 0 | 3.46
2021-10-02 00:00:00 | 0.13 | 2.01
2021-10-03 00:00:00 | 0.03 | 1.87
2021-10-04 00:00:00 | 0.42 | 2.61 |  |  | -2.2 | error
2021-10-05 00:00:00 | 0.94 | 2.1
2021-10-06 00:00:00 | 0.23 | 1.84
2021-10-07 00:00:00 | 0.98 | 1.23
2021-10-08 00:00:00 | 1.11 | 0.95
2021-10-09 00:00:00 | 1.02 | 0.92
2021-10-10 00:00:00 | 0.82 | 0.93
2021-10-11 00:00:00 | 1.07 | 0.92
2021-10-12 00:00:00 | 1.42 | 0.92
2021-10-13 00:00:00 | 0 | 0.92
2021-10-14 00:00:00 | 1.31 | 1.7
2021-10-15 00:00:00 | 0.13 | 1.25 |  |  | -1.11 | error
2021-10-16 00:00:00 | 0.1 | 2 |  |  | -1.89 | error
2021-10-17 00:00:00 | 0.59 | 1.4
2021-10-18 00:00:00 | 1.5 | 0.98
2021-10-19 00:00:00 | 1.67 | 1.41
2021-10-20 00:00:00 | 2.63 | 0.92
2021-10-21 00:00:00 | 1.95 | 0.93
2021-10-22 00:00:00 | 0.5 | 0.92 |  |  | -0.43 | error
2021-10-23 00:00:00 | 0.49 | 0.95 |  |  | -0.47 | error
2021-10-24 00:00:00 | 1.26 | 1.06
2021-10-25 00:00:00 | 1.39 | 0.92
2021-10-26 00:00:00 | 3.09 | 0.92
2021-10-27 00:00:00 | 2.22 | 0.92 |  |  | 1.29 | error
2021-10-28 00:00:00 | 0 | 3.96
2021-10-29 00:00:00 | 1.6 | 2.2 |  |  | -0.59 | error
2021-10-30 00:00:00 | 1.74 | 1.37
2021-10-31 00:00:00 | 2.6 | 0.92 |  |  | 1.69 | error
2021-11-01 00:00:00 | 3.01 | 0.92
2021-11-02 00:00:00 | 2.68 | 0.94 |  |  | 1.75 | error
2021-11-03 00:00:00 | 0.2 | 0.92
2021-11-04 00:00:00 | 2.65 | 0.92
2021-11-05 00:00:00 | 3.27 | 0.94 |  |  | 2.32 | error
2021-11-06 00:00:00 | 0.23 | 1.03
2021-11-07 00:00:00 | 1.29 | 2.86 |  |  | -1.56 | error
2021-11-08 00:00:00 | 0.83 | 1.57 |  |  | -0.73 | error
2021-11-09 00:00:00 | 1.7 | 1.8 |  |  | -0.11 | error
2021-11-10 00:00:00 | 2.14 | 0.96
2021-11-11 00:00:00 | 1.73 | 0.97
2021-11-12 00:00:00 | 0.6 | 0.99 |  |  | -0.38 | error
2021-11-13 00:00:00 | 1.72 | 0.96
2021-11-14 00:00:00 | 1.7 | 0.96 |  |  | 0.73 | error
2021-11-15 00:00:00 | 1.79 | 0.95
2021-11-16 00:00:00 | 0.34 | 2.03
2021-11-17 00:00:00 | 3.42 | 0.95 |  |  | 2.48
2021-11-18 00:00:00 | 3.04 | 0.95
2021-11-19 00:00:00 | 2.51 | 0.95
2021-11-20 00:00:00 | 2.83 | 0.95
2021-11-21 00:00:00 | 3.51 | 0.95
2021-11-22 00:00:00 | 2.82 | 0.97
2021-11-23 00:00:00 | 0 | 1.11
2021-11-24 00:00:00 | 2.24 | 1.43
2021-11-25 00:00:00 | 1.81 | 1.01
2021-11-26 00:00:00 | 0.65 | 1.02
2021-11-27 00:00:00 | 2.38 | 1.14
2021-11-28 00:00:00 | 3.36 | 2.98
2021-11-29 00:00:00 | 0 | 0.9
2021-11-30 00:00:00 | 3.43 | 0.93
2021-12-01 00:00:00 | 2.94 | 0.93
2021-12-02 00:00:00 | 1.09 | 0.92
2021-12-03 00:00:00 | 2.95 | 0.92
2021-12-04 00:00:00 | 1.69 | 2.24
2021-12-05 00:00:00 | 1.42 | 2.17 |  |  | -0.76
2021-12-06 00:00:00 | 0.59 | 0.92 |  |  | -0.32
2021-12-07 00:00:00 | 2.06 | 1.76
2021-12-08 00:00:00 | 2.03 | 2.03 |  |  | -0.01
2021-12-09 00:00:00 | 1.92 | 0.92
2021-12-10 00:00:00 | 2.22 | 0.92
2021-12-11 00:00:00 | 3.05 | 0.92
2021-12-12 00:00:00 | 3.32 | 0.94 |  |  |  | errors may be accounted for the start of quarter 19/09/2021 and not 23/09/2021
2021-12-13 00:00:00 | 0.92 | 1.04 |  |  |  | also feed in tariff $0.06 and not $0.10 for 21/09/2021 to 17/10/2021
2021-12-14 00:00:00 | 3.58 | 0.92 |  |  |  |  | Days for period | credits | charges |  | balance
2021-12-15 00:00:00 | 2.69 | 0.92 |  |  |  |  |  |  | Usage
2021-12-16 00:00:00 | 2.97 | 0.92 |  |  |  | Here | 91 |  |  | 76.58
2021-12-17 00:00:00 | 3.17 | 0.92 |  |  |  | Origin Bill | 91 | 145.34 | 61.53
2021-12-18 00:00:00 | 3.08 | 0.92
2021-12-19 00:00:00 | 1.11 | 0.93
2021-12-20 00:00:00 | 1.76 | 0.93
2021-12-21 00:00:00 | 2.14 | 0.94
2021-12-22 00:00:00 | 1.98 | 0.92
2021-12-23 00:00:00 | 3.14 | 0.92
2021-12-24 00:00:00 | 3.87 | 0.92
2021-12-25 00:00:00 | 1.84 | 1.2
2021-12-26 00:00:00 | 1.29 | 0.92
2021-12-27 00:00:00 | 2.96 | 0.92
2021-12-28 00:00:00 | 3.61 | 0.92
2021-12-29 00:00:00 | 3.24 | 0.95 |  |  | 2.3
2021-12-30 00:00:00 | 3.71 | 0.96 |  |  | 2.74
2021-12-31 00:00:00 | 3.39 | 0.92 |  |  | 2.46
2022-01-01 00:00:00 | 0.57 | 0.92
2022-01-02 00:00:00 | 2.57 | 0.92
2022-01-03 00:00:00 | 2.36 | 0.92
2022-01-04 00:00:00 | 1.35 | 0.93 |  |  | 0.43
2022-01-05 00:00:00 | 0 | 1.43
2022-01-06 00:00:00 | 1.81 | 1.55
2022-01-07 00:00:00 | 0.58 | 1.48
2022-01-08 00:00:00 | 0.52 | 1.72
2022-01-09 00:00:00 | 3.23 | 2.35 |  |  | 0.87
2022-01-10 00:00:00 | 2.65 | 2.01
2022-01-11 00:00:00 | 3.41 | 2.29
2022-01-12 00:00:00 | 2.58 | 1.71
2022-01-13 00:00:00 | 2.82 | 1.63 |  |  | 1.2
2022-01-14 00:00:00 | 3.56 | 1.59
2022-01-15 00:00:00 | 2.06 | 1.82 |  |  | 0.23
2022-01-16 00:00:00 | 3.91 | 1.47
2022-01-17 00:00:00 | 2.5 | 1.74
2022-01-18 00:00:00 | 1.94 | 2.03
2022-01-19 00:00:00 | 2.59 | 1.5
2022-01-20 00:00:00 | 3.81 | 1.7
2022-01-21 00:00:00 | 3.79 | 1.37
2022-01-22 00:00:00 | 3.77 | 1.43 |  |  | 2.35
2022-01-23 00:00:00 | 2.52 | 1.55 |  |  | 0.96
2022-01-24 00:00:00 | 2.56 | 1.64
2022-01-25 00:00:00 | 3.19 | 1.47
2022-01-26 00:00:00 | 1.76 | 1.32
2022-01-27 00:00:00 | 3.28 | 1.43 |  |  |  |  | Days for period | credits | charges | balance
2022-01-28 00:00:00 | 2.02 | 1.69 |  |  |  |  |  |  | Usage
2022-01-29 00:00:00 | 2.31 | 1.51
2022-01-30 00:00:00 | 1.19 | 1.81
2022-01-31 00:00:00 | 2.85 | 2.24
2022-02-01 00:00:00 | 2.46 | 1.7
2022-02-02 00:00:00 | 2.51 | 2.1
2022-02-03 00:00:00 | 1.2 | 1.96
2022-02-04 00:00:00 | 2.92 | 1.83
2022-02-05 00:00:00 | 2.79 | 1.76
2022-02-06 00:00:00 | 2.82 | 1.74 |  |  | 1.09
2022-02-07 00:00:00 | 3.59 | 1.88 |  |  | 1.7
2022-02-08 00:00:00 | 3.19 | 1.69
2022-02-09 00:00:00
2022-02-10 00:00:00
2022-02-11 00:00:00
2022-02-12 00:00:00
2022-02-13 00:00:00
2022-02-14 00:00:00
2022-02-15 00:00:00
2022-02-16 00:00:00
2022-02-17 00:00:00
2022-02-18 00:00:00
2022-02-19 00:00:00
2022-02-20 00:00:00
2022-02-21 00:00:00
2022-02-22 00:00:00
2022-02-23 00:00:00
2022-02-24 00:00:00
2022-02-25 00:00:00
2022-02-26 00:00:00
2022-02-27 00:00:00
2022-02-28 00:00:00
2022-03-01 00:00:00
2022-03-02 00:00:00
2022-03-03 00:00:00
2022-03-04 00:00:00
2022-03-05 00:00:00
2022-03-06 00:00:00
2022-03-07 00:00:00
2022-03-08 00:00:00
2022-03-09 00:00:00
2022-03-10 00:00:00
2022-03-11 00:00:00
2022-03-12 00:00:00
2022-03-13 00:00:00
2022-03-14 00:00:00
2022-03-15 00:00:00
2022-03-16 00:00:00
2022-03-17 00:00:00
2022-03-18 00:00:00