1. Consumption File Upload Example
- Please view this two-minute video of one method to upload Consumption Files to New HelioScope Financials and Proposals.
2. Step-by-step Instructions: How to Upload Consumption Files
1. Open your hourly 8760 consumption data for the site.
a. Currently, only hourly consumption data is compatible.
2. If needed, split the Date/Time from the Energy usage by:
a. Highlighting the column with energy data,
b. Select the Data tab and Text to Columns,
c. Ensure "Delimiter" is selected and press Next,
d. Ensure the appropriate delimiter is selected (semicolon in the video example) and press Next,
e. Select Text and then Finish.
3. Copy the energy consumption values in the column.
4. Go to How to Upload Consumption Files.
5. Download the appropriate Template File.
6. Paste the energy data into the Template File.
7. Save the file as a CSV file.
8. Navigate to the Financial and Proposals Overview Page and scroll down to the Consumption Details.
9. Click the Upload New Field.
10. Select the newly saved consumption file to upload it.
a. Optional: If you want to choose between multiple files or your manual input, click the dropdown in the top right corner of the Consumption Details section.