Consumption Measurement are subject to property building or group and it is highly recommended that consumptions are imported in a separate sheet, where they are tied to a building or group by the corresponding ID. Certain headers are mandatory in order to import a consumption, but additional details can also be imported by optional headers.
Mandatory headers
| Column title | Description | Allowed values |
|---|
| Entity ID | An entity ID of the corresponding entity type subject to the cunsumption | String |
| Entity Type | Type of entity | PROPERTY_BUILDING, PROPERTY_GROUP |
Consumption type | Type of Consumption | - electricity consumption,
- heating consumption,
- cooling consumption,
- water consumption
|
Consumption value | Monthly consumption in kWh | Number |
Measurement date | Starting date of the lease | Date*
Format: 2019-12-24 |
* Attempting to import date values if alignment is left it will cause fail. Edit date formatting such that alignment is on the right side.