Meter data

The calibration matches the model to your meter data, so its quality decides how accurate the results are.

For: AnalyzerWhere: Home › Meter Data card

You have 12 months of meter data (13 months of interval data is recommended): an interval data file for buildings with hourly data, or monthly bills for buildings with monthly data. See Supported data formats.

Steps

  1. On Home, click the building’s Meter data card.
  2. Add the electricity data:
    • Hourly data - On the first tab, Import files, drop your interval data file into the upload area and click Import and fill meter data. InverseAudit recognizes the file’s format automatically. The Electricity (hourly data) tab then shows a monthly summary and the data quality checks.
    • Monthly data - Complete the required fields for each month on Electricity (monthly data), or import your bills on the first tab, Import bills.
  3. Enter monthly natural gas or fuel oil use on the Natural gas / fuel oil tab. See Natural gas and fuel oil. If the building uses district chilled water or steam, upload its 60-minute data on the Chilled water or Steam tab.
  4. Click Save changes.

On a calibrated building, uploading or importing new data, or saving changed values, sends the building back to preparation. Check inputs and run the calibration again afterwards. Saving without changes keeps the calibration.

The Electricity (hourly data) tab with the monthly summary and data quality checks

Entering monthly data

What you’ll see next

The Meter data card no longer shows Pending. When all four cards are done, check inputs and run the calibration.

Import utility bills with AI

The first tab can fill in the fields for you. Upload your utility bills (and, for buildings with hourly data, your interval data file) and click Import and fill monthly data (buildings with monthly data, tab Import bills) or Import and fill meter data (buildings with hourly data, tab Import files). Check the values on the other tabs before you save.

The import reads each bill’s usage, peak demand and total cost. The costs set your utility rates: see Rates from your bills.

You can upload up to 50 files of up to 40 MB each: PDF, JPG, PNG, XLS, XLSX, CSV, TXT or XML (Green Button), with at most two CSV or TXT files and one Excel file. Importing again overwrites the data on the other tabs.

The Import files tab

Natural gas and fuel oil

Enter each month’s use on the Natural gas / fuel oil tab: therms for natural gas, gallons for fuel oil. Purchased steam without a meter file is entered here too, in MMBtu. The two options beside the table decide how the calibration uses these bills:

  • No natural gas or fuel oil - Sets every month to 0. Tick it only when the building uses neither. If the building heats with gas and you leave its bills out, its heating isn’t calibrated.
  • Bills are actual meter readings - Tick it when every bill is an actual reading, with no estimated, skipped or combined months. The calibration then compares each month’s bill with the model, against ASHRAE Guideline 14. Left unticked, it fits the year’s total. This option isn’t offered for fuel oil, whose deliveries don’t follow the months: fuel oil is fitted on the year’s total.

Utilities sometimes skip a month’s reading and bill it with the next one. Enter 0 for the skipped month, not an estimate, and leave Bills are actual meter readings unticked: the next bill makes up the skipped month, so the year’s total is still right and the calibration isn’t misled. With the option ticked, Check Inputs warns about a month billed 0 between two months with gas, unless a cost is entered for it: a month with only a charge, such as a summer customer charge, is a bill.

The calibration weighs electricity more than gas: gas counts for at most a quarter of the score, and the gas counts as matched when the year’s total is within 5% (each month’s CV(RMSE) within 15% when the bills are actual meter readings). Gas bills are usually further from anything a model can match than electricity. The audit report’s Appendix A states how the gas was calibrated.

Time stamps and daylight saving time

An interval data file is timed either by the clock, which moves an hour for daylight saving time, or in standard time all year. The calibration lines the model’s hours up with the readings, so it needs to know which. The Time stamps box on the Electricity (hourly data) tab shows what InverseAudit found, and you can change it:

  • Detect from the readings - InverseAudit compares the building’s weekday start and stop in the weeks before and after each clock change. If they stay at the same hours, the readings follow the clock; if they move an hour, they’re in standard time. Readings without a clear working day are taken as following the clock, as most utilities’ files are. Leave Green Button files on this choice: they’re moved to standard time when imported.
  • Follow the clock (daylight saving time) or Standard time all year - Choose one when you know how your utility times its files.

The box appears only where the clocks change. Your choice is kept when you import the interval data again. Changing it sends the building back to preparation, so run the calibration again.

Missing data and outliers

Treat readings that don’t represent actual energy use as missing data. Up to 2,500 hours of data points can be missing, and the data must cover at least 9 months. To exclude readings, edit the file in Excel or any text editor and either:

  • remove the entire row, including the date, or
  • fill the readings with zeros or blanks, keeping the dates.

The examples below are all acceptable in a CSV (comma-separated values) file. For Green Button data, use an XML editor.

Excluding readings by removing rows

Excluding readings with blanks

Excluding readings with zeros

If something goes wrong

My interval data file won't import

Check that the file matches one of the supported data formats, and that it covers at least 9 months with no more than 2,500 missing hours. If it still won’t import, contact support and attach the file.

The annual electricity use looks doubled or halved

The file’s unit was probably read as kW instead of kWh, or the other way around. Put the unit in the file as described in Supported data formats.

In summer, the model's hours are an hour off the readings

On the calibration’s heat map, the calibrated model’s working day starts an hour earlier or later than the measured one while daylight saving time is on. Set Time stamps on the Electricity (hourly data) tab to how your utility times its files, save, and run the calibration again. See Time stamps and daylight saving time.