Building stock in Helsinki: Difference between revisions

From Opasnet
Jump to navigation Jump to search
(→‎Rationale: priorities and auxiliaries added)
Line 16: Line 16:


==== Building stock ====
==== 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.
<t2b name="Effective floor area of buildings" index="Building,Year" locations="Baseline,2020,2025,2050" unit="m2" desc="Year of baseline,Type of data,Quality,Description ref etc">
Residential buildings||||||||
Government & public administration buildings||||||||
Commercial offices buildings||||||||
Data centers buildings||||||||
Education, K12 and universitiy buildings||||||||
Hospitals and healthcare buildings||||||||
Hotels, hospitality and leisure buildings||||||||
Exhibitions, fairs, halls buildings||||||||
Retail, stores and shops buildings||||||||
Warehouses & shopping mall buildings||||||||
Industrial buildings||||||||
Non residential buildings unspecified||||||||
</t2b>
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.


<t2b name="Existing situation of total stock" index="Property,Building type" locations="Residential,Non-residential,Public administration" unit="%">
<t2b name="Existing situation of total stock" index="Property,Building type" locations="Residential,Non-residential,Public administration" unit="%">
Line 36: Line 60:
</t2b>
</t2b>


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


 
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
<t2b name="Effective floor area of buildings" index="Building,Year" locations="Baseline,2020,2025,2050" unit="m2" desc="Year of baseline,Type of data,Quality,Description ref etc">
Effective Building Area in City||||||||
Residential buildings||||||||
Government & public administration buildings||||||||
Commercial offices buildings||||||||
Data centers buildings||||||||
Education, K12 and universitiy buildings||||||||
Hospitals and healthcare buildings||||||||
Hotels, hospitality and leisure buildings||||||||
Exhibitions, fairs, halls buildings||||||||
Retail, stores and shops buildings||||||||
Warehouses & shopping mall buildings||||||||
Industrial buildings||||||||
Non residential buildings unspecified||||||||
</t2b>
 
==== Energy demand ====


<t2b name="Total energy demand by type" index="Energy type,Building type" locations="Residential,Non-residential,Public administration" unit="kWh /m2 /a">
<t2b name="Total energy demand by type" index="Energy type,Building type" locations="Residential,Non-residential,Public administration" unit="kWh /m2 /a">
Line 64: Line 71:


Note! Heating includes warm water.
Note! Heating includes warm water.
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">
<t2b name="Efficiency increase decreasing energy demand" index="Energy type,Use,Building type" locations="Residential,Non-residential,Public administration" unit="% /a">
Line 82: Line 92:




<t2b name="Share of energy demand by use type" index="Energy type,Use,Buiding type" locations="Residential,Non-residential,Public administration" unit="%">
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
Cooling|Infiltration|||
 
Cooling|Ventilation|||
<t2b name="Share of energy demand by use type" index="Energy type,Use,Buiding type" locations="Residential,Non-residential,Public administration" unit="%" desc="Auxiliaries">
Cooling|Losses through walls through transmission|||
Cooling|Infiltration||||PPT
Cooling|Heat input by solar radiation through windows|||
Cooling|Ventilation||||PPT
Cooling|Losses through windows through transmission|||
Cooling|Losses through walls through transmission||||PPT
Cooling|Other effects (e.g. people, electrical Appliances)|||
Cooling|Heat input by solar radiation through windows||||PPT
Heating|Infiltration|||
Cooling|Losses through windows through transmission||||PPT
Heating|Ventilation|||
Cooling|Other effects (e.g. people, electrical Appliances)||||PPT
Heating|Walls|||
Heating|Infiltration||||PPT
Heating|Windows|||
Heating|Ventilation||||PPT
Heating|Floors|||
Heating|Walls||||PPT
Heating|Roofs|||
Heating|Windows||||PPT
Heating|Other|||
Heating|Floors||||PPT
Heating|Warm water|||
Heating|Roofs||||PPT
Electricity|Lighting|||
Heating|Other||||PPT
Electricity|Appliances|||
Heating|Warm water||||Excel
Electricity|Ventilation|||
Electricity|Lighting||||Excel
Electricity|Other|||
Electricity|Appliances||||Excel
Electricity|Ventilation||||Excel
Electricity|Other||||Excel
</t2b>
</t2b>


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


<t2b name="Energy parameters" index="Parameter,Unit,Building type" locations="Residential,Non-residential,Public administration" unit="-">
<t2b name="Energy parameters" index="Parameter,Unit,Building type" locations="Residential,Non-residential,Public administration" unit="-" desc="Auxiliary">
Ratio of wall area / effective area|-|||
Ratio of wall area / effective area|-||||PPT
Ratio of window/effective area|-|||
Ratio of window/effective area|-||||PPT
U-value of windows|W /m2 /K|||
U-value of windows|W /m2 /K||||PPT
Solar heat gain coefficient "G-Value" of windows|%|||
Solar heat gain coefficient "G-Value" of windows|%||||PPT
Efficiency increase of G-value of windows|% /a|||
Efficiency increase of G-value of windows|% /a||||Excel
Efficiency increase of U-value of windows|% /a|||
Efficiency increase of U-value of windows|% /a||||Excel
U-value of building walls|W /m2 /K|||
U-value of building walls|W /m2 /K||||PPT
</t2b>
</t2b>


==== Lighting ====
==== Lighting ====
Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.


<t2b name="Average run time of lamps per year" index="Lamp,Building type" locations="Residential,Non-residential,Public administration" unit="h /a">
<t2b name="Average run time of lamps per year" index="Lamp,Building type" locations="Residential,Non-residential,Public administration" unit="h /a">
Line 133: Line 148:


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


