Spreadsheet: 776415d1649728924-formulas-behaving-different-solar-feedin-schedule
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Earned | Charges
 |  |  |  |  |  |  |  |  |  |  |  | Days above $4
 | Supply charge per day |  | 0.9001 |  | Details |  |  | Amount | Date | Number of times |  | Days between $3 and $4
 |  |  |  |  | Highest Daily |  |  |  |  |  |  | Days between $2 and $3
 |  | Today |  |  | Highest Profit |  |  |  |  |  |  | Days between $1 and $2
 |  |  |  |  | Highest Cost |  |  |  |  |  |  | Days between $0 and $1
 |  |  |  |  | Average |  |  |  |  |  |  | Days with $0
 |  |  |  |  | total earnt since install |  |  |  |  |  |  | Total days actual/count
 |  | Reading date | days for period | Credits | Usage Charges | Balance |  | Reading date | days for period | Credits | Usage Charges | Difference charge | Balance |  | Reading date | Days for period | credits | Usage Charges | balance |  | app | 205.73 | 146.37
 | Here | 2022-06-20 00:00:00 |  |  |  |  |  | 2021-12-20 00:00:00 |  |  |  | 76.58 |  |  | 2022-03-18 00:00:00 |  |  |  |  |  | dif
 | Origin |  |  |  |  |  |  |  |  | 145.34 | 61.53
 | Date | earned | charges | Supply charge | balance | App |  | Date | earned | charges | Supply charge | balance | App |  | Date | earned | charges | Supply charge | balance | App
 | 2022-03-19 00:00:00 | 2.99 | 1.47 |  |  |  |  | 2021-09-23 00:00:00 | 0.42 | 3.08 |  |  |  |  |  | 1.76 | 0.94
 | 2022-03-20 00:00:00 | 1.46 | 1.27 |  |  |  |  |  | 0.89 | 2.41 |  |  |  |  |  | 2.14 | 0.94
 | 2022-03-21 00:00:00 | 1.5 | 1.59 |  |  |  |  |  | 1.13 | 1.55 |  |  |  |  |  | 1.98 | 0.92
 | 2022-03-22 00:00:00 | 0.9 | 1.85 |  |  |  |  |  | 1.06 | 1.58 |  |  |  |  |  | 3.14 | 0.92
 | 2022-03-23 00:00:00 | 1.65 | 1.64 |  |  |  |  |  | 1.71 | 1.53 |  |  |  |  |  | 3.87 | 0.92
 | 2022-03-24 00:00:00 | 0.47 | 1.48 |  |  |  |  |  | 0.56 | 1.88 |  |  |  |  |  | 1.84 | 1.2
 | 2022-03-25 00:00:00 | 0.83 | 1.68 |  |  | -0.86 |  |  | 0.94 | 1.61 |  |  |  |  |  | 1.29 | 0.92
 | 2022-03-26 00:00:00 | 2.42 | 1.83 |  |  |  |  |  | 0 | 3.62 |  |  |  |  |  | 2.96 | 0.92
 | 2022-03-27 00:00:00 | 2.53 | 1.25 |  |  |  |  |  | 0 | 3.46 |  |  |  |  |  | 3.61 | 0.92 |  |  | 2.3
 | 2022-03-28 00:00:00 | 1.01 | 1.42 |  |  |  |  |  | 0.13 | 2.01 |  |  |  |  |  | 3.24 | 0.95 |  |  | 2.74
 | 2022-03-29 00:00:00 | 0.9 | 1.43 |  |  | -0.54 |  |  | 0.03 | 1.87 |  |  |  |  |  | 3.71 | 0.96 |  |  | 2.46
 | 2022-03-30 00:00:00 | 0.79 | 1.56 |  |  |  |  |  | 0.42 | 2.61 |  |  | -2.2 | error |  | 3.39 | 0.92
 | 2022-03-31 00:00:00 | 1.17 | 1.61 |  |  |  |  |  | 0.94 | 2.1 |  |  |  |  |  | 0.57 | 0.92
 | 2022-04-01 00:00:00 | 1.77 | 1.68 |  |  |  |  |  | 0.23 | 1.84 |  |  |  |  |  | 2.57 | 0.92
 | 2022-04-02 00:00:00 | 0.75 | 1.38 |  |  |  |  |  | 0.98 | 1.23 |  |  |  |  |  | 2.36 | 0.92 |  |  | 0.43
 | 2022-04-03 00:00:00 | 1.24 | 1.7 |  |  |  |  |  | 1.11 | 0.95 |  |  |  |  |  | 1.35 | 0.93
 | 2022-04-04 00:00:00 | 0.56 | 1.48 |  |  | -0.91 |  |  | 1.02 | 0.92 |  |  |  |  |  | 0 | 1.43
 | 2022-04-05 00:00:00 | 0 | 1.65 |  |  |  |  |  | 0.82 | 0.93 |  |  |  |  |  | 1.81 | 1.55
 | 2022-04-06 00:00:00 | 1.02 | 1.67 |  |  |  |  |  | 1.07 | 0.92 |  |  |  |  |  | 0.58 | 1.48
 | 2022-04-07 00:00:00 | 0.79 | 1.69 |  |  | -0.89 |  |  | 1.42 | 0.92 |  |  |  |  |  | 0.52 | 1.72 |  |  | 0.87
 | 2022-04-08 00:00:00 | 2.03 | 1.33 |  |  |  |  |  | 0 | 0.92 |  |  |  |  |  | 3.23 | 2.35
 | 2022-04-09 00:00:00 | 1.07 | 1.34 |  |  |  |  |  | 1.31 | 1.7 |  |  |  |  |  | 2.65 | 2.01
 | 2022-04-10 00:00:00 | 0.78 | 1.55 |  |  |  |  |  | 0.13 | 1.25 |  |  | -1.11 | error |  | 3.41 | 2.29
 |  |  |  |  |  |  |  |  | 0.1 | 2 |  |  | -1.89 | error |  | 2.58 | 1.71
 |  |  |  |  |  |  |  |  | 0.59 | 1.4 |  |  |  |  |  | 2.82 | 1.63 |  |  | 1.2
 |  |  |  |  |  |  |  |  | 1.5 | 0.98 |  |  |  |  |  | 3.56 | 1.59
 |  |  |  |  |  |  |  |  | 1.67 | 1.41 |  |  |  |  |  | 2.06 | 1.82
 |  |  |  |  |  |  |  |  | 2.63 | 0.92 |  |  |  |  |  | 3.91 | 1.47
 |  |  |  |  |  |  |  |  | 1.95 | 0.93 |  |  |  |  |  | 2.5 | 1.74
 |  |  |  |  |  |  |  |  | 0.5 | 0.92 |  |  | -0.43 | error |  | 1.94 | 2.03
 |  |  |  |  |  |  |  |  | 0.49 | 0.95 |  |  | -0.47 | error |  | 2.59 | 1.5
 |  |  |  |  |  |  |  |  | 1.26 | 1.06 |  |  |  |  |  | 3.81 | 1.7
 |  |  |  |  |  |  |  |  | 1.39 | 0.92 |  |  |  |  |  | 3.79 | 1.37
 |  |  |  |  |  |  |  |  | 3.09 | 0.92 |  |  |  |  |  | 3.77 | 1.43 |  |  | 2.35
 |  |  |  |  |  |  |  |  | 2.22 | 0.92 |  |  | 1.29 | error |  | 2.52 | 1.55 |  |  | 0.96
 |  |  |  |  |  |  |  |  | 0 | 3.96 |  |  |  |  |  | 2.56 | 1.64
 |  |  |  |  |  |  |  |  | 1.6 | 2.2 |  |  | -0.59 | error |  | 3.19 | 1.47
 |  |  |  |  |  |  |  |  | 1.74 | 1.37 |  |  |  |  |  | 1.76 | 1.32
 |  |  |  |  |  |  |  |  | 2.6 | 0.92 |  |  | 1.69 | error |  | 3.28 | 1.43
 |  |  |  |  |  |  |  |  | 3.01 | 0.92 |  |  |  |  |  | 2.02 | 1.69
 |  |  |  |  |  |  |  |  | 2.68 | 0.94 |  |  | 1.75 | error |  | 2.31 | 1.51
 |  |  |  |  |  |  |  |  | 0.2 | 0.92 |  |  |  |  |  | 1.19 | 1.81
 |  |  |  |  |  |  |  |  | 2.65 | 0.92 |  |  |  |  |  | 2.85 | 2.24
 |  |  |  |  |  |  |  |  | 3.27 | 0.94 |  |  | 2.32 | error |  | 2.46 | 1.7
 |  |  |  |  |  |  |  |  | 0.23 | 1.03 |  |  |  |  |  | 2.51 | 2.1
 |  |  |  |  |  |  |  |  | 1.29 | 2.86 |  |  | -1.56 | error |  | 1.2 | 1.96 |  |  | -0.77
 |  |  |  |  |  |  |  |  | 0.83 | 1.57 |  |  | -0.73 | error |  | 2.92 | 1.83
 |  |  |  |  |  |  |  |  | 1.7 | 1.8 |  |  | -0.11 | error |  | 2.79 | 1.76
 |  |  |  |  |  |  |  |  | 2.14 | 0.96 |  |  |  |  |  | 2.82 | 1.74 |  |  | 1.09
 |  |  |  |  |  |  |  |  | 1.73 | 0.97 |  |  |  |  |  | 3.59 | 1.88 |  |  | 1.7
 |  |  |  |  |  |  |  |  | 0.6 | 0.99 |  |  | -0.38 | error |  | 3.19 | 1.69
 |  |  |  |  |  |  |  |  | 1.72 | 0.96 |  |  |  |  |  | 2.13 | 2.1
 |  |  |  |  |  |  |  |  | 1.7 | 0.96 |  |  | 0.73 | error |  | 2.07 | 1.84 |  |  | 0.24
 |  |  |  |  |  |  |  |  | 1.79 | 0.95 |  |  |  |  |  | 2.87 | 1.66
 |  |  |  |  |  |  |  |  | 0.34 | 2.03 |  |  |  |  |  | 3.57 | 2.16
 |  |  |  |  |  |  |  |  | 3.42 | 0.95 |  |  | 2.48 |  |  | 2.02 | 1.67
 |  |  |  |  |  |  |  |  | 3.04 | 0.95 |  |  |  |  |  | 3.4 | 1.45
 |  |  |  |  |  |  |  |  | 2.51 | 0.95 |  |  |  |  |  | 3.4 | 1.99
 |  |  |  |  |  |  |  |  | 2.83 | 0.95 |  |  |  |  |  | 0.16 | 1.66
 |  |  |  |  |  |  |  |  | 3.51 | 0.95 |  |  |  |  |  | 2.18 | 1.42
 |  |  |  |  |  |  |  |  | 2.82 | 0.97 |  |  |  |  |  | 1.41 | 2.01
 |  |  |  |  |  |  |  |  | 0 | 1.11 |  |  |  |  |  | 3.08 | 2.53
 |  |  |  |  |  |  |  |  | 2.24 | 1.43 |  |  |  |  |  | 1.31 | 1.66
 |  |  |  |  |  |  |  |  | 1.81 | 1.01 |  |  |  |  |  | 2.41 | 1.8
 |  |  |  |  |  |  |  |  | 0.65 | 1.02 |  |  |  |  |  | 2.55 | 1.7
 |  |  |  |  |  |  |  |  | 2.38 | 1.14 |  |  |  |  |  | 3.29 | 1.38
 |  |  |  |  |  |  |  |  | 3.36 | 2.98 |  |  |  |  |  | 3.1 | 1.64
 |  |  |  |  |  |  |  |  | 0 | 0.9 |  |  |  |  |  | 2.61 | 1.5
 |  |  |  |  |  |  |  |  | 3.43 | 0.93 |  |  |  |  |  | 2.37 | 1.58
 |  |  |  |  |  |  |  |  | 2.94 | 0.93 |  |  |  |  |  | 0 | 2.01
 |  |  |  |  |  |  |  |  | 1.09 | 0.92 |  |  |  |  |  | 1.36 | 2.25
 |  |  |  |  |  |  |  |  | 2.95 | 0.92 |  |  |  |  |  | 0.57 | 1.62
 |  |  |  |  |  |  |  |  | 1.69 | 2.24 |  |  |  |  |  | 1.87 | 1.6
 |  |  |  |  |  |  |  |  | 1.42 | 2.17 |  |  | -0.76 |  |  | 2.63 | 2.05
 |  |  |  |  |  |  |  |  | 0.59 | 0.92 |  |  | -0.32 |  |  | 0.2 | 3.41
 |  |  |  |  |  |  |  |  | 2.06 | 1.76 |  |  |  |  |  | 1.5 | 3.94
 |  |  |  |  |  |  |  |  | 2.03 | 2.03 |  |  | -0.01 |  |  | 2.41 | 4.13
 |  |  |  |  |  |  |  |  | 1.92 | 0.92 |  |  |  |  |  | 1.66 | 2.98
 |  |  |  |  |  |  |  |  | 2.22 | 0.92 |  |  |  |  |  | 1.82 | 1.93
 |  |  |  |  |  |  |  |  | 3.05 | 0.92 |  |  |  |  |  | 1.75 | 1.37
 |  |  |  |  |  |  |  |  | 3.32 | 0.94 |  |  |  |  |  | 2.57 | 1.54
 |  |  |  |  |  |  |  |  | 0.92 | 1.04 |  |  |  |  |  | 2.08 | 1.42
 |  |  |  |  |  |  |  |  | 3.58 | 0.92 |  |  |  |  |  | 3.02 | 1.95
 |  |  |  |  |  |  |  |  | 2.69 | 0.92 |  |  |  |  |  | 3.02 | 1.75
 |  |  |  |  |  |  |  |  | 2.97 | 0.92 |  |  |  |  |  | 1.69 | 1.39
 |  |  |  |  |  |  |  |  | 3.17 | 0.92 |  |  |  |  |  | 2.76 | 1.5 |  |  | 1.27
 |  |  |  |  |  |  |  |  | 3.08 | 0.92 |  |  |  |  |  | 1.85 | 1.83
 |  |  |  |  |  |  |  |  | 1.11 | 0.93 |  |  |  |  |  | 2.31 | 1.65
 |  |  |  |  |  |  |  |  | 1.76 | 0.93 |  |  |  |  |  | 2.28 | 1.64