Building stock in Helsinki

From Opasnet
Revision as of 08:14, 8 April 2015 by Jouni (talk | contribs) (→‎Rationale: priorities and auxiliaries added)
Jump to navigation Jump to search



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"