{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1. Project Details","1-1. Verification","2. OSE Report","3. Temperature Sensors","4. EUI","5. Water Consumption","6. Energy & Water Improve Plan","7. CoC","8. Sustainable OM","9 IEQ"],"not_rendered":{"charts":8,"images":3,"macros":1,"external_links":0,"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":"1. Project Details","index":0,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2],[22,0,22,1],[7,0,7,2],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[20,0,20,1],[21,0,21,1],[35,0,35,1],[27,0,27,1],[19,0,19,1],[1,0,1,2],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[28,0,28,1]]}
["“Re-certification of Green Mark Buildings” is a process for qualified Green Mark-certified buildings to be recognised for sustained performance in the area of energy and water efficiency, operations and management, and indoor environment quality. By satisfying a checklist of performance metrics, such buildings can be re-certified to its most recent Green Mark scheme and rating.\n\nEligibility\n     1. The building has not been retrofitted since its last Green Mark assessment\n     2. It intends to retain the same Green Mark scheme and rating\n     3. It was certified with the following schemes:\n          a. Green Mark for New Non-residential Buildings (GM-NRB)\n          b. Green Mark for Existing Non-residential Buildings (GM-ENRB)\n          c. Green Mark for Healthcare Facilities (GM-HC)\n\n"]
["Applicant is only required to provide entry for coloured (not white nor grey) cells in the following tabs:\n     1. Project Details\n     2. OSE / Energy Audit Report\n     4. Energy Utilisation Index\n     5. Water Consumption\n     6. Energy & Water  Improvement Plan\n     7. Cooling Tower CoC\n     8. Sustainable Operation & Management\n     9. IEQ\nThe assessor will schedule a visit to the site to verify the chiller plant temperature sensors and a walk-through of the facility."]
[]
[]
["Re-certification of Green Mark Buildings"]
[]
[]
["Project Details"]
["GM Reference No",null,"GMXXXX/7/2017"]
["Building name",null,"A Certain Building (Re-certification)"]
["Address",null,"800 Central Road Singapore 923880"]
["Building Owner",null,"XYZ Investment Pte Ltd"]
["Consultant Firm / ESCO",null,"Blue Energy Consultants Pte Ltd"]
["Green Mark Standard",null,"Green Mark for Existing Non-Residential Buildings (Version 3)"]
["Previous GM Reference No.",null,"GMXXX/9/2015"]
["Date of last GM Letter Of Award",null,"28 Feb 2015"]
["Previous GM Rating",null,"GoldPLUS"]
["Previous Green Mark Score",null,"88 (after verification)"]
["Date of Current GM Assessment",null,"15/2/2018"]
["Green Mark Assessors (Lead)",null,"John Doe"]
["Green Mark Assessors (co)",null,"Mary Ann"]
[]
["Building Details:"]
["Type of Building",null,"Hotel"]
["GFA (m2)",null,45000]
["Carpark Area (m2)",null,900]
["Air-conditioned Area (m2)",null,42000]
[]
["Building Key Performance Data:"]
["Type of A/C systems ",null,"Water-cooled"]
["Building cooling load (RT)",null,900]
["Chiller configuration (e.g. 3 nos. x 500RT)",null,"2 x 550RT (operating; 1 at night) + 1 x 600 (standby)"]
["Cooling load / aircon area (W/m2)",null,{"$f":"C31*3.517*1000/C27","v":75.3642857142857}]
["Air-conditioning system efficiency (kW/RT)",null,0.65]
["Total Building Energy consumption (kWh/yr)",null,{"$f":"'4. EUI'!B53","v":1093303}]
["EUI (kWh/m2/yr)",null,{"$f":"'4. EUI'!D61","v":24.295622222222221}]

{"sheet":"1-1. Verification","index":1,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,6],[12,0,12,6],[23,2,23,3],[24,2,24,3],[25,2,25,3],[2,3,2,4],[4,0,4,3],[5,3,5,6],[6,3,6,6],[9,3,9,6],[8,0,8,2],[8,3,8,6],[10,0,10,2],[26,2,26,3],[27,2,27,3],[19,0,19,1],[21,2,21,3],[5,0,5,2],[6,0,6,2],[7,0,7,2],[9,0,9,2],[22,2,22,3],[7,3,7,6],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[21,0,21,1]]}
["This tab is to be filled by BCA Assessors and is only required if there are green features committed in the previous assessment.\nDelete this tab if verification is not appilicable."]
[]
["Verification of Committed Green Features"]
[]
["Project Details"]
["Previous GM Reference No.",null,null,{"$f":"'1. Project Details'!C15","v":"GMXXX/9/2015"}]
["Date of last GM Letter Of Award",null,null,{"$f":"'1. Project Details'!C16","v":"28 Feb 2015"}]
["Green Mark Standard",null,null,{"$f":"'1. Project Details'!C14","v":"Green Mark for Existing Non-Residential Buildings (Version 3)"}]
["Previous GM Rating",null,null,{"$f":"'1. Project Details'!C17","v":"GoldPLUS"}]
["Verification Officer",null,null,"Mary Dole"]
["Use \"Insert..Object..Create from File\" command if macro execution is disabled"]
[]
["The list of commitments as listed in the attached Commitment Letter are"]
["GM Criteria","Description","Pre-requisite","Implemented","Variance, if any","Attachment e.g. photo, report","Impact"]
["e.g. 1-2d","Provision of permanent measuring instruments for monitoring of watercooled chilled-water plant","Y","Y","-",null,"-"]
["e.g. 2-4","Implementation of Water Efficiency Improvement Plan","N","N","-",null,-1]
[]
[]
[]
["Verification Results"]
[]
["Category",null,"Points Scored\n(during assessment)",null,"Final Points Scored\n(after verification)"]
["Part 1 - Energy Efficiency",null,60.06,null,60.06]
["Part 2 - Water Efficiency",null,13,null,13]
["Part 3 – Sustainable Operation & Management",null,25.25,null,25.25]
["Part 4 – Indoor Environment Quality",null,16,null,16]
["Part 5 – Other Green Features",null,10,null,9]
[null,"Total",{"$f":"SUM(C23:C27)","v":124.31},null,{"$f":"SUM(E23:E27)","v":123.31}]
[]
["Project Green Mark rating after verification:     Platinum   þ       Goldplus    r        Gold   r      Certified   r "]

