Checking your usage file for EA - CitiPower - Powercor

The format described on this page and shown in the picture below is used by:

  • EnergyAustralia
  • CitiPower / Powercor

If you have requested a 'Victorian Energy Compare supported consumption file' (also known as a 'usage file') from the above retailer or distributor, it should pass the three checks below. Use this information, and the example shown below, to check and compare your file.

  1. The columns in your file should adhere to these conditions:
    • Column 1: should contain a Meter ID (10 digits)
    • Column 2: should contain a date
    • Column 3: should contain a time
    • Column 4: should contain a register ID (8 digits)
    • Column 5: Should contain a consumption flag (E.g. E1, B1, etc.)
    • Column 8: should contain a consumption value (E.g. 0.076)
  2. In the second column of your file, there should be 12 complete consecutive months of data e.g. from 01/01/2013 to 31/12/2013
  3. In the eigth column of your file, there should be consumption data (also known as 'Interval data'). Your file should contain 48 consumption values for every day, one for each 30 minute period.

Example of consumption file (usage file)

The image is a sample of a consumption file and highlights the conditions as described on this page.

The example file in the picture is an incomplete file. Your file should contain more data.

If your file does not pass the checks above and looks significantly different to the example shown, then you should go back to your retailer or distributor and request a 'Victorian Energy Compare supported consumption file'.

Files may also contain other additional information (for example, if you have solar or controlled load, there may be additional streams of information presented in your file). However, even with these differences, your file should still pass the same checks and look similar to the example above.