Export property data in an Excel file

You can export an Excel document on Skenarios service's Export-page. The exported Excel contains two sheets, one for buildings and one for units. Please, note that all the information uploaded into the Skenarios' service by Excel Import may not be included in the exported Excel*, hence we recommend you to save your original Excel file to prevent possible loss of information.



How to

Go to the Export&Import view.

Choose a portfolio to be exported; portfolio 'Helsinki' is chosen in the adjacent figure.

Click 'Create Export', the export process will start. For small portfolios, the download link will appear almost immediately and you can download the export file.

For large portfolios, the processing will take a while and the link will appear once the export is done. You will get a notification if this is the case. You can see the completed export file when you refresh the page.

Renovations

An exported Excel represents building level renovations for the next decade in great detail. Each year has its own column for yearly total renovation costs, and the following column presents the details of the total costs. The details column manifests the renovated building parts and their costs. The exported Excel contains also a column for the total renovation costs in a decade per a building floor area.

Building details sheet

Column titleDescription
Building IDIdentifies a building uniquely in a portfolio
Building NameName of the building
Group idIdentifies a group uniquely in a portfolio
Group nameName of the property group
Building prototypeType of the property
Usage purposeUsage code of the building. 11 stands for residential.
AddressThe street address of a building.
FloorsThe number of floors in a building.
Build YearThe construction year of a building.
Floor AreaThe gross floor area of a building in square meters.
Facade AreaThe gross facade area of a building in square meters.
HeatingThe heating source of a building.
ElectricityThe electricity source of a building.

Electricity Demand (kWh/m2/a)

Electricity consumption of the property.

Heating Demand (kWh/m2/a)

Heating consumption of the property.

Cooling Demand (kWh/m2/a)

The cooling demand of the property.

Solar Potential (kWh/a)

Potential solar energy production of a building, if the building rooftop is equipped with solar panels.

<year> renovations

Yearly renovation costs of a building given in local currency. Contains both Assumed and Planned renovations.

<year> renovation details

Details of yearly renovation costs. Renovated parts and their costs in a given year are listed. Contains both Assumed and Planned renovations.
Decade total costsTotal costs of 10 years renovations

Decade costs per floor area 

Total renovation costs of the upcoming decade of a building given in local currency. Contains both Assumed and Planned renovations.

Unit details sheet

If the portfolio has any units, the second sheet has details of them.

ColumnDescription
Unit IDIdentifies the unit uniquely in a portfolio
Building IDIdentifies the building uniquely in a portfolio
Group IDIdentifies the group uniquely in a portfolio
Unit NameName of the unit
DescriptionDescription of the unit
AddressAddress of the unit
Estimated unit valueThe latest estimated value of the unit
Floor areaFloor area of the unit
FloorFloor number of the unit
Bathroom renovation & CostYear and cost of the next coming renovation
Kitchen renovation & CostYear and cost of the next coming renovation
Heating system renovation & CostYear and cost of the next coming renovation
MaintenanceList of last 5 years maintenances done to this unit
Total costTotal cost of the previous maintenances 
Maintenance descriptionDescriptions of the previous maintenance works


*One example of such information is past renovations.