{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Guidance Notes","1. Project Details","2. EE requirement","2.1 EE Pathway1","4. EUI","2.2 EE Pathway2","3. OSE Report","4. Energy Consumption","5. Water Consumption","6. Energy & Water Improve Plan","7. CoC","8. Sustainable OM","8. IEQ","9. Others","Sheet1"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Guidance Notes","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[]
["Guidance Notes"]
[1,"GM 2021 In Operation aims to encourage buildings that have been previously certified before to continuously improve and maintain their performance. \n"]
[2,"The assessment will be based on their measured data. No letter of commitment or undertaking will be accepted for GM2021 In Operation certification.  Supporting documents such as OSE report, IAQ audit, POE survey shall be completed prior to the GM assessment.\n"]
[3,"Based on the actual performance, the GM ratings can be upgraded or downgraded. For example,  if a building that has been previously certified as GM Gold rating, but  if the actual performance at the time of assessment meets the GM2021 Platinum requirement, its rating can be upgraded to Platinum. \n"]
[4,"How to calculate EUI for EE pathway1? \n\nEnergy Use Intensity (EUI) express a building's energy use over a period of one year. It's calculated by dividing the total energy consumed by the building in one year (measured in kWh) by the total gross floor area (GFA) of the building (m2).  You can get your most recent one year's energy use from your utility bills and divided by GFA to get the most recent EUI. \nNote: to use EUI pathway, the occupancy rate must be higher than 60%. "]
[5,"TSE stands for Total System Efficiency. For water-cooled or air-cooled system, it is the sum of the efficiency values of both chiller plant and air side; for VRF or unitary system, TSE is the sum of efficiency values of the CU and FCUs (or AHUs if applicable).\n"]
[6,"DCS refers to the supply of chilled water for cooling purpose from a central source to multiple buildings through a network of pipes. Individual users purchase chilled water from the district cooling system operator and do not need to install separate chiller plant or unitary system. This is different from buildings’ in-house air-conditioning plant, in part or in full, being maintained and operated by a third party."]
[7,"Under EE Pathway 2, projects shall meet the minimum requirements i.e. the TSE should be better than 0.9kW/RT or the plant efficiency must be better than 0.65kW/RT, regardless of the project's previous GM rating. \nCompliance through the plant efficiency of 0.65kW/RT will be phased out by 31 Oct 2023 (based on LOA date). In other words, from 1 Nov 2023, all re-certification projects are subject to the same minimum TSE of 0.9kW/RT.\nFor projects complying with minimum 0.65kW/RT for plant efficiency before 31 Oct 2023, air side efficiency must be measured as well, though it is not for compliance purposes. The is for building owners to take note of the airside performance and prepare for compliance with future requirement. \n"]
[8,"Under TSE requirement in GM2021 In Operation, is it required to measure TSE for all types of systems i.e. water cooled, air cooled and VRF system?\n\nThe answer is yes for both water and air side efficiencies. However for VRF system, the CU efficiency can be based on catalogue and NEA formula till 31 Oct 2023 (LOA issued). In other words, from 1 Nov 2023, ongoing projects with VRF system need to measure their CUs’ efficiency. \nFor projects do not have VRF's technical specifications, and do not want to measure its efficiency before 30 Oct 2023, the VRF efficiency will be calculated based on nameplate power and cooling load. \nFor buildings with permanent M&V for VRF system, such as suppliers' monitoring system, the efficiency should be based on the measured data.\nOSE report should include air side and VRF as well. \n"]
[9,"For projects without permanent M&V for air side, how can the air side efficiency be measured?\n\nFor projects without permanent M&V for airside, 3rd party energy audit for air side is required. Please see detailed requirement below:\na) For AHUs with VSD (most projects), power readings should be downloaded from all AHUs to calculate air side efficiency;\nb) For AHUs without VSD (not common for GM certified projects), measurement must be taken with the sampling size of 30%  for AHUs of each size (in terms of cooling capacity) with trend logging of power and cooling load for one week. The minimum number of AHUs to be measured is 5 and capped at max of 20 AHUs. When the actual number of AHUs on site is less than 5, all AHUs need to be measured.\nc) For FCUs, catalogue data can be used to do calculation\n \nThis is valid till the next major retrofit when the building will be subject to GM2021 full certification. "]
[10,"Does OSE report need to be endorsed by an Energy Auditor (EA)or PE(Mech) for GM2021 In Operation?\n\nFor all projects that are required to submit independent OSE report, the OSE has to be endorsed. If the on-site system is linked to BCA system (such as SLEB hub or chiller portal), OSE report and its endorsement are not required.\n"]
[11,"Can Existing Residential Buildings (ERB) re-certification be assessed under GM2021 In Operation?\n\nYes, GM2021 In Operation is applicable for both ERB and ENRB. \n"]

{"sheet":"1. Project Details","index":1,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,0,24,1],[22,0,22,1],[14,0,14,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[15,0,15,1],[1,0,1,2],[7,0,7,2],[8,0,8,1],[9,0,9,1],[23,0,23,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[2,0,2,2]]}
[]
["GM: 2021 In Operation is applicable for Existing Buildings (a) which have previously attained Green Mark certification, (b) applying for re-certification and (c) have not done any major retrofit to the building's chilled water system. "]
[]
[]
["GM: 2021 In Operation"]
[]
[]
["Project Details",null,null,null,null,null,"Possible inputs"]
["GM Reference No"]
["Building name"]
["Type of Building",null,null,null,null,null,"Office / Retail / Hotel / Mixed Office + Retail"]
["GFA (m2)"]
["Carpark Area (m2)"]
["Air-conditioned Area (m2)"]
[]
["Building Key Performance Data:"]
["Type of Aircon system",null,null,null,null,null,"Central Water-cooled Chiller Plant / VRF System / Unitary System"]
["Building cooling load (RT)"]
["Chiller configuration (e.g. 3 nos. x 500RT)"]
["Cooling load / aircon area (W/m2)",null,{"$f":"(C18*3517)/C14","v":{"$error":"#DIV/0!"}}]
["Air-conditioning system efficiency (kW/RT) (Plant or CU)"]
["Air Distribution system efficiency (kW/RT)"]
["Total System Efficiency, TSE (kW/RT)"]
["Total Building Energy consumption (kWh/yr)"]
["Latest EUI (kWh/m2/yr)"]

{"sheet":"2. EE requirement","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,3,4],[4,0,4,4],[5,0,5,4]]}
[]
["Rating","Gold*","GoldPLUS","Platinum","SLE"]
["% Energy efficiency improvement over 2005 levels*",0.4,0.5,0.55000000000000004,0.6]
["Applicable EE Pathways:   Pathway 1 – EUI;\n                                            Pathway 2 – Fixed metrics"]
[]
["*Aligns with mandatory minimum energy efficiency requirements to raise energy performance standards of existing buildings"]

{"sheet":"2.1 EE Pathway1","index":3,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[21,2,21,5],[45,1,45,5],[31,1,31,5],[32,2,35,5],[26,2,26,5],[27,1,27,5],[28,2,30,5],[44,1,44,5],[1,1,1,5],[27,8,27,12],[28,9,30,12],[31,8,31,12],[32,9,35,12],[26,9,26,12],[3,8,3,12],[9,8,9,12],[15,8,15,12],[20,8,20,12],[21,9,21,12],[1,8,1,12],[3,1,3,5],[9,1,9,5],[15,1,15,5],[20,1,20,5]]}
[]
[null,"EUI Pathway1: for buildings with in-house Chilled water systems or other cooling systems",null,null,null,null,null,null,"EUI Pathway1: for buildings supplied by DCS*"]
[null,"Building Type","Gold \n40%","Goldplus \n50%","Platinum \n55%","SLE\n60%",null,null,"Building Type","Gold \n40%","Goldplus \n50%","Platinum \n55%","SLE\n60%"]
[null,"Commercial",null,null,null,null,null,null,"Commercial"]
[null,"Office Buildings (Large)",165,155,140,115,null,null,"Office Buildings (Large)",120,100,90,{"$f":"K5/0.5*0.4","v":80}]
[null,"Office Buildings (Small)",150,135,120,100,null,null,"Office Buildings (Small)",105,90,80,75]
[null,"Hotels (Large)",270,230,220,190,null,null,"Hotels (Large)",180,{"$f":"230*0.65","v":149.5},{"$f":"K7/0.5*0.45","v":134.55000000000001},{"$f":"K7/0.5*0.4","v":119.60000000000001}]
[null,"Hotels (Small)",200,180,160,140,null,null,"Hotels (Small)",145,{"$f":"185*0.65","v":120.25},110,95]
[null,"Retail Malls",300,240,210,160,null,null,"Retail Malls",190,160,144,128]
[null,"Educational",null,null,null,null,null,null,"Educational"]
[null,"IHL (University, Polytechnics and ITE)",150,130,120,90,null,null,"IHL (University, Polytechnics and ITE)"]
[null,"Private Schools and Colleges",130,110,100,80,null,null,"Private Schools and Colleges"]
[null,"Junior Colleges (MOE)",70,60,50,40,null,null,"Junior Colleges (MOE)",null,"nil"]
[null,"Secondary Schools (MOE)",45,40,35,30,null,null,"Secondary Schools (MOE)"]
[null,"Primary Schools (MOE)",45,40,35,30,null,null,"Primary Schools (MOE)"]
[null,"Healthcare",null,null,null,null,null,null,"Healthcare"]
[null,"Hospitals (Private and General)",450,375,340,300,null,null,"Hospitals (Private and General)",295,245,230,210]
[null,"Community Hospitals",280,230,210,185,null,null,"Community Hospitals",180,149.5,140,129.5]
[null,"Polyclinic ",180,150,135,120,null,null,"Polyclinic ",120,100,90.45,85]
[null,"Nursing/Youth Homes",105,90,80,70,null,null,"Nursing/Youth Homes",70,60,55,50]
[null,"Other Non-Residential",null,null,null,null,null,null,"Other Non-Residential"]
[null,"Mixed Develpments","by GFA mix",null,null,null,null,null,"Mixed Develpments","by GFA mix"]
[null,"Community Centres ",180,150,125,110,null,null,"Community Centres ",120,100,90,80]
[null,"Civic Buildings",100,80,70,60,null,null,"Civic Buildings",65,50,45,40]
[null,"Cultural Institution",220,180,140,120,null,null,"Cultural Institution",140,115,100,85]
[null,"Sports and Recreation Centres",125,110,80,50,null,null,"Sports and Recreation Centres",85,70,65,35]
[null,"Religious/ Place of Worship","NA",null,null,null,null,null,"Religious/ Place of Worship","NA"]
[null,"Industrial",null,null,null,null,null,null,"Industrial"]
[null,"High Tech Industrial","NA",null,null,null,null,null,"High Tech Industrial","NA"]
[null,"Light Industrial",null,null,null,null,null,null,"Light Industrial"]
[null,"Warehouses, Workshops and Others",null,null,null,null,null,null,"Warehouses, Workshops and Others"]
[null,"Residential",null,null,null,null,null,null,"Residential"]
[null,"Multi Residential (HDB, EC, Condo, pte apartments)","NA",null,null,null,null,null,"Multi Residential (HDB, EC, Condo, pte apartments)","NA"]
[null,"Cluster Housing",null,null,null,null,null,null,"Cluster Housing"]
[null,"Landed Housing",null,null,null,null,null,null,"Landed Housing"]
[]
[]
[null,"Additional Notes"]
[null,"Non Residential Buildings Minimum TSE",null,"0.9kW/RT"]
[null,"On-site RE is included in EUI (net off)",null,"On-site RE"]
[null,"EUI measured for EB and In Operation - occupancy rate ",null,">60%"]
[null,"Excludes EV charging station consumption"]
[]
[null,"EUI calculation:"]
[null,"Energy Utilisation Intensity =Total  Building Energy Consumption of one year (kWhyr) / GFA (m2)\nPlease use the most recent 12 months' energy consumption (occupancy rate >60%)  to calculate the most recent EUI. "]
[null,"*DCS refers to the supply of chilled water for cooling purpose from a central source to multiple buildings through a network of pipes. Individual users purchase chilled water from the district cooling system operator and do not need to install their own air-conditioning plant. This is different from buildings’ in-house air-conditioning plant, in part or in full, being maintained and operated by a third party.  "]

{"sheet":"4. EUI","index":4,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":true,"merged":[[35,1,35,3],[53,1,53,3],[59,1,59,3]]}
["Energy Utility Index (3 Years Electricity Bill)"]
[]
["Energy Consumption (1st Year, Baseline)"]
[]
["Month ","Total Consumption (kWh)","Tenant's Consumption (kWh)","Landlord's Consumption (kWh)"]
["e.g. Jun'14",1228556,13401,1215155]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B6:B17)","v":1228556},{"$f":"SUM(C6:C17)","v":13401},1215155]
[]
["Energy Consumption (2nd Year)"]
[]
["Month ","Total Consumption (kWh)","Tenant's Consumption (kWh)","Landlord's Consumption (kWh)"]
["e.g. Jun'15",1096746,9944,1086802]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B23:B34)","v":1096746},{"$f":"SUM(C23:C34)","v":9944},1086802]
["Baseline Improvement",{"$f":"(B18-B35)/B18","v":0.10728855664699045}]
[]
["Energy Consumption (3rd Year)"]
[]
["Month ","Total Consumption (kWh)","Tenant's Consumption (kWh)","Landlord's Consumption (kWh)"]
["e.g. Jun'16",1093303,11049,1082254]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B41:B52)","v":1093303},{"$f":"SUM(C41:C52)","v":11049},1082254]
["Baseline Improvement",{"$f":"(B18-B53)/B18","v":0.11009103370135345}]
[]
["Computation of Energy Untility Index (EUI) based on area (kW/m²/year)"]
[]
[null,"Year 1","Year 2","Year 3"]
["Total Building Energy Consumption (kWh)",{"$f":"B18","v":1228556},{"$f":"B35","v":1096746},{"$f":"B53","v":1093303}]
["Gross Floor Area,m² (GFA)",{"$f":"'1. Project Details'!C12","v":0}]
["Energy Utility Index, EUI",{"$f":"B59/B60","v":{"$error":"#DIV/0!"}},{"$f":"C59/B60","v":{"$error":"#DIV/0!"}},{"$f":"D59/B60","v":{"$error":"#DIV/0!"}}]
["Deviation","Baseline",{"$f":"(C61-B61)/B61","v":{"$error":"#DIV/0!"}},{"$f":"(D61-B61)/B61","v":{"$error":"#DIV/0!"}}]
["Reasons, if deviation > ± 5%","-"]

