{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["detail(NB1.2)","Credit Summary","Target Rating_BSL","Target Rating","pull down list"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"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":"detail(NB1.2)","index":0,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[38,3,38,8],[67,2,67,8],[50,2,50,8],[63,4,63,5],[64,4,64,5],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[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 V1.1 & 1.2)"]
[]
[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²  "]
[]
[null,"9.","Area Weighting Method"]
[]
[null,null,"Category","Type of Area","Ventilation System",null,"CFA Area (m²)","GFA Area as shown in GBP (m²)","% Area"]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G61),\"\",G61/$G$65)","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G62),\"\",G62/$G$65)","v":""}]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,""]
[null,null,null,null,"Total Area (m²)",null,{"$f":"SUM(G61:G64)","v":0},{"$f":"SUM(H61:H64)","v":0}]
[]
[null,null,"9a) Explaination for Area which has a larger GFA than its CFA:"]

{"sheet":"Credit Summary","index":1,"n_rows":190,"n_cols":33,"rows_kept":190,"cut":false,"hidden":false,"merged":[[18,5,18,8],[18,9,18,12],[18,13,18,16],[18,17,18,20],[66,4,68,4],[61,4,65,4],[57,4,60,4],[21,5,21,8],[21,9,21,12],[22,5,22,8],[22,9,22,12],[23,5,23,8],[23,9,23,12],[32,5,32,8],[32,9,32,12],[33,5,33,8],[33,9,33,12],[34,5,34,8],[34,9,34,12],[27,5,27,7],[27,9,27,11],[30,5,30,8],[30,9,30,12],[31,5,31,8],[104,1,104,3],[144,1,144,3],[2,5,2,8],[2,9,2,12],[3,5,3,8],[3,9,3,12],[4,5,4,8],[4,9,4,12],[8,5,8,8],[8,9,8,12],[9,5,9,8],[9,9,9,12],[10,5,10,8],[10,9,10,12],[5,5,5,8],[5,9,5,12],[6,5,6,8],[6,9,6,12],[7,5,7,8],[7,9,7,12],[11,5,11,8],[11,9,11,12],[12,5,12,8],[12,9,12,12],[13,5,13,8],[13,9,13,12],[2,1,2,3],[30,1,30,3],[91,1,91,3],[55,1,55,3],[17,5,17,8],[17,9,17,12],[19,5,19,8],[19,9,19,12],[20,5,20,8],[20,9,20,12],[14,5,14,8],[14,9,14,12],[15,5,15,8],[15,9,15,12],[16,5,16,8],[16,9,16,12],[24,5,24,8],[24,9,24,12],[25,5,25,8],[25,9,25,12],[26,5,26,8],[26,9,26,12],[31,9,31,12],[38,5,38,8],[38,9,38,12],[39,5,39,8],[39,9,39,12],[40,5,40,8],[40,9,40,12],[35,5,35,8],[35,9,35,12],[36,5,36,8],[36,9,36,12],[37,5,37,8],[37,9,37,12],[44,5,44,8],[44,9,44,12],[45,5,45,8],[45,9,45,12],[46,5,46,8],[46,9,46,12],[41,5,41,8],[41,9,41,12],[42,5,42,8],[42,9,42,12],[43,5,43,8],[43,9,43,12],[50,5,50,8],[50,9,50,12],[51,5,51,8],[51,9,51,12],[52,5,52,7],[52,9,52,11],[47,5,47,8],[47,9,47,12],[48,5,48,8],[48,9,48,12],[49,5,49,8],[49,9,49,12],[55,5,55,8],[55,9,55,12],[56,5,56,8],[56,9,56,12],[70,5,70,8],[70,9,70,12],[100,5,100,8],[100,9,100,12],[101,5,101,8],[101,9,101,12],[97,5,97,8],[97,9,97,12],[98,5,98,8],[98,9,98,12],[99,5,99,8],[99,9,99,12],[94,5,94,8],[94,9,94,12],[95,5,95,8],[95,9,95,12],[96,5,96,8],[96,9,96,12],[91,5,91,8],[91,9,91,12],[105,5,105,8],[105,9,105,12],[123,5,123,8],[123,9,123,12],[130,5,130,8],[130,9,130,12],[81,5,81,8],[81,9,81,12],[88,5,88,7],[88,9,88,11],[104,5,104,8],[104,9,104,12],[102,5,102,7],[102,9,102,11],[92,5,92,8],[92,9,92,12],[93,5,93,8],[93,9,93,12],[148,9,148,11],[145,5,145,8],[145,9,145,12],[146,5,146,8],[146,9,146,12],[147,5,147,8],[147,9,147,12],[134,5,134,8],[134,9,134,12],[141,5,141,7],[141,9,141,11],[144,5,144,8],[144,9,144,12],[2,13,2,16],[2,17,2,20],[3,13,3,16],[4,13,4,16],[5,13,5,16],[6,13,6,16],[7,13,7,16],[8,13,8,16],[9,13,9,16],[3,17,3,20],[4,17,4,20],[5,17,5,20],[6,17,6,20],[7,17,7,20],[8,17,8,20],[9,17,9,20],[12,17,12,20],[13,17,13,20],[14,17,14,20],[15,17,15,20],[16,17,16,20],[17,17,17,20],[19,17,19,20],[10,13,10,16],[11,13,11,16],[12,13,12,16],[13,13,13,16],[14,13,14,16],[15,13,15,16],[16,13,16,16],[17,13,17,16],[19,13,19,16],[10,17,10,20],[11,17,11,20],[20,17,20,20],[21,17,21,20],[22,17,22,20],[23,17,23,20],[24,17,24,20],[25,17,25,20],[26,17,26,20],[30,13,30,16],[30,17,30,20],[20,13,20,16],[21,13,21,16],[22,13,22,16],[23,13,23,16],[24,13,24,16],[25,13,25,16],[26,13,26,16],[27,13,27,15],[27,17,27,19],[40,13,40,16],[41,13,41,16],[42,13,42,16],[43,13,43,16],[44,13,44,16],[45,13,45,16],[46,13,46,16],[47,13,47,16],[48,13,48,16],[31,13,31,16],[32,13,32,16],[33,13,33,16],[34,13,34,16],[35,13,35,16],[36,13,36,16],[37,13,37,16],[38,13,38,16],[39,13,39,16],[31,17,31,20],[32,17,32,20],[33,17,33,20],[34,17,34,20],[35,17,35,20],[36,17,36,20],[37,17,37,20],[38,17,38,20],[39,17,39,20],[40,17,40,20],[41,17,41,20],[42,17,42,20],[43,17,43,20],[44,17,44,20],[45,17,45,20],[46,17,46,20],[47,17,47,20],[48,17,48,20],[49,17,49,20],[50,17,50,20],[51,17,51,20],[91,13,91,16],[91,17,91,20],[92,13,92,16],[93,13,93,16],[94,13,94,16],[95,13,95,16],[49,13,49,16],[50,13,50,16],[51,13,51,16],[92,17,92,20],[93,17,93,20],[94,17,94,20],[95,17,95,20],[52,13,52,15],[70,13,70,16],[81,13,81,16],[55,13,55,16],[55,17,55,20],[56,13,56,16],[88,13,88,15],[52,17,52,19],[102,17,102,19],[88,17,88,19],[141,17,141,19],[104,13,104,16],[104,17,104,20],[105,13,105,16],[105,17,105,20],[123,13,123,16],[123,17,123,20],[134,13,134,16],[134,17,134,20],[130,13,130,16],[130,17,130,20],[102,13,102,15],[141,13,141,15],[56,17,56,20],[70,17,70,20],[81,17,81,20],[96,17,96,20],[97,17,97,20],[98,17,98,20],[99,17,99,20],[101,13,101,16],[101,17,101,20],[100,17,100,20],[96,13,96,16],[97,13,97,16],[98,13,98,16],[99,13,99,16],[100,13,100,16],[148,17,148,19],[144,13,144,16],[144,17,144,20],[145,13,145,16],[146,13,146,16],[147,13,147,16],[145,17,145,20],[146,17,146,20],[147,17,147,20]]}
[6,"Credit Summary"]
[]
[null,"Site Aspects",null,null,"Submission Template","Credits Applicable",null,null,null,"Credits \nSubmitted",null,null,null,"BAS\nCredits Applicable",null,null,null,"BAS\nCredits Achieved",null,null,null,"BAS Remarks"]
[null,"SA P1",null,"Minimum Landscaping Area",null,{"$f":"IF(J4=\"NA\",\"NA\",\"PR\")","v":"PR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J4),\"Blank\",IF(J4<>\"PR\",IF(J4<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R4),\"Blank\",IF(R4<>\"PR\",IF(R4<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"SA 1 ","BONUS","Contaminated Land",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"SA 2a",null,"Local Transport - Car Parking Provisions",null,{"$f":"IF(J6=\"NA\",\"NA\",2)","v":2}]
[null,"SA 2b",null,"Local Transport - Public Transport",null,{"$f":"IF(J7=\"NA\",\"NA\",1)","v":1}]
[null,"SA 3a",null,"Neighbourhood Amenities - Provision of Basic Services",null,{"$f":"IF(J8=\"NA\",\"NA\",1)","v":1}]
[null,"SA 3b",null,"Neighbourhood Amenities - Neighbourhood Recreational Facilities",null,1]
[null,"SA 3c",null,"Neighbourhood Amenities - Provision of Basic Services/Recreational Facilities",null,1]
[null,"SA 4",null,"Site Design Appraisal",null,1]
[null,"SA 4","BONUS","Site Design Appraisal",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"SA 5","BONUS","Ecological Impact",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"SA 6",null,"Cultural Heritage",null,{"$f":"IF(J14=\"NA\",\"NA\",1)","v":1}]
[null,"SA 7a",null,"Landscaping and Planters - Hard Landscaping",null,{"$f":"IF(J15=\"NA\",\"NA\",1)","v":1}]
[null,"SA 7b",null,"Landscaping and Planters - Soft Landscaping",null,{"$f":"IF(J16=\"NA\",\"NA\",2)","v":2}]
[null,"SA 8a",null,"Microclimate around Buildings - Wind Amplification",null,{"$f":"IF(J17=\"NA\",\"NA\",1)","v":1}]
[null,"SA 8b (i)",null,"Microclimate around Buildings - Elevated Temperatures (non-roof impervious surfaces)",null,1]
[null,"SA 8b (ii)",null,"Microclimate around Buildings - Elevated Temperatures (high emissivity roofing)",null,1]
[null,"SA 8c",null,"Microclimate around Buildings - Air Ventilation Assessment",null,1]
[null,"SA 9",null,"Neighbourhood Daylight Access",null,1]
[null,"SA 10",null,"Environmental Management Plan",null,1]
[null,"SA 11",null,"Air Pollution during Construction",null,1]
[null,"SA 12",null,"Noise during Construction",null,1]
[null,"SA 13",null,"Water Pollution during Construction",null,1]
[null,"SA 14",null,"Noise from Building Equipment",null,1]
[null,"SA 15",null,"Light Pollution",null,1]
[null,null,null,null,null,"Applicable Credits",null,null,{"$f":"SUM(F6:I11,F14:I27)","v":22},"Submitted Credits",null,null,{"$f":"SUM(J6:M11,J14:M27)","v":0},"Applicable Credits",null,null,{"$f":"SUM(N6:Q11,N14:Q27)","v":0},"Submitted Credits",null,null,{"$f":"SUM(R6:U11,R14:U27)","v":0}]
[]
[]
[null,"Materials Aspects",null,null,"Submission Template","Credits Applicable",null,null,null,"Credits \nSubmitted",null,null,null,"BAS\nCredits Applicable",null,null,null,"BAS\nCredits Achieved",null,null,null,"BAS Remarks"]
[null,"MA P1",null,"Timber Used for Temporary Works",null,{"$f":"IF(J32=\"NA\",\"NA\",\"PR\")","v":"PR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J32),\"Blank\",IF(J32<>\"PR\",IF(J32<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R32),\"Blank\",IF(R32<>\"PR\",IF(R32<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"MA P2",null,"Use of Non-CFC Based Refrigerants",null,"PR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J33),\"Blank\",IF(J33<>\"PR\",IF(J33<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R33),\"Blank\",IF(R33<>\"PR\",IF(R33<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"MA P3 ",null,"Construction and Demolition Waste Management Plan",null,"PR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J34),\"Blank\",IF(J34<>\"PR\",IF(J34<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R34),\"Blank\",IF(R34<>\"PR\",IF(R34<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"MA P4",null,"Waste Recycling Facilities",null,{"$f":"IF(J35=\"NA\",\"NA\",\"PR\")","v":"PR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J35),\"Blank\",IF(J35<>\"PR\",IF(J35<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R35),\"Blank\",IF(R35<>\"PR\",IF(R35<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"MA 1",null,"Building Reuse",null,{"$f":"IF(J36=\"NA\",\"NA\",2)","v":2}]
[null,"MA 1","BONUS","Building Reuse",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"MA 2",null,"Modular and Standardised Design",null,{"$f":"IF(J38=\"NA\",\"NA\",1)","v":1}]
[null,"MA 3",null,"Prefabrication",null,{"$f":"IF(J39=\"NA\",\"NA\",2)","v":2}]
[null,"MA 4a",null,"Adaptability and Deconstruction - Spatial Adaptability",null,{"$f":"IF(J40=\"NA\",\"NA\",1)","v":1}]
[null,"MA 4b",null,"Adaptability and Deconstruction - Flexible Engineering Services",null,1]
[null,"MA 4c",null,"Adaptability and Deconstruction - Structural Adaptability",null,1]
[null,"MA 5",null,"Rapidly Renewable Materials",null,{"$f":"IF(J43=\"NA\",\"NA\",2)","v":2}]
[null,"MA 6",null,"Sustainable Forest Products",null,{"$f":"IF(J44=\"NA\",\"NA\",1)","v":1}]
[null,"MA 7a",null,"Recycled Materials - Outside Surface Works and Structures",null,1]
[null,"MA 7b",null,"Recycled Materials - Building Structure",null,1]
[null,"MA 7c",null,"Recycled Materials - Interior Components",null,1]
[null,"MA 8a",null,"Ozone Depleting Substances - Refrigerants",null,1]
[null,"MA 8b",null,"Ozone Depleting Substances - Ozone Depleting Materials",null,1]
[null,"MA 9",null,"Regionally Manufactured Materials",null,{"$f":"IF(J50=\"NA\",\"NA\",2)","v":2}]
[null,"MA 10",null,"Demolition Waste Reduction",null,2]
[null,"MA 11",null,"Construction Waste Reduction",null,2]
[null,null,null,null,null,"Applicable Credits",null,null,{"$f":"SUM(F36,F38:I52)","v":22},"Submitted Credits",null,null,{"$f":"SUM(J36,J38:M52)","v":0},"Applicable Credits",null,null,{"$f":"SUM(N36,N38:Q52)","v":0},"Submitted Credits",null,null,{"$f":"SUM(R36,R38:U52)","v":0}]
[]
[]
[null,"Energy Use",null,null,"Submission Template","Credits Applicable",null,null,null,"Credits \nSubmitted",null,null,null,"BAS\nCredits Applicable",null,null,null,"BAS\nCredits Achieved",null,null,null,"BAS Remarks"]
[null,"EU P1",null,"Minimum Energy Performance",null,{"$f":"IF(J57=\"NA\",\"NA\",\"PR\")","v":"PR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J57),\"Blank\",IF(J57<>\"PR\",IF(J57<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R57),\"Blank\",IF(R57<>\"PR\",IF(R57<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"EU 1a",null,"Reduction of CO2 Emissions - Commercial and Hotel Buildings",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J58=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K58=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L58=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M58=\"NA\",\"NA\",15))","v":0}]
[null,"EU 1b",null,"Reduction of CO2 Emissions - Educational Buildings",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J59=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K59=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L59=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M59=\"NA\",\"NA\",15))","v":0}]
[null,"EU 1c",null,"Reduction of CO2 Emissions - Residential Buildings",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J60=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K60=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L60=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M60=\"NA\",\"NA\",15))","v":0}]
[null,"EU 1d",null,"Reduction of CO2 Emissions - Other Building Types",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J61=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K61=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L61=\"NA\",\"NA\",15))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M61=\"NA\",\"NA\",15))","v":0}]
[null,"EU 1a",null,"Option 2 Alternative Route : Passive Design - Site Planning/Building Orientation",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J62=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K62=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L62=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M62=\"NA\",\"NA\",3))","v":0}]
[null,"EU 1b",null,"Option 2 Alternative Route : Passive Design - Building Envelope",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J63=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K63=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L63=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M63=\"NA\",\"NA\",5))","v":0}]
[null,"EU 1c",null,"Option 2 Alternative Route : Passive Design - Natural Ventilation",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J64=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K64=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L64=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M64=\"NA\",\"NA\",5))","v":0}]
[null,"EU 1d",null,"Option 2 Alternative Route : Passive Design - Daylight",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J65=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K65=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L65=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M65=\"NA\",\"NA\",1))","v":0}]
[null,"EU 1e",null,"Option 2 Alternative Route : Passive Design - Active Building Systems",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J66=\"NA\",\"NA\",6))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K66=\"NA\",\"NA\",6))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L66=\"NA\",\"NA\",6))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M66=\"NA\",\"NA\",6))","v":0}]
[null,"EU 2a",null,"Peak Electricity Demand Reduction - Commercial and Hotel Buildings",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J67=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K67=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L67=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M67=\"NA\",\"NA\",3))","v":0}]
[null,"EU 2b",null,"Peak Electricity Demand Reduction - Educational and Residential Buildings",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J68=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K68=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L68=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M68=\"NA\",\"NA\",3))","v":0}]
[null,"EU 2c",null,"Peak Electricity Demand Reduction - Other Building Types",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J69=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K69=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L69=\"NA\",\"NA\",3))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M69=\"NA\",\"NA\",3))","v":0}]
[null,"EU 3",null,"Embodied Energy in Building Structural Elements",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J70=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K70=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L70=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M70=\"NA\",\"NA\",1))","v":0}]
[null,"EU 3","BONUS","Embodied Energy in Building Structural Elements",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"EU 4",null,"Ventilation System in Car Parks",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J72=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K72=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L72=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M72=\"NA\",\"NA\",2))","v":0}]
[null,"EU 5",null,"Lighting System in Car Parks",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J73=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K73=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L73=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M73=\"NA\",\"NA\",2))","v":0}]
[null,"EU 6",null,"Renewable Energy Systems",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J74=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K74=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L74=\"NA\",\"NA\",5))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M74=\"NA\",\"NA\",5))","v":0}]
[null,"EU 7",null,"Air-conditioning Units",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J75=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K75=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L75=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M75=\"NA\",\"NA\",1))","v":0}]
[null,"EU 8",null,"Clothes Drying Facilities",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J76=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K76=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L76=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M76=\"NA\",\"NA\",1))","v":0}]
[null,"EU 9",null,"Energy Efficient Appliances",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J77=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K77=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L77=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M77=\"NA\",\"NA\",2))","v":0}]
[null,"EU 10a",null,"Testing and Commissioning - Commissioning Specifications",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J78=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K78=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L78=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M78=\"NA\",\"NA\",1))","v":0}]
[null,"EU 10b",null,"Testing and Commissioning - Commissioning Plan",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J79=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K79=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L79=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M79=\"NA\",\"NA\",1))","v":0}]
[null,"EU 10c",null,"Testing and Commissioning - Commissioning",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J80=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K80=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L80=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M80=\"NA\",\"NA\",1))","v":0}]
[null,"EU 10d",null,"Testing and Commissioning - Commissioning Report",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J81=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K81=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L81=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M81=\"NA\",\"NA\",1))","v":0}]
[null,"EU 10e","BONUS","Testing and Commissioning - Independent Commissioning Authority",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"EU 11a",null,"Operation and Maintenance - Operations and Maintenance Manual",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J83=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K83=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L83=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M83=\"NA\",\"NA\",1))","v":0}]
[null,"EU 11b",null,"Operation and Maintenance - Energy Management Manual",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J84=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K84=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L84=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M84=\"NA\",\"NA\",1))","v":0}]
[null,"EU 11c",null,"Operation and Maintenance - Operator Training and Operation and Maintenance Facilities",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J85=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K85=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L85=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M85=\"NA\",\"NA\",1))","v":0}]
[null,"EU 12",null,"Metering and Monitoring",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J86=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K86=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L86=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M86=\"NA\",\"NA\",1))","v":0}]
[null,"EU 13",null,"Energy Efficient Building Layout",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J87=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K87=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L87=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M87=\"NA\",\"NA\",2))","v":0}]
[null,null,null,null,"Sub-Total",{"$f":"SUM(F58:F70,F72:F81,F83:F87)","v":0},{"$f":"SUM(G58:G70,G72:G81,G83:G87)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Applicable Credits",null,null,{"$f":"F88*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+G88*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+H88*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+I88*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0},"Submitted Credits",null,null,{"$f":"J88*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+K88*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+L88*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+M88*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0},"Applicable Credits",null,null,{"$f":"N88*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+O88*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+P88*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+Q88*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0},"Submitted Credits",null,null,{"$f":"R88*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+S88*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+T88*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+U88*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0}]
[]
[]
[null,"Water Use",null,null,"Submission Template","Credits Applicable",null,null,null,"Credits \nSubmitted",null,null,null,"BAS\nCredits Applicable",null,null,null,"BAS\nCredits Achieved",null,null,null,"BAS Remarks"]
[null,"WU P1",null,"Water Quality Survey",null,{"$f":"IF(J93=\"NA\",\"NA\",\"PR\")","v":"PR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J93),\"Blank\",IF(J93<>\"PR\",IF(J93<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R93),\"Blank\",IF(R93<>\"PR\",IF(R93<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"WU P2",null,"Minimum Water Saving Performance",null,"PR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J94),\"Blank\",IF(J94<>\"PR\",IF(J94<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R94),\"Blank\",IF(R94<>\"PR\",IF(R94<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"WU 1",null,"Annual Water Use",null,{"$f":"IF(J95=\"NA\",\"NA\",3)","v":3}]
[null,"WU 2",null,"Monitoring and Control",null,{"$f":"IF(J96=\"NA\",\"NA\",1)","v":1}]
[null,"WU 3",null,"Water Efficient Irrigation",null,{"$f":"IF(J97=\"NA\",\"NA\",1)","v":1}]
[null,"WU 4a",null,"Water Recycling - Harvested Rainwater",null,1]
[null,"WU 4b",null,"Water Recycling - Recycled Water",null,1]
[null,"WU 4c","BONUS","Water Recycling - A Combination",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"WU 5",null,"Water Efficient Appliances",null,{"$f":"IF(J101=\"NA\",\"NA\",1)","v":1}]
[null,"WU 6",null,"Effluent Discharge to Foul Sewers",null,1]
[null,null,null,null,null,"Applicable Credits",null,null,{"$f":"SUM(F95:I99,F101:I102)","v":9},"Submitted Credits",null,null,{"$f":"SUM(J95:M99,J101:M102)","v":0},"Applicable Credits",null,null,{"$f":"SUM(N95:Q99,N101:Q102)","v":0},"Submitted Credits",null,null,{"$f":"SUM(R95:U99,R101:U102)","v":0}]
[]
[null,"Indoor Environmental Quality",null,null,"Submission Template","Credits Applicable",null,null,null,"Credits \nSubmitted",null,null,null,"BAS\nCredits Applicable",null,null,null,"BAS\nCredits Achieved",null,null,null,"BAS Remarks"]
[null,"IEQ P1",null,"Minimum Ventilation Performance",null,{"$f":"IF(J106=\"NA\",\"NA\",\"PR\")","v":"PR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(J106),\"Blank\",IF(J106<>\"PR\",IF(J106<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"},{"$f":"IF(ISBLANK(R106),\"Blank\",IF(R106<>\"PR\",IF(R106<>\"NA\",\"nPR\",\"OK\"),\"OK\"))","v":"Blank"}]
[null,"IEQ 1",null,"Security",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J107=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K107=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L107=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M107=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 2",null,"Plumbing and Drainage",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J108=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K108=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L108=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M108=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 3",null,"Biological Contamination",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J109=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K109=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L109=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M109=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 4",null,"Waste Disposal Facilities",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J110=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K110=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L110=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M110=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 5a",null,"Construction IAQ Management - Construction IAQ Management",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J111=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K111=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L111=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M111=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 5b",null,"Construction IAQ Management - Filter Replacement and Flush-out",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J112=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K112=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L112=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M112=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 6a",null,"Outdoor Sources of Air Pollution - Carbon Monoxide (CO), Nitrogen Dioxide (NO2) and Ozone (O3)",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J113=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K113=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L113=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M113=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 6b",null,"Outdoor Sources of Air Pollution - Respirable Suspended Particulate (RSP, PM10)",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J114=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K114=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L114=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M114=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 7a",null,"Indoor Sources of Air Pollution - Volatile Organic Compounds (VOCs)",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J115=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K115=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L115=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M115=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 7b",null,"Indoor Sources of Air Pollution - Formaldehyde Compounds (HCHO)",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J116=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K116=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L116=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M116=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 7c",null,"Indoor Sources of Air Pollution - Radon (Rn)",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J117=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K117=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L117=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M117=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 8",null,"IAQ in Car Parks",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J118=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K118=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L118=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M118=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 9",null,"Increased Ventilation",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J119=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K119=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L119=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M119=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 10",null,"Background Ventilation",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J120=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K120=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L120=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M120=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 11a",null,"Localised Ventilation - Source Control",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J121=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K121=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L121=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M121=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 11b",null,"Localised Ventilation - Local Exhaust",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J122=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K122=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L122=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M122=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 12a",null,"Ventilation in Common Areas - Ventilation by Any Means",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J123=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K123=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L123=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M123=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 12b","BONUS","Ventilation in Common Areas - Use of Natural Ventilation",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"IEQ 13a",null,"Thermal Comfort in Air-conditioned Premises - Temperature",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J125=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K125=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L125=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M125=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 13b",null,"Thermal Comfort in Air-conditioned Premises - Room Air Distribution",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J126=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K126=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L126=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M126=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 14a",null,"Thermal Comfort in Naturally Ventilated Premises - Performance with Natural Ventilation",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J127=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K127=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L127=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M127=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 14b",null,"Thermal Comfort in Naturally Ventilated Premises - Performance with Air-conditioning",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J128=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K128=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L128=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M128=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 15",null,"Natural Lighting",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J129=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K129=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L129=\"NA\",\"NA\",2))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M129=\"NA\",\"NA\",2))","v":0}]
[null,"IEQ 16",null,"Interior Lighting in Normally Occupied Areas",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J130=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K130=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L130=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M130=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 16","BONUS","Interior Lighting in Normally Occupied Areas",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"IEQ 17",null,"Interior Lighting in Areas Not Normally Occupied",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J132=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K132=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L132=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M132=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 18",null,"Room Acoustics",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J133=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K133=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L133=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M133=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 19",null,"Noise Isolation",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J134=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K134=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L134=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M134=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 19","BONUS","Noise Isolation",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"IEQ 20",null,"Background Noise",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J136=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K136=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L136=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M136=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 21",null,"Indoor Vibration",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J137=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K137=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L137=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M137=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 22",null,"Access for Persons with Disability",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J138=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K138=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L138=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M138=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 23a",null,"Amenity Features - Amenities for the Benefit of Building Users",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J139=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K139=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L139=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M139=\"NA\",\"NA\",1))","v":0}]
[null,"IEQ 23b",null,"Amenity Features - Amenities for Improved Operation and Maintenance",null,{"$f":"IF('detail(NB1.2)'!$D$61=0,0,IF(J140=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$62=0,0,IF(K140=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$63=0,0,IF(L140=\"NA\",\"NA\",1))","v":0},{"$f":"IF('detail(NB1.2)'!$D$64=0,0,IF(M140=\"NA\",\"NA\",1))","v":0}]
[null,null,null,null,"Sub-Total",{"$f":"SUM(F107:F123,F125:F130,F132:F134,F136:F140)","v":0},{"$f":"SUM(G107:G123,G125:G130,G132:G134,G136:G140)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"Applicable Credits",null,null,{"$f":"F141*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+G141*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+H141*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+I141*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0},"Submitted Credits",null,null,{"$f":"J141*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+K141*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+L141*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+M141*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0},"Applicable Credits",null,null,{"$f":"N141*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+O141*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+P141*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+Q141*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0},"Submitted Credits",null,null,{"$f":"R141*IF(ISNUMBER('detail(NB1.2)'!$G$61),'detail(NB1.2)'!$I$61,0)+S141*IF(ISNUMBER('detail(NB1.2)'!$G$62),'detail(NB1.2)'!$I$62,0)+T141*IF(ISNUMBER('detail(NB1.2)'!$G$63),'detail(NB1.2)'!$I$63,0)+U141*IF(ISNUMBER('detail(NB1.2)'!$G$64),'detail(NB1.2)'!$I$64,0)","v":0}]
[]
[]
[null,"Innovations and Additions",null,null,"Submission Template","Credits Applicable",null,null,null,"Credits \nSubmitted",null,null,null,"BAS\nCredits Applicable",null,null,null,"BAS\nCredits Achieved",null,null,null,"BAS Remarks"]
[null,"IA 1",null,"Innovative Techniques",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"IA 2",null,"Performance Enhancements",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,"IA 3",null,"BEAM Professional",null,"BONUS",null,null,null,null,null,null,null,"BONUS"]
[null,null,null,null,null,null,null,null,null,"Submitted Credits",null,null,{"$f":"IF(SUM(J146:M148)+COUNTIF(J4:J140,\"1B\")>=6,6,SUM(J146:M148)+COUNTIF(J4:J140,\"1B\"))","v":0},null,null,null,null,"Submitted Credits",null,null,{"$f":"IF(SUM(R146:U148)+COUNTIF(R4:R140,\"1B\")>=6,6,SUM(R146:U148)+COUNTIF(R4:R140,\"1B\"))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]

{"sheet":"Target Rating_BSL","index":2,"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":"'Credit Summary'!I28","v":22},{"$f":"'Credit Summary'!M28","v":0},{"$f":"IF(C3>0,IF(D3>0,(D3/C3),\"NA\"),\"NA\")","v":"NA"},0.25,{"$f":"IF(E3<>\"NA\",E3*F3*100,\"NA\")","v":"NA"},{"$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":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!X4:X4,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Materials Aspects",{"$f":"'Credit Summary'!I53","v":22},{"$f":"'Credit Summary'!M53","v":0},{"$f":"IF(C4>0,IF(D4>0,(D4/C4),\"NA\"),\"NA\")","v":"NA"},0.08,{"$f":"IF(E4<>\"NA\",E4*F4*100,\"NA\")","v":"NA"},null,null,null,null,{"$f":"IF(COUNTIF('Credit Summary'!X32:X35,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Energy Use",{"$f":"'Credit Summary'!I89","v":0},{"$f":"'Credit Summary'!M89","v":0},{"$f":"IF(C5>0,IF(D5>0,(D5/C5),\"NA\"),\"NA\")","v":"NA"},0.35,{"$f":"IF(E5<>\"NA\",E5*F5*100,\"NA\")","v":"NA"},{"$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":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!X57:X57,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Water Use",{"$f":"'Credit Summary'!I103","v":9},{"$f":"'Credit Summary'!M103","v":0},{"$f":"IF(C6>0,IF(D6>0,(D6/C6),\"NA\"),\"NA\")","v":"NA"},0.12,{"$f":"IF(E6<>\"NA\",E6*F6*100,\"NA\")","v":"NA"},null,null,null,null,{"$f":"IF(COUNTIF('Credit Summary'!X93:X94,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Indoor Environmental Quality",{"$f":"'Credit Summary'!I142","v":0},{"$f":"'Credit Summary'!M142","v":0},{"$f":"IF(C7>0,IF(D7>0,(D7/C7),\"NA\"),\"NA\")","v":"NA"},0.2,{"$f":"IF(E7<>\"NA\",E7*F7*100,\"NA\")","v":"NA"},{"$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":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!X106:X106,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Innovations and Additions",null,{"$f":"'Credit Summary'!M149","v":0},null,1,{"$f":"D8","v":0},{"$f":"IF(G8=\"\",\"Unclassified\",IF(G8>=3,\"Platinum\",IF(G8>=2,\"Gold\",IF(G8>=1,\"Silver\",IF(G8=0,\"Bronze\",\"Unclassified\")))))","v":"Bronze"},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":2},{"$f":"IF(COUNTIF(L3:L7,\"Blank\")<5,\"OK\",\"Blank\")","v":"Blank"}]
[null,null,null,null,null,"Sub Rating",{"$f":"SUM(G3:G8)","v":0},{"$f":"IF(G9=0,\"NA\",IF(G9>=75,\"Platinum\",IF(G9>=65,\"Gold\",IF(G9>=55,\"Silver\",IF(G9>=40,\"Bronze\",\"Unclassified\")))))","v":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!X10:X10,\"Blank\")>0,\"Blank\",\"OK\")","v":"OK"}]
[null,null,null,null,null,"Overall Rating",{"$f":"+G9","v":0},{"$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":"Canot be Assessed"},null,{"$f":"COUNTIF('Credit Summary'!X:X,\"OK\")","v":0},{"$f":"MIN(K3:K9)","v":1},{"$f":"IF(COUNTIF(L3:L7,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[]
[]
[]
[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":"'Credit Summary'!Q28","v":0},{"$f":"'Credit Summary'!U28","v":0},{"$f":"IF(C16>0,IF(D16>0,(D16/C16),\"NA\"),\"NA\")","v":"NA"},0.25,{"$f":"IF(E16<>\"NA\",E16*F16*100,\"NA\")","v":"NA"},{"$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":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!Y4:Y4,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Materials Aspects",{"$f":"'Credit Summary'!Q53","v":0},{"$f":"'Credit Summary'!U53","v":0},{"$f":"IF(C17>0,IF(D17>0,(D17/C17),\"NA\"),\"NA\")","v":"NA"},0.08,{"$f":"IF(E17<>\"NA\",E17*F17*100,\"NA\")","v":"NA"},null,null,null,null,{"$f":"IF(COUNTIF('Credit Summary'!Y32:Y35,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Energy Use",{"$f":"'Credit Summary'!Q89","v":0},{"$f":"'Credit Summary'!U89","v":0},{"$f":"IF(C18>0,IF(D18>0,(D18/C18),\"NA\"),\"NA\")","v":"NA"},0.35,{"$f":"IF(E18<>\"NA\",E18*F18*100,\"NA\")","v":"NA"},{"$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":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!Y57:Y57,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Water Use",{"$f":"'Credit Summary'!Q103","v":0},{"$f":"'Credit Summary'!U103","v":0},{"$f":"IF(C19>0,IF(D19>0,(D19/C19),\"NA\"),\"NA\")","v":"NA"},0.12,{"$f":"IF(E19<>\"NA\",E19*F19*100,\"NA\")","v":"NA"},null,null,null,null,{"$f":"IF(COUNTIF('Credit Summary'!Y93:Y94,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Indoor Environmental Quality",{"$f":"'Credit Summary'!Q142","v":0},{"$f":"'Credit Summary'!U142","v":0},{"$f":"IF(C20>0,IF(D20>0,(D20/C20),\"NA\"),\"NA\")","v":"NA"},0.2,{"$f":"IF(E20<>\"NA\",E20*F20*100,\"NA\")","v":"NA"},{"$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":"NA"},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":1},{"$f":"IF(COUNTIF('Credit Summary'!Y106:Y106,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]
[null,"Innovations and Additions",null,{"$f":"'Credit Summary'!U149","v":0},null,1,{"$f":"D21","v":0},{"$f":"IF(G21=\"\",\"Unclassified\",IF(G21>=3,\"Platinum\",IF(G21>=2,\"Gold\",IF(G21>=1,\"Silver\",IF(G21=0,\"Bronze\",\"Unclassified\")))))","v":"Bronze"},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":2},{"$f":"IF(COUNTIF(L16:L20,\"Blank\")<5,\"OK\",\"Blank\")","v":"Blank"}]
[null,null,null,null,null,"Sub Rating",{"$f":"SUM(G16:G21)","v":0},{"$f":"IF(G22=0,\"NA\",IF(G22>=75,\"Platinum\",IF(G22>=65,\"Gold\",IF(G22>=55,\"Silver\",IF(G22>=40,\"Bronze\",\"Unclassified\")))))","v":"NA"},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":1}]
[null,null,null,null,null,"Overall Rating",{"$f":"+G22","v":0},{"$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":"Canot be Assessed"},null,{"$f":"COUNTIF('Credit Summary'!Y:Y,\"OK\")","v":0},{"$f":"MIN(K16:K22)","v":1},{"$f":"IF(COUNTIF(L16:L20,\"Blank\")>0,\"Blank\",\"OK\")","v":"Blank"}]

{"sheet":"Target Rating","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"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":"'Credit Summary'!I28","v":22},{"$f":"'Credit Summary'!M28","v":0},{"$f":"IFERROR(D3/C3,0)","v":0},0.25,{"$f":"ROUNDDOWN(E3*F3*100,2)","v":0},{"$f":"IF(E3>=0.7,\"Platinum\",IF(E3>=0.6,\"Gold\",IF(E3>=0.5,\"Silver\",IF(E3>=0.4,\"Bronze\",\"Unclassified\"))))","v":"Unclassified"}]
[null,"Materials Aspects",{"$f":"'Credit Summary'!I53","v":22},{"$f":"'Credit Summary'!M53","v":0},{"$f":"IFERROR(D4/C4,0)","v":0},0.08,{"$f":"ROUNDDOWN(E4*F4*100,2)","v":0}]
[null,"Energy Use",{"$f":"IFERROR('Credit Summary'!I89,0)","v":0},{"$f":"IFERROR('Credit Summary'!M89,0)","v":0},0,0.35,{"$f":"ROUNDDOWN(E5*F5*100,2)","v":0},{"$f":"IF(E5>=0.7,\"Platinum\",IF(E5>=0.6,\"Gold\",IF(E5>=0.5,\"Silver\",IF(E5>=0.4,\"Bronze\",\"Unclassified\"))))","v":"Unclassified"}]
[null,"Water Use",{"$f":"'Credit Summary'!I103","v":9},{"$f":"'Credit Summary'!M103","v":0},0,0.12,{"$f":"ROUNDDOWN(E6*F6*100,2)","v":0}]
[null,"Indoor Environmental Quality",{"$f":"IFERROR('Credit Summary'!I142,0)","v":0},{"$f":"IFERROR('Credit Summary'!M142,0)","v":0},{"$f":"IFERROR(D7/C7,0)","v":0},0.2,{"$f":"ROUNDDOWN(E7*F7*100,2)","v":0},{"$f":"IF(E7>=0.7,\"Platinum\",IF(E7>=0.6,\"Gold\",IF(E7>=0.5,\"Silver\",IF(E7>=0.4,\"Bronze\",\"Unclassified\"))))","v":"Unclassified"}]
[null,"Innovations and Additions",null,{"$f":"'Credit Summary'!M149","v":0},null,1,{"$f":"D8","v":0},{"$f":"IF(D8>=3,\"Platinum\",IF(D8=2,\"Gold\",IF(D8=1,\"Silver\",\"Bronze\")))","v":"Bronze"}]
[null,null,null,null,null,"Sub Rating"]
[null,null,null,null,null,"Overall Rating",{"$f":"SUM(G3:G8)","v":0},{"$f":"IF(AND(E3>=0.7,E5>=0.7,E7>=0.7,D8>=3,G10>=75),\"Platinum\",IF(AND(E3>=0.6,E5>=0.6,E7>=0.6,D8>=2,G10>=65),\"Gold\",IF(AND(E3>=0.5,E5>=0.5,E7>=0.5,D8>=1,G10>=55),\"Silver\",IF(AND(E3>=0.4,E5>=0.4,E7>=0.4,D8>=0,G10>=40),\"Bronze\",\"Unclassified\"))))","v":"Unclassified"}]
[null,null,null,null,null,null,"Applicant Target Rating"]

{"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":"'detail(NB1.2)'!F29","v":"00:00:00"},{"$f":"'detail(NB1.2)'!F30","v":"00:00:00"},{"$f":"RANK(AH2,$AH$2:$AI$4)","v":1},1,{"$f":"AJ2-AK2","v":0},null,{"$f":"'detail(NB1.2)'!G61","v":0},{"$f":"'detail(NB1.2)'!H61","v":0},{"$f":"IF(AND(AN2<>0,AO2>AN2),1,0)","v":0}]
[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 1.1",null,"Provisional Assessment (PA)",null,{"$f":"'detail(NB1.2)'!F35","v":"00:00:00"},{"$f":"'detail(NB1.2)'!F36","v":"00:00:00"},1,1,{"$f":"AJ3-AK3","v":0},null,{"$f":"'detail(NB1.2)'!G62","v":0},{"$f":"'detail(NB1.2)'!H62","v":0},{"$f":"IF(AND(AN3<>0,AO3>AN3),1,0)","v":0}]
[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,"New Building Version 1.2",null,"Preliminary Final Assessment (PFA)",null,{"$f":"'detail(NB1.2)'!F41","v":"00:00:00"},{"$f":"'detail(NB1.2)'!F42","v":"00:00:00"},1,1,0,null,{"$f":"'detail(NB1.2)'!G63","v":0},{"$f":"'detail(NB1.2)'!H63","v":0},0]
[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":"'detail(NB1.2)'!G64","v":0},{"$f":"'detail(NB1.2)'!H64","v":0},0]
[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":0}]
[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]