Correctly Formatting Interval Data

When assessments fail, it is most likely due to the interval data file not been formatted
correctly. Interval data comes directly from the retailer in Excel and can be provided in
a variety of formats with any number of columns, worksheet tabs, header rows, or
include null data.

A sense check and clean-up of the data may be required for the assessment to run
successfully. The following are key things to check to ensure the data file is correctly
formatted:

• No header rows – the first row should contain the column name
• A total of three columns is required
  • A date and time column is required – this can be 30 or 15min steps
  • A column is required for either kW or kWh
  • A column for kVA
• Ideally 12 months of data is required
• No more than one tab in the spreadsheet– delete all other tabs
• Check for bad data – e.g. ensure that kVA ≥ kW, no missing data, errors, etc