Looking for tips or advice on energy efficiency around the home? See what others are doing or share your experience!
Looking for tips or advice on energy efficiency around the home? See what others are doing or share your experience!
Could you please assist in how to read the CSV detailed usage report which is downloadable from the AGL customer portal, from the Usage section?
It's full of great info, but i'm not sure if the numbers are cumulative for the 30min block which each line item represents? And if that is so, why does it show me both importing and exporting energy at the same time? If i have excess energy to export, why would i also be using energy from the grid?
Here's 4 lines from the downloadable CSV, for 2 consecutive 30min blocks. (i've cut out the columns with my account number and NMI)
DeviceType | RegisterCode | RateTypeDescription | StartDate | EndDate | ProfileReadValue | RegisterReadValue | QualityFlag |
COMMS4D | 82218#B1 | Solar | 24/08/2019 13:00 | 24/08/2019 13:29 | 0.516 | 0 | A |
COMMS4D | 82218#E1 | Generalusage | 24/08/2019 13:00 | 24/08/2019 13:29 | 0.242 | 0 | A |
COMMS4D | 82218#B1 | Solar | 24/08/2019 13:30 | 24/08/2019 13:59 | 2.092 | 0 | A |
COMMS4D | 82218#E1 | Generalusage | 24/08/2019 13:30 | 24/08/2019 13:59 | 0.017 | 0 | A |
thanks!
Dimitry
Solved! Go to Answer
Reading the CSV's from AGL was discussed here:
If you changed the file name from MyUsageData_DD-MM-YYYY.csv to MyUsageData_YYYY-MM-DD.csv it would sort better by filename.
Hi @Dimitryp , you might also find the tools that @NeilC created and mentioned in this thread useful