{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Group 2 PD&E"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Group 2 PD&E","index":0,"n_rows":117,"n_cols":19,"rows_kept":117,"cut":false,"hidden":false,"merged":[[104,3,104,11],[106,1,106,12],[107,2,110,11],[41,1,41,12],[84,3,84,11],[85,3,85,11],[87,1,87,12],[88,2,91,11],[102,3,102,11],[95,2,95,10],[107,12,108,12],[50,1,53,12],[69,12,70,12],[88,12,89,12],[69,2,72,11],[57,2,57,12],[76,2,76,10],[97,2,97,11],[99,3,99,11],[59,2,59,11],[119,1,119,12],[114,1,114,11],[118,1,118,12],[68,1,68,12],[103,3,103,11],[82,3,82,11],[80,3,80,11],[81,3,81,11],[83,3,83,11],[100,3,100,11],[101,3,101,11],[78,2,78,11],[4,1,4,3],[4,4,4,8],[4,10,4,12],[6,10,6,12],[5,10,5,12],[5,4,5,8],[6,4,6,8],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12],[37,10,37,12],[17,1,18,12],[19,1,19,12],[22,1,22,12],[8,10,8,12],[37,1,37,6],[8,4,8,8],[9,4,9,8],[7,10,7,12],[9,10,9,12],[24,1,24,12],[30,1,30,12],[33,12,35,12],[33,4,35,11],[20,1,20,12],[7,4,7,8],[38,1,38,6],[56,2,56,12],[42,2,45,11],[65,3,65,11],[66,3,66,11],[61,3,61,11],[62,3,62,11],[63,3,63,11],[64,3,64,11]]}
[]
[]
[]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[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 is restricted to FDOT Project Managers."]
[]
[null,"PROJECT DEVELOPMENT AND ENVIRONMENT (PD&E) 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,null,null,null,null,null,null,null,null,null,5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,null,4.5]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,null,4]
[null,"**{See specific performance measure guidelines within each criteria item}**",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]
[null,null,null,null,"TOTAL AVERAGE SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,null,{"$f":"M115","v":"Not Rated"},null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[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. \n"]
[]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","ANALYSIS AND DOCUMENTATION OF PHYSICAL, NATURAL, SOCIAL, AND CULTURAL IMPACTS",null,null,null,null,null,null,null,null,null,null,null,null,0.33329999999999999]
[]
[null,null,"EXPECTATION:\n1.  Deliverables to be considered may include the Environmental Document, Noise Study Report, Contamination \n     Screening Evaluation Report, Natural Resource Evaluation, Sociocultural Effects Evaluation, Cultural Resources \n     Assessment Surveys, etc.\n2.  Analysis, reports, and stakeholder/agency documentation were completed as required by the scope and Project \n     Development and Environment (PD&E) Manual.\n3.  Consultant demonstrated understanding and application of federal and state project development and\n     environmental laws, regulations, policies, procedures, and standards as they pertain to the PD&E project delivery \n     process.\n4.  Consultation and coordination with the Department, regulatory agencies, and other stakeholders were successfully \n     completed as required by the scope of services as well as the PD&E Manual. \n5.  Demonstrated that a thorough quality control process was followed prior to submittals.\n6.  Minimized the number of review comments, especially major comments.  A major comment is defined as one that \n     would result in a substantial change in the document or cause a delay in the schedule due to performance of \n     additional work efforts and/or agency review.\n7.  Minimized the number of re-submittals necessary prior to document approval by the Department."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Analysis, documentation, and coordination with FDOT and regulatory agencies far exceeded FDOT expectations, requirements, and guidelines."]
[null,null,4,"Analysis, documentation, and coordination with FDOT and regulatory agencies often exceeded FDOT expectations, requirements, and guidelines.  "]
[null,null,3,"Analysis, documentation, and coordination with FDOT and regulatory agencies consistently achieved FDOT expectations, requirements, and guidelines.  "]
[null,null,2,"Analysis, documentation, and coordination with FDOT and regulatory agencies sometimes did not achieve FDOT expectations, requirements, and guidelines.  "]
[null,null,1,"Analysis, documentation, and coordination with FDOT and regulatory agencies consistently did not achieve FDOT expectations, requirements, and guidelines.  "]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M68)=0),\"NA\",M68*P58)","v":"NA"},{"$f":"IF(COUNT(Q68)=0,-P58,0)","v":-0.33329999999999999},{"$f":"IF((COUNT(M68)=0),\"\",M68)","v":""}]
[null,"Comments:"]
[null,null,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,"B.","ANALYSIS AND DOCUMENTATION OF ALTERNATIVES DEVELOPMENT, TRAFFIC ANALYSIS AND ENGINEERING ANALYSIS",null,null,null,null,null,null,null,null,null,null,null,null,0.33329999999999999]
[]
[null,null,"EXPECTATION:\n1.   Deliverables to be considered may include the Concept Plans, Typical Section package, Preliminary Engineering\n      Report, Stormwater Management Alternatives Report, Pond Siting Report, Location Hydraulics Report, \n      Geotechnical Reports, Utility Assessment Package, Project Traffic Analysis Report, etc.\n2.   Preliminary Engineering Design documentation demonstrate knowledge and requirements of the AASHTO A \n      Policy on Geometric Design of Highways and Streets (AASHTO Green Book), Florida Manual of Uniform Minimum \n      Standards for Design, Construction and Maintenance (Florida Greenbook), FDOT Standard Plans for Road and \n      Bridge Construction, the FDOT Design Manual,  FDOT Traffic Analysis Handbook, FDOT Drainage Manual and \n      other manual requirements, procedures, topics, and Scope of Services expectations as applicable.\n3.   Demonstrated proper coordination with other project disciplines and adjacent projects. \n4.   Demonstrated that a thorough quality control process was followed prior to submittals.\n5.   Minimized the number of review comments, especially major comments.  A major comment is defined as one that \n      would result in a substantial change in the preliminary design or document or cause a delay in the schedule due to \n      performance of additional work efforts and/or agency review.\n6.   Minimized the number of re-submittals necessary prior to document approval by the Department."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Alternatives development, traffic analysis, engineering analysis and coordination with FDOT far exceeded FDOT expectations, requirements, and guidelines.  "]
[null,null,4,"Alternatives development, traffic analysis, engineering analysis, and coordination with FDOT often exceeded FDOT expectations, requirements, and guidelines."]
[null,null,3,"Alternatives development, traffic analysis, engineering analysis, and coordination with FDOT consistently achieved FDOT expectations, requirements, and guidelines.  "]
[null,null,2,"Alternatives development, traffic analysis, engineering analysis, and coordination with FDOT sometimes did not achieve FDOT expectations, requirements, and guidelines.  "]
[null,null,1,"Alternatives development, traffic analysis, engineering analysis, and coordination with FDOT consistently did not achieve FDOT expectations, requirements, and guidelines.  "]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M87)=0),\"NA\",M87*P77)","v":"NA"},{"$f":"IF(COUNT(Q87)=0,-P77,0)","v":-0.33329999999999999},{"$f":"IF((COUNT(M87)=0),\"\",M87)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M87=\"N/A\",\"\",(IF(M87=\"\",\"\",(IF(M87<3,\"COMMENTS REQUIRED\",(IF(M87>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"C.","PUBLIC INVOLVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,0.33329999999999999]
[]
[null,null,"EXPECTATION:\n1.    Deliverables to be considered may include the Public Involvement Plan, newsletters, project website, stakeholder \n       meetings, Alternatives Meeting activities and documentation, Public Hearing activities and documentation, \n       miscellaneous stakeholder meeting materials, Public Involvement Activities Report, Responses to comments, etc.\n2.    Deliverables were completed as required by the scope and PD&E Manual. \n3.    Demonstrated that a thorough quality control process was followed prior to submittals.\n4.    Successfully identified and engaged all the affected communities and stakeholders.\n5.    Meetings were well organized and informative.\n6.    Meeting notifications and invitations were sent on time and in accordance with the PD&E Manual."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"The Public Involvement Plan, public meetings, stakeholder meetings and coordination with FDOT far exceeded FDOT expectations, requirements, and guidelines.  "]
[null,null,4,"The Public Involvement Plan, public meetings, stakeholder meetings and coordination with FDOT often exceeded FDOT expectations, requirements, and guidelines.  "]
[null,null,3,"The Public Involvement Plan, public meetings, stakeholder meetings and coordination with FDOT consistently achieved FDOT expectations, requirements, and guidelines.  "]
[null,null,2,"The Public Involvement Plan, public meetings, stakeholder meetings and coordination with FDOT sometimes did not achieve FDOT expectations, requirements, and guidelines.  "]
[null,null,1,"The Public Involvement Plan, public meetings, stakeholder meetings and coordination with FDOT consistently did not achieve FDOT expectations, requirements, and guidelines.  "]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M106)=0),\"NA\",M106*P96)","v":"NA"},{"$f":"IF(COUNT(Q106)=0,-P96,0)","v":-0.33329999999999999},{"$f":"IF((COUNT(M106)=0),\"\",M106)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M106=\"N/A\",\"\",(IF(M106=\"\",\"\",(IF(M106<3,\"COMMENTS REQUIRED\",(IF(M106>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"Total Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(M68:M113)=0),\"Not Rated\",ROUND(SUM(Q68:Q113)/(1+SUM(R68:R113)),1))","v":"Not Rated"},null,null,null,{"$f":"ROUND(SUM(Q68:Q113),3)","v":0},{"$f":"ROUND(SUM(R68:R113),2)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(R68:R113))","v":9.9999999999988987E-5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Q115/Q116","v":0},null,{"$f":"ROUND(AVERAGE(S68:S113),1)","v":{"$error":"#DIV/0!"}}]