This article describes the function, instructions, and header definitions of the 'Sites, Meters & Readings Template' in Measurabl.
FUNCTION:
- To create new manual sites, meters and readings. Cannot update existing sites, meters, or readings.
- New sites uploaded with this template are considered 'manual' properties, and are not connected with EnergyStar. Please let us know if the new sites to be synced with EnergyStar.
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.
DEFINITIONS:
The column header values for this template are defined as (broken out by tabs):
- Submission Form - Buildings
- Building Name - Required. Enter the name exactly how you want it to appear in Measurabl.
- Street Address - Required.
- Street Address 2 - Optional.
- City/Municipality - Required.
- State/Province - Required.
- Postal Code - Required.
- Country - Required. Select option from drop-down list.
- Primary Type - Required. Select option from drop-down list.
- Gross Floor Area (GFA) - Required.
- GFA Units - Required. Select option (Sq. Ft. or Sq. M.) from the drop-down list.
- Year Built - Optional.
- Custom ID - Optional.
- Control Type - Optional. Choose between owned or leased
- Start Date - Optional. Date format should be in MM/DD/YYYY. Bought date of the property.
- End Date - Optional. Date format should be in MM/DD/YYYY. Sold date of the property.
- Submission Form - Meters (Energy & Water)
- 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. Please ensure this value matches the currency selected in the Currency column.
- Energy Exported - Optional. This is separate from ‘Usage’ and should include the total renewable electric data exported. Usage should only include the amount consumed. This column's entry should match the ‘Usage Unit’.
- Submission Form - Waste Meters
- 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.
Feel free to submit a request or email us directly if you have any questions!