{| {{prettytable}}
{| {{prettytable}}
Line 145: Line 162:
=== Calculations ===
=== Calculations ===


Summary graphs are made with these formulas. The rows 7-12 in the table are for
Summary graphs on sheet ''Parameter Balance'' are made with these formulas. The rows 7-12 in the table are for
* General
* General
* Power
* Power
* Transport
* Transport
* Buildings (Area)
* Buildings (Area): sheet 4_Input Buildings (Area Demand)
* Buildings (Residential)
* Buildings (Residential): sheet 5_Input Residential
* Buildings (Non-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:
The columns in the building type sheets:
Line 160: Line 178:


{| {{prettytable}}
{| {{prettytable}}
! Cell !! !! Priority !! !! Formula
! Cell !! !! Priority !! Source of data !! Formula !! Explanation
|----
|----
|| B12
|| B12
|rowspan="4"| TOTALS|| all (non-optional) parameters|| ||=SUM(C12:E12)
|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)
|| 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)
|| 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)
|| E12|| Prio 3 || ||=COUNTIF($'6.0_Input Non Residential'.$F$31:$F$115,3)|| Number of parametres with low priority
|----
|----
|| F12
|| F12
|rowspan="6"| DONES
|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=""))
|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=""))
|| 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
|| 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=""))
|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=""))
|| 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
|| 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=""))
|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=""))
|| 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
|| L12|| || || Sum of derived/informed|| =J12+H12+F12
|| Number of parametres with auxiliary PPT
|----
|----
|| M12|| || || Sum of pre-fill|| =K12+I12+G12
|| M12|| || || Sum of pre-fill|| =K12+I12+G12
|| Number of parametres with auxiliary Excel
|----
|----
|| N12|| || || Sum of Dones|| =SUM(F12:K12)
|| N12|| || || Sum of Dones|| =SUM(F12:K12)
|| Number of parametres
|----
|----
|}
|}

Revision as of 08:14, 8 April 2015



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.

Effective floor area of buildings(m2)
ObsBuildingBaseline202020252050Year of baselineType of dataQualityDescription ref etc
1Residential buildings
2Government & public administration buildings
3Commercial offices buildings
4Data centers buildings
5Education, K12 and universitiy buildings
6Hospitals and healthcare buildings
7Hotels, hospitality and leisure buildings
8Exhibitions, fairs, halls buildings
9Retail, stores and shops buildings
10Warehouses & shopping mall buildings
11Industrial buildings
12Non 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.

Existing situation of total stock(%)
ObsPropertyResidentialNon-residentialPublic administration
1Wall insulation
2High efficient glazing
3Efficient lighting in baseline
4Demand oriented lighting
5Building Efficiency Monitoring
6Building Remote Monitoring
7Building Performance Optimization
8Demand controlled ventilation
9Heat and Cold Recovery in ventilation
10Efficient Motors
11Building Automation BACS Class C
12Building Automation BACS Class B
13Building Automation BACS Class A
14Room Automation HVAC
15Room Automation HVAC + lighting
16Building Automation HVAC + lighting + blinds

Energy demand

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

Total energy demand by type(kWh /m2 /a)
ObsEnergy typeResidentialNon-residentialPublic administration
1Electricity
2Cooling
3Heating

Note! Heating includes warm water.


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

Efficiency increase decreasing energy demand(% /a)
ObsEnergy typeUseResidentialNon-residentialPublic administration
1ElectricityLighting /Lamp stock
2ElectricityAppliances
3ElectricityVentilation
4ElectricityOther
5CoolingInfiltration
6CoolingVentilation
7CoolingOther (e.g. electric appliances, people)
8HeatingInfiltration
9HeatingVentilation
10HeatingFloors
11HeatingRoofs
12HeatingOther reasons
13HeatingWarm water


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

Share of energy demand by use type(%)
ObsEnergy typeUseResidentialNon-residentialPublic administrationAuxiliaries
1CoolingInfiltrationPPT
2CoolingVentilationPPT
3CoolingLosses through walls through transmissionPPT
4CoolingHeat input by solar radiation through windowsPPT
5CoolingLosses through windows through transmissionPPT
6CoolingOther effects (e.g. people, electrical Appliances)PPT
7HeatingInfiltrationPPT
8HeatingVentilationPPT
9HeatingWallsPPT
10HeatingWindowsPPT
11HeatingFloorsPPT
12HeatingRoofsPPT
13HeatingOtherPPT
14HeatingWarm waterExcel
15ElectricityLightingExcel
16ElectricityAppliancesExcel
17ElectricityVentilationExcel
18ElectricityOtherExcel

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

Energy parameters(-)
ObsParameterUnitResidentialNon-residentialPublic administrationAuxiliary
1Ratio of wall area / effective area-PPT
2Ratio of window/effective area-PPT
3U-value of windowsW /m2 /KPPT
4Solar heat gain coefficient "G-Value" of windows%PPT
5Efficiency increase of G-value of windows% /aExcel
6Efficiency increase of U-value of windows% /aExcel
7U-value of building wallsW /m2 /KPPT

Lighting

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

Average run time of lamps per year(h /a)
ObsLampResidentialNon-residentialPublic administration
1Incandescent lamps
2Compact fluorescent lamps
3Fluorescent lamps
4Low voltage halogen lamps
5Medium voltage halogen lamps
Shares of lamp types(%)
ObsLampResidentialNon-residentialPublic administration
1Incandescent lamps
2Compact fluorescent lamps
3Fluorescent lamps
4Low voltage halogen lamps
5Medium 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.

Possibly important information
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

See also

References

Related files

Retrieved from "https://en.opasnet.org/index.php?title=Building_stock_in_Helsinki&oldid=35247"