{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover Note","PSF 9a","PSF 9b ","PSF 9c","PSF 9d","PSF 9e","PSG 2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":112,"comments":5,"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":"Cover Note","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[11,1,11,3],[10,1,10,4],[15,1,15,4],[43,1,43,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[33,1,33,4],[36,1,36,4],[31,1,31,4],[45,1,45,4]]}
[]
[null,null,null,null,"PSF 9a,b,c,d,e"]
[]
[]
[]
[]
[null,"Performance Evaluation Forms"]
[]
[1,"Completing Performance Evaluations"]
[]
[1.1000000000000001,"This spreadsheet provides the forms and background information for the provision of performance evaluations in compliance with the NZTA's Performance Assessment by Co-ordinated Evaluation (PACE).  For details on the minimum standard requirements refer Z/11 (linked below):"]
[null,"Professional Services Minimum Standard - Z/11 Performance Evaluation"]
[]
[2,"PACE Objectives"]
[]
[2.1,"Performance Assessment by Coordinated Evaluations (PACE) has three objectives: "]
[null,"• To provide a means of systematically monitoring performance of our suppliers;"]
[null,"• To enable continuous dialogue with suppliers to encourage high levels of performance by challenging them to meet the key objectives; and"]
[null,"• To provide an historical database to assist in track record assessment in future tender evaluations."]
[]
[]
[3,"Using this Performance Evaluation Spreadsheet"]
[]
[3.1,"Select the correct marking sheet: "]
[]
[null,"Performance Evaluation of Capital Consultant","PSF 9a"]
[null,"Performance Evaluation of Capital Contractors","PSF 9b"]
[null,"Performance Evaluation of Maintenance Contractors1","PSF 9c"]
[null,"Performance Evaluation of Maintenance Consultant","PSF 9d"]
[null,"Performance Evaluation of Non-Engineering Consultant","PSF 9e"]
[]
[3.2,"Consider the suppliers performance for the period / contract being evaluated and provisionally assign ratings."]
[]
[3.3,"In, ideally, a face to face meeting, discuss the suppliers performance and finalise the ratings for each criteria on the marking sheet, including comments as necessary noting:"]
[null,"• Green fields are mandatory"]
[null,"• Yellow fields are optional"]
[null,"• Hover over the criteria for more information on what to consider or refer to the guidance notes (\"guidelines\" tab of this spreadsheet)"]
[]
[3.4,"Once the evaluation is complete. Obtain required signatures and load into the PACE database."]
[]
[]
[4,"Rating Examples (PSG 2)"]
[]
[4.0999999999999996,"The \"Performance Evaluation Examples\" (PSG 2) tab includes more information on each of the criteria, and some examples of the rating scale that may be adopted relative to each of the criteria."]
[]
["Note: 1) ","If there are additional works to a maintenance contract, the project manager will need to decide whether the PACE evaluation should be carried out under the current contract or to set up a new contract for the new works under Capital or Maintenance with the appropriate PACE form be used.   "]

