Building stock in Helsinki

This page is a knowledge crystal of subtype variable. The page identifier is Op_en7115
Moderator:Jouni (see all)
Upload data {{#opasnet_base_link:Op_en7115}}

Question

What is the building stock in Helsinki?

Rationale

Data

Building stock

Existing situation of total stock(%)

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

Absolute increase/decrease rate will be based on the inhabitants projected in time.

Effective floor area of buildings(m2)

Obs	Building	Baseline	2020	2025	2050	Year of baseline	Type of data	Quality	Description ref etc
1	Effective Building Area in City
2	Residential buildings
3	Government & public administration buildings
4	Commercial offices buildings
5	Data centers buildings
6	Education, K12 and universitiy buildings
7	Hospitals and healthcare buildings
8	Hotels, hospitality and leisure buildings
9	Exhibitions, fairs, halls buildings
10	Retail, stores and shops buildings
11	Warehouses & shopping mall buildings
12	Industrial buildings
13	Non residential buildings unspecified

Energy demand

Total energy demand by type(kWh /m2 /a)

Obs	Energy type	Residential	Non-residential	Public administration
1	Electricity
2	Cooling
3	Heating

Note! Heating includes warm water.

Efficiency increase decreasing energy demand(% /a)

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

Share of energy demand by use type(%)

Obs	Energy type	Use	Residential	Non-residential	Public administration
1	Cooling	Infiltration
2	Cooling	Ventilation
3	Cooling	Losses through walls through transmission
4	Cooling	Heat input by solar radiation through windows
5	Cooling	Losses through windows through transmission
6	Cooling	Other effects (e.g. people, electrical Appliances)
7	Heating	Infiltration
8	Heating	Ventilation
9	Heating	Walls
10	Heating	Windows
11	Heating	Floors
12	Heating	Roofs
13	Heating	Other
14	Heating	Warm water
15	Electricity	Lighting
16	Electricity	Appliances
17	Electricity	Ventilation
18	Electricity	Other

Energy parameters(-)

Obs	Parameter	Unit	Residential	Non-residential	Public administration
1	Ratio of wall area / effective area	-
2	Ratio of window/effective area	-
3	U-value of windows	W /m2 /K
4	Solar heat gain coefficient "G-Value" of windows	%
5	Efficiency increase of G-value of windows	% /a
6	Efficiency increase of U-value of windows	% /a
7	U-value of building walls	W /m2 /K

Lighting

Average run time of lamps per year(h /a)

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

Shares of lamp types(%)

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

Possibly important information

Data	Result
Number of households
Number of persons per household

Calculations

Summary graphs are made with these formulas. The rows 7-12 in the table are for

• General
• Power
• Transport
• Buildings (Area)
• Buildings (Residential)
• Buildings (Non-Residential)

The columns in the building type sheets:

• F: Priority [1, 2, 3]
• G: Auxiliaries [Excel, PPT]
• H: Empty

Cell		Priority		Formula
B12	TOTALS	all (non-optional) parameters		=SUM(C12:E12)
C12		Prio 1		=COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,1)
D12		Prio 2		=COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,2)
E12		Prio 3		=COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,3)
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=""))
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=""))
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=""))
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=""))
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=""))
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=""))
L12			Sum of derived/informed	=J12+H12+F12
M12			Sum of pre-fill	=K12+I12+G12
N12			Sum of Dones	=SUM(F12:K12)