Data usage in detailed .XLSX for spread sheets.

[VKBob]

The simplified usage details on the portal are inadequate for a big company like AGL! We are not dumb users and I would expect a more detailed breakdown of actual usage that can be incorporated into an ongoing spreadsheet in XLSX format.

Please give us a detailed spreadsheet so that we can track the cost, times, period and usage details in XLSX format.

[Lester]

Bob, I feel the back end work needed to provide all the plan and pricing info would be a challenge.

While AGL obviously have that capability now in final billing you, not sure it'd be easy to redesign the download data to reflect the extra info.

That data is just collated from the same sort of simple 5 min data the DNSP provides to the retailer.

Within states there can be numerous DNSPs with vastly different terms, tariffs, TOU variations, then within AGL or any other retailer their different plans, tariffs, etc with a myriad of single rate, TOU, demand tariffs, various daily supply charges etc.

Everything is present now in data except for the pricing and individual plan times of use.

Using the current 30 min data you can get from AGL to spreadsheet that with my pricing etc, is not an easy task.

I've tried, complicated by defunct CL lines x approx 4400 extra nil recording lines per quarter.

What you are asking for is open and clear data like that format, but showing your own pricing for whatever plan you are on, those tariffs for single or TOU, DSC (daily supply charge), etc ?

That would be good for people to have without hassle, and a fair thing to request.

At the moment you can't really see clear transparent data / pricing, you trust the system is working as it should.

Maybe one of the AI platforms can use simple instructions to separate TOU data, add pricing, add DSC etc ?

My son is good at that sort of thing, will ask him.

There is a section of the usage window when logged into the website, clicking a day you can break down 6 hourly blocks with usage, cost, etc

Although this is just an overview, it might help see when you use power at highest tariff levels etc on various days.

[VKBob]

To have access to the raw data that AGL uses itself to calculate the price it charges for power is not a big ask. The GUI is based on this but you have no access to the data in a transferable format.

A file copy for my own analysis is what I ask and in a workable format.

It's very simple...

[Mia_AGL]

Hi, I’m sorry the portal isn’t providing the level of detail you’re looking for. If you need more detailed usage data for your own analysis and spreadsheets, you can download your usage data directly from AGL My Account.

How to download your usage data:

• Log in to your AGL My Account.
• Go to the Usage page.
• Click the Download icon in the top-right corner of the usage graph section.
• Save the file. It will download as a CSV file, or a compressed folder containing a CSV file, which can be opened directly in Microsoft Excel.
• Please note that the download option requires a digital/smart meter. Analogue meters don't support interval data downloads.

If you need even more detailed interval metering data, you can also request it here: https://www.agl.com.au/campaigns/request-metering-data. The feedback about providing a more comprehensive XLSX export, including costs, times, billing periods and usage details, has been noted.
Kind regards,
Mia.