{"sheet":"PSF 9a","index":1,"n_rows":73,"n_cols":26,"rows_kept":73,"cut":false,"hidden":false,"merged":[[38,0,38,1],[31,0,31,1],[33,0,33,1],[35,0,35,1],[36,0,36,1],[34,0,34,1],[32,0,32,1],[10,1,10,11],[11,1,11,6],[12,1,12,6],[13,1,13,6],[28,0,28,1],[22,0,22,1],[16,1,16,6],[20,0,21,1],[23,0,23,1],[24,0,24,1],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,1,14,6],[15,1,15,6],[48,0,48,2],[45,5,60,11],[44,5,44,11],[20,11,21,11],[20,9,21,10],[39,9,39,10],[39,6,39,8],[22,3,22,4],[41,9,41,10],[41,6,41,8],[30,0,30,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[29,0,29,1],[37,0,37,1]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PSF 9a"]
[]
[]
[]
[]
[]
["Performance Evaluation of Capital Consultant",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden Cells"]
[]
["Contract Title:"]
["Contract Number:",null,null,null,null,null,null,"Appraisal Date:"]
["Contract Value:",null,null,null,null,null,null,"Region Office:",null,null,null,null,"▼"]
["Consultant: ",null,null,null,null,null,null,"Appraisal by:"]
["Consultant's Manager:"]
["Work Activity:",null,null,null,null,null,null,"▼",null,null,null,"= Mandatory Field"]
["Evaluation Status:",null,null,null,null,null,null,"▼",null,null,null,"= Optional Field"]
[null,null,null,null,null,null,null,null,null,null,"▼","= Drop down menu available in green box"]
[]
[]
["Criteria",null,null,null,null,null,null,null,null,"Rating",null,"Comments",null,null,"Maximum Rating",null,null,"Grades","Grades","Grades","Work Activity","Regional Office","Interim or Final",null,"Check if Spreadsheet has been entered"]
[null,null,"Weakness",null,null,null,null,null,"Strength",null,null,null,null,null,"depens of No of N/As",null,null,null,null,null,null,null,null,null,"If not, Cells will be left blank"]
["Management (30%)"]
["Competency",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J24=\"n/a\",I24,\"\")","v":""},null,null,"N/A","N/A","N/A","Strategy Study","Auckland","Interim",null,{"$f":"IF(J24=\"\",\"\", J24)","v":""},{"$f":"IF(Y24=\"\",1000,Y24)","v":1000}]
["Creating \"No Surprises\" Environment",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J25=\"n/a\",I25,\"\")","v":""},null,null,0,0,0,"I&R","Christchurch","Final",null,"",{"$f":"IF(Y25=\"\",1000,Y25)","v":1000}]
["Creating Innovation",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J26=\"n/a\",I26,\"\")","v":""},null,null,1,2,3,"Design","Dunedin",null,null,"",{"$f":"IF(Y26=\"\",1000,Y26)","v":1000}]
["Proactiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J27=\"n/a\",I27,\"\")","v":""},null,null,2,4,6,"Design and Construct MSQA","Hamilton",null,null,"",{"$f":"IF(Y27=\"\",1000,Y27)","v":1000}]
["Responsiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J28=\"n/a\",I28,\"\")","v":""},null,null,3,6,9,"Project Management","Napier",null,null,"",{"$f":"IF(Y28=\"\",1000,Y28)","v":1000}]
["Production (40%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,8,12,"ECI","Tauranga"]
["Timely Outputs",null,"N/A",0,3,6,9,12,15,null,"▼",null,null,null,"",null,null,5,10,15,"Alliance","Wellington",null,null,"",{"$f":"IF(Y30=\"\",1000,Y30)","v":1000}]
["Accurate Outputs to Required Standard",null,"N/A",0,3,6,9,12,15,null,"▼",null,null,null,"",null,null,null,null,null,null,"Whanganui",null,null,"",{"$f":"IF(Y31=\"\",1000,Y31)","v":1000}]
["Defect Management System",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J32=\"n/a\",I32,\"\")","v":""},null,null,null,null,null,null,null,null,null,"",{"$f":"IF(Y32=\"\",1000,Y32)","v":1000}]
["Health and Safety (5%)"]
["Safe Work Practices",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J34=\"\",\"\", J34)","v":""},{"$f":"IF(Y34=\"\",1000,Y34)","v":1000}]
["Administration (25%)"]
["QA Documentation",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J36=\"\",\"\", J36)","v":""},{"$f":"IF(Y36=\"\",1000,Y36)","v":1000}]
["Monthly Report",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J37=\"\",\"\", J37)","v":""},{"$f":"IF(Y37=\"\",1000,Y37)","v":1000}]
["Financial",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J38=\"\",\"\", J38)","v":""},{"$f":"IF(Y38=\"\",1000,Y38)","v":1000}]
["Handling of Variations",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(J39=\"\",\"\", J39)","v":""},{"$f":"IF(Y39=\"\",1000,Y39)","v":1000}]
[null,null,null,null,null,null,"Total",null,null,{"$f":"Y40","v":""},null,null,null,null,{"$f":"100-SUM($O24:$O39)","v":100},"Maximum Rating",null,null,null,null,null,null,null,null,{"$f":"IF(Z40=13000,\"\", SUM(Y24:Y39))","v":""},{"$f":"SUM(Z24:Z39)","v":13000}]
["Total Score",null,{"$f":"(J29+J33+J35+J40)/O40","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z41=12000,\"\", SUM(Y24:Y39))","v":0},{"$f":"SUM(Z24:Z39)","v":13000}]
[null,null,null,null,null,null,"Out of",null,null,{"$f":"IF(J40=\"\",\"\",100-SUM($O24:$O39))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J40/J42","v":{"$error":"#VALUE!"}}]
["Overall % Ratings",null,null,null,null,"Overall Comment  (Mandatory for all Final Evaluations and if an Interim Evaluation's Overall Rating is < 50% or > 70%)"]
[]
["Overall Rating",null,null,{"$f":"IF(J42=\"\",\"\",+C41)","v":""}]
[]
[]
["Unsatisfactory",null,"≤35%",{"$f":"+IF(S50=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"≤35%",{"$f":"+D47<35.5%","v":false}]
[]
["Needs Improvement",null,"36-49%",{"$f":"+IF(S52=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"36-49%",{"$f":"AND(D47>=35.5%,D47<49.5%)","v":false}]
[]
["Acceptable",null,"50-59%",{"$f":"+IF(S54=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"50-59%",{"$f":"AND(D47>=49.5%,D47<59.5%)","v":false}]
[]
["Requirements fully met",null,"60-70%",{"$f":"+IF(S56=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"60-70%",{"$f":"AND(D47>=59.5%,D47<70.5%)","v":false}]
[]
["Exceeds Requirements",null,"71-85%",{"$f":"+IF(S58=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"71-85%",{"$f":"AND(D47>=70.5%,D47<85.5%)","v":false}]
[]
["Superlative",null,"86-100%",{"$f":"+IF(S60=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"86-100%",{"$f":"AND(D47>=85.5%,D47<=100%)","v":false}]
[]
["Signatures"]
[]
[]
[]
[]
["NZTA Representative",null,null,null,null,"Consultant's Representative"]
[]
[]
[]
[]
[]
["NZTA PMSM (Mandatory for Final Evaluations)"]

{"sheet":"PSF 9b ","index":2,"n_rows":71,"n_cols":26,"rows_kept":71,"cut":false,"hidden":false,"merged":[[14,1,14,6],[15,1,15,6],[16,1,16,6],[20,0,21,1],[25,0,25,1],[23,0,23,1],[22,3,22,4],[43,5,58,11],[42,5,42,11],[30,0,30,1],[33,0,33,1],[36,0,36,1],[31,0,31,1],[32,0,32,1],[34,0,34,1],[39,9,39,10],[46,0,46,2],[35,0,35,1],[37,9,37,10],[37,6,37,8],[10,1,10,11],[11,1,11,6],[12,1,12,6],[13,1,13,6],[39,6,39,8],[11,10,11,11],[12,10,12,11],[13,10,13,11],[20,11,21,11],[20,9,21,10],[27,0,27,1],[28,0,28,1],[29,0,29,1],[22,0,22,1],[26,0,26,1],[24,0,24,1]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PSF 9b"]
[]
[]
[]
[]
[]
["Performance Evaluation of Capital Contractors",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden Cells"]
[]
["Contract Title:"]
["Contract Number:",null,null,null,null,null,null,"Appraisal Date:"]
["Contract Value:",null,null,null,null,null,null,"Region Office:",null,null,null,null,"▼"]
["Contractor: ",null,null,null,null,null,null,"Appraisal by:"]
["Contractor's Manager:"]
["Work Activity:",null,null,null,null,null,null,"▼",null,null,null,"= Mandatory Field"]
["Evaluation Status:",null,null,null,null,null,null,"▼",null,null,null,"= Optional Field"]
[null,null,null,null,null,null,null,null,null,null,"▼","= Drop down menu available in green box"]
[]
[]
["Criteria",null,null,null,null,null,null,null,null,"Rating",null,"Comments",null,null,"Maximum Rating",null,null,"Grades","Grades","Grades","Work Activity","Regional Office","Interim or Final",null,"Check if Spreadsheet has been entered"]
[null,null,"Weakness",null,null,null,null,null,"Strength",null,null,null,null,null,"depens of No of N/As",null,null,null,null,null,null,null,null,null,"If not, Cells will be left blank"]
["Management (25%)"]
["Skill Level and Competency",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J24=\"n/a\",I24,\"\")","v":""},null,null,"N/A","N/A","N/A","Design & Construct","Auckland","Interim",null,{"$f":"IF(J24=\"\",\"\", J24)","v":""},{"$f":"IF(Y24=\"\",1000,Y24)","v":1000}]
["Risk Management",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J25=\"n/a\",I25,\"\")","v":""},null,null,0,0,0,"Intelligent Traffic Systems","Christchurch","Final",null,{"$f":"IF(J25=\"\",\"\", J25)","v":""},{"$f":"IF(Y25=\"\",1000,Y25)","v":1000}]
["Responsiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J26=\"n/a\",I26,\"\")","v":""},null,null,1,2,3,"ECI","Dunedin",null,null,{"$f":"IF(J26=\"\",\"\", J26)","v":""},{"$f":"IF(Y26=\"\",1000,Y26)","v":1000}]
["Production (40%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,6,"Alliance","Hamilton"]
["Ability to Meet Programme",null,"N/A",0,3,6,9,12,15,null,"▼",null,null,null,{"$f":"IF(J28=\"n/a\",I28,\"\")","v":""},null,null,3,6,9,"Minor Works","Napier",null,null,{"$f":"IF(J28=\"\",\"\", J28)","v":""},{"$f":"IF(Y28=\"\",1000,Y28)","v":1000}]
["Achieves the Specified Standard",null,"N/A",0,3,6,9,12,15,null,"▼",null,null,null,{"$f":"IF(J29=\"n/a\",I29,\"\")","v":""},null,null,4,8,12,"New Road (minor structures)","Tauranga",null,null,{"$f":"IF(J29=\"\",\"\", J29)","v":""},{"$f":"IF(Y29=\"\",1000,Y29)","v":1000}]
["Defect Management System",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J30=\"n/a\",I30,\"\")","v":""},null,null,5,10,15,"New Road (major structures)","Wellington",null,null,{"$f":"IF(J30=\"\",\"\", J30)","v":""},{"$f":"IF(Y30=\"\",1000,Y30)","v":1000}]
["Health and Safety (20%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Realignment","Whanganui"]
["Safe Work Practices",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J32=\"n/a\",I32,\"\")","v":""},null,null,null,null,null,"Resealing and Resurfacing",null,null,null,{"$f":"IF(J32=\"\",\"\", J32)","v":""},{"$f":"IF(Y32=\"\",1000,Y32)","v":1000}]
["Traffic Management Control",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J33=\"n/a\",I33,\"\")","v":""},null,null,null,null,null,"Rural Rehabilitation",null,null,null,{"$f":"IF(J33=\"\",\"\", J33)","v":""},{"$f":"IF(Y33=\"\",1000,Y33)","v":1000}]
["Administration (15%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specialist Applications "]
["QA Documentation",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J35=\"n/a\",I35,\"\")","v":""},null,null,null,null,null,"Structure",null,null,null,{"$f":"IF(J35=\"\",\"\", J35)","v":""},{"$f":"IF(Y35=\"\",1000,Y35)","v":1000}]
["Financial",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J36=\"n/a\",I36,\"\")","v":""},null,null,null,null,null,"Urban Rehabilitation",null,null,null,{"$f":"IF(J36=\"\",\"\", J36)","v":""},{"$f":"IF(Y36=\"\",1000,Y36)","v":1000}]
["Handling of Variations",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J37=\"n/a\",I37,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J37=\"\",\"\", J37)","v":""},{"$f":"IF(Y37=\"\",1000,Y37)","v":1000}]
[null,null,null,null,null,null,"Total",null,null,{"$f":"Y38","v":""},null,null,null,null,{"$f":"100-SUM($O24:$O37)","v":100},"Maximum Rating",null,null,null,null,null,null,null,null,{"$f":"IF(Z38=11000,\"\", SUM(Y24:Y37))","v":""},{"$f":"SUM(Z24:Z37)","v":11000}]
["Total Score",null,{"$f":"(J27+J31+J34+J38)/O38","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Out of",null,null,{"$f":"IF(J38=\"\",\"\",100-SUM($O24:$O37))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J38/J40","v":{"$error":"#VALUE!"}}]
["Overall % Ratings",null,null,null,null,"Overall Comment  (Mandatory for all Final Evaluations and if an Interim Evaluation's Overall Rating is < 50% or > 70%)"]
[]
["Overall Rating",null,null,{"$f":"IF(J40=\"\",\"\",+C39)","v":""}]
[]
[]
["Unsatisfactory",null,"≤35%",{"$f":"+IF(S48=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"≤35%",{"$f":"+D45<35.5%","v":false}]
[]
["Needs Improvement",null,"36-49%",{"$f":"+IF(S50=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"36-49%",{"$f":"AND(D45>=35.5%,D45<49.5%)","v":false}]
[]
["Acceptable",null,"50-59%",{"$f":"+IF(S52=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"50-59%",{"$f":"AND(D45>=49.5%,D45<59.5%)","v":false}]
[]
["Requirements fully met",null,"60-70%",{"$f":"+IF(S54=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"60-70%",{"$f":"AND(D45>=59.5%,D45<70.5%)","v":false}]
[]
["Exceeds Requirements",null,"71-85%",{"$f":"+IF(S56=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"71-85%",{"$f":"AND(D45>=70.5%,D45<85.5%)","v":false}]
[]
["Superlative",null,"86-100%",{"$f":"+IF(S58=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"86-100%",{"$f":"AND(D45>=85.5%,D45<=100%)","v":false}]
[]
["Signatures"]
[]
[]
[]
[]
["Consultant's Representative",null,null,null,null,"Contractor's Representative"]
[]
[]
[]
[]
[]
["NZTA Representative",null,null,null,null,"NZTA PMSM (Mandatory for Final Evaluations)"]

{"sheet":"PSF 9c","index":3,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":false,"merged":[[40,0,40,1],[38,0,38,1],[39,0,39,1],[37,0,37,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[35,0,35,1],[34,0,34,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[22,0,22,1],[36,0,36,1],[15,1,15,6],[16,1,16,6],[10,1,10,11],[11,1,11,6],[12,1,12,6],[13,1,13,6],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,1,14,6],[50,0,50,2],[47,5,62,11],[46,5,46,11],[20,11,21,11],[20,9,21,10],[41,9,41,10],[41,6,41,8],[22,3,22,4],[43,9,43,10],[43,6,43,8],[26,0,26,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[27,0,27,1],[20,0,21,1]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PSF 9c"]
[]
[]
[]
[]
[]
["Performance Evaluation of Maintenance Contractors",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden Cells"]
[]
["Contract Title:"]
["Contract Number:",null,null,null,null,null,null,"Appraisal Date:"]
["Contract Value:",null,null,null,null,null,null,"Region Office:",null,null,null,null,"▼"]
["Contractor: ",null,null,null,null,null,null,"Appraisal by:"]
["Contractor's Manager:"]
["Work Activity:",null,null,null,null,null,null,"▼",null,null,null,"= Mandatory Field"]
["Evaluation Status:",null,null,null,null,null,null,"▼",null,null,null,"= Optional Field"]
[null,null,null,null,null,null,null,null,null,null,"▼","= Drop down menu available in green box"]
[]
[]
["Criteria",null,null,null,null,null,null,null,null,"Rating",null,"Comments",null,null,"Maximum Rating",null,null,"Grades","Grades","Grades","Work Activity","Regional Office","Interim or Final",null,"Check if Spreadsheet has been entered"]
[null,null,"Weakness",null,null,null,null,null,"Strength",null,null,null,null,null,"depends of No of N/As",null,null,null,null,null,null,null,null,null,"If not, Cells will be left blank"]
["Management (20%)"]
["Skill Level and Competency",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J24=\"n/a\",I24,\"\")","v":""},null,null,"N/A","N/A","N/A","Highway Maintenance","Auckland","Interim",null,{"$f":"IF(J24=\"\",\"\", J24)","v":""},{"$f":"IF(Y24=\"\",1000,Y24)","v":1000}]
["Risk Management",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J25=\"n/a\",I25,\"\")","v":""},null,null,0,0,0,"Resurfacing","Christchurch","Final",null,{"$f":"IF(J25=\"\",\"\", J25)","v":""},{"$f":"IF(Y25=\"\",1000,Y25)","v":1000}]
["Responsiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J26=\"n/a\",I26,\"\")","v":""},null,null,1,2,3,"Traffic Services","Dunedin","Contract Extension",null,{"$f":"IF(J26=\"\",\"\", J26)","v":""},{"$f":"IF(Y26=\"\",1000,Y26)","v":1000}]
["Quality Assurance",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J27=\"n/a\",I27,\"\")","v":""},null,null,2,4,6,"Vegetation Control","Hamilton",null,null,{"$f":"IF(J27=\"\",\"\", J27)","v":""},{"$f":"IF(Y27=\"\",1000,Y27)","v":1000}]
["Production (45%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6,9,"Pavement Marking","Napier"]
["Contractors Programmes",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J29=\"n/a\",I29,\"\")","v":""},null,null,4,8,12,"Highway Lighting","Tauranga",null,null,{"$f":"IF(J29=\"\",\"\", J29)","v":""},{"$f":"IF(Y29=\"\",1000,Y29)","v":1000}]
["Ability to Meet Programme",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,5,10,15,"Traffic Signals","Wellington",null,null,"",1000]
["Achieves the Specified Standard",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,"",null,null,null,null,null,"Bridge Maintenance ","Whanganui",null,null,"",1000]
["Defect Management System",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,"",null,null,null,null,null,"Minor Works",null,null,null,"",1000]
["Achievement",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,"",null,null,null,null,null,"PSMC",null,null,null,"",1000]
["Network Condition",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,null,null,null,"Hybrid",null,null,null,"",1000]
["Health and Safety (20%)"]
["Safe Work Practices",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J36=\"n/a\",I36,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J36=\"\",\"\", J36)","v":""},{"$f":"IF(Y36=\"\",1000,Y36)","v":1000}]
["Traffic Management Control",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J37=\"n/a\",I37,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J37=\"\",\"\", J37)","v":""},{"$f":"IF(Y37=\"\",1000,Y37)","v":1000}]
["Administration (15%)"]
["Financial",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J39=\"n/a\",I39,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J39=\"\",\"\", J39)","v":""},{"$f":"IF(Y39=\"\",1000,Y39)","v":1000}]
["Handling of Variations",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J40=\"n/a\",I40,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J40=\"\",\"\", J40)","v":""},{"$f":"IF(Y40=\"\",1000,Y40)","v":1000}]
["Reporting",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J41=\"n/a\",I41,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J41=\"\",\"\", J41)","v":""},{"$f":"IF(Y41=\"\",1000,Y41)","v":1000}]
[null,null,null,null,null,null,"Total",null,null,{"$f":"Y42","v":""},null,null,null,null,{"$f":"100-SUM($O24:$O41)","v":100},"Maximum Rating",null,null,null,null,null,null,null,null,{"$f":"IF(Z42=15000,\"\", SUM(Y24:Y41))","v":""},{"$f":"SUM(Z24:Z41)","v":15000}]
["Total Score",null,{"$f":"(J28+J35+J38+J42)/O42","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Out of",null,null,{"$f":"IF(J42=\"\",\"\",100-SUM($O24:$O41))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J42/J44","v":{"$error":"#VALUE!"}}]
["Overall % Ratings",null,null,null,null,"Overall Comment  (Mandatory for all Final and Contract Extension Evaluations and if an Interim Evaluation's Overall Rating is < 50% or > 70%)"]
[]
["Overall Rating",null,null,{"$f":"IF(J44=\"\",\"\",+C43)","v":""}]
[]
[]
["Unsatisfactory",null,"≤35%",{"$f":"+IF(S52=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"≤35%",{"$f":"+D49<35.5%","v":false}]
[]
["Needs Improvement",null,"36-49%",{"$f":"+IF(S54=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"36-49%",{"$f":"AND(D49>=35.5%,D49<49.5%)","v":false}]
[]
["Acceptable",null,"50-59%",{"$f":"+IF(S56=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"50-59%",{"$f":"AND(D49>=49.5%,D49<59.5%)","v":false}]
[]
["Requirements fully met",null,"60-70%",{"$f":"+IF(S58=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"60-70%",{"$f":"AND(D49>=59.5%,D49<70.5%)","v":false}]
[]
["Exceeds Requirements",null,"71-85%",{"$f":"+IF(S60=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"71-85%",{"$f":"AND(D49>=70.5%,D49<85.5%)","v":false}]
[]
["Superlative",null,"86-100%",{"$f":"+IF(S62=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"86-100%",{"$f":"AND(D49>=85.5%,D49<=100%)","v":false}]
[]
["Signatures"]
[]
[]
[]
[]
["Consultant's Representative",null,null,null,null,"Contractor's Representative"]
[]
[]
[]
[]
[]
["NZTA Representative",null,null,null,null,"NZTA PAM (Mandatory for Final Evaluations)"]

{"sheet":"PSF 9d","index":4,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":false,"merged":[[23,0,23,1],[28,0,28,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[37,0,37,1],[27,0,27,1],[33,0,33,1],[36,0,36,1],[32,0,32,1],[34,0,34,1],[35,0,35,1],[30,0,30,1],[31,0,31,1],[29,0,29,1],[50,0,50,2],[47,5,62,11],[46,5,46,11],[43,9,43,10],[43,6,43,8],[10,1,10,11],[22,3,22,4],[11,10,11,11],[12,10,12,11],[13,10,13,11],[20,11,21,11],[20,9,21,10],[20,0,21,1],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[22,0,22,1],[41,9,41,10],[41,6,41,8],[38,0,38,1],[39,0,39,1],[40,0,40,1]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PSF 9d"]
[]
[]
[]
[]
[]
["Performance Evaluation of Maintenance Consultant",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden Cells"]
[]
["Contract Title:"]
["Contract Number:",null,null,null,null,null,null,"Appraisal Date:"]
["Contract Value:",null,null,null,null,null,null,"Region Office:",null,null,null,null,"▼"]
["Contractor: ",null,null,null,null,null,null,"Appraisal by:"]
["Contractor's Manager:"]
["Work Activity:",null,null,null,null,null,null,"▼",null,null,null,"= Mandatory Field"]
["Evaluation Status:",null,null,null,null,null,null,"▼",null,null,null,"= Optional Field"]
[null,null,null,null,null,null,null,null,null,null,"▼","= Drop down menu available in green box"]
[]
[]
["Criteria",null,null,null,null,null,null,null,null,"Rating",null,"Comments",null,null,"Maximum Rating",null,null,"Grades","Grades","Grades","Work Activity","Regional Office","Interim or Final",null,"Check if Spreadsheet has been entered"]
[null,null,"Weakness",null,null,null,null,null,"Strength",null,null,null,null,null,"depens of No of N/As",null,null,null,null,null,null,null,null,null,"If not, Cells will be left blank"]
["Management (40%)"]
["Competency",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J24=\"n/a\",I24,\"\")","v":""},null,null,"N/A","N/A","N/A","Traditional ","Auckland","Interim",null,{"$f":"IF(J24=\"\",\"\", J24)","v":""},{"$f":"IF(Y24=\"\",1000,Y24)","v":1000}]
["Creating \"No Surprises\" Environment",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,"",null,null,0,0,0,"Hybrid","Christchurch","Final",null,"",1000]
["Creating Innovation",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,1,2,3,"PSMC","Dunedin","Contract Extension",null,"",1000]
["Proactiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,2,4,6,"Bridge Management","Hamilton",null,null,"",1000]
["Responsiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,3,6,9,null,"Napier",null,null,"",1000]
["Managing the Network",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,"",null,null,4,8,12,null,"Tauranga",null,null,"",1000]
["Production (25%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,10,15,null,"Wellington"]
["Timely Outputs",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J31=\"n/a\",I31,\"\")","v":""},null,null,null,null,null,null,"Whanganui",null,null,{"$f":"IF(J31=\"\",\"\", J31)","v":""},{"$f":"IF(Y31=\"\",1000,Y31)","v":1000}]
["Accurate Outputs to Required Standard",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J32=\"n/a\",I32,\"\")","v":""},null,null,null,null,null,null,"Whanganui",null,null,{"$f":"IF(J32=\"\",\"\", J32)","v":""},{"$f":"IF(Y32=\"\",1000,Y32)","v":1000}]
["Defect Management System",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J33=\"n/a\",I33,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J33=\"\",\"\", J33)","v":""},{"$f":"IF(Y33=\"\",1000,Y33)","v":1000}]
["Health and Safety (10%)"]
["Safe Work Practices",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J35=\"n/a\",I35,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J35=\"\",\"\", J35)","v":""},{"$f":"IF(Y35=\"\",1000,Y35)","v":1000}]
["Safety Performance Measures",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J36=\"n/a\",I36,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J36=\"\",\"\", J36)","v":""},{"$f":"IF(Y36=\"\",1000,Y36)","v":1000}]
["Administration (25%)"]
["QA Documentation",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J38=\"n/a\",I38,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J38=\"\",\"\", J38)","v":""},{"$f":"IF(Y38=\"\",1000,Y38)","v":1000}]
["Monthly Report",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J39=\"n/a\",I39,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J39=\"\",\"\", J39)","v":""},{"$f":"IF(Y39=\"\",1000,Y39)","v":1000}]
["Financial",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J40=\"n/a\",I40,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J40=\"\",\"\", J40)","v":""},{"$f":"IF(Y40=\"\",1000,Y40)","v":1000}]
["Handling of Variations",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J41=\"n/a\",I41,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J41=\"\",\"\", J41)","v":""},{"$f":"IF(Y41=\"\",1000,Y41)","v":1000}]
[null,null,null,null,null,null,"Total",null,null,{"$f":"Y42","v":""},null,null,null,null,{"$f":"100-SUM($O24:$O41)","v":100},"Maximum Rating",null,null,null,null,null,null,null,null,{"$f":"IF(Z42=15000,\"\", SUM(Y24:Y41))","v":""},{"$f":"SUM(Z24:Z41)","v":15000}]
["Total Score",null,{"$f":"(J30+J34+J37+J42)/O42","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z43=12000,\"\", SUM(Y24:Y41))","v":0},{"$f":"SUM(Z24:Z41)","v":15000}]
[null,null,null,null,null,null,"Out of",null,null,{"$f":"IF(J42=\"\",\"\",100-SUM($O24:$O41))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J42/J44","v":{"$error":"#VALUE!"}}]
["Overall % Ratings",null,null,null,null,"Overall Comment  (Mandatory for all Final and Contract Extension Evaluations and if an Interim Evaluation's Overall Rating is < 50% or > 70%)"]
[]
["Overall Rating",null,null,{"$f":"IF(J44=\"\",\"\",+C43)","v":""}]
[]
[]
["Unsatisfactory",null,"≤35%",{"$f":"+IF(S52=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"≤35%",{"$f":"+D49<35.5%","v":false}]
[]
["Needs Improvement",null,"36-49%",{"$f":"+IF(S54=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"36-49%",{"$f":"AND(D49>=35.5%,D49<49.5%)","v":false}]
[]
["Acceptable",null,"50-59%",{"$f":"+IF(S56=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"50-59%",{"$f":"AND(D49>=49.5%,D49<59.5%)","v":false}]
[]
["Requirements fully met",null,"60-70%",{"$f":"+IF(S58=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"60-70%",{"$f":"AND(D49>=59.5%,D49<70.5%)","v":false}]
[]
["Exceeds Requirements",null,"71-85%",{"$f":"+IF(S60=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"71-85%",{"$f":"AND(D49>=70.5%,D49<85.5%)","v":false}]
[]
["Superlative",null,"86-100%",{"$f":"+IF(S62=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"86-100%",{"$f":"AND(D49>=85.5%,D49<=100%)","v":false}]
[]
["Signatures"]
[]
[]
[]
[]
["NZTA Representative",null,null,null,null,"Consutlant's Representative"]
[]
[]
[]
[]
[]
["NZTA PAM (Mandatory for Final Evaluations)"]

{"sheet":"PSF 9e","index":5,"n_rows":73,"n_cols":26,"rows_kept":73,"cut":false,"hidden":false,"merged":[[22,3,22,4],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[48,0,48,2],[45,5,60,11],[44,5,44,11],[20,11,21,11],[20,9,21,10],[39,9,39,10],[39,6,39,8],[27,0,27,1],[29,0,29,1],[30,0,30,1],[26,0,26,1],[38,0,38,1],[34,0,34,1],[32,0,32,1],[28,0,28,1],[33,0,33,1],[11,10,11,11],[12,10,12,11],[13,10,13,11],[10,1,10,11],[41,9,41,10],[41,6,41,8],[31,0,31,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[22,0,22,1],[20,0,21,1],[11,1,11,6]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"PSF 9e"]
[]
[]
[]
[]
[]
["Performance Evaluation of Non-Engineering Consultant",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hidden Cells"]
[]
["Contract Title:"]
["Contract Number:",null,null,null,null,null,null,"Appraisal Date:"]
["Contract Value:",null,null,null,null,null,null,"Region Office:",null,null,null,null,"▼"]
["Contractor: ",null,null,null,null,null,null,"Appraisal by:"]
["Contractor's Manager:"]
["Work Activity:",null,null,null,null,null,null,"▼",null,null,null,"= Mandatory Field"]
["Evaluation Status:",null,null,null,null,null,null,"▼",null,null,null,"= Optional Field"]
[null,null,null,null,null,null,null,null,null,null,"▼","= Drop down menu available in green box"]
[]
[]
["Criteria",null,null,null,null,null,null,null,null,"Rating",null,"Comments",null,null,"Maximum Rating",null,null,"Grades","Grades","Grades","Work Activity","Regional Office","Interim or Final",null,"Check if Spreadsheet has been entered"]
[null,null,"Weakness",null,null,null,null,null,"Strength",null,null,null,null,null,"depends of No of N/As",null,null,null,null,null,null,null,null,null,"If not, Cells will be left blank"]
["Management (30%)"]
["Competency",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J24=\"n/a\",I24,\"\")","v":""},null,null,"N/A","N/A","N/A","Property Acqusition","Auckland","Interim",null,{"$f":"IF(J24=\"\",\"\", J24)","v":""},{"$f":"IF(Y24=\"\",1000,Y24)","v":1000}]
["Creating \"No Surprises\" Environment",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J25=\"n/a\",I25,\"\")","v":""},null,null,0,0,0,"Property Disposal","Christchurch","Final",null,{"$f":"IF(J25=\"\",\"\", J25)","v":""},{"$f":"IF(Y25=\"\",1000,Y25)","v":1000}]
["Creating Innovation",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J26=\"n/a\",I26,\"\")","v":""},null,null,1,2,3,"Property Management","Dunedin","Contract Extension",null,{"$f":"IF(J26=\"\",\"\", J26)","v":""},{"$f":"IF(Y26=\"\",1000,Y26)","v":1000}]
["Proactiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J27=\"n/a\",I27,\"\")","v":""},null,null,2,4,6,null,"Hamilton",null,null,{"$f":"IF(J27=\"\",\"\", J27)","v":""},{"$f":"IF(Y27=\"\",1000,Y27)","v":1000}]
["Responsiveness",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J28=\"n/a\",I28,\"\")","v":""},null,null,3,6,9,null,"Napier",null,null,{"$f":"IF(J28=\"\",\"\", J28)","v":""},{"$f":"IF(Y28=\"\",1000,Y28)","v":1000}]
["Production (40%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,8,12,null,"Tauranga"]
["Timely Outputs",null,"N/A",0,3,6,9,12,15,null,"▼",null,null,null,{"$f":"IF(J30=\"n/a\",I30,\"\")","v":""},null,null,5,10,15,null,"Wellington",null,null,{"$f":"IF(J30=\"\",\"\", J30)","v":""},{"$f":"IF(Y30=\"\",1000,Y30)","v":1000}]
["Accurate Outputs to Required Standard",null,"N/A",0,3,6,9,12,15,null,"▼",null,null,null,{"$f":"IF(J31=\"n/a\",I31,\"\")","v":""},null,null,null,null,null,null,"Whanganui",null,null,{"$f":"IF(J31=\"\",\"\", J31)","v":""},{"$f":"IF(Y31=\"\",1000,Y31)","v":1000}]
["Defect Management System",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J32=\"n/a\",I32,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J32=\"\",\"\", J32)","v":""},{"$f":"IF(Y32=\"\",1000,Y32)","v":1000}]
["Health and Safety (5%)"]
["Safe Work Practices",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J34=\"n/a\",I34,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J34=\"\",\"\", J34)","v":""},{"$f":"IF(Y34=\"\",1000,Y34)","v":1000}]
["Administration (25%)"]
["QA Documentation",null,"N/A",0,2,4,6,8,10,null,"▼",null,null,null,{"$f":"IF(J36=\"n/a\",I36,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J36=\"\",\"\", J36)","v":""},{"$f":"IF(Y36=\"\",1000,Y36)","v":1000}]
["Monthly Report",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J37=\"n/a\",I37,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J37=\"\",\"\", J37)","v":""},{"$f":"IF(Y37=\"\",1000,Y37)","v":1000}]
["Financial",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J38=\"n/a\",I38,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J38=\"\",\"\", J38)","v":""},{"$f":"IF(Y38=\"\",1000,Y38)","v":1000}]
["Handling of Variations",null,"N/A",0,1,2,3,4,5,null,"▼",null,null,null,{"$f":"IF(J39=\"n/a\",I39,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(J39=\"\",\"\", J39)","v":""},{"$f":"IF(Y39=\"\",1000,Y39)","v":1000}]
[null,null,null,null,null,null,"Total",null,null,{"$f":"Y40","v":""},null,null,null,null,{"$f":"100-SUM($O24:$O39)","v":100},"Maximum Rating",null,null,null,null,null,null,null,null,{"$f":"IF(Z40=13000,\"\", SUM(Y24:Y39))","v":""},{"$f":"SUM(Z24:Z39)","v":13000}]
["Total Score",null,{"$f":"(J29+J33+J35+J40)/O40","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z41=12000,\"\", SUM(Y24:Y39))","v":0},{"$f":"SUM(Z24:Z39)","v":13000}]
[null,null,null,null,null,null,"Out of",null,null,{"$f":"IF(J40=\"\",\"\",100-SUM($O24:$O39))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J40/J42","v":{"$error":"#VALUE!"}}]
["Overall % Ratings",null,null,null,null,"Overall Comment  (Mandatory for all Final Evaluations and if an Interim Evaluation's Overall Rating is < 50% or > 70%)"]
[]
["Overall Rating",null,null,{"$f":"IF(J42=\"\",\"\",+C41)","v":""}]
[]
[]
["Unsatisfactory",null,"≤35%",{"$f":"+IF(S50=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"≤35%",{"$f":"+D47<35.5%","v":false}]
[]
["Needs Improvement",null,"36-49%",{"$f":"+IF(S52=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"36-49%",{"$f":"AND(D47>=35.5%,D47<49.5%)","v":false}]
[]
["Acceptable",null,"50-59%",{"$f":"+IF(S54=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"50-59%",{"$f":"AND(D47>=49.5%,D47<59.5%)","v":false}]
[]
["Requirements fully met",null,"60-70%",{"$f":"+IF(S56=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"60-70%",{"$f":"AND(D47>=59.5%,D47<70.5%)","v":false}]
[]
["Exceeds Requirements",null,"71-85%",{"$f":"+IF(S58=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"71-85%",{"$f":"AND(D47>=70.5%,D47<85.5%)","v":false}]
[]
["Superlative",null,"86-100%",{"$f":"+IF(S60=TRUE,\"X\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"86-100%",{"$f":"AND(D47>=85.5%,D47<=100%)","v":false}]
[]
["Signatures"]
[]
[]
[]
[]
["NZTA Representative",null,null,null,null,"Consutlant's Representative"]
[]
[]
[]
[]
[]
["The relevant NZTA 4th tier manager (Mandatory for Final Evaluations)"]

{"sheet":"PSG 2","index":6,"n_rows":177,"n_cols":10,"rows_kept":177,"cut":false,"hidden":false,"merged":[[167,7,169,7],[167,6,169,6],[167,5,169,5],[154,5,158,5],[161,7,166,7],[161,5,166,5],[154,6,158,6],[154,4,158,4],[145,4,148,4],[141,4,144,4],[141,5,144,5],[141,6,144,6],[13,1,14,1],[13,4,14,4],[13,5,14,5],[13,6,14,6],[154,7,158,7],[29,5,32,5],[15,4,26,4],[15,5,26,5],[174,9,177,9],[89,6,91,6],[89,7,91,7],[89,8,91,8],[89,9,91,9],[106,8,108,8],[141,7,144,7],[174,8,177,8],[134,8,140,8],[145,9,148,9],[174,4,177,4],[174,5,177,5],[174,6,177,6],[174,7,177,7],[145,7,148,7],[145,8,148,8],[161,6,166,6],[134,4,140,4],[145,6,148,6],[145,5,148,5],[6,6,8,6],[6,8,8,8],[6,7,8,7],[53,9,55,9],[58,8,65,8],[38,8,43,8],[15,2,15,3],[29,6,32,6],[29,7,32,7],[29,8,32,8],[23,2,23,3],[20,2,20,3],[29,4,32,4],[106,9,108,9],[77,8,84,8],[49,9,52,9],[53,8,55,8],[124,7,131,7],[121,7,123,7],[9,7,12,7],[58,9,65,9],[33,7,37,7],[85,9,88,9],[49,8,52,8],[58,7,65,7],[33,8,37,8],[33,9,37,9],[13,8,14,8],[13,9,14,9],[15,7,26,7],[13,7,14,7],[29,9,32,9],[15,9,26,9],[15,8,26,8],[9,8,12,8],[145,0,148,0],[145,1,148,1],[161,1,166,1],[161,0,166,0],[154,1,158,1],[154,0,158,0],[151,1,153,1],[134,1,140,1],[174,0,177,0],[174,1,177,1],[151,0,153,0],[167,1,169,1],[167,0,169,0],[170,0,173,0],[170,1,173,1],[100,1,105,1],[106,1,108,1],[106,0,108,0],[141,1,144,1],[141,0,144,0],[121,1,123,1],[121,0,123,0],[124,1,131,1],[134,0,140,0],[109,0,113,0],[109,1,113,1],[114,1,120,1],[114,0,120,0],[124,0,131,0],[100,0,105,0],[44,0,48,0],[58,5,65,5],[85,1,88,1],[77,1,84,1],[66,1,70,1],[49,6,52,6],[49,7,52,7],[53,4,55,4],[53,5,55,5],[58,4,65,4],[66,3,70,3],[53,6,55,6],[73,4,76,4],[73,5,76,5],[73,1,76,1],[73,0,76,0],[85,0,88,0],[77,7,84,7],[77,5,84,5],[73,7,76,7],[77,4,84,4],[100,9,105,9],[38,7,43,7],[2,0,3,0],[2,1,3,1],[29,1,32,1],[33,0,37,0],[33,1,37,1],[6,0,8,0],[6,1,8,1],[9,1,12,1],[9,0,12,0],[13,0,14,0],[15,0,26,0],[15,1,26,1],[38,0,43,0],[38,1,43,1],[29,0,32,0],[49,1,52,1],[44,1,48,1],[53,0,55,0],[53,1,55,1],[58,1,65,1],[58,0,65,0],[49,0,52,0],[2,2,3,3],[38,6,43,6],[33,4,37,4],[44,6,48,6],[44,7,48,7],[53,2,53,3],[49,4,52,4],[44,4,48,4],[53,7,55,7],[38,4,43,4],[2,4,2,9],[9,9,12,9],[44,9,48,9],[38,9,43,9],[33,5,37,5],[9,6,12,6],[9,4,12,4],[9,5,12,5],[38,5,43,5],[15,6,26,6],[33,6,37,6],[6,9,8,9],[6,4,8,4],[6,5,8,5],[49,5,52,5],[73,8,76,8],[100,8,105,8],[44,8,48,8],[100,7,105,7],[100,5,105,5],[44,5,48,5],[58,6,65,6],[73,6,76,6],[96,4,96,9],[73,9,76,9],[89,5,91,5],[77,6,84,6],[96,2,97,3],[93,0,93,9],[66,0,70,0],[85,8,88,8],[77,0,84,0],[96,0,97,0],[96,1,97,1],[77,9,84,9],[89,0,91,0],[89,4,91,4],[89,1,91,1],[151,5,153,5],[151,6,153,6],[170,7,173,7],[161,4,166,4],[151,7,153,7],[85,4,88,4],[85,5,88,5],[85,6,88,6],[85,7,88,7],[100,6,105,6],[100,4,105,4],[109,5,113,5],[134,5,140,5],[114,7,120,7],[106,7,108,7],[170,4,173,4],[170,5,173,5],[170,6,173,6],[167,4,169,4],[151,4,153,4],[134,6,140,6],[134,7,140,7],[121,4,123,4],[114,4,120,4],[109,7,113,7],[109,6,113,6],[109,4,113,4],[106,4,108,4],[106,5,108,5],[124,6,131,6],[121,6,123,6],[114,6,120,6],[114,5,120,5],[106,6,108,6],[124,4,131,4],[124,5,131,5],[121,5,123,5],[141,9,144,9],[109,9,113,9],[109,8,113,8],[124,8,131,8],[124,9,131,9],[121,8,123,8],[121,9,123,9],[114,9,120,9],[114,8,120,8],[134,9,140,9],[141,8,144,8],[170,8,173,8],[170,9,173,9],[151,8,153,8],[151,9,153,9],[167,9,169,9],[167,8,169,8],[161,9,166,9],[154,9,158,9],[161,8,166,8],[154,8,158,8]]}
["Performance Evaluation Examples - Contractor"]
[]
["Criteria ","Measure","Consider",null,"Rating Scale Examples"]
[null,null,null,null,"Unsatisfactory","Needs Improvement","Acceptable","Requirements Fully Met","Exceeds Requirements","Superlative"]
[]
["Management"]
["Skill Level and Competency","Competency of management team to effectively manage the project and its progress","·","Technical skills","Significant skills or competency issues noted in the management team, requiring immediate attention.","Some deficiencies noted in the skills and competencies of management, or areas where improvement are needed.","Overall have demonstrated the required skills and competencies in management, or are working well to develop in some areas to the required standard","Have demonstrated the required skills and competencies in management at all levels.","Easily meets all the skills and competency requirements in management for the contract, and exceeds at some levels","Skills and competencies in management demonstrated well in excess of the requirements, at all levels."]
[null,null,"·","Inter personal skills and management skills"]
[null,null,"·","Environmental Management"]
["Risk Management ","Effort, focus and proactive management of risks on the project","·","Number of new risks identified, quantified and planned for.","Irresponsible risk management adversely affecting the  project and the Client's reputation ","Several key risks not identified or appropriately managed, adversely affecting the project","Most key risks are identified and managed appropriately with minor effects on the project","All key risks are identified and managed appropriately ","All key risks are efficiently managed improving the project quality.  A number of opportunities proactively identified to the benefit of the project.","Superior risk management processes developed and managed, improving the project quality, and raising the bar in terms of the risk management standards.  Great efforts taken to identify and progress opportunities to the benefit of the project."]
[null,null,"·","Accurate identification of risk consequence and outcomes."]
[null,null,"·","Proactive risk management and mitigating measures."]
[null,null,"·","Speedy mitigation or management of high risks."]
["Responsiveness","Provides efficient and timely responses and reporting","·","Turnaround of queries and completeness of responses.","Response and deliverables more than five days late","Response and deliverables two to five days late","Majority of responses and deliverableson time","All responses and deliverables on time","Response and deliverables between two days early and on time","All Response and deliverables more than two days early"]
[null,null,"·","Achieving documentation and reporting deliverable dates."]
["Quality Assurance  (Maintenance Contractor Only)","Quality Assurance","Level of proactive effort applied to the quality system:",null,"Poor quality of delivery. Improvement needed in several areas.","Improvement needed in some areas.","Most tasks delivered to required standard","All tasks delivered to required standard","All tasks delivered to a higher standard","All tasks delivered to an excellent standard"]
[null,null,"·","Level of innovation and management of the system."]
[null,null,"·","Paper trail functional and accessible through the system."]
[null,null,"·","Availability of test results."]
[null,null,"·","Availability of material certificates."]
[null,null,"Quality Plan:"]
[null,null,"·","Development and Updating."]
[null,null,"·","Implementation."]
[null,null,"Maintenance Contract Standard Quality Performance Indicator:"]
[null,null,"·","The number of non-complying tasks compared to the number of tasks programmed."]
[null,null,"·","Contract quality plan compliance."]
[null,null,"·","Other indicators developed during the contract period."]
[]
["Production"]
["Contractor’s Programmes  (Maintenance Contractor Only)","Contractor's Programmes","·","Preparation and agreement","Programme delivered late, incomplete, and at a standard well below than expected.  Limited evidence that it has been effectively executed across the network  Updates to the programme are infrequent.","Programme generally delivered late, and at a standard lower than expected.  Not well implemented across the project.  Updates infrequently completed.","Programme generally delivered on time, to the required standard.  Implemented generally as planned.  Some updates completed, and some demonstration of positive monitoring undertaken.","Delivered on time and to the required standard.  Implemented generally as planned.  Frequent updates completed, and appropriate positive monitoring undertaken.","Programme delivered on time and to a high standard.  Implemented as planned.  Frequent updates completed, positive monitoring undertaken, and used as a highly effective management tool.","Programme always delivered on or ahead of time, and to a very high standard.  Implemented as planned.  Frequent updates completed, positive and proactive programme management practices undertaken with significant enhancements made as a result."]
[null,null,"·","Completeness"]
[null,null,"·","Accuracy"]
[null,null,"·","Implementation"]
["Ability to meet Programme","Effort and Proactive management of the programme together with accuracy in relation to on site production","·","Current completion date with that originally forecast.","Delivery significantly behind target completion date.","Delivery behind target completion date.","Delivery on target completion date with some minor exceptions.","Delivery on target completion date.","Delivery ahead of target completion date.","Delivery significantly ahead of target completion date."]
[null,null,"·","Resources made available as required."]
[null,null,"·","Flexibility in resourcing."]
[null,null,"·","Quantum and number of changes from last review."]
[null,null,"·","Progress in relation to programme."]
["Achieves the Specified Standard","Standard and quality of output in relation to contractual requirements","·","Quality of output in relation to requirements.","Products disfigured and/or in a poor state of operation. Overall site looks like a tip, unloved and presents a safety hazard","Products in poor state and/or potential to be blamed for operational issues.  Overall site untidy, no pride in the look of the site and potential for safety issues to arise","Defects to products or operational requirements not hard to find.  Overall site tidy but frequent occasions of litter, detritus, spoil etc.  Site team unaware of look","Occasional defect to products and/or isolated operational problems corrected in timely fashion. Site very tidy, but odd area needs improvement and/or response time has not been meet.  Good pride in overall look","No defects to products and/or isolated operational problems. Site very tidy and/or response times being meet.  Good pride in overall look","Products exceed standard specified and in excellent operational condition. Site clean, tidy, ordered and a pleasure to the eye. Site team happy to point out the performance"]
[null,null,"·","Test results to prove quality of outputs."]
[null,null,"·","Number of “Notices to Contractor” (NTC’s) issued relating to quality of completed work not being of an acceptable standard."]
[null,null,"·","Supervision with emphasis on quality."]
[null,null,"·","Training of staff."]
[null,null,"·","Certification of materials corresponding with requirements."]
["Defect Management System","Ability to identify and rectify non compliances","·","Number of Non Conformances and number not rectified.","30+% non conformances outstanding more than one month","20% non conformances outstanding more than one month","10% non conformances outstanding more than one month","5% non conformances outstanding ","No non conformances"," Pro-active Defect Management System ensuring all standards exceed specification "]
[null,null,"·","Self monitoring and ability to identify non conformances."]
[null,null,"·","Early detection of non conformances."]
[null,null,"·","Number of non conformances originally identified externally."]
[null,null,"·","Speedy rectification of errors."]
["Achievement (Maintenance Contractor Only)","Achievement","·","The number of faults the Engineer identifies that were not rectified in the specified response times.","The Engineer identifies major faults not rectified and significantly outside the specified response times.  Insufficient priority tasks completed within the month.  Critical cyclic maintenance and unit rate work items not identified in a timely manner with impacts on acceptable levels of service.","The Engineer identifies major faults not rectified in the specified response times.  Some priority tasks to be completed within the month were outstanding.  Critical cyclic maintenance and unit rate work items not identified in a timely manner.","The Engineer does not identify any major faults not rectified in the specified response times.  All priority tasks to be completed within the month were completed.  All critical cyclic maintenance and unit rate work items identified.","The Engineer does not identify any faults not rectified in the specified response times.  All priority tasks to be completed within the month were completed.  All critical cyclic maintenance and unit rate work items identified and commenced.","All faults rectified in the specified response times and work on remaining faults commenced.  All priority tasks to be completed within the month were completed and a start made on the backlog.  All critical cyclic maintenance and unit rate work items identified, commenced and at least a quarter were completed.","All identified faults rectified in the month.  All tasks to be completed within the month were completed.  All critical cyclic maintenance and unit rate work items identified and completed."]
[null,null,"·","The number of outstanding tasks each month compared to the number of tasks with a priority such that they were to be completed within that month."]
[null,null,"·","Timely identification and intervention on cyclic maintenance items resulting in the output criteria being met."]
[null,null,"·","Timely identification of unit rate work items and completion of these before safety is compromised, they develop into a more expensive repair or pavement integrity is affected."]
["Network Condition (Maintenance Contractor Only)","Network Condition","The standard of work, effectiveness of the programme and innovative interventions being used is:",null,"Network condition significantly under required levels","Network condition needs improvement in several areas","Network condition meets most requirements","Network Condition meets requirements","Network condition exceeds requirements","Network condition exceeds requirements significantly "]
[null,null,"·","Resulting in an avoidable deterioration of the general condition of the network and service level provided."]
[null,null,"·","Resulting in a noticeable improvement in the general condition of the network and service level provided which can be attributed to interventions executed under this contract."]
[]
["Health and Safety"]
["Safe Work Practices","Effort focus and proactive management of safety on site","·","Reporting and action on incidents.","Significant deficiencies from required standard","A number of deficiencies from required standard.","Evidence of good implementation of Contractor’s OSH management information on site.","Contractor’s OSH management information has been fully implemented on site, ","A number of enhancements from required standard ","In addition to meeting the required standard significant enhancements have been deployed"]
[null,null,"·","Work practices agreeing with Health and Safety (OSH) requirements."]
[null,null,"·","Number of lost time Injuries (LTI’s) during the month."]
[null,null,"·","Number of repeated near miss incidents or subsequent LTI’s."]
[null,null,"·","Company Safety Plan."]
[null,null,"·","Site Safety Plan."]
[null,null,"·","Number of near misses identified."]
[null,null,"·","Maintenance contract standard Safety Performance indicator (Maintenance Contractor Only)."]
["Traffic Management Control","Effort and Proactive management of traffic flows and public safety","·","Disruption to traffic flows\nPublic safety\nPublic perception\nComplaints\nTraffic Management Plan: Development and updating\nTraffic Management Plan: Implementation\n","Development of Site Specific Traffic Management Plans (TMP’s):"]
[null,null,"·\n·\n·\n·\n·",null,"TMP's completed and implemented without any prior consultation with outside parties.","TMP’s completed and implemented with minimal prior consultation with outside parties.","Majority of TMP’s completed and implemented with prior consultation with outside parties.","Majority of TMP’s completed and implemented with full and proper consultation with outside parties.","All TMP’s proactively completed well in advance and implemented with full and proper consultation with outside parties.","All TMP’s proactively completed well in advance and implemented with full and proper consultation with outside parties and addressing any comments, STMS has copy of TMP."]
[null,null,null,null,"Implementation of Site Specific Traffic Management Plans (TMP):"]
[null,null,null,null,"Dangerous. Poor level of traffic control set-out.","Needs Improvement. Inadequate level of traffic control set-out.","Acceptable level of traffic control set-out on majority of sites.","Acceptable level of traffic control set-out on all sites, with some evidence of higher standard sites.","Acceptable level of traffic control set-out on all sites, with several very high standard sites.","High Standard of traffic control set-out on all sites."]
[null,null,null,null,"Average Audit score greater than or equal to 51.","Average Audit score 26-50.","Average Audit score 11-25.","Average Audit score 5-10.","Average Audit score \n1-5.","Average Audit score 0."]
[]
["Administration"]
["QA Documentation (Capital Contractor Only)","Level of proactive effort applied to the quality system","·","Level of innovation and management of the system.","Significant deficiencies from required standard.","A number of deficiencies from the required standard.","Minimal deficiencies from the required standard.","No deficiencies from the required standard and some enhancements noted.","A number of enhancements above the required standard","A significant number of enhancements to the required standard"]
[null,null,"·","Paper trail functional and accessible through the system."]
[null,null,"·","Availability of test results."]
[null,null,"·","Availability of material certificates."]
["Financial","Effort and proactive management of the project budget, cashflow and its accuracy","·","Variations between forecast for the month and financial year based on original forecast and current forecast.","Delivery significantly above target budget and limited financial information provided in required reports.","Delivery above target budget and incomplete or inaccurate financial information provided in required reports.","Slight variance from target budget and reasonable financial information provided in reports.","Delivery on target budget and good financial information provided in reports.","Delivery below target budget, and excellent financial information provided in reports.","Delivery significantly below target budget, and first class financial information consistently provided at all times."]
[null,null,"·","Accuracy of invoicing."]
[null,null,"\n·","Capital Contractor Only:\nChange in final forecast cost from last month "]
[null,null,null,"Maintenance Contractor Only:"]
[null,null,"·","Maintenance contract standard Financial Performance indicator"]
[null,null,"·","Accrued value of work versus budget and updated forecast."]
[null,null,"·","Value of monthly programmes versus budget, forecast and the value of certified for payment."]
[null,null,"·","Value of outstanding work and work in progress"]
["Handling of Variations","Necessary changes being incorporated effectively and managed satisfactorily","·","Keeping up with contract changes.","Approach to pricing and signalling variations lacks proactiveness, with limited if any forward visibility of pending claims.  Dispute about handling and/or pricing of variation(s) requiring Client intervention to resolve.","Approach to pricing and signalling variations lacks proactiveness.  Dispute about handling and/or pricing of variation(s) requiring Client intervention to resolve.","Variations priced, approved and recorded in a reasonably timely fashion.","Variations efficiently priced, approved and recorded in timely fashion and remain within forecast.  All parties keep informed and generally working collaboratively.","Variations efficiently and proactively priced, approved and recorded in timely fashion.  All parties keep well informed throughout and working collaboratively to reduce Client costs.","Variations highly efficiently and proactively priced, approved and recorded in timely fashion.  Significant proactive steps taken to avoid variations.  All parties keep well informed throughout and working collaboratively to reduce Client costs."]
[null,null,"·","Awareness of current documents."]
[null,null,"·","Documents and drawings kept up to date."]
[null,null,"·","Time and cost effective solutions to variations giving the Client good value for money"]
["Reporting (Maintenance Contractor Only)","Reporting","·","Monthly claim.","Report delivered to a poor standard with inaccurate information provided, and poor financial forecasts and monthly claims","Report delivered to a low standard with some inaccuracies in areas such as financial forecasts and monthly claims","Report delivered generally to a acceptable standard ","Report delivered according to requirements","Report delivered to a consistently high standard of completeness and accuracy.","Report delivered to a consistently very high standard of completeness and accuracy, with significant additional value provided over and above the minimum requirements. "]
[null,null,"·","Work summary report."]
[null,null,"·","Financial forecast."]
[]
[]
["Performance Evaluation Examples - Consultant / Non-Engineering"]
[]
["Criteria ","Measure","Consider",null,"Rating Scale Examples"]
[null,null,null,null,"Unsatisfactory","Needs Improvement","Acceptable","Requirements Fully Met","Exceeds Requirements","Superlative"]
[]
["Management"]
["Competency","Competency of management team to effectively manage the project and its progress on all necessary tasks","·","Technical skills.","Significant skills or competency issues noted in the management team, requiring immediate attention.  Numerous complaints from Stakeholders.","Some deficiencies noted in the skills and competencies of management, or areas where improvement are needed. Several complains from received from stakeholders. ","Overall have demonstrated the required skills and competencies in management, or are working well to develop in some areas to the required standard.  Limited complaints from received stakeholders, or any complaints received have been appropriately handled.","Have demonstrated the required skills and competencies in management at all levels. Few complaints from stakeholders. ","Easily meets all the skills and competency requirements in management for the contract, at all levels. Few or no complaints from stakeholders.","Skills and competencies in management demonstrated well in excess of the requirements, at all levels.  All stakeholders satisfied "]
[null,null,"·","Inter personal skills and management skills."]
[null,null,"·","Ability to plan for forward works and make resources available."]
[null,null,"·","Environmental Management."]
[null,null,"·","Stakeholders’ view of consultant’s performance, including the Client and monitoring number of complaints received. "]
[null,null,"·","Robustness of projects nominated in the annual plan (related to the number progressed to detailed design and number of change authorizations required to draft annual plan) (Maintenance Consultant Only)."]
["Creating “No Surprises” Environment","Ability to keep the Client informed on all relevant issues","·","Flow of information and its accuracy and relevance.","Limited and / or inaccurate updates to the Client provided leading to serious or significant issues.","Few updates to the Client on potential changes leading to some issues","Client is informed on a regular basis, although some minor inaccuracies in information noted.","The Client is keep well informed and updated on any changes or issues.","The Client is keep well informed and updated on any changes or issues, with highly accurate information provided at all times, and solutions proactively provided as necessary.","The Client is keep well informed and updated on any changes or issues well in advance, with highly accurate information provided at all times, and highly effective solutions proactively provided as necessary."]
[null,null,"·","Highlighting and informing on potential problems."]
[null,null,"·","Highlighting and informing on potential costs."]
["Creating Innovation","Innovative ideas turned into reality in design and management","·","New methods","Very little innovation seen.  Many opportunities to innovate missed or unexplored.","Some innovation seen but several opportunities missed.","Some value adding innovation seen in some areas","Good levels of innovation provided in critical areas, including good consideration of improved customer satisfaction techniques.","High levels of innovation provided in many areas, including good consideration of improved customer satisfaction techniques.","Extremely innovative across the full range of services provided.  Excellent positive customer satisfaction initiatives identified."]
[null,null,"·","New materials"]
[null,null,"·","Value gained by the innovative ideas."]
[null,null,"·","Time saved by innovative ideas."]
[null,null,"·","New initiatives that better serve customers"]
["Proactiveness","Effort, focus and proactive management of risks and future issues on the project","·","Number of new risks identified, quantified and planned for.","Irresponsible risk management adversely affecting the  project and the Client's reputation ","Several key risks not identified or managed, adversely affecting the contract.","Most key risks are identified and managed appropriately with minor effects on the contract.","All key risks are identified and managed appropriately .","Risks and opportunities very efficiently managed, significant improving outcomes.","Risks and opportunities very efficiently managed at all times, great customer service initiatives developed, and outstanding outcomes achieved."]
[null,null,"·","Early detection of issues which may cause problems."]
[null,null,"·","Accurate identification of issues, risk consequence and outcomes."]
[null,null,"·","Proactive risk management and speedy identification of mitigating measures."]
[null,null,"·","Identification of preventative maintenance sites (Maintenance Consultant Only)."]
[null,null,"·","Ensure contractor responds to incidents (Maintenance Consultant Only)."]
[null,null,"·","Puts customers first and deals quickly with customer issues"]
["Responsiveness (Maintenance Consultant Only)","Provides efficient and timely responses and exception reporting","·","Turnaround of queries and completeness of responses.","Response more than five days late","Response two to five days late","Majority of responses on time","All responses on time","Response between two days early and on time","Response more than two days early"]
[null,null,"·","Level of service provided to the Client."]
[null,null,"·","Mitigate the effect of environmental issues."]
["Managing the Network (Maintenance Consultant Only)","Effective execution of all network management functions","·","Public Relations.","Several tasks not completed, or completed to a poor standard","Most tasks completed to an average standard, or several areas of improvement noted.","Most tasks completed to an acceptable standard ","All tasks completed to required standard","All tasks completed to a high standard","All tasks completed to an excellent standard"]
[null,null,"·","All miscellaneous reports required under the contract that are not specifically mentioned."]
[null,null,"·","Robust and credible Forward work programme and annual plan submission."]
[null,null,"·","Network Controls managed adequately."]
[null,null,"·","Inspections effective and identify all issues requiring attention."]
[null,null,"·","Preparation and administration of Contracts."]
[null,null,"·","Quality of Deliverables."]
[null,null,"·","Clear focus on delivery of required safety outputs."]
[]
["Production"]
["Timely outputs","Effective management and resourcing to produce the required outputs on time","·","Current completion dates (outputs may be incremental) relating to those originally forecast.","Output delivery significantly behind target completion date.","Output delivery behind target completion date.","Output delivery on target completion date with some minor exceptions.","Output delivery on target completion date.","Output delivery ahead of target completion date.","Output delivery significantly ahead of target completion date."]
[null,null,"·","Resources made available as required."]
[null,null,"·","Flexibility in resourcing."]
[null,null,"·","Number of changes from last review."]
[null,null,"·","Progress in relation to programme."]
[null,null,"·","Planning and Service consents processed within required response time (Maintenance Consultant Only)."]
[null,null,"·","Timely production of the annual plan (Maintenance Consultant Only)."]
["Accurate outputs to Required Standard","Standard and quality of output in relation to contractual obligations","·","Quality of output in relation to requirements in contract.","Outputs consistently provided to a standard less than required.","Some outputs provided to the required standard, but with several exceptions noted.","Outputs generally provided to the required standard","Outputs consistently provided to the required or higher standard","Outputs consistently provided to a higher than required standard","All outputs provided to a higher than required standard, with numerous outputs significantly between than required."]
[null,null,"·","Reports and documents agreeing with the scope."]
[null,null,"·","Management of outputs with emphasis on quality."]
[null,null,"·","Accurate RAMM updates."]
["Defect Management System","Ability to identify and rectify non compliances and errors","·","Self monitoring and ability to identify non conformances.","20+% non conformances outstanding more than one month","Less than 20% non conformances outstanding more than one month","Less than 10% non conformances outstanding more than one month","Less than 5% non conformances outstanding ","No non conformances"," Pro-active Defect Management System ensuring all standards exceed specification "]
[null,null,"·","Early detection of non conformances."]
[null,null,"·","Number of non conformances originally identified externally."]
[null,null,"·","Speedy rectification of errors."]
[]
["Health and Safety"]
["Safe Work Practices","Effort focus and proactive management of safety","·","Reporting and action on incidents.","Significant deficiencies from required standard","A number of deficiencies from required standard.","Evidence of good implementation of Contractor’s OSH management information on site.","Contractor’s OSH management information has been fully implemented on site, ","A number of enhancements from required standard ","In addition to meeting the required standard significant enhancements have been deployed"]
[null,null,"·","Work practices agreeing with OSH requirements."]
[null,null,"·","Company Safety Plan."]
["Safety Performance Measures (Maintenance Consultant Only)","Consultants achievement of their contractual performance measures","·","Response times interim fatal accident reports.","Poor incident management and / or poor quality and accuracy of reporting.  Issues with the timeliness of reporting.","Some issues with incident management.  Some quality and accuracy issues with reporting.  Issues with the timeliness of reporting.","Most incidents well managed, and most reports provided to the required standard in a timely manner.","All incidents well managed, and all reports provided to the required standard in a timely manner.","All incidents highly competently managed, and all reports provided to are to a high standard, and received on or ahead of response times.","All incidents highly competently and proactively managed, excellent customer service provided.  All reports provided to are to a superb standard, and consistently received ahead of response times."]
[null,null,"·","Development of minor safety programme."]
[null,null,"·","Safety inspections completed as suppliers methodology."]
[null,null,"·","Crash database updated and provided as required."]
[null,null,"·","Response and management of incidents/emergency events."]
[]
["Administration"]
["Quality Assurance Documentation","Level of proactive effort applied to the quality system","·","Level of innovation and management of the system.","Significant deficiencies from required standard.","A number of deficiencies from the required standard.","Minimal deficiencies from the required standard.","No deficiencies from the required standard and some enhancements noted.","A number of enhancements above the required standard","A significant number of enhancements to the required standard"]
[null,null,"·","Paper trail functional and accessible through the system."]
[null,null,"·","Availability of self auditing and self monitoring documentation."]
[null,null,"·","Certification of personnel capabilities."]
[null,null,"·","Availability of relevant up to date approved quality plan (Maintenance Consultant Only)."]
[null,null,"·","Evidence that the quality plan is being implemented and non-conformances are being managed appropriately. (Maintenance Consultant Only)."]
["Monthly Report","Accuracy and relevance of Monthly Report","·","Quality of contents.","Report delivered to a poor standard, inaccurate information or/and with late delivery","Report delivered to a low standard, some with inaccurate information or/and with late delivery ","Reports generally delivered to an acceptable standard and quality, and on time.","All reports delivered to an acceptable standard and quality, and on time.","All reports delivered to an high standard and quality, and on time.  Often delivered significantly ahead of time, or with numerous additional value adding information.","All reports delivered to a very high standard and quality, and always ahead of time.  All report contain significant additional value adding or insightful information."]
[null,null,"·","Relevance of contents with reference to the scope."]
[null,null,"·","Timeliness of availability of report."]
["Financial","Effort and proactive management of the project budget, cashflow and its accuracy (professional services and physical works contrasts)","·","Variations between forecast for the month and financial year based on original forecast and current forecast.","Delivery significantly above target Budget.","Delivery above target budget.","Slight variance from target budget.","Delivery on target budget.","Delivery below target budget.","Delivery significantly below target budget."]
[null,null,"·","Accuracy of invoicing."]
[null,null,"·","Update Proman on time."]
[null,null,"·","Accuracy of forecasting physical works expenditure for the month and financial year."]
["Handling of Variations","Necessary changes being incorporated effectively and managed satisfactorily.","·","Keeping up with contract, and project changes.","Approach to pricing and signalling variations lacks proactiveness, with limited if any forward visibility of pending claims.  Dispute about handling and/or pricing of variation(s) requiring Client intervention to resolve.","Approach to pricing and signalling variations lacks proactiveness.  Dispute about handling and/or pricing of variation(s) requiring Client intervention to resolve.","Variations priced, approved and recorded in a reasonably timely fashion.","Variations efficiently priced, approved and recorded in timely fashion and remain within forecast.  All parties keep informed and generally working collaboratively.","Variations efficiently and proactively priced, approved and recorded in timely fashion.  All parties keep well informed throughout and working collaboratively to reduce Client costs.","Variations highly efficiently and proactively priced, approved and recorded in timely fashion.  Significant proactive steps taken to avoid variations.  All parties keep well informed throughout and working collaboratively to reduce Client costs."]
[null,null,"·","Awareness of current documents."]
[null,null,"·","Documents and drawings updated and distributed"]