Reconciling AGL electricity bill to downloaded .csv data

MarcBerger
Conductor
1 Reply 487 Views

I downloaded two years of my electricity usage data (from https: //myaccount.agl.com.au/usage ) and am trying to reconcile that data for a particular month against the AGL bill for that month. I can reconcile the kWh figures for total usage and for the controlled load. However, I cannot see how to split the non-controlled loads into peak, off-peak and shoulder. For each half hour of the day the kWh data is split into three "RateTypeDescription" categories, namely "Controlledload" and two "Usage" categories. For example, on 27/5/2025 in the half hour from 13:30-13:59 (which is in the shoulder period) my total usage was 2463 kWh. The total is split into "Controlledload" (0.105 kWh) and two "Usage" figures (2.257 and 0.101 kWh). Logically, since the period in question is a shoulder period, both usage figures should be shoulder usage. However, if I apply this logic consistently to the entire monthly billing period, it does not reconcile to the peak usage stated on the bill. Can anyone explain how these "Usage" figures can be reconciled to the bill?

 

Kind regards,

MarcBerger

1 REPLY 1
MarcBerger
Conductor
0 Replies 471 Views

OK, my bad! The problem I was having turned out to be a problem with my spreadsheet. All now resolved and AGL bill fully reconciles to the downloaded usage data.

 

Kind regards,

MarcBerger