Supported Data Formats
Table of contents
Below is a list of interval data formats supported by InverseAudit. We continuously add new formats. For any questions or issues with data import, please contact our support team.
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
Understanding 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 mistakenly treated as kWh:
- Result: Annual energy consumption would be overestimated by 100%. The annual energy consumption would be calculated as double the actual amount (kWh).
If 30-minute kWh intervals are mistakenly treated as kW:
- Result: Annual energy consumption would be underestimated by 50%. The estimated annual energy consumption would be 50% lower than the actual amount (kWh).
These errors, when propagated over extended periods, can result in substantial discrepancies in energy analysis.
Data Format 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 consumes Green Button data without any modification
CSV (Comma-Separated Value) 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
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
Three-Column Format
- Column 1: Date
- Column 2: Time
- Column 3: Electricity usage data
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
Ensure data consistency within each file For CSV files, maintain a clear structure as outlined above When using the horizontal CSV format, specify the unit (kW or kWh) if it differs from the default
Natural Gas
| Company | Reference | Format | Interval | Tested |
|---|---|---|---|---|
| InverseAudit | - | csv (comma-separated values) | 1 Month | Yes |
Fuel Oil
| Company | Reference | Format | Interval | Tested |
|---|---|---|---|---|
| InverseAudit | - | csv (comma-separated values) | 1 Month | Yes |
District Chilled Water
| Company | Reference | Format | Interval | Tested |
|---|---|---|---|---|
| InverseAudit | - | csv (comma-separated values) | 60 mins | Yes |
District Steam
| Company | Reference | Format | Interval | Tested |
|---|---|---|---|---|
| InverseAudit | - | csv (comma-separated values) | 60 mins | Yes |