ABOUT ENERGY STAR PARTNER RESOURCES

Search by Topic:

Can I Copy/Paste Data into my Meter? Follow

Yes. One way to enter multiple bills for one meter is to copy your bill data from a spreadsheet and paste it onto the Manage Bills page.

1. Navigate to the Manage Bills Page: to get to the Manage Bills Page, select your property from your MyPortfolio page then select the Energy tab then select the meter

1.png

2.png

a. If you have not already created a meter, you can do so by selecting the blue 'Add a Meter' button and follow the guided steps to add a new meter to the property.
3.png

 

2. Download the spreadsheet template by selecting the 'spreadsheet template' link at the bottom of any meter entry page:

3. Save the spreadsheet to your computer and fill in the downloaded spreadsheet with your meter’s bill data. Be sure to fill in all required columns including the last column, Estimation (Yes/No). Column A, B, C and E must be complete for each row of data.*

4. Copy your data (but not the header: row 1), by highlighting all of the new meter information from the spreadsheet downloaded in step 2 and clicking Cntl+C

5. Paste your data on Manage Bills page for the meter you would like to update. At the bottom of the Monthly Entries table select Add Another Entry and click into the empty “Start Date” field and click Cntl+V to paste the information.

Capture.PNG

6. Save the new data: click the "Save Bills" button at the bottom of the page.

 

*Note - Don't change the format of any of the columns.

Have more questions? Submit a request