3.2 Add monthly usage data via ESPM spreadsheet upload, or manually
This article outlines the steps needed to add monthly energy usage data manually to your property in ENERGY STAR Portfolio Manager. If you would like to set up an automatic data sync with your utility provider(s), please refer to: 3.1. How to add energy data automatically: Set Up Data Exchange With Utility Provider(s) In ESPM (
Help Desk Article).
STEP 1 - Once you have created your meter(s), you are now ready to add monthly energy use information. There are two options to manually add monthly energy data to your meter in ESPM. Option 1 (Add monthly data in bulk from an excel spreadsheet) is the recommended option if you are uploading data for more than one meter, as it can help minimize data entry errors.
Option 1: Add monthly data in bulk from an excel spreadsheet
Download the single-meter spreadsheet, add the required information
and upload the spreadsheet to ‘Upload data in bulk for this meter’
Option 2: Add monthly data manually based on your monthly energy bill(s)
Click ‘add entry’ and add the required information for each month, then click ‘Save Bills’
Click ‘Continue’ to move on to the final step of setting up your meters.
Note: You are not required to enter monthly data right away to finish setting up your meters.
STEP 2 - Select which meters to include for your property and confirm if these meters represent the total energy usage of your property, or only represent the partial energy usage of the building.
When you have completed this step, click ‘Apply Selections’.
For more information and to contact the Help Desk, Submit a Ticket for 'Help using Energy Star Portfolio Manager'.
Related Articles
3. Add energy meters (Electricity, Natural Gas, and other) to your ESPM property
There are three ways to add energy use information to your ESPM property(ies): manually, by filling in and uploading a spreadsheet, or by setting up an automatic data exchange with your utility provider (Help Desk Article). Before setting up the data ...
3.1. How to add energy data automatically: Set Up Data Exchange With Utility Provider(s) In ESPM
3.1.1 BC Hydro customers - set up data exchange with BC Hydro Before enrolling in BC Hydro’s Web Services, ensure that: All of the meters accounting for the building’s total energy consumption have been added to the property profile You have ...
3.1.1. Data Aggregation (For commercial, residential, and mixed-use buildings with multiple tenants)
BC Hydro BC Hydro can aggregate energy usage data for: Commercial buildings with three or more commercial accounts Multi-unit residential buildings with five or more residential accounts Mixed-use buildings that have three or more commercial accounts ...
2. Add & Set up your property
STEP 1 - After logging in to ESPM, click the ‘Add a Property’ button on the upper left of the MyPortfolio tab. STEP 2 - Answer questions about your property Property type (Main property type) Number of buildings (Partial building, Single building or ...
5. Share your properties with the Capital Regional District ESPM account
Before being able to share your properties with the Capital Regional District Benchmarking ESPM account “CRDBenchmarking”, you must first connect with them on ESPM. STEP 1 - Send a connection request to the CRDBenchmarking ESPM account. You have two ...