Versions Compared

Version Old Version 1 New Version Current
Changes made by

Former user

Anni Rahiala

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Consumption Measurement are subject to property buildings building or group and it is highly recommended that leases consumptions are imported in a separate sheet, where they are tied to a unit building or group by the corresponding ID. Certain headers are mandatory in order to import a leaseconsumption, but additional details can also be imported by optional headers.

Mandatory headers

Building
Column title DescriptionAllowed values
Entity IDSpecifies the property class in a portfolioStringAn entity ID of the corresponding entity type subject to the cunsumptionString
Entity TypeType of entityPROPERTY_BUILDING, PROPERTY_GROUP

Consumption type

Type of Consumption
  • electricity consumption,
  • heating consumption,
  • cooling consumption,
  • water consumption

Consumption value

Monthly consumption in kWhNumber

Measurement date

Starting date of the leaseDate*
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.