This article describes the function, instructions, and header definitions of the '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.
Once you've completed the bulk upload, you can send it to support@measurabl.com for processing.
DEFINITIONS:
The column header values for this template are defined as (broken out by tabs):
- Energy & Water Meters
- Building Name - Required. Enter the name exactly as it appears in Measurabl.
- Meter Name - Required. Enter the name exactly as it appears in Measurabl.
- Meter Category - Required. Select an option from the drop-down menu. Must match the existing meter you are wanting to add readings to.
- Meter 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
- Building Name - Required. Enter the name exactly as it appears in Measurabl.
- Meter Name - Required. Enter the name exactly as it appears in Measurabl.
- Meter Category - Required. Select an option from the drop-down menu. Must match the existing meter you are wanting to add readings to.
- Meter 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.