{"sheet":"2. OSE Report","index":2,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[26,0,26,3],[2,0,3,0],[2,1,2,2],[2,3,3,3],[0,2,0,3],[25,0,25,3],[24,0,24,3]]}
["Summary of OSE/Energy Audit Report",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"]
["Power Consumption",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 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,"Quantity","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":"3. Temperature Sensors","index":3,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[42,0,42,3],[42,5,42,8],[4,0,4,3],[4,5,4,8]]}
["Temperature Sensors Check (This tab is to be filled by BCA Assessors)"]
[]
["Date:","2018-02-15"]
[]
["CHWS Temperature (°C)",null,null,null,null,"CHWR Temperature (°C)"]
["Time","BCA","BMS","ABS Diff",null,"Time","BCA","BMS","ABS Diff"]
[null,null,null,{"$f":"ABS(B7-C7)","v":0},null,null,null,null,{"$f":"ABS(G7-H7)","v":0}]
[null,null,null,0,null,null,null,null,{"$f":"ABS(G8-H8)","v":0}]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,"Average",{"$f":"AVERAGE(D7:D26)","v":0},null,null,null,"Average",{"$f":"AVERAGE(I7:I26)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CDWS Temperature (°C)",null,null,null,null,"CDWR Temperature (°C)"]
["Time","BCA","BMS","ABS Diff",null,"Time","BCA","BMS","ABS Diff"]
[null,null,null,{"$f":"ABS(B45-C45)","v":0},null,null,null,null,{"$f":"ABS(G45-H45)","v":0}]
[null,null,null,0,null,null,null,null,{"$f":"ABS(G46-H46)","v":0}]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,null,0,null,null,null,null,0]
[null,null,"Average",{"$f":"AVERAGE(D45:D64)","v":0},null,null,null,"Average",{"$f":"AVERAGE(I45:I64)","v":0}]

{"sheet":"4. EUI","index":4,"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 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'!C25","v":45000}]
["Energy Utility Index, 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":5,"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'14",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'15",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'16",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":6,"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":7,"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":8,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"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":"9 IEQ","index":9,"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:"]