{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["13.3-13.5","13.4 Systems","13.5 Sub-area Corridor Planning","13.6 Land Planning-Engineering","13.7 Transportation Statistics"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"13.3-13.5","index":0,"n_rows":93,"n_cols":18,"rows_kept":93,"cut":false,"hidden":false,"merged":[[24,1,24,12],[39,1,39,6],[39,10,39,12],[40,1,40,6],[35,1,37,4],[35,5,37,11],[35,12,37,12],[31,5,31,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[26,1,26,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,12],[22,1,22,12],[8,4,8,8],[11,4,11,8],[11,10,11,12],[19,1,20,12],[8,10,8,12],[21,1,21,12],[14,7,16,12],[9,4,9,8],[9,10,9,12],[10,4,10,8],[10,10,10,12],[86,12,87,12],[77,1,77,2],[77,3,77,11],[80,3,80,11],[81,1,81,2],[81,12,82,12],[74,3,74,11],[74,12,75,12],[71,12,72,12],[58,2,58,10],[51,2,51,12],[71,3,71,11],[62,12,63,12],[64,3,64,11],[65,1,65,2],[65,12,66,12],[43,1,43,12],[33,1,33,12],[44,2,47,11],[44,12,45,12],[53,1,56,12],[92,8,92,11],[60,2,60,11],[61,3,61,11],[62,1,62,2],[62,3,62,11],[86,2,89,11],[85,1,85,11],[81,3,81,11],[73,3,73,11],[68,3,68,11],[67,3,67,11],[70,3,70,11],[71,1,71,2],[76,3,76,11],[65,3,65,11],[74,1,74,2]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:",null,null,null,null,null,null,4.5]
[null,"Project Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Prime Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"Sub Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Engineer of Record:",null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"Design Firm:",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Consultant Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,"FDOT Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, copy this tab to create an identical evaluation form for each Work Type."]
[]
[]
[]
[]
[null,"This worksheet provides specific performance measure guidelines for the performance rating scale as it pertains to each criteria item in this evaluation area. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official evaluation within the FDOT Consultant Evaluation (CE) internal application:"]
[]
[null,"https://ce.fdot.gov/"]
[null,"Access to the internal CE application for inputting performance evaluations \nis restricted to FDOT Project Managers."]
[]
[null,"PLANNING - QUALITY EVALUATION CRITERIA"]
[]
[null,"GENERAL PERFORMANCE RATING SCALE"]
[null,5,"Outstanding Performance",null,null,"   - Consultant consistently exceeded expectations."]
[null,4,"Above Satisfactory Performance",null,null,"   - Consultant consistently met, often exceeded, expectations."]
[null,3,"Satisfactory Performance",null,null,"   - Consultant consistently met expectations."]
[null,2,"Below Satisfactory Performance",null,null,"   - Consultant inconsistently met expectations."]
[null,1,"Unacceptable Performance",null,null,"   - Consultant consistently failed to meet expectations."]
[]
[null,"**{See specific performance measure guidelines within each Evaluation Criteria Section}**"]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M93","v":"Not Rated"},null,null,null,"Total Items:",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R62:R83)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Do not rate an evaluation item if it is not applicable to this evaluation. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated.  All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"Ability to examine the existing multimodal transportation system/mode.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62=\"N/A\",\"\",(IF(M62=\"\",\"\",(IF(M62<3,\"COMMENTS REQUIRED\",(IF(M62>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M63=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"Ability to gather data and apply it to approved models for the development of future year forecasts.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65=\"N/A\",\"\",(IF(M65=\"\",\"\",(IF(M65<3,\"COMMENTS REQUIRED\",(IF(M65>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M66=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Ability to develop alternative analyses and their related cost estimates.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M68>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M68=\"N/A\",\"\",(IF(M68=\"\",\"\",(IF(M68<3,\"COMMENTS REQUIRED\",(IF(M68>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M69=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Ability to develop a comprehensive long range plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71=\"N/A\",\"\",(IF(M71=\"\",\"\",(IF(M71<3,\"COMMENTS REQUIRED\",(IF(M71>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M72=\"comments required\", 1,0)","v":0}]
[]
[null,null,5,"Ability to organize and conduct public involvement meetings engaging public and stakeholders.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74=\"N/A\",\"\",(IF(M74=\"\",\"\",(IF(M74<3,\"COMMENTS REQUIRED\",(IF(M74>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M75=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Ability to collect, compile, and analyze transportation planning data.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77=\"N/A\",\"\",(IF(M77=\"\",\"\",(IF(M77<3,\"COMMENTS REQUIRED\",(IF(M77>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M78=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,7,"Ability to produce deliverables relevant to the contract scope of services.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M81>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M81=\"N/A\",\"\",(IF(M81=\"\",\"\",(IF(M81<3,\"COMMENTS REQUIRED\",(IF(M81>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M82=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M62:M83)=0),\"Not Rated\", AVERAGE(M62:M83))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M85=\"Not Rated\",\"\",(IF(O87>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O62:O83)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M85))","v":"Not Rated"}]

{"sheet":"13.4 Systems","index":1,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":true,"merged":[[89,12,90,12],[93,1,93,11],[94,2,97,11],[94,12,95,12],[100,8,100,11],[84,3,84,11],[85,1,85,2],[85,3,85,11],[88,3,88,11],[89,1,89,2],[89,3,89,11],[82,1,82,2],[82,3,82,11],[82,12,83,12],[72,3,72,11],[73,1,73,2],[73,3,73,11],[73,12,74,12],[75,3,75,11],[76,3,76,11],[78,3,78,11],[79,1,79,2],[79,3,79,11],[79,12,80,12],[81,3,81,11],[70,12,71,12],[58,2,58,10],[60,3,60,11],[61,3,61,11],[62,3,62,11],[63,3,63,11],[64,3,64,11],[65,3,65,11],[68,2,68,11],[69,3,69,11],[70,1,70,2],[70,3,70,11],[53,1,56,12],[33,1,33,12],[35,1,37,4],[35,5,37,11],[35,12,37,12],[39,1,39,6],[39,10,39,12],[40,1,40,6],[43,1,43,12],[44,2,47,11],[44,12,45,12],[51,2,51,12],[31,5,31,12],[11,4,11,8],[11,10,11,12],[19,1,20,12],[21,1,21,12],[22,1,22,12],[24,1,24,12],[26,1,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[8,4,8,8],[8,10,8,12],[9,4,9,8],[9,10,9,12],[10,4,10,8],[10,10,10,12],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:",null,null,null,null,null,null,4.5]
[null,"Project Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Prime Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"Sub Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Engineer of Record:",null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"Design Firm:",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Consultant Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,"FDOT Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"FDOT PM Phone No:"]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet provides specific performance measure guidelines for the performance rating scale as it pertains to each criteria item in this evaluation area. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official evaluation within the FDOT Consultant Evaluation (CE) internal application:"]
[]
[null,"https://psice.dot.state.fl.us/"]
[null,"Access to the internal CE application for inputting performance evaluations \nis restricted to FDOT Project Managers."]
[]
[null,"PLANNING - QUALITY EVALUATION CRITERIA"]
[]
[null,"GENERAL PERFORMANCE RATING SCALE"]
[null,5,"Outstanding Performance",null,null,"   - Completed task with minimal Department review/involvement required. \n     Consultant proactively handled any issues."]
[null,4,"Above Satisfactory Performance",null,null,"   - Completed task with a few minor issues. Comment resolution required\n      little effort."]
[null,3,"Satisfactory Performance",null,null,"   - Completed task with several minor issues. Comment resolution required\n     discussions and/or meetings."]
[null,2,"Below Satisfactory Performance",null,null,"   - Completed task with numerous issues. Comment resolution required \n     significant effort, discussions, meetings and rework."]
[null,1,"Unacceptable Performance",null,null,"   - Failed to complete task."]
[]
[null,"**{See specific performance measure guidelines within each Evaluation Criteria Section}**"]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M101","v":"Not Rated"},null,null,null,"Total Items:",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R70:R91)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. * NOTE: Evaluation Criteria in items 10 - 13 may only be applicable to Materials/Testing Contracts. All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Far exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Often exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Consistently achieved FDOT requirements and guidelines.  Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Sometimes achieved FDOT requirements and guidelines.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Consistently did not achieve FDOT requirements and guidelines.  Objectives achieved with significant involvement by FDOT."]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"Ability to examine the existing multimodal transportation system/mode.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M70>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M70=\"N/A\",\"\",(IF(M70=\"\",\"\",(IF(M70<3,\"COMMENTS REQUIRED\",(IF(M70>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M71=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"Ability to gather data and apply it to approved models for the development of future year forecasts.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M73>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M73=\"N/A\",\"\",(IF(M73=\"\",\"\",(IF(M73<3,\"COMMENTS REQUIRED\",(IF(M73>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M74=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Ability to develop alternative analyses and their related cost estimates.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M76>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M76=\"N/A\",\"\",(IF(M76=\"\",\"\",(IF(M76<3,\"COMMENTS REQUIRED\",(IF(M76>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M77=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Ability to develop a comprehensive long range plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M79>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M79=\"N/A\",\"\",(IF(M79=\"\",\"\",(IF(M79<3,\"COMMENTS REQUIRED\",(IF(M79>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M80=\"comments required\", 1,0)","v":0}]
[]
[null,null,5,"Ability to organize and conduct public involvement meetings engaging public and stakeholders.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M82>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M82=\"N/A\",\"\",(IF(M82=\"\",\"\",(IF(M82<3,\"COMMENTS REQUIRED\",(IF(M82>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M83=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Ability to collect, compile, and analyze transportation planning data.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M85>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M85=\"N/A\",\"\",(IF(M85=\"\",\"\",(IF(M85<3,\"COMMENTS REQUIRED\",(IF(M85>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M86=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,7,"Ability to produce deliverables relevant to the contract scope of services.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M89>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M89=\"N/A\",\"\",(IF(M89=\"\",\"\",(IF(M89<3,\"COMMENTS REQUIRED\",(IF(M89>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M90=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M70:M91)=0),\"Not Rated\", AVERAGE(M70:M91))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M93=\"Not Rated\",\"\",(IF(O95>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O70:O91)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M93))","v":"Not Rated"}]

