This script analyses energy usage data from an InfluxDB v1 database and runs TCO calculations on various different fixed or TOU market energy plans.
The influxdb metrics Grid_Consumption, Solar_Feed_In and Self_Consumption (in Watts) are integrated to retrieve the usage data per hour. All analysis is performed on average prices across each hourly period.
It will also look at an additional SQL database which contains the AEMO spot prices and calculate the TCO of amber energy wholesale pricing versus other market plans. An SQL dump of this database is included in the repo with a couple of the last years data sets.
A very simple model for simulating battery charging and discharging is also included in the script.
Configuration of the influx and SQL credentials is done within config.yml. Configuration of the plans, rates, and simulated battery charge/discharge are done within the ruby script itself inside constants at the beginning of the file.
For wholesale market plans, an hourly cost break down (including mean/average price per hour) is also included along with the Volume Weighted Average Price across the whole period being analysed.
Example output:
Energy cost breakdown for period 2024-08-01 00:00:00 +1000 to 2025-08-01 00:00:00 +1000 ...
** Per-Plan Costs **
Amber / EvoEnergy / 017 New Residential TOU Network $ -1413.75
ActewAGL Value Plan $ 1057.38
Origin Affinity Variable $ 1499.93
ActewAGL Direct Saver $ 1859.49
Origin Go Variable $ 1862.17
Origin Go Solar Variable $ 1905.45
ActewAGL Simple Saver $ 1938.24
ActewAGL Standard Plan $ 2613.11
** Amber / EvoEnergy / 017 New Residential TOU Network -- Hourly Cost Totals **
Hour 0 | import: $ 134.65 ($ 0.193 /kWh) | export: $ -8.96 ($ -0.080 /kWh)
Hour 1 | import: $ 122.79 ($ 0.185 /kWh) | export: $ -5.14 ($ -0.072 /kWh)
Hour 2 | import: $ 119.51 ($ 0.182 /kWh) | export: $ -5.24 ($ -0.069 /kWh)
Hour 3 | import: $ 120.40 ($ 0.182 /kWh) | export: $ -5.22 ($ -0.069 /kWh)
Hour 4 | import: $ 119.79 ($ 0.187 /kWh) | export: $ -5.84 ($ -0.074 /kWh)
Hour 5 | import: $ 126.05 ($ 0.197 /kWh) | export: $ -6.90 ($ -0.084 /kWh)
Hour 6 | import: $ 119.06 ($ 0.199 /kWh) | export: $ -5.69 ($ -0.087 /kWh)
Hour 7 | import: $ 136.88 ($ 0.304 /kWh) | export: $ -12.44 ($ -0.086 /kWh)
Hour 8 | import: $ 159.13 ($ 0.286 /kWh) | export: $ -10.68 ($ -0.068 /kWh)
Hour 9 | import: $ 57.28 ($ 0.140 /kWh) | export: $ -2.12 ($ -0.027 /kWh)
Hour 10 | import: $ 23.05 ($ 0.121 /kWh) | export: $ 3.08 ($ -0.009 /kWh)
Hour 11 | import: $ 14.08 ($ 0.110 /kWh) | export: $ 0.85 ($ -0.018 /kWh)
Hour 12 | import: $ 12.87 ($ 0.097 /kWh) | export: $ 25.75 ($ -0.005 /kWh)
Hour 13 | import: $ 16.91 ($ 0.109 /kWh) | export: $ -11.97 ($ -0.017 /kWh)
Hour 14 | import: $ 37.02 ($ 0.181 /kWh) | export: $ -136.57 ($ -0.089 /kWh)
Hour 15 | import: $ 50.42 ($ 0.174 /kWh) | export: $ -64.39 ($ -0.082 /kWh)
Hour 16 | import: $ 145.93 ($ 0.251 /kWh) | export: $ -46.52 ($ -0.139 /kWh)
Hour 17 | import: $ 10.21 ($ 0.575 /kWh) | export: $ -1918.12 ($ -0.357 /kWh)
Hour 18 | import: $ 70.33 ($ 0.588 /kWh) | export: $ -1910.74 ($ -0.370 /kWh)
Hour 19 | import: $ 70.27 ($ 0.449 /kWh) | export: $ -19.33 ($ -0.231 /kWh)
Hour 20 | import: $ 132.82 ($ 0.384 /kWh) | export: $ -6.77 ($ -0.166 /kWh)
Hour 21 | import: $ 119.52 ($ 0.217 /kWh) | export: $ -5.70 ($ -0.105 /kWh)
Hour 22 | import: $ 194.34 ($ 0.210 /kWh) | export: $ -6.98 ($ -0.097 /kWh)
Hour 23 | import: $ 157.17 ($ 0.202 /kWh) | export: $ -4.83 ($ -0.089 /kWh)
------------------------------------------------------------------------------------------
VWAP | import: ($ 0.232 /kWh) | export: ($ -0.182 /kWh)