GB Code Spreadsheet Technical Training 2017-04-27

Philippine Green Building Spreadsheet
March 15, 2017
1
Technical Training Agenda
• Establishing the Baseline Energy • Computing Total Energy Savings,

& Water Consumption and Cost CO2 Avoidance and Water
Savings
• Tracking Monthly Consumption • Hands-on and Question and

of Electricity and Water Answer
2
Establishing the Baseline Energy
Consumption and Cost
Existing buildings survey Summary of the results

• Offices (6 buildings) • Buildings average 10 years old
• Hospitals (4 buildings) • Buildings average 10 stories
• Educational (3 buildings) • 100% with no insulation
• Residential (6 buildings) • Glazing types vary
• Retail (4 buildings) • 50% with central AC
• Hotels (6 buildings) • 66% with low flow water fitting
59 buildings surveyed with • 30% with VSD fans and pumps
1,133,970 m2 of floor area • 186 kWh/m2/year average
with 50,000 occupants energy use
3
Establishing the Baseline Energy
Consumption and Cost
4
Computing Total Energy Savings and
CO2 Avoidance
Use Energy Consumption Cost

(kWh/m2/yr) (PHP/kWh)
Office 262 11.00
Hospital 323 11.00
School 119 11.00
Residential 65 11.00
Mercantile 345 11.00
Hotel 151 11.00
5
Establishing the Baseline Water
Consumption & Cost & Total Water Savings
Use Water Consumption Cost % Water EDGE Building Data EDGE Water
(m3/yr/unit) (PHP/m3) 2016 Savings Efficiency Measures
Office 1.8657square 54.10 32.4%Office (10,000 m2) OFW01 (4.8 Lt./min)
meters food court OFW02 (4.9 Lt./flush)
OFW03 (1 Lt./flush)
OFW04 (4.8 Lt./min)
Hospital 231beds 54.10 14.3%Private Hospital 105 HSW01 (9 Lt./min)
beds, 9,975 m2, HSW02 (4.8 Lt./min)
70% occupied HSW03 (4.9 Lt./flush)
uncheck all HSW04 (1 Lt./min)
School 1.497square 54.10 34.03%Office (10,000 m2) OFW01 (4.8 Lt./min)
meters uncheck all OFW02 (4.9 Lt./flush)
OFW03 (1 Lt./flush)
OFW04 (4.8 Lt./min)
Residential 105units 17.70 40.9%Lower Middle Income HMW01 (9 Lt/min)
Flats/Apartments HMW02&3 (4.8 Lt./min)
(188 units) HMW05 (4.9 Lt./flush)
Mercantile 7.2904square 54.10 35.4%Shopping Mall (15,000 RTW01 (4.9 Lt./flush)
meters m2), indoor parking, RTW02 (1 Lt./flush)
supermarket, food court RTW03&4 (4.8 Lt./min)
Hotel 74.1982rooms 54.10 20.8%1-Star Hotel (10,000 m2) HTW01 (9 Lt./min)
247 guest rooms HTW02 (4.8 Lt./min)
uncheck all HTW03 (4.9 Lt./flush)
HTW05 (1 Lt./flush)
HTW06 (4.9 Lt./flush)
HTW07 (4.8 Lt./min)
6
CO2 Avoidance
• Table 1 Electricity Cost, Water Cost & USD-PHP Exchange Rate

• fill out the following information:
▪ Residential Cost of Electricity (PHP/kWh)
▪ Nonresidential Cost of Electricty (PHP/kWh)
▪ Residential Cost of Water (PHP/m3)
▪ Nonresidential Cost of Water (PHP/m3)
▪ 1.00 USD TO PHP Exchange Rate (PHP)
▪ Date of Cost Information (YYYY-MM-DD)
7
CO2 Avoidance
• Table 3 New Construction and/or with Alteration of Buildings Covered by the

Philippine Green Building Code
• columns L to T will automatically compute baseline energy, green building
energy savings and CO2 avoidance.
• fill out columns A to J with information on the buildings complying with PGBC.
Columns A-J L-M N-O P Q-R S-T

New Construction and/ or Baseline Green Building CO2 Baseline Green Building
with Alteration of Buildings Energy Energy Savings Avoidance Water Water Savings
Covered by the PGBC (15%) (tCO2/yr)
8
CO2 Avoidance