{"sheet":"13.5 Sub-area Corridor Planning","index":2,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":true,"merged":[[88,12,89,12],[92,1,92,11],[93,2,96,11],[93,12,94,12],[99,8,99,11],[84,3,84,11],[85,1,85,2],[85,3,85,11],[87,3,87,11],[88,1,88,2],[88,3,88,11],[82,1,82,2],[82,3,82,11],[82,12,83,12],[72,3,72,11],[73,1,73,2],[73,3,73,11],[73,12,74,12],[75,3,75,11],[76,3,76,11],[78,3,78,11],[79,1,79,2],[79,3,79,11],[79,12,80,12],[81,3,81,11],[70,12,71,12],[58,2,58,10],[60,3,60,11],[61,3,61,11],[62,3,62,11],[63,3,63,11],[64,3,64,11],[65,3,65,11],[68,2,68,11],[69,3,69,11],[70,1,70,2],[70,3,70,11],[53,1,56,12],[33,1,33,12],[35,1,37,4],[35,5,37,11],[35,12,37,12],[39,1,39,6],[39,10,39,12],[40,1,40,6],[43,1,43,12],[44,2,47,11],[44,12,45,12],[51,2,51,12],[31,5,31,12],[11,4,11,8],[11,10,11,12],[19,1,20,12],[21,1,21,12],[22,1,22,12],[24,1,24,12],[26,1,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[8,4,8,8],[8,10,8,12],[9,4,9,8],[9,10,9,12],[10,4,10,8],[10,10,10,12],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:",null,null,null,null,null,null,4.5]
[null,"Project Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Prime Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"Sub Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Engineer of Record:",null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"Design Firm:",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Consultant Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,"FDOT Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"FDOT PM Phone No:"]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet provides specific performance measure guidelines for the performance rating scale as it pertains to each criteria item in this evaluation area. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official evaluation within the FDOT Consultant Evaluation (CE) internal application:"]
[]
[null,"https://psice.dot.state.fl.us/"]
[null,"Access to the internal CE application for inputting performance evaluations \nis restricted to FDOT Project Managers."]
[]
[null,"PLANNING - QUALITY EVALUATION CRITERIA"]
[]
[null,"GENERAL PERFORMANCE RATING SCALE"]
[null,5,"Outstanding Performance",null,null,"   - Completed task with minimal Department review/involvement required. \n     Consultant proactively handled any issues."]
[null,4,"Above Satisfactory Performance",null,null,"   - Completed task with a few minor issues. Comment resolution required\n      little effort."]
[null,3,"Satisfactory Performance",null,null,"   - Completed task with several minor issues. Comment resolution required\n     discussions and/or meetings."]
[null,2,"Below Satisfactory Performance",null,null,"   - Completed task with numerous issues. Comment resolution required \n     significant effort, discussions, meetings and rework."]
[null,1,"Unacceptable Performance",null,null,"   - Failed to complete task."]
[]
[null,"**{See specific performance measure guidelines within each Evaluation Criteria Section}**"]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M100","v":"Not Rated"},null,null,null,"Total Items:",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R70:R90)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. * NOTE: Evaluation Criteria in items 10 - 13 may only be applicable to Materials/Testing Contracts. All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Far exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Often exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Consistently achieved FDOT requirements and guidelines.  Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Sometimes achieved FDOT requirements and guidelines.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Consistently did not achieve FDOT requirements and guidelines.  Objectives achieved with significant involvement by FDOT."]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"Ability to examine the existing multimodal transportation system/mode.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M70>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M70=\"N/A\",\"\",(IF(M70=\"\",\"\",(IF(M70<3,\"COMMENTS REQUIRED\",(IF(M70>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M71=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"Ability to gather data and apply it to approved models for the development of future year forecasts.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M73>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M73=\"N/A\",\"\",(IF(M73=\"\",\"\",(IF(M73<3,\"COMMENTS REQUIRED\",(IF(M73>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M74=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Ability to develop alternative analyses and their related cost estimates.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M76>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M76=\"N/A\",\"\",(IF(M76=\"\",\"\",(IF(M76<3,\"COMMENTS REQUIRED\",(IF(M76>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M77=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Ability to develop a comprehensive long range plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M79>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M79=\"N/A\",\"\",(IF(M79=\"\",\"\",(IF(M79<3,\"COMMENTS REQUIRED\",(IF(M79>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M80=\"comments required\", 1,0)","v":0}]
[]
[null,null,5,"Ability to organize and conduct public involvement meetings engaging public and stakeholders.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M82>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M82=\"N/A\",\"\",(IF(M82=\"\",\"\",(IF(M82<3,\"COMMENTS REQUIRED\",(IF(M82>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M83=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Ability to collect, compile, and analyze transportation planning data.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M85>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M85=\"N/A\",\"\",(IF(M85=\"\",\"\",(IF(M85<3,\"COMMENTS REQUIRED\",(IF(M85>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M86=\"comments required\", 1,0)","v":0}]
[]
[null,null,7,"Ability to produce deliverables relevant to the contract scope of services.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M88>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M88=\"N/A\",\"\",(IF(M88=\"\",\"\",(IF(M88<3,\"COMMENTS REQUIRED\",(IF(M88>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M89=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M70:M90)=0),\"Not Rated\", AVERAGE(M70:M90))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M92=\"Not Rated\",\"\",(IF(O94>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O70:O90)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M92))","v":"Not Rated"}]

