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 title	Description
Building ID	Identifies a building uniquely in a portfolio
Building Name	Name of the building
Group id	Identifies a group uniquely in a portfolio
Group name	Name of the property group
Building prototype	Type of the property
Usage purpose	Usage code of the building. 11 stands for residential.
Address	The street address of a building.
Floors	The number of floors in a building.
Build Year	The construction year of a building.
Floor Area	The gross floor area of a building in square meters.
Facade Area	The gross facade area of a building in square meters.
Heating	The heating source of a building.
Electricity	The 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 costs	Total 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.

Column	Description
Unit ID	Identifies the unit uniquely in a portfolio
Building ID	Identifies the building uniquely in a portfolio
Group ID	Identifies the group uniquely in a portfolio
Unit Name	Name of the unit
Description	Description of the unit
Address	Address of the unit
Estimated unit value	The latest estimated value of the unit
Floor area	Floor area of the unit
Floor	Floor number of the unit
Bathroom renovation & Cost	Year and cost of the next coming renovation
Kitchen renovation & Cost	Year and cost of the next coming renovation
Heating system renovation & Cost	Year and cost of the next coming renovation
Maintenance	List of last 5 years maintenances done to this unit
Total cost	Total cost of the previous maintenances
Maintenance description	Descriptions of the previous maintenance works

*One example of such information is past renovations.