{"sheet":"2.2 EE Pathway2","index":5,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,7,1],[16,0,16,5],[19,0,19,5]]}
[]
["Building types","PARAMETER","Gold","GoldPLUS","Platinum","SLE"]
["For Commerical buildings","ACMV TSE1","TSE 0.9 or\nPlant efficiency of 0.65",0.8,0.74,0.68]
["For Healthcare buildings",null,"TSE 0.9 or\nPlant efficiency of 0.65",0.8,0.75,0.7]
["For Educational buildings",null,"TSE 0.9 or\nPlant efficiency of 0.65",0.8,0.75,0.7]
["For High Tech/ High intensity Industrial buildings",null,"TSE 0.9 or\nPlant efficiency of 0.65",0.8,0.78,0.75]
["For Light industrial/ Warehouse buildings",null,"TSE 0.9 or\nPlant efficiency of 0.65",0.8,0.75,0.7]
["For other non Residential buildings",null,"TSE 0.9 or\nPlant efficiency of 0.65",0.8,0.75,0.7]
[]
[]
["For building supplied by DCS2"]
[]
[]
["PARAMETER","Gold","GoldPLUS","Platinum","SLE"]
["Air side efficiency",0.25,0.2,0.18,0.16]
[]
["Note: \n1TSE is Total System Efficiency, including the efficiency from both chilled water plant and air side for water-cooled system; for VRF system, TSE includes the CU and FCUs efficiency\n\n2DCS refers to the supply of chilled water for cooling purpose from a central source to multiple buildings through a network of pipes. Individual users purchase chilled water from the district cooling system operator and do not need to install their own air-conditioning plant. This is different from buildings’ in-house air-conditioning plant, in part or in full, being maintained and operated by a third party.\n \n3For GM2021 full certification, M&V is required for TSE calculation/measurement; However, for project previously certified under legacy criteria, applying re-certification based on GM: 2021 In-Operation, air side efficiency can be done by third party energy audit. The methodology of air side measurement and its sampling size should refer to the guidance notes.  \n"]

