How to read the usage csv

[Dimitryp]

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

[Bob_H · Accepted solution]

Dimitryp,

Reading the CSV's from AGL was discussed here:

https://community.agl.com.au/t5/Renewables-and-Energy-Technology/AGL-app-now-showing-Solar-export/m-...

[Wesley_Pang]

If you changed the file name from MyUsageData_DD-MM-YYYY.csv to MyUsageData_YYYY-MM-DD.csv it would sort better by filename.

[David_AGL]

Hi @Dimitryp , you might also find the tools that @NeilC created and mentioned in this thread useful