This article describes the function, instructions, and header definitions of the bulk upload 'Readings Template' in Measurabl.
FUNCTION:
- To add readings to existing manual meters in bulk. You cannot update existing 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.
- Make sure the meter 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.
- 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).
DEFINITIONS:
The column header values for this template are defined as (broken out by tabs):
- Energy & Water Meters
- Meter ID - Required. Enter the meter ID as found from the 'Sites > Meters' tab under 'Unique Meter ID'.
- Meter Name - Required. Enter the name exactly as it appears in Measurabl.
- Site Source (Admin) - Leave blank. Measurabl will fill this column out.
- 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. The unit must match the same unit as the existing meter you want to add the reading to.
- 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
- Meter ID - Required. Enter the meter ID as found from the 'Sites > Meters' tab under 'Unique Meter ID'.
- Meter Name - Required. Enter the name exactly as it appears in Measurabl.
- Site Source (Admin) - Leave blank. Measurabl will fill this column out.
- 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. The unit must match the same unit as the existing meter you want to add the reading to.
- 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.