Supported data formats

The meter data file formats InverseAudit can import, and how it reads kW and kWh.

On this page

We continuously add new formats. For questions or problems with a data import, contact support.

If your meter data file contains more than one year’s worth of data, our system will automatically use the latest one-year period.

Electricity

kW and kWh in interval meter data

Interval meter data typically presents energy consumption information in two key metrics: kilowatts (kW) and kilowatt-hours (kWh). Proper interpretation of these metrics is crucial for accurate energy analysis and billing.

Definitions

  • kW (kilowatt): A measure of power, representing the rate of energy consumption at a given moment.
  • kWh (kilowatt-hour): A measure of energy, representing the total amount of electricity consumed over a period of time.

Data conversion

When converting interval data to hourly figures:

  • kW values are averaged to represent the mean power demand.
  • kWh values are summed to represent the total energy consumption.

Critical Interpretation

Misinterpreting kW as kWh or vice versa can lead to significant errors in energy calculations:

  • If 30-minute kW intervals are treated as kWh, annual energy consumption is overestimated by 100% (double the actual kWh).
  • If 30-minute kWh intervals are treated as kW, annual energy consumption is underestimated by 50% (half the actual kWh).

These errors, when propagated over extended periods, can result in substantial discrepancies in energy analysis.

Data formats for InverseAudit

InverseAudit supports two major data formats: Green Button and CSV. This manual outlines the specifications for each format and how they are handled by the system.

Green Button format

The Green Button is a standardized data format designed for easy and secure access to energy usage data.

  • Format: Standardized, machine-readable
  • Purpose: Allows utility customers to access their energy usage data in a consumer-friendly format
  • Handling: InverseAudit reads each reading’s unit and multiplier from the file (Wh or kWh, energy or power), adds 15-minute readings up into hours, and uses electricity readings only. If the building exports solar power, the hourly use is the energy delivered minus the energy sent back to the grid. Times are converted from UTC to the building’s local standard time.
  • One file per year: a year split across several XML files, or a zipped download, isn’t read. Unzip it, and use one file that covers the year.

CSV (comma-separated values) format

CSV is a common output format for spreadsheet programs. InverseAudit supports two types of CSV formats and can automatically recognize the type.

Horizontal CSV format
  • Structure: Horizontal header shows time, First column shows date
  • Default Unit: kW
  • Unit Specification: If needed, include “kWh” or “kW” in the first cell of the first column
  • File Extension: .csv

Horizontal CSV: dates in the first column and times across the header row Horizontal CSV with the unit in the first cell

Vertical CSV format

InverseAudit supports two variations of the vertical format:

Two-column format
  • Column 1: Date and time combined
  • Column 2: Electricity usage data

Two-column vertical CSV: date and time in one column, usage in the next Another two-column vertical CSV example

Three-column format
  • Column 1: Date
  • Column 2: Time
  • Column 3: Electricity usage data

Three-column vertical CSV: date, time and usage Another three-column vertical CSV example

Data import process

InverseAudit automatically detects the format of the imported file (Green Button or CSV). For CSV files, the system determines whether it’s a horizontal or vertical format. The data is then processed according to the identified format.

Best practices

  • Keep the data consistent within each file.
  • For CSV files, keep the structure described above.
  • With the horizontal CSV format, specify the unit (kW or kWh) if it differs from the default.

Times and daylight saving

The weather and the model run in the building’s local standard time. Each reading belongs to the hour it ends in.

  • CSV files keep the hours they have, clock time (with daylight saving) or standard time. The Time stamps box on Meter data shows which InverseAudit found, and the calibration lines the model up with them: readings timed by the clock keep the model’s schedules on the same hours all year; readings in standard time all year give the model daylight saving, so its working day moves an hour in summer as theirs does. See Time stamps and daylight saving time.
  • Green Button files are in UTC and are moved to the building’s local standard time.
  • Monthly bills have no hours, so the model keeps its schedules on the same hours all year, without daylight saving.
  • The charts on Home show the hours as the meter data has them, and for monthly data the model’s hours.

Natural gas and fuel oil

There’s no file format for natural gas or fuel oil. Enter the monthly use (therms for natural gas, gallons for fuel oil) on the Natural gas / fuel oil tab of the Meter Data window, or import your bills with AI on its first tab. Enter 0 for a month the utility didn’t read. See Natural gas and fuel oil.

District chilled water

CompanyReferenceFormatIntervalTested
InverseAudit-csv (comma-separated values)60 minsYes

District steam

CompanyReferenceFormatIntervalTested
InverseAudit-csv (comma-separated values)60 minsYes