{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary (NB2.0)","Credit Checklist","Project Score Result","Target Rating_BSL","pull down list"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"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":"Summary (NB2.0)","index":0,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[38,3,38,8],[50,2,50,8],[54,6,56,8],[17,5,17,7],[18,5,18,7],[6,3,6,8],[25,2,26,8],[32,3,32,8],[0,0,0,9],[13,2,13,8],[2,3,2,8],[4,3,4,8],[7,5,7,8]]}
["BEAM PLUS SUBMISSION SUMMARY (NEW BUILDINGS V2.0)"]
[]
[null,"Project Name: "]
[]
[null,"BEAM Plus Project No:"]
[]
[null,"Assessment Tools:"]
[null,"Provisional Assessment (PA) / Final Assessment (FA) : "]
[]
[null,"*Please be reminded that the information below should be tally with the project information fact sheet."]
[]
[null,"1.","Project Description:"]
[]
[null,null,"Please note that the project description will be shown in the assessment report."]
[]
[null,"2.","Site Area:",null,"m²"]
[]
[null,"3.","Number of Tower/Block:"]
[null,null,"(Number of Storey of each Tower/Block:",null,null,null,null,null,")"]
[]
[null,"4.","Approved GBP Submitted:"]
[]
[null,"5.","Master Programme Submitted: "]
[]
[null,"6.","Project Schedule:"]
[null,"ø","For multiple phase in a single PA or FA asssessment, please fill in the earliest start date for date of commencement and the final complete date for the work completion."]
[]
[null,"ø","a) Demolition "]
[null,null,null,"Date of Commencement:",null,null,"(mm/yyyy)"]
[null,null,null,"Date of Work Completeion:",null,null,"(mm/yyyy)"]
[null,null,null,"Consent for the commencement and carrying out of work submitted"]
[null,null,null,"Demolition is not applicable for the project."]
[null,null,null,"Please fill in with a brief reason of not applicable."]
[null,"ø","b) Foundation"]
[null,null,null,"Date of Commencement:",null,null,"(mm/yyyy)"]
[null,null,null,"Date of Work Completeion:",null,null,"(mm/yyyy)"]
[null,null,null,"Consent for the commencement and carrying out of work submitted"]
[null,null,null,"Foundation is not applicable for the project."]
[null,null,null,"Please fill in with a brief reason of not applicable."]
[null,"ø","c) Super-Structure / Construction"]
[null,null,null,"Date of Commencement:",null,null,"(mm/yyyy)"]
[null,null,null,"Date of Work Completeion:",null,null,"(mm/yyyy)"]
[null,null,null,"Consent for the commencement / carry out of building work submitted",null,null,null,"(Target/Consent Date:",null,") (dd/mm/yyyy)"]
[]
[null,null,"d) Submission of Substantiation of Work Completion"]
[null,null,null,"Certificate on Completion of Building Work",null,null,"(Target/Date of Issuance:",null,") (dd/mm/yyyy)"]
[null,null,"OR","Occupation Permit (OP)",null,"(Target/Date of Issuance:",null,") (dd/mm/yyyy)"]
[null,null,"OR","Other ","(Please specify:",null,")"]
[]
[null,null,"e) Explaination for the overlapped period in section 6:"]
[]
[]
[null,"7.","Whether this project applies for GFA concession?"]
[]
[null,"8.","CFA without 10% Concession: ",null,null,"m²",{"$f":"IF(AND(G65<>0,E55<>G65,E56<>G65),\"Please be reminded that the figure of CFA with 10% Concession or the figure of CFA without 10% Concession should be equal to the sum of CFA area in section 9.\",\"\")","v":""}]
[null,null,"CFA with 10% Concession: ",null,null,"m²  "]

{"sheet":"Credit Checklist","index":1,"n_rows":221,"n_cols":14,"rows_kept":221,"cut":false,"hidden":false,"merged":[[2,8,2,12],[2,13,3,13],[4,6,4,7],[5,6,5,7],[6,6,6,7],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[7,6,7,7],[8,0,9,0],[8,1,9,1],[8,3,9,3],[8,6,8,7],[10,0,12,0],[10,1,12,1],[10,3,12,3],[2,6,3,7],[17,6,17,7],[18,0,20,0],[18,1,20,1],[18,3,20,3],[18,6,18,7],[19,6,19,7],[20,6,20,7],[13,0,16,0],[13,1,16,1],[13,3,16,3],[13,6,13,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[26,0,31,0],[26,1,31,1],[26,3,28,3],[26,6,26,7],[29,3,31,3],[29,6,29,7],[21,6,21,7],[22,0,25,0],[22,1,25,1],[22,3,25,3],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[40,0,43,0],[40,1,43,1],[40,3,43,3],[40,6,40,7],[44,0,45,0],[44,1,45,1],[44,3,45,3],[44,6,44,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[38,0,39,0],[38,1,39,1],[38,3,39,3],[38,6,38,7],[39,6,39,7],[46,5,46,7],[47,5,47,7],[48,5,48,6],[49,5,49,7],[51,0,52,0],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,7],[51,8,51,12],[51,13,52,13],[53,6,53,7],[54,6,54,7],[55,0,59,0],[55,1,59,1],[55,3,59,3],[55,6,55,7],[56,6,56,7],[65,6,65,7],[66,6,66,7],[67,0,68,0],[67,1,68,1],[67,3,68,3],[67,6,67,7],[68,6,68,7],[60,0,61,0],[60,1,61,1],[60,3,61,3],[60,6,60,7],[61,6,61,7],[62,0,64,0],[62,1,64,1],[62,3,64,3],[62,6,62,7],[77,6,77,7],[79,3,80,3],[81,3,82,3],[81,6,81,7],[82,6,82,7],[84,6,84,7],[69,0,74,0],[69,1,74,1],[69,3,71,3],[69,6,69,7],[72,3,74,3],[75,0,83,0],[75,1,83,1],[75,6,75,7],[76,3,78,3],[76,6,76,7],[89,0,90,0],[89,1,90,1],[89,3,90,3],[91,5,91,7],[92,5,92,7],[93,5,93,6],[85,0,86,0],[85,1,86,1],[85,6,85,7],[86,6,86,7],[87,0,88,0],[87,1,88,1],[87,3,88,3],[87,6,87,7],[96,8,96,12],[96,13,97,13],[98,6,98,7],[99,6,99,7],[101,0,102,0],[101,1,102,1],[101,3,102,3],[101,6,101,7],[94,5,94,7],[96,0,97,0],[96,1,97,1],[96,2,97,2],[96,3,97,3],[96,4,97,4],[96,5,97,5],[96,6,97,7],[110,0,111,0],[110,1,111,1],[110,3,111,3],[110,6,110,7],[112,0,114,0],[112,1,114,1],[112,3,114,3],[112,6,112,7],[103,0,106,0],[103,1,106,1],[103,2,104,2],[103,3,104,3],[103,6,103,7],[107,0,109,0],[107,1,109,1],[107,6,107,7],[115,0,116,0],[115,1,116,1],[115,3,116,3],[115,6,115,7],[116,6,116,7],[117,0,119,0],[117,1,119,1],[117,3,119,3],[117,6,117,7],[128,0,131,0],[128,1,131,1],[128,3,131,3],[128,6,128,7],[129,6,129,7],[132,5,132,7],[120,0,124,0],[120,1,124,1],[120,3,124,3],[120,6,120,7],[125,6,125,7],[126,0,127,0],[126,1,127,1],[126,3,127,3],[126,6,126,7],[133,5,133,7],[134,5,134,6],[135,5,135,7],[137,0,138,0],[137,1,138,1],[137,2,138,2],[137,3,138,3],[137,4,138,4],[137,5,138,5],[137,6,138,7],[137,8,137,12],[137,13,138,13],[139,6,139,7],[140,6,140,7],[141,6,141,7],[142,0,143,0],[142,1,143,1],[142,2,143,2],[142,3,143,3],[142,6,142,7],[144,6,144,7],[145,0,147,0],[145,1,147,1],[145,3,147,3],[145,6,145,7],[148,0,150,0],[148,1,150,1],[148,3,150,3],[148,6,148,7],[149,6,149,7],[151,0,152,0],[151,1,152,1],[151,3,152,3],[151,6,151,7],[152,6,152,7],[153,0,154,0],[153,1,154,1],[153,3,154,3],[153,6,153,7],[161,8,161,12],[161,13,162,13],[163,6,163,7],[164,6,164,7],[155,6,155,7],[156,5,156,7],[157,5,157,7],[158,5,158,6],[159,5,159,7],[165,0,166,0],[165,1,166,1],[165,3,166,3],[165,6,165,7],[167,0,168,0],[167,1,168,1],[167,3,168,3],[167,6,167,7],[161,5,162,5],[161,6,162,7],[161,0,162,0],[161,1,162,1],[161,2,162,2],[161,3,162,3],[161,4,162,4],[169,6,169,7],[170,6,170,7],[171,6,171,7],[172,6,172,7],[173,6,173,7],[174,0,176,0],[174,1,176,1],[174,3,176,3],[174,6,174,7],[175,6,175,7],[182,6,183,7],[182,8,182,12],[182,13,183,13],[184,6,184,7],[185,6,185,7],[187,0,188,0],[187,1,188,1],[187,3,188,3],[177,5,177,7],[178,5,178,7],[179,5,179,6],[180,5,180,7],[182,0,183,0],[182,1,183,1],[182,2,183,2],[182,3,183,3],[182,4,183,4],[182,5,183,5],[189,0,190,0],[189,1,190,1],[189,3,190,3],[189,6,189,7],[191,0,194,0],[191,1,194,1],[191,3,194,3],[191,6,191,7],[192,6,192,7],[194,6,194,7],[201,6,201,7],[202,0,204,0],[202,1,204,1],[202,3,203,3],[202,6,202,7],[204,6,204,7],[195,6,195,7],[196,0,200,0],[196,1,200,1],[196,6,196,7],[197,6,197,7],[198,6,198,7],[200,6,200,7],[205,0,206,0],[205,1,206,1],[205,3,206,3],[205,6,205,7],[207,0,208,0],[207,1,208,1],[207,3,208,3],[207,6,207,7],[208,6,208,7],[216,8,216,12],[216,13,217,13],[218,6,218,7],[210,6,210,7],[211,5,211,7],[212,5,212,7],[213,5,213,6],[214,5,214,7],[216,0,217,0],[216,1,217,1],[216,2,217,2],[216,3,217,3],[216,4,217,4],[216,5,217,5],[216,6,217,7]]}
["2. Credit Summary"]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Integrated Design & Construction Management (IDCM)",null,null,null,{"$f":"SUM(E6:E46)&\"+\"&COUNTIF(E6:E46,\"1B\")&\"B\"","v":"25+14B"},"Y/N?"]
["IDCM P1","Sustainability Champions - Project","Demonstrate that an accredited BEAM Professional (BEAM Pro) with a valid credential for BEAM Plus New Buildings v2.0 is engaged as the Project BEAM Pro of the consultant team.","All buildings","Required","Y","Required"]
["IDCM P2","Environmental Management Plan","Demonstrate that an Environmental Management Plan (EMP) has been properly prepared.","All buildings","Required","Y","Required"]
["IDCM P3","Timber Used for Temporary Works","Demonstrate that no virgin forest products are used for temporary works.","All buildings","Required","Y","Required"]
["IDCM 1","Sustainability Champions - Design","1 credit for at least two (2) members from at least two (2) applicable core design disciplines shall be accredited BEAM Professionals with valid credentials for BEAM Plus NB v2.0 for Projects intending to achieve Bronze rating or above.","All buildings",1,"Y"]
[null,null,"1 ADDITIONAL BONUS credit for at least one (1) additional member, from an applicable core design discipline different from the disciplines counted in the above credit, shall be accredited BEAM Professional with valid credential for BEAM Plus NB v2.0; \n\nAlternatively, \nAt least two (2) additional members, of an applicable core design discipline different from the disciplines counted in the above credit, shall be accredited BEAM Affiliates with valid credential for BEAM Plus NB v2.0.",null,"1B","Y",null,"B"]
["IDCM 2","Complimentary Certification","(a) BEAM Plus Neighbourhood (ND)\n1 BONUS credit where the project is certified by BEAM Plus Neighbourhood (ND) certification.","All buildings that are applicable for respective BEAM Plus certification tools.","1B","Y",null,"B"]
[null,null,"(b) BEAM Plus Interiors (BI)\n1 BONUS credit for preparing the Project for BEAM Plus Interiors (BI) certification.",null,"1B","Y",null,"B"]
[null,null,"(c) BEAM Plus Existing Buildings (EB) \n1 BONUS credit for preparing the project for BEAM Plus Existing Buildings (EB) certification (comprehensive scheme).",null,"1B","Y",null,"B"]
["IDCM 3","Integrated Design Process","(a) Early Consideration(s) for Integrated Building Design Process\n1 credit for consideration of the integrated design process on whole-systems thinking to explore the interrelationships among green building design strategies and systems in the conceptual design stage.\n","All buildings",1,"Y"]
[null,null,"1 ADDITIONAL credit for organizing at least one multi-disciplinary design charrette to formulate passive and active design strategies in the conceptual/ schematic design stages.",null,1,"Y"]
[null,null,"(b) Early Design Consideration of Buildability/ Constructability\n1 credit for early design consideration of buildability to ease construction and save on-site materials/ labour before completion of the design development stage.\n",null,1,"Y"]
[null,null,"(c) Design Consideration for Operation and Maintenance\n1 credit for design consideration of  the long-term operation and maintenance needs for the building and its engineering services.\n",null,1,"Y"]
["IDCM 4","Life Cycle Costing","1 credit for conducting life cycle costing for active systems.","All buildings",1,"Y"]
["IDCM 5","Commissioning","2 credits for demonstrating the (a) the appointment of commissioning authority (CxA) before tender stage and (b) providing a commissioning plan.","All buildings",2,"Y",0]
[null,null,"1 credit for providing a commissioning review report before construction as described in part ( c)",null,1,"Y",0]
[null,null,"1 credit for providing commissioning reports as described in part (d) ",null,1,"Y",0]
["IDCM 6","Sustainability Champions - Construction","1 credit for at least two (2) accredited BEAM Professionals with valid credential for BEAM Plus New Buildings v2.0 are engaged by the main/ lead contractor for the Project intending to achieve Bronze rating or above.\nAlternatively,\n1 credit for at least one (1) accredited BEAM Professional and two (2) accredited BEAM Affiliates, with valid credential for BEAM Plus New Buildings v2.0 are engaged by the main/ lead contractor of the Project intending to achieve Bronze rating or above.\n","All buildings",1,"Y",0]
["IDCM 7","Measures to Reduce Site Emissions","(a) Minimisation of Air Pollution\n1 credit for providing adequate monitoring and mitigation measures to minimize air pollution during construction (demolition and foundation are included, if any).\n","All buildings",1,"Y",0]
[null,null,"(b) Minimisation of Noise Pollution\n1 credit for providing adequate monitoring and mitigation measures to minimize noise pollution during construction (demolition and foundation are included, if any). \n",null,1,"Y",0]
[null,null,"(c) Minimisation of Water Pollution\n1 credit for provide adequate monitoring and mitigation measures to minimize water pollution during construction (demolition and foundation are included, if any). \n",null,1,"Y",0]
[null,null,"(d) Minimization of Light Pollution\n1 credit for providing adequate mitigation measures to minimize light pollution during construction (demolition and foundation are included, if any). \n\n",null,1,"Y",0]
["IDCM 8","Construction and Demolition Waste Recycling","(a) Demolition Waste Recycling\n1 credit for demonstrating compliance with the Waste Management Plan and the application of proactive waste management provisions during demolition; and recycling of at least 15% of demolition waste. ","All buildings requiring demolition which are under the Client’s control",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for demonstration of recycling at least 30% of demolition waste.",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for demonstration of recycling of at least 60% of demolition waste.",null,"1B","Y",0,"B"]
[null,null,"(b) Construction Waste Recycling\n1 credit for demonstrating compliance with the Waste Management Plan and the application of proactive waste management provisions during construction (foundation to be included, if any); and recycling of at least 15% of construction waste (foundation waste included, if any).\n","All buildings",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for demonstration of recycling of at least 30% of construction waste (foundation waste included, if any).",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for demonstration of recycling of at least 60% of construction waste (foundation waste included, if any).\n",null,"1B","Y",0,"B"]
["IDCM 9","Construction IAQ Management","1 credit for implementing a Construction IAQ Management Plan, undertaking a building ‘flush out’ or ‘bake out’, and replacement of all filters prior to occupancy.","All areas to implementing a Construction IAQ Management Plan\nAll areas with central air-conditioning and ventilation systems for undertaking a building ‘flush out’ or bake out’ and replacement of all filters prior to occupancy.\n",1,"Y",0]
["IDCM 10","Considerate Construction","1 credit for demonstrating considerate measures to the neighbourhood, passers-by and workers. Good tree protection practices where tree preservation within the project site is required, should also be carried out.","All buildings",1,"Y",0]
["IDCM 11","Building Management Manual","1 credit for providing fully documented Operations and Maintenance Manual and Energy Management Manual.","All buildings",1,"Y",0]
["IDCM 12","Operator Training plus Chemical Storage Room","1 credit for providing training for operations and maintenance staff to the minimum specified; and demonstrating that adequate maintenance facilities are provided for operations and maintenance work. \n","All buildings",1,"Y",0]
["IDCM 13","Digital Facility Management Interface","1 BONUS for providing a digital interface in addition to the project design metering provision for future facility management team to review the building operation performance.","All non-residential buildings and  common areas of residential buildings\n","1B","Y",0,"B"]
["IDCM 14","Occupant Engagement Platform","1 BONUS credit for providing a digital platform to engage building occupants.\n","All non-residential buildings\n","1B","Y",0,"B"]
["IDCM 15","Document Management System","(a) Project Team Document Management \n1 credit for demonstrating the use of document management system within the design team.\n","All buildings",1,"Y",0]
[null,null,"(b) Facility Management Team Document Management \n1 credit for demonstrating the use of document management platform by the building owner or building management company.\n",null,1,"Y",0]
["IDCM 16","BIM Integration","(a) Coordinated Use of BIM within Design Teams\n1 credit for the coordinated use of BIM among the design team.","All buildings",1,"Y",0]
[null,null,"(b) Coordinated Use of BIM with Design and Construction Teams\n1 ADDITIONAL BONUS credit for coordinated use of BIM among design teams and the contractors.",null,"1B","Y",0,"B"]
[null,null,"(c) BIM for time\n1 BONUS credit for using the BIM model for scheduling, cost and quantity, schedules preparation and tracking the project budget.",null,"1B","Y",0,"B"]
[null,null,"(d) BIM for Facility Management Use\n1 BONUS credit for updating the BIM model to as-built condition.",null,"1B","Y",0,"B"]
["IDCM 17","Design for Engagement and Education on Green Buildings ","1 credit for providing any two (2) education elements of the listed green building design measures and provisions accredited by BEAM Plus and implemented in the project. The Project must achieve a rating of Bronze or above.","All buildings",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for providing four(4) education elements of the listed green building design measures and provisions. ",null,"1B","Y",0,"B"]
[null,null,null,null,"Credit Applicable:",{"$f":"IF(COUNTIF(F9:F46,\"Y\")=0,\" \", SUMIFS(E9:E46,E9:E46,\">0\",F9:F46,\"Y\"))","v":25}]
[null,null,null,null,"Credit Anticipated:",{"$f":"IF(COUNTIF(F9:F46,\"Y\")=0,\" \",SUMIFS(G9:G46,E9:E46,\">0\",F9:F46,\"Y\"))","v":0}]
[null,null,null,null,"Bonus Anticipated:",{"$f":"IF(COUNTIF(F9:F46,\"Y\")=0,\" \",SUMIFS(G9:G46,E9:E46,\"1B\",F9:F46,\"Y\"))","v":0},null,"B"]
[null,null,null,null,"Percentage of Credits Achieved:",{"$f":"IF(COUNTIF(F9:F46,\"Y\")=0,\" \",IF((F48+F49*1.2)/SUMIF(F9:F46,\"Y\",E9:E46)>100%,100%,(F48+F49*1.2)/SUMIF(F9:F46,\"Y\",E9:E46)))","v":0}]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Sustainable Site (SS)",null,null,null,{"$f":"SUM(E55:E76, E85:E91)&\"+\"&(COUNTIF(E55:E76,\"1B\")+COUNTIF(E85:E91,\"1B\"))+2*(COUNTIF(E55:E76,\"2B\")+COUNTIF(E85:E91,\"2B\"))&\"B / \"&SUM(E55:E75, E77:E91)&\"+\"&(COUNTIF(E55:E75,\"1B\")+COUNTIF(E77:E91,\"1B\"))+2*(COUNTIF(E55:E75,\"2B\")+COUNTIF(E77:E91,\"2B\"))&\"B\"","v":"17+13B / 20+19B"},"Y/N?"]
["SS P1","Minimum Landscaping Requirements","Demonstrate compliance with minimum planting provisions in terms of viability and site coverage of greenery of at least 20% of the site.","All sites with a site area of 1,000m2 or more.","Required","Y","Required"]
["SS 1","Pedestrian-oriented and Low Carbon Transport","(a) Accessibility to Public Transport\n1 credit for achieving Accessibility Index of 15 or more for all buildings of a development.\n","All buildings",1,"Y",0]
[null,null,"(b) Pedestrian-oriented Access\n1 credit for achieving 50% or more of the applicable pedestrian-oriented transport planning measures.\n",null,1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for achieving 100% of the applicable pedestrian-oriented transport planning measures. ",null,"1B","Y",0,"B"]
[null,null,"(c) Cycling Facilities and Network Integration \n1 BONUS credit for providing cycling facilities within the Site and integrating with the public cycling network if a public cycling network exists or has been planned nearby.\n",null,"1B","Y",0,"B"]
[null,null,"(d) Charging Facilities for Electric Vehicle (EV)\n1 BONUS credit for providing EV medium chargers for at least 50% of all parking spaces and EV charging-enabling for all parking spaces (including visitor car parks).\n",null,"1B","Y",0,"B"]
["SS 2","Neighbourhood Amenities","(a) Amenities for Building Users\n1 credit where adequate amenities for building users are located within the Site or 500m walking distance/ an equivalent horizontal commuting time from the site entrance(s).\n","All buildings",1,"Y",0]
[null,null,"(b) Shared Amenities for Neighbourhood\n1 credit where adequate shared amenities for neighbourhood are provided within the site and are made available for public use.\n",null,1,"Y",0]
["SS 3","Building Design for Sustainable Urbanism","(a) Sustainable Urban Design\n1 credit for preparing site design appraisal report demonstrating a proactive approach in achieving a people-oriented and place-making approach for sustainable site planning, and at least 30% of applicable sustainable urbanism measures are achieved.\n2 credits for achieving at least 60% of applicable sustainable urbanism measures.\n","All buildings",2,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for achieving at least 90% of applicable sustainable urbanism measures.",null,"1B","Y",0,"B"]
[null,null,"(b) Conservation of Cultural Heritage\n1 BONUS credit for demonstrating that a proper heritage impact assessment mechanism and its recommendations have been implemented.\n",null,"1B","Y",0,"B"]
["SS 4 ","Neighbourhood Daylight Access","1 credit for designs which the access to daylight of neighbouring sensitive buildings is maintained to the prescribed levels.","All buildings",1,"Y",0]
["SS 5 ","Noise Control for Building Equipment","1 credit for demonstrating that the level of the intruding noise at the facade of the potential noise sensitive receivers is in compliance with the criteria recommended in the Technical Memorandum for the Assessment of Noise from Places Other than Domestic Premises, Public Places or Construction Sites.","All buildings",1,"Y",0]
["SS 6","Light Pollution Control","(a) Control of Obtrusive Artificial Light\n1 credit for demonstrating that the obtrusive light from exterior lighting meets the specified performance for the environmental zone in which the building development is located.\n","All buildings",1,"Y",0]
[null,null,"(b) Control of External Light Reflection from Building\n1 credit for demonstrating that sunlight reflection from external surfaces of the building is controlled by using materials with proper external light reflectance.\n",null,1,"Y",0]
["SS 7","Biodiversity Enhancement","(a) Reduction of Ecological Impact\n1 credit for demonstrating all identified habitat types on Site are of low or negligible indicative ecological values\nAlternatively,\nDemonstrating that all identified habitat types on Site of medium to high indicative ecological value are preserved intact and are either unaffected by the planned development.","All site with existing tree except brownfield sites or sites on reclaimed land ",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for demonstrating that existing trees are retained in situ such that the combined girth of the retained trees, with individual girth of at least 150mm for below requirement. At least 20% of the total girth of all existing trees on site.",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for demonstrating that existing trees are retained in situ such that the combined girth of the retained trees, with individual girth of at least 150mm for below requirement. At least 40% or more of the total girth of all existing trees on site.",null,"1B","Y",0,"B"]
[null,null,"(b) Enhancement of Biodiversity\n1 BONUS credit for preparing a manual on biodiversity-friendly landscape maintenance, PLUS Physical connectivity between areas with ecological values","Sites with adjacent areas of medium or high ecological value","1B","Y",0,"B"]
[null,null,"1 BONUS credit for preparing a manual on biodiversity-friendly landscape maintenance, PLUS Increase diversity and complexity of planting",null,"1B","Y",0,"B"]
[null,null,"1 BONUS credit for preparing a manual on biodiversity-friendly landscape maintenance, PLUS Wildlife-friendly building features (e.g. windows and lighting)",null,"1B","Y",0,"B"]
["SS 8","Urban Heat Island Mitigation","(a) Urban Design Guidelines Chapter 11\n1 credit for implementing at least 2 site level strategies under Section 11 of Hong Kong Planning Standards and Guidelines Chapter 11 Urban Design Guidelines.\n","All buildings & \nfor Site area <1000m2",1,"Y",0]
[null,null,"(a) Sustainable Building Design Measures\n1 credit for providing shade on at least 5% of the site area and at least 50% of non-roof impervious surfaces on the site (parking, walkways, plazas) using light coloured high-albedo materials (albedo of at least 0.4).\n","All buildings & \nfor Site area \n≥ 1000m2",1,"Y",0]
[null,null,"1 credit for demonstrating compliance with prescribed requirements of the SBD Guidelines as promulgated in the PNAP APP-152.",null,1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for demonstrating compliance with prescribed requirements and relevant prescriptive requirements of the SBD Guidelines as promulgated in the PNAP APP-152 with enhanced performances.",null,"1B","Y",0,"B"]
[null,null,"(b) Tree Coverage\n2 BONUS credits for demonstrating that at least 10% of the total Site Area is provided with tree coverage.\n","All buildings & \nfor Site area \n≥ 1000m2","2B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance, where 20% or more of the site is provided with tree coverage.",null,"1B","Y",0,"B"]
[null,null,"(c) Air Ventilation Assessment (AVA)\nFor conducting an AVA by wind tunnel or Computer Fluid Dynamics (CFD) according to the prevailing AVA methodology introduced by the Government demonstrating that better or equivalent ventilation performances than a baseline case:\n1 Credit for demonstrating annual wind condition.\n","All buildings & \nfor Site area \n≥ 1000m2",1,"Y",0]
[null,null,"1 Credit for demonstrating summer wind condition.",null,1,"Y",0]
[null,null,"(d) Intra Urban Heat Island Study\n2 BONUS credit for conducting an Intra Urban Heat Island Study demonstrating that a maximum Intra-Urban Heat Index (difference between Turban and Tmet ) in summer is less than 0.8 °C.\n","All buildings & \nfor Site area \n≥ 1000m2","2B","Y",0,"B"]
["SS 9","Immediate Neighbourhood Wind Environment","1 credit for demonstrating that no pedestrian areas will be subject to excessive wind velocities caused by amplification due to the site layout design and/or building design.","All buildings",1,"Y",0]
["SS 10","Outdoor Thermal Comfort","(a) Shaded or Covered Routes\n1 credit for at least one shaded or covered route, connecting the site with nearby amenities / site main entrance/ transport hub.\n","All sites with site area of 1,000m2 or more.",1,"Y",0]
[null,null,"(b) Passive Open Spaces with Thermal Comfort\n1 credit for 50% or more of the passive open spaces and pedestrian zones achieving thermal comfort is demonstrated on a typical summer day at 3:00 pm in Hong Kong.\n","All sites with site area of 1,000m2 or more.",1,"Y",0]
["SS 11","Stormwater Management","2 credit for demonstrating that adequate stormwater management design measures have been provided to cater the total volume of runoff for one hour corresponding to a design of at least 30mm/event for the site in its post-developed conditions.","All sites with site area of 1,000m2 or more.",2,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for demonstrating that adequate stormwater management measures have been provided to cater the total volume of runoff corresponding to a design rainfall of at least 40mm/event for the site in its post-developed conditions.",null,"1B","Y",0,"B"]
["SS 12","Design for Climate Change Adaptation","1 BONUS credit for studying the projected variation in temperature and rainfall and water level rise/ storm surge of adjacent water bodies due to climate change and its impact on the development, and prepare mitigation proposal to improve the climate resilience of the building.","All buildings","1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for including quantitative calculation to support the resilience design which is technically eligible and cost effective. ",null,"1B","Y",0,"B"]
[null,null,null,null,"Credit Applicable:",{"$f":"IF(COUNTIF(F56:F91,\"Y\")=0,\" \", SUMIFS(E56:E91,E56:E91,\">0\",F56:F91,\"Y\"))","v":21}]
[null,null,null,null,"Credit Anticipated:",{"$f":"IF(COUNTIF(F56:F91,\"Y\")=0,\" \",SUMIFS(G56:G91,E56:E91,\">0\",F56:F91,\"Y\"))","v":0}]
[null,null,null,null,"Bonus Anticipated:",{"$f":"IF(COUNTIF(F56:F91,\"Y\")=0,\" \",SUMIFS(G56:G91,E56:E91,\"1B\",F56:F91,\"Y\")+SUMIFS(G56:G91,E56:E91,\"2B\",F56:F91,\"Y\"))","v":0},null,"B"]
[null,null,null,null,"Percentage of Credits Achieved:",{"$f":"IF(COUNTIF(F56:F91,\"Y\")=0,\" \",IF((F93+F94*1.2)/SUMIF(F56:F91,\"Y\",E56:E91)>100%,100%,(F93+F94*1.2)/SUMIF(F56:F91,\"Y\",E56:E91)))","v":0}]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Materials and Waste (MW)",null,null,null,{"$f":"SUM(E100:E132)&\"+\"&COUNTIF(E100:E132,\"1B\")+2*COUNTIF(E100:E132,\"2B\")+3*COUNTIF(E100:E132,\"3B\")&\"B\"","v":"14+21B"},"Y/N?"]
["MW P1","Minimum Waste Handling Facilities","Meet the minimum provisions of waste recycle facilities for the collection, sorting, storage, recycling (recovered material) and disposal (waste).","All buildings except one-single family domestic building with not more than 3 floors, or domestic part of a composite building for one single family with not more than 3 floors, or a building not normally occupied or for transient stay (e.g. pump house, sewage treatment plant, carpark building).","Required","Y","Required"]
["MW 1","Building Re-use","Compliance method 1\n1 BONUS credit for the reuse of 20% or more (by mass or volume) of existing structures (sub-structure and superstructure).\n2 BONUS credits for the reuse of 40% or more (by mass or volume) of existing structures (sub-structure and superstructure).\nFor exemplary performance, 1 ADDITIONAL BONUS credit for the reuse of 90% or more (by mass or volume) of existing structures (sub-structure and superstructure).\n\nAlternatively,\nCompliance method 2\n1 BONUS credit for the reuse of 25% or more (by surface area) of superstructure elements (including at least floor, roof decking) & enclosure materials (including at least skin, framing).\n2 BONUS credits for the reuse of 50% or more (by surface area) of superstructure elements (including at least floor, roof decking) & enclosure materials (including at least skin, framing).\nFor exemplary performance,1 ADDITIONAL BONUS credit for the reuse of 90% or more (by surface area) of superstructure elements (including at least floor, roof decking) & enclosure materials (including at least skin, framing).","All buildings ","3B","Y",0,"B"]
["MW 2","Modular and Standardised Design","1 credit for designing modular elements which contributed at least 50% (by mass, volume, dollar value or surface area) of the major elements and modules in the project.","All buildings except for a single one-storey building with total floor areas not exceeding 230m2.",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance, designing modular elements which contributed 90% or more (by mass, volume, dollar value or surface area) of the major elements and modules in the project.",null,"1B","Y",0,"B"]
["MW 3","Prefabrication","(a) Structural Elements\n1 credit when 10% of the prefabricated structural elements has been manufactured off-site.\n1 ADDITIONAL BONUS credit when 20% of the prefabricated structural elements has been manufactured off-site.\n\nAlternatively,\n(b) Façade Elements\n1 credit when 10% of the prefabricated facade elements has been manufactured off-site.\n1 ADDITIONAL BONUS credit when 20% of the prefabricated facade elements has been manufactured off-site.\n\nAlternatively,\n(c) Architectural/ Internal Building Elements\n1 credit when 10% of the prefabricated architectural/ internal building elements has been manufactured off-site.\n1 ADDITIONAL BONUS credit when 20% of the prefabricated architectural/ internal building elements has been manufactured off-site.\n","All buildings",1,"Y",0]
[null,null,null,null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for compliance with requirements listed in above sub-item (a), (b) and (c).","All buildings","1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance when 50% or more of the prefabricated elements in above sub-item (a) or (b) or (c) has been manufactured off-site.","All buildings","1B","Y",0,"B"]
["MW 4","Design for Durability and Resilience","(a)    Building Material Selection Appraisal\n1 credit for appraisal report demonstrating a proactive approach to evaluate the durability of the building materials with at least 3 of the relevant listed items. \n","All buildings",1,"Y",0]
[null,null,"(b)    Protecting Vulnerable Parts of the Building from Damage\n1 BONUS credit for providing suitable protective measures, or designed features or solutions to prevent damage to vulnerable parts.\n","All buildings","1B","Y",0,"B"]
[null,null,"(c)    Protecting Exposed Parts of the Building from Material Degradation\n1 BONUS credit for incorporating appropriate design and specification measures to limit material degradation due to environmental factors.\n","All buildings","1B","Y",0,"B"]
["MW 5","Sustainable Forest Products","1 credit for demonstrating at least 30% (for residential development) and 50% (for non-residential development) of all timber and composite timber products used in the project are from sustainable sources/ recycled timber.","All buildings, except buildings with an insignificant amount of timber products being adopted (e.g. all timber products used in the building consists of five sets of doors only).",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS for exemplary performance, for demonstrating 90% or more of all timber and composite timber products used in the project are from sustainable sources/ recycled timber.",null,"1B","Y",0,"B"]
["MW 6","Recycled Materials","(a) Outside Surface Works and Structures\n1 credit where at least 10% of all materials used for site exterior surface works, structures and features with recycled content.\n\nAlternatively,\n(b) Building Façade and Structural Components\n1 credit where at least 10% of all materials used for facade and structural components are materials with recycled content; OR\nthe use of Pulverised Fuel Ash (PFA) as a partial cement replacement in concrete that the PFA content is not less than 25%; OR \nthe use of Ground Granulated Blast furnace Slag (GGBS) as a partial cement replacement in concrete that the GGBS content is not less than 40%.\n\nAlternatively,\n(c) Interior Non-structural Components\n1 credit where at least 10% of all materials used for interior non-structural components are materials with recycled content.\n","All buildings",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for compliance with requirements listed in sub-item (a), (b) and (c).",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance, where 50% or more of all materials used for sub-item (a) or (b) or (c) are materials with recycled content. ",null,"1B","Y",0,"B"]
["MW 7","Ozone Depleting Substances","(a) Refrigerants\n1 credit for the use of refrigerants with a value less than or equal to the threshold of the combined contribution to ozone depletion and global warming potentials using the specified equation.\n","All buildings",1,"Y",0]
[null,null,"(b) Ozone Depleting Materials\n1 credit for the use of products in the building fabric and services that avoid using ozone depleting substances in their manufacture, composition or use. \n",null,1,"Y",0]
["MW 8","Regional Materials","1 credit for the use of regional materials meeting prescribed requirement, which contribute at least 10% of all building materials used in the project.","All buildings",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credits for the use of regional materials meeting prescribed requirement, which contribute at least 20% of all building materials used in the project.",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance, for the use of regional materials meeting prescribed requirement, which contribute 50% or above of all building materials used in the project.",null,"1B","Y",0,"B"]
["MW 9","Use of Green Products","(a) Certified Green Products\n1 credit for having at least 5% certified green products in one (1) of the listed categories (outside surface works, building façade and structures, interior non-structural components, and building services components). \n2 credit for having at least 5% certified green products in two (2) of the listed categories (outside surface works, building façade and structures, interior non-structural components, and building services components).\n","All buildings",2,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for having at least 5% of certified green products under Construction Industry Council (CIC) Green Product Certification, Carbon Labelling Scheme/ HKGBC Green Product Accreditation and Standards (HK G-PASS) in one (1) of the listed categories (outside surface works, building façade and structures, interior non-structural components, and building services components).",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance, for having at least 25% of certified green products under CIC Green Product Certification, Carbon Labelling Scheme/ HK G-PASS in one (1) of the listed categories (outside surface works, building façade and structures, interior non-structural components, and building services components).",null,"1B","Y",0,"B"]
[null,null,"(b) Rapidly Renewable Materials\n1 BONUS credit for demonstrating 5% of all building materials/ products of interior non-structural components in the project is rapidly renewable materials. \n",null,"1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for exemplary performance, for demonstrating 25% of all building materials/ products of interior non-structural components in the project is rapidly renewable materials.",null,"1B","Y",0,"B"]
["MW 10","Life Cycle Assessment","1 credit for demonstrating the embodied energy in the major elements of the building structure of the building has been studied and optimised through a Life Cycle Assessment (LCA).","All buildings",1,"Y",0]
["MW 11","Adaptability and Deconstruction","a) Spatial Adaptability\n1 credit for designs providing spatial flexibility that can adapt spaces for different uses, and allows for expansion to permit additional spatial requirements to be accommodated.\n\nAlternatively,\nb) Flexible Engineering Services\n1 credit for flexible design of services that can adapt to changes of layout and use.\n\nAlternatively,\nc) Structural Adaptability\n1 credit for designs providing flexibility through the use of building structural systemswhich allow for change in future use, and which is coordinated with interior planning modules.\n","All buildings",1,"Y",0]
[null,null,"1 ADDITIONAL BONUS credit for compliance with requirements listed in sub-item (a), (b) and (c).",null,"1B","Y",0,"B"]
["MW 12","Enhanced Waste Handling Facilities","(a)   Additional Recyclables Collection\n1 credit for the provision of facilities for collection, sorting, storage and disposal of 2 other recyclable streams in addition to those described in MW P1. \n","All buildings except one single family domestic building with not more than 3 floors, or domestic part of a composite building for one single family with not more than 3 floors, or a building not normally occupied or for transient stay (e.g. pump house, sewage treatment plant, carpark building).\nPart (b) is applicable only when Municipal Solid Waste Charging Scheme is activated. ",1,"Y",0]
[null,null,"(b)   Additional Facilities Provisions to Enable enhanced Municipal Solid Waste (MSW) Charging Scheme\n1 credit for additional facilities for collection, sorting, storage and disposal of recyclables in addition to those described in MW P1 and MW 12 part (a).\n",null,1,"Y",0]
[null,null,"(c)   Waste treatment equipment\n1 BONUS for providing at least one set of waste treatment equipment.\n",null,"1B","Y",0,"B"]
[null,null,"(d)    Alternatives to Recycling Facilities\n1 BONUS for provide alternative means of waste collection systems.\n",null,"1B","Y",0,"B"]
[null,null,null,null,"Credit Applicable:",{"$f":"IF(COUNTIF(F101:F132,\"Y\")=0,\" \", SUMIFS(E101:E132,E101:E132,\">0\",F101:F132,\"Y\"))","v":14}]
[null,null,null,null,"Credit Anticipated:",{"$f":"IF(COUNTIF(F101:F132,\"Y\")=0,\" \",SUMIFS(G101:G132,E101:E132,\">0\",F101:F132,\"Y\"))","v":0}]
[null,null,null,null,"Bonus Anticipated:",{"$f":"IF(COUNTIF(F101:F132,\"Y\")=0,\" \",SUMIFS(G101:G132,E101:E132,\"1B\",F101:F132,\"Y\")+SUMIFS(G101:G132,E101:E132,\"3B\",F101:F132,\"Y\"))","v":0},null,"B"]
[null,null,null,null,"Percentage of Credits Achieved:",{"$f":"IF(COUNTIF(F101:F132,\"Y\")=0,\" \",IF((F134+F135*1.2)/SUMIF(F101:F132,\"Y\",E101:E132)>100%,100%,(F134+F135*1.2)/SUMIF(F101:F132,\"Y\",E101:E132)))","v":0}]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Energy Use (EU)",null,null,null,{"$f":"SUM(E141:E156)&\"+\"&COUNTIF(E141:E156,\"1B\")+2*COUNTIF(E141:E156,\"2B\")+5*COUNTIF(E141:E156,\"5B\")&\"B\"","v":"31+13B"},"Y/N?"]
["EU P1","Minimum Energy Performance","Demonstrate performance improvement against the latest edition of Building Energy Code (BEC).\n","All buildings","Required","Y","Required"]
["EU 1","Low Carbon Passive Design","Option 1: Prescriptive Path\n4 credits for incorporating any 4 of the passive design strategies listed below:\n(1) Optimum Spatial Planning; \n(2) External Overhang (Fix/ movable); \n(3) Vegetated Building Envelope; \n(4) Cross Ventilation Provision (normanlly occupied space); \n(5) Cross Ventilation Provision (not normally occupied space);\n(6) Daylighting Provision\n\nAlternatively,\nOption 2: Performance Route (1 credit for each item)\n(1) Built Form and orientation; \n(2) Optimum spatial planning; \n(3) External shading devices; \n(4) Vegetated building envelope; \n(5) Space layout for natural ventilation\n(6) Sufficient daylight penetration\n","All buildings",6,"Y",0]
["EU 2","Reduction of CO2 Emissions","Option 1 – Performance Route (1-10 credits + 5 Bonus)\nDemonstrate a percentage of reduction on annual CO2 emission of the proposed building performance compared with the baseline performance. \n1 to 10 credits for annual CO2 emission reduction from 1% to 19%.\n1 to 5 ADDITIONAL BONUS for annual CO2 emission reduction from 21% to 29%.\n\nAlternatively,\nOption 2 – Prescriptive Route (0.5-7 credits)\nDemonstrate a prescriptive compliance in the listed item. \n(a) Passive Building Design Enhancement (0.5 to 3 credits)\n(b) Active Building Design Improvement (0.5 - 4 credits)","All buildings",10,"Y",0]
[null,null,null,null,"5B","Y",0,"B"]
["EU 3","Peak Electricity Demand Reduction","Option 1 – Performance Path (1 - 3 credits)\nBased on simulation result in EU 2 (Performance Path) to review the achieved peak reduction from 5% to 15%.\n\nAlternatively,\nOption 2 – Prescriptive Path (2 credits)\n1 credit when achieving 4 credits in EU 2 (Prescriptive Path)\n2 credits when achieving 7 credits in EU 2 (Prescriptive Path)\n","All buildings",3,"Y",0]
["EU 4","Metering and Monitoring","(a) Fundamental Metering and Monitoring\n1 credit for providing energy monitoring system of equipment and systems in spaces.\n","All Non-residential buildings and common area of residential buildings\n",1,"Y",0]
[null,null,"1 BONUS credit for providing performance auditing monitoring system for equipment and systems in spaces.\n",null,"1B","Y",0,"B"]
[null,null,"(b) Metering for Tenanted Area\n1 BONUS credit for providing monitoring provision of tenants’ energy consumption.\n",null,"1B","Y",0,"B"]
["EU 5","Renewable and Alternative Energy Systems","(a) Solar Energy Feasibility Study\n1 credit for evaluating the building roof’s potential in harnessing solar energy.\n","All buildings",1,"Y",0]
[null,null,"(b) On-site Renewable Energy Application\n1 to 5 credits for using on-site renewable energy systems to offset annual building energy consumption for controlled area to offset 0.2% to 1% energy consumption.\n",null,5,"Y",0]
[null,null,"(b) On-site Renewable Energy Application\n1 to 5 ADDITIONAL BONUS credits for using on-site renewable energy systems to offset annual building energy consumption for controlled area to offset 1.2% to 2% energy consumption.\n",null,"5B","Y",0,"B"]
["EU 6","Air-conditioning Units","(a) Compliance with Manufacturer’s Recommendation\n1 credit for complying with manufacturer’s recommended installation positions for optimal heat rejection.\n","All buildings using window or split-type air conditioners\n",1,"Y",0]
[null,null,"(b) Performance Verification\n1 credit for demonstrating the operating temperatures of all window type, split-type or packaged type air-conditioning units do not exceed manufacturer’s recommendation for the specified COP in the manufacturer’s technical specifications via computational simulation techniques.\n",null,1,"Y",0]
["EU 7","Clothes Drying Facilities","(a) Provision of Clothes Drying Facilities\n1 credit for providing permanent clothes drying facilities provision for all residential units under suitable location conditions.\n \n","Residential buildings",1,"Y",0]
[null,null,"(b) Demonstration of Effectiveness\n1 BONUS for demonstrating the effectiveness of permanent clothes drying facilities via computational analysis.\n",null,"1B","Y",0,"B"]
["EU 8","Energy Efficient Appliances","1 credit when 60% of total rated power of appliances are certified energy efficient products\n2 credit when 80% of total rated power of appliances are certified energy efficient products\n","Residential Buildings and Hotel\n",2,"Y",0]
[null,null,null,null,"Credit Applicable:",{"$f":"IF(COUNTIF(F142:F156,\"Y\")=0,\" \", SUMIFS(E142:E156,E142:E156,\">0\",F142:F156,\"Y\"))","v":31}]
[null,null,null,null,"Credit Anticipated:",{"$f":"IF(COUNTIF(F142:F156,\"Y\")=0,\" \",SUMIFS(G142:G156,E142:E156,\">0\",F142:F156,\"Y\"))","v":0}]
[null,null,null,null,"Bonus Anticipated:",{"$f":"IF(COUNTIF(F142:F156,\"Y\")=0,\" \",SUMIFS(G142:G156,E142:E156,\"1B\",F142:F156,\"Y\")+SUMIFS(G142:G156,E142:E156,\"5B\",F142:F156,\"Y\"))","v":0},null,"B"]
[null,null,null,null,"Percentage of Credits Achieved:",{"$f":"IF(COUNTIF(F142:F156,\"Y\")=0,\" \",IF((F158+F159*1.2)/SUMIF(F142:F156,\"Y\",E142:E156)>100%,100%,(F158+F159*1.2)/SUMIF(F142:F156,\"Y\",E142:E156)))","v":0}]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Water Use (WU)",null,null,null,{"$f":"SUM(E165:E177)&\"+\"&COUNTIF(E165:E177,\"1B\")&\"B\"","v":"12+3B"},"Y/N?"]
["WU P1","Minimum Water Saving Performance","Demonstrate that the use of water efficient flow devices leads to an estimated annual saving of 10%.\n","All buildings","Required","Y","Required"]
["WU 1","Annual Water Use","(a) Further Potable Water Saving\n1 credit for demonstrating that the use of water efficient flow devices leads to an estimated annual saving of 20%.\n2 credits for demonstrating that the use of water efficient flow devices leads to an estimated annual saving of 25%.\n3 credits for demonstrating that the use of water efficient flow devices leads to an estimated annual saving of 30%.","All buildings",3,"Y",0]
[null,null,"(b) Exemplary Potable Water Saving\n1 BONUS credit for demonstrating that the use of water efficient flow devices leads to an estimated annual saving of 40%.",null,"1B","Y",0,"B"]
["WU 2","Water Efficient Irrigation","1 credit for reducing potable water consumption for irrigation of at least 25% in comparison with the baseline.\n2 credits for reducing potable water consumption for irrigation of at least 50% in comparison with the baseline.","All buildings with permanent greenery and permanent irrigation system\n",2,"Y",0]
[null,null,"(b) Exemplary performance in reduction of potable water consumption for irrigation\n1 ADDITIONAL BONUS for reducing potable water consumption for irrigation by 100% in comparison with the baseline.",null,"1B","Y",0,"B"]
["WU 3","Water Efficient Appliances","1 credit for installing water efficient appliances that achieve Grade 1 under the WSD’s Water Efficiency Labelling Scheme.\n","Residential buildings",1,"Y",0]
["WU 4","Water Leakage Detection","1 credit for installing water leakage detection systems in all municipal potable water tank rooms.\n","All buildings with potable water tank rooms",1,"Y",0]
["WU 5","Twin Tank System","1 credit for providing twin tank for potable water supply system and flushing water supply system \n","All buildings and buildings with centralised/ shared tank that is outside the assessment boundary",1,"Y",0]
["WU 6","Cooling Tower Water","1 credit for achieving 7 or more cycles of concentration with acceptable water quality\n\n","All buildings equipped with cooling tower using potable water as makeup water\n",1,"Y",0]
["WU 7","Effluent Discharge to Foul Sewers","1 credit for demonstrating a reduction in annual sewage volumes by 20% or more.\n","All buildings",1,"Y",0]
["WU 8","Water Harvesting and Recycling","(a) Harvested Rainwater\n1 credit for harvesting of rainwater that achieve a reduction of 5% or more in the consumption of potable water.\n","All buildings",1,"Y",0]
[null,null,"(b) Recycled Grey Water \n1 credit for recycled grey water that achieve a reduction of 5% of more in the consumption of potable water.\n",null,1,"Y",0]
[null,null,"(c) Exemplary Water Recycling\n1 BONUS credit where harvested rainwater, recycled grey water or a combination of both leads to a reduction of 10% of more in the consumption of potable water.\n",null,"1B","Y",0,"B"]
[null,null,null,null,"Credit Applicable:",{"$f":"IF(COUNTIF(F166:F177,\"Y\")=0,\" \", SUMIFS(E166:E177,E166:E177,\">0\",F166:F177,\"Y\"))","v":12}]
[null,null,null,null,"Credit Anticipated:",{"$f":"IF(COUNTIF(F166:F177,\"Y\")=0,\" \",SUMIFS(G166:G177,E166:E177,\">0\",F166:F177,\"Y\"))","v":0}]
[null,null,null,null,"Bonus Anticipated:",{"$f":"IF(COUNTIF(F166:F177,\"Y\")=0,\" \",SUMIFS(G166:G177,E166:E177,\"1B\",F166:F177,\"Y\"))","v":0},null,"B"]
[null,null,null,null,"Percentage of Credits Achieved:",{"$f":"IF(COUNTIF(F166:F177,\"Y\")=0,\" \",IF((F179+F180*1.2)/SUMIF(F166:F177,\"Y\",E166:E177)>100%,100%,(F179+F180*1.2)/SUMIF(F166:F177,\"Y\",E166:E177)))","v":0}]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Health and Wellbeing (HWB)",null,null," ",{"$f":"SUM(E186:E211)&\"+\"&(COUNTIF(E186:E211,\"1B\")+2*COUNTIF(E186:E211,\"2B\")&\"B\")","v":"19+10B"},"Y/N?"]
["HWB P1","Minimum Ventilation Performance","(a) Measure outdoor air pollutants on-site prior to building design to understand the site conditions.\n(b) Demonstrate the project is in compliance with the minimum ventilation quantity with respective to its designed ventilation mode.\n\n","All buildings","Required","Y","Required"]
["HWB 1","Healthy and Active Living","1 BONUS credit for scoring at least 3 items of all applicable design measures for healthy and active living.\n","Indoor / semi-outdoor communal areas of building development\n","1B","Y",0,"B"]
["HWB 2","Biophilic Design","1 BONUS credit for demonstrating visual connection with nature and/ or biophilic design features at an assessment space with Visual Quality Score of 2 or above.\n","All buildings","1B","Y",0,"B"]
[null,null,"1 ADDITIONAL BONUS credit for demonstrating visual connection with nature and/ or biophilic design features at an assessment space with Visual Quality Score of 3 or above.\n",null,"1B","Y",0,"B"]
["HWB 3","Inclusive Design","(a) Universal Accessibility\n1 credit for providing at least ten (10) applicable enhanced provisions as stipulated in the “Recommended Design Requirements” of BFA 2008.\n","All buildings",1,"Y",0]
[null,null,"(b) Weather Protection & Family Friendly Facilities\n1 BONUS credit for providing prescribed weather protection and at least two (2) family friendly facilities features.\n",null,"1B","Y",0,"B"]
["HWB 4","Enhanced Ventilation","(a)  Fresh Air Provision\n1.1 Fresh air provision in normally occupied spaces\n1 credit for demonstrating that all normally occupied spaces in the building are provided with increased ventilation.\n","All buildings",1,"Y",0]
[null,null,"1.2 Fresh air provision in not normally occupied spaces\n1 credit for demonstrating that all not normally occupied spaces in the building are provided with adequate ventilation.\n",null,1,"Y",0]
[null,null,"1.3 On-site measurements\n1 ADDITIONAL BONUS credit for conducting on-site measurements to verify the ventilation performance for all normally occupied spaces.\n",null,"1B","Y",0,"B"]
[null,null,"(b) Exhaust air\n1 credit for the provision of an adequate ventilation system for spaces where significant indoor pollution sources are generated.\n",null,1,"Y",0]
["HWB 5","Waste Odour Control","1 credit for installing odour sensor at all discharge points from enclosed waste disposal and recycling spaces.\n","All buildings",1,"Y",0]
["HWB 6","Acoustic and Noise","(a) Room Acoustics\n(1) 1 credit for demonstrating that mid-frequency reverberation time in applicable spaces of landlord’s-controlled area meets the prescribed criteria of different types of premises.\n","All buildings ",1,"Y",0]
[null,null,"(2) 1 credit for demonstrating that mid-frequency reverberation time in applicable rooms of non-landlord area meets the prescribed criteria of different types of premises.\n","All buildings with tenanted spaces",1,"Y",0]
[null,null,"(b) Noise Isolation\n(1) 1 credit for demonstrating airborne noise isolation between, spaces fulfils the prescribed criteria. \n","All buildings ",1,"Y",0]
[null,null,"(2) 1 BONUS for demonstrating impact noise isolation between floors fulfills the prescribed criteria.\n","Residential buildings ","1B","Y",0,"B"]
[null,null,"(c) Background Noise \n1 credit for demonstrating background noise levels within the presecribed criteria (including traffic noise and external building services equipment that are within the project boundary).","All buildings ",1,"Y",0]
["HWB 7","Indoor Vibration","1 credit for demonstrating vibration levels not exceeding the prescribed criteria.\n","All buildings ",1,"Y",0]
["HWB 8","IAQ Monitoring","(a) Indoor Air Quality in Occupied Spaces\n1.1 Path 1\n2 credit for demonstrating compliance with the prescribed limits for Carbon monoxide (CO), Nitrogen dioxide (NO2), Ozone (O3), Carbon dioxide (CO2), Respirable suspended particulates (PM10),Total volatile organic compounds (TVOCs), Formaldehyde (HCHO) and Radon (Rn) in the sampled occupied spaces.\n\n1 credit for demonstrating compliance with the prescribed limits for Airborne bacteria and conduct the Mould assessment in the sampled occupied spaces.\n\n1.2 Path 2\n3 credits for submitting a valid IAQ Certification Scheme (Good Class) certificate issued by the Environmental Protection Department (EPD) covering the whole building.\n\n","All buildings ",3,"Y",0]
[null,null,"1.2 Path 2\n1 ADDITION BONUS credit for submitting a valid IAQ Certification Scheme (Excellent Class) certificate issued by the Environmental Protection Department (EPD) covering the whole building.",null,"1B","Y",0,"B"]
[null,null,"(b) Air Quality in Car Park\n1 credit for demonstrating compliance with the pollutant concentration limits specified in ProPECC PN 2/96.","All buildings with enclosed and/ or semi-enclosed car park of areas more than 10% of Construction Floor Area",1,"Y",0]
["HWB 9","Thermal Comfort","(a) Thermal Comfort Analysis\n2 credits for conducting thermal comfort analysis and demonstrate that normally occupied spaces can fulfil the thermal comfort requirements.\n","All buildings ",2,"Y",0]
[null,null,"(b) Thermal Comfort Measurement\n1 ADDITIONAL BONUS credit for conducting on-site measurements to verify the thermal comfort performance.\n",null,"1B","Y",0,"B"]
["HWB 10","Artificial Lighting","(a) Artificial lighting in normally occupied spaces\n1 credit for achieving the prescribed lighting performance in normally occupied spaces.\n","All buildings ",1,"Y",0]
[null,null,"(b) Artificial lighting in not normally occupied spaces and unoccupied spaces \n1 credit for achieving the prescribed lighting performance in not normally occupied spaces and unoccupied spaces.\n",null,1,"Y",0]
["HWB 11","Daylight","2 BONUS credits for demonstrating at least 55% of the total area of the studied normally occupied spaces achieves spatial Daylight Autonomy300/50% (sDA300/50%) and no more than 10% of the same area receives Annual Sunlight Exposure100,250 (ASE1000, 250).\n","Residential, office and education buildings.\n","2B","Y",0,"B"]
["HWB 12","Biological Contamination","1 credit for complying with the recommendations given in the Code of Practice for Prevention of Legionnaires’ Disease 2016 Edition in respect of Water Supply Systems, HVAC Systems and other Water Features.\n","All buildings ",1,"Y",0]
[null,null,null,null,"Credit Applicable:",{"$f":"IF(COUNTIF(F187:F211,\"Y\")=0,\" \", SUMIFS(E187:E211,E187:E211,\">0\",F187:F211,\"Y\"))","v":19}]
[null,null,null,null,"Credit Anticipated:",{"$f":"IF(COUNTIF(F187:F211,\"Y\")=0,\" \",SUMIFS(G187:G211,E187:E211,\">0\",F187:F211,\"Y\"))","v":0}]
[null,null,null,null,"Bonus Anticipated:",{"$f":"IF(COUNTIF(F187:F211,\"Y\")=0,\" \",SUMIFS(G187:G211,E187:E211,\"1B\",F187:F211,\"Y\")+SUMIFS(G187:G211,E187:E211,\"2B\",F187:F211,\"Y\"))","v":0},null,"B"]
[null,null,null,null,"Percentage of Credits Achieved:",{"$f":"IF(COUNTIF(F187:F211,\"Y\")=0,\" \",IF((F213+F214*1.2)/SUMIF(F187:F211,\"Y\",E187:E211)>100%,100%,(F213+F214*1.2)/SUMIF(F187:F211,\"Y\",E187:E211)))","v":0}]
[]
[null,"Section","Credit Requirement","Extent of Application","Credit Attainable","Credit Applicable","Credit Anticipated",null,"Responsible Party/ Discipline",null,null,null,null,"Remarks"]
[]
["Innovations and Additions (IA)",null,null,null,"10B","Y/N?",{"$f":"SUM(G220:G220)","v":0}]
["IA 1","Innovations and Additions","1 Bonus credit for each of the application of  new practice, technologies and/ or techniques that are (1) not described in this manual; or (2) not market mainstream implementation; or (3) multiple aspect achievement; and the associated benefits in addressing sustainability objectives for new buildings (Maximum 10 BONUS credits in this Section)","All buildings","10B","Y",0,"B"]
[null,null,null,null,null," "]

