topic How to read the usage csv in Managing Your Energy

How to read the usage csv

Dimitryp — Sun, 25 Aug 2019 03:36:52 GMT

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

Re: How to read the usage csv

Bob_H — Sun, 25 Aug 2019 07:09:22 GMT

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-p/13612#M1138

Re: How to read the usage csv

Wesley_Pang — Sun, 25 Aug 2019 21:57:37 GMT

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

Re: How to read the usage csv

David_AGL — Wed, 28 Aug 2019 01:14:10 GMT

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