{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Group 4 Structures"],"not_rendered":{"charts":0,"images":9,"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 4 Structures","index":0,"n_rows":148,"n_cols":18,"rows_kept":148,"cut":false,"hidden":false,"merged":[[145,8,145,11],[139,12,140,12],[49,12,50,12],[76,12,77,12],[95,12,96,12],[118,12,119,12],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[85,2,85,11],[72,3,72,11],[73,3,73,11],[75,1,75,12],[76,2,79,11],[114,3,114,11],[108,2,108,11],[110,3,110,11],[111,3,111,11],[112,3,112,11],[45,1,45,6],[89,3,89,11],[87,3,87,11],[88,3,88,11],[90,3,90,11],[103,2,103,11],[9,10,9,12],[63,2,63,12],[58,1,61,12],[150,1,150,12],[129,2,129,11],[131,3,131,11],[132,3,132,11],[133,3,133,11],[134,3,134,11],[135,3,135,11],[136,3,136,11],[138,1,138,12],[139,2,142,11],[149,1,149,12],[146,7,148,12],[40,12,42,12],[10,4,10,8],[10,10,10,12],[19,7,20,12],[40,5,42,11],[40,1,42,4],[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],[6,4,6,8],[6,10,6,12],[5,10,5,12],[8,4,8,8],[8,10,8,12],[5,4,5,8],[7,4,7,8],[44,10,44,12],[7,10,7,12],[23,1,24,12],[28,1,28,12],[25,1,25,12],[26,1,26,12],[9,4,9,8],[44,1,44,6],[11,4,11,8],[11,10,11,12],[30,1,30,12],[37,1,37,12],[127,2,127,10],[48,1,48,12],[115,3,115,11],[117,1,117,12],[118,2,121,11],[91,3,91,11],[92,3,92,11],[94,1,94,12],[95,2,98,11],[113,3,113,11],[64,2,64,10],[106,2,106,10],[83,2,83,10],[49,2,52,11],[66,2,66,11],[126,2,126,12]]}
[]
[]
[]
[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 4."]
[]
[]
[]
[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,"STRUCTURES QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",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,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,"Scores are required for all sections. The TOTAL WEIGHTED SCORE will ONLY be shown once ALL sections are scored.",null,null,null,"TOTAL WEIGHTED SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M146","v":"Not Rated"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",null,{"$f":"COUNT(M138,M117,M94,M75)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M41=\"not rated\",\"\",(IF(M41=\"\",\"\",(IF(M41<3,\"COMMENTS REQUIRED\",(IF(M41>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[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\nPLEASE NOTE:  Work Group 4 evaluators are REQUIRED to provide a rating score for each evaluation item.  Additionally, the Central Office Structures Design Office (SDO) Plans Review Group MUST conduct the Consultant Evaluation for Consultants Designing Category 2 Structures.  "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","COMPLIANCE WITH TECHNICAL CRITERIA  ",null,null,null,null,null,null,null,null,"(30%)"]
[]
[null,null,"EXPECTATION:\nStructural design was in accordance with engineering standards, guidance, and criteria set forth in project technical requirements. Plans Submittals were in compliance with required detailing and design procedures, including applicable Department and AASHTO publications. Consultant demonstrated a sound understanding of relevant governing regulations, contract documents, project site, and design constraints. Minimal corrections necessary during the plans review process to provide a solution compliant with all design and detailing requirements."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Compliance with technical criteria far exceeded FDOT expectations. Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Compliance with technical criteria exceeded FDOT expectations. Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Compliance with technical criteria met FDOT expectations. Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Compliance with technical criteria did not meet minimum FDOT expectations. Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Compliance with technical criteria significantly missed minimum 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,{"$f":"IF((COUNT(M75)=0),\"NA\",M75*0.3)","v":"NA"},{"$f":"IF(COUNT(P75)=0,-0.3,0)","v":-0.3}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M75=\"N/A\",\"\",(IF(M75=\"\",\"\",(IF(M75<3,\"COMMENTS REQUIRED\",(IF(M75>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,"B.","QUALITY CONTROL, ORGANIZATION AND COMPLETENESS OF SUBMITTALS",null,null,null,null,null,null,null,null,"(35%)"]
[]
[null,null,"EXPECTATION:\nPlan Submittals were accurate, complete, and properly detailed in accordance with the scope of services. Calculations were organized, with all pertinent design assumptions, methodology, and references clearly documented. Phase Submittals demonstrated thorough quality control/assurance processes were completed and effective. Submittals required minimal corrections or repeat comments to provide a compliant design.\n "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Phase Submittals far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Phase Submittals often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Phase Submittals consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Phase Submittals sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Phase Submittals 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,{"$f":"IF((COUNT(M94)=0),\"NA\",M94*0.35)","v":"NA"},{"$f":"IF(COUNT(P94)=0,-0.35,0)","v":-0.35}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M94=\"N/A\",\"\",(IF(M94=\"\",\"\",(IF(M94<3,\"COMMENTS REQUIRED\",(IF(M94>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C.","DESIGN APPROACH – \nENGINEERING JUDGEMENT / INNOVATION / OVERCOMING CHALLENGES  ",null,null,null,null,null,null,null,null,"(15%)"]
[]
[null,null,"EXPECTATION:\nDesign personnel developed a cost-effective, context appropriate structural solution based on project constraints and applicable design criteria. Individuals involved with the design demonstrated sound engineering judgement, and possessed the knowledge, skills and experience necessary given the structure type and complexity. Design assumptions and calculations accurately accounted for the complexity of the structure being designed. Analysis / design software utilized, as well as all modeling assumptions considered for the analysis, were appropriate based on the structure type and complexity. When necessary, innovation and “out-of-the-box” thinking was employed to develop a transparent structural solution to solve challenging design problems. \n\nNOTE TO EVALUATOR: The design of miscellaneous and minor bridge structures may not involve high levels of flexibility to incorporate innovation, however the design may be evaluated based on the consultant’s use of engineering judgement and how challenges were overcome. It is suggested to clarify in the comments what was specifically considered in the evaluation. \n"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Design approach  far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Design approach often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Design approach consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Design approach sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Design approach 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,{"$f":"IF((COUNT(M117)=0),\"NA\",M117*0.15)","v":"NA"},{"$f":"IF(COUNT(P117)=0,-0.15,0)","v":-0.15}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M117=\"N/A\",\"\",(IF(M117=\"\",\"\",(IF(M117<3,\"COMMENTS REQUIRED\",(IF(M117>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"D.","COMMUNICATION AND INTERACTION ",null,null,null,null,null,null,null,null," (20%)"]
[]
[null,null,"EXPECTATION:\nDesign personnel demonstrated professionalism and cooperation while resolving Department generated comments, and proactively engaged relevant Department personnel when necessary to achieve the project deliverables and objectives. Design personnel properly coordinated with other project design disciplines and adjacent projects."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Communication and interaction far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Communication and interaction often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Communication and interaction consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Communication and interaction sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Communication and interaction 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,{"$f":"IF((COUNT(M138)=0),\"NA\",M138*0.2)","v":"NA"},{"$f":"IF(COUNT(P138)=0,-0.2,0)","v":-0.2}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M138=\"N/A\",\"\",(IF(M138=\"\",\"\",(IF(M138<3,\"COMMENTS REQUIRED\",(IF(M138>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Weighted Score:",null,null,null,{"$f":"IF((COUNT(M75:M138)=0),\"Not Rated\",IF((COUNT(M75:M138)=4),ROUND(SUM(P75:P138)/(1+SUM(Q75:Q138)),1),\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"ROUND(SUM(P75:P138),3)","v":0},{"$f":"ROUND(SUM(Q75:Q138),2)","v":-1}]
[null,null,null,null,null,null,null,"Reminder: Work Group 4 evaluators are required to provide a rating score for each evaluation item. ",null,null,null,null,null,null,null,{"$f":"(1+SUM(Q75:Q138))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P146/P147","v":{"$error":"#DIV/0!"}}]