This article describes the function, instructions, and header definitions of the 'Meters & Readings Template' in Measurabl.
FUNCTION:
- To create meters and add readings to those new meters in bulk on existing buildings. You cannot update existing meters or readings using this template.
Download the template HERE.
GENERAL INSTRUCTIONS:
- All headers that are green in the template are required fields to fill out. If it is blue, it is optional, and you can leave the cell blank. Note that some fields may be conditionally optional - meaning the field may be blue to start, but will turn green if it becomes required based on other information you add.
-
Make sure the building name matches exactly how it is in Measurabl.
- If there is a dropdown menu in any of the cells, please use one of the options from the menu.
- All dates should be in MM/DD/YYYY format.
- Only input 1 line of data per row.
- Please do not add additional columns, fields, or alter the template in any way.
- Bulk uploads can not be reversed once they are processed by our team, so it is important to quality check the data before submitting it.
Once you've completed the bulk upload, you can send it to support@measurabl.com for processing.
TIPS:
- If you are needing manual meter readings corrected, and are sending a bulk upload of the correct readings, please indicate this in your email. Bulk uploads are automatically assumed to be new data, and we can not overwrite existing readings with a bulk upload.
- We can not bulk upload data to Connect meters. If you need data to be added to a Connect meter, you will either need to upload the bills to the account or send us the missing bills, depending on the account type.
- Please do not combine readings for new and existing meters in the same template. We have two separate templates to use depending on if the readings are meant for meters that exist already or if you want new meters added. If you need to add data for both existing and new meters, separate the existing and new meter data into the appropriate templates.
-
For reading uploads to existing meters, make sure the currency of the readings is the same as what the existing meter was created in. Meter readings can only be added to an existing meter if they are in the same currency the meter was created in, otherwise a new meter will have to be created or the cost values converted.
- Remember to include the currency regardless if there’s a cost value or not. This is a required field to create a new meter or to add readings to a meter (even without cost).
- For new meters, each meter name needs to be unique at a property.
DEFINITIONS:
The column header values for this template are defined as (broken out by tabs):
-
Energy & Water Meters
- Building ID (Admin) - Leave blank. Measurabl will fill this column out.
- Building Source (Admin) - Leave blank. Measurabl will fill this column out.
- Building Name - Required. Enter the name exactly as it appears in Measurabl.
- Meter Name - Required. Enter the meter name or number.
- Meter Type - Required. Select an option from the drop-down menu.
- Start Date - Required. Date format should be in MM/DD/YYYY. Utility bill service period start date.
- End Date - Required. Date format should be in MM/DD/YYYY. Utility bill service period start date.
- Usage/Quantity - Required. The total consumption over the billing service period.
- Usage Units - Required. Units of the consumption are read in.
- Cost - Optional. The total cost amount over the billing service period.
- Currency - Required. Select an option from the drop-down menu. The currency that the cost value is in. Even if you do not enter a cost value, you must still fill out the currency of the meter.
- Demand (kW) - Optional.
- Demand Spend - Optional.
-
Energy Exported - Optional.
-
Waste Meters
- Building ID (Admin) - Leave blank. Measurabl will fill this column out.
- Building Source (Admin) - Leave blank. Measurabl will fill this column out.
- Building Name - Required. Enter the name exactly as it appears in Measurabl.
- Meter Name - Required. Enter the meter name or number.
- Meter Type - Required. Select an option from the drop-down menu.
- Start Date - Required. Date format should be in MM/DD/YYYY. Utility bill service period start date.
- End Date - Required. Date format should be in MM/DD/YYYY. Utility bill service period start date.
- Usage/Quantity - Required. The total consumption over the billing service period.
- Usage Units - Required. Units of the consumption are read in.
- Hazardous Waste - Required. Select an option from the drop-down menu.
- Cost - Optional. The total cost amount over the billing service period.
- Currency - Required. Select an option from the drop-down menu. The currency that the cost value is in. Even if you do not enter a cost value, you must still fill out the currency of the meter.
- Landfill Percentage - Conditionally optional. Only required if the meter type is 'disposal'. This is the percentage of the wastes' end life. The total between 'Landfill' 'Incineration' 'Waste to Energy' and 'Other' must equal 100%. If nothing is entered, 100% landfill will be assumed.
- Incineration Percentage - Conditionally optional. Only required if the meter type is 'disposal'. This is the percentage of the wastes' end life. The total between 'Landfill' 'Incineration' 'Waste to Energy' and 'Other' must equal 100%. If nothing is entered, 100% landfill will be assumed.
- Waste to Energy Percentage - Conditionally optional. Only required if the meter type is 'disposal'. This is the percentage of the wastes' end life. The total between 'Landfill' 'Incineration' 'Waste to Energy' and 'Other' must equal 100%. If nothing is entered, 100% landfill will be assumed.
-
Other Percentage - Conditionally optional. Only required if the meter type is 'disposal'. This is the percentage of the wastes' end life. The total between 'Landfill' 'Incineration' 'Waste to Energy' and 'Other' must equal 100%. If nothing is entered, 100% landfill will be assumed.