There are three options: Input Consumption by Bills (US Only), Directly Input Consumption by Bills (for both US and International), and Upload File.
- The first option, Estimate consumption by Bills(US Only), is a quick way to get an idea of what a client’s consumption patterns look like, based on a few months of data, and typical consumption patterns in the area. Please note this option is only available in the United States. The more bill values that are inputted will help provide the most accurate estimate.
- The second option is to Directly Input Consumption by Bills, this allows you to have a more precise calculation of the homeowners energy consumption pattern and bills. Please note that you need to have 12 months worth of data to achieve best results with this option. This is available for all users in the US and internationally.
- The third option, Upload File, allows you to upload a CSV or Green Button Data XML file to input a consumption profile. For each option, you will want to choose the location, your customer’s Utility Provider, Utility Rate, and the Rate Effective Period.
Uploading Data to Estimate Consumption allows you to view detailed information on a consumers utility consumption and time of use that can be found on many utility company websites. You can choose to upload Data via an .xml or .csv file format as opposed to inputting bill values to the Consumption portal. Commercial sites with Demand Charges will need to be uploaded with Green Button Data so Aurora can accurately calculate the rate and consumption.
To upload your Green Button Data into Aurora, follow the steps below:
- Go to the Consumption tab in the left hand toolbar, then select <b>Upload Data File</b> in the top right.
- Choose your customer’s Utility Provider, Utility Rate, and the Rate Effective Period.
Before uploading, please ensure that you have obtained at least 1 year’s worth of timely interval data.
- The Green Button option allows you to upload a green button style xml file from any utility company or service that provides them.
- For PG&E, you can upload a CSV file that is downloadable from the account page of your customer’s Pacific Gas, and Electric web portal.
- If you do not have data for these options, but you have the energy usage in kilowatt hours for each hour of the year, you can Download a CSV Template Aurora has created for you to use. When selecting this option:
- There are different file formats to select from:
- First download the Hourly Interval Template.
- Open this up from your downloads on your computer.
- Input the data information into a spreadsheet software such as Excel or Numbers, then save or export the file as a CSV format.
Once you upload your file from a selection above, this will allow you to estimate your customer’s consumption load profile.
If you'd like to learn more about Green Button Data, check out our blog post: The Value of Green Button Data.
If you are interested in learning more about the hourly load profile, see our blog post entitled How to Estimate a Homeowner's Energy Load Profile.