Building stock in Helsinki: Difference between revisions

Revision as of 10:15, 8 April 2015

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?

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.

Table 1. Effective floor area of buildings by building type.

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

Effective floor area of buildings(m2)
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

Notes: Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Absolute increase/decrease rate will be based on the inhabitants projected in time.

Table 2. Existing situation of important energy parametres in the 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

Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.

Energy demand

Table 3. Total energy demand by energy type and building type.

Total energy demand by type(kWh /m2 /a)
Obs	Energy type	Residential	Non-residential	Public administration
1	Electricity
2	Cooling
3	Heating

Notes: Heating includes warm water. Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.

Table 4. Shares of different energy sinks by building type.

Share of energy demand by use type(%)
Obs	Energy type	Use	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

Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries: see table.

Table 5. Changes in energy efficiency of different energy sinks.

Efficiency increase decreasing energy demand(% /a)
Obs	Energy type	Use
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

Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.

Table 6. Important energy parameters.

Energy parameters(-)
Obs	Parameter	Unit	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

Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.

Lighting

Tables 7-8. Run times and shares of lamps by lamp type and building type.

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

Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.

Other

Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Nice to have specific factor otherwise we adapt standard data or other studies.

*Possibly important information*
Data	Result
Number of households
Number of persons per household

Calculations

References

Related files

@@ Line 19: / Line 19: @@
 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.
+'''Table 1. Effective floor area of buildings by building type.
 Type of data:
@@ Line 49: / Line 49: @@
 </t2b>
-Absolute increase/decrease rate will be based on the inhabitants projected in time.
+;Notes: Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Absolute increase/decrease rate will be based on the inhabitants projected in time.
+'''Table 2. Existing situation of important energy parametres in the building stock.
-Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
 <t2b name="Existing situation of total stock" index="Property,Building type" locations="Residential,Non-residential,Public administration" unit="%">
@@ Line 72: / Line 71: @@
 Building Automation HVAC + lighting + blinds|||
 </t2b>
+;Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
 ==== Energy demand ====
-Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
+'''Table 3. Total energy demand by energy type and building type.
 <t2b name="Total energy demand by type" index="Energy type,Building type" locations="Residential,Non-residential,Public administration" unit="kWh /m2 /a">
@@ Line 83: / Line 84: @@
 </t2b>
-Note! Heating includes warm water.
+;Notes: Heating includes warm water. Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
-Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
-<t2b name="Efficiency increase decreasing energy demand" index="Energy type,Use,Building type" locations="Residential,Non-residential,Public administration" unit="% /a">
-Electricity|Lighting /Lamp stock|||
-Electricity|Appliances|||
-Electricity|Ventilation|||
-Electricity|Other|||
-Cooling|Infiltration|||
-Cooling|Ventilation|||
-Cooling|Other (e.g. electric appliances, people)|||
-Heating|Infiltration|||
-Heating|Ventilation|||
-Heating|Floors|||
-Heating|Roofs|||
-Heating|Other reasons|||
-Heating|Warm water|||
-</t2b>
-Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
+'''Table 4. Shares of different energy sinks by building type.
 <t2b name="Share of energy demand by use type" index="Energy type,Use,Buiding type" locations="Residential,Non-residential,Public administration" unit="%" desc="Auxiliaries">
@@ Line 128: / Line 109: @@
 </t2b>
-Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
+;Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries: see table.
+'''Table 5. Changes in energy efficiency of different energy sinks.
+<t2b name="Efficiency increase decreasing energy demand" index="Energy type,Use,Building type" locations="Residential,Non-residential,Public administration" unit="% /a">
+Electricity|Lighting /Lamp stock|||
+Electricity|Appliances|||
+Electricity|Ventilation|||
+Electricity|Other|||
+Cooling|Infiltration|||
+Cooling|Ventilation|||
+Cooling|Other (e.g. electric appliances, people)|||
+Heating|Infiltration|||
+Heating|Ventilation|||
+Heating|Floors|||
+Heating|Roofs|||
+Heating|Other reasons|||
+Heating|Warm water|||
+</t2b>
+;Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
+'''Table 6. Important energy parameters.
 <t2b name="Energy parameters" index="Parameter,Unit,Building type" locations="Residential,Non-residential,Public administration" unit="-" desc="Auxiliary">
@@ Line 139: / Line 143: @@
 U-value of building walls|W /m2 /K||||PPT
 </t2b>
+;Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
 ==== Lighting ====
-Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
+'''Tables 7-8. Run times and shares of lamps by lamp type and building type.
 <t2b name="Average run time of lamps per year" index="Lamp,Building type" locations="Residential,Non-residential,Public administration" unit="h /a">
@@ Line 159: / Line 165: @@
 Medium voltage halogen lamps|||
 </t2b>
+;Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
 ==== Other ====
@@ Line 175: / Line 183: @@
 === Calculations ===
-Summary graphs on sheet ''Parameter Balance'' are made with these formulas. The rows 7-12 in the table are for
+== See also ==
-* 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
-{| {{prettytable}}
-! Cell !! !! Priority !! Source of data !! Formula !! Explanation
-|----
-|| B12
-|rowspan="4"| 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
-|rowspan="6"| DONES
-|rowspan="2"| 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
-|rowspan="2"| 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
-|rowspan="2"| 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
-|----
-|}
-== See also ==
+* [http://en.opasnet.org/en-opwiki/index.php?title=Building_stock_in_Helsinki&oldid=35248#Calculations Descriptions about the summary calculations on sheet Parameter Balance] (not needed any more).
 == References ==
 == Related files ==