Building stock in Helsinki
| Moderator:Jouni (see all) |
|
|
| Upload data
|
Question
What is the building stock in Helsinki?
Answer
Rationale
Data
Building stock
The structures of the tables are based on CyPT Excel file N:\YMAL\Projects\ilmastotiekartta\Helsinki Data Input Template - Building Data.xlsx.
Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT.
Type of data:
- Average, City
- Example, city
- Average, city close by
- Example, city close by
- Average, national
- Example, country
Quality of data
- Statistics
- Extrapolated
- Calculated from statistics
- Calculated from stat. inc. assumptions
| Obs | Building | Baseline | 2020 | 2025 | 2050 | Year of baseline | Type of data | Quality | Description ref etc |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Residential buildings | ||||||||
| 2 | Government & public administration buildings | ||||||||
| 3 | Commercial offices buildings | ||||||||
| 4 | Data centers buildings | ||||||||
| 5 | Education, K12 and universitiy buildings | ||||||||
| 6 | Hospitals and healthcare buildings | ||||||||
| 7 | Hotels, hospitality and leisure buildings | ||||||||
| 8 | Exhibitions, fairs, halls buildings | ||||||||
| 9 | Retail, stores and shops buildings | ||||||||
| 10 | Warehouses & shopping mall buildings | ||||||||
| 11 | Industrial buildings | ||||||||
| 12 | Non residential buildings unspecified |
Absolute increase/decrease rate will be based on the inhabitants projected in time.
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
| Obs | Property | Residential | Non-residential | Public administration |
|---|---|---|---|---|
| 1 | Wall insulation | |||
| 2 | High efficient glazing | |||
| 3 | Efficient lighting in baseline | |||
| 4 | Demand oriented lighting | |||
| 5 | Building Efficiency Monitoring | |||
| 6 | Building Remote Monitoring | |||
| 7 | Building Performance Optimization | |||
| 8 | Demand controlled ventilation | |||
| 9 | Heat and Cold Recovery in ventilation | |||
| 10 | Efficient Motors | |||
| 11 | Building Automation BACS Class C | |||
| 12 | Building Automation BACS Class B | |||
| 13 | Building Automation BACS Class A | |||
| 14 | Room Automation HVAC | |||
| 15 | Room Automation HVAC + lighting | |||
| 16 | Building Automation HVAC + lighting + blinds |
Energy demand
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
| Obs | Energy type | Residential | Non-residential | Public administration |
|---|---|---|---|---|
| 1 | Electricity | |||
| 2 | Cooling | |||
| 3 | Heating |
Note! Heating includes warm water.
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
| Obs | Energy type | Use | Residential | Non-residential | Public administration |
|---|---|---|---|---|---|
| 1 | Electricity | Lighting /Lamp stock | |||
| 2 | Electricity | Appliances | |||
| 3 | Electricity | Ventilation | |||
| 4 | Electricity | Other | |||
| 5 | Cooling | Infiltration | |||
| 6 | Cooling | Ventilation | |||
| 7 | Cooling | Other (e.g. electric appliances, people) | |||
| 8 | Heating | Infiltration | |||
| 9 | Heating | Ventilation | |||
| 10 | Heating | Floors | |||
| 11 | Heating | Roofs | |||
| 12 | Heating | Other reasons | |||
| 13 | Heating | Warm water |
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
| Obs | Energy type | Use | Residential | Non-residential | Public administration | Auxiliaries |
|---|---|---|---|---|---|---|
| 1 | Cooling | Infiltration | PPT | |||
| 2 | Cooling | Ventilation | PPT | |||
| 3 | Cooling | Losses through walls through transmission | PPT | |||
| 4 | Cooling | Heat input by solar radiation through windows | PPT | |||
| 5 | Cooling | Losses through windows through transmission | PPT | |||
| 6 | Cooling | Other effects (e.g. people, electrical Appliances) | PPT | |||
| 7 | Heating | Infiltration | PPT | |||
| 8 | Heating | Ventilation | PPT | |||
| 9 | Heating | Walls | PPT | |||
| 10 | Heating | Windows | PPT | |||
| 11 | Heating | Floors | PPT | |||
| 12 | Heating | Roofs | PPT | |||
| 13 | Heating | Other | PPT | |||
| 14 | Heating | Warm water | Excel | |||
| 15 | Electricity | Lighting | Excel | |||
| 16 | Electricity | Appliances | Excel | |||
| 17 | Electricity | Ventilation | Excel | |||
| 18 | Electricity | Other | Excel |
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
| Obs | Parameter | Unit | Residential | Non-residential | Public administration | Auxiliary |
|---|---|---|---|---|---|---|
| 1 | Ratio of wall area / effective area | - | PPT | |||
| 2 | Ratio of window/effective area | - | PPT | |||
| 3 | U-value of windows | W /m2 /K | PPT | |||
| 4 | Solar heat gain coefficient "G-Value" of windows | % | PPT | |||
| 5 | Efficiency increase of G-value of windows | % /a | Excel | |||
| 6 | Efficiency increase of U-value of windows | % /a | Excel | |||
| 7 | U-value of building walls | W /m2 /K | PPT |
Lighting
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
| Obs | Lamp | Residential | Non-residential | Public administration |
|---|---|---|---|---|
| 1 | Incandescent lamps | |||
| 2 | Compact fluorescent lamps | |||
| 3 | Fluorescent lamps | |||
| 4 | Low voltage halogen lamps | |||
| 5 | Medium voltage halogen lamps |
| Obs | Lamp | Residential | Non-residential | Public administration |
|---|---|---|---|---|
| 1 | Incandescent lamps | |||
| 2 | Compact fluorescent lamps | |||
| 3 | Fluorescent lamps | |||
| 4 | Low voltage halogen lamps | |||
| 5 | Medium voltage halogen lamps |
Other
Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Nice to have specific factor otherwise we adapt standard data or other studies.
| Data | Result |
|---|---|
| Number of households | |
| Number of persons per household |
Calculations
Summary graphs on sheet Parameter Balance are made with these formulas. The rows 7-12 in the table are for
- General
- Power
- Transport
- Buildings (Area): sheet 4_Input Buildings (Area Demand)
- Buildings (Residential): sheet 5_Input Residential
- Buildings (Non-Residential): sheet 6.0_Input Non Residential
- MISSING SHEET FROM SUMMARIES: 6.2_Input Public Admin
The columns in the building type sheets:
- F: Priority [1, 2, 3]
- G: Auxiliaries [Excel, PPT]
- H: Empty
| Cell | Priority | Source of data | Formula | Explanation | |
|---|---|---|---|---|---|
| B12 | TOTALS | all (non-optional) parameters | =SUM(C12:E12) | Number of parametres | |
| C12 | Prio 1 | =COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,1) | Number of parametres with high priority | ||
| D12 | Prio 2 | =COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,2) | Number of parametres with medium priority | ||
| E12 | Prio 3 | =COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,3) | Number of parametres with low priority | ||
| F12 | DONES | Prio 1 | derived/informed | =SUMPRODUCT(($'6.0_Input Non Residential'.$G$31:$G$115="PPT")*($'6.0_Input Non Residential'.$F$31:$F$115=1)*($'6.0_Input Non Residential'.$H$31:$H$115="")) | Number of parametres with highest priority and auxiliary PPT |
| G12 | all pre-fill parameters | =SUMPRODUCT(($'6.0_Input Non Residential'.$G$31:$G$115="Excel")*($'6.0_Input Non Residential'.$F$31:$F$115=1)*($'6.0_Input Non Residential'.$H$31:$H$115="")) | Number of parametres with high priority and auxiliary Excel | ||
| H12 | Prio 2 | derived/informed | =SUMPRODUCT(($'6.0_Input Non Residential'.$G$31:$G$115="PPT")*($'6.0_Input Non Residential'.$F$31:$F$115=2)*($'6.0_Input Non Residential'.$H$31:$H$115="")) | Number of parametres with medium priority and auxiliary PPT | |
| I12 | all pre-fill parameters | =SUMPRODUCT(($'6.0_Input Non Residential'.$G$31:$G$115="Excel")*($'6.0_Input Non Residential'.$F$31:$F$115=2)*($'6.0_Input Non Residential'.$H$31:$H$115="")) | Number of parametres with medium priority and auxiliary Excel | ||
| J12 | Prio 3 | derived/informed | =SUMPRODUCT(($'6.0_Input Non Residential'.$G$31:$G$115="PPT")*($'6.0_Input Non Residential'.$F$31:$F$115=3)*($'6.0_Input Non Residential'.$H$31:$H$115="")) | Number of parametres with low priority and auxiliary PPT | |
| K12 | all pre-fill parameters | =SUMPRODUCT(($'6.0_Input Non Residential'.$G$31:$G$115="Excel")*($'6.0_Input Non Residential'.$F$31:$F$115=3)*($'6.0_Input Non Residential'.$H$31:$H$115="")) | Number of parametres with low priority and auxiliary Excel | ||
| L12 | Sum of derived/informed | =J12+H12+F12 | Number of parametres with auxiliary PPT | ||
| M12 | Sum of pre-fill | =K12+I12+G12 | Number of parametres with auxiliary Excel | ||
| N12 | Sum of Dones | =SUM(F12:K12) | Number of parametres |