{"sheet":"13.6 Land Planning-Engineering","index":3,"n_rows":104,"n_cols":18,"rows_kept":104,"cut":false,"hidden":false,"merged":[[86,3,86,11],[88,3,88,11],[96,1,96,11],[97,2,100,11],[97,12,98,12],[86,1,86,2],[103,8,103,11],[76,3,76,11],[77,1,77,2],[77,3,77,11],[91,3,91,11],[92,1,92,2],[92,3,92,11],[79,3,79,11],[80,1,80,2],[80,3,80,11],[82,3,82,11],[89,1,89,2],[89,3,89,11],[83,1,83,2],[83,3,83,11],[85,3,85,11],[74,1,74,2],[74,3,74,11],[74,12,75,12],[64,3,64,11],[65,1,65,2],[65,3,65,11],[65,12,66,12],[67,3,67,11],[68,3,68,11],[70,3,70,11],[71,1,71,2],[71,3,71,11],[71,12,72,12],[73,3,73,11],[62,12,63,12],[58,2,58,10],[60,2,60,11],[61,3,61,11],[62,1,62,2],[62,3,62,11],[53,1,56,12],[33,1,33,12],[35,1,37,4],[35,5,37,11],[35,12,37,12],[39,1,39,6],[39,10,39,12],[40,1,40,6],[43,1,43,12],[44,2,47,11],[44,12,45,12],[51,2,51,12],[31,5,31,12],[11,4,11,8],[11,10,11,12],[19,1,20,12],[21,1,21,12],[22,1,22,12],[24,1,24,12],[26,1,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[8,4,8,8],[8,10,8,12],[9,4,9,8],[9,10,9,12],[10,4,10,8],[10,10,10,12],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:",null,null,null,null,null,null,4.5]
[null,"Project Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Prime Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"Sub Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Engineer of Record:",null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"Design Firm:",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Consultant Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,"FDOT Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"FDOT PM Phone No:"]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet provides specific performance measure guidelines for the performance rating scale as it pertains to each criteria item in this evaluation area. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official evaluation within the FDOT Consultant Evaluation (CE) internal application:"]
[]
[null,"https://ce.fdot.gov/"]
[null,"Access to the internal CE application for inputting performance evaluations \nis restricted to FDOT Project Managers."]
[]
[null,"PLANNING - QUALITY EVALUATION CRITERIA"]
[]
[null,"GENERAL PERFORMANCE RATING SCALE"]
[null,5,"Outstanding Performance",null,null,"   - Consultant consistently exceeded expectations."]
[null,4,"Above Satisfactory Performance",null,null,"   - Consultant consistently met, often exceeded, expectations."]
[null,3,"Satisfactory Performance",null,null,"   - Consultant consistently met expectations."]
[null,2,"Below Satisfactory Performance",null,null,"   - Consultant inconsistently met expectations."]
[null,1,"Unacceptable Performance",null,null,"   - Consultant consistently failed to meet expectations."]
[]
[null,"**{See specific performance measure guidelines within each Evaluation Criteria Section}**"]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M104","v":"Not Rated"},null,null,null,"Total Items:",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R62:R94)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Do not rate an evaluation item if it is not applicable to this evaluation. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated.  All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"Ability to examine the existing transportation system/mode and determine its deficiencies.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62=\"N/A\",\"\",(IF(M62=\"\",\"\",(IF(M62<3,\"COMMENTS REQUIRED\",(IF(M62>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M63=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"Ability to gather data and apply it to approved models for the development of future year forecasts.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65=\"N/A\",\"\",(IF(M65=\"\",\"\",(IF(M65<3,\"COMMENTS REQUIRED\",(IF(M65>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M66=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Ability to develop alternative analyses and their related cost estimates.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M68>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M68=\"N/A\",\"\",(IF(M68=\"\",\"\",(IF(M68<3,\"COMMENTS REQUIRED\",(IF(M68>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M69=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Ability to develop a comprehensive long range plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71=\"N/A\",\"\",(IF(M71=\"\",\"\",(IF(M71<3,\"COMMENTS REQUIRED\",(IF(M71>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M72=\"comments required\", 1,0)","v":0}]
[]
[null,null,5,"Ability to organize and conduct public involvement meetings engaging public and stakeholders.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74=\"N/A\",\"\",(IF(M74=\"\",\"\",(IF(M74<3,\"COMMENTS REQUIRED\",(IF(M74>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M75=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Ability to collect, compile and analyze existing traffic data sources related to transportation planning.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77=\"N/A\",\"\",(IF(M77=\"\",\"\",(IF(M77<3,\"COMMENTS REQUIRED\",(IF(M77>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M78=\"comments required\", 1,0)","v":0}]
[]
[null,null,7,"The Land Planning/Engineering services and/or reports when initially received, were in \ncompliance with contractual obligations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M80>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M80=\"N/A\",\"\",(IF(M80=\"\",\"\",(IF(M80<3,\"COMMENTS REQUIRED\",(IF(M80>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M81=\"comments required\", 1,0)","v":0}]
[]
[null,null,8,"The methods and techniques used in performing the assignment, when initially received, were appropriate. No corrections were required for mathematical errors, inadequate descriptions and explanations, erroneous assumptions, contradictions, and/or omission of pertinent statements and information.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M83>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M83=\"N/A\",\"\",(IF(M83=\"\",\"\",(IF(M83<3,\"COMMENTS REQUIRED\",(IF(M83>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M84=\"comments required\", 1,0)","v":0}]
[]
[null,null,9,"The work performed illustrated the ability to properly develop and report comprehensive plans as they impact a specific property or properties and alternative analyses and their related costs for site plans, traffic circulation, access, and/or parking designs and patterns, etc. on properties affected by a right of way acquisition.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M86>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M86=\"N/A\",\"\",(IF(M86=\"\",\"\",(IF(M86<3,\"COMMENTS REQUIRED\",(IF(M86>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M87=\"comments required\", 1,0)","v":0}]
[]
[null,null,10,"Consultant submitted acceptable answers to review concerns, corrections, or requested data within stipulated contract time.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M89>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M89=\"N/A\",\"\",(IF(M89=\"\",\"\",(IF(M89<3,\"COMMENTS REQUIRED\",(IF(M89>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M90=\"comments required\", 1,0)","v":0}]
[]
[null,null,11,"The consultant demonstrated the qualities needed to be an effective expert witness through the consultant's knowledge of the subject project, ability to present and explain land planning and engineering issues, support of the Department's appraisal and legal staff during the pre-hearing phase, and demeanor during depositions and court hearings.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M92>0,1,0)","v":0}]
[null,"Comments:",null,1,null,null,null,null,null,null,null,null,{"$f":"IF(M92=\"N/A\",\"\",(IF(M92=\"\",\"\",(IF(M92<3,\"COMMENTS REQUIRED\",(IF(M92>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M93=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M62:M94)=0),\"Not Rated\", AVERAGE(M62:M94))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M96=\"Not Rated\",\"\",(IF(O98>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O62:O94)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M96))","v":"Not Rated"}]

