Skenarios support

Import renovations

Renovations can be subject to property units and buildings. It is highly recommended that unit and building renovations are imported in separate sheets, where they are tied to a building or a unit by corresponding building or unit ID's. 

Import building renovations

Certain headers are mandatory in order to import a renovation, but additional details can also be imported by optional headers.

Mandatory headers

In addition to sufficient information to link a renovation to a building (see Overview), importing a renovation requires also the following mandatory fields.

Column title DescriptionAllowed values
PartThe subject of a renovationautomation system, balcony, base floor, cooling system,  electric installations, external wall, facade, fire protection system, heat distribution, heating system, interior, lift, other, roof, sitework, substructure, superstructure, ventilation, water & sanitation, window
RenovationThe type of a renovation*Part change, Miscellaneous repair, Part renovation related planning, Mortar joint repair, Facade painting, Window fences and frames painting, Window sealing, Roof painting
YearThe year a renovation takes placeInteger

* Attempting to import a renovation with an incompatible part will not raise an error, but the renovation is changed to Miscellaneous repair. Furthermore, importing a renovation for a non-existing part will not raise an error, but the renovation is changed to Part change (thus creating the part).

When importing renovations, certain limitations apply:

  • Renovations can be specific to a part and/or country
  • Renovating a part which is already at its best condition, will not import the renovation.


Part

Renovation name

Country

All



Miscellaneous repair

All


Part change
Part renovation related planning

base floor

Improve floor insulation

BE,NL

Improve floor insulation (Part L, U=0,25)

UK

superstructure

Superstructure condition survey

FI

roof

Add loft insulation

FI,ME,SI

Improve flat roof insulation (Part L, U=0,18)

UK

Improve loft insulation (Part L, U=0,16)

UK

Improve loft insulation (U=0,13)

UK

Improve roof insulation

BE,FI,NL

Improve roof insulation (U=0,13)

UK

Renew bitumen felt roofing

BE,FI,NL

Renew metal roofing

FI

Renew tile roofing

BE,FI,NL

Roof condition survey

FI

Roof painting

FI

external wall






Add wall cavity insulation

UK

Improve solid wall insulation (U=0,16)

UK

Improve wall insulation

BE,FI,NL

Improve wall insulation (Part L, U=0,3)

UK

Improve wall insulation (Part L, U=0,55)

UK

Improve wall insulation (U=0,16)

ME,SI,UK

window

Add additional glazing

ME,SI,UK

External solar control devices (brie solei, light shelves, etc)

UK

Internal solar control devices (blinds)

UK

Replace windows (U=0,72)

UK

Replace windows (U=1,4)

UK

Window condition survey

FI

Window fences and frames painting

FI,PL,PT,SE,UK

Window sealing

FI,PL,PT,SE,UK

facade

Facade painting

CA,DE,FI

Improve air tightness

FI,UK

Mortar joint repair

DE,FI,PT

water & sanitation

Low flow sanitary appliances installation

UK

Pipe imaging

FI

Renew fresh water plumbing parts

FI

Renew plumbing fixtures

FI

electric installations

Distribution boards renewal

FI,UK

Final circuits renewal

FI

Incorporate VSDs to HVAC motors

UK

Institutional kitchen equipment renewal

FI

Lighting distribution circuits renewal

FI

Lighting fixtures renewal

FI,UK

Main distribution board renewal

FI

Main supply cable renewal

FI

Power factor correction and VSDs to HVAC

UK

Riser cables renewal

FI

Upgrade to LED lighting and improve lighting controls

FI,UK

Variable-frequency drives renewal

FI

ventilation

Recommission ventilation units

UK

Repair ductwork leakage

UK

Replace ventilation units

UK

Ventilation ducts sweeping; airflow measurement and adjustment

FI,UK

Ventilation machine unit renewal

BE,CA,DE,FI,NL,UK

sitework

Renew playground equipment

FI

Resurface paved traffic areas

FI

interior

Exposing of internal thermal mass (false ceiling removal)

UK

Internal spatial layouts

UK

Renew interior fixtures

FI

Renew interior surfaces

FI

Tilapintojen ja -osien uusiminen

FI

heating system

Heat exchanger renewal

PT

Recommission gas boiler

UK

Replace boiler

UK

Switch to air source heat pump

UK

Switch to ground-source heat pump

UK

heat distribution

Radiator network balancing and thermostat renewals

FI,PT

Radiator network shutter and control valve renewal

FI,PT

Renew heat radiators

FI

automation system

BMS check and temperature set point calibration

UK

BMS check, temp set point calibration, consumption monitoring, user training

UK

BMS check, utility and specific energy metering

UK

BMS check, utility and specific energy metering, temp set point calibration, consumption monitoring, user training

FI,UK

Optional headers

Column title DescriptionAllowed values
DescriptionFree text field for the description of the renovation.Any string
CostThe cost of a renovationInteger

Import unit renovations

Certain headers are mandatory in order to import a renovation, but additional details can also be imported by optional headers. A unit renovation is updated if a unit renovation is already found in the database, where the unit ID, part, and renovation year are equivalent.

Mandatory headers

Column title DescriptionAllowed values
Unit IDThe ID of a unit subject to a renovationString
Unit PartThe subject of a renovation

Bathroom, Kitchen, Unit heating system,Unit door,Unit balcony,Unit window,Unit electrics, Interior surfaces, Other

Unit Renovation YearThe year a renovation takes placeInteger

* Attempting to import a renovation with an incompatible part will raise an error and the renovation will not be saved to the database.

Optional headers

Column title DescriptionAllowed values
Unit Renovation DescriptionFree text field for the description of the renovation.Any string
Unit Renovation CostThe cost of a renovationInteger

Portfolio id

The id of the portfolio where the building should be imported.

If the portfolio id is set Organization key header became mandatory otherwise row will be skipped.

The portfolio id should exist within the organization used as organization key and user should be a part of the organization too otherwise row will be skipped.

Integer

Organization key

The key of the organization where the building should be imported.

If the Organization key is set Portfolio id header became mandatory otherwise row will be skipped.

The Organization key should exist as parent/child organization and user should be a part of the organization too otherwise row will be skipped.

Text


SkenarioLabs