You can add manual meter data (meters and/or readings) to your sites in Measurabl either in bulk or individually.
STEPS TO INDIVIDUALLY ADD A MANUAL METER:
- Navigate to the desired site from the 'Sites' tab.
- Click on the "Utilities" tab.
- Utilities are segmented by metric, and you can toggle between Energy, Water, and Waste at the top of the page.
- Click on the green "+" next to the desired meter type within the desired metric.
- Fill out the prompted fields > Click "Save."
STEPS TO INDIVIDUALLY ADD A MANUAL METER READING:
- Navigate to the desired site from the 'Sites' tab.
- Click on the "Utilities" tab.
- Click on the desired meter.
- Scroll down to the "Readings", click on the green "+ Add Meter Reading" button.
- Fill out the reading Dates, Usage, and Spend, then click "Save".
NOTE: When adding readings to an existing meter, make sure to enter data in the same units and currency.
STEPS TO BULK UPLOAD MANUAL METER DATA:
To add your manual meter data in bulk, you will be using our bulk upload template. You'll use the same file used to add sites in bulk. For your convenience, the file is attached in this guide at the bottom.
- Navigate to the "Sites" tab on the left-hand side.
- Click "Add bulk sites" (the green button with the + sign within a white circle at the top of the Sites table).
- Download the spreadsheet.
- Open the template, and read "Instructions" tab carefully - this helps ensure that your upload goes through successfully the first time. Here are some additional tips to follow:
- Be sure if you are adding readings to existing meters, that you are using the same name, units, and currency as it is in Measurabl.
- Meter names must be unique for each site.
- The dates must be in mm/dd/yy format for it to be processed correctly.
- Please use the exact property name as it appears in Measurabl. - Fill out the columns with green headers in the "Submission Form - Meters" tab and/or "Submission Form - Waste."
- If you're adding multiple readings for a meter, you'll simply repeat the site name, meter name, and meter type for each row of usage you'd like to add to that meter.
- Once finished, return to Measurabl, and click "add bulk sites."
- Upload the completed spreadsheet.
- Congrats, your bulk upload is complete! If there are any issues with your upload, you will be contacted by our support team. Otherwise, your meters & readings will be posted within 2 business days.
NOTE: The bulk meter template is only available in the app to portfolio managers and portfolio members, not site managers. If you're a site manager who needs access to the template, it is attached on this guide, as well as our bulk upload templates article - please send it to our support team once you have completed it.
ADDITIONAL INFORMATION & FAQs
- I have data error alerts in my meters, what do I do?
- If you are noticing any gaps, overlaps, or other error alerts, please check out this article on more information on how to identify and resolve the issue(s).
- If you don't have the data for your gaps, you can use our Estimations feature.
- I have an intermittent meter, so I have a lot of gaps that I need to fix, what do I do?
-
Intermittent meters are meters that have no usage and no meter readings for a period of time - this will cause a gap in your meter. This can be resolved by filling in the empty time with a 0-usage reading for every individual day that comprises the gap. However, a quicker solution is to fill out our 'Meters, Readings Bulk Upload Template'. You will want to input all of the gap periods in the spreadsheet, then send back to our support team to upload for you! You are also able to just leave the gaps as is since it is intermittent.
- Rather than manually filling the gaps, you can also use our Estimations tool.
-
- What if I'm trying to add readings to an existing meter, but the units are different?
- Each meter can only support one type of unit (if a meter has always read CCF, you must enter any new reading in CCF). To add new meter data under a new unit going forward, you can create a new meter, and specify the new units under the "Unit" dropdown menu.
- If you want to switch the meter, including its historical data, over to the new unit, you'll want to download the meter's historical data (via the Data Quality Report), convert its consumption over to the new unit, post a new meter with the new unit, push the converted historical consumption to the new meter, then delete the old meter. Reach out to our support team, if you need help with this.
- I accidentally entered the wrong data for a previous reading, how can I correct this?
- Go to the reading > Click the ellipses on desired reading > Edit/Delete the reading.
- Go to the reading > Click the ellipses on desired reading > Edit/Delete the reading.
- How do I know if my meter(s) is active or inactive?
- Click into the desired meter > Scroll to middle > Change 'Is this meter active?' toggle to yes/no.
- Measurabl allows you to track meter activation dates within Measurabl for all meter types and utility types. For more information, navigate to this guide.
Any other questions? Contact our support team.
- Click into the desired meter > Scroll to middle > Change 'Is this meter active?' toggle to yes/no.