{"sheet":"13.7 Transportation Statistics","index":4,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[81,12,82,12],[87,8,87,11],[76,3,76,11],[77,1,77,2],[77,3,77,11],[80,1,80,11],[81,2,84,11],[74,1,74,2],[74,3,74,11],[74,12,75,12],[64,3,64,11],[65,1,65,2],[65,3,65,11],[65,12,66,12],[67,3,67,11],[68,3,68,11],[70,3,70,11],[71,1,71,2],[71,3,71,11],[71,12,72,12],[73,3,73,11],[62,12,63,12],[58,2,58,10],[60,2,60,11],[61,3,61,11],[62,1,62,2],[62,3,62,11],[53,1,56,12],[33,1,33,12],[35,1,37,4],[35,5,37,11],[35,12,37,12],[39,1,39,6],[39,10,39,12],[40,1,40,6],[43,1,43,12],[44,2,47,11],[44,12,45,12],[51,2,51,12],[31,5,31,12],[11,4,11,8],[11,10,11,12],[19,1,20,12],[21,1,21,12],[22,1,22,12],[24,1,24,12],[26,1,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[8,4,8,8],[8,10,8,12],[9,4,9,8],[9,10,9,12],[10,4,10,8],[10,10,10,12],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:",null,null,null,null,null,null,4.5]
[null,"Project Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Prime Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,"Sub Consultant Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Engineer of Record:",null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,"Design Firm:",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Consultant Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,"FDOT Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"FDOT PM Phone No:"]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet provides specific performance measure guidelines for the performance rating scale as it pertains to each criteria item in this evaluation area. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official evaluation within the FDOT Consultant Evaluation (CE) internal application:"]
[]
[null,"https://ce.fdot.gov/"]
[null,"Access to the internal CE application for inputting performance evaluations \nis restricted to FDOT Project Managers."]
[]
[null,"PLANNING - QUALITY EVALUATION CRITERIA"]
[]
[null,"GENERAL PERFORMANCE RATING SCALE"]
[null,5,"Outstanding Performance",null,null,"   - Consultant consistently exceeded expectations."]
[null,4,"Above Satisfactory Performance",null,null,"   - Consultant consistently met, often exceeded, expectations."]
[null,3,"Satisfactory Performance",null,null,"   - Consultant consistently met expectations."]
[null,2,"Below Satisfactory Performance",null,null,"   - Consultant inconsistently met expectations."]
[null,1,"Unacceptable Performance",null,null,"   - Consultant consistently failed to meet expectations."]
[]
[null,"**{See specific performance measure guidelines within each Evaluation Criteria Section}**"]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M88","v":"Not Rated"},null,null,null,"Total Items:",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R62:R78)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Do not rate an evaluation item if it is not applicable to this evaluation. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated.  All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"Ability to collect traffic, highway and GIS data related to transportation planning.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M62=\"N/A\",\"\",(IF(M62=\"\",\"\",(IF(M62<3,\"COMMENTS REQUIRED\",(IF(M62>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M63=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"The consultant submitted acceptable products in accordance with the Department's schedule and accuracy standards and coordinated task assignments with minimal direction by Department Staff.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M65=\"N/A\",\"\",(IF(M65=\"\",\"\",(IF(M65<3,\"COMMENTS REQUIRED\",(IF(M65>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M66=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Ability to access and compile data (traffic, highway, GIS) using the Department's software systems (SPS, TCI, RCI, SLD, ArcGIS, etc.).",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M68>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M68=\"N/A\",\"\",(IF(M68=\"\",\"\",(IF(M68<3,\"COMMENTS REQUIRED\",(IF(M68>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M69=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Ability to use Department approved study techniques, computer resources and procedures to their fullest benefit to produce required reports.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M71=\"N/A\",\"\",(IF(M71=\"\",\"\",(IF(M71<3,\"COMMENTS REQUIRED\",(IF(M71>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M72=\"comments required\", 1,0)","v":0}]
[]
[null,null,5,"Ability to gather related data and apply project traffic forecasting techniques for development of future traffic.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M74=\"N/A\",\"\",(IF(M74=\"\",\"\",(IF(M74<3,\"COMMENTS REQUIRED\",(IF(M74>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M75=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Ability to convert highway, traffic, and other related data obtained by consultant for this project  into comprehensive information completely and accurately.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M77=\"N/A\",\"\",(IF(M77=\"\",\"\",(IF(M77<3,\"COMMENTS REQUIRED\",(IF(M77>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M78=\"comments required\", 1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M62:M78)=0),\"Not Rated\", AVERAGE(M62:M78))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M80=\"Not Rated\",\"\",(IF(O82>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O62:O78)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M80))","v":"Not Rated"}]