{"sheet":"3. OSE Report","index":6,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[29,0,29,3],[2,0,3,0],[2,1,2,2],[2,3,3,3],[0,2,0,3],[28,0,28,3],[27,0,27,3],[0,0,0,1]]}
["Summary of OSE/Energy Audit Report \n(including airside efficiency)",null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
[]
["Daily Average Reading","Period",null,"Unit"]
[null,"Day Time^","Night Time~"]
["Cooling Load",null,null,"RT"]
["Cooling Load Density (Air-con area)",null,null,"m2/RT"]
["Energy Consumption from Chilled water side (Chillers, Pumps, CTs)",null,null,"kW"]
["Chilled water supply temperature",null,null,"oC"]
["Chilled water return temperature",null,null,"oC"]
["Chilled water delta T",null,null,"oC"]
["Chilled water flow rate",null,null,"l/s"]
["Chilled water flow rate vs cooling load",null,null,"USgpm/RT"]
["*Condenser heat rejection",null,null,"HRT"]
["*Condenser water supply temperature",null,null,"oC"]
["*Condenser water return temperature",null,null,"oC"]
["*Condenser water delta T",null,null,"oC"]
["*Condenser water flow rate",null,null,"l/s"]
["*Condenser water flow rate vs cooling load",null,null,"USgpm/RT"]
["Chiller(s) efficiency",null,null,"kW/RT"]
["Chilled water pump(s) efficiency",null,null,"kW/RT"]
["*Condenser water pump(s) efficiency",null,null,"kW/RT"]
["*Cooling tower(s) efficiency",null,null,"kW/RT"]
["Overall chiller plant system efficiency",null,null,"kW/RT"]
["Energy consumption from airside ",null,null,"kW"]
["Air Distribution system efficiency",null,null,"kW/RT"]
["Total System Efficiency",null,null,"kW/RT"]
[]
["*Not applicable to Air-cooled Chilled Water Plant"]
["~For hotels and other developments with 24-hour operations only, night time shall refer to the period from 11pm-7am"]
["^ For hotels and other developments with 24-hour operations, day-time shall refer to the period from 7am–11pm; for all other developments, daytime shall refer to the normal operating hours stipulated in clause 6.1.4"]
[]
["Summary of Heat Balance"]
[null,"Data","Unit","Formula"]
["Sum of total electrical energy used",null,"kWh","(A)"]
["Sum of total cooling produced",null,"RTh","(B)"]
["Sum of total heat rejected",null,"RTh","(C)"]
["Chiller Plant Efficiency",null,"kW/RT","(A) /  (B)"]
["Total Heat Balance Data Count",null,"-","(D)"]
["Data Count > + 5% error",null,"-","(E)"]
["Data Count < - 5% error",null,"-","(F)"]
["Data Count within ±5% error",null,"-","(G) = (D) – (E) – (F)"]
["% Heat Balance within ±5% error",null,"%","100 x (G) / (D)"]

{"sheet":"4. Energy Consumption","index":7,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":false,"merged":[[35,1,35,3],[53,1,53,3],[59,1,59,3]]}
["Energy Use Intensity (3 Years Electricity Bill)"]
[]
["Energy Consumption (1st Year, Baseline)"]
[]
["Month ","Total Consumption (kWh)","Tenant's Consumption (kWh)","Landlord's Consumption (kWh)"]
["e.g. Jun'18",1228556,13401,1215155]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B6:B17)","v":1228556},{"$f":"SUM(C6:C17)","v":13401},{"$f":"SUM(D6:D17)","v":1215155}]
[]
["Energy Consumption (2nd Year)"]
[]
["Month ","Total Consumption (kWh)","Tenant's Consumption (kWh)","Landlord's Consumption (kWh)"]
["e.g. Jun'19",1096746,9944,1086802]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B23:B34)","v":1096746},{"$f":"SUM(C23:C34)","v":9944},{"$f":"SUM(D23:D34)","v":1086802}]
["Baseline Improvement",{"$f":"(B18-B35)/B18","v":0.10728855664699045}]
[]
["Energy Consumption (3rd Year)"]
[]
["Month ","Total Consumption (kWh)","Tenant's Consumption (kWh)","Landlord's Consumption (kWh)"]
["e.g. Jun'20",1093303,11049,1082254]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B41:B52)","v":1093303},{"$f":"SUM(C41:C52)","v":11049},{"$f":"SUM(D41:D52)","v":1082254}]
["Baseline Improvement",{"$f":"(B18-B53)/B18","v":0.11009103370135345}]
[]
["Computation of Energy Use Intensity (EUI) based on area (kW/m²/year)"]
[]
[null,"Year 1","Year 2","Year 3"]
["Total Building Energy Consumption (kWh)",{"$f":"B18","v":1228556},{"$f":"B35","v":1096746},{"$f":"B53","v":1093303}]
["Gross Floor Area,m² (GFA)",{"$f":"'[1]1. Project Details'!C25","v":45000}]
["Energy Use Intensity, EUI",{"$f":"B59/B60","v":27.301244444444446},{"$f":"C59/B60","v":24.372133333333334},{"$f":"D59/B60","v":24.295622222222221}]
["Deviation","Baseline",{"$f":"(C61-B61)/B61","v":-0.10728855664699048},{"$f":"(D61-B61)/B61","v":-0.11009103370135356}]
["Reasons, if deviation > ± 5%","-"]

