Skenarios support
Import renovations
Peter Sundell
Ugur Argun
Jukka Viikari
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 | Description | Allowed values |
|---|---|---|
| Part | The subject of a renovation | automation 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 |
| Renovation | The 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 |
| Year | The year a renovation takes place | Integer |
* 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 | Description | Allowed values |
|---|---|---|
Description | Free text field for the description of the renovation. | Any string |
Cost | The cost of a renovation | Integer |
Investment type | The type of the investment | Capital, Maintenance |
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 | Description | Allowed values |
|---|---|---|
| Unit ID | The ID of a unit subject to a renovation | String |
| Unit Part | The subject of a renovation | Bathroom, Kitchen, Unit heating system,Unit door,Unit balcony,Unit window,Unit electrics, Interior surfaces, Other |
| Unit Renovation Year | The year a renovation takes place | Integer |
* 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 | Description | Allowed values |
|---|---|---|
| Unit Renovation Description | Free text field for the description of the renovation. | Any string |
| Unit Renovation Cost | The cost of a renovation | Integer |
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