{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Disclaimer","Change Log","Instructions","Building Input Sheet","Design Review Scorecard","Built Scorecard","Submission Planner","ss - As Built Scorecard"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":79,"comments":4,"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":"Disclaimer","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,11,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disclaimer, Authorisation and Acknowledgment"]

{"sheet":"Change Log","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,3,8,5],[7,3,7,5],[0,1,0,3],[3,1,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5]]}
[]
[]
[null,"Change Log"]
[null,"Please ensure that you use the most up to date version of Green Star NZ scorecards. They are routinely updated, and using the most current version will make filling in your scorecard easier, clearer and accurate.\n"]
[null,null,"Scorecard Release","Summary of Changes"]
[null,"Green Star - Design & As Built NZv1.0","2019-04-11","Initial release."]
[null,"Green Star - Design & As Built NZv1.0","2021-06-01","Adding pathways/options set out by the Green Star Design & As Built Guidance for industrial projects "]
[null,"Green Star - Design & As Built NZv1.0","2022-10-01","Enabling % of NA claim according to the Fitout Scope Guidance "]
[null,"Green Star - Design & As Built NZv1.1","2023-10-01","Updates for NZv1.1 "]

{"sheet":"Instructions","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[17,1,17,9],[18,1,18,9],[20,1,20,9],[4,12,8,12],[15,1,15,5],[4,1,4,9],[5,7,5,9],[6,1,14,9],[15,7,15,9]]}
[]
[]
[null,"Instructions",null,null,null,null,null,null,null,null,null,null,"Definitions"]
[]
[null,"Use the tabs at the bottom of the worksheets to navigate. \n\n     1. Fill in the appropriate Scorecard based on the stage of the project (either Design Review or As Built).\n     2. Fill in the targeted points in the ‘Points Targeted’ column.\n     3. Conditional Requirements in the 'Greenhouse Gas Emissions' and 'Sustainable Sites' credits, and the minimum requirements in other credits, are required to be selected as 'Complies'.\n     4. Credits which have multiple compliance pathways are listed below. Pathways for these credits need to be selected in order to unlock the associated criteria.  \n\nCredits which have alternative compliance pathways:      \n• Operational Waste\n• Peak Electricity Demand Reduction\n• Potable Water\n• Sustainable Transport \n• Life Cycle Assessment/Impacts\n• Construction and Demolition Waste\n",null,null,null,null,null,null,null,null,null,null,"The classifications of Points Targeted, Awarded, Available, Not Applicable, and Project Score used in the scorecard are defined below:\n\nPoints Available (Targeted) - This is the total points available minus the total points claimed as 'Not Applicable' by the project team. This section DOES NOT include the 10 points available in the Innovation Category.\n\nPoints Available (Awarded) - This is the total points available minus the 'Not Applicable' credit points awarded by the Certified Assessor.\nThis DOES NOT include the Innovation points that have been awarded.\n\nProject Score (Targeted) - This is points targeted by the project team plus the total points targeted in the Innovation category.\n\nProject Score (Awarded) - This is the final score awarded to the project. It is a summation of the percentage of points awarded and the total Innovation points awarded i.e. Project score = (Points Awarded / Points Available (Awarded)) * 100 + Innovation Points.\n\nPoints TBC - This is the total points that have NOT been awarded. This section also includes Innovation points that have NOT been awarded.\n\nNA Targeted - This is the total number of points that have been claimed as 'Not applicable' by the project team including: \n\n   1. Available NA Credits as selected in the 'Building Input Sheet'\n\n   2. Type C credits that have been targeted in line with the Fitout Scope guidance document.\n\nNA Awarded - This is the total points that have been awarded as 'Not Applicable' by the Certified Assessor. This includes:\n\n   1. Available NA Credits as selected in the 'Building Input Sheet' and awarded by the Certified Assessor.\n\n   2. Type C credits that have been targeted in line with the Fitout Scope guidance document and awarded by the Certified Assessor.\n\nNA TBC - This is the total 'Not Applicable' points that have NOT been awarded by the Certified Assessor. This includes:\n\n   1. Available NA credits that have been targeted and  NOT awarded. \n\n   2. Type C credits that have been targeted and NOT awarded. "]
[null,"Important Notes"]
[null,"\n• As stated in the Submission Guidelines, some criteria will be considered 'Not Applicable' for certain projects. These credits have a check box in the 'N/A' column of the Scorecard. Criteria should only be selected as 'N/A' where NZGBC approval has been granted. If a criteria is approved as 'Not Applicable', please select the relevant tick box under the 'N/A' column. This will affect the total number of points available and the project's final score. \n\n• Some credits contain multiple pathways. In these cases project teams are required to select the pathway they have chosen to follow, in doing so the relevant criteria for that pathway will be ‘unlocked’ within the spreadsheet.\n\n• The total number of points within each category is indicated in the headings row at the top of the category. The number of points able to be targeted by the project is dependent on the relevant pathways selected by the project team. The numbers of points able to be targeted are shown in the totals row at the bottom of the category.\n\nEXAMPLE: there are 20 points available in the Energy category. A maximum of 18 points are available for the ‘Greenhouse Gas Emissions’ credit and a maximum of 2 points are available for the ‘Peak Electricity Demand Reduction’ credit. \n\nIf the Reference Building Pathway (15.2) is chosen for the 'Greenhouse Gas Emissions' credit (18 points available) and the Prescriptive Pathway (16A) is chosen for the 'Peak Energy Demand' credit (1 point available), the total number of points able to be targeted by the project will be 19. However, the total number of points available in the category remains at 20 points.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Clarification of Assessment Comments"]
[]
[null,"A section has been provided within the scorecard worksheet to enable project teams to query assessment comments prior to the following round of assessment. The three types of queries that may be submitted are:\n\n     1. Clarifying the documentation requested in the assessment comment. \n     2. Clarifying apparent inconsistencies between the assessment comment and the Submission Guideline's requirements.\n     3. Documentation was included but missed during the assessment.\n\nThis section is hidden prior to the project's assessment. The section will be unhidden when project teams receive their project's assessment results."]
[null,"Integrated Fitout and Cold Shell Spaces"]
[]
[null,"Building Input Sheet\nA section has been provided within the Building Input Sheet to enable project teams to identify the amount of space within the project which is being delivered as 'Cold Shell' or 'Integrated Fitout'.\n\n     1. Enter the total amount of Primary and Secondary Spaces within the project\n     2. Enter the total amount of Primary and Secondary Spaces within the project being delivered as Cold Shell.\n     3. Enter the total amount of Primary and Secondary Spaces within the project being delivered as Integrated Fitout.\n     4. Complete table for Integrated Fitout where full compliance is being sort for Integrated Fitout Areas.\n\nThe number of points available are for cold shell spaces and integrated fitout are based upon the ratio determined by the above inputs. The remaining points are able to be claimed as 'Not Applicable' within the Design Review and As Built Scorecard sheets. \n\nNote: If the points claimed in the Scorecard has been populated and the Cold Shell percentage changes, the Scorecard inputs will need to be manually updated\n\nRefer to the 'Green Star – Design & As Built Fitout Scope: Guidance for Integrated, Cold Shell and Warm Shell Fitouts' document for further guidance on Primary and Secondary spaces in a building being delivered as Cold Shell or Integrated Fitout. "]

{"sheet":"Building Input Sheet","index":3,"n_rows":110,"n_cols":7,"rows_kept":110,"cut":false,"hidden":false,"merged":[[108,1,108,2],[105,1,105,2],[74,1,75,1],[76,1,78,1],[102,1,102,3],[103,1,103,2],[104,1,104,2],[91,1,94,1],[66,1,67,1],[68,1,69,1],[70,1,71,1],[72,1,73,1],[106,1,106,2],[5,1,7,1],[19,1,20,1],[19,3,20,3],[21,1,21,2],[50,1,50,3],[109,1,109,2],[99,1,99,4],[51,1,51,3],[107,1,107,2],[83,1,83,3],[84,1,84,3],[85,1,85,2],[86,1,86,3],[96,1,97,1],[89,1,90,1],[81,1,81,4],[52,1,52,2],[53,1,53,3],[57,1,59,1],[60,1,62,1],[63,1,65,1]]}
[null,null,null,null,null,"x"]
[]
[]
[null,"Building Input ",null,null,null,"NSW","USER INPUT CELL"]
[null,"Name of Building:",null,null,null,"ACT"]
[null,"Address of Building:",null,null,null,"NT","LOCKED CELL"]
[null,null,null,null,null,"QLD"]
[null,null,null,null,null,"SA","LOCKED CELL"]
[null,"Postcode:",null,null,null,"TAS"]
[null,"City:",null,null,null,"VIC"]
[null,null,null,null,null,"WA"]
[null,"Project Timeline",null,"Date (MM/YYYY)"]
[null,"Site purchase date"]
[null,"Start of design"]
[null,"Design completed"]
[null,"Start of construction"]
[null,"Practical Completion"]
[]
[null,"Building Description"]
[null,"Description of building"]
[]
[null,"Industrial projects: \nIs the project claiming Industrial specific pathways and credits inline with the Green Star Design & As Built Guidance for industrial projects document?",null,"No","Note: Projects choosing to use Green Star Design & As Built Guidance for Industrial projects cannot claim \"Not Applicable\" for cold shell compliance as per the Green Star – Design & As Built NZv1.1 Fitout Scope: Guidance for Integrated, Cold Shell and Warm Shell Fitouts document.","Yes"]
[null,null,null,null,null,"No"]
[null,"Area Listing (GFA in m²)",null,{"$f":"IF(D22=\"Yes\",\"Enter the project areas for Office and Industrial\",\"\")","v":""}]
[null,"Office"]
[null,"Residential"]
[null,"Retail"]
[null,"Healthcare"]
[null,"Education"]
[null,"Industrial"]
[null,"Other"]
[null,"Total",null,{"$f":"SUM(D25:D31)","v":0}]
[]
[null,"Applicant Details"]
[null,"Applicant:"]
[null,"Contact Person:"]
[]
[null,"Project Team Details",null,"Company/Organisation"]
[null,"Acoustic Consultant"]
[null,"Architect"]
[null,"Building Services Engineer"]
[null,"Building Surveyor"]
[null,"ESD Consultant"]
[null,"Landscaping Consultant"]
[null,"Local Planning Authority"]
[null,"Main Contractor"]
[null,"Project Manager"]
[null,"Quantity Surveyor"]
[null,"Structural/Civil Engineer"]
[]
[null,"Credits being claimed as 'Not Applicable'"]
[null,"This section is used to indicate credits or specific criteria which may not be considered relevant to the sustainability outcomes of the project. Such credits can be claimed as 'Not Applicable' below. Refer to the Submission Guidelines for more information. \nPlease note that this section does not cover \"Not Applicable\" credits for cold shell compliance as allowed in the Green Star – Design & As Built NZv1.1 Fitout Scope: Guidance for Integrated, Cold Shell and Warm Shell Fitouts document. \"Not applicable\" credits for cold shell compliance are separately addressed in the following sections."]
[null,"Are any credits being claimed as 'Not Applicable'?",null,"No",{"$f":"IF(AND(D53=\"No\",COUNTA(E58:E81)>0),\"Error: Please select 'Yes' and check if there are any credits that are claimed as Not Applicable\",\"\")","v":""}]
[null,"Please select the credits below which are \"Not Applicable\" for your project. "]
[]
[null,"Available 'Not Applicable' (NA) Credits",null,null,"Select Yes below"]
[null,"Credit","Code","Credit Criteria","Not Applicable"]
[null,"Indoor Air Quality",9.1,"Ventilation System Attributes"]
[null,null,9.1999999999999993,"Provision of Outdoor Air"]
[null,null,9.3000000000000007,"Exhaust or Elimination of Pollutants"]
[null,"Acoustic Comfort",10.1,"Internal Noise Levels"]
[null,null,10.199999999999999,"Reverberation"]
[null,null,10.3,"Acoustic Separation"]
[null,"Lighting Comfort",11.2,"General Illuminance and Glare Reduction"]
[null,null,11.3,"Surface Illuminance"]
[null,null,11.4,"Localised Lighting Control"]
[null,"Visual Comfort",12.2,"Daylight"]
[null,null,12.3,"Views"]
[null,"Indoor Pollutants",13.1,"Paints, Adhesives, Sealants and Carpets"]
[null,null,13.2,"Engineered Wood Products"]
[null,"Thermal Comfort",14.1,"Thermal Comfort"]
[null,null,14.2,"Advanced Thermal Comfort"]
[null,"Sustainable Transport","17B.2","Reduced Car Parking Provision"]
[null,null,"17B.3","Low Emission Vehicle Infrastructure"]
[null,"Potable Water","18B.4","Landscape Irrigation"]
[null,null,"18B.5","Fire System Test Water"]
[null,"Responsible Building Materials",20.100000000000001,"Structural and Reinforcing Steel"]
[null,null,20.2,"Timber Products"]
[null,null,20.3,"Permanent Formwork, Pipes, Flooring, Blinds and Cables"]
[null,"Sustainable Sites",24.3,"Contamination and Hazardous Materials"]
[null,"Refrigerant Impacts ",28,"Refrigerant Impacts "]
[null,"Note 1: Where project teams are claiming credit criteria as 'Not Applicable', project teams must provide evidence to demonstrate that the credit criteria are not applicable or not relevant to the project. The Certified Assessor will determine whether the credit criteria claimed is complaint in line with the evidence provided. \n"]
[]
[null,"Credits being claiming Full Compliance for Integrated Fitout"]
[null,"This section is used to indicate credits that are claiming Full Compliance for the Integrated Fitout Areas (i.e where the credit requirements are also being achieved by the tenant fitout). Refer to the Green Star – Design & As Built NZv1.1 Fitout Scope: Guidance for Integrated, Cold Shell and Warm Shell Fitouts document for more details."]
[null,"Are any credits claimed Full Compliance for Integrated Fitout?",null,"No"]
[null,"Please select the credits below which are claiming Full Compliance for Integrated Fitout for your project."]
[]
[null,"Available Integrated Fitout Credits",null,null,"Select Yes below"]
[null,"Acoustic Comfort",10.199999999999999,"Reverberation"]
[null,null,10.3,"Acoustic Separation"]
[null,"Lighting Comfort",11.1,"Minimum Lighting Comfort "]
[null,null,11.2,"General Illuminance and Glare Reduction"]
[null,null,11.3,"Surface Illuminance"]
[null,null,11.4,"Localised Lighting Control"]
[null,"Visual Comfort",12.1,"Glare Reduction"]
[null,"Indoor Pollutants",13.1,"Paints, Adhesives, Sealants and Carpets"]
[null,null,13.2,"Engineered Wood Products"]
[]
[null,"Note 2: Where project teams are claiming credit criteria as Integrated Fitout full compliance, project teams must provide evidence to demonstrate that the credit criteria is achieved in both the base building and fitout. The Certified Assessor will determine whether the credit criteria claimed is complaint in line with the evidence provided. \n"]
[]
[null,"Cold Shell and Integrated Fitout Spaces"]
[null,"This section is used to calculate the percentage of Cold Shell and Integrated Fitout spaces and determines how Type C credits will be treated for the project. \n\nIMPORTANT: Projects which are being delivered as Cold Shell and Integrated Fitout must first complete the 'Area Definition Form' and use those outputs as the areas in the cells below. Refer to the Green Star – Design & As Built NZv1.1 Fitout Scope: Guidance for Integrated, Cold Shell and Warm Shell Fitouts document for more details.\n\nWhere Integrated Fitouts and Cold Shell Spaces make up between 5% - 95% of Primary and Secondary Spaces, they may be excluded on submission of relevant documentation, and the scorecard is adjusted to reflect this exclusions in the credit's points available value. Refer to the 'Green Star - Design & As Built Fitout Scope: Guidance for Integrated, Cold Shell and Warm Shell Fitouts' document for more information."]
[null,"Total Primary & Secondary space (m2)"]
[null,"Total Cold Shell Area (m2)"]
[null,"Total Integrated Fitout Area (m2)"]
[null,"Total Cold Shell Areas (%)",null,{"$f":"IF(SEL_YN_Industrial=\"Yes\",0,ROUND(IFERROR((D105)/D104,0),2))","v":0}]
[null,"Integrated Fitout Areas (%)",null,{"$f":"IF(SEL_YN_Industrial=\"Yes\",0,ROUND(IFERROR((D106)/D104,0),2))","v":0}]
[null,"Scaling of Type C Credits - N/A Pathway",null,{"$f":"IF(D105=\"\",\"\",IF((D107+D108)<=0.05,\"Scaling of Type C credits do not apply when total cold shell areas are <5%.\",IF((D107+D108)>=0.95,\"Credits will be scaled at 100% so that 100% of the points available in Type C credits may be targeted as Not Applicable.\",\"Credits will be scaled so that \"&(1-D107-D108)*100&\"% of the points available in Type C credits can be claimed and \"&(D107+D108)*100&\"% can be targeted as Not Applicable.\")))","v":""}]
[null,"Scaling of Type C Credits where full compliance of Integrated Fitout is selected from Row 90 to Row 98",null,{"$f":"IF(D105=\"\",\"\",IF((D107)<=0.05,\"Scaling of Type C credits do not apply when total cold shell areas are <5%.\",IF((D107)>=0.95,\"Credits will be scaled at 100% so that 100% of the points available in Type C credits may be targeted as Not Applicable.\",\"Credits will be scaled so that \"&(1-D107)*100&\"% of the points available in Type C credits can be claimed and \"&(D107)*100&\"% can be targeted as Not Applicable.\")))","v":""}]

{"sheet":"Design Review Scorecard","index":4,"n_rows":130,"n_cols":43,"rows_kept":130,"cut":false,"hidden":false,"merged":[[77,6,79,6],[77,5,81,5],[80,6,81,6],[107,5,107,8],[108,10,112,10],[91,5,91,8],[98,5,98,8],[99,5,100,5],[99,6,100,6],[101,5,102,5],[101,6,102,6],[82,5,84,5],[82,6,84,6],[91,16,91,17],[93,5,95,5],[93,6,95,6],[86,5,88,5],[87,6,88,6],[49,5,50,5],[49,6,50,6],[54,5,64,5],[54,6,64,6],[68,5,73,5],[68,6,73,6],[47,5,48,5],[47,6,48,6],[30,5,32,5],[30,6,32,6],[33,5,36,5],[33,6,36,6],[37,5,39,5],[37,6,39,6],[40,5,41,5],[40,6,41,6],[42,5,43,5],[42,6,43,6],[46,5,46,8],[27,5,29,5],[27,6,29,6],[11,5,13,5],[11,6,13,6],[15,5,16,5],[15,6,16,6],[17,5,18,5],[17,6,18,6],[19,5,21,5],[19,6,21,6],[22,5,23,5],[22,6,23,6],[26,5,26,8],[3,6,3,7],[4,25,4,27],[0,5,0,8],[1,6,1,7],[8,5,10,5],[8,6,10,6],[0,20,0,23],[0,24,0,27],[1,21,1,23],[1,25,1,27],[2,21,2,23],[2,25,2,27],[3,21,3,23],[3,25,3,27],[4,21,4,23],[2,6,2,7]]}
[null,null,null,null,null,"Green Star - Design & As Built NZv1.1 Scorecard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUND 1 ",null,null,null,"ROUND 2",null,null,null,"x","x","x","x"]
[null,null,null,null,null,"Project:",null,null,null,null,"Core Points Available (Targeted)","Project Score (Targeted)","NA Targeted",null,null,null,"Project Score (Awarded)","Total Points TBC","NA Awarded","NA TBC",null,"Post Round 1 Clarification \nPlease enter type of clarification for each credit as follows:",null,null,null,"Post Round 2 Clarification \nPlease enter type of clarification for each credit as follows:"]
[null,null,null,null,null,"Targeted Rating:",{"$f":"IF(AND(L3>=75,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"6 Stars - World Leadership\",IF(AND(L3>=60,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"5 Star - New Zealand Excellence\",IF(AND(L3>=45,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"4 Star - New Zealand Best Practice\",\"\")))","v":""},null,null,null,{"$f":"K117","v":100},{"$f":"L120","v":0},{"$f":"AO49","v":0},null,null,null,{"$f":"Q117","v":0},{"$f":"R117","v":0},{"$f":"AJ18","v":0},{"$f":"AJ19","v":0},null,"1. Documentation Clarification: The project team wish to clarify the documentation requested in the Round 1 Assessment Comment ",null,null,null,"1. Documentation Clarification: The project team wish to clarify the documentation requested in the Round 1 Assessment Comment "]
[null,null,null,null,null,"Rating Achieved:",{"$f":"IF(AND(Q3>=75,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"6 Stars - World Leadership\",IF(AND(Q3>=60,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"5 Star - New Zealand Excellence\",IF(AND(Q3>=45,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"4 Star - New Zealand Best Practice\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Complaince Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements.",null,null,null,"2. Complaince Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Check Existing Documentation: The project team wish to draw the Assesors' attention to documentation submitted previously that may have been overlooked during the assessment. ",null,null,null,"3. Check Existing Documentation: The project team wish to draw the Assesors' attention to documentation submitted previously that may have been overlooked during the assessment. "]
[null,null,null,null,null,"CATEGORY / CREDIT","AIM OF THE CREDIT / SELECTION","CODE","CREDIT CRITERIA","INTEGRATED/ COLD SHELL CREDIT TYPE","POINTS AVAILABLE","POINTS TARGETED","NA AVAILABLE","NA TARGETED",null,null," POINTS AWARDED"," POINTS \nTBC","POINTS OUTCOME","NA OUTCOME"," Rd1 ASSESSMENT COMMENTS","Type","Clarification Request \n(GSAP to complete)","Clarification from Assessors\n(To be completed by Assessors) "," Rd2 ASSESSMENT COMMENTS","Type","Clarification Request \n(GSAP to complete)","Clarification from Assessors\n(To be Completed by Assessors) "]
[null,null,null,null,null,"Management",null,null,null,null,15,null,null,null,null,null,null,null,null,null,"(Completed by Assessors only)",null,null,"Assessors comments including Point(s) Awarded/Denied","(Completed by Assessors only)",null,null,"Assessors comments including Point(s) Awarded/Denied",null,null,null,null,null,null,"NA Points Calculations",null,null,null,null,null," "]
[null,null,null,null,null,"Green Star Accredited Professional","To recognise projects that engage a Green Star Accredited Professional to support the Green Star certification process.",1,"Green Star Accredited Professional","A",1,null,"-",{"$f":"M8","v":"-"},null,null,{"$f":"IF(OR(S8=$AE$10,S8=$AE$11),L8,\"\")","v":""},{"$f":"IF(S8=$AE$12,L8,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please enter the Total Primary & Secondary Spaces for your project (m2)",{"$f":"'Building Input Sheet'!D104","v":0}]
[null,null,null,null,null,"Commissioning and Tuning","To encourage and recognise commissioning, handover and tuning initiatives that ensure all building services operate to their full potential and as designed.",2.1,"Conditonal Requirement ","A",2,null,"-",{"$f":"M9","v":"-"},{"$f":"IF($L$9<>2,\"CR\",\"\")","v":"CR"},null,"","",null,null,null,null,null,null,null,null,null,null,"Performance Pathway",null,null,"Complies",null,null,"Please enter the Total Primary & Secondary Spaces for your project that are delivered as Cold shell (m2)",{"$f":"'Building Input Sheet'!D105","v":0}]
[null,null,null,null,null,null,null,2.2000000000000002,"Services and Maintainability Review","A",1,null,"-","-",{"$f":"IF(AND(L10>0,$L$9<>2),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway","Core","Awarded - Compliant","Does not comply",null,null,"Please enter the Total Primary & Secondary Spaces for your project that are delivered as Integrated Fitout (m2)",{"$f":"'Building Input Sheet'!D106","v":0}]
[null,null,null,null,null,null,null,2.2999999999999998,"Independent Commissioning Agent","A",1,null,"-","-",{"$f":"IF(AND(L11>0,$L$9<>2),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,"Stage 1","Awarded - Minor non-compliance",null,null,null,"Total Primary & Secondary areas delivered as Cold Shell(%)",{"$f":"IF(ISERROR(AJ9/AJ8),0, AJ9/AJ8)","v":0}]
[null,null,null,null,null,"Adaptation and Resilience","To encourage and recognise projects that are resilient to the impacts of a changing climate and natural disasters.",3.1,"Climate Change Pre-Screening Checklist ","Conditional Requirement ","Conditional Requirement ",null,"-","-",{"$f":"IF($L$12<>AF9,\"CR\",\"\")","v":"CR"},null,"","",null,null,null,null,null,null,null,null,null,null,null,"Stage 2","Not Awarded - Major non-compliance",null,null,null,"Are there any Traditional \"NA\" Credits being targeted",{"$f":"IF('Building Input Sheet'!D53=\"Yes\",\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,3.2,"Climate Change Risk Assessment and Adaptation Plan",2,2,null,"-","-",{"$f":"IF(AND(L13>0,$L$12<>$AF$9),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,3.3,"Earthquake Resilience ",1,1,null,"-","-",{"$f":"IF(AND(L14>0,$L$12<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points ratio for type C credits based on Cold Shell and Integrated area",{"$f":"ROUND(IF('Building Input Sheet'!D107+'Building Input Sheet'!D108>=0.95,0,IF('Building Input Sheet'!D107+'Building Input Sheet'!D108<=0.05,1,1-('Building Input Sheet'!D107+'Building Input Sheet'!D108))),2)","v":1}]
[null,null,null,null,null,"Building Information","To recognise the development and provision of building information that facilitates operator and user understanding of a building's systems, their operation and maintenance requirements, and their environmental targets, to enable optimised performance.",4.0999999999999996,"Building Information","A",1,null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"Points ratio for type C credits based on Cold Shell area (Integrated fitout full compliance)",{"$f":"ROUND(IF('Building Input Sheet'!D107>=0.95,0,IF('Building Input Sheet'!D107<=0.05,1,1-'Building Input Sheet'!D107)),2)","v":1}]
[null,null,null,null,null,"Commitment to Performance","To recognise practices that encourage building owners, building occupants and facilities management teams to set targets and monitor environmental performance in a collaborative way.",5.0999999999999996,"Environmental Building Performance","A",1,null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,"Total points that have been made NA by the project team",{"$f":"AN49","v":0}]
[null,null,null,null,null,null,null,5.2,"End of Life Waste Performance","A",1,null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,"Total NA points that have been targeted",{"$f":"AO49","v":0}]
[null,null,null,null,null,"Metering and Monitoring","To recognise the implementation of effective energy and water metering and monitoring systems.",6.1,"Metering","A","Minimum Requirement",null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NA points that have been awarded ",{"$f":"AP49","v":0}]
[null,null,null,null,null,null,null,6.2,"Monitoring Systems","A",1,null,"-","-",{"$f":"IF(AND(L19>0,$L$18<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NA points that have not been awarded",{"$f":"AQ49","v":0}]
[null,null,null,null,null,"Responsible Construction Practices","To reward responsible construction practices that manage environmental impacts, enhance staff health and wellbeing, and improve sustainability knowledge on site.",7.1,"Environmental Management Plan","B","Minimum Requirement",null,"-","-",null,null,"",""]
[null,null,null,null,null,null,null,7.2,"Formalised Environmental Management System","B",1,null,"-","-",{"$f":"IF(AND(L21>0,$L$20<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Available NA Credits","NA Targeted","Integrated Fitout Compliance","Type C Credits overlap","Points Available","NA Points Available","NA points Targeted","NA Awarded","NA Not Awarded"]
[null,null,null,null,null,null,null,7.3,"High Quality Staff Support","B",1,null,"-","-",{"$f":"IF(AND(L22>0,$L$20<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1,{"$f":"IF('Building Input Sheet'!E58=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ22=TRUE,0,1)","v":1},{"$f":"IF(AJ22=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ22=TRUE,AN22,0)","v":0},{"$f":"IF(OR(T28=$AE$10,T28=$AE$11),AO22,0)","v":0},{"$f":"IF(T28=$AE$12,AO22,0)","v":0}]
[null,null,null,null,null,"Operational Waste","Performance Pathway","8A","Performance Pathway - Specialist Plan","A",{"$f":"IF(G23=AC9,1,\"0\")","v":1},null,"-","-",{"$f":"IF(AND(L23>0,G23=\"Prescriptive Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S23=$AE$10,S23=$AE$11),L23,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993,{"$f":"IF('Building Input Sheet'!E59=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ23=TRUE,0,2)","v":2},{"$f":"IF(AJ23=TRUE,2,\"-\")","v":"-"},{"$f":"IF(AJ23=TRUE,AN23,0)","v":0},0,0]
[null,null,null,null,null,null,null,"8B","Prescriptive Pathway - Facilities","A",{"$f":"IF(G23=AC10,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L24>0,G23=\"Performance Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S24=$AE$10,S24=$AE$11),L24,\"\")","v":""},{"$f":"IF(S24=$AE$12,L24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.3000000000000007,{"$f":"IF('Building Input Sheet'!E60=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ24=TRUE,0,1)","v":1},{"$f":"IF(AJ24=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ24=TRUE,AN24,0)","v":0},0,0]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K8:K24)","v":15},{"$f":"SUM(L8:L24)","v":0},{"$f":"SUM(M8:M24)","v":0},{"$f":"SUM(N8:N24)","v":0},{"$f":"IF(L25>K25,\"!\",\"\")","v":""},null,{"$f":"SUM(Q8:Q24)","v":0},{"$f":"SUM(R8:R24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.1,{"$f":"IF('Building Input Sheet'!E61=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ25=TRUE,0,1)","v":1},{"$f":"IF(AJ25=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ25=TRUE,AN25,0)","v":0},0,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,null,null,null,10.199999999999999,{"$f":"IF('Building Input Sheet'!E62=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E90=\"Yes\",TRUE,FALSE)","v":false},10.199999999999999,{"$f":"IF(AJ26=TRUE,0,IF(AK26=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ26=TRUE,1,IF(AK26=TRUE,1-AM26,\"-\"))","v":"-"},{"$f":"N32","v":0},0,0]
[null,null,null,null,null,"Indoor Environment Quality",null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.3,{"$f":"IF('Building Input Sheet'!E63=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E91=\"Yes\",TRUE,FALSE)","v":false},10.3,{"$f":"IF(AJ27=TRUE,0,IF(AK27=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ27=TRUE,1,IF(AK27=TRUE,1-AM27,\"-\"))","v":"-"},"-",0,0]
[null,null,null,null,null,"Indoor Air Quality","To recognise projects that provide high indoor air quality to occupants.",9.1,"Ventilation System Attributes","A",{"$f":"AM22","v":1},null,{"$f":"AN22","v":"-"},{"$f":"M28","v":"-"},null,null,{"$f":"IF(OR(S28=$AE$10,S28=$AE$11),L28,\"\")","v":""},{"$f":"IF(S28=$AE$12,L28,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Building Input Sheet'!E92=\"Yes\",TRUE,FALSE)","v":false},11.1,0,"-","-",0,0]
[null,null,null,null,null,null,null,9.1999999999999993,"Provision of Outdoor Air","A",{"$f":"AM23","v":2},null,{"$f":"AN23","v":"-"},{"$f":"M29","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.2,{"$f":"IF('Building Input Sheet'!E64=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E93=\"Yes\",TRUE,FALSE)","v":false},11.2,{"$f":"IF(AJ29=TRUE,0,IF(AK29=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ29=TRUE,1,IF(AK29=TRUE,1-AM29,\"-\"))","v":"-"},"-",{"$f":"IF(OR(T35=$AE$10,T35=$AE$11),AO29,0)","v":0},{"$f":"IF(T35=$AE$12,AO29,0)","v":0}]
[null,null,null,null,null,null,null,9.3000000000000007,"Exhaust or Elimination of Pollutants","A",1,null,{"$f":"AN24","v":"-"},"-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.3,{"$f":"IF('Building Input Sheet'!E65=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E94=\"Yes\",TRUE,FALSE)","v":false},11.3,{"$f":"IF(AJ30=TRUE,0,IF(AK30=FALSE,$AJ$14,$AJ$15))","v":1},"-","-",{"$f":"IF(OR(T36=$AE$10,T36=$AE$11),AO30,0)","v":0},{"$f":"IF(T36=$AE$12,AO30,0)","v":0}]
[null,null,null,null,null,"Acoustic Comfort","To reward projects that provide appropriate and comfortable acoustic conditions for occupants.",10.1,"Internal Noise Levels","A",1,null,{"$f":"AN25","v":"-"},{"$f":"M31","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.4,{"$f":"IF('Building Input Sheet'!E66=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E95=\"Yes\",TRUE,FALSE)","v":false},11.4,{"$f":"IF(AJ31=TRUE,0,IF(AK31=FALSE,$AJ$14,$AJ$15))","v":1},"-","-",{"$f":"IF(OR(T37=$AE$10,T37=$AE$11),AO31,0)","v":0},{"$f":"IF(T37=$AE$12,AO31,0)","v":0}]
[null,null,null,null,null,null,null,10.199999999999999,"Reverberation","C",{"$f":"AM26","v":1},null,"-",null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Building Input Sheet'!E96=\"Yes\",TRUE,FALSE)","v":false},12.1,0,"-","-",0,0]
[null,null,null,null,null,null,null,10.3,"Acoustic Separation","C",1,null,"-",{"$f":"M33","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.2,{"$f":"IF('Building Input Sheet'!E67=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ33=TRUE,0,2)","v":2},{"$f":"IF(AJ33=TRUE,2,\"-\")","v":"-"},{"$f":"IF(AJ33=TRUE,AN33,0)","v":0},{"$f":"IF(OR(T39=$AE$10,T39=$AE$11),AO33,0)","v":0},{"$f":"IF(T39=$AE$12,AO33,0)","v":0}]
[null,null,null,null,null,"Lighting Comfort","To encourage and recognise well-lit spaces that provide a high degree of comfort to users.",11.1,"Minimum Lighting Comfort","C","Minimum Requirement",null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.3,{"$f":"IF('Building Input Sheet'!E68=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ34=TRUE,0,1)","v":1},{"$f":"IF(AJ34=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ34=TRUE,AN34,0)","v":0},0,0]
[null,null,null,null,null,null,null,11.2,"General Illuminance and Glare Reduction","C",1,null,{"$f":"AN29","v":"-"},{"$f":"M35","v":"-"},{"$f":"IF(AND(OR(L35>0,AND(M35>0,M35<>\"-\")),$L$34<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.1,{"$f":"IF('Building Input Sheet'!E69=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E97=\"Yes\",TRUE,FALSE)","v":false},13.1,{"$f":"IF(AJ35=TRUE,0,IF(AK35=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ35=TRUE,1,IF(AK35=TRUE,1-AM35,\"-\"))","v":"-"},{"$f":"N41","v":"-"},0,0]
[null,null,null,null,null,null,null,11.3,"Surface Illuminance","C",1,null,{"$f":"AN30","v":"-"},"-",{"$f":"IF(AND(OR(L36>0,AND(M36>0,M36<>\"-\")),$L$34<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.2,{"$f":"IF('Building Input Sheet'!E70=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E98=\"Yes\",TRUE,FALSE)","v":false},13.2,{"$f":"IF(AJ36=TRUE,0,IF(AK36=FALSE,$AJ$14,$AJ$15))","v":1},"-",{"$f":"N42","v":"-"},0,0]
[null,null,null,null,null,null,null,11.4,"Localised Lighting Control","C",1,null,{"$f":"AN31","v":"-"},"-",{"$f":"IF(AND(OR(L37>0,AND(M37>0,M37<>\"-\")),$L$34<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.1,{"$f":"IF('Building Input Sheet'!E71=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ37=TRUE,0,1)","v":1},{"$f":"IF(AJ37=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ37=TRUE,AN37,0)","v":0},0,0]
[null,null,null,null,null,"Visual Comfort","To recognise the delivery of well-lit spaces that provide high levels of visual comfort to building occupants.",12.1,"Glare Reduction","C","Minimum Requirement",null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.2,{"$f":"IF('Building Input Sheet'!E72=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ38=TRUE,0,1)","v":1},{"$f":"IF(AJ38=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ38=TRUE,AN38,0)","v":0},0,0]
[null,null,null,null,null,null,null,12.2,"Daylight","A",2,null,{"$f":"AN33","v":"-"},"-",{"$f":"IF(AND(OR(L39>0,M39<>\"-\"),$L$38<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17B.2",{"$f":"IF('Building Input Sheet'!E73=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ39=TRUE,0,1)","v":1},{"$f":"IF(AJ39=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AND(AJ39=TRUE,G55=AC57),AN39,0)","v":0},{"$f":"IF(OR(T57=$AE$10,T57=$AE$11),AO39,0)","v":0},{"$f":"IF(T57=$AE$12,AO39,0)","v":0}]
[null,null,null,null,null,null,null,12.3,"Views","A",1,null,{"$f":"AN34","v":"-"},"-",{"$f":"IF(AND(OR(L40>0,M40<>\"-\"),$L$38<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17B.3",{"$f":"IF('Building Input Sheet'!E74=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ40=TRUE,0,2)","v":2},{"$f":"IF(AJ40=TRUE,2,\"-\")","v":"-"},{"$f":"IF(AND(AJ40=TRUE,G55=AC57),AN40,0)","v":0},{"$f":"IF(OR(T58=$AE$10,T58=$AE$11),AO40,0)","v":0},{"$f":"IF(T58=$AE$12,AO40,0)","v":0}]
[null,null,null,null,null,"Indoor Pollutants","To recognise projects that safeguard occupant health through the reduction in internal air pollutant levels.",13.1,"Paints, Adhesives, Sealants and Carpets","C",1,null,"-","-",null,null,{"$f":"IF(OR(S41=$AE$10,S41=$AE$11),L41,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18B.4",{"$f":"IF('Building Input Sheet'!E75=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ41=TRUE,0,1)","v":1},"-",{"$f":"IF(AND(AJ41=TRUE,G69=AC70),AN41,0)","v":0},{"$f":"IF(OR(T73=$AE$10,T73=$AE$11),AO41,0)","v":0},{"$f":"IF(T73=$AE$12,AO41,0)","v":0}]
[null,null,null,null,null,null,null,13.2,"Engineered Wood Products","C",1,null,"-","-",null,null,{"$f":"IF(OR(S42=$AE$10,S42=$AE$11),L42,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18B.5",{"$f":"IF('Building Input Sheet'!E76=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ42=TRUE,0,1)","v":1},"-",{"$f":"IF(AND(AJ42=TRUE,G69=AC70),AN42,0)","v":0},{"$f":"IF(OR(T74=$AE$10,T74=$AE$11),AO42,0)","v":0},{"$f":"IF(T74=$AE$12,AO42,0)","v":0}]
[null,null,null,null,null,"Thermal Comfort","To recognise projects that achieve high levels of thermal comfort.",14.1,"Thermal Comfort","A",1,null,"-","-",null,null,{"$f":"IF(OR(S43=$AE$10,S43=$AE$11),L43,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.100000000000001,{"$f":"IF('Building Input Sheet'!E77=\"Yes\",TRUE,FALSE)","v":false},null,null,1,"-",{"$f":"IF(AJ43=TRUE,AN43,0)","v":0},{"$f":"IF(OR(T83=$AE$10,T83=$AE$11),AO43,0)","v":0},{"$f":"IF(T83=$AE$12,AO43,0)","v":0}]
[null,null,null,null,null,null,null,14.2,"Advanced Thermal Comfort","A",1,null,"-","-",null,null,{"$f":"IF(OR(S44=$AE$10,S44=$AE$11),L44,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.2,{"$f":"IF('Building Input Sheet'!E78=\"Yes\",TRUE,FALSE)","v":false},null,null,1,"-",{"$f":"IF(AJ44=TRUE,AN44,0)","v":0},{"$f":"IF(OR(T84=$AE$10,T84=$AE$11),AO44,0)","v":0},{"$f":"IF(T84=$AE$12,AO44,0)","v":0}]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K28:K44)","v":17},{"$f":"SUM(L28:L44)","v":0},{"$f":"SUM(M28:M44)","v":0},0,{"$f":"IF(L45>K45,\"!\",\"\")","v":""},null,{"$f":"SUM(Q28:Q44)","v":0},{"$f":"SUM(R28:R44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.3,{"$f":"IF('Building Input Sheet'!E79=\"Yes\",TRUE,FALSE)","v":false},null,null,1,"-",{"$f":"IF(AJ45=TRUE,AN45,0)","v":0},{"$f":"IF(OR(T85=$AE$10,T85=$AE$11),AO45,0)","v":0},{"$f":"IF(T85=$AE$12,AO45,0)","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,null,null,null,24.3,{"$f":"IF('Building Input Sheet'!E80=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ46=TRUE,0,1)","v":1},"-",{"$f":"IF(AJ46=TRUE,AN46,0)","v":0},{"$f":"IF(OR(T96=$AE$10,T96=$AE$11),AO46,0)","v":0},{"$f":"IF(T96=$AE$12,AO46,0)","v":0}]
[null,null,null,null,null,"Energy",null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF('Building Input Sheet'!E81=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ47=TRUE,0,1)","v":1},{"$f":"IF(AJ47=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ47=TRUE,AN47,0)","v":0},{"$f":"IF(OR(T105=$AE$10,T105=$AE$11),AO47,0)","v":0},{"$f":"IF(T105=$AE$12,AO47,0)","v":0}]
[null,null,null,null,null,"Greenhouse Gas Emissions","To encourage energy efficient buildings and the reduction of greenhouse gas (GHG) emissions associated with the use of energy in building operations.",15.1,"Conditional Requirement","A","Conditional Requirement",null,"-",{"$f":"M48","v":"-"},{"$f":"IF($L$48<>$AF$9,\"CR\",\"\")","v":"CR"},null,{"$f":"IF(OR(S48=$AE$10,S48=$AE$11),L48,\"\")","v":""},{"$f":"IF(S48=$AE$12,L48,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","NA Available","NA Targeted","NA Awarded","NA Not Awarded"]
[null,null,null,null,null,null,null,15.2,"GHG Emissions Reduction: Reference Building Pathway","A",18,null,"-","-",{"$f":"IF(AND(L49>0,$L$48<>$AF$9),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S49=$AE$10,S49=$AE$11),L49,\"\")","v":""},{"$f":"IF(S49=$AE$12,L49,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN22:AN47)","v":0},{"$f":"SUM(AO22:AO47)","v":0},{"$f":"SUM(AP22:AP47)","v":0},{"$f":"SUM(AQ22:AQ47)","v":0}]
[null,null,null,null,null,"Peak Electricity Demand Reduction","Performance Pathway","16A","Prescriptive Pathway: On-site Energy Generation","A",{"$f":"IF(G50=AC50,1,\"0\")","v":"0"},null,"-",{"$f":"M50","v":"-"},{"$f":"IF(AND(L50>0,G50=\"Performance Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S50=$AE$10,S50=$AE$11),L50,\"\")","v":""},{"$f":"IF(S50=$AE$12,L50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,null,null,"16B","Modelled Performance Pathway: Reference Building","A",{"$f":"IF(G50=AC51,2,\"0\")","v":2},null,"-",{"$f":"M51","v":"-"},{"$f":"IF(AND(L51>0,G50=\"Prescriptive Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S51=$AE$10,S51=$AE$11),L51,\"\")","v":""},{"$f":"IF(S51=$AE$12,L51,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K48:K51)","v":20},{"$f":"SUM(L48:L51)","v":0},{"$f":"SUM(M48:M51)","v":0},0,{"$f":"IF(L52>K52,\"!\",\"\")","v":""},null,{"$f":"SUM(Q48:Q51)","v":0},{"$f":"SUM(R48:R51)","v":0}]
[]
[null,null,null,null,null,"Transport",null,null,null,null,10]
[null,null,null,null,null,"Sustainable Transport","17A Performance Pathway","17A","Performance pathway ","A",{"$f":"IF(G55=AC56,10,\"0\")","v":10},null,"-",{"$f":"M55","v":"-"},{"$f":"IF(AND(L55>0,G55<>AC56),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S55=$AE$10,S55=$AE$11),L55,\"\")","v":""},{"$f":"IF(S55=$AE$12,L55,\"\")","v":""}]
[null,null,null,null,null,null,null,"17B.1","Access by Public Transport","A",{"$f":"IF($G$55=$AC$57,4,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L56>0,$G$55<>$AC$57),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S56=$AE$10,S56=$AE$11),L56,\"\")","v":""},{"$f":"IF(S56=$AE$12,L56,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"17A Performance Pathway"]
[null,null,null,null,null,null,null,"17B.2","Reduced Car Parking Provision","A",{"$f":"IF(OR($G$55=$AC$56,$G$55=$AC$58,C57=TRUE),0,AM39)","v":0},null,{"$f":"IF($G$55=$AC$57,AN39,\"-\")","v":"-"},"-",{"$f":"IF(OR(AND(M57>0,SUM(L56:L60)+SUM(M56:M60)>7),AND(L57>0,$G$55<>$AC$57)),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S57=$AE$10,S57=$AE$11),L57,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,"17B Prescriptive pathway"]
[null,null,null,null,null,null,null,"17B.3","Low Emission Vehicle Infrastructure","A",{"$f":"IF(OR($G$55=$AC$56,$G$55=$AC$58,C58=TRUE),0,AM40)","v":0},null,{"$f":"IF($G$55=$AC$57,AN40,\"-\")","v":"-"},"-",{"$f":"IF(OR(AND(M58>0,SUM(L56:L60)+SUM(M56:M60)>7),AND(L58>0,$G$55<>$AC$57)),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"17C Industrial pathway"]
[null,null,null,null,null,null,null,"17B.4","Active Transport Facilities","A",{"$f":"IF($G$55=$AC$57,2,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L59>0,$G$55<>$AC$57),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S59=$AE$10,S59=$AE$11),L59,\"\")","v":""},""]
[null,null,null,null,null,null,null,"17B.5","Walkable Neighbourhoods","A",{"$f":"IF($G$55=$AC$57,1,\"0\")","v":"0"},null,"-","-","",null,{"$f":"IF(OR(S60=$AE$10,S60=$AE$11),L60,\"\")","v":""},""]
[null,null,null,null,null,null,null,"17C.1","Access by Public Transport","A",{"$f":"IF($G$55=$AC$58,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L61>0,$G$55<>$AC$58),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"17C.2","Reduced Car Parking Provision","A",{"$f":"IF($G$55=$AC$58,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L62>0,$G$55<>$AC$58),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"17C.3","Low Emission Vehicle Infrastructure","A",{"$f":"IF($G$55=$AC$58,5,\"0\")","v":"0"},null,"-","-","",null,"",""]
[null,null,null,null,null,null,null,"17C.4","Active Transport Facilities","A",{"$f":"IF($G$55=$AC$58,2,\"0\")","v":"0"},null,"-","-","",null,"",{"$f":"IF(S64=$AE$12,L64,\"\")","v":""}]
[null,null,null,null,null,null,null,"17C.5","Proximity to Amenities ","A",{"$f":"IF($G$55=$AC$58,2,\"0\")","v":"0"},null,"-","-","",null,"",{"$f":"IF(S65=$AE$12,L65,\"\")","v":""}]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"IF(AND(SUM(K55:K65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(K55:K65)>10,\"!\", SUM(K55:K65)))","v":10},{"$f":"IF(AND(SUM(L55:L65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(L55:L65)>10,\"!\", SUM(L55:L65)))","v":0},{"$f":"SUM(M55:M65)","v":0},{"$f":"IF(AND(SUM(N55:N65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(N55:N65)>10,\"!\", SUM(N55:N65)))","v":0},{"$f":"IF(OR(L66+M66>K66,L66>K66),\"!\",\"\")","v":""},null,{"$f":"IF(AND(SUM(Q55:Q65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(Q55:Q65)>10,\"!\", SUM(Q55:Q65)))","v":0},{"$f":"IF(AND(SUM(R55:R65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(R55:R65)>10,\"!\", SUM(R55:R65)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Water",null,null,null,null,10]
[null,null,null,null,null,"Potable Water","Performance Pathway","18A","Potable Water - Performance Pathway","A",{"$f":"IF(G69=AC69,10,\"0\")","v":10},null,"-",{"$f":"M69","v":"-"},{"$f":"IF(AND(L69>0,$G$69<>$AC$69),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S69=$AE$10,S69=$AE$11),L69,\"\")","v":""},{"$f":"IF(S69=$AE$12,L69,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,null,null,"18B.1","Sanitary Fixture Efficiency","A",{"$f":"IF($G$69=$AC$70,1,0)","v":0},null,"-","-",{"$f":"IF(AND(L70>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,null,null,"18B.2","Rainwater Reuse","A",{"$f":"IF($G$69=$AC$70,1,0)","v":0},null,"-","-",{"$f":"IF(AND(L71>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"18B.3","Heat Rejection","A",{"$f":"IF($G$69=$AC$70,1,0)","v":0},null,"-","-",{"$f":"IF(AND(L72>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"18B.4","Landscape Irrigation","A",{"$f":"IF(OR($G$69=$AC$69,C73=TRUE),0,AM41)","v":0},null,{"$f":"IF($G$69=$AC$70,AN41,\"-\")","v":"-"},"-",{"$f":"IF(AND(L73>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"18B.5","Fire System Test Water","A",{"$f":"IF(OR($G$69=$AC$69,C74=TRUE),0,AM42)","v":0},null,{"$f":"IF($G$69=$AC$70,AN42,\"-\")","v":"-"},"-",{"$f":"IF(AND(L74>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K69:K74)","v":10},{"$f":"SUM(L69:L74)","v":0},{"$f":"SUM(M69:M74)","v":0},0,{"$f":"IF(L75>K75,\"!\",\"\")","v":""},null,{"$f":"SUM(Q69:Q74)","v":0},0]
[]
[null,null,null,null,null,"Materials",null,null,null,null,18]
[null,null,null,null,null,"Life Cycle Impacts ","Reference Building Pathway - Upfront Carbon Reduction",19.100000000000001,"Upfront Carbon Reduction ","B","Conditional Requirement",null,"-",{"$f":"M78","v":"-"},{"$f":"IF($L$78<>$AF$9,\"CR\",\"\")","v":"CR"},null,{"$f":"IF(OR(S78=$AE$10,S78=$AE$11),L78,\"\")","v":""},{"$f":"IF(S78=$AE$12,L78,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Absolute Value Pathway - Upfront Carbon Reduction"]
[null,null,null,null,null,null,null,"19.1A","Absolute Value Pathway - Upfront Carbon Reduction ","B",{"$f":"IF(G78=AC78,6,\"0\")","v":"0"},null,"-","-",{"$f":"IF(OR(AND(L79>0,$L$78<>$AF$9),AND(L79>0,G78<>AC78)),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Reference Building Pathway - Upfront Carbon Reduction"]
[null,null,null,null,null,null,null,"19.1B","Reference Building Pathway - Upfront Carbon Reduction ","B",{"$f":"IF(G78=AC79,6,\"0\")","v":6},null,"-","-",{"$f":"IF(OR(AND(L80>0,$L$78<>$AF$9),AND(L80>0,G78<>AC79)),\"!\",\"\")","v":""},null,"",{"$f":"IF(S80=$AE$12,L80,\"\")","v":""}]
[null,null,null,null,null,null,null,19.2,"Comparative Life Cycle Assessment ","B",3,null,"-","-",{"$f":"IF(AND(L81>0,$L$78<>$AF$9),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,19.3,"Long-term Carbon Storage","B",2,null,"-","-",{"$f":"IF(AND(L82>0,$L$78<>$AF$9),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,"Responsible Building Materials","To reward projects that include building materials that are responsibly sourced or have a sustainable supply chain.",20.100000000000001,"Structural and Reinforcing Steel","B",{"$f":"AM43","v":1},null,{"$f":"AN43","v":"-"},"-","",null,"",""]
[null,null,null,null,null,null,null,20.2,"Timber ","B",{"$f":"AM44","v":1},null,{"$f":"AN44","v":"-"},"-","",null,{"$f":"IF(OR(S84=$AE$10,S84=$AE$11),L84,\"\")","v":""},""]
[null,null,null,null,null,null,null,20.3,"Permanent Formwork, Pipes, Flooring, Blinds and Cables","B",{"$f":"AM45","v":1},null,{"$f":"AN45","v":"-"},"-","",null,"",""]
[null,null,null,null,null,"Sustainable Products","To encourage sustainability and transparency in product specification.",21,"Product Transparency and Sustainability","B",3,null,"-","-",null,null,{"$f":"IF(OR(S86=$AE$10,S86=$AE$11),L86,\"\")","v":""},""]
[null,null,null,null,null,"Construction and Demolition Waste",null,22.1,"Reporting Accuracy","B","Minimum Requirement",null,"-","-",null,null,"",""]
[null,null,null,null,null,null,"Percentage Benchmark","22..2A","Fixed Benchmark","B",{"$f":"IF(G88=AC88,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L88>0,OR(G88=\"Percentage Benchmark\",L87<>$AF$9)),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Fixed Benchmark"]
[null,null,null,null,null,null,null,"22.2B","Percentage Benchmark","B",{"$f":"IF(G88=AC89,1,\"0\")","v":1},null,"-","-",{"$f":"IF(AND(L89>0,OR(G88=AC88,L87<>$AF$9)),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S89=$AE$10,S89=$AE$11),L89,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,"Percentage Benchmark"]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K78:K89)","v":18},{"$f":"SUM(L78:L89)","v":0},{"$f":"SUM(M78:M89)","v":0},{"$f":"SUM(N78:N89)","v":0},{"$f":"IF(L90>K90,\"!\",\"\")","v":""},null,{"$f":"SUM(Q78:Q89)","v":0},{"$f":"SUM(R78:R89)","v":0}]
[]
[null,null,null,null,null,"Land Use & Ecology",null,null,null,null,5]
[null,null,null,null,null,"Ecological Value","To reward projects that improve the ecological value of their site.",23,"Ecological Value","A",3,null,"-",{"$f":"M93","v":"-"},null,null,{"$f":"IF(OR(S93=$AE$10,S93=$AE$11),L93,\"\")","v":""},{"$f":"IF(S93=$AE$12,L93,\"\")","v":""}]
[null,null,null,null,null,"Sustainable Sites","To reward projects that choose to develop sites that have limited ecological value, that reuse previously developed land, and that remediate contaminated land.",24.1,"Conditional Requirement: Ecological Protection","A","Conditional Requirement",null,"-","-",{"$f":"IF($L$94<>$AF$9,\"CR\",\"\")","v":"CR"},null,{"$f":"IF(OR(S94=$AE$10,S94=$AE$11),L94,\"\")","v":""},{"$f":"IF(S94=$AE$12,L94,\"\")","v":""}]
[null,null,null,null,null,null,null,24.2,"Reuse of Land","A",1,null,"-","-",{"$f":"IF(AND(L95>0,$L$94<>$AF$9),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S95=$AE$10,S95=$AE$11),L95,\"\")","v":""},""]
[null,null,null,null,null,null,null,24.3,"Contamination and Hazardous Materials","A",{"$f":"IF(C96=FALSE,AM46,0)","v":1},null,{"$f":"AN46","v":"-"},"-",{"$f":"IF(AND(OR(M96<>\"-\",L96>0),$L$94<>$AF$9),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S96=$AE$10,S96=$AE$11),L96,\"\")","v":""},""]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K93:K96)","v":5},{"$f":"SUM(L93:L96)","v":0},{"$f":"SUM(M93:M96)","v":0},0,{"$f":"IF(L97>K97,\"!\",\"\")","v":""},null,{"$f":"SUM(Q93:Q96)","v":0},{"$f":"SUM(R93:R96)","v":0}]
[]
[null,null,null,null,null,"Emissions",null,null,null,null,5]
[null,null,null,null,null,"Stormwater","To reward projects that minimise peak storm water outflows from the site and reduce pollutants entering the public sewer infrastructure or other water bodies.",25.1,"Stormwater Peak Discharge","A",1,null,"-",{"$f":"M100","v":"-"},null,null,{"$f":"IF(OR(S100=$AE$10,S100=$AE$11),L100,\"\")","v":""},{"$f":"IF(S100=$AE$12,L100,\"\")","v":""}]
[null,null,null,null,null,null,null,25.2,"Stormwater Pollution Targets","A",1,null,"-","-",null,null,"",{"$f":"IF(S101=$AE$12,L101,\"\")","v":""}]
[null,null,null,null,null,"Light Pollution","To reward projects that minimise light pollution.",26.1,"Light Pollution to Neighbouring Bodies","A","Minimum Requirement",null,"-","-",null,null,"",{"$f":"IF(S102=$AE$12,L102,\"\")","v":""}]
[null,null,null,null,null,null,null,26.2,"Light Pollution to Night Sky","A",1,null,"-","-",{"$f":"IF(AND(L103>0,L102<>$AF$9),\"!\",\"\")","v":""},null,"",{"$f":"IF(S103=$AE$12,L103,\"\")","v":""}]
[null,null,null,null,null,"Microbial Control","To recognise projects that implement systems to minimise the impacts associated with harmful microbes in building cooling systems.",27,"Legionella Impacts from Cooling Systems","A",1,null,"-","-",null,null,"",{"$f":"IF(S104=$AE$12,L104,\"\")","v":""}]
[null,null,null,null,null,"Refrigerant Impacts","To encourage practices that minimise the environmental impacts of refrigeration and air conditioning equipment.",28,"Refrigerants Impacts","A",{"$f":"AM47","v":1},null,{"$f":"AN47","v":"-"},"-","",null,"",{"$f":"IF(S105=$AE$12,L105,\"\")","v":""}]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K100:K105)","v":5},{"$f":"SUM(L100:L105)","v":0},{"$f":"SUM(M100:M105)","v":0},0,{"$f":"IF(L106>K106,\"!\",\"\")","v":""},null,{"$f":"SUM(Q100:Q105)","v":0},0]
[]
[null,null,null,null,null,"Innovation",null,null,null,null,10]
[null,null,null,null,null,"Innovative Technology or Process","The project meets the aims of an existing credit using a technology or process that is considered innovative in New Zealand or the world.",29.1,"Innovative Technology or Process","A",10,null,"-",{"$f":"M109","v":"-"},null,null,{"$f":"IF(OR(S109=$AE$10,S109=$AE$11),L109,\"\")","v":""},{"$f":"IF(S109=$AE$12,L109,\"\")","v":""}]
[null,null,null,null,null,"Market Transformation","The project has undertaken a sustainability initiative that substantially contributes to the broader market transformation towards sustainable development in New Zealand or in the world.",29.2,"Market Transformation","A",null,null,"-","-",null,null,{"$f":"IF(OR(S110=$AE$10,S110=$AE$11),L110,\"\")","v":""},{"$f":"IF(S110=$AE$12,L110,\"\")","v":""}]
[null,null,null,null,null,"Improving on Green Star Benchmarks","The project has achieved full points in a Green Star credit and demonstrates a substantial improvement on the benchmark required to achieve full points.\nFor credits where this Innovation criterion is applicable, improved benchmarks are included in the ‘Innovation’ section of the credit.",29.3,"Improving on Green Star Benchmarks","A",null,null,"-","-",null,null,{"$f":"IF(OR(S111=$AE$10,S111=$AE$11),L111,\"\")","v":""},""]
[null,null,null,null,null,"Innovation Challenge","The project can target any of the current Innovation Challenges that are published on the NZGBC and GBCA website. Alternatively, where the project addresses a sustainability issue not included within any of the credits in the existing Green Star rating tools, projects may propose a new Innovation Challenge.",29.4,"Innovation Challenge","A",null,null,"-","-",null,null,{"$f":"IF(OR(S112=$AE$10,S112=$AE$11),L112,\"\")","v":""},""]
[null,null,null,null,null,"Global Sustainability","Project teams may adopt an approved credit from a Global Green Building Rating tool that addresses a sustainability issue that is currently outside the scope of this Green Star rating tool.",29.5,"Global Sustainability","A",null,null,"-","-",null,null,{"$f":"IF(OR(S113=$AE$10,S113=$AE$11),L113,\"\")","v":""},""]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K109)","v":10},{"$f":"IF(SUM(L109:L113)>10,10,SUM(L109:L113))","v":0},null,null,{"$f":"IF(L114>K114,\"!\",\"\")","v":""},null,{"$f":"SUM(Q109:Q113)","v":0},0]
[]
[null,null,null,null,null,null,null,null,"TOTALS",null,"AVAILABLE","TARGETED",null,null,null,null,"AWARDED","TBC"]
[null,null,null,null,null,null,null,null,"CORE POINTS",null,{"$f":"100-AO49","v":100},{"$f":"L25+L45+L52+L66+L75+L90+L97+L106","v":0},null,null,null,null,{"$f":"(Q25+Q45+Q52+Q66+Q75+Q90+Q97+Q106)/(100-AP49)*100+Q114","v":0},{"$f":"(R25+R45+R52+R66+R75+R90+R97+R106)/(100-AP49)*100+R114","v":0}]
[null,null,null,null,null,null,null,null,"CATEGORY PERCENTAGE SCORE",null,null,{"$f":"L117/K117*100","v":0}]
[null,null,null,null,null,null,null,null,"INNOVATION POINTS",null,10,{"$f":"L114","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL SCORE TARGETED",null,null,{"$f":"L118+L119","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome Count","Assessment result"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 1",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0},{"$f":"IF(S127>#REF!*0.5, \"Go to Stage 2\", \"Assessment Complete\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 2",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0},{"$f":"IF(AND(T127=\"Go to Stage 2\",#REF!= 0),T127,IF(S128>SUM(#REF!)*0.5,\"Go to Stage 3\",\"Assessment Complete\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 3",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(S8:S105,\"Awarded - Compliant\")+COUNTIF(S8:S105,\"Awarded - Minor non-Compliance\")+COUNTIF(S8:S105,\"Not Awarded - Major non-compliance\")","v":0},{"$f":"IF(T127=\"Assessment Complete\",T127,IF(T128=\"Assessment Complete\",T128,IF(#REF!>=1,T128,\"Assessment Complete\")))","v":{"$error":"#REF!"}}]

{"sheet":"Built Scorecard","index":5,"n_rows":130,"n_cols":43,"rows_kept":130,"cut":false,"hidden":false,"merged":[[107,5,107,8],[108,10,112,10],[93,5,95,5],[93,6,95,6],[98,5,98,8],[99,5,100,5],[99,6,100,6],[101,5,102,5],[101,6,102,6],[82,5,84,5],[82,6,84,6],[86,5,88,5],[87,6,88,6],[91,5,91,8],[91,16,91,17],[54,5,64,5],[54,6,64,6],[68,5,73,5],[68,6,73,6],[77,5,81,5],[77,6,79,6],[80,6,81,6],[42,5,43,5],[42,6,43,6],[46,5,46,8],[47,5,48,5],[47,6,48,6],[49,5,50,5],[49,6,50,6],[33,5,36,5],[33,6,36,6],[37,5,39,5],[37,6,39,6],[40,5,41,5],[40,6,41,6],[22,5,23,5],[22,6,23,6],[26,5,26,8],[27,5,29,5],[27,6,29,6],[30,5,32,5],[30,6,32,6],[15,5,16,5],[15,6,16,6],[17,5,18,5],[17,6,18,6],[19,5,21,5],[19,6,21,6],[4,21,4,23],[4,25,4,27],[8,5,10,5],[8,6,10,6],[11,5,13,5],[11,6,13,6],[2,6,2,7],[2,21,2,23],[2,25,2,27],[3,6,3,7],[3,21,3,23],[3,25,3,27],[0,5,0,8],[0,20,0,23],[0,24,0,27],[1,6,1,7],[1,21,1,23],[1,25,1,27]]}
[null,null,null,null,null,"Green Star - Design & As Built NZv1.1 Scorecard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ROUND 1 ",null,null,null,"ROUND 2",null,null,null,"x","x","x","x"]
[null,null,null,null,null,"Project:",null,null,null,null,"Core Points Available (Targeted)","Project Score (Targeted)","NA Targeted",null,null,null,"Project Score (Awarded)","Total Points TBC","NA Awarded","NA TBC",null,"Post Round 1 Clarification \nPlease enter type of clarification for each credit as follows:",null,null,null,"Post Round 2 Clarification \nPlease enter type of clarification for each credit as follows:"]
[null,null,null,null,null,"Targeted Rating:",{"$f":"IF(AND(L3>=75,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"6 Stars - World Leadership\",IF(AND(L3>=60,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"5 Star - New Zealand Excellence\",IF(AND(L3>=45,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"4 Star - New Zealand Best Practice\",\"\")))","v":""},null,null,null,{"$f":"K117","v":100},{"$f":"L120","v":0},{"$f":"AO49","v":0},null,null,null,{"$f":"Q117","v":0},{"$f":"R117","v":0},{"$f":"AJ18","v":0},{"$f":"AJ19","v":0},null,"1. Documentation Clarification: The project team wish to clarify the documentation requested in the Round 1 Assessment Comment ",null,null,null,"1. Documentation Clarification: The project team wish to clarify the documentation requested in the Round 1 Assessment Comment "]
[null,null,null,null,null,"Rating Achieved:",{"$f":"IF(AND(Q3>=75,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"6 Stars - World Leadership\",IF(AND(Q3>=60,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"5 Star - New Zealand Excellence\",IF(AND(Q3>=45,O9<>\"CR\",O12<>\"CR\",O48<>\"CR\",O78<>\"CR\",O94<>\"CR\"),\"4 Star - New Zealand Best Practice\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Complaince Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements.",null,null,null,"2. Complaince Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Check Existing Documentation: The project team wish to draw the Assesors' attention to documentation submitted previously that may have been overlooked during the assessment. ",null,null,null,"3. Check Existing Documentation: The project team wish to draw the Assesors' attention to documentation submitted previously that may have been overlooked during the assessment. "]
[null,null,null,null,null,"CATEGORY / CREDIT","AIM OF THE CREDIT / SELECTION","CODE","CREDIT CRITERIA","INTEGRATED/ COLD SHELL CREDIT TYPE","POINTS AVAILABLE","POINTS TARGETED","NA AVAILABLE","NA TARGETED",null,null," POINTS AWARDED"," POINTS \nTBC","POINTS OUTCOME","NA OUTCOME"," Rd1 ASSESSMENT COMMENTS","Type","Clarification Request \n(GSAP to complete)","Clarification from Assessors\n(To be completed by Assessors) "," Rd2 ASSESSMENT COMMENTS","Type","Clarification Request \n(GSAP to complete)","Clarification from Assessors\n(To be Completed by Assessors) "]
[null,null,null,null,null,"Management",null,null,null,null,15,null,null,null,null,null,null,null,null,null,"(Completed by Assessors only)",null,null,"Assessors comments including Point(s) Awarded/Denied","(Completed by Assessors only)",null,null,"Assessors comments including Point(s) Awarded/Denied",null,null,null,null,null,null,"NA Points Calculations",null,null,null,null,null," "]
[null,null,null,null,null,"Green Star Accredited Professional","To recognise projects that engage a Green Star Accredited Professional to support the Green Star certification process.",1,"Green Star Accredited Professional","A",1,null,"-",{"$f":"M8","v":"-"},null,null,{"$f":"IF(OR(S8=$AE$10,S8=$AE$11),L8,\"\")","v":""},{"$f":"IF(S8=$AE$12,L8,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please enter the Total Primary & Secondary Spaces for your project (m2)",{"$f":"'Building Input Sheet'!D104","v":0}]
[null,null,null,null,null,"Commissioning and Tuning","To encourage and recognise commissioning, handover and tuning initiatives that ensure all building services operate to their full potential and as designed.",2.1,"Conditonal Requirement ","A",2,null,"-",{"$f":"M9","v":"-"},{"$f":"IF($L$9<>2,\"CR\",\"\")","v":"CR"},null,"","",null,null,null,null,null,null,null,null,null,null,"Performance Pathway",null,null,"Complies",null,null,"Please enter the Total Primary & Secondary Spaces for your project that are delivered as Cold shell (m2)",{"$f":"'Building Input Sheet'!D105","v":0}]
[null,null,null,null,null,null,null,2.2000000000000002,"Services and Maintainability Review","A",1,null,"-","-",{"$f":"IF(AND(L10>0,$L$9<>2),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway","Core","Awarded - Compliant","Does not comply",null,null,"Please enter the Total Primary & Secondary Spaces for your project that are delivered as Integrated Fitout (m2)",{"$f":"'Building Input Sheet'!D106","v":0}]
[null,null,null,null,null,null,null,2.2999999999999998,"Independent Commissioning Agent","A",1,null,"-","-",{"$f":"IF(AND(L11>0,$L$9<>2),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,"Stage 1","Awarded - Minor non-compliance",null,null,null,"Total Primary & Secondary areas delivered as Cold Shell(%)",{"$f":"IF(ISERROR(AJ9/AJ8),0, AJ9/AJ8)","v":0}]
[null,null,null,null,null,"Adaptation and Resilience","To encourage and recognise projects that are resilient to the impacts of a changing climate and natural disasters.",3.1,"Climate Change Pre-Screening Checklist ","Conditional Requirement ","Conditional Requirement ",null,"-","-",{"$f":"IF($L$12<>AF9,\"CR\",\"\")","v":"CR"},null,"","",null,null,null,null,null,null,null,null,null,null,null,"Stage 2","Not Awarded - Major non-compliance",null,null,null,"Are there any Traditional \"NA\" Credits being targeted",{"$f":"IF('Building Input Sheet'!D53=\"Yes\",\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,3.2,"Climate Change Risk Assessment and Adaptation Plan",2,2,null,"-","-",{"$f":"IF(AND(L13>0,$L$12<>$AF$9),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,3.3,"Earthquake Resilience ",1,1,null,"-","-",{"$f":"IF(AND(L14>0,$L$12<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Points ratio for type C credits based on Cold Shell and Integrated area",{"$f":"ROUND(IF('Building Input Sheet'!D107+'Building Input Sheet'!D108>=0.95,0,IF('Building Input Sheet'!D107+'Building Input Sheet'!D108<=0.05,1,1-('Building Input Sheet'!D107+'Building Input Sheet'!D108))),2)","v":1}]
[null,null,null,null,null,"Building Information","To recognise the development and provision of building information that facilitates operator and user understanding of a building's systems, their operation and maintenance requirements, and their environmental targets, to enable optimised performance.",4.0999999999999996,"Building Information","A",1,null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"Points ratio for type C credits based on Cold Shell area (Integrated fitout full compliance)",{"$f":"ROUND(IF('Building Input Sheet'!D107>=0.95,0,IF('Building Input Sheet'!D107<=0.05,1,1-'Building Input Sheet'!D107)),2)","v":1}]
[null,null,null,null,null,"Commitment to Performance","To recognise practices that encourage building owners, building occupants and facilities management teams to set targets and monitor environmental performance in a collaborative way.",5.0999999999999996,"Environmental Building Performance","A",1,null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,"Total points that have been made NA by the project team",{"$f":"AN49","v":0}]
[null,null,null,null,null,null,null,5.2,"End of Life Waste Performance","A",1,null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,"Total NA points that have been targeted",{"$f":"AO49","v":0}]
[null,null,null,null,null,"Metering and Monitoring","To recognise the implementation of effective energy and water metering and monitoring systems.",6.1,"Metering","A","Minimum Requirement",null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NA points that have been awarded ",{"$f":"AP49","v":0}]
[null,null,null,null,null,null,null,6.2,"Monitoring Systems","A",1,null,"-","-",{"$f":"IF(AND(L19>0,$L$18<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total NA points that have not been awarded",{"$f":"AQ49","v":0}]
[null,null,null,null,null,"Responsible Construction Practices","To reward responsible construction practices that manage environmental impacts, enhance staff health and wellbeing, and improve sustainability knowledge on site.",7.1,"Environmental Management Plan","B","Minimum Requirement",null,"-","-",null,null,"",""]
[null,null,null,null,null,null,null,7.2,"Formalised Environmental Management System","B",1,null,"-","-",{"$f":"IF(AND(L21>0,$L$20<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Available NA Credits","NA Targeted","Integrated Fitout Compliance","Type C Credits overlap","Points Available","NA Points Available","NA points Targeted","NA Awarded","NA Not Awarded"]
[null,null,null,null,null,null,null,7.3,"High Quality Staff Support","B",1,null,"-","-",{"$f":"IF(AND(L22>0,$L$20<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1,{"$f":"IF('Building Input Sheet'!E58=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ22=TRUE,0,1)","v":1},{"$f":"IF(AJ22=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ22=TRUE,AN22,0)","v":0},{"$f":"IF(OR(T28=$AE$10,T28=$AE$11),AO22,0)","v":0},{"$f":"IF(T28=$AE$12,AO22,0)","v":0}]
[null,null,null,null,null,"Operational Waste","Performance Pathway","8A","Performance Pathway - Specialist Plan","A",{"$f":"IF(G23=AC9,1,\"0\")","v":1},null,"-","-",{"$f":"IF(AND(L23>0,G23=\"Prescriptive Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S23=$AE$10,S23=$AE$11),L23,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1999999999999993,{"$f":"IF('Building Input Sheet'!E59=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ23=TRUE,0,2)","v":2},{"$f":"IF(AJ23=TRUE,2,\"-\")","v":"-"},{"$f":"IF(AJ23=TRUE,AN23,0)","v":0},0,0]
[null,null,null,null,null,null,null,"8B","Prescriptive Pathway - Facilities","A",{"$f":"IF(G23=AC10,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L24>0,G23=\"Performance Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S24=$AE$10,S24=$AE$11),L24,\"\")","v":""},{"$f":"IF(S24=$AE$12,L24,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.3000000000000007,{"$f":"IF('Building Input Sheet'!E60=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ24=TRUE,0,1)","v":1},{"$f":"IF(AJ24=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ24=TRUE,AN24,0)","v":0},0,0]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K8:K24)","v":15},{"$f":"SUM(L8:L24)","v":0},{"$f":"SUM(M8:M24)","v":0},{"$f":"SUM(N8:N24)","v":0},{"$f":"IF(L25>K25,\"!\",\"\")","v":""},null,{"$f":"SUM(Q8:Q24)","v":0},{"$f":"SUM(R8:R24)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.1,{"$f":"IF('Building Input Sheet'!E61=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ25=TRUE,0,1)","v":1},{"$f":"IF(AJ25=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ25=TRUE,AN25,0)","v":0},0,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,null,null,null,10.199999999999999,{"$f":"IF('Building Input Sheet'!E62=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E90=\"Yes\",TRUE,FALSE)","v":false},10.199999999999999,{"$f":"IF(AJ26=TRUE,0,IF(AK26=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ26=TRUE,1,IF(AK26=TRUE,1-AM26,\"-\"))","v":"-"},{"$f":"N32","v":0},0,0]
[null,null,null,null,null,"Indoor Environment Quality",null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.3,{"$f":"IF('Building Input Sheet'!E63=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E91=\"Yes\",TRUE,FALSE)","v":false},10.3,{"$f":"IF(AJ27=TRUE,0,IF(AK27=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ27=TRUE,1,IF(AK27=TRUE,1-AM27,\"-\"))","v":"-"},"-",0,0]
[null,null,null,null,null,"Indoor Air Quality","To recognise projects that provide high indoor air quality to occupants.",9.1,"Ventilation System Attributes","A",{"$f":"AM22","v":1},null,{"$f":"AN22","v":"-"},{"$f":"M28","v":"-"},null,null,{"$f":"IF(OR(S28=$AE$10,S28=$AE$11),L28,\"\")","v":""},{"$f":"IF(S28=$AE$12,L28,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Building Input Sheet'!E92=\"Yes\",TRUE,FALSE)","v":false},11.1,0,"-","-",0,0]
[null,null,null,null,null,null,null,9.1999999999999993,"Provision of Outdoor Air","A",{"$f":"AM23","v":2},null,{"$f":"AN23","v":"-"},{"$f":"M29","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.2,{"$f":"IF('Building Input Sheet'!E64=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E93=\"Yes\",TRUE,FALSE)","v":false},11.2,{"$f":"IF(AJ29=TRUE,0,IF(AK29=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ29=TRUE,1,IF(AK29=TRUE,1-AM29,\"-\"))","v":"-"},"-",{"$f":"IF(OR(T35=$AE$10,T35=$AE$11),AO29,0)","v":0},{"$f":"IF(T35=$AE$12,AO29,0)","v":0}]
[null,null,null,null,null,null,null,9.3000000000000007,"Exhaust or Elimination of Pollutants","A",1,null,{"$f":"AN24","v":"-"},"-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.3,{"$f":"IF('Building Input Sheet'!E65=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E94=\"Yes\",TRUE,FALSE)","v":false},11.3,{"$f":"IF(AJ30=TRUE,0,IF(AK30=FALSE,$AJ$14,$AJ$15))","v":1},"-","-",{"$f":"IF(OR(T36=$AE$10,T36=$AE$11),AO30,0)","v":0},{"$f":"IF(T36=$AE$12,AO30,0)","v":0}]
[null,null,null,null,null,"Acoustic Comfort","To reward projects that provide appropriate and comfortable acoustic conditions for occupants.",10.1,"Internal Noise Levels","A",1,null,{"$f":"AN25","v":"-"},{"$f":"M31","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.4,{"$f":"IF('Building Input Sheet'!E66=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E95=\"Yes\",TRUE,FALSE)","v":false},11.4,{"$f":"IF(AJ31=TRUE,0,IF(AK31=FALSE,$AJ$14,$AJ$15))","v":1},"-","-",{"$f":"IF(OR(T37=$AE$10,T37=$AE$11),AO31,0)","v":0},{"$f":"IF(T37=$AE$12,AO31,0)","v":0}]
[null,null,null,null,null,null,null,10.199999999999999,"Reverberation","C",{"$f":"AM26","v":1},null,"-",null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Building Input Sheet'!E96=\"Yes\",TRUE,FALSE)","v":false},12.1,0,"-","-",0,0]
[null,null,null,null,null,null,null,10.3,"Acoustic Separation","C",1,null,"-",{"$f":"M33","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.2,{"$f":"IF('Building Input Sheet'!E67=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ33=TRUE,0,2)","v":2},{"$f":"IF(AJ33=TRUE,2,\"-\")","v":"-"},{"$f":"IF(AJ33=TRUE,AN33,0)","v":0},{"$f":"IF(OR(T39=$AE$10,T39=$AE$11),AO33,0)","v":0},{"$f":"IF(T39=$AE$12,AO33,0)","v":0}]
[null,null,null,null,null,"Lighting Comfort","To encourage and recognise well-lit spaces that provide a high degree of comfort to users.",11.1,"Minimum Lighting Comfort","C","Minimum Requirement",null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.3,{"$f":"IF('Building Input Sheet'!E68=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ34=TRUE,0,1)","v":1},{"$f":"IF(AJ34=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ34=TRUE,AN34,0)","v":0},0,0]
[null,null,null,null,null,null,null,11.2,"General Illuminance and Glare Reduction","C",1,null,{"$f":"AN29","v":"-"},{"$f":"M35","v":"-"},{"$f":"IF(AND(OR(L35>0,AND(M35>0,M35<>\"-\")),$L$34<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.1,{"$f":"IF('Building Input Sheet'!E69=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E97=\"Yes\",TRUE,FALSE)","v":false},13.1,{"$f":"IF(AJ35=TRUE,0,IF(AK35=FALSE,$AJ$14,$AJ$15))","v":1},{"$f":"IF(AJ35=TRUE,1,IF(AK35=TRUE,1-AM35,\"-\"))","v":"-"},{"$f":"N41","v":"-"},0,0]
[null,null,null,null,null,null,null,11.3,"Surface Illuminance","C",1,null,{"$f":"AN30","v":"-"},"-",{"$f":"IF(AND(OR(L36>0,AND(M36>0,M36<>\"-\")),$L$34<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.2,{"$f":"IF('Building Input Sheet'!E70=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF('Building Input Sheet'!E98=\"Yes\",TRUE,FALSE)","v":false},13.2,{"$f":"IF(AJ36=TRUE,0,IF(AK36=FALSE,$AJ$14,$AJ$15))","v":1},"-",{"$f":"N42","v":"-"},0,0]
[null,null,null,null,null,null,null,11.4,"Localised Lighting Control","C",1,null,{"$f":"AN31","v":"-"},"-",{"$f":"IF(AND(OR(L37>0,AND(M37>0,M37<>\"-\")),$L$34<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.1,{"$f":"IF('Building Input Sheet'!E71=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ37=TRUE,0,1)","v":1},{"$f":"IF(AJ37=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ37=TRUE,AN37,0)","v":0},0,0]
[null,null,null,null,null,"Visual Comfort","To recognise the delivery of well-lit spaces that provide high levels of visual comfort to building occupants.",12.1,"Glare Reduction","C","Minimum Requirement",null,"-","-",null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.2,{"$f":"IF('Building Input Sheet'!E72=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ38=TRUE,0,1)","v":1},{"$f":"IF(AJ38=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AJ38=TRUE,AN38,0)","v":0},0,0]
[null,null,null,null,null,null,null,12.2,"Daylight","A",2,null,{"$f":"AN33","v":"-"},"-",{"$f":"IF(AND(OR(L39>0,M39<>\"-\"),$L$38<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17B.2",{"$f":"IF('Building Input Sheet'!E73=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ39=TRUE,0,1)","v":1},{"$f":"IF(AJ39=TRUE,1,\"-\")","v":"-"},{"$f":"IF(AND(AJ39=TRUE,G55=AC57),AN39,0)","v":0},{"$f":"IF(OR(T57=$AE$10,T57=$AE$11),AO39,0)","v":0},{"$f":"IF(T57=$AE$12,AO39,0)","v":0}]
[null,null,null,null,null,null,null,12.3,"Views","A",1,null,{"$f":"AN34","v":"-"},"-",{"$f":"IF(AND(OR(L40>0,M40<>\"-\"),$L$38<>$AF$9),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17B.3",{"$f":"IF('Building Input Sheet'!E74=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ40=TRUE,0,2)","v":2},{"$f":"IF(AJ40=TRUE,2,\"-\")","v":"-"},{"$f":"IF(AND(AJ40=TRUE,G55=AC57),AN40,0)","v":0},{"$f":"IF(OR(T58=$AE$10,T58=$AE$11),AO40,0)","v":0},{"$f":"IF(T58=$AE$12,AO40,0)","v":0}]
[null,null,null,null,null,"Indoor Pollutants","To recognise projects that safeguard occupant health through the reduction in internal air pollutant levels.",13.1,"Paints, Adhesives, Sealants and Carpets","C",1,null,"-","-",null,null,{"$f":"IF(OR(S41=$AE$10,S41=$AE$11),L41,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18B.4",{"$f":"IF('Building Input Sheet'!E75=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ41=TRUE,0,1)","v":1},"-",{"$f":"IF(AND(AJ41=TRUE,G69=AC70),AN41,0)","v":0},{"$f":"IF(OR(T73=$AE$10,T73=$AE$11),AO41,0)","v":0},{"$f":"IF(T73=$AE$12,AO41,0)","v":0}]
[null,null,null,null,null,null,null,13.2,"Engineered Wood Products","C",1,null,"-","-",null,null,{"$f":"IF(OR(S42=$AE$10,S42=$AE$11),L42,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18B.5",{"$f":"IF('Building Input Sheet'!E76=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ42=TRUE,0,1)","v":1},"-",{"$f":"IF(AND(AJ42=TRUE,G69=AC70),AN42,0)","v":0},{"$f":"IF(OR(T74=$AE$10,T74=$AE$11),AO42,0)","v":0},{"$f":"IF(T74=$AE$12,AO42,0)","v":0}]
[null,null,null,null,null,"Thermal Comfort","To recognise projects that achieve high levels of thermal comfort.",14.1,"Thermal Comfort","A",1,null,"-","-",null,null,{"$f":"IF(OR(S43=$AE$10,S43=$AE$11),L43,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.100000000000001,{"$f":"IF('Building Input Sheet'!E77=\"Yes\",TRUE,FALSE)","v":false},null,null,1,"-",{"$f":"IF(AJ43=TRUE,AN43,0)","v":0},{"$f":"IF(OR(T83=$AE$10,T83=$AE$11),AO43,0)","v":0},{"$f":"IF(T83=$AE$12,AO43,0)","v":0}]
[null,null,null,null,null,null,null,14.2,"Advanced Thermal Comfort","A",1,null,"-","-",null,null,{"$f":"IF(OR(S44=$AE$10,S44=$AE$11),L44,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.2,{"$f":"IF('Building Input Sheet'!E78=\"Yes\",TRUE,FALSE)","v":false},null,null,1,"-",{"$f":"IF(AJ44=TRUE,AN44,0)","v":0},{"$f":"IF(OR(T84=$AE$10,T84=$AE$11),AO44,0)","v":0},{"$f":"IF(T84=$AE$12,AO44,0)","v":0}]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K28:K44)","v":17},{"$f":"SUM(L28:L44)","v":0},{"$f":"SUM(M28:M44)","v":0},0,{"$f":"IF(L45>K45,\"!\",\"\")","v":""},null,{"$f":"SUM(Q28:Q44)","v":0},{"$f":"SUM(R28:R44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20.3,{"$f":"IF('Building Input Sheet'!E79=\"Yes\",TRUE,FALSE)","v":false},null,null,1,"-",{"$f":"IF(AJ45=TRUE,AN45,0)","v":0},{"$f":"IF(OR(T85=$AE$10,T85=$AE$11),AO45,0)","v":0},{"$f":"IF(T85=$AE$12,AO45,0)","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,null,null,null,24.3,{"$f":"IF('Building Input Sheet'!E80=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ46=TRUE,0,1)","v":1},"-",{"$f":"IF(AJ46=TRUE,AN46,0)","v":0},{"$f":"IF(OR(T96=$AE$10,T96=$AE$11),AO46,0)","v":0},{"$f":"IF(T96=$AE$12,AO46,0)","v":0}]
[null,null,null,null,null,"Energy",null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,{"$f":"IF('Building Input Sheet'!E81=\"Yes\",TRUE,FALSE)","v":false},null,null,{"$f":"IF(AJ47=TRUE,0,1)","v":1},"-",{"$f":"IF(AJ47=TRUE,AN47,0)","v":0},{"$f":"IF(OR(T105=$AE$10,T105=$AE$11),AO47,0)","v":0},{"$f":"IF(T105=$AE$12,AO47,0)","v":0}]
[null,null,null,null,null,"Greenhouse Gas Emissions","To encourage energy efficient buildings and the reduction of greenhouse gas (GHG) emissions associated with the use of energy in building operations.",15.1,"Conditional Requirement","A","Conditional Requirement",null,"-",{"$f":"M48","v":"-"},{"$f":"IF($L$48<>$AF$9,\"CR\",\"\")","v":"CR"},null,{"$f":"IF(OR(S48=$AE$10,S48=$AE$11),L48,\"\")","v":""},{"$f":"IF(S48=$AE$12,L48,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","NA Available","NA Targeted","NA Awarded","NA Not Awarded"]
[null,null,null,null,null,null,null,15.2,"GHG Emissions Reduction: Reference Building Pathway","A",18,null,"-","-",{"$f":"IF(AND(L49>0,$L$48<>$AF$9),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S49=$AE$10,S49=$AE$11),L49,\"\")","v":""},{"$f":"IF(S49=$AE$12,L49,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN22:AN47)","v":0},{"$f":"SUM(AO22:AO47)","v":0},{"$f":"SUM(AP22:AP47)","v":0},{"$f":"SUM(AQ22:AQ47)","v":0}]
[null,null,null,null,null,"Peak Electricity Demand Reduction","Performance Pathway","16A","Prescriptive Pathway: On-site Energy Generation","A",{"$f":"IF(G50=AC50,1,\"0\")","v":"0"},null,"-",{"$f":"M50","v":"-"},{"$f":"IF(AND(L50>0,G50=\"Performance Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S50=$AE$10,S50=$AE$11),L50,\"\")","v":""},{"$f":"IF(S50=$AE$12,L50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,null,null,"16B","Modelled Performance Pathway: Reference Building","A",{"$f":"IF(G50=AC51,2,\"0\")","v":2},null,"-",{"$f":"M51","v":"-"},{"$f":"IF(AND(L51>0,G50=\"Prescriptive Pathway\"),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S51=$AE$10,S51=$AE$11),L51,\"\")","v":""},{"$f":"IF(S51=$AE$12,L51,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K48:K51)","v":20},{"$f":"SUM(L48:L51)","v":0},{"$f":"SUM(M48:M51)","v":0},0,{"$f":"IF(L52>K52,\"!\",\"\")","v":""},null,{"$f":"SUM(Q48:Q51)","v":0},{"$f":"SUM(R48:R51)","v":0}]
[]
[null,null,null,null,null,"Transport",null,null,null,null,10]
[null,null,null,null,null,"Sustainable Transport","17A Performance Pathway","17A","Performance pathway ","A",{"$f":"IF(G55=AC56,10,\"0\")","v":10},null,"-",{"$f":"M55","v":"-"},{"$f":"IF(AND(L55>0,G55<>AC56),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S55=$AE$10,S55=$AE$11),L55,\"\")","v":""},{"$f":"IF(S55=$AE$12,L55,\"\")","v":""}]
[null,null,null,null,null,null,null,"17B.1","Access by Public Transport","A",{"$f":"IF($G$55=$AC$57,4,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L56>0,$G$55<>$AC$57),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S56=$AE$10,S56=$AE$11),L56,\"\")","v":""},{"$f":"IF(S56=$AE$12,L56,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"17A Performance Pathway"]
[null,null,null,null,null,null,null,"17B.2","Reduced Car Parking Provision","A",{"$f":"IF(OR($G$55=$AC$56,$G$55=$AC$58,C57=TRUE),0,AM39)","v":0},null,{"$f":"IF($G$55=$AC$57,AN39,\"-\")","v":"-"},"-",{"$f":"IF(OR(AND(M57>0,SUM(L56:L60)+SUM(M56:M60)>7),AND(L57>0,$G$55<>$AC$57)),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S57=$AE$10,S57=$AE$11),L57,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,"17B Prescriptive pathway"]
[null,null,null,null,null,null,null,"17B.3","Low Emission Vehicle Infrastructure","A",{"$f":"IF(OR($G$55=$AC$56,$G$55=$AC$58,C58=TRUE),0,AM40)","v":0},null,{"$f":"IF($G$55=$AC$57,AN40,\"-\")","v":"-"},"-",{"$f":"IF(OR(AND(M58>0,SUM(L56:L60)+SUM(M56:M60)>7),AND(L58>0,$G$55<>$AC$57)),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"17C Industrial pathway"]
[null,null,null,null,null,null,null,"17B.4","Active Transport Facilities","A",{"$f":"IF($G$55=$AC$57,2,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L59>0,$G$55<>$AC$57),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S59=$AE$10,S59=$AE$11),L59,\"\")","v":""},""]
[null,null,null,null,null,null,null,"17B.5","Walkable Neighbourhoods","A",{"$f":"IF($G$55=$AC$57,1,\"0\")","v":"0"},null,"-","-","",null,{"$f":"IF(OR(S60=$AE$10,S60=$AE$11),L60,\"\")","v":""},""]
[null,null,null,null,null,null,null,"17C.1","Access by Public Transport","A",{"$f":"IF($G$55=$AC$58,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L61>0,$G$55<>$AC$58),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"17C.2","Reduced Car Parking Provision","A",{"$f":"IF($G$55=$AC$58,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L62>0,$G$55<>$AC$58),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"17C.3","Low Emission Vehicle Infrastructure","A",{"$f":"IF($G$55=$AC$58,5,\"0\")","v":"0"},null,"-","-","",null,"",""]
[null,null,null,null,null,null,null,"17C.4","Active Transport Facilities","A",{"$f":"IF($G$55=$AC$58,2,\"0\")","v":"0"},null,"-","-","",null,"",{"$f":"IF(S64=$AE$12,L64,\"\")","v":""}]
[null,null,null,null,null,null,null,"17C.5","Proximity to Amenities ","A",{"$f":"IF($G$55=$AC$58,2,\"0\")","v":"0"},null,"-","-","",null,"",{"$f":"IF(S65=$AE$12,L65,\"\")","v":""}]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"IF(AND(SUM(K55:K65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(K55:K65)>10,\"!\", SUM(K55:K65)))","v":10},{"$f":"IF(AND(SUM(L55:L65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(L55:L65)>10,\"!\", SUM(L55:L65)))","v":0},{"$f":"SUM(M55:M65)","v":0},{"$f":"IF(AND(SUM(N55:N65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(N55:N65)>10,\"!\", SUM(N55:N65)))","v":0},{"$f":"IF(OR(L66+M66>K66,L66>K66),\"!\",\"\")","v":""},null,{"$f":"IF(AND(SUM(Q55:Q65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(Q55:Q65)>10,\"!\", SUM(Q55:Q65)))","v":0},{"$f":"IF(AND(SUM(R55:R65)>7,OR($G$55=$AC$58, $G$55=$AC$57)),7,IF(SUM(R55:R65)>10,\"!\", SUM(R55:R65)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,"Water",null,null,null,null,10]
[null,null,null,null,null,"Potable Water","Performance Pathway","18A","Potable Water - Performance Pathway","A",{"$f":"IF(G69=AC69,10,\"0\")","v":10},null,"-",{"$f":"M69","v":"-"},{"$f":"IF(AND(L69>0,$G$69<>$AC$69),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S69=$AE$10,S69=$AE$11),L69,\"\")","v":""},{"$f":"IF(S69=$AE$12,L69,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,null,null,"18B.1","Sanitary Fixture Efficiency","A",{"$f":"IF($G$69=$AC$70,1,0)","v":0},null,"-","-",{"$f":"IF(AND(L70>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,null,null,"18B.2","Rainwater Reuse","A",{"$f":"IF($G$69=$AC$70,1,0)","v":0},null,"-","-",{"$f":"IF(AND(L71>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"18B.3","Heat Rejection","A",{"$f":"IF($G$69=$AC$70,1,0)","v":0},null,"-","-",{"$f":"IF(AND(L72>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"18B.4","Landscape Irrigation","A",{"$f":"IF(OR($G$69=$AC$69,C73=TRUE),0,AM41)","v":0},null,{"$f":"IF($G$69=$AC$70,AN41,\"-\")","v":"-"},"-",{"$f":"IF(AND(L73>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,"18B.5","Fire System Test Water","A",{"$f":"IF(OR($G$69=$AC$69,C74=TRUE),0,AM42)","v":0},null,{"$f":"IF($G$69=$AC$70,AN42,\"-\")","v":"-"},"-",{"$f":"IF(AND(L74>0,$G$69<>$AC$70),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K69:K74)","v":10},{"$f":"SUM(L69:L74)","v":0},{"$f":"SUM(M69:M74)","v":0},0,{"$f":"IF(L75>K75,\"!\",\"\")","v":""},null,{"$f":"SUM(Q69:Q74)","v":0},0]
[]
[null,null,null,null,null,"Materials",null,null,null,null,18]
[null,null,null,null,null,"Life Cycle Impacts ","Reference Building Pathway - Upfront Carbon Reduction",19.100000000000001,"Upfront Carbon Reduction ","B","Conditional Requirement",null,"-",{"$f":"M78","v":"-"},{"$f":"IF($L$78<>$AF$9,\"CR\",\"\")","v":"CR"},null,{"$f":"IF(OR(S78=$AE$10,S78=$AE$11),L78,\"\")","v":""},{"$f":"IF(S78=$AE$12,L78,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Absolute Value Pathway - Upfront Carbon Reduction"]
[null,null,null,null,null,null,null,"19.1A","Absolute Value Pathway - Upfront Carbon Reduction ","B",{"$f":"IF(G78=AC78,6,\"0\")","v":"0"},null,"-","-",{"$f":"IF(OR(AND(L79>0,$L$78<>$AF$9),AND(L79>0,G78<>AC78)),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Reference Building Pathway - Upfront Carbon Reduction"]
[null,null,null,null,null,null,null,"19.1B","Reference Building Pathway - Upfront Carbon Reduction ","B",{"$f":"IF(G78=AC79,6,\"0\")","v":6},null,"-","-",{"$f":"IF(OR(AND(L80>0,$L$78<>$AF$9),AND(L80>0,G78<>AC79)),\"!\",\"\")","v":""},null,"",{"$f":"IF(S80=$AE$12,L80,\"\")","v":""}]
[null,null,null,null,null,null,null,19.2,"Comparative Life Cycle Assessment ","B",3,null,"-","-",{"$f":"IF(AND(L81>0,$L$78<>$AF$9),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,null,null,19.3,"Long-term Carbon Storage","B",2,null,"-","-",{"$f":"IF(AND(L82>0,$L$78<>$AF$9),\"!\",\"\")","v":""},null,"",""]
[null,null,null,null,null,"Responsible Building Materials","To reward projects that include building materials that are responsibly sourced or have a sustainable supply chain.",20.100000000000001,"Structural and Reinforcing Steel","B",{"$f":"AM43","v":1},null,{"$f":"AN43","v":"-"},"-","",null,"",""]
[null,null,null,null,null,null,null,20.2,"Timber ","B",{"$f":"AM44","v":1},null,{"$f":"AN44","v":"-"},"-","",null,"",""]
[null,null,null,null,null,null,null,20.3,"Permanent Formwork, Pipes, Flooring, Blinds and Cables","B",{"$f":"AM45","v":1},null,{"$f":"AN45","v":"-"},"-","",null,"",""]
[null,null,null,null,null,"Sustainable Products","To encourage sustainability and transparency in product specification.",21,"Product Transparency and Sustainability","B",3,null,"-","-",null,null,{"$f":"IF(OR(S86=$AE$10,S86=$AE$11),L86,\"\")","v":""},""]
[null,null,null,null,null,"Construction and Demolition Waste",null,22.1,"Reporting Accuracy","B","Minimum Requirement",null,"-","-",null,null,"",""]
[null,null,null,null,null,null,"Percentage Benchmark","22..2A","Fixed Benchmark","B",{"$f":"IF(G88=AC88,1,\"0\")","v":"0"},null,"-","-",{"$f":"IF(AND(L88>0,OR(G88=\"Percentage Benchmark\",L87<>$AF$9)),\"!\",\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,"Fixed Benchmark"]
[null,null,null,null,null,null,null,"22.2B","Percentage Benchmark","B",{"$f":"IF(G88=AC89,1,\"0\")","v":1},null,"-","-",{"$f":"IF(AND(L89>0,OR(G88=AC88,L87<>$AF$9)),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S89=$AE$10,S89=$AE$11),L89,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,"Percentage Benchmark"]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K78:K89)","v":18},{"$f":"SUM(L78:L89)","v":0},{"$f":"SUM(M78:M89)","v":0},{"$f":"SUM(N78:N89)","v":0},{"$f":"IF(L90>K90,\"!\",\"\")","v":""},null,{"$f":"SUM(Q78:Q89)","v":0},{"$f":"SUM(R78:R89)","v":0}]
[]
[null,null,null,null,null,"Land Use & Ecology",null,null,null,null,5]
[null,null,null,null,null,"Ecological Value","To reward projects that improve the ecological value of their site.",23,"Ecological Value","A",3,null,"-",{"$f":"M93","v":"-"},null,null,{"$f":"IF(OR(S93=$AE$10,S93=$AE$11),L93,\"\")","v":""},{"$f":"IF(S93=$AE$12,L93,\"\")","v":""}]
[null,null,null,null,null,"Sustainable Sites","To reward projects that choose to develop sites that have limited ecological value, that reuse previously developed land, and that remediate contaminated land.",24.1,"Conditional Requirement: Ecological Protection","A","Conditional Requirement",null,"-","-",{"$f":"IF($L$94<>$AF$9,\"CR\",\"\")","v":"CR"},null,{"$f":"IF(OR(S94=$AE$10,S94=$AE$11),L94,\"\")","v":""},{"$f":"IF(S94=$AE$12,L94,\"\")","v":""}]
[null,null,null,null,null,null,null,24.2,"Reuse of Land","A",1,null,"-","-",{"$f":"IF(AND(L95>0,$L$94<>$AF$9),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S95=$AE$10,S95=$AE$11),L95,\"\")","v":""},""]
[null,null,null,null,null,null,null,24.3,"Contamination and Hazardous Materials","A",{"$f":"IF(C96=FALSE,AM46,0)","v":1},null,{"$f":"AN46","v":"-"},"-",{"$f":"IF(AND(OR(M96<>\"-\",L96>0),$L$94<>$AF$9),\"!\",\"\")","v":""},null,{"$f":"IF(OR(S96=$AE$10,S96=$AE$11),L96,\"\")","v":""},""]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K93:K96)","v":5},{"$f":"SUM(L93:L96)","v":0},{"$f":"SUM(M93:M96)","v":0},0,{"$f":"IF(L97>K97,\"!\",\"\")","v":""},null,{"$f":"SUM(Q93:Q96)","v":0},{"$f":"SUM(R93:R96)","v":0}]
[]
[null,null,null,null,null,"Emissions",null,null,null,null,5]
[null,null,null,null,null,"Stormwater","To reward projects that minimise peak storm water outflows from the site and reduce pollutants entering the public sewer infrastructure or other water bodies.",25.1,"Stormwater Peak Discharge","A",1,null,"-",{"$f":"M100","v":"-"},null,null,{"$f":"IF(OR(S100=$AE$10,S100=$AE$11),L100,\"\")","v":""},{"$f":"IF(S100=$AE$12,L100,\"\")","v":""}]
[null,null,null,null,null,null,null,25.2,"Stormwater Pollution Targets","A",1,null,"-","-",null,null,"",{"$f":"IF(S101=$AE$12,L101,\"\")","v":""}]
[null,null,null,null,null,"Light Pollution","To reward projects that minimise light pollution.",26.1,"Light Pollution to Neighbouring Bodies","A","Minimum Requirement",null,"-","-",null,null,"",{"$f":"IF(S102=$AE$12,L102,\"\")","v":""}]
[null,null,null,null,null,null,null,26.2,"Light Pollution to Night Sky","A",1,null,"-","-",{"$f":"IF(AND(L103>0,L102<>$AF$9),\"!\",\"\")","v":""},null,"",{"$f":"IF(S103=$AE$12,L103,\"\")","v":""}]
[null,null,null,null,null,"Microbial Control","To recognise projects that implement systems to minimise the impacts associated with harmful microbes in building cooling systems.",27,"Legionella Impacts from Cooling Systems","A",1,null,"-","-",null,null,"",{"$f":"IF(S104=$AE$12,L104,\"\")","v":""}]
[null,null,null,null,null,"Refrigerant Impacts","To encourage practices that minimise the environmental impacts of refrigeration and air conditioning equipment.",28,"Refrigerants Impacts","A",{"$f":"AM47","v":1},null,{"$f":"AN47","v":"-"},"-","",null,"",{"$f":"IF(S105=$AE$12,L105,\"\")","v":""}]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K100:K105)","v":5},{"$f":"SUM(L100:L105)","v":0},{"$f":"SUM(M100:M105)","v":0},0,{"$f":"IF(L106>K106,\"!\",\"\")","v":""},null,{"$f":"SUM(Q100:Q105)","v":0},0]
[]
[null,null,null,null,null,"Innovation",null,null,null,null,10]
[null,null,null,null,null,"Innovative Technology or Process","The project meets the aims of an existing credit using a technology or process that is considered innovative in New Zealand or the world.",29.1,"Innovative Technology or Process","A",10,null,"-",{"$f":"M109","v":"-"},null,null,{"$f":"IF(OR(S109=$AE$10,S109=$AE$11),L109,\"\")","v":""},{"$f":"IF(S109=$AE$12,L109,\"\")","v":""}]
[null,null,null,null,null,"Market Transformation","The project has undertaken a sustainability initiative that substantially contributes to the broader market transformation towards sustainable development in New Zealand or in the world.",29.2,"Market Transformation","A",null,null,"-","-",null,null,{"$f":"IF(OR(S110=$AE$10,S110=$AE$11),L110,\"\")","v":""},{"$f":"IF(S110=$AE$12,L110,\"\")","v":""}]
[null,null,null,null,null,"Improving on Green Star Benchmarks","The project has achieved full points in a Green Star credit and demonstrates a substantial improvement on the benchmark required to achieve full points.\nFor credits where this Innovation criterion is applicable, improved benchmarks are included in the ‘Innovation’ section of the credit.",29.3,"Improving on Green Star Benchmarks","A",null,null,"-","-",null,null,{"$f":"IF(OR(S111=$AE$10,S111=$AE$11),L111,\"\")","v":""},""]
[null,null,null,null,null,"Innovation Challenge","The project can target any of the current Innovation Challenges that are published on the NZGBC and GBCA website. Alternatively, where the project addresses a sustainability issue not included within any of the credits in the existing Green Star rating tools, projects may propose a new Innovation Challenge.",29.4,"Innovation Challenge","A",null,null,"-","-",null,null,{"$f":"IF(OR(S112=$AE$10,S112=$AE$11),L112,\"\")","v":""},""]
[null,null,null,null,null,"Global Sustainability","Project teams may adopt an approved credit from a Global Green Building Rating tool that addresses a sustainability issue that is currently outside the scope of this Green Star rating tool.",29.5,"Global Sustainability","A",null,null,"-","-",null,null,{"$f":"IF(OR(S113=$AE$10,S113=$AE$11),L113,\"\")","v":""},""]
[null,null,null,null,null,"Total",null,null,null,null,{"$f":"SUM(K109)","v":10},{"$f":"IF(SUM(L109:L113)>10,10,SUM(L109:L113))","v":0},null,null,{"$f":"IF(L114>K114,\"!\",\"\")","v":""},null,{"$f":"SUM(Q109:Q113)","v":0},0]
[]
[null,null,null,null,null,null,null,null,"TOTALS",null,"AVAILABLE","TARGETED",null,null,null,null,"AWARDED","TBC"]
[null,null,null,null,null,null,null,null,"CORE POINTS",null,{"$f":"100-AO49","v":100},{"$f":"L25+L45+L52+L66+L75+L90+L97+L106","v":0},null,null,null,null,{"$f":"(Q25+Q45+Q52+Q66+Q75+Q90+Q97+Q106)/(100-AP49)*100+Q114","v":0},{"$f":"(R25+R45+R52+R66+R75+R90+R97+R106)/(100-AP49)*100+R114","v":0}]
[null,null,null,null,null,null,null,null,"CATEGORY PERCENTAGE SCORE",null,null,{"$f":"L117/K117*100","v":0}]
[null,null,null,null,null,null,null,null,"INNOVATION POINTS",null,10,{"$f":"L114","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL SCORE TARGETED",null,null,{"$f":"L118+L119","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome Count","Assessment result"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Core",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 1",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0},{"$f":"IF(S127>#REF!*0.5, \"Go to Stage 2\", \"Assessment Complete\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 2",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0},{"$f":"IF(AND(T127=\"Go to Stage 2\",#REF!= 0),T127,IF(S128>SUM(#REF!)*0.5,\"Go to Stage 3\",\"Assessment Complete\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 3",{"$f":"COUNTIF(S8:S105,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(S8:S105,\"Awarded - Compliant\")+COUNTIF(S8:S105,\"Awarded - Minor non-Compliance\")+COUNTIF(S8:S105,\"Not Awarded - Major non-compliance\")","v":0},{"$f":"IF(T127=\"Assessment Complete\",T127,IF(T128=\"Assessment Complete\",T128,IF(#REF!>=1,T128,\"Assessment Complete\")))","v":{"$error":"#REF!"}}]

{"sheet":"Submission Planner","index":6,"n_rows":115,"n_cols":30,"rows_kept":115,"cut":false,"hidden":true,"merged":[[77,5,79,5],[77,6,79,6],[103,9,107,9],[102,5,102,8],[88,5,90,5],[88,6,90,6],[93,5,93,8],[94,5,95,5],[94,6,95,6],[96,6,97,6],[81,5,82,5],[81,6,82,6],[85,5,85,8],[86,5,87,5],[86,6,87,6],[96,5,97,5],[40,5,41,5],[40,6,41,6],[62,5,67,5],[62,6,67,6],[71,5,76,5],[71,6,76,6],[42,5,43,5],[42,6,43,6],[46,5,46,8],[47,5,48,5],[47,6,48,6],[37,5,39,5],[37,6,39,6],[22,6,23,6],[26,5,26,8],[27,5,29,5],[27,6,29,6],[30,5,32,5],[30,6,32,6],[19,5,21,5],[19,6,21,6],[22,5,23,5],[33,5,36,5],[33,6,36,6],[0,5,0,8],[1,6,1,7],[2,6,2,7],[7,5,11,5],[7,6,11,6],[12,5,13,5],[12,6,13,6],[15,5,16,5],[15,6,16,6],[17,5,18,5],[17,6,18,6],[73,11,76,11],[49,5,50,5],[49,6,50,6],[54,5,58,5],[54,6,58,6]]}
["x","x","x",null,null,"Green Star - Design & As Built NZv1.0 Scorecard",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x"]
["Points Available","NA Points","NA - T/F",null,null,"Project:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"Core Points Available","Total Score Targeted "]
[null,null,null,null,null,"Targeted Rating:",{"$f":"IF(K3>=75,\"6 Stars - World Leadership\",IF(K3>=60,\"5 Stars - New Zealand Excellence\",IF(K3>=45,\"4 Stars - New Zealand Best Practice\",\"\")))","v":""},null,null,{"$f":"J112","v":100},{"$f":"K115","v":0}]
[]
[null,null,null,null,"NA","CATEGORY / CREDIT","AIM OF THE CREDIT / SELECTION","CODE","CREDIT CRITERIA","POINTS AVAILABLE","POINTS TARGETED",null,"SUBMISSION PLANNING"]
[null,null,null,null,null,"Management",null,null,null,{"$f":"15-SUM(B7:B24)","v":15},null,null,null,null,null,null,null,null,null,null,null,null,"Category","Fixed Total","Variable Total","Points Claimed",null,"Points Awarded","Points TBC"]
[null,null,null,null,null,"Green Star Accredited Professional","To recognise projects that engage a Green Star Accredited Professional to support the Green Star certification process.",1,"Accredited Professional",1,null,null,null,null,null,null,null,null,null,null,null,null,"Management",15,null,{"$f":"K25","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Commissioning and Tuning","To encourage and recognise commissioning, handover and tuning initiatives that ensure all building services operate to their full potential and as designed.",2,"Environmental Performance Targets","Minimum Requirement",null,null,null,null,null,null,null,"Performance Pathway",null,null,"Complies",null,"Indoor Environment Quality",17,{"$f":"J45","v":17},{"$f":"K45","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,2.1,"Services and Maintainability Review",1,null,{"$f":"IF(AND(K9>0,$K$8<>$AD$8),\"!\",\"\")","v":""},null,null,null,null,null,"Prescriptive Pathway","Core","Awarded - Compliant","Does not comply",null,"Energy",22,{"$f":"J52","v":21},{"$f":"K52","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,2.2000000000000002,"Building Commissioning",1,null,{"$f":"IF(AND(K10>0,$K$8<>$AD$8),\"!\",\"\")","v":""},null,null,null,null,null,null,"Stage 1","Awarded - Minor non-compliance",null,null,"Transport",10,{"$f":"J60","v":10},{"$f":"K60","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,2.2999999999999998,"Building Systems Tuning",1,null,"",null,null,null,null,null,null,"Stage 2","Not Awarded - Major non-compliance",null,null,"Water",12,{"$f":"J69","v":6},{"$f":"K69","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,2.4,"Independent Commissioning Agent",1,null,"",null,null,null,null,null,null,"Stage 3",null,null,null,"Materials",14,{"$f":"J84","v":12},{"$f":"K84","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Adaptation and Resilience","To encourage and recognise projects that are resilient to the impacts of a changing climate and natural disasters.",3,"Implementation of a Climate Adaptation Plan",2,null,"",null,null,null,null,null,null,null,null,null,null,"Land Use and Ecology",5,{"$f":"J92","v":5},{"$f":"K92","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,3.1,"Adaptation & Resilience: Earthquake Resilience",1,null,null,null,null,null,null,null,null,null,null,null,null,"Emissions",5,{"$f":"J101","v":5},{"$f":"K101","v":0},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Building Information","To recognise the development and provision of building information that facilitates operator and user understanding of a building's systems, their operation and maintenance requirements, and their environmental targets, to enable optimised performance.",4.0999999999999996,"Building Information",1,null,"",null,null,null,null,null,null,null,null,null,null,"Total Points Available",{"$f":"J112","v":100}]
[null,null,null,null,null,"Commitment to Performance","To recognise practices that encourage building owners, building occupants and facilities management teams to set targets and monitor environmental performance in a collaborative way.",5.0999999999999996,"Environmental Building Performance",1,null,"",null,null,null,null,null,null,null,null,null,null,"Total Score",null,null,null,null,{"$f":"(#REF!/X15)*100","v":{"$error":"#REF!"}},{"$f":"(#REF!/X15)*100","v":{"$error":"#REF!"}},"Weight score i.e. accounting for N/As."]
[null,null,null,null,null,null,null,5.2,"End of Life Waste Performance",1,null,"",null,null,null,null,null,null,null,null,null,null,"Innovation",null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Metering and Monitoring","To recognise the implementation of effective energy and water metering and monitoring systems.",6,"Metering","Minimum Requirement",null,null,null,null,null,null,null,null,null,null,null,null,"Total Final Score",null,null,null,null,{"$f":"AB16+AB17","v":{"$error":"#REF!"}},{"$f":"AC16+AC17","v":{"$error":"#REF!"}},"Final score i.e. weighted score + Innovation"]
[null,null,null,null,null,null,null,6.1,"Monitoring Systems",1,null,{"$f":"IF(AND(K19>0,$K$18<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Responsible Building Practices","To reward responsible construction practices that manage environmental impacts, enhance staff health and wellbeing, and improve sustainability knowledge on site.",7,"Environmental Management Plan","Minimum Requirement"]
[null,null,null,null,null,null,null,7.1,"Formalised Environmental Management System",1,null,{"$f":"IF(AND(K21>0,$K$20<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,null,null,7.2,"High Quality Staff Support",1,null,{"$f":"IF(AND(K22>0,$K$20<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Operational Waste","Performance Pathway","8A","Performance Pathway - Specialist Plan",{"$f":"IF(G23=R8,1,\"0\")","v":1},null,{"$f":"IF(AND(K23>0,G23=\"Prescriptive Pathway\"),\"!\",\"\")","v":""}]
[null,null,null,null,null,null,null,"8B","Prescriptive Pathway - Facilities",{"$f":"IF(G23=R9,1,\"0\")","v":"0"},null,{"$f":"IF(AND(K24>0,G23=\"Performance Pathway\"),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J7:J24)","v":15},{"$f":"SUM(K7:K24)","v":0},{"$f":"IF(K25>J25,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Indoor Environment Quality",null,null,null,{"$f":"17-SUM(B28:B44)","v":17}]
[1,{"$f":"IF(C28=TRUE,A28,0)","v":0},false,null,null,"Indoor Air Quality","To recognise projects that provide high indoor air quality to occupants.",9.1,"Ventilation System Attributes",{"$f":"IF(C28=FALSE,A28,0)","v":1}]
[2,{"$f":"IF(C29=TRUE,A29,0)","v":0},false,null,null,null,null,9.1999999999999993,"Provision of Outdoor Air",{"$f":"IF(C29=FALSE,A29,0)","v":2}]
[1,0,false,null,null,null,null,9.3000000000000007,"Exhaust or Elimination of Pollutants",1]
[1,0,false,null,null,"Acoustic Comfort","To reward projects that provide appropriate and comfortable acoustic conditions for occupants.",10.1,"Internal Noise Levels",1]
[1,0,false,null,null,null,null,10.199999999999999,"Reverberation",1]
[1,0,false,null,null,null,null,10.3,"Acoustic Separation",1]
[null,null,null,null,null,"Lighting Comfort","To encourage and recognise well-lit spaces that provide a high degree of comfort to users.",11,"Minimum Lighting Comfort","Minimum Requirement"]
[1,0,false,null,null,null,null,11.1,"General Illuminance and Glare Reduction",1,null,{"$f":"IF(AND(K35>0,$K$34<>$AD$8),\"!\",\"\")","v":""}]
[1,0,false,null,null,null,null,11.2,"Surface Illuminance",1,null,{"$f":"IF(AND(K36>0,$K$34<>$AD$8),\"!\",\"\")","v":""}]
[1,0,false,null,null,null,null,11.3,"Localised Lighting Control",1,null,{"$f":"IF(AND(K37>0,$K$34<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Visual Comfort","To recognise the delivery of well-lit spaces that provide high levels of visual comfort to building occupants.",12,"Glare Reduction","Minimum Requirement"]
[2,0,false,null,null,null,null,12.1,"Daylight",2,null,{"$f":"IF(AND(K39>0,$K$38<>$AD$8),\"!\",\"\")","v":""}]
[1,0,false,null,null,null,null,12.2,"Views",1,null,{"$f":"IF(AND(K40>0,$K$38<>$AD$8),\"!\",\"\")","v":""}]
[1,0,false,null,null,"Indoor Pollutants","To recognise projects that safeguard occupant health through the reduction in internal air pollutant levels.",13.1,"Paints, Adhesives, Sealants and Carpets",1]
[1,0,false,null,null,null,null,13.2,"Engineered Wood Products",1]
[1,0,false,null,null,"Thermal Comfort","To recognise projects that achieve high levels of thermal comfort.",14.1,"Thermal Comfort",1]
[1,0,false,null,null,null,null,14.2,"Advanced Thermal Comfort",1]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J28:J44)","v":17},{"$f":"SUM(K28:K44)","v":0},{"$f":"IF(K45>J45,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Energy",null,null,null,{"$f":"22-SUM(B48:B51)","v":22}]
[null,null,null,null,null,"Greenhouse Gas Emissions","To encourage energy efficient buildings and the reduction of greenhouse gas (GHG) emissions associated with the use of energy in building operations.","15E.0","Conditional Requirement: Reference Building Pathway","Conditional Requirement"]
[null,null,null,null,null,null,null,"15E.1","Reference Building Pathway",20,null,{"$f":"IF(AND(K49>0,K48<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Peak Electricity Demand Reduction","Prescriptive Pathway","16A","Prescriptive Pathway: On-site Energy Generation",{"$f":"IF(G50=R62,1,\"0\")","v":1}]
[null,null,null,null,null,null,null,"16B","Modelled Performance Pathway: Reference Building",{"$f":"IF(G50=R63,2,\"0\")","v":"0"}]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J48:J51)","v":21},{"$f":"SUM(K48:K51)","v":0},{"$f":"IF(K52>J52,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Transport",null,null,null,{"$f":"10-SUM(B55:B59)","v":10}]
[null,null,null,null,null,"Sustainable Transport","To reward projects that implement design and operational measures that reduce the carbon emissions arising from occupant travel to and from the project, when compared to a reference building. This also promotes the health and fitness of commuters, and the increased liveability of the location.","17B.1","Access by Public Transport",4]
[1,{"$f":"IF((C56=TRUE),1,0)","v":0},false,null,null,null,null,"17B.2","Reduced Car Parking Provision",{"$f":"IF(C56=TRUE,0,1)","v":1}]
[2,{"$f":"IF((C57=TRUE),2,0)","v":0},false,null,null,null,null,"17B.3","Low Emission Vehicle Infrastructure",{"$f":"IF(C57=TRUE,0,2)","v":2}]
[null,null,null,null,null,null,null,"17B.4","Active Transport Facilities",2]
[null,null,null,null,null,null,null,"17B.5","Walkable Neighbourhoods",1]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J55:J59)","v":10},{"$f":"SUM(K55:K59)","v":0},{"$f":"IF(K60>J60,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Water",null,null,null,{"$f":"12-SUM(B63:B68)","v":12},null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,"Potable Water","Prescriptive Pathway","18A.1","Potable Water - Performance Pathway",{"$f":"IF(G63=R67,12,0)","v":0},null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,null,null,"18B.1","Sanitary Fixture Efficiency",{"$f":"IF($G$63=$R$68,1,0)","v":1}]
[null,null,null,null,null,null,null,"18B.2","Rainwater Reuse",{"$f":"IF($G$63=$R$68,1,0)","v":1}]
[null,null,null,null,null,null,null,"18B.3","Heat Rejection",{"$f":"IF($G$63=$R$68,2,0)","v":2}]
[1,{"$f":"IF(AND($G$63=$R$68,C67=TRUE),1,0)","v":0},false,null,null,null,null,"18B.4","Landscape Irrigation",{"$f":"IF(OR($G$63=$R$67,C67=TRUE),0,1)","v":1},null,null,null,null,null,null,null,"Performance Pathway"]
[1,{"$f":"IF(AND($G$63=$R$68,C68=TRUE),1,0)","v":0},false,null,null,null,null,"18B.5","Fire System Test Water",{"$f":"IF(OR($G$63=$R$67,C68=TRUE),0,1)","v":1},null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J63:J68)","v":6},{"$f":"SUM(K63:K68)","v":0},{"$f":"IF(K69>J69,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Materials",null,null,null,{"$f":"14-SUM(B72:B83)","v":14}]
[null,null,null,null,null,"Life Cycle Assessment/Impacts","Prescriptive Pathway - Life Cycle Impacts","19A.1","Comparative Life Cycle Assessment",{"$f":"IF($G$72=$R$85,6,0)","v":0},null,{"$f":"IF(SUM(K72:K73)>7,\"!\", \"\")","v":""}]
[null,null,null,null,null,null,null,"19A.2","Additional Reporting",{"$f":"IF($G$72=$R$85,4,0)","v":0},null,{"$f":"IF(SUM(K72:K73)>7,\"!\", \"\")","v":""}]
[null,null,null,null,null,null,null,"19B.1","Concrete",{"$f":"IF($G$72=$R$86,3,0)","v":3},null,{"$f":"IF(SUM(K74:K77)>5,\"Error: the total number of points available for the 'Material Use' Pathway is 5. Please enter a points score less than or equal to 5.\",\"\")","v":""}]
[null,null,null,null,null,null,null,"19B.2","Steel",{"$f":"IF($G$72=$R$86,1,0)","v":1}]
[null,null,null,null,null,null,null,"19B.3","Building Reuse",{"$f":"IF($G$72=$R$86,4,0)","v":4},null,null,null,null,null,null,null,"Performance Pathway"]
[4,{"$f":"IF(C77=TRUE,A77,0)","v":0},null,null,null,null,null,"19B.3","Structural Timber",{"$f":"IF($G$72=$R$86,3,0)","v":3},null,null,null,null,null,null,null,"Prescriptive Pathway"]
[1,0,false,null,null,"Responsible Building Materials","To reward projects that include building materials that are responsibly sourced or have a sustainable supply chain.",20.100000000000001,"Structural and Reinforcing Steel",{"$f":"IF(C78=TRUE,0,1)","v":1}]
[1,0,false,null,null,null,null,20.2,"Timber ",{"$f":"IF(C79=TRUE,0,1)","v":1}]
[1,0,false,null,null,null,null,20.3,"Permanent Formwork, Pipes, Flooring, Blinds and Cables",1]
[null,null,null,null,null,"Sustainable Products","To encourage sustainability and transparency in product specification.",21,"Product Transparency and Sustainability",3]
[null,null,null,null,null,"Construction and Demolition Waste","Fixed Benchmark","22A","Fixed Benchmark",{"$f":"IF(G82=R94,1,\"0\")","v":1}]
[null,null,null,null,null,null,null,"22B","Percentage Benchmark",{"$f":"IF(G82=R95,1,\"0\")","v":"0"}]
[null,null,null,null,null,"Total",null,null,null,{"$f":"IF(G72=R86,12,14)","v":12},{"$f":"SUM(K72:K83)","v":0},{"$f":"IF(K84>J84,\"!\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performance Pathway - Life Cycle Assessment"]
[null,null,null,null,null,"Land Use & Ecology",null,null,null,{"$f":"5-SUM(B87:B91)","v":5},null,null,null,null,null,null,null,"Prescriptive Pathway - Life Cycle Impacts"]
[null,null,null,null,null,"Ecological Value","To reward projects that improve the ecological value of their site.",23,"Endangered, Threatened or Vulnerable Species","Minimum Requirement"]
[null,null,null,null,null,null,null,23.1,"Ecological Value",3,null,{"$f":"IF(AND(K88>0,$K87<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Sustainable Sites","To reward projects that choose to develop sites that have limited ecological value, that reuse previously developed land, and that remediate contaminated land.",24,"Conditional Requirement","Conditional Requirement"]
[null,null,null,null,null,null,null,24.1,"Reuse of Land",1,null,{"$f":"IF(AND(K90>0,$K$89<>$AD$8),\"!\",\"\")","v":""}]
[1,{"$f":"IF(C91=TRUE,A91,0)","v":0},false,null,null,null,null,24.2,"Contamination and Hazardous Materials",{"$f":"IF(C91=FALSE,1,0)","v":1},null,{"$f":"IF(AND(K91>0,$K$89<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J87:J91)","v":5},{"$f":"SUM(K87:K91)","v":0},{"$f":"IF(K92>J92,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Emissions",null,null,null,{"$f":"5-SUM(B95:B100)","v":5},null,null,null,null,null,null,null,"Fixed Benchmark"]
[null,null,null,null,null,"Stormwater","To reward projects that minimise peak storm water outflows from the site and reduce pollutants entering the public sewer infrastructure or other water bodies.",26.1,"Stormwater Peak Discharge",1,null,null,null,null,null,null,null,"Percentage Benchmark"]
[null,null,null,null,null,null,null,26.2,"Stormwater Pollution Targets",1]
[null,null,null,null,null,"Light Pollution","To reward projects that minimise light pollution.",27,"Light Pollution to Neighbouring Bodies","Minimum Requirement"]
[null,null,null,null,null,null,null,27.1,"Light Pollution to Night Sky",1,null,{"$f":"IF(AND(K98>0,$K97<>$AD$8),\"!\",\"\")","v":""}]
[null,null,null,null,null,"Microbial Control","To recognise projects that implement systems to minimise the impacts associated with harmful microbes in building cooling systems.",28,"Legionella Impacts from Cooling Systems",1]
[null,null,null,null,null,"Refrigerant Impacts","To encourage practices that minimise the environmental impacts of refrigeration and air conditioning equipment.",29,"Refrigerants Impacts",1]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J95:J100)","v":5},{"$f":"SUM(K95:K100)","v":0},{"$f":"IF(K101>J101,\"!\",\"\")","v":""}]
[]
[null,null,null,null,null,"Innovation",null,null,null,10]
[null,null,null,null,null,"Innovative Technology or Process","The project meets the aims of an existing credit using a technology or process that is considered innovative in Australia or the world.","30A","Innovative Technology or Process",10]
[null,null,null,null,null,"Market Transformation","The project has undertaken a sustainability initiative that substantially contributes to the broader market transformation towards sustainable development in Australia or in the world.","30B","Market Transformation"]
[null,null,null,null,null,"Improving on Green Star Benchmarks","The project has achieved full points in a Green Star credit and demonstrates a substantial improvement on the benchmark required to achieve full points.","30C","Improving on Green Star Benchmarks"]
[null,null,null,null,null,"Innovation Challenge","Where the project addresses an sustainability issue not included within any of the Credits in the existing Green Star rating tools.","30D","Innovation Challenge"]
[null,null,null,null,null,"Global Sustainability","Project teams may adopt an approved credit from a Global Green Building Rating tool that addresses a sustainability issue that is currently outside the scope of this Green Star rating tools.","30E","Global Sustainability"]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J104)","v":10},{"$f":"IF(SUM(K104:K108)>10,10,SUM(K104:K108))","v":0},{"$f":"IF(K109>J109,\"!\",\"\")","v":""}]
[]
[null,"TOTAL NA POINTS",null,null,null,null,null,null,"TOTALS","AVAILABLE","TARGETED"]
[null,{"$f":"SUM(B7:B102)","v":0},null,null,null,null,null,null,"CORE POINTS",{"$f":"100-B112","v":100},{"$f":"K25+K45+K52+K60+K69+K84+K92+K101","v":0}]
[null,null,null,null,null,null,null,null,"CATEGORY PERCENTAGE SCORE",null,{"$f":"K112/J112*100","v":0}]
[null,null,null,null,null,null,null,null,"INNOVATION POINTS",10,{"$f":"K109","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL SCORE TARGETED",null,{"$f":"K113+K114","v":0}]

{"sheet":"ss - As Built Scorecard","index":7,"n_rows":138,"n_cols":30,"rows_kept":138,"cut":false,"hidden":true,"merged":[[7,5,11,5],[7,6,11,6],[0,5,0,8],[0,20,0,22],[1,6,1,7],[1,20,2,22],[2,6,2,7],[29,5,31,5],[29,6,31,6],[14,5,15,5],[14,6,15,6],[16,5,17,5],[16,6,17,6],[18,5,20,5],[18,6,20,6],[21,5,22,5],[21,6,22,6],[25,5,25,8],[26,5,28,5],[26,6,28,6],[46,11,52,11],[32,5,35,5],[32,6,35,6],[36,5,38,5],[36,6,38,6],[39,5,40,5],[39,6,40,6],[41,5,42,5],[41,6,42,6],[45,5,45,8],[46,5,60,5],[46,6,60,6],[61,5,62,5],[61,6,62,6],[66,5,71,5],[66,6,71,6],[75,5,80,5],[75,6,80,6],[86,11,88,11],[89,5,91,5],[89,6,91,6],[97,5,97,8],[97,12,97,13],[93,5,94,5],[93,6,94,6],[84,5,88,5],[84,6,88,6],[98,5,99,5],[98,6,99,6],[100,5,102,5],[100,6,102,6],[116,9,120,9],[106,5,106,8],[107,5,108,5],[107,6,108,6],[109,5,110,5],[109,6,110,6],[115,5,115,8]]}
["x","x","x",null,null,"Green Star NZ - Design & As Built Pilot Scorecard",null,null,null,null,null,null,null,null,"x","x",null,null,null,null,"Clarification of Assessment Comments",null,null,"X","R1",null,"x","x","x","x"]
["Points Available","NA Points","NA - T/F",null,null,"Project:",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"Core Points Available","Total Score Targeted ",null,"Total Points Awarded","Total Points TBC",null,null,null,null,null,null,"Query Type\n\n1. Clarifying the documentation requested in the assessment comment. \n2. Clarifying apparent inconsistencies between the assessment comment and Submission Guideline requirements.\n3. Documentation was included but missed during the assessment."]
[null,null,null,null,null,"Targeted Rating:",{"$f":"IF(K3>=75,\"6 Stars - World Excellence\",IF(K3>=60,\"5 Star - Australian Excellence\",IF(K3>=45,\"4 Star - Best Practice\",\"\")))","v":""},null,null,{"$f":"J125","v":100},{"$f":"K128","v":0},null,{"$f":"M125","v":0},{"$f":"N125","v":0},null,{"$f":"IF(Q138<=SUM(P134:P135),\"\",R138)","v":""}]
[]
[null,null,null,null,"NA","CATEGORY / CREDIT","AIM OF THE CREDIT / SELECTION","CODE","CREDIT CRITERIA","POINTS AVAILABLE","POINTS TARGETED",null," POINTS AWARDED"," POINTS \nTBC","ASSIGNED STAGE","ASSESSOR COMPLETED STAGE","OUTCOME",null," ASSESSMENT COMMENTS",null,"QUERY TYPE","Round 1 Query","Requested Action by the project team","NZGBC Comments","Assessor Response"]
[null,null,null,null,null,"Management",null,null,null,{"$f":"14-SUM(B7:B23)","v":14},null,null,null,null,null,null,null,null,null,null,"1,2 or 3","Provide an explanation of the project team’s questions/comments regarding the assessment comments.","Explain what action the project would like taken, e.g. comment be clarified, comment be removed, point awarded, etc."]
[null,null,null,null,null,"Green Star Accredited Professional","To recognise the appointment and active involvement of a Green Star Accredited Professional in order to ensure that the rating tool is applied effectively and as intended.",1,"Accredited Professional",1,null,null,{"$f":"IF(OR(Q7=$AC$9,Q7=$AC$10),K7,\"\")","v":""},{"$f":"IF(Q7=$AC$11,K7,\"\")","v":""}]
[null,null,null,null,null,"Commissioning and Tuning","To encourage and recognise commissioning, handover and tuning initiatives that ensure all building services operate to their full potential.",2,"Environmental Performance Targets","-",null,null,{"$f":"IF(OR(Q8=$AC$9,Q8=$AC$10),K8,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"Performance Pathway",null,null,"Complies"]
[null,null,null,null,null,null,null,2.1,"Services and Maintainability Review",1,null,{"$f":"IF(AND(K9>0,$K$8<>$AD$8),\"!\",\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway","Core","Awarded - Compliant","Does not comply"]
[null,null,null,null,null,null,null,2.2000000000000002,"Building Commissioning",1,null,{"$f":"IF(AND(K10>0,$K$8<>$AD$8),\"!\",\"\")","v":""},"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 1","Awarded - Minor non-compliance"]
[null,null,null,null,null,null,null,2.2999999999999998,"Building Systems Tuning",1,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 2","Not Awarded - Major non-compliance"]
[null,null,null,null,null,null,null,2.4,"Independent Commissioning Agent",1,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 3"]
[null,null,null,null,null,"Adaptation and Resilience","To encourage and recognise projects that are resilient to the impacts of a changing climate and natural disasters.",3.1,"Implementation of a Climate Adaptation Plan",2,null,"","",""]
[null,null,null,null,null,"Building Information","To recognise the development and provision of building information that facilitates understanding of a building's systems, operation and maintenance requirements, and environmental targets to enable the optimised performance.",4.0999999999999996,"Building Information",1,null,"","",""]
[null,null,null,null,null,"Commitment to Performance","To recognise practices that encourage building owners, building occupants and facilities management teams to set targets and monitor environmental performance in a collaborative way.",5.0999999999999996,"Environmental Building Performance",1,null,"","",""]
[null,null,null,null,null,null,null,5.2,"End of Life Waste Performance",1,null,"","",""]
[null,null,null,null,null,"Metering and Monitoring","To recognise the implementation of effective energy and water metering and monitoring systems.",6,"Metering","-",null,null,"",""]
[null,null,null,null,null,null,null,6.1,"Monitoring Systems",1,null,{"$f":"IF(AND(K18>0,$K$17<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,"Responsible Building Practices","To reward projects that use best practice formal environmental management procedures during construction.",7,"Environmental Management Plan","-",null,null,"",""]
[null,null,null,null,null,null,null,7.1,"Formalised Environmental Management System",1,null,{"$f":"IF(AND(K20>0,$K$19<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,null,null,7.2,"High Quality Staff Support",1]
[null,null,null,null,null,"Operational Waste","Performance Pathway","8A","Performance Pathway - Specialist Plan",{"$f":"IF(G22=AA8,1,\"-\")","v":1},null,{"$f":"IF(AND(K22>0,G22=\"Prescriptive Pathway\"),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,null,null,"8B","Prescriptive Pathway - Facilities",{"$f":"IF(G22=AA9,1,\"-\")","v":"-"},null,{"$f":"IF(AND(K23>0,G22=\"Performance Pathway\"),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J7:J23)","v":14},{"$f":"SUM(K7:K23)","v":0},{"$f":"IF(K24>J24,\"!\",\"\")","v":""},{"$f":"SUM(M7:M23)","v":0},{"$f":"SUM(N7:N23)","v":0}]
[]
[null,null,null,null,null,"Indoor Environment Quality",null,null,null,{"$f":"17-SUM(B27:B43)","v":17}]
[1,{"$f":"IF(C27=TRUE,A27,0)","v":0},false,null,null,"Indoor Air Quality","To recognise projects that provide high air quality to occupants.",9.1,"Ventilation System Attributes",{"$f":"IF(C27=FALSE,A27,0)","v":1},null,null,{"$f":"IF(OR(Q27=$AC$9,Q27=$AC$10),K27,\"\")","v":""},{"$f":"IF(Q27=$AC$11,K27,\"\")","v":""}]
[2,{"$f":"IF(C28=TRUE,A28,0)","v":0},false,null,null,null,null,9.1999999999999993,"Provision of Outdoor Air",{"$f":"IF(C28=FALSE,A28,0)","v":2},null,null,{"$f":"IF(OR(Q28=$AC$9,Q28=$AC$10),K28,\"\")","v":""},""]
[1,0,false,null,null,null,null,9.3000000000000007,"Exhaust or Elimination of Pollutants",1,null,null,"",""]
[1,0,false,null,null,"Acoustic Comfort","To reward projects that provide appropriate and comfortable acoustic conditions for occupants.",10.1,"Internal Noise Levels",1,null,null,"",""]
[1,0,false,null,null,null,null,10.199999999999999,"Reverberation",1,null,null,"",""]
[1,0,false,null,null,null,null,10.3,"Acoustic Separation",1,null,null,"",""]
[null,null,null,null,null,"Lighting Comfort","To encourage and recognise well-lit spaces that provide a high degree of comfort to users.",11,"Minimum Lighting Comfort","-",null,null,"",""]
[1,0,false,null,null,null,null,11.1,"General Illuminance and Glare Reduction",1,null,{"$f":"IF(AND(K34>0,$K$33<>$AD$8),\"!\",\"\")","v":""},"",""]
[1,0,false,null,null,null,null,11.2,"Surface Illuminance",1,null,{"$f":"IF(AND(K35>0,$K$33<>$AD$8),\"!\",\"\")","v":""},"",""]
[1,0,false,null,null,null,null,11.3,"Localised Lighting Control",1,null,{"$f":"IF(AND(K36>0,$K$33<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,"Visual Comfort","To recognise the delivery of well-lit spaces that provide high levels of visual comfort to building occupants.",12,"Glare Reduction","-",null,null,"",""]
[2,0,false,null,null,null,null,12.1,"Daylight",2,null,{"$f":"IF(AND(K38>0,$K$37<>$AD$8),\"!\",\"\")","v":""},"",""]
[1,0,false,null,null,null,null,12.2,"Views",1,null,{"$f":"IF(AND(K39>0,$K$37<>$AD$8),\"!\",\"\")","v":""},"",""]
[1,0,false,null,null,"Indoor Pollutants","To recognise projects that safeguard occupant health through the reduction in internal air pollutant levels.",13.1,"Paints, Adhesives, Sealants and Carpets",1,null,null,"",""]
[1,0,false,null,null,null,null,13.2,"Engineered Wood Products",1,null,null,"",""]
[1,0,false,null,null,"Thermal Comfort","To encourage and recognise projects that achieve high levels of thermal comfort.",14.1,"Thermal Comfort",1,null,null,"",""]
[1,0,false,null,null,null,null,14.2,"Advanced Thermal Comfort",1,null,null,"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J27:J43)","v":17},{"$f":"SUM(K27:K43)","v":0},{"$f":"IF(K44>J44,\"!\",\"\")","v":""},{"$f":"SUM(M27:M43)","v":0},0]
[]
[null,null,null,null,null,"Energy",null,null,null,{"$f":"22-SUM(B47:B63)","v":22}]
[null,null,null,null,null,"Greenhouse Gas Emissions","A. Prescriptive Pathway","15A.0","Conditional Requirement: Prescriptive Pathway","-",null,null,{"$f":"IF(OR(Q47=$AC$9,Q47=$AC$10),K47,\"\")","v":""},{"$f":"IF(Q47=$AC$11,K47,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"A. Prescriptive Pathway"]
[null,null,null,null,null,null,null,"15A.1","Building Envelope",{"$f":"IF($G$47=$AA$47,1,\"-\")","v":1},null,null,{"$f":"IF(OR(Q48=$AC$9,Q48=$AC$10),K48,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"B. NatHERS Pathway "]
[null,null,null,null,null,null,null,"15A.2","Glazing",{"$f":"IF($G$47=$AA$47,1,\"-\")","v":1},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"C. BASIX Pathway"]
[null,null,null,null,null,null,null,"15A.3","Lighting",1,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"D. NABERS Pathway"]
[null,null,null,null,null,null,null,"15A.4","Ventilation and Air-conditioning",1,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"E. Modelled Performance Pathway"]
[null,null,null,null,null,null,null,"15A.5","Domestic Hot Water Systems",1,null,null,"",""]
[null,null,null,null,null,null,null,"15A.6","Accredited GreenPower",{"$f":"IF($G$47=$AA$47,5,\"-\")","v":5},null,null,"",""]
[null,null,null,null,null,null,null,"15B.0","Conditional Requirement: NatHERS Pathway","-",null,null,"",""]
[null,null,null,null,null,null,null,"15B.1","NatHERS Pathway",{"$f":"IF(G47=AA48,16,\"-\")","v":"-"},null,{"$f":"IF(AND(K55>0,$K$54<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,null,null,"15C.0","Conditional Requirement: BASIX Pathway","-",null,null,"",""]
[null,null,null,null,null,null,null,"15C.1","BASIX Pathway",{"$f":"IF(G47=AA49,16,\"-\")","v":"-"},null,{"$f":"IF(AND(K57>0,$K$56<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,null,null,"15D.0","Conditional Requirement: NABERS Pathway","-",null,null,"",""]
[null,null,null,null,null,null,null,"15D.1","NABERS Energy Commitment Agreement Pathway",{"$f":"IF(G47=AA50,20,\"-\")","v":"-"},null,{"$f":"IF(AND(K59>0,$K$58<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,null,null,"15E.0","Conditional Requirement: Reference Building Pathway","-",null,null,"",""]
[null,null,null,null,null,null,null,"15E.1","Comparison to a Reference Building Pathway",{"$f":"IF(G47=AA51,20,\"-\")","v":"-"},null,{"$f":"IF(AND(K61>0,K60<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,"Peak Electricity Demand Reduction","Prescriptive Pathway","16A","Prescriptive Pathway - On-site Energy Generation",{"$f":"IF(G62=AA62,1,\"-\")","v":1},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,null,null,"16B","Performance Pathway - Reference Building",{"$f":"IF(G62=AA63,2,\"-\")","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,"Total",null,null,null,{"$f":"IF(G47=AA47,10+SUM(J62:J63),SUM(J47:J63))","v":11},{"$f":"SUM(K47:K63)","v":0},{"$f":"IF(K64>J64,\"!\",\"\")","v":""},{"$f":"SUM(M47:M63)","v":0},{"$f":"SUM(N47:N63)","v":0}]
[]
[null,null,null,null,null,"Transport",null,null,null,{"$f":"10-SUM(B67:B72)","v":10}]
[null,null,null,null,null,"Sustainable Transport","Performance Pathway","17A.1","Performance Pathway",{"$f":"IF(G67=AA67,10,0)","v":10},null,null,{"$f":"IF(OR(Q67=$AC$9,Q67=$AC$10),K67,\"\")","v":""},{"$f":"IF(Q67=$AC$11,K67,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,null,null,"17B.1","Access by Public Transport",{"$f":"IF($G$67=$AA$68,3,0)","v":0},null,null,{"$f":"IF(OR(Q68=$AC$9,Q68=$AC$10),K68,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,{"$f":"IF(AND($G$67=$AA$68,C69=TRUE),1,0)","v":0},false,null,null,null,null,"17B.2","Reduced Car Parking Provision",{"$f":"IF(OR($G$67=$AA$67,C69=TRUE),0,1)","v":0},null,null,"",""]
[null,{"$f":"IF(AND($G$67=$AA$68,C70=TRUE),1,0)","v":0},false,null,null,null,null,"17B.3","Low Emission Vehicle Infrastructure",{"$f":"IF(OR($G$67=$AA$67,C70=TRUE),0,1)","v":0},null,null,"",""]
[null,null,null,null,null,null,null,"17B.4","Active Transport Facilities",{"$f":"IF($G$67=$AA$68,1,0)","v":0},null,null,"",""]
[null,null,null,null,null,null,null,"17B.5","Walkable Neighbourhoods",{"$f":"IF($G$67=$AA$68,1,0)","v":0},null,null,"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J67:J72)","v":10},{"$f":"SUM(K67:K72)","v":0},{"$f":"IF(K73>J73,\"!\",\"\")","v":""},{"$f":"SUM(M67:M72)","v":0},0]
[]
[null,null,null,null,null,"Water",null,null,null,{"$f":"12-SUM(B76:B81)","v":12}]
[null,null,null,null,null,"Potable Water","Performance Pathway","18A.1","Potable Water - Performance Pathway",{"$f":"IF(G76=AA76,12,0)","v":12},null,null,{"$f":"IF(OR(Q76=$AC$9,Q76=$AC$10),K76,\"\")","v":""},{"$f":"IF(Q76=$AC$11,K76,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Performance Pathway"]
[null,null,null,null,null,null,null,"18B.1","Sanitary Fixture Efficiency",{"$f":"IF($G$76=$AA$77,1,0)","v":0},null,null,{"$f":"IF(OR(Q77=$AC$9,Q77=$AC$10),K77,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway"]
[null,null,null,null,null,null,null,"18B.2","Rainwater Reuse",{"$f":"IF($G$76=$AA$77,1,0)","v":0},null,null,"",""]
[null,null,null,null,null,null,null,"18B.3","Heat Rejection",{"$f":"IF($G$76=$AA$77,2,0)","v":0},null,null,"",""]
[null,{"$f":"IF(AND($G$76=$AA$77,C80=TRUE),1,0)","v":0},false,null,null,null,null,"18B.4","Landscape Irrigation",{"$f":"IF(OR($G$76=$AA$76,C80=TRUE),0,1)","v":0},null,null,"",""]
[null,{"$f":"IF(AND($G$76=$AA$77,C81=TRUE),1,0)","v":0},false,null,null,null,null,"18B.5","Fire System Test Water",{"$f":"IF(OR($G$76=$AA$76,C81=TRUE),0,1)","v":0},null,null,"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J76:J81)","v":12},{"$f":"SUM(K76:K81)","v":0},{"$f":"IF(K82>J82,\"!\",\"\")","v":""},{"$f":"SUM(M76:M81)","v":0},0]
[]
[null,null,null,null,null,"Materials",null,null,null,{"$f":"14-SUM(B85:B95)","v":14}]
[null,null,null,null,null,"Life Cycle Impacts","Performance Pathway - Life Cycle Assessment","19A.1","Comparative Life Cycle Assessment",{"$f":"IF($G$85=$AA$85,6,0)","v":6},null,{"$f":"IF(SUM(K85:K86)>7,\"!\", \"\")","v":""},{"$f":"IF(OR(Q85=$AC$9,Q85=$AC$10),K85,\"\")","v":""},{"$f":"IF(Q85=$AC$11,K85,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"Performance Pathway - Life Cycle Assessment"]
[null,null,null,null,null,null,null,"19A.2","Additional Life Cycle Impact Reporting",4,null,{"$f":"IF(SUM(K85:K86)>7,\"!\", \"\")","v":""},{"$f":"IF(OR(Q86=$AC$9,Q86=$AC$10),K86,\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,"Prescriptive Pathway - Life Cycle Impacts"]
[null,null,null,null,null,null,null,"19B.1","Concrete",{"$f":"IF($G$85=$AA$86,3,0)","v":0},null,{"$f":"IF(SUM(K87:K89)>5,\"Error: the total number of points available for the 'Material Use' Pathway is 5. Please enter a points score less than or equal to 5.\",\"\")","v":""},"",""]
[null,null,null,null,null,null,null,"19B.2","Steel",{"$f":"IF($G$85=$AA$86,1,0)","v":0},null,null,"",""]
[4,{"$f":"IF(C89=TRUE,A89,0)","v":0},null,null,null,null,null,"19B.3","Building Reuse",{"$f":"IF($G$85=$AA$86,4,0)","v":0},null,null,"",""]
[1,0,false,null,null,"Responsible Building Materials","To reward projects that include materials that are responsibly sourced or have a sustainable supply chain. ",20.100000000000001,"Structural and Reinforcing Steel",{"$f":"IF(C90=TRUE,0,1)","v":1},null,null,"",""]
[1,0,false,null,null,null,null,20.2,"Timber Products",{"$f":"IF(C91=TRUE,0,1)","v":1},null,null,"",""]
[1,0,false,null,null,null,null,20.3,"Permanent Formwork, Pipes, Flooring, Blinds and Cables",1,null,null,"",""]
[null,null,null,null,null,"Sustainable Products","To encourage sustainability and transparency in product specification. ",21.1,"Product Transparency and Sustainability",3,null,null,"",{"$f":"IF(Q93=$AC$11,K93,\"\")","v":""}]
[null,null,null,null,null,"Construction and Demolition Waste","Fixed Benchmark","22A","Fixed Benchmark",{"$f":"IF(G94=AA94,1,\"-\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed Benchmark"]
[null,null,null,null,null,null,null,"22B","Percentage Benchmark",{"$f":"IF(G94=AA95,1,\"-\")","v":"-"},null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,"Percentage Benchmark"]
[null,null,null,null,null,"Total",null,null,null,{"$f":"IF(G85=AA86,12,14)","v":14},{"$f":"SUM(K85:K95)","v":0},{"$f":"IF(K96>J96,\"!\",\"\")","v":""},{"$f":"SUM(M85:M95)","v":0},{"$f":"SUM(N85:N95)","v":0}]
[]
[null,null,null,null,null,"Land Use & Ecology",null,null,null,{"$f":"6-SUM(B99:B104)","v":6}]
[null,null,null,null,null,"Ecological Value","To reward projects that improve the ecological value of their site.",23,"Endangered, Threatened or Vulnerable Species","-",null,null,{"$f":"IF(OR(Q99=$AC$9,Q99=$AC$10),K99,\"\")","v":""},{"$f":"IF(Q99=$AC$11,K99,\"\")","v":""}]
[null,null,null,null,null,null,null,23.1,"Ecological Value",3,null,{"$f":"IF(AND(K100>0,$K99<>$AD$8),\"!\",\"\")","v":""},{"$f":"IF(OR(Q100=$AC$9,Q100=$AC$10),K100,\"\")","v":""},""]
[null,null,null,null,null,"Sustainable Sites","To reward projects that choose to develop sites that have limited ecological value, re-use previously developed land and remediate contaminate land.",24,"Conditional Requirement","-",null,null,"",""]
[null,null,null,null,null,null,null,24.1,"Reuse of Land",1,null,{"$f":"IF(AND(K102>0,$K$101<>$AD$8),\"!\",\"\")","v":""},"",""]
[1,{"$f":"IF(C103=TRUE,A103,0)","v":0},false,null,null,null,null,24.2,"Contamination and Hazardous Materials",{"$f":"IF(C103=FALSE,1,0)","v":1},null,{"$f":"IF(AND(K103>0,$K$101<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,"Heat Island Effect","To encourage and recognise projects that reduce the contribution of the project site to the heat island effect.",25,"Heat Island Effect Reduction",1,null,null,"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J99:J104)","v":6},{"$f":"SUM(K99:K104)","v":0},{"$f":"IF(K105>J105,\"!\",\"\")","v":""},{"$f":"SUM(M99:M104)","v":0},0]
[]
[null,null,null,null,null,"Emissions",null,null,null,{"$f":"5-SUM(B108:B113)","v":5}]
[null,null,null,null,null,"Stormwater","To reward projects that minimise peak stormwater flows and reduce pollutants entering public sewer infrastructure.",26.1,"Stormwater Peak Discharge",1,null,null,{"$f":"IF(OR(Q108=$AC$9,Q108=$AC$10),K108,\"\")","v":""},{"$f":"IF(Q108=$AC$11,K108,\"\")","v":""}]
[null,null,null,null,null,null,null,26.2,"Stormwater Pollution Targets",1,null,null,{"$f":"IF(OR(Q109=$AC$9,Q109=$AC$10),K109,\"\")","v":""},""]
[null,null,null,null,null,"Light Pollution","To reward projects that minimise light pollution.",27,"Light Pollution to Neighbouring Bodies","-",null,null,"",""]
[null,null,null,null,null,null,null,27.1,"Light Pollution to Night Sky",1,null,{"$f":"IF(AND(K111>0,$K110<>$AD$8),\"!\",\"\")","v":""},"",""]
[null,null,null,null,null,"Microbial Control","To recognise projects that implement systems to minimise the impacts associated with harmful microbes in building systems.",28,"Legionella Impacts from Cooling Systems",1,null,null,"",""]
[null,null,null,null,null,"Refrigerant Impacts","To encourage operational practices that minimise the environmental impacts of refrigeration equipment.",29,"Refrigerants Impacts",1,null,null,"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J108:J113)","v":5},{"$f":"SUM(K108:K113)","v":0},{"$f":"IF(K114>J114,\"!\",\"\")","v":""},{"$f":"SUM(M108:M113)","v":0},0]
[]
[null,null,null,null,null,"Innovation",null,null,null,10]
[null,null,null,null,null,"Innovative Technology or Process","The project meets the aims of an existing credit using a technology or process that is considered innovative in Australia or the world.","30A","Innovative Technology or Process",10,null,null,{"$f":"IF(OR(Q117=$AC$9,Q117=$AC$10),K117,\"\")","v":""},{"$f":"IF(Q117=$AC$11,K117,\"\")","v":""}]
[null,null,null,null,null,"Market Transformation","The project has undertaken a sustainability initiative that substantially contributes to the broader market transformation towards sustainable development in Australia or in the world.","30B","Market Transformation",null,null,null,{"$f":"IF(OR(Q118=$AC$9,Q118=$AC$10),K118,\"\")","v":""},""]
[null,null,null,null,null,"Improving on Green Star Benchmarks","The project has achieved full points in a Green Star credit and demonstrates a substantial improvement on the benchmark required to achieve full points.","30C","Improving on Green Star Benchmarks",null,null,null,"",""]
[null,null,null,null,null,"Innovation Challenge","Where the project addresses an sustainability issue not included within any of the Credits in the existing Green Star rating tools.","30D","Innovation Challenge",null,null,null,"",""]
[null,null,null,null,null,"Global Sustainability","Project teams may adopt an approved credit from a Global Green Building Rating tool that addresses a sustainability issue that is currently outside the scope of this Green Star rating tools.","30E","Global Sustainability",null,null,null,"",""]
[null,null,null,null,null,"Total",null,null,null,{"$f":"SUM(J117)","v":10},{"$f":"IF(SUM(K117:K121)>10,10,SUM(K117:K121))","v":0},{"$f":"IF(K122>J122,\"!\",\"\")","v":""},{"$f":"SUM(M117:M121)","v":0},0]
[]
[null,"TOTAL NA POINTS",null,null,null,null,null,null,"TOTALS","AVAILABLE","TARGETED",null,"AWARDED","TBC"]
[null,{"$f":"SUM(B7:B113)","v":0},null,null,null,null,null,null,"CORE POINTS",{"$f":"100-B125","v":100},{"$f":"K24+K44+K64+K73+K82+K96+K105+K114","v":0},null,{"$f":"(M24+M44+M64+M73+M82+M96+M105+M114)/$J$125*100+M122","v":0},{"$f":"(N24+N44+N64+N73+N82+N96+N105+N114)/$J$125*100+N122","v":0}]
[null,null,null,null,null,null,null,null,"CATEGORY PERCENTAGE SCORE",null,{"$f":"K125/J125*100","v":0}]
[null,null,null,null,null,null,null,null,"INNOVATION POINTS",10,{"$f":"K122","v":0}]
[null,null,null,null,null,null,null,null,"TOTAL SCORE TARGETED",null,{"$f":"K126+K127","v":0}]
[]
[]
[]
[]
[null,null,null,"x",null,null,null,null,null,null,null,null,null,null,"Stage Count","Assessor Stage Count","Outcome Count","Assessment result"]
[null,null,null,"x",null,null,null,null,null,null,null,null,null,"Core",null,{"$f":"COUNTIF(P7:P113,\"Core\")","v":0},{"$f":"COUNTIF(Q7:Q113,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,"x",null,null,null,null,null,null,null,null,null,"Stage 1",{"$f":"COUNTIF(O7:O113,\"Stage 1\")","v":0},{"$f":"COUNTIF(P7:P113,\"Stage 1\")","v":0},{"$f":"COUNTIF(Q7:Q113,\"Not Awarded - Major Non-compliance\")","v":0},{"$f":"IF(Q135>P135*0.5, \"Go to Stage 2\", \"Assessment Complete\")","v":"Assessment Complete"}]
[null,null,null,"x",null,null,null,null,null,null,null,null,null,"Stage 2",{"$f":"COUNTIF(O7:O113,\"Stage 2\")","v":0},{"$f":"COUNTIF(P7:P113,\"Stage 2\")","v":0},{"$f":"COUNTIF(Q7:Q113,\"Not Awarded - Major Non-compliance\")","v":0},{"$f":"IF(AND(R135=\"Go to Stage 2\", P136=0),R135,IF(Q136>SUM(P135:P136)*0.5,\"Go to Stage 3\",\"Assessment Complete\"))","v":"Assessment Complete"}]
[null,null,null,"x",null,null,null,null,null,null,null,null,null,"Stage 3",{"$f":"COUNTIF(O7:O113,\"Stage 3\")","v":0},{"$f":"COUNTIF(P7:P113,\"Stage 3\")","v":0},{"$f":"COUNTIF(Q7:Q113,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,"x",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Q7:Q113,\"Awarded - Compliant\")+COUNTIF(Q7:Q113,\"Awarded - Minor non-Compliance\")+COUNTIF(Q7:Q113,\"Not Awarded - Major non-compliance\")","v":0},{"$f":"IF(R135=\"Assessment Complete\",R135,IF(R136=\"Assessment Complete\",R136,IF(P134>=1,R136,\"Assessment Complete\")))","v":"Assessment Complete"}]