{"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":143,"n_cols":17,"rows_kept":143,"cut":false,"hidden":false,"merged":[[5,10,5,12],[7,10,7,12],[9,10,9,12],[144,1,144,12],[98,2,98,11],[103,2,103,11],[105,3,105,11],[106,3,106,11],[107,3,107,11],[121,2,121,12],[122,2,122,12],[67,3,67,11],[68,3,68,11],[70,1,70,12],[71,2,74,11],[25,10,25,12],[145,1,145,12],[124,2,124,11],[126,3,126,11],[127,3,127,11],[128,3,128,11],[129,3,129,11],[130,3,130,11],[131,3,131,11],[133,1,133,12],[140,1,140,11],[134,2,137,11],[7,4,7,8],[78,2,78,11],[11,4,11,8],[11,10,11,12],[27,1,27,12],[33,1,33,12],[36,12,38,12],[36,4,38,11],[24,1,24,12],[19,7,21,12],[44,1,44,12],[45,2,48,11],[61,2,61,11],[9,4,9,8],[85,3,85,11],[10,4,10,8],[10,10,10,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],[6,4,6,8],[6,10,6,12],[8,4,8,8],[8,10,8,12],[5,4,5,8],[84,3,84,11],[63,3,63,11],[64,3,64,11],[65,3,65,11],[66,3,66,11],[80,2,80,11],[82,3,82,11],[83,3,83,11],[59,2,59,12],[40,1,40,6],[40,10,40,12],[41,1,41,6],[54,1,55,12],[58,2,58,12],[109,3,109,11],[110,3,110,11],[112,1,112,12],[113,2,116,11],[101,2,101,12],[86,3,86,11],[87,3,87,11],[89,1,89,12],[90,2,93,11],[108,3,108,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,"NOTE: \nIf more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 4."]
[]
[]
[]
[]
[null,"NOTE: This worksheet provides guidance on the specific performance measures for the performance rating scale as it pertains to each evaluation item. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official "]
[null,"evaluation within the FDOT Consultant Evaluation (CE) internal application:",null,null,null,null,null,null,null,null,"https://psice.dot.state.fl.us/"]
[]
[null,"GENERAL PERFORMANCE RATING SCALE"]
[null,5,"Outstanding Performance"]
[null,4,"Above Satisfactory Performance",null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
[null,3,"Satisfactory Performance",null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,2,"Below Satisfactory Performance",null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,1,"Unacceptable Performance",null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"**{See specific performance measure guidelines within each evaluation item}**",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5]
[null,null,"Note: An overall score of 3 is considered satisfactory performance. The maximum score attainable is 5.",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,2.5]
[null,null,null,null,"TOTAL WEIGHTED SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,null,{"$f":"M141","v":"Not Rated"},null,null,2]
[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,1]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,"QUALITY EVALUATION CRITERIA"]
[null,"Instructions:"]
[null,"For each item below, please select a numerical score from 1 to 5 (0.5 point increments) in accordance with the performance rating scale for each item. Do not provide a rating for criteria that do not apply to this evaluation. \nSelect N/A if the item is not applicable. Comments must be entered for all items rated."]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","DESIGN PERSONNEL (25%)"]
[]
[null,null,"EXPECTATION:\nIndividuals listed as Engineer of Record, Designer and Design Checker are appropriate based on the bridge type and complexity of bridge being designed (Reference Rule 14-75).  At least one individual active in the design (e.g.  Engineer of Record, Designer or Design Checker) qualifies the Firm under the appropriate Work Group depending on the bridge type being designed.  For this evaluation, qualifiers under Work Group 4.1.2 is acceptable for individuals designing substructure components except for components designed with post tensioning, consisting of structural steel or designed for ship impact."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Design personnel qualifications far exceed FDOT expectations (i.e. significant experience in designing similar bridge types)."]
[null,null,4,"Design personnel qualifications exceed FDOT expectations (i.e. substantial experience in designing similar bridge types)."]
[null,null,3,"Design personnel qualifications met FDOT expectations (i.e. basic experience in designing similar bridge types)."]
[null,null,2,"Design personnel qualifications did not meet minimum FDOT expectations (i.e. little experience in designing similar bridge types)."]
[null,null,1,"Design personnel qualifications significantly missed minimum FDOT expectations (i.e. no or inadequate experience in designing similar bridge types)."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M70)=0),\"NA\",M70*0.25)","v":"NA"},{"$f":"IF(COUNT(P70)=0,-0.25,0)","v":-0.25}]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
[]
[null,"B.","QUALITY OF PHASE SUBMITTALS (25%)"]
[]
[null,null,"EXPECTATION:\n1. Minimize number of Phase Submittals are necessary prior to plan approval by the Department.  \n2. Phase Submittals are accurate, complete, and in compliance with the Structures Design Manual, AASHTO LRFD Bridge Design Code, and the FDOT Design Manual.\n3. Plan Submittals demonstrate that a thorough Quality Control Process was followed prior to submitting. \n4. Phase Submittals demonstrate knowledge of Department and District Procedures and demonstrate knowledge of the Structures Design Manual, AASHTO LRFD Bridge Design Code, and FDOT Design Manual requirements.\n5. Phase Submittals demonstrate properly coordination with other project design disciplines, and adjacent projects. \n6. Minimize the number of major ERC comments.  A major comment is defined as one that would result in a substantial change in the design.\n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the bridge design firm and the Department is encouraged.\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(M89)=0),\"NA\",M89*0.25)","v":"NA"},{"$f":"IF(COUNT(P89)=0,-0.25,0)","v":-0.25}]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C.","CALCULATION COMPLETENESS AND APPROPRIATENESS (25%)"]
[]
[null,null,"EXPECTATION:\nThe proposed structural concept results in a solution that exhibits transparent structural behavior (e.g. stress flow and load distribution is clear).  Design is based on good engineering practice.   Calculations accurately accounted for the complexity of the structure being designed.  Basis of calculations were properly coordinated and communicated in the plans.  Calculations were checked, initialed, dated, signed and sealed as appropriate.   Calculations included an index that was clear to follow.  Design assumptions and design references were clearly stated.    \n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the bridge design firm and the Department is encouraged.\n"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Design Calculations far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Design Calculations often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Design Calculations consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Design Calculations sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Design Calculations 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(M112)=0),\"NA\",M112*0.25)","v":"NA"},{"$f":"IF(COUNT(P112)=0,-0.25,0)","v":-0.25}]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"D.","PHASE SUBMITTAL CONTENT AND COMPLETENESS (25%)"]
[]
[null,null,"EXPECTATION:\nThe BDR/30%, 90%, and 100% Structural submittal content met the requirements of the FDOT Design Manual Chapter 121.  Piece-meal submittals were minimized.   Plan Submittals demonstrate that a thorough Quality Control Process was followed prior to submitting.  \n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the bridge 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,{"$f":"IF((COUNT(M133)=0),\"NA\",M133*0.25)","v":"NA"},{"$f":"IF(COUNT(P133)=0,-0.25,0)","v":-0.25}]
[null,"Comments:"]
[]
[]
[]
[]
[]
[]
[null,"Total Weighted Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(M70:M133)=0),\"Not Rated\",ROUND(SUM(P70:P133)/(1+SUM(Q70:Q133)),1))","v":"Not Rated"},null,null,{"$f":"ROUND(SUM(P70:P133),1)","v":0},{"$f":"ROUND(SUM(Q70:Q133),1)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q70:Q133))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P141/P142","v":{"$error":"#DIV/0!"}}]