Covered by the PGBC (15%) (tCO2/yr)
Bldg Bldg Bldg Owner Building Lot Use Total Floor Add’l
Permit Name Location Name Description Area Area for Info for
No. Energy Water
Savings Savings
000 A1 EDSA, Acme 40 Storey 888 Office 10000 10000

Wack- Corp. 1 Basement Total Floor
wack, Area in
Mandalu square
yong meters
9
CO2 Avoidance

Covered by the PGBC (15%) (kCO2/yr)
Consumption Cost (PHP Energy Cost Savings 0.5267

(mWh/yr) million/yr) Savings (PHP tCO2/mW
(mWh/yr) million/yr) CO2 Avoidance
(tCO2/yr)
2,620 28.82 393 4.32 207
10
Computing Total Water Savings

Covered by the PGBC (15%) (kCO2/yr)
Consumption Cost Water Savings Cost Savings

(m3/yr) (PHP (m3/yr) (PHP millions/yr)
millions/yr)
18,657 1.01 6,044.87 0.33
11
Computing Total Energy Savings, CO2
Avoidance and Total Water Savings
• Table 2 Total Lot and Floor Areas, Green Building Energy Savings, CO2
Avoidance, and Green Building Water Savings
• computes total lot and floor area, green building energy savings, CO2 avoidance
and green building water savings for the different projects listed in Table 3
Lot Floor Energy Cost CO2 Water Cost
Area Area Savings Savings Avoidance Savings Savings
Office
Hospital
School
Residential
Mercantile
Hotel
TOTAL
12
Tracking Monthly Consumption of
Electricity and Water
• Table 4 Operational Buildings Complying with the Philippine Green Building

Code
• records the electricity and water usage of operational buildings complying with
the Philippine Green Building Code
• fill out columns columns G onward with electricity and water usage of
operational buildings complying with the PGBC.
Columns A-F G-AD AE-BB
Operational Buildings Monthly Consumption Monthly Consumption
Complying with the Electricity & Cost Water & Cost
Philippine Green (kWh & PHP) (m3 & PHP)
Building Code
13

Building Code
Bldg Permit Bldg Bldg Owner Building Description

No. Name Location Name
000 A1 EDSA, Acme Corp. 40 Storey

Wack-wack, 1 Basement
Mandaluyong
14

Building Code
Electricity (kWh) Electricity Cost (PHP)

J F M A M J J A S O N D J F M A M J J A S O N D
15

Building Code
Water (m3) Water Cost (PHP)

J F M A M J J A S O N D J F M A M J J A S O N D
16
Hands-on and Question and Answer
17

GB Code Spreadsheet Technical Training 2017-04-27

Uploaded by

Copyright:

Available Formats

GB Code Spreadsheet Technical Training 2017-04-27

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

GB Code Spreadsheet Technical Training 2017-04-27

Uploaded by

Copyright:

Available Formats

Philippine Green Building Spreadsheet

March 15, 2017

• Establishing the Baseline Energy • Computing Total Energy Savings,

• Tracking Monthly Consumption • Hands-on and Question and

Existing buildings survey Summary of the results

Use Energy Consumption Cost

Hospital 323 11.00

School 119 11.00

Mercantile 345 11.00

Hotel 151 11.00

• Table 1 Electricity Cost, Water Cost & USD-PHP Exchange Rate

• Table 3 New Construction and/or with Alteration of Buildings Covered by the

Columns A-J L-M N-O P Q-R S-T

Columns A-J L-M N-O P Q-R S-T

000 A1 EDSA, Acme 40 Storey 888 Office 10000 10000

Columns A-J L-M N-O P Q-R S-T

Consumption Cost (PHP Energy Cost Savings 0.5267

Columns A-J L-M N-O P Q-R S-T

Consumption Cost Water Savings Cost Savings

18,657 1.01 6,044.87 0.33

• Table 4 Operational Buildings Complying with the Philippine Green Building

Columns A-F G-AD AE-BB

Bldg Permit Bldg Bldg Owner Building Description

000 A1 EDSA, Acme Corp. 40 Storey

Columns A-F G-AD AE-BB

Electricity (kWh) Electricity Cost (PHP)

Columns A-F G-AD AE-BB

Water (m3) Water Cost (PHP)

You might also like