Time of day usage data

Williampape
Switched-on
2 Replies 34816 Views

Hi where can I find time of day electricity usage data ?

i have looked in the AGL app and can see total daily consumption but no further breakdown.

i understand other retailers supply hourly or every 2 hourly usage info. Thanks & Regards 

William

 

22 REPLIES 22
Giff
Charged Up
1 Reply 2670 Views

Hi PCP20US


I would contact AGL and query them about the content of your downloaded CSV file. 

My file contains two rows for each 30 minutes. One for Solar, the feed-in kWh, and the other for the energy consumed (purchased). 

I presume you have downloaded the csv file from the Web browser following Neil’s instructions above. 

Cheers

     Giff

pcp20us
Semiconductor
1 Reply 2668 Views

Hi Giff.

 

Yep downloaded the CSV file.

 

The hourly usage is in the file, I was looking at old data before the smart meter was installed. Doh.

So data is good , hopefully Neil jumps in with his excel project.

 

Giff
Charged Up
0 Replies 2665 Views

Do you have 1 or 2 lines for each 30 minutes?  Do you have Solar?

 

I’ve been playing with Google sheets as well as Excel. 

What information do you want to extract from the data?