{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Group 3 Roadway"],"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 3 Roadway","index":0,"n_rows":251,"n_cols":19,"rows_kept":251,"cut":false,"hidden":false,"merged":[[128,12,129,12],[147,12,148,12],[166,12,167,12],[185,12,186,12],[204,12,205,12],[223,12,224,12],[242,12,243,12],[63,3,63,11],[64,3,64,11],[65,3,65,11],[66,3,66,11],[80,2,80,11],[230,2,230,10],[106,3,106,11],[108,1,108,12],[109,2,112,11],[139,3,139,11],[140,3,140,11],[141,3,141,11],[161,3,161,11],[162,3,162,11],[163,3,163,11],[165,1,165,12],[43,1,43,12],[86,3,86,11],[87,3,87,11],[89,1,89,12],[90,2,93,11],[104,3,104,11],[59,2,59,10],[97,2,97,10],[109,12,110,12],[52,1,55,12],[71,12,72,12],[90,12,91,12],[71,2,74,11],[105,3,105,11],[84,3,84,11],[82,3,82,11],[83,3,83,11],[85,3,85,11],[102,3,102,11],[103,3,103,11],[78,2,78,10],[99,2,99,11],[101,3,101,11],[61,2,61,11],[253,1,253,12],[232,2,232,11],[234,3,234,11],[235,3,235,11],[236,3,236,11],[237,3,237,11],[238,3,238,11],[239,3,239,11],[241,1,241,12],[248,1,248,11],[242,2,245,11],[252,1,252,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[6,4,6,8],[6,10,6,12],[5,10,5,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12],[8,4,8,8],[8,10,8,12],[5,4,5,8],[7,4,7,8],[39,10,39,12],[7,10,7,12],[19,1,20,12],[21,1,21,12],[24,1,24,12],[10,4,10,8],[10,10,10,12],[9,10,9,12],[11,10,11,12],[26,1,26,12],[32,1,32,12],[35,12,37,12],[35,4,37,11],[14,7,16,12],[9,4,9,8],[39,1,39,6],[11,4,11,8],[22,1,22,12],[40,1,40,6],[58,2,58,12],[44,2,47,11],[229,2,229,12],[67,3,67,11],[68,3,68,11],[70,1,70,12],[123,3,123,11],[124,3,124,11],[125,3,125,11],[127,1,127,12],[128,2,131,11],[116,2,116,10],[118,2,118,11],[120,3,120,11],[121,3,121,11],[122,3,122,11],[142,3,142,11],[143,3,143,11],[144,3,144,11],[146,1,146,12],[147,2,150,11],[135,2,135,10],[137,2,137,11],[166,2,169,11],[154,2,154,10],[156,2,156,11],[158,3,158,11],[159,3,159,11],[160,3,160,11],[180,3,180,11],[181,3,181,11],[182,3,182,11],[184,1,184,12],[185,2,188,11],[173,2,173,10],[175,2,175,11],[177,3,177,11],[178,3,178,11],[179,3,179,11],[199,3,199,11],[200,3,200,11],[201,3,201,11],[203,1,203,12],[204,2,207,11],[192,2,192,10],[194,2,194,11],[196,3,196,11],[197,3,197,11],[198,3,198,11],[218,3,218,11],[219,3,219,11],[220,3,220,11],[222,1,222,12],[223,2,226,11],[211,2,211,10],[213,2,213,11],[215,3,215,11],[216,3,216,11],[217,3,217,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,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 3."]
[]
[]
[]
[]
[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 is restricted to FDOT Project Managers."]
[]
[null,"ROADWAY 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":"M249","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. 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.","GEOMETRIC/ENGINEERING REPORTS AND DESIGN DOCUMENTATION  ",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tDeliverables to be considered include Variations/Exceptions, Geotechnical/Soils Evaluation, Pavement Design Report, RRR Report, Design Documentation Report, etc. \n2.   \tGeometrics and Engineering documentation demonstrate knowledge and requirements of the AASHTO A Policy on Geometric Design of Highways and Streets (AASHTO Green Book), Florida Manual of Uniform Minimum Standards for Design, Construction and Maintenance (Florida Greenbook), FDOT Standard Plans for Road and Bridge Construction, the FDOT Design Manual, and other manual requirements as applicable. \n3.  \tCoordination with PM prior to the official submittal. Identifies design approach/issues/problems, ensures report content correlates with project requirements, makes recommendations when scope change occurs. \n    a.  \tErrors Described as: Major error = wrong functional class, wrong road name, design criteria error, wrong county, major elements missing from report, incomplete forms; Minor error = spelling, format, grammar.\n\nNote: Meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the consultant and the Department is encouraged."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Geometric Engineering Reports and Design Documentation far exceeded FDOT expectations, requirements and guidelines.  No errors observed.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Geometric Engineering Reports and Design Documentation often exceeded FDOT expectations, requirements and guidelines.  Average number of minor errors observed.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Geometric Engineering Reports and Design Documentation consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Geometric Engineering Reports and Design Documentation sometimes achieved FDOT expectations.  Some major errors and minor errors.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Geometric Engineering Reports and Design Documentation consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT.\t"]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M70)=0),\"NA\",M70*P60)","v":"NA"},{"$f":"IF(COUNT(Q70)=0,-P60,0)","v":-0.1},{"$f":"IF((COUNT(M70)=0),\"\",M70)","v":""}]
[null,"Comments:"]
[null,null,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,"B.","PHASE SUBMITTALS",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tMinimize number of Re-submittals necessary prior to plan approval by the Department.  \n2.   \tAccurate, complete, and in compliance with the FDOT Design Manual.  \n3.   \tDemonstrate that a thorough Quality Control Process was followed prior to submitting.  \n4.   \tDemonstrate knowledge of Department and District Procedures and demonstrate knowledge of the FDOT Design\n     \t Manual requirements for phase submittals and plans production.\n5.   \tDemonstrate proper coordination with other project design disciplines, and adjacent projects.  \n6.   \tMinimize the number of major ERC comments.  A major comment is defined as one that would result in a\n     \t substantial change in the design.  \nNote: In general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the design firm and the Department is encouraged."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Phase Submittal Content far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Phase Submittal Content often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Phase Submittal Content consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Phase Submittal Content sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Phase Submittal Content consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M89)=0),\"NA\",M89*P79)","v":"NA"},{"$f":"IF(COUNT(Q89)=0,-P79,0)","v":-0.1},{"$f":"IF((COUNT(M89)=0),\"\",M89)","v":""}]
[null,"Comments:"]
[null,null,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,"C.","ROADWAY DRAINAGE DESIGN AND OVERALL STORMWATER MANAGEMENT ANALYSIS/DOCUMENTATION  ",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tFollows District specific Drainage Design practices and any District specific guidelines.\n2.   \tFollows District Environmental Permit Information Manual, Department’s Drainage Manual, and permitting\n     \t agencies' procedures and guidelines.\n3.   \tDrainage Report content correlates with construction plans.\n4.   \tIncludes all required documentation and calculations in the Drainage Report.\n"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Roadway Drainage Design and overall Stormwater Management Analysis/Documentation far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Roadway Drainage Design and overall Stormwater Management Analysis/Documentation often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Roadway Drainage Design and overall Stormwater Management Analysis/Documentation consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Roadway Drainage Design and overall Stormwater Management Analysis/Documentation sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Roadway Drainage Design and overall Stormwater Management Analysis/Documentation consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M108)=0),\"NA\",M108*P98)","v":"NA"},{"$f":"IF(COUNT(Q108)=0,-P98,0)","v":-0.1},{"$f":"IF((COUNT(M108)=0),\"\",M108)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M108=\"N/A\",\"\",(IF(M108=\"\",\"\",(IF(M108<3,\"COMMENTS REQUIRED\",(IF(M108>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"D.","ENVIRONMENTAL PERMITTING SERVICES (WATER MANAGEMENT DISTRICT, CORPS. OF ENGINEERS, USCG, LOCAL PERMITS, ETC.)",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tThorough understanding of permitting agencies processes, criteria, permit package expectations\n2.   \tProactive in meeting with Drainage and Environmental staff and provide input on agencies possible needs,\n     \t feedback, requirements, etc.\n3.   \tProactively set up and conduct meetings with agencies and their staff to confirm and document permit\n     \t requirements and provide permit documentations (incl. invitations, agendas, meeting minutes, and follow-up\n     \t items when needed).\n4.   \tWorks independently, provide recommendations without FDOT assistance.\n5.   \tWorks independently, provides recommendations with less than expected level of FDOT staff involvement.\n6.   \tCome to meetings with agenda, ready to discuss issues with proposals and follows up on all issues. "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Environmental Permitting Services (Water Management District, Corps of Engineers, USCG, Local Permits, etc.) far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Environmental Permitting Services (Water Management District, Corps of Engineers, USCG, Local Permits, etc.) often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Environmental Permitting Services (Water Management District, Corps of Engineers, USCG, Local Permits, etc.) consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Environmental Permitting Services (Water Management District, Corps of Engineers, USCG, Local Permits, etc.) sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Environmental Permitting Services (Water Management District, Corps of Engineers, USCG, Local Permits, etc.) consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M127)=0),\"NA\",M127*P117)","v":"NA"},{"$f":"IF(COUNT(Q127)=0,-P117,0)","v":-0.1},{"$f":"IF((COUNT(M127)=0),\"\",M127)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M127=\"N/A\",\"\",(IF(M127=\"\",\"\",(IF(M127<3,\"COMMENTS REQUIRED\",(IF(M127>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"E.","UTILITY COORD./ADJUSTMENTS AND UTILITY AGREEMENTS AND WORK SCHEDULES",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tMinimizing the need for relocation of utilities through design. \n2.   \tUnderstanding utility guidelines and engineering considerations.\n3.   \tHave a clear understanding of utilities in corridor (permit/easement).\n4.   \tProactively resolve utilities conflicts.\n5.   \tIdentify and thoroughly coordinate with all owners needed to clear utilities.\n6.   \tAchieve receipt of all agreements and schedules.\n7.\tPrepare conflict spread sheet and resolved possible conflicts by discussing with utility or providing a solution that may require a field conflict resolution as the preparation of the “Utility work by highway contractor” agreement.   \t\n8.   \tAchieve Utility certification by Phase III/Bidability/90% Plans of all utility work.\n9.   \tProactive to process and advise FDOT PM of non-responsive utilities.      \t \n10. \tAssist utilities in utilities schedules if needed."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Utility Coordination/Adjustments and Utility Agreements and Work Schedules far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Utility Coordination/Adjustments and Utility Agreements and Work Schedules often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Utility Coordination/Adjustments and Utility Agreements and Work Schedules consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Utility Coordination/Adjustments and Utility Agreements and Work Schedules sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Utility Coordination/Adjustments and Utility Agreements and Work Schedules consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M146)=0),\"NA\",M146*P136)","v":"NA"},{"$f":"IF(COUNT(Q146)=0,-P136,0)","v":-0.1},{"$f":"IF((COUNT(M146)=0),\"\",M146)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M146=\"N/A\",\"\",(IF(M146=\"\",\"\",(IF(M146<3,\"COMMENTS REQUIRED\",(IF(M146>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"F.","TRAFFIC CONTROL PLANS/MAINTENANCE OF TRAFFIC",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tFollow Department standards, criteria and district practices in delivering the plans. \n2.   \tPrepare a conceptual plan and coordinated review with FDOT PM, District construction and Operation Center.   \n3.   \tAchieve TCP approval with minimal comments.\n4.   \tPrepared lane closure analysis w/seasonal impact if practical. \n5.   \tDemonstrate awareness of interstate/special case requirements if applicable.  "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Traffic Control Plans/Maintenance of Traffic far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Traffic Control Plans/Maintenance of Traffic often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Traffic Control Plans/Maintenance of Traffic consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Traffic Control Plans/Maintenance of Traffic sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Traffic Control Plans/Maintenance of Traffic consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M165)=0),\"NA\",M165*P155)","v":"NA"},{"$f":"IF(COUNT(Q165)=0,-P155,0)","v":-0.1},{"$f":"IF((COUNT(M165)=0),\"\",M165)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M165=\"N/A\",\"\",(IF(M165=\"\",\"\",(IF(M165<3,\"COMMENTS REQUIRED\",(IF(M165>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"G.","RIGHT OF WAY REQUIREMENTS AND COORDINATION ANALYSIS/DOCUMENTATION",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tFollow Department standards, Right of Way Procedure Manual, criteria and district practices in delivering   \n     \t the plans, specifically related to identification of existing and proposed right of way conditions.   \t\n2.   \tReview the existing ROW Maps provided or available in the District or County to understand the existing corridor    \n     \t available ROW and field review to advise of possible concerns.  \t\n3.   \tIdentify need for a Maintenance map during Initial engineering process.     \t\n4.   Properly communicate Surveying concerns prior to start of field work to assure all possible issues are addressed.  \n5.   \tField verify the survey prepared to assure ROW is compliant to corridor project needs.   \t"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Right of Way Requirements and Coordination Analysis/Documentation far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Right of Way Requirements and Coordination Analysis/Documentation often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Right of Way Requirements and Coordination Analysis/Documentation consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Right of Way Requirements and Coordination Analysis/Documentation sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Right of Way Requirements and Coordination Analysis/Documentation consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M184)=0),\"NA\",M184*P174)","v":"NA"},{"$f":"IF(COUNT(Q184)=0,-P174,0)","v":-0.1},{"$f":"IF((COUNT(M184)=0),\"\",M184)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M184=\"N/A\",\"\",(IF(M184=\"\",\"\",(IF(M184<3,\"COMMENTS REQUIRED\",(IF(M184>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"H.","PAY ITEMS AND QUANTITIES",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tCompleted quantities and pay items as required per each phase submittal. \t\n2.   \tPay Item calculations are accurate and received a quality control review.\t\n3.   \tQuantities and Pay items are consistent with plans. \t\n4.   \tAddress phase review comments at production with no required corrections.\n5.   \tAll pay items are current based on Basis of Estimate."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Pay Items and Quantities work far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Pay Items and Quantities work often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Pay Items and Quantities work consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Pay Items and Quantities work sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Pay Items and Quantities work consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M203)=0),\"NA\",M203*P193)","v":"NA"},{"$f":"IF(COUNT(Q203)=0,-P193,0)","v":-0.1},{"$f":"IF((COUNT(M203)=0),\"\",M203)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M203=\"N/A\",\"\",(IF(M203=\"\",\"\",(IF(M203<3,\"COMMENTS REQUIRED\",(IF(M203>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"I.","MAINTAIN AND UPDATE CONSTRUCTION COST ESTIMATES AND OVERALL PROJECT FUNDING NEEDS (TIP/STIP, LOCAL AGENCIES, UAOS, ETC.)",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tScope of work and LRE consistent.\n2.   \tSubmit engineer’s estimate at Phase III/Bidability/90% Plans and Phase IV/Production/100% Plans with no errors   \n     \t or comments.   \t\n3.   \tSubmit lump sum items break down costs with no errors or comments. \t\n4.   \tMeet schedule submittal dates for work program updates (TIP/STIP).\n5.   \tMeet schedule submittal dates for phase review updates.\n6.   \tEarly update ROW estimate for projects involving ROW. \t"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Effort to maintain and update construction cost estimates and overall project funding needs (TIP/STIP, Local, Agencies, UAOs, etc.) far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Effort to maintain and update construction cost estimates and overall project funding needs (TIP/STIP, Local, Agencies, UAOs, etc.) often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Effort to maintain and update construction cost estimates and overall project funding needs (TIP/STIP, Local, Agencies, UAOs, etc.) consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Effort to maintain and update construction cost estimates and overall project funding needs (TIP/STIP, Local, Agencies, UAOs, etc.) sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Effort to maintain and update construction cost estimates and overall project funding needs (TIP/STIP, Local, Agencies, UAOs, etc.) consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M222)=0),\"NA\",M222*P212)","v":"NA"},{"$f":"IF(COUNT(Q222)=0,-P212,0)","v":-0.1},{"$f":"IF((COUNT(M222)=0),\"\",M222)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M222=\"N/A\",\"\",(IF(M222=\"\",\"\",(IF(M222<3,\"COMMENTS REQUIRED\",(IF(M222>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"J.","SPECIFICATIONS",null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[]
[null,null,"EXPECTATION:\n1.   \tSubmit developmental spec with no errors.\n2.   \tSubmit modified spec with no errors.\n3.   \tSpecification package complete with no errors and no re-submittals.\n4.   \tAll required TSP’s included with Specifications submittal Package.\n5.   \tSpecifications package delivered early or on time.\n6.   \tInclude all applicable items in production complete checklist."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Specifications work far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Specifications work often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Specifications work consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Specifications work sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Specifications work consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,null,{"$f":"IF((COUNT(M241)=0),\"NA\",M241*P231)","v":"NA"},{"$f":"IF(COUNT(Q241)=0,-P231,0)","v":-0.1},{"$f":"IF((COUNT(M241)=0),\"\",M241)","v":""}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M241=\"N/A\",\"\",(IF(M241=\"\",\"\",(IF(M241<3,\"COMMENTS REQUIRED\",(IF(M241>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[null,"Total Average Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(M70:M241)=0),\"Not Rated\",ROUND(SUM(Q70:Q241)/(1+SUM(R70:R241)),1))","v":"Not Rated"},null,null,null,{"$f":"ROUND(SUM(Q70:Q241),3)","v":0},{"$f":"ROUND(SUM(R70:R241),2)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(R70:R241))","v":1.1102230246251565E-16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Q249/Q250","v":0},null,{"$f":"ROUND(AVERAGE(S70:S241),1)","v":{"$error":"#DIV/0!"}}]