How to read the usage csv

Dimitryp
Conductor
2 Replies 12814 Views

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)

 

DeviceTypeRegisterCodeRateTypeDescriptionStartDateEndDateProfileReadValueRegisterReadValueQualityFlag
COMMS4D82218#B1Solar24/08/2019 13:0024/08/2019 13:290.5160A
COMMS4D82218#E1Generalusage24/08/2019 13:0024/08/2019 13:290.2420A
COMMS4D82218#B1Solar24/08/2019 13:3024/08/2019 13:592.0920A
COMMS4D82218#E1Generalusage24/08/2019 13:3024/08/2019 13:590.0170A

 

thanks!

Dimitry

3 REPLIES 3
Bob_H
Transformer
1 Reply 12808 Views
Wesley_Pang
Switched-on
0 Replies 12794 Views

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
AGL Community Manager
0 Replies 12779 Views

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