Neighbourhood

Find answers. Ask questions. Share what you know and join the conversation.

How can we help you?

ceejayeegee's profile

Semiconductor

 • 

3 Messages

How to interpret downloaded power usage/solar generation data Excel CSV files

Can someone explain to me if the Excel CSV files that can be downloaded from the MyAGL IQ My Usage page are really in NEM 12 format and how the consumption and solar generation data/values are to be interpretted please.

In particular, as per the image below, why does the column Rate Type Despcription feature 3 Peak and 2 Solar readings for each half hour interval for each day? If these represent different rates within the applicable tariff structure, then why are the values repeated for Register Codes 01246#E1 and 2? 

I am more familiar with half hourly interval data reports in Excel format where dates are listed by rows and 48 half hour interval values for each day of interval data are listed in columns - does AGL provide data in this format? 

AGL HHI Readings -Excel CSV file.jpg

1 Attachment

Retired AGL Moderator

 • 

35 Messages

Hi @ceejayeegee. 

 

Thanks for the post and welcome to the Community! 

 

We are investigating the answer for you and will back in touch shortly. 

 

Thanks! 

Retired AGL Moderator

 • 

35 Messages

Hi @ceejayeegee. 

 

We confirm that the data is generally provided in 30 minute intervals however our system then breaks this down into 15 minute intervals. Which means that the meter data that you download from AGL Energy Online. 

 

Thanks! 

Semiconductor

 • 

3 Messages

Hi Catherine

It looks like your reply was cut short or is somewhat meaningless. Could you elaborate please.

Can you confirm that  smart meter readings that I understand are just total progressive grid sourced power readings net of solar used internally in the home, are convertered to half hourly interval data by AGL that is then used for billing purposes?

Can you also clarity the purpose of the three different types of register codes to which half hourly interval data are assigned?

Super Nova

 • 

18 Messages

Hi @ceejayeegee, 

Thank you for your follow up, and apologies for the lack of clarity provided in our initial response.

 

It is very interesting to go see this csv file, since the data should generally just who two rows for consumption and generation, and then the last for export to the grid. We are working very hard on the 'usage' aspect that our customers are currently able to monitor via My Account or the app. As such, you may have noticed that the ability you had to download your usage information is no longer there for you. We are aiming to provide a better way of accessing this information - and to do it as soon as possible. 

 

I am very sorry for any inconvenience caused in the meantime. Thank you so much for your patience, and please let us know if you have any other questions.

 

Kindly, Jordan

Conductor

 • 

5 Messages

Thank you for your detailed feedback, Jordan. If I read your note correctly, and if it remains current, then users have lost the old IQ ability to download usage data.

 

"As such, you may have noticed that the ability you had to download your usage information is no longer there for you. We are aiming to provide a better way of accessing this information - and to do it as soon as possible."

 

I don't want a "better" way - I just want the old way! 

 

Is there an ETA for any solution? 

 

Thank you VERY much,

Anita

Semiconductor

 • 

3 Messages

Hi Jordan

I believe that the data as featured in the extract from the CSV file for my power usage, as featured in my original post, is corrupt, as reflected by an adjustment that has recently been made to by AGL electricity bill. As yet, I have still not had a satisfactory reply to my initial query that explains how to interpret the half hourly interval data and in particular, if someone can confirm that there should be only one register code active for each of grid sourced power and solar power exported (if applicable) for any given half hourly period. In other words, it should not be possible for two or more register codes to show kWh values for a given half hourly interval.

I am also keen to better understand the process by which smart meter cumulative meter readings that are sent remotely/electronically to my energy distributor, are then sent on to AGL and converted to half hourly interval data, and which are then adopted for billing purposes. If someone can shed some light on how this is done and who does what and how the values can be corrupted and what is the purpose of multiple register codes for grid sourced power, it would be helpful and much appreciated. In my case, my smart meter was installed by another energy retailer and the half hourly interval data corruption only started once I switched to AGL.

I am confused by your comment and those of Anita about download access to my usage data (half hourly interval data in Excel CSV format) no longer being available as this facility is still available to me via My AGL IQ website.

Powerhouse

 • 

802 Messages

CeeJay,

To the best of my knowledge no Retailer supplies files in NEM format.

They supply the data as is comes from the SmartMeter.

I have a program to convert the data from AGL2Nem.

Working at the moment to test the programs and announce them on the this web site.

 

Interested to see that according your file you have two solar units.

 

One that supplies power during the night and one that does not.

 

Bx meters are generators on your side and Ex meters are usage on your side.

 

NEM format files are (or should be) available from your electricity supplier (the company that owns the poles).

 

Cheers Neil