Interval data is a record of a home's electricity use at regular intervals, taken by the utility meter. Add it to a project to give Aurora the most detailed picture of when the customer uses power. You can paste the data in or import it from UtilityAPI.
In this article:
- Before you begin
- Preparing your data
- Pasting interval data
- Importing from UtilityAPI
- FAQ
- Related articles
Before you begin
- Get the customer's interval data in kWh, for example as a CSV file from their utility.
- To import from UtilityAPI, an admin needs to connect it first. See Configuring the UtilityAPI integration.
- If the project already has solar, Aurora recommends Monthly estimate with existing system instead, because it adds the existing system's production. See PV and Battery Add-On Projects (aka Retrofits).
Preparing your data
Aurora needs one year of values in kWh, and nothing else in the data box. The number of values depends on the interval:
| Intervals (minutes) | Values for one year | If the year includes February 29 |
|---|---|---|
| 15 | 35,040 | 35,136 |
| 30 | 17,520 | 17,568 |
| 60 | 8,760 | 8,784 |
Paste only the usage values. Aurora skips header rows, blank lines, and other entries that aren't numbers without warning you, so remove them first.
Separate the values with a single character, such as a comma or a line break. You'll choose it under Data delimiter: Colon, Comma, Newline, Period, Semi-colon, Space, or Tab.
Pasting interval data
Paste the data on the project's Energy usage page. These steps take you from the project to saved interval data.
- Open the project and click Energy usage.
- Under Input method, select Interval data.
- Click Add interval data.
- Select the Start date of your data.
- Under Intervals (minutes), click 15, 30, or 60.
- Under Data delimiter, select the character that separates your values.
- Paste your values into the data box.
- Click Save.
If your data covers less than a year, Aurora shows Looks like you have some missing values. If this is a mistake, try pasting your values again or click save to allow Aurora to estimate what's missing. Click Save to have Aurora estimate the missing intervals the same way it estimates months for Monthly estimate (1-12 months), or paste the full dataset again.
When you save, Annual energy and the charts update with your data, and every design on the project uses it.
Note: Add interval data always opens empty, even after you've saved data. To change the data, paste the complete dataset again and click Save. Aurora replaces what was there.
Importing from UtilityAPI
If your account has UtilityAPI connected, you can import a customer's interval data directly. These steps take you from the project to imported data.
- Open the project and click Energy usage.
- Under Input method, select UtilityAPI.
- Review the matching accounts. Aurora matches on the project's customer name, service address, and service account ID where it can. Each result shows the account holder's name and address, the rate plan, and the SAID.
- Click Select on the customer's account. Aurora imports its interval data.
FAQ
Why does UtilityAPI show "Showing 0 results matching current customer profile"?
Your account may not have UtilityAPI connected, or no UtilityAPI account matches the customer's details. Ask an admin to check Apps in Settings, and check the project's Customer profile.
Can I upload a Green Button file?
Not directly. Copy the usage values from the file and paste them into Add interval data.