{"sheet":"Project Score Result","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,0,10,4],[11,0,11,4]]}
[]
[]
["Category","Applicable Credits \n(A)","Achieved Credits \n(B)","% of Achieved Credit \n(C)","Category Weighting \n(D)","Weighted Achieved Score \n(E)","Flat for 10% - 20%"]
[{"$f":"'Credit Checklist'!A5","v":"Integrated Design & Construction Management (IDCM)"},{"$f":"'Credit Checklist'!F47","v":25},{"$f":"IF('Credit Checklist'!F48=\" \",\" \",'Credit Checklist'!F48&\"+\"&'Credit Checklist'!F49&\"B\")","v":"0+0B"},{"$f":"'Credit Checklist'!F50","v":0},0.18,{"$f":"IF(D4=\" \", \" \",D4*E4)","v":0},{"$f":"IF(AND(D4>=20%,D4>=10%),0,1)","v":1}]
[{"$f":"'Credit Checklist'!A54","v":"Sustainable Site (SS)"},{"$f":"'Credit Checklist'!F92","v":21},{"$f":"IF('Credit Checklist'!F93=\" \",\" \",'Credit Checklist'!F93&\"+\"&'Credit Checklist'!F94&\"B\")","v":"0+0B"},{"$f":"'Credit Checklist'!F95","v":0},0.15,0,{"$f":"IF(AND(D5>=20%,D5>=10%),0,1)","v":1}]
[{"$f":"'Credit Checklist'!A99","v":"Materials and Waste (MW)"},{"$f":"'Credit Checklist'!F133","v":14},{"$f":"IF('Credit Checklist'!F134=\" \",\" \",'Credit Checklist'!F134&\"+\"&'Credit Checklist'!F135&\"B\")","v":"0+0B"},{"$f":"'Credit Checklist'!F136","v":0},0.09,0,1]
[{"$f":"'Credit Checklist'!A140","v":"Energy Use (EU)"},{"$f":"'Credit Checklist'!F157","v":31},{"$f":"IF('Credit Checklist'!F158=\" \",\" \",'Credit Checklist'!F158&\"+\"&'Credit Checklist'!F159&\"B\")","v":"0+0B"},{"$f":"'Credit Checklist'!F160","v":0},0.28999999999999998,0,1]
[{"$f":"'Credit Checklist'!A164","v":"Water Use (WU)"},{"$f":"'Credit Checklist'!F178","v":12},{"$f":"IF('Credit Checklist'!F179=\" \",\" \",'Credit Checklist'!F179&\"+\"&'Credit Checklist'!F180&\"B\")","v":"0+0B"},{"$f":"'Credit Checklist'!F181","v":0},7.0000000000000007E-2,0,1]
[{"$f":"'Credit Checklist'!A185","v":"Health and Wellbeing (HWB)"},{"$f":"'Credit Checklist'!F212","v":19},{"$f":"IF('Credit Checklist'!F213=\" \",\" \",'Credit Checklist'!F213&\"+\"&'Credit Checklist'!F214&\"B\")","v":"0+0B"},{"$f":"'Credit Checklist'!F215","v":0},0.22,0,{"$f":"IF(AND(D9>=20%,D9>=10%),0,1)","v":1}]
[{"$f":"'Credit Checklist'!A219","v":"Innovations and Additions (IA)"},null,{"$f":"IF('Credit Checklist'!G220=0, \" \", 'Credit Checklist'!G220)","v":" "},null,null,{"$f":"IF(C10=\" \", \" \", C10/100)","v":" "}]
["Overall Score",null,null,null,null,{"$f":"IF(SUM(F4:F10)=0, \" \", SUM(F4:F10))","v":" "},{"$f":"SUM(G4:G9)","v":6}]
["Overall Rating",null,null,null,null,{"$f":"IF(F11=\" \",\" \",IF(G11>0,\"Prerequisite Achieved\",IF(OR(F11>0.75,F11=0.75),\"Platinum\",IF(OR(F11>0.65,F11=0.65),\"Gold\",IF(OR(F11>0.55,F11=0.55),\"Silver\",IF(OR(F11>0.4,F11=0.4),\"Bronze\",IF(OR(F11>0.2,F11=0.2),\"Prerequisite Achieved\",\"c\")))))))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"  "]

{"sheet":"Target Rating_BSL","index":3,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,"Applicant Summary"]
[null,"Category","Applicable Credits","Achieved Credits","% of Achieved Credits","Category Weight Factor","Weighted Achieved Score","Achieved Sub-Rating"]
[null,"Site Aspects",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C3>0,IF(D3>0,(D3/C3),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.25,{"$f":"IF(E3<>\"NA\",E3*F3*100,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(E3=\"NA\",\"NA\",IF(E3>=0.7,\"Platinum\",IF(E3>=0.6,\"Gold\",IF(E3>=0.5,\"Silver\",IF(E3>=0.4,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H3=\"NA\",1,IF(H3=\"Platinum\",5,IF(H3=\"Gold\",4,IF(H3=\"Silver\",3,IF(H3=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Materials Aspects",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C4>0,IF(D4>0,(D4/C4),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.08,{"$f":"IF(E4<>\"NA\",E4*F4*100,\"NA\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Energy Use",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C5>0,IF(D5>0,(D5/C5),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.35,{"$f":"IF(E5<>\"NA\",E5*F5*100,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(E5=\"NA\",\"NA\",IF(E5>=0.7,\"Platinum\",IF(E5>=0.6,\"Gold\",IF(E5>=0.5,\"Silver\",IF(E5>=0.4,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H5=\"NA\",1,IF(H5=\"Platinum\",5,IF(H5=\"Gold\",4,IF(H5=\"Silver\",3,IF(H5=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Water Use",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C6>0,IF(D6>0,(D6/C6),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.12,{"$f":"IF(E6<>\"NA\",E6*F6*100,\"NA\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Indoor Environmental Quality",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C7>0,IF(D7>0,(D7/C7),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.2,{"$f":"IF(E7<>\"NA\",E7*F7*100,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(E7=\"NA\",\"NA\",IF(E7>=0.7,\"Platinum\",IF(E7>=0.6,\"Gold\",IF(E7>=0.5,\"Silver\",IF(E7>=0.4,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H7=\"NA\",1,IF(H7=\"Platinum\",5,IF(H7=\"Gold\",4,IF(H7=\"Silver\",3,IF(H7=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Innovations and Additions",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,1,{"$f":"D8","v":{"$error":"#REF!"}},{"$f":"IF(G8=\"\",\"Unclassified\",IF(G8>=3,\"Platinum\",IF(G8>=2,\"Gold\",IF(G8>=1,\"Silver\",IF(G8=0,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H8=\"NA\",1,IF(H8=\"Platinum\",5,IF(H8=\"Gold\",4,IF(H8=\"Silver\",3,IF(H8=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(L3:L7,\"Blank\")<5,\"OK\",\"Blank\")","v":"OK"}]
[null,null,null,null,null,"Sub Rating",{"$f":"SUM(G3:G8)","v":{"$error":"#REF!"}},{"$f":"IF(G9=0,\"NA\",IF(G9>=75,\"Platinum\",IF(G9>=65,\"Gold\",IF(G9>=55,\"Silver\",IF(G9>=40,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H9=\"NA\",1,IF(H9=\"Platinum\",5,IF(H9=\"Gold\",4,IF(H9=\"Silver\",3,IF(H9=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Overall Rating",{"$f":"+G9","v":{"$error":"#REF!"}},{"$f":"IF(J10<>9,\"Canot be Assessed\",IF(K10=1,\"Unclassified\",IF(K10=2,\"Bronze\",IF(K10=3,\"Silver\",IF(K10=4,\"Gold\",IF(K10=5,\"Platinum\",\"NA\"))))))","v":{"$error":"#REF!"}},null,{"$f":"COUNTIF(#REF!,\"OK\")","v":{"$error":"#REF!"}},{"$f":"MIN(K3:K9)","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(L3:L7,\"Blank\")>0,\"Blank\",\"OK\")","v":"OK"}]
[]
[]
[]
[null,"BAS Summary"]
[null,"Category","Applicable Credits","Achieved Credits","% of Achieved Credits","Category Weight Factor","Weighted Achieved Score","Achieved Sub-Rating"]
[null,"Site Aspects",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C16>0,IF(D16>0,(D16/C16),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.25,{"$f":"IF(E16<>\"NA\",E16*F16*100,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(E16=\"NA\",\"NA\",IF(E16>=0.7,\"Platinum\",IF(E16>=0.6,\"Gold\",IF(E16>=0.5,\"Silver\",IF(E16>=0.4,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H16=\"NA\",1,IF(H16=\"Platinum\",5,IF(H16=\"Gold\",4,IF(H16=\"Silver\",3,IF(H16=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Materials Aspects",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C17>0,IF(D17>0,(D17/C17),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.08,{"$f":"IF(E17<>\"NA\",E17*F17*100,\"NA\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Energy Use",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C18>0,IF(D18>0,(D18/C18),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.35,{"$f":"IF(E18<>\"NA\",E18*F18*100,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(E18=\"NA\",\"NA\",IF(E18>=0.7,\"Platinum\",IF(E18>=0.6,\"Gold\",IF(E18>=0.5,\"Silver\",IF(E18>=0.4,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H18=\"NA\",1,IF(H18=\"Platinum\",5,IF(H18=\"Gold\",4,IF(H18=\"Silver\",3,IF(H18=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Water Use",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C19>0,IF(D19>0,(D19/C19),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.12,{"$f":"IF(E19<>\"NA\",E19*F19*100,\"NA\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Indoor Environmental Quality",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C20>0,IF(D20>0,(D20/C20),\"NA\"),\"NA\")","v":{"$error":"#REF!"}},0.2,{"$f":"IF(E20<>\"NA\",E20*F20*100,\"NA\")","v":{"$error":"#REF!"}},{"$f":"IF(E20=\"NA\",\"NA\",IF(E20>=0.7,\"Platinum\",IF(E20>=0.6,\"Gold\",IF(E20>=0.5,\"Silver\",IF(E20>=0.4,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H20=\"NA\",1,IF(H20=\"Platinum\",5,IF(H20=\"Gold\",4,IF(H20=\"Silver\",3,IF(H20=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(#REF!,\"Blank\")>0,\"Blank\",\"OK\")","v":{"$error":"#REF!"}}]
[null,"Innovations and Additions",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,1,{"$f":"D21","v":{"$error":"#REF!"}},{"$f":"IF(G21=\"\",\"Unclassified\",IF(G21>=3,\"Platinum\",IF(G21>=2,\"Gold\",IF(G21>=1,\"Silver\",IF(G21=0,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H21=\"NA\",1,IF(H21=\"Platinum\",5,IF(H21=\"Gold\",4,IF(H21=\"Silver\",3,IF(H21=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(L16:L20,\"Blank\")<5,\"OK\",\"Blank\")","v":"OK"}]
[null,null,null,null,null,"Sub Rating",{"$f":"SUM(G16:G21)","v":{"$error":"#REF!"}},{"$f":"IF(G22=0,\"NA\",IF(G22>=75,\"Platinum\",IF(G22>=65,\"Gold\",IF(G22>=55,\"Silver\",IF(G22>=40,\"Bronze\",\"Unclassified\")))))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(H22=\"NA\",1,IF(H22=\"Platinum\",5,IF(H22=\"Gold\",4,IF(H22=\"Silver\",3,IF(H22=\"Bronze\",2,1)))))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Overall Rating",{"$f":"+G22","v":{"$error":"#REF!"}},{"$f":"IF(J23<>9,\"Canot be Assessed\",IF(K23=1,\"Unclassified\",IF(K23=2,\"Bronze\",IF(K23=3,\"Silver\",IF(K23=4,\"Gold\",IF(K23=5,\"Platinum\",\"NA\"))))))","v":{"$error":"#REF!"}},null,{"$f":"COUNTIF(#REF!,\"OK\")","v":{"$error":"#REF!"}},{"$f":"MIN(K16:K22)","v":{"$error":"#REF!"}},{"$f":"IF(COUNTIF(L16:L20,\"Blank\")>0,\"Blank\",\"OK\")","v":"OK"}]

{"sheet":"pull down list","index":4,"n_rows":19,"n_cols":42,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Defined Names","areat","ac","area","yn","prereq","prereq_b","sco_1","sco_1_b","sco_2","sco_2_b","sco_3","sco_3_b","sco_5","sco_5_b","sco_15","sco_15_b","sco_bon","sco_bon_b","sco_6","sco_6_b",null,"sco_1_a","sco_2_a","sco_3_a","sco_5_a","sco_15_a",0,null,"Assessment Tools",null,"project type",null,"rank",null,null,null,null,null,"If"]
[null,"Carpark ","Central A/C","Area A",null,"PR","PR","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",null,"NA","NA","NA","NA","NA","NA",null,null,null,null,null,{"$f":"'Summary (NB2.0)'!F29","v":"00:00:00"},{"$f":"'Summary (NB2.0)'!F30","v":"00:00:00"},{"$f":"RANK(AH2,$AH$2:$AI$4)","v":1},1,{"$f":"AJ2-AK2","v":0},null,{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(AND(AN2<>0,AO2>AN2),1,0)","v":{"$error":"#REF!"}}]
[null,"Clubhouse ","Chiller","Area B","Yes","NA","NA","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS","NS",null,1,2,3,5,15,6,null,"New Building Version 2.0",null,"Provisional Assessment (PA)",null,{"$f":"'Summary (NB2.0)'!F35","v":"00:00:00"},{"$f":"'Summary (NB2.0)'!F36","v":"00:00:00"},1,1,{"$f":"AJ3-AK3","v":0},null,{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(AND(AN3<>0,AO3>AN3),1,0)","v":{"$error":"#REF!"}}]
[null,"Educational","Mechnical Vent","Area C","No",null,0,1,1,2,2,3,3,5,5,15,15,"1B","1B",6,6,null,null,1,2,4,14,5,null,null,null,"Preliminary Final Assessment (PFA)",null,{"$f":"'Summary (NB2.0)'!F41","v":"00:00:00"},{"$f":"'Summary (NB2.0)'!F42","v":"00:00:00"},1,1,0,null,{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Hotel","Split Type A/C","Area D",null,null,null,null,0,1,1,2,2,4,4,14,14,null,0,5,5,null,null,null,1,3,13,4,null,null,null,"Final Assessment (FA)",null,null,null,null,null,{"$f":"SUM(AL2:AL4)","v":0},null,{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Summary (NB2.0)'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Industrial","VRV",null,null,null,null,null,null,null,0,1,1,3,3,13,13,null,null,4,4,null,null,null,null,2,12,3,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP2:AP5)","v":{"$error":"#REF!"}}]
[null,"Residential","Windows Type A/C",null,null,null,null,null,null,null,null,null,0,2,2,12,12,null,null,3,3,null,null,null,null,1,11,2]
[null,"Retail","VRV & fresh air",null,null,null,null,null,null,null,null,null,null,1,1,11,11,null,null,2,2,null,null,null,null,null,10,1]
[null,null,"To be provided by future tenant",null,null,null,null,null,null,null,null,null,null,null,0,10,10,null,null,1,1,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,9,null,null,null,0,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,8,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,7,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]