{"sheet":"5. Water Consumption","index":8,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,1,53,3],[35,1,35,3]]}
["Water Efficiency  (3 Years Building Water Bill)"]
[]
["Water Consumption (1st Year, Baseline)"]
[]
["Month ","Total Consumption (m³)","Tenant's Consumption (m³)","Landlord's Consumption (m³)"]
["e.g. Jun'18",12256.1,376,11880.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B6:B17)","v":12256.1},{"$f":"SUM(C6:C17)","v":376},11880.1]
[]
["Water Consumption (2nd Year)"]
[]
["Month ","Total Consumption (m³)","Tenant's Consumption (m³)","Landlord's Consumption (m³)"]
["e.g. Jun'19",11682.2,603,11079.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B23:B34)","v":11682.2},{"$f":"SUM(C23:C34)","v":603},11079.2]
["Baseline Improvement",{"$f":"(B18-B35)/B18","v":4.6825662323251249E-2}]
[]
["Water Consumption (3rd Year)"]
[]
["Month ","Total Consumption (m³)","Tenant's Consumption (m³)","Landlord's Consumption (m³)"]
["e.g. Jun'20",10688.1,711,9977.1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yearly Consumption",{"$f":"SUM(B41:B52)","v":10688.1},{"$f":"SUM(C41:C52)","v":711},9977.1]
["Baseline Improvement",{"$f":"(B18-B53)/B18","v":0.12793629294800141}]
[]
[null,"Year 1","Year 2","Year 3"]
["Total Building Water Consumption (m3)",{"$f":"B18","v":12256.1},{"$f":"B35","v":11682.2},{"$f":"B53","v":10688.1}]
["Deviation","Baseline",{"$f":"(C57-B57)/B57","v":-4.6825662323251249E-2},{"$f":"(D57-B57)/B57","v":-0.12793629294800141}]
["Reasons, if deviation > ± 5%","-"]

{"sheet":"6. Energy & Water Improve Plan","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,4],[4,4,5,4],[7,4,8,4],[5,0,5,2],[8,0,8,2]]}
["Energy and Water Improvement Plan"]
[]
["Submission of plans showing intent, measures and implementation strategies  to achieve improvement target set against current performance over the next 3 years."]
[]
["3 Years Energy Efficiency Improvement Target:",null,"%",null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Assessor's comment:"]
[]
["3 Years Water Efficiency Improvement Target:",null,"%",null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Assessor's comment:"]

{"sheet":"7. CoC","index":10,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,0,2,4],[4,4,5,4],[5,0,5,2]]}
["Cycles of Concentration (for water-cooled chiller plant only)"]
[]
["Submission of cooling tower’s water treatment reports showing 7 or better cycles of concentration."]
[]
["Cycle of Concentration:",null,"Cycles",null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Assessor's comment:"]

{"sheet":"8. Sustainable OM","index":11,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[[4,0,4,4],[9,0,9,4],[9,6,10,9],[14,6,15,9],[14,0,14,2],[4,6,4,9],[10,0,10,4],[15,0,15,4],[14,3,14,4],[5,0,5,4]]}
["Sustainable Operations & Management"]
[]
["Occupant Satisfaction Survey"]
[]
["A post-occupancy evaluation is a survey to gauge occupants’ satisfaction on indoor environmental quality and identify corrective actions that will enhance comfort. Please ask your assessor for a survey weblink for this project, which may then be disseminated to occupants. Results will be tabulated automatically, so that FM may view them and record corrective actions taken.\n\nAlternatively, you may use the attached questionaire from Annex B of GM ENRB:2017, and tabulate the response  with the attached result template.",null,null,null,null,null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Assessor's comment:"]
[]
["Environmental Policy"]
[]
["Environmental Policy that reflects sustainability goals set for the building and its systems",null,null,null,null,null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Assessor's comment:"]
[]
["Waste Recycling Reports"]
[]
["Name of waste recycling company:",null,null,null,null,null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Assessor's comment:"]

{"sheet":"8. IEQ","index":12,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,0,4,1],[13,0,13,3],[21,0,21,3],[23,3,25,3],[6,3,9,3],[15,3,17,3],[9,0,9,1],[17,0,17,1],[25,0,25,1]]}
["Indoor Environment Quality"]
[]
["IAQ Audit"]
[]
["Submission of latest IAQ audit report performed by SAC accredited consultants/companies, stating major areas of concern (e.g. mold issues)."]
[]
["Test Report Number:",null,null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Date Audit was Conducted:"]
["Name of SAC-Accredited Lab:"]
["Assessor's comment:"]
[]
["Lighting Lux Level"]
[]
["Submission of lighting lux levels for various areas, complying with SS531 or CP38."]
[]
["Test Report Number:",null,null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Measurements taken by:"]
["Assessor's comment:"]
[]
["Noise Level"]
[]
["Submission of noise levels for internal areas, complying with SS553 or CP13."]
[]
["Test Report Number:",null,null,"Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
["Measurements taken by:"]
["Assessor's comment:"]

{"sheet":"9. Others","index":13,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,0,20,3],[5,0,6,0],[5,1,6,1],[5,3,7,3],[7,0,7,1],[17,0,17,1],[29,3,31,3],[31,0,31,1],[29,0,30,0],[29,1,30,1],[22,3,24,3],[24,0,24,1]]}
[]
[]
[]
["POE survey"]
[]
["Submit POE survey results","done within past one year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Waste reports"]
["Submit past one year's waste collection report detailing the breakdown of types and quantity of recyclables and non-recyclables "]
[]
["Waste report of recyclables and non-recyclables "]
[]
[]
[]
[]
["Tenants/Occupants engagement"]
[]
["Submit photos of health and wellbeing related activities  organised by Green Building Committee","At least 3 activities per year"]

{"sheet":"Sheet1","index":14,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[[8,1,8,5]]}
[1,"Energy and water consumption for past three years"]
[2,"IAQ audit"]
[3,"POE"]
[4,"Lux level measurement"]
[5,"Smart control (co2) for refresh air intake"]
[6,"Lighting control (occupancy sensors)"]
[7,"monitoring recycles and non-recycles"]
[8,"energy and water improvement plan"]
[9,"at least 3 green or health related activities for tenants per year"]