{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Disclaimer","Introduction","Change Log","Design Review Scorecard","As Built Review Scorecard ","Submission Planner","ss - As Built Scorecard"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":72,"comments":3,"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":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Disclaimer"]

{"sheet":"Introduction","index":1,"n_rows":44,"n_cols":2,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Introduction"]
[null,"Using the Scorecard"]
[null,"Inputs can be made for the following fields:"]
[null,"- 'Targeted performance level' for each credit"]
[null,"- Points available for Leadership Challenges"]
[null,"The targeted performance level can be selected for each credit and a sum of points across the relevant performance levels are provided in 'Total points targeted'. When multiple point values are available for a chosen performance level, the cell in the 'Total Points Targeted' column will be highlighted in red for the user to enter a custom value within the available points range."]
[null,"Each category has a sum for the total points targeted in that category"]
[]
[null,"Terms & definitions"]
[null,"Summary - Net Zero Ready Pathway"]
[null,"Registering from"]
[null,"The range of years which the project registers from will determine the requirements of the pathway. See submission guidelines for more information."]
[null,"Desired Green Star rating"]
[null,"The pathway also depends on the rating that the project is seeking. Each rating will have to meet a different level of requirements in the pathway. The requirements for the desired rating will be coloured in blue for each relevant credit's performance level (note this is different to the calculated targeted rating)."]
[null,"Summary - Scoring"]
[null,"Minimum expectations met"]
[null,"Indicates if all 16 Minimum Expectations in the rating tool have been met"]
[null,"Core points targeted"]
[null,"Sum of all points targeted, excluding those in the Leadership category. There are 100 core points available."]
[null,"Leadership points targeted"]
[null,"Sum of points targeted in the Leadership category."]
[null,"Total points targeted"]
[null,"Sum of the core points and Leadership points targeted. The total points targeted and assessed will always be capped at 100."]
[null,"Targeted Green Star rating"]
[null,"The Green Star rating equivalent to the points targeted by the project. This ranges from 4 to 6 Star."]
[null,"Submission planner"]
[null,"Minimum Expectation"]
[null,"A dot is shown when a Minimum Expectation applies to the credit."]
[null,"Credit Achievement"]
[null,"The number of points available if Credit Achievement can be targeted for the credit."]
[null,"Exceptional Performance"]
[null,"The number of points available if Exceptional Performance can be targeted for the credit."]
[null,"Some credits have multiple point options avaialbe for Credit Achivement and Exceptional Performance. These cells will appear in red and the targeted score must be manually selected from the drop down list."]
[null,"Total points available"]
[null,"Sum of points available for the credit across all performance levels."]
[null,"Targeted performance level"]
[null,"Input for users to select the performance level being targeted for each credit"]
[null,"Total points targeted"]
[null,"Sum of points targeted for the credit based on the performance level selected. "]
[null,"Comments"]
[null,"Free text input to enter any comments about the credit to help plan the submission."]

{"sheet":"Change Log","index":2,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Releases"]
[]
[null,"Rating tool","Release","Summary of changes"]
[null,"Green Star Buildings v1 ","1 - 13/08/2024","Initial release"]
[]
[]
[]
[]
[]
[]
[]
["x","Change log"]
["x"]
["x","Release","Date","Sheets","Range","New value","Old value","Summary of change","Author","Reviewer","Approver"]
["x",1,"2020-10-29","All sheets","Password","Dqr`UhzFKU",null,"Password for the entire workbook","EC","DV","TC"]
["x",2,"2021-02-18","Change log","All","New sheet",null,"Added a change log sheet","EC","TC","TC"]
["x",2,"2021-02-18","Introduction","B3","<blank>","Version 1","Moved the version number and date from this sheet into the change log sheet","EC","TC","TC"]
["x",2,"2021-02-18","Introduction","B4","<blank>","29 October 2020","Moved the version number and date from this sheet into the change log sheet","EC","TC","TC"]
["x",2,"2021-02-18","Introduction","3:4","Row delete",null,"Moved the version number and date from this sheet into the change log sheet","EC","TC","TC"]
["x",2,"2021-02-18","Introduction","B5","Using the submission planner","Using the scorecard","Updating wording to use this document as a submission planner rather than scorecard","EC","TC","TC"]
["x",2,"2021-02-18","Introduction","B6","Selections and values can be entered into the 'Targeted performance level' and 'Comments' columns, as well as the points available for Credit Achievement under the Leadership category.","Inputs are only required in the 'Targeted performance level' and 'Comments' columns with the exception for the points available for Credit Achievement under the Leadership Challenge credits.","Updating wording to use this document as a submission planner rather than scorecard","EC","TC","TC"]
["x",2,"2021-02-18","Submission planner","B3","Submission planner","Scorecard","Updating wording to use this document as a submission planner rather than scorecard","EC","TC","TC"]
["x",2,"2021-02-18","Submission planner","4:4","Row added",null,"Added a subheading for the summary at the top","EC","TC","TC"]
["x",2,"2021-02-18","Submission planner","B4","Summary","<blank>","Added a subheading for the summary at the top","EC","TC","TC"]
["x",2,"2021-02-18","Submission planner","F8","=I83","=MIN(10,I83)","Removed the cap for Leadership category","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","5:5","Row insert",null,"Added an input for projects to select what year bracket they're registering from","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","B5","Registering from","<blank>","Added an input for projects to select what year bracket they're registering from","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","L14:M17, L6:M9","Range Move",null,"Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","L5","Points scale and net zero requirements","<blank>","Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","L6","Points","Green Star Buildings ratings","Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","M6","Rating","<blank>","Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","N6","2020 onwards","<blank>","Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","O6","2023 onwards","<blank>","Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","P6","2026 onwards","<blank>","Adding in the net zero requirements for each star rating across the 3 different registration periods","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","N7","No","<blank>","Net zero requirements for 4 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","O7","No","<blank>","Net zero requirements for 4 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","P7","Yes","<blank>","Net zero requirements for 4 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","N8","No","<blank>","Net zero requirements for 5 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","O8","Yes","<blank>","Net zero requirements for 5 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","P8","Yes","<blank>","Net zero requirements for 5 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","N9","Yes","<blank>","Net zero requirements for 6 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","O9","Yes","<blank>","Net zero requirements for 6 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","P9","Yes","<blank>","Net zero requirements for 6 Star","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","L10","Net zero required","<blank>","Checks the targeting rating and if net zero is required","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","M10","=IFNA(VLOOKUP(CAL_TotalPoints,REF_NetZeroRequirements,MATCH(IN_RegistratingFrom,L6:P6,0),TRUE),\"\")","<blank>",null,"EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","B6","Net zero carbon in operations targeted","Net zero in operations targeted","Updated wording","EC","TC","TC"]
["x",2,"2021-02-23","Submission planner","H6","=IF(AND(IFNA(VLOOKUP(CAL_TotalPoints,REF_NetZeroRequirements,MATCH(IN_RegistratingFrom,L6:Q6,0),TRUE),\"\")=\"Yes\",CAL_NetZeroTargeted=\"No\"),\"Net zero carbon in operations must be targeted for this rating\",\"\")","<blank>","Added in a message that pops up if net zero is required but hasn't been targeted","EC","TC","TC"]
["x",3,"2021-07-26","Introduction","B15","Climate Positive Pathway targeted","Net zero in operations targeted","Updated wording for the Climate Positive Pathway","EC","DF","DF"]
["x",3,"2021-07-26","Introduction","B16","Indicates if the Climate Positive Pathway has been targeted. The relevant credits in this pathway are in the Positive category and shaded in orange. This pathway is has 15 points if targeted: 14 from achieving the credits and 1 point added to Leadership Challenges. When targeted, the 1 Leadership Challenge point is automatically added to the total points targeted.","Indicates if the Net zero in operations pathway has been targeted. The relevant credits in this pathway are in the Positive category and shaded in orange. This pathway is has 15 points if targeted: 14 from achieving the credits and 1 point added to Leadership Challenges. When targeted, the 1 Leadership Challenge point is automatically added to the total points targeted.","Updated wording for the Climate Positive Pathway","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","B6","Climate Positive Pathway targeted","Net zero carbon in operations targeted","Updated wording for the Climate Positive Pathway","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","L10","<blank>","Net zero required","Removed the formula for 'CAL_NetZeroRequired'","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","M10","<blank>","=IFNA(VLOOKUP(CAL_TotalPoints,REF_NetZeroRequirements,MATCH(IN_RegistratingFrom,L6:P6,0),TRUE),\"\")","Added the formula directly into the calculation for instruction if climate positive pathway must be targeted (cell H6)","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","R5:W9, L5:P9","Range Move",null,"Moved the climate positive requirements table","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","R5","Climate Positive requirements","Points scale and net zero requirements","Updated wording for the Climate Positive Pathway","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","W6","after 2030","<blank>","Adding in the net zero requirements for projects certified after 2030","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","W7","Yes","<blank>","Net zero requirements for 4 Star","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","W8","Yes","<blank>","Net zero requirements for 5 Star","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","W9","Yes","<blank>","Net zero requirements for 6 Star","EC","DF","DF"]
["x",3,"2021-07-26","Submission planner","H6","=IF(AND(IFNA(VLOOKUP(CAL_TotalPoints,REF_ClimatePositiveRequirements,MATCH(IN_RegistratingFrom,R6:W6,0),TRUE),\"\")=\"Yes\",CAL_ClimatePositiveTargeted=\"No\"),\"The Climate Positive Pathway must be targeted for this rating\",\"\")","=IF(AND(CAL_NetZeroRequired=\"Yes\",CAL_NetZeroTargeted=\"No\"),\"Net zero carbon in operations must be targeted for this rating\",\"\")","Updated wording for the Climate Positive Pathway and combined with formula for 'CAL_NetZeroRequired'","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L44","Climate positive pathways","<blank>","Outlining the different requirements of the pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","M45:X45","# Star 20## onwards / after 2030","<blank>","List of all possible ratings and registering from / certified after years as per the climate positive pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","M46:X49","Credit Achievement (1) / Exceptional Performance (2)","<blank>","List of the performance level requirements for the climate positive pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L6","Performance levels","<blank>","Assinging numerical values to each performance level to use in calculations","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L7","Minimum Expectation","<blank>","Minimum Expectation = 0","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","M7",0,"<blank>","Minimum Expectation = 0","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L8","Credit Achievement","<blank>","Credit Achievement = 1","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","M8",1,"<blank>","Credit Achievement = 1","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L9","Exceptional Performance","<blank>","Exceptional Performance = 2","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","M9",2,"<blank>","Exceptional Performance = 2","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L45","Targeted","<blank>","Determine if climate positive pathway is targeted","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L46","=VLOOKUP(H46,REF_PerformanceLevelValues,2,FALSE)>=INDEX($M46:$X46,1,MATCH($P$6&\" \"&IN_RegistratingFrom,$M$45:$X$45,0))","<blank>","Check if the correct performance levels have been targeted for each credit in the pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L47","=VLOOKUP(H47,REF_PerformanceLevelValues,2,FALSE)>=INDEX($M47:$X47,1,MATCH($P$6&\" \"&IN_RegistratingFrom,$M$45:$X$45,0))","<blank>","Check if the correct performance levels have been targeted for each credit in the pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L48","=VLOOKUP(H48,REF_PerformanceLevelValues,2,FALSE)>=INDEX($M48:$X48,1,MATCH($P$6&\" \"&IN_RegistratingFrom,$M$45:$X$45,0))","<blank>","Check if the correct performance levels have been targeted for each credit in the pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","L49","=VLOOKUP(H49,REF_PerformanceLevelValues,2,FALSE)>=INDEX($M49:$X49,1,MATCH($P$6&\" \"&IN_RegistratingFrom,$M$45:$X$45,0))","<blank>","Check if the correct performance levels have been targeted for each credit in the pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","C6","=IF(COUNTIF(L46:L49,TRUE)=4,\"Yes\",\"No\")","=IF(AND(COUNT(REF_NetZeroCredits)=4,CAL_PointsTargeted_21>=D46,CAL_PointsTargeted_22>=D47,CAL_PointsTargeted_23>=SUM(D48:E48),CAL_PointsTargeted_24>=D49),\"Yes\",\"No\")","Updated wording for Climate Positive Pathway and simplified formula","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","O5","Targeted rating without climate positive point","<blank>","Calculation of the targeted rating without adding the extra point for targeting the climate positive pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","O6","Green Star rating","<blank>","Targeted rating","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","P6","=IFNA(VLOOKUP(P9,REF_PointsScale,2,TRUE),\"\")","<blank>","Targeted rating without leadership point for climate positive pathway formula is the same","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","O7","Core points","<blank>","Core points targeted","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","P7","=CAL_CorePoints","<blank>","Core points targeted remains the same","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","O8","Leadership points","<blank>","Leadership points","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","P8","=IF(H81=$C$11,C81,IF(H81=$D$11,D81,IF(H81=$E$11,SUM(D81:E81),0)))+IF(H82=$C$11,C82,IF(H82=$D$11,D82,IF(H82=$E$11,SUM(D82:E82),0)))","<blank>","Leadership points targeted without point for climate positive pathway","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","O9","Total points targeted","<blank>","Total points targeted","EC","DF","DF"]
["x",3,"2021-08-13","Submission planner","P9","=MIN(100,P7+P8)","<blank>","Total points targeted without climate positive pathway point","EC","DF","DF"]
["x",3,"2021-09-21","Submission planner","L50","Total points","<blank>","Total points available for climate positive pathways","EC","DF","DF"]
["x",3,"2021-09-21","Submission planner","M50:X50","14; 16; 19","<blank>","Depending on the rating and year, points available for the climate positive pathways can be 14, 16, or 19","EC","DF","DF"]
["x",3,"2021-09-21","Submission planner","I82","=IF(H82=$C$11,C82,IF(H82=$D$11,D82,IF(H82=$E$11,SUM(D82:E82),0)))+IFNA(IF(AND(INDEX($M50:$X50,1,MATCH($P$6&\" \"&IN_RegistratingFrom,$M$45:$X$45,0))<=15,CAL_ClimatePositiveTargeted=\"Yes\"),1,0),0)","=IF(H82=$C$11,C82,IF(H82=$D$11,D82,IF(H82=$E$11,SUM(D82:E82),0)))+IF(CAL_ClimatePositiveTargeted=\"Yes\"),1,0)","Leadership point for targeting climate positive pathway is only awarded if the pathway is worth 14 points i.e. up to 2026 for 4 Star, 2023 for 5 Star, and 2020 for 6 Star","EC","DF","DF"]
["x",4,"2022-06-10","Submission planner","5:5","Row insert",null,"Separating the summary section into 2","EC"]
["x",4,"2022-06-10","Submission planner","B5","Climate Positive Pathway",null,"Providing a clear section to summarise all CPP requirements and targets","EC"]
["x",4,"2022-06-10","Submission planner","B7","Scoring",null,"Section to calculate points and targeted rating","EC"]
["x",4,"2022-06-10","Submission planner","B5:F10","Moved cells",null,"Moved cells around to have a clearer separate summary for scoring and for CPP"]
["x",4,"2022-06-10","Submission planner","D6","Desired Green Star rating","<blank>","Added in a section for teams to select the 'desired rating' so that they can see which CPP they will fall under","EC"]
["x",4,"2022-06-10","Submission planner","D9","Climate Positive Pathway met","Climate Positive Pathway targeted",null,"EC"]
["x",4,"2022-06-10","Submission planner","H6","=IF(IFNA(VLOOKUP(IN_DesiredRating,S8:W10,MATCH(IN_RegistratingFrom,S7:W7,0),TRUE),\"\")=\"Yes\",\"The Climate Positive Pathway must be targeted for the desired rating\",IF(IFNA(VLOOKUP(IN_DesiredRating,S8:W10,MATCH(IN_RegistratingFrom,S7:W7,0),TRUE),\"\")=\"No\",\"The Climate Positive Pathway is optional for the desired rating\",\"\"))","<blank>","Added in extra guidance to indicate if CPP is optional or not for the desired rating (as opposed to the calculated targeted rating)","EC"]
["x",4,"2022-06-10","Submission planner","B17:B20","Delete rows",null,"Removed the definitions for CA and EP points targeted which were removed from the summary","EC"]
["x",4,"2022-06-10","Introduction","B29","Climate positive pathway met","Climate Positive Pathway targeted","Updating terminology for instructions","EC"]
["x",4,"2022-06-10","Introduction","B30","Indicates if the Climate Positive Pathway has been targeted. The relevant credits in this pathway are in the Positive category and are dependent on the project's targeted rating and year it is registring from or certified after. Once the year is selected and targeted rating calculated, these credits are shaded in green. This pathway is has 15 points if targeted: 14 from achieving the credits and 1 point added to Leadership Challenges. When targeted, the 1 Leadership Challenge point is automatically added to the total points targeted.","Indicates if the Climate Positive Pathway has been targeted. The relevant credits in this pathway are in the Positive category and are dependent on the project's targeted rating and year it is registring from or certified after. Once the year is selected and targeted rating calculated, these credits are shaded in orange. This pathway is has 15 points if targeted: 14 from achieving the credits and 1 point added to Leadership Challenges. When targeted, the 1 Leadership Challenge point is automatically added to the total points targeted.","Updating terminology for instructions","EC"]
["x",4,"2022-06-10","Introduction","B13","Registering from / certified after","<blank>","Updating terminology for instructions","EC"]
["x",4,"2022-06-10","Introduction","B14","The range of years which the project registers or certifies from will determine the requirements of the pathway","<blank>","Updating terminology for instructions","EC"]
["x",4,"2022-06-10","Introduction","B15","Desired Green Star rating","<blank>","Updating terminology for instructions","EC"]
["x",4,"2022-06-10","Introduction","B16","The pathway also depends on the rating that the proejct is seeking. Each rating will have to meet a different level of requirements in the pathway. The credit requirements for the desired rating will be outlined with a blue border (note this is different to the final calculated targeted rating).","<blank>","Updating terminology for instructions","EC"]
["x",5,"2022-09-29","Submission planner","B7","Green Star rating","Scoring","Updated to match GSP v2 submission planner","EC"]
["x",5,"2022-09-29","Submission planner","B8:F10","Cells moved",null,"Rearranged the order of the scoring sumarry","EC"]

{"sheet":"Design Review Scorecard","index":3,"n_rows":80,"n_cols":36,"rows_kept":80,"cut":false,"hidden":false,"merged":[[2,21,2,23],[3,14,3,16],[3,21,3,23],[5,14,5,16],[0,0,0,4],[0,13,0,16],[0,17,0,23],[1,14,1,16],[1,21,1,23],[1,1,1,2],[1,18,1,20],[2,18,2,20],[3,18,3,20],[4,18,4,20],[2,1,2,2],[3,1,3,2],[4,1,4,2],[4,21,4,23],[2,14,2,16]]}
["Green Star Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x"]
["Project name:",null,null,null,null,null,"Core Points Available (Targeted)","Project Score (Targeted)",null,null,"Project Score (Awarded)","Total Points TBC",null,null,"Post Round 1 Clarification \nPlease enter type of clarification for each credit as follows:",null,null,null,"Post Round 1 Clarification \nPlease enter type of clarification for each credit as follows. Please note you can only chose 5 credits to ask for clarification and have to submit to NZGBC within 5 working days.",null,null,"Post Round 2 Clarification \nPlease enter type of clarification for each credit as follows. Please note you can only chose 5 credits to ask for clarification and have to submit to NZGBC within 5 working days."]
["Targeted Rating:",{"$f":"IF(H3>=70,\"6 Stars - World Leadership\",IF(H3>=35,\"5 Star - New Zealand Excellence\",IF(H3>=15,\"4 Star - New Zealand Best Practice\",\"\")))","v":""},null,null,null,null,{"$f":"G68","v":100},{"$f":"H70","v":0},null,null,{"$f":"K68","v":0},{"$f":"L68","v":0},null,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,"1. Documentation Clarification: The project team wish to clarify the documentation requested in the Round 1 Assessment Comment "]
["Minimum Expectations Met:",{"$f":"COUNTIFS(F10:F60,\"<>\",C10:C60,\"=•\")& \" out of 16\"","v":"0 out of 16"},null,null,null,null,null,null,null,null,null,null,null,null,"2. Compliance 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. Compliance Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements.",null,null,"2. Compliance Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements."]
["Rating Achieved:",{"$f":"IF(K3>=70,\"6 Stars - World Leadership\",IF(K3>=35,\"5 Star - New Zealand Excellence\",IF(K3>=15,\"4 Star - New Zealand Best Practice\",\"\")))","v":""},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 Assessors' attention to documentation submitted previously that may have been overlooked during the assessment.",null,null,"3. Check Existing Documentation: The project team wish to draw the Assessors' attention to documentation submitted previously that may have been overlooked during the assessment."]
[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 Assessors' attention to documentation submitted previously that may have been overlooked during the assessment. "]
["CATEGORY / CREDIT","CODE","MINIMUM EXPECTATION","CREDIT ACHIEVEMENT","EXCEPTIONAL PERFORMANCE","TARGETED PERFORMANCE LEVEL","POINTS AVAILABLE","POINTS TARGETED",null,null," POINTS AWARDED"," POINTS \nTBC","POINTS 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 PR1C\n(GSAP to complete)","Clarification from Assessors\n(To be Completed by Assessors) ","Type","Clarification Request PR1C\n(GSAP to complete)","Clarification from Assessors\n(To be Completed by Assessors) "]
[null,null,null,null,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,"Assessors comments including Point(s) Awarded/Denied"]
["Responsible ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessors comments including Point(s) Awarded/Denied",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Industry development",1,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M10=$AA$12,M10=$AA$13),H10,\"\")","v":""},{"$f":"IF(M10=$AA$14,H10,\"\")","v":""}]
["Responsible Construction",2,"•",1,null,null,1,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complies"]
["Verification and Handover",3,"•",1,null,null,1,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Core","Awarded - Compliant","Does not comply"]
["Responsible Resource Management",4,"•",null,null,null,{"$f":"C7","v":"MINIMUM EXPECTATION"},null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 1","Awarded - Minor non-compliance"]
["Responsible Procurement",5,null,1,null,null,1,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 2","Not Awarded - Major non-compliance"]
["Responsible Structure",6,null,3,2,null,5,null,null,null,"",""]
["Responsible Envelope",7,null,2,2,null,4,null,null,null,"",""]
["Responsible Systems",8,null,1,1,null,2]
["Responsible Finishes ",9,null,1,1,null,2,null,null,null,{"$f":"IF(OR(M18=$AA$12,M18=$AA$13),H18,\"\")","v":""},{"$f":"IF(M18=$AA$14,H18,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Total",null,null,null,null,null,{"$f":"SUM(G10:G18)","v":17},{"$f":"SUM(H10:H18)","v":0},{"$f":"IF(H19>G19,\"!\",\"\")","v":""},null,{"$f":"SUM(K10:K18)","v":0},{"$f":"SUM(L10:L18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG19,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH19,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH19,0)","v":{"$error":"#REF!"}}]
["Healthy",null,null,null,null,null,null,null,{"$f":"IF(H20>G20,\"!\",\"\")","v":""},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(#REF!=TRUE,0,IF(#REF!=FALSE,#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,IF(#REF!=TRUE,1-AF20,\"-\"))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH20,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH20,0)","v":{"$error":"#REF!"}}]
["Clean Air",10,"•",2,null,null,2,null,null,null,{"$f":"IF(OR(M21=$AA$12,M21=$AA$13),H21,\"\")","v":""},{"$f":"IF(M21=$AA$14,H21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Light Quality",11,"•",2,2,null,4,null,null,null,{"$f":"IF(OR(M22=$AA$12,M22=$AA$13),H22,\"\")","v":""},{"$f":"IF(M22=$AA$14,H22,\"\")","v":""}]
["Acoustic Comfort",12,"•",2,null,null,2,null,null,null,"",""]
["Exposure to Toxins",13,"•",2,null,null,2,null,null,null,"",""]
["Therman Comfort and Amenity Spaces",14,"•",1,1,null,2,null,null,null,"",""]
["Connection to Nature",15,null,1,1,null,2,null,null,null,"",{"$f":"IF(M26=$AA$14,H26,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Total",null,null,null,null,null,{"$f":"SUM(G21:G26)","v":14},{"$f":"SUM(H21:H26)","v":0},{"$f":"IF(H27>G27,\"!\",\"\")","v":""},null,{"$f":"SUM(K21:K26)","v":0},{"$f":"SUM(L21:L26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG27,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH27,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH27,0)","v":{"$error":"#REF!"}}]
["Resilient",null,null,null,null,null,null,null,{"$f":"IF(H28>G28,\"!\",\"\")","v":""}]
["Climate Change Resilience",16,"•",1,null,null,1,null,null,null,{"$f":"IF(OR(M29=$AA$12,M29=$AA$13),H29,\"\")","v":""},{"$f":"IF(M29=$AA$14,H29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Operations Resilience",17,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M30=$AA$12,M30=$AA$13),H30,\"\")","v":""},{"$f":"IF(M30=$AA$14,H30,\"\")","v":""}]
["Community Resilience",18,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M31=$AA$12,M31=$AA$13),H31,\"\")","v":""},""]
["Heat Resilience",19,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M32=$AA$12,M32=$AA$13),H32,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G29:G32)","v":5},{"$f":"SUM(H29:H32)","v":0},null,null,{"$f":"SUM(K29:K32)","v":0},{"$f":"SUM(L29:L32)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG33,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH33,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH33,0)","v":{"$error":"#REF!"}}]
["Positive"]
["Grid Resilience",20,null,2,2,null,4,null,null,null,{"$f":"IF(OR(M35=$AA$12,M35=$AA$13),H35,\"\")","v":""},""]
["Upfront Carbon Emissions",21,"•",4,4,null,8,null,null,null,"",""]
["Energy Use",22,"•",3,4,null,7,null,null,null,"",""]
["Energy Source",23,"•",1,1,null,2,null,null,null,"",""]
["Other Carbon Emissions",24,null,2,2,null,4,null,null,null,"",""]
["Water Use",25,"•",3,3,null,6,null,null,null,"",""]
["Life Cycle Impacts",26,null,1,1,null,2,null,null,null,"",""]
["Total",null,null,null,null,null,{"$f":"SUM(G35:G41)","v":33},{"$f":"SUM(H35:H41)","v":0},null,null,{"$f":"SUM(K35:K41)","v":0},{"$f":"SUM(L35:L41)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG42,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH42,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH42,0)","v":{"$error":"#REF!"}}]
["Places"]
["Movement and Place",27,"•",3,null,null,3,null,null,null,{"$f":"IF(OR(M44=$AA$12,M44=$AA$13),H44,\"\")","v":""},""]
["Enjoyable Places",28,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M45=$AA$12,M45=$AA$13),H45,\"\")","v":""},""]
["Contribution to Place",29,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M46=$AA$12,M46=$AA$13),H46,\"\")","v":""},""]
["Culture, Heritage and Identity",30,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M47=$AA$12,M47=$AA$13),H47,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G44:G47)","v":8},{"$f":"SUM(H44:H47)","v":0},null,null,{"$f":"SUM(K44:K47)","v":0},{"$f":"SUM(L44:L47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG48,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH48,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH48,0)","v":{"$error":"#REF!"}}]
["People"]
["Inclusive Construction Practices",31,"•",1,null,null,1,null,null,null,{"$f":"IF(OR(M50=$AA$12,M50=$AA$13),H50,\"\")","v":""},""]
["Indigenous Inclusion",32,null,1,1,null,2,null,null,null,{"$f":"IF(OR(M51=$AA$12,M51=$AA$13),H51,\"\")","v":""},""]
["Procurement and Workforce Inclusion",33,null,2,1,null,3,null,null,null,{"$f":"IF(OR(M52=$AA$12,M52=$AA$13),H52,\"\")","v":""},""]
["Design for Inclusion",34,null,2,1,null,3,null,null,null,{"$f":"IF(OR(M53=$AA$12,M53=$AA$13),H53,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G50:G53)","v":9},{"$f":"SUM(H50:H53)","v":0},null,null,{"$f":"SUM(K50:K53)","v":0},{"$f":"SUM(L50:L53)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG54,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH54,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH54,0)","v":{"$error":"#REF!"}}]
["Nature",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M55=$AA$12,M55=$AA$13),H55,\"\")","v":""},{"$f":"IF(OR(N55=$AA$12,N55=$AA$13),I55,\"\")","v":""},{"$f":"IF(OR(O55=$AA$12,O55=$AA$13),J55,\"\")","v":""},{"$f":"IF(OR(P55=$AA$12,P55=$AA$13),K55,\"\")","v":""},{"$f":"IF(OR(Q55=$AA$12,Q55=$AA$13),L55,\"\")","v":""},{"$f":"IF(OR(R55=$AA$12,R55=$AA$13),M55,\"\")","v":""},{"$f":"IF(OR(V55=$AA$12,V55=$AA$13),N55,\"\")","v":""},{"$f":"IF(OR(W55=$AA$12,W55=$AA$13),O55,\"\")","v":""}]
["Impacts to Nature",35,"•",2,null,null,2,null,null,null,{"$f":"IF(OR(M56=$AA$12,M56=$AA$13),H56,\"\")","v":""},""]
["Biodiversity Enhancement",36,null,2,2,null,4,null,null,null,{"$f":"IF(OR(M57=$AA$12,M57=$AA$13),H57,\"\")","v":""},""]
["Nature Connectivity",37,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M58=$AA$12,M58=$AA$13),H58,\"\")","v":""},""]
["Nature Stewardship",38,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M59=$AA$12,M59=$AA$13),H59,\"\")","v":""},""]
["Waterway Protection",39,null,2,2,null,4,null,null,null,{"$f":"IF(OR(M60=$AA$12,M60=$AA$13),H60,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G56:G60)","v":14},{"$f":"SUM(H56:H60)","v":0},null,null,{"$f":"SUM(K56:K60)","v":0},{"$f":"SUM(L56:L60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG61,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH61,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH61,0)","v":{"$error":"#REF!"}}]
["Leadership",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M62=$AA$12,M62=$AA$13),H62,\"\")","v":""},{"$f":"IF(OR(N62=$AA$12,N62=$AA$13),I62,\"\")","v":""},{"$f":"IF(OR(O62=$AA$12,O62=$AA$13),J62,\"\")","v":""},{"$f":"IF(OR(P62=$AA$12,P62=$AA$13),K62,\"\")","v":""},{"$f":"IF(OR(Q62=$AA$12,Q62=$AA$13),L62,\"\")","v":""},{"$f":"IF(OR(R62=$AA$12,R62=$AA$13),M62,\"\")","v":""},{"$f":"IF(OR(V62=$AA$12,V62=$AA$13),N62,\"\")","v":""},{"$f":"IF(OR(W62=$AA$12,W62=$AA$13),O62,\"\")","v":""}]
["Market Transformation",40,null,null,null,null,5,null,null,null,{"$f":"IF(OR(M63=$AA$12,M63=$AA$13),H63,\"\")","v":""},""]
["Leadership Challenges",41,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M64=$AA$12,M64=$AA$13),H64,\"\")","v":""}]
["Total",null,null,null,null,null,null,{"$f":"SUM(H63:H64)","v":0},null,null,{"$f":"SUM(K63:K64)","v":0},{"$f":"SUM(L63:L64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG65,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH65,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH65,0)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"TOTALS",null,"AVAILABLE","TARGETED",null,null,"AWARDED","TBC"]
[null,null,null,null,"CORE POINTS",null,{"$f":"SUM(G19+G27+G33+G42+G48+G54+G61)","v":100},{"$f":"SUM(H19+H27+H33+H42+H48+H54+H61)","v":0},null,null,{"$f":"SUM(K19+K27+K33+K42+K48+K54+K61+K65)","v":0},{"$f":"SUM(L19+L27+L33+L42+L48+L54+L61+L65)","v":0}]
[null,null,null,null,"LEADERSHIP POINTS",null,null,{"$f":"H65","v":0}]
[null,null,null,null,"TOTAL SCORE TARGETED",null,null,{"$f":"H68+H69","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Outcome Count"]
[null,null,null,null,null,null,null,null,null,null,null,"Core",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stage 1",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stage 2",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stage 3",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M10:M65,\"Awarded - Compliant\")+COUNTIF(M10:M65,\"Awarded - Minor non-Compliance\")+COUNTIF(M10:M65,\"Not Awarded - Major non-compliance\")","v":0}]

{"sheet":"As Built Review Scorecard ","index":4,"n_rows":80,"n_cols":36,"rows_kept":80,"cut":false,"hidden":false,"merged":[[4,1,4,2],[4,18,4,20],[4,21,4,23],[5,14,5,16],[2,1,2,2],[2,14,2,16],[2,18,2,20],[2,21,2,23],[3,1,3,2],[3,14,3,16],[3,18,3,20],[3,21,3,23],[0,0,0,4],[0,13,0,16],[0,17,0,23],[1,1,1,2],[1,14,1,16],[1,18,1,20],[1,21,1,23]]}
["Green Star Buildings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x"]
["Project name:",{"$f":"IF('Design Review Scorecard'!B2=\"\",\"\",'Design Review Scorecard'!B2)","v":""},null,null,null,null,"Core Points Available (Targeted)","Project Score (Targeted)",null,null,"Project Score (Awarded)","Total Points TBC",null,null,"Post Round 1 Clarification \nPlease enter type of clarification for each credit as follows:",null,null,null,"Post Round 1 Clarification \nPlease enter type of clarification for each credit as follows. Please note you can only chose 5 credits to ask for clarification and have to submit to NZGBC within 5 working days.",null,null,"Post Round 2 Clarification \nPlease enter type of clarification for each credit as follows. Please note you can only chose 5 credits to ask for clarification and have to submit to NZGBC within 5 working days."]
["Targeted Rating:",{"$f":"IF(H3>=70,\"6 Stars - World Leadership\",IF(H3>=35,\"5 Star - New Zealand Excellence\",IF(H3>=15,\"4 Star - New Zealand Best Practice\",\"\")))","v":""},null,null,null,null,{"$f":"G68","v":100},{"$f":"H70","v":0},null,null,{"$f":"K68","v":0},{"$f":"L68","v":0},null,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,"1. Documentation Clarification: The project team wish to clarify the documentation requested in the Round 1 Assessment Comment "]
["Minimum Expectations Met:",{"$f":"COUNTIFS(F10:F60,\"<>\",C10:C60,\"=•\")& \" out of 16\"","v":"0 out of 16"},null,null,null,null,null,null,null,null,null,null,null,null,"2. Compliance 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. Compliance Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements.",null,null,"2. Compliance Criteria:  The project team wish to draw attention to potential differences in expectations between the assessment comment and the Submission Guidelines requirements."]
["Rating Achieved:",{"$f":"IF(K3>=70,\"6 Stars - World Leadership\",IF(K3>=35,\"5 Star - New Zealand Excellence\",IF(K3>=15,\"4 Star - New Zealand Best Practice\",\"\")))","v":""},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 Assessors' attention to documentation submitted previously that may have been overlooked during the assessment.",null,null,"3. Check Existing Documentation: The project team wish to draw the Assessors' attention to documentation submitted previously that may have been overlooked during the assessment."]
[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 Assessors' attention to documentation submitted previously that may have been overlooked during the assessment. "]
["CATEGORY / CREDIT","CODE","MINIMUM EXPECTATION","CREDIT ACHIEVEMENT","EXCEPTIONAL PERFORMANCE","TARGETED PERFORMANCE LEVEL","POINTS AVAILABLE","POINTS TARGETED",null,null," POINTS AWARDED"," POINTS \nTBC","POINTS 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 PR1C\n(GSAP to complete)","Clarification from Assessors\n(To be Completed by Assessors) ","Type","Clarification Request PR1C\n(GSAP to complete)","Clarification from Assessors\n(To be Completed by Assessors) "]
[null,null,null,null,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,"Assessors comments including Point(s) Awarded/Denied"]
["Responsible ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Assessors comments including Point(s) Awarded/Denied",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Industry development",1,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M10=$AA$12,M10=$AA$13),H10,\"\")","v":""},{"$f":"IF(M10=$AA$14,H10,\"\")","v":""}]
["Responsible Construction",2,"•",1,null,null,1,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Complies"]
["Verification and Handover",3,"•",1,null,null,1,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Core","Awarded - Compliant","Does not comply"]
["Responsible Resource Management",4,"•",null,null,null,{"$f":"C7","v":"MINIMUM EXPECTATION"},null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 1","Awarded - Minor non-compliance"]
["Responsible Procurement",5,null,1,null,null,1,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,"Stage 2","Not Awarded - Major non-compliance"]
["Responsible Structure",6,null,3,2,null,5,null,null,null,"",""]
["Responsible Envelope",7,null,2,2,null,4,null,null,null,"",""]
["Responsible Systems",8,null,1,1,null,2]
["Responsible Finishes ",9,null,1,1,null,2,null,null,null,{"$f":"IF(OR(M18=$AA$12,M18=$AA$13),H18,\"\")","v":""},{"$f":"IF(M18=$AA$14,H18,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Total",null,null,null,null,null,{"$f":"SUM(G10:G18)","v":17},{"$f":"SUM(H10:H18)","v":0},{"$f":"IF(H19>G19,\"!\",\"\")","v":""},null,{"$f":"SUM(K10:K18)","v":0},{"$f":"SUM(L10:L18)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG19,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH19,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH19,0)","v":{"$error":"#REF!"}}]
["Healthy",null,null,null,null,null,null,null,{"$f":"IF(H20>G20,\"!\",\"\")","v":""},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(#REF!=TRUE,0,IF(#REF!=FALSE,#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,IF(#REF!=TRUE,1-AF20,\"-\"))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH20,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH20,0)","v":{"$error":"#REF!"}}]
["Clean Air",10,"•",2,null,null,2,null,null,null,{"$f":"IF(OR(M21=$AA$12,M21=$AA$13),H21,\"\")","v":""},{"$f":"IF(M21=$AA$14,H21,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Light Quality",11,"•",2,2,null,4,null,null,null,{"$f":"IF(OR(M22=$AA$12,M22=$AA$13),H22,\"\")","v":""},{"$f":"IF(M22=$AA$14,H22,\"\")","v":""}]
["Acoustic Comfort",12,"•",2,null,null,2,null,null,null,"",""]
["Exposure to Toxins",13,"•",2,null,null,2,null,null,null,"",""]
["Therman Comfort and Amenity Spaces",14,"•",1,1,null,2,null,null,null,"",""]
["Connection to Nature",15,null,1,1,null,2,null,null,null,"",{"$f":"IF(M26=$AA$14,H26,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Total",null,null,null,null,null,{"$f":"SUM(G21:G26)","v":14},{"$f":"SUM(H21:H26)","v":0},{"$f":"IF(H27>G27,\"!\",\"\")","v":""},null,{"$f":"SUM(K21:K26)","v":0},{"$f":"SUM(L21:L26)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG27,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH27,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH27,0)","v":{"$error":"#REF!"}}]
["Resilient",null,null,null,null,null,null,null,{"$f":"IF(H28>G28,\"!\",\"\")","v":""}]
["Climate Change Resilience",16,"•",1,null,null,1,null,null,null,{"$f":"IF(OR(M29=$AA$12,M29=$AA$13),H29,\"\")","v":""},{"$f":"IF(M29=$AA$14,H29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,1]
["Operations Resilience",17,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M30=$AA$12,M30=$AA$13),H30,\"\")","v":""},{"$f":"IF(M30=$AA$14,H30,\"\")","v":""}]
["Community Resilience",18,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M31=$AA$12,M31=$AA$13),H31,\"\")","v":""},""]
["Heat Resilience",19,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M32=$AA$12,M32=$AA$13),H32,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G29:G32)","v":5},{"$f":"SUM(H29:H32)","v":0},null,null,{"$f":"SUM(K29:K32)","v":0},{"$f":"SUM(L29:L32)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG33,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH33,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH33,0)","v":{"$error":"#REF!"}}]
["Positive"]
["Grid Resilience",20,null,2,2,null,4,null,null,null,{"$f":"IF(OR(M35=$AA$12,M35=$AA$13),H35,\"\")","v":""},""]
["Upfront Carbon Emissions",21,"•",4,4,null,8,null,null,null,"",""]
["Energy Use",22,"•",3,4,null,7,null,null,null,"",""]
["Energy Source",23,"•",1,1,null,2,null,null,null,"",""]
["Other Carbon Emissions",24,null,2,2,null,4,null,null,null,"",""]
["Water Use",25,"•",3,3,null,6,null,null,null,"",""]
["Life Cycle Impacts",26,null,1,1,null,2,null,null,null,"",""]
["Total",null,null,null,null,null,{"$f":"SUM(G35:G41)","v":33},{"$f":"SUM(H35:H41)","v":0},null,null,{"$f":"SUM(K35:K41)","v":0},{"$f":"SUM(L35:L41)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG42,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH42,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH42,0)","v":{"$error":"#REF!"}}]
["Places"]
["Movement and Place",27,"•",3,null,null,3,null,null,null,{"$f":"IF(OR(M44=$AA$12,M44=$AA$13),H44,\"\")","v":""},""]
["Enjoyable Places",28,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M45=$AA$12,M45=$AA$13),H45,\"\")","v":""},""]
["Contribution to Place",29,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M46=$AA$12,M46=$AA$13),H46,\"\")","v":""},""]
["Culture, Heritage and Identity",30,null,1,null,null,1,null,null,null,{"$f":"IF(OR(M47=$AA$12,M47=$AA$13),H47,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G44:G47)","v":8},{"$f":"SUM(H44:H47)","v":0},null,null,{"$f":"SUM(K44:K47)","v":0},{"$f":"SUM(L44:L47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG48,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH48,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH48,0)","v":{"$error":"#REF!"}}]
["People"]
["Inclusive Construction Practices",31,"•",1,null,null,1,null,null,null,{"$f":"IF(OR(M50=$AA$12,M50=$AA$13),H50,\"\")","v":""},""]
["Indigenous Inclusion",32,null,1,1,null,2,null,null,null,{"$f":"IF(OR(M51=$AA$12,M51=$AA$13),H51,\"\")","v":""},""]
["Procurement and Workforce Inclusion",33,null,2,1,null,3,null,null,null,{"$f":"IF(OR(M52=$AA$12,M52=$AA$13),H52,\"\")","v":""},""]
["Design for Inclusion",34,null,2,1,null,3,null,null,null,{"$f":"IF(OR(M53=$AA$12,M53=$AA$13),H53,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G50:G53)","v":9},{"$f":"SUM(H50:H53)","v":0},null,null,{"$f":"SUM(K50:K53)","v":0},{"$f":"SUM(L50:L53)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG54,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH54,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH54,0)","v":{"$error":"#REF!"}}]
["Nature",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M55=$AA$12,M55=$AA$13),H55,\"\")","v":""},{"$f":"IF(OR(N55=$AA$12,N55=$AA$13),I55,\"\")","v":""},{"$f":"IF(OR(O55=$AA$12,O55=$AA$13),J55,\"\")","v":""},"","","",{"$f":"IF(OR(V55=$AA$12,V55=$AA$13),N55,\"\")","v":""},{"$f":"IF(OR(W55=$AA$12,W55=$AA$13),O55,\"\")","v":""}]
["Impacts to Nature",35,"•",2,null,null,2,null,null,null,{"$f":"IF(OR(M56=$AA$12,M56=$AA$13),H56,\"\")","v":""},""]
["Biodiversity Enhancement",36,null,2,2,null,4,null,null,null,{"$f":"IF(OR(M57=$AA$12,M57=$AA$13),H57,\"\")","v":""},""]
["Nature Connectivity",37,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M58=$AA$12,M58=$AA$13),H58,\"\")","v":""},""]
["Nature Stewardship",38,null,2,null,null,2,null,null,null,{"$f":"IF(OR(M59=$AA$12,M59=$AA$13),H59,\"\")","v":""},""]
["Waterway Protection",39,null,2,2,null,4,null,null,null,{"$f":"IF(OR(M60=$AA$12,M60=$AA$13),H60,\"\")","v":""},""]
["Total",null,null,null,null,null,{"$f":"SUM(G56:G60)","v":14},{"$f":"SUM(H56:H60)","v":0},null,null,{"$f":"SUM(K56:K60)","v":0},{"$f":"SUM(L56:L60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG61,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH61,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH61,0)","v":{"$error":"#REF!"}}]
["Leadership",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M62=$AA$12,M62=$AA$13),H62,\"\")","v":""},{"$f":"IF(OR(N62=$AA$12,N62=$AA$13),I62,\"\")","v":""},{"$f":"IF(OR(O62=$AA$12,O62=$AA$13),J62,\"\")","v":""},"","","",{"$f":"IF(OR(V62=$AA$12,V62=$AA$13),N62,\"\")","v":""},""]
["Market Transformation",40,null,null,null,null,5,null,null,null,{"$f":"IF(OR(M63=$AA$12,M63=$AA$13),H63,\"\")","v":""},""]
["Leadership Challenges",41,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M64=$AA$12,M64=$AA$13),H64,\"\")","v":""}]
["Total",null,null,null,null,null,null,{"$f":"SUM(H63:H64)","v":0},null,null,{"$f":"SUM(K63:K64)","v":0},{"$f":"SUM(L63:L64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,0,1)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,1,\"-\")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=TRUE,AG65,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(#REF!=$AA$12,#REF!=$AA$13),AH65,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$AA$14,AH65,0)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"TOTALS",null,"AVAILABLE","TARGETED",null,null,"AWARDED","TBC"]
[null,null,null,null,"CORE POINTS",null,{"$f":"SUM(G19+G27+G33+G42+G48+G54+G61)","v":100},{"$f":"SUM(H19+H27+H33+H42+H48+H54+H61)","v":0},null,null,{"$f":"SUM(K19+K27+K33+K42+K48+K54+K61+K65)","v":0},{"$f":"SUM(L19+L27+L33+L42+L48+L54+L61+L65)","v":0}]
[null,null,null,null,"LEADERSHIP POINTS",null,null,{"$f":"H65","v":0}]
[null,null,null,null,"TOTAL SCORE TARGETED",null,null,{"$f":"H68+H69","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Outcome Count"]
[null,null,null,null,null,null,null,null,null,null,null,"Core",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stage 1",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stage 2",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stage 3",{"$f":"COUNTIF(M10:M65,\"Not Awarded - Major Non-compliance\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M10:M65,\"Awarded - Compliant\")+COUNTIF(M10:M65,\"Awarded - Minor non-Compliance\")+COUNTIF(M10:M65,\"Not Awarded - Major non-compliance\")","v":0}]

{"sheet":"Submission Planner","index":5,"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":6,"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"}]