{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["9.1 Soil Exploration","9.2 Geo. Classif. Lab Testing","9.3 HIghway Materials Testing","9.4.1 Std. Foundation Studies","9.4.2 NRDS BridgeFoundatStudies","9.5 Geo. Specialty Lab Testing"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"9.1 Soil Exploration","index":0,"n_rows":121,"n_cols":18,"rows_kept":121,"cut":false,"hidden":false,"merged":[[110,1,110,2],[75,3,75,11],[81,3,81,11],[79,12,80,12],[82,1,82,2],[82,3,82,11],[82,12,83,12],[78,3,78,11],[79,1,79,2],[79,3,79,11],[76,3,76,11],[89,3,89,11],[89,12,90,12],[100,3,100,11],[101,1,101,2],[101,3,101,11],[98,1,98,12],[91,3,91,11],[92,1,92,2],[92,3,92,11],[92,12,93,12],[109,3,109,11],[103,3,103,11],[104,1,104,2],[104,3,104,11],[104,12,105,12],[106,3,106,11],[107,1,107,2],[107,3,107,11],[101,12,102,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12],[110,3,110,11],[110,12,111,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],[39,1,39,6],[39,10,39,12],[40,1,40,6],[22,1,22,12],[8,4,8,8],[88,3,88,11],[89,1,89,2],[84,3,84,11],[11,4,11,8],[11,10,11,12],[19,1,20,12],[21,1,21,12],[24,1,24,12],[8,10,8,12],[9,4,9,8],[9,10,9,12],[10,4,10,8],[10,10,10,12],[43,1,43,12],[44,2,47,11],[44,12,45,12],[53,1,56,12],[58,2,58,10],[51,2,51,12],[26,1,26,12],[33,1,33,12],[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],[70,12,71,12],[72,3,72,11],[73,1,73,2],[73,3,73,11],[73,12,74,12],[62,3,62,11],[60,3,60,11],[61,3,61,11],[120,8,120,11],[65,3,65,11],[68,2,68,11],[69,3,69,11],[70,1,70,2],[70,3,70,11],[64,3,64,11],[63,3,63,11],[114,2,117,11],[113,1,113,11],[94,3,94,11],[95,1,95,2],[95,3,95,11],[114,12,115,12],[85,1,85,2],[85,3,85,11]]}
[]
[]
[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,"SOIL EXPLORATION - 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":"M121","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:R110)","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,"A.","Soil Exploration"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Soil exploration process far exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Soil exploration process often exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Soil exploration process consistently achieved FDOT requirements and guidelines.  Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Soil exploration process sometimes achieved FDOT requirements and guidelines.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Soil exploration process 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,"Appropriately document the collection, review and presentation of all relevant available information on the project (topographic maps, USDA NRCS maps, aerial photographs, groundwater data, geology bulletins, pile driving records, soil boring database, existing plans, etc.).",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,"Develop a boring location plan for FDOT approval, locate utilities, coordinate field operations, manage MOT, obtain drilling permits, notify property owners, conduct site reconnaissance. ",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,"Perform adequate depth Roadway Soil Survey and Structures borings/soundings/surveys in all areas contractor must excavate or construct: record stabilized groundwater levels, delineate horizontal and vertical limits of non-select material, determine latitude/longitude of roadway borings, coordinate with the surveyor to determine latitude/longitude of structures borings, follow standard procedures (ASTM, AASHTO, FM, Soils & Foundations Handbook, etc.)",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,"Collect SPT-N values and soil samples at the proper frequencies for bridge, miscellaneous structure and roadway soil stratification, LBR &/or resilient modulus testing, corrosion testing, D50, strength & compressibility testing, follow standard FM, AASHTO & ASTM sampling procedures unless otherwise described in the Soils & Foundation Handbook.",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,"Perform on-site investigations, field permeability tests, double ring infiltrometer tests, borings, Standard Penetration tests, Cone Penetration tests, and rock coring through the use of specialized test equipment (such as the field vane, pressuremeter, dilatometer, double ring infiltrometer, etc.) and through the use of geophysical methods including the field classification of materials and acquisition of soil and rock samples in accordance with standard FM, AASHTO & ASTM procedures unless otherwise described in the Soils & Foundation Handbook.",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,"Ensure field logs are accurate and complete.",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,"Demonstrate knowledge of Department and District Procedures and demonstrate knowledge of FM, AASHTO, ASTM, and Soils and Foundations Handbook sampling requirements.",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,8,"Complete all work on schedule to be incorporated into required reports and plan review submittals (i.e. BDR, 30%, 60%, 90%, 100% or Phase I, Phase II, Phase III, Phase VI) including all the geotechnical work and submit the final geotechnical report and recommendation on schedule. Avoid additional submittals or delays due to geotechnical exploration related quality or completeness issues.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M92>0,1,0)","v":0}]
[null,"Comments:",null,null,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,9,"Respond appropriately to Department review comments and verify issues are resolved as responded.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M95>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M95=\"N/A\",\"\",(IF(M95=\"\",\"\",(IF(M95<3,\"COMMENTS REQUIRED\",(IF(M95>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M96=\"comments required\", 1,0)","v":0}]
[]
[]
[null,"Additional evaluation criteria that may only apply to Materials/Testing Contracts:"]
[]
[null,null,"10*","Perform pavement survey/evaluation and report the results in accordance with the most current governing documents in timely manner.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M101>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M101=\"N/A\",\"\",(IF(M101=\"\",\"\",(IF(M101<3,\"COMMENTS REQUIRED\",(IF(M101>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M102=\"comments required\", 1,0)","v":0}]
[]
[null,null,"11*","Document the findings of the pavement cores accurately in the Pavement Evaluation and Condition Data Sheet, Core Layout Plan, and photo pages.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M104>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M104=\"N/A\",\"\",(IF(M104=\"\",\"\",(IF(M104<3,\"COMMENTS REQUIRED\",(IF(M104>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M105=\"comments required\", 1,0)","v":0}]
[]
[null,null,"12*","Perform field testing (pavement cores, borings, DCP, GPR, etc.) in accordance with standard procedures (ASTM, AASHTO, FM, FDOT Materials Manual, Soils & Foundations Handbook, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M107>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M107=\"N/A\",\"\",(IF(M107=\"\",\"\",(IF(M107<3,\"COMMENTS REQUIRED\",(IF(M107>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M108=\"comments required\", 1,0)","v":0}]
[]
[null,null,"13*","Complete all reporting documents on schedule including data entry into the Department’s Pavement Core Reporting (PCR) system and/or in other systems effectively and in timely manner.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M110>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M110=\"N/A\",\"\",(IF(M110=\"\",\"\",(IF(M110<3,\"COMMENTS REQUIRED\",(IF(M110>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M111=\"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:M110)=0),\"Not Rated\", AVERAGE(M70:M110))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M113=\"Not Rated\",\"\",(IF(O115>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O70:O111)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M113))","v":"Not Rated"}]

{"sheet":"9.2 Geo. Classif. Lab Testing","index":1,"n_rows":96,"n_cols":18,"rows_kept":96,"cut":false,"hidden":false,"merged":[[85,12,86,12],[88,1,88,11],[89,2,92,11],[89,12,90,12],[95,8,95,11],[84,3,84,11],[85,1,85,2],[85,3,85,11],[78,3,78,11],[79,1,79,2],[79,3,79,11],[75,3,75,11],[79,12,80,12],[81,3,81,11],[82,1,82,2],[82,3,82,11],[82,12,83,12],[76,3,76,11],[72,3,72,11],[73,1,73,2],[73,3,73,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],[73,12,74,12],[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,"GEOTECHNICAL CLASSIFICATION LAB TESTING - 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":"M96","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:R86)","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. All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[null,"A.","GEOTECHNICAL CLASSIFICATION LAB TESTING"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Geotechnical Classification Lab Testing effort far exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Geotechnical Classification Lab Testing effort often exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Geotechnical Classification Lab Testing effort consistently achieved FDOT requirements and guidelines.  Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Geotechnical Classification Lab Testing effort sometimes achieved FDOT requirements and guidelines.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Geotechnical Classification Lab Testing effort 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,"Perform classification (% fines, gradation, organic content, etc.) and Index Property (i.e. liquid limit, plastic limit, natural moisture content, torvane shear, pocket penetrometer, etc.) testing in accordance with standard procedures (FM, AASHTO, ASTM, etc.).",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,"Classify soil and rock samples in accordance with either AASHTO or Unified Soil Classification Systems.",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,"Perform LBR tests in accordance with standard procedures (FM) or submit samples for resilient modulus testing.",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,"Document the results of testing appropriately in reports and the construction plans.",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,"Demonstrates knowledge of Department and District Procedures and demonstrates knowledge of FM, AASHTO and ASTM standard test procedures.",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,"Complete all testing and reporting on schedule to be incorporated into required documents or engineering reports and plan review submittals (i.e. BDR, 30%, 60%, 90%, 100% or Phase I, Phase II, Phase III, Phase VI).  Avoid additional submittals or delays due to geotechnical exploration testing related quality or completeness issues.",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,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M70:M86)=0),\"Not Rated\", AVERAGE(M70:M86))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M88=\"Not Rated\",\"\",(IF(O90>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O70:O86)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M88))","v":"Not Rated"}]

{"sheet":"9.3 HIghway Materials Testing","index":2,"n_rows":93,"n_cols":18,"rows_kept":93,"cut":false,"hidden":false,"merged":[[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],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,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],[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],[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],[72,3,72,11],[73,1,73,2],[73,3,73,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],[73,12,74,12],[75,3,75,11],[92,8,92,11],[85,1,85,11],[86,2,89,11],[86,12,87,12],[78,3,78,11],[79,1,79,2],[79,3,79,11],[79,12,80,12],[81,3,81,11],[82,1,82,2],[82,3,82,11],[76,3,76,11]]}
[]
[]
[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,"HIGHWAY MATERIALS TESTING - 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":"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(R70: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. 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,"A.","HIGHWAY MATERIALS TESTING"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Highway Materials Testing effort far exceeded FDOT expectations, requirements and guidelines. Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Highway Materials Testing effort often exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Highway Materials Testing effort consistently achieved FDOT requirements and guidelines. Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Highway Materials Testing effort sometimes achieved FDOT requirements and guidelines. Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Highway Materials Testing effort 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,"Sample, test and report all required materials in accordance with standard procedures (FM, AASHTO, ASTM, etc.).",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,"Document the results of testing appropriately in reports, the construction plans, and enter them into the current FDOT materials database system within the specified time from receipt of sample through reporting.",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,"Demonstrates knowledge of Department and District Procedures and demonstrates knowledge of FM, AASHTO and ASTM standard test procedures.",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,"Consultant's internal Quality Control Program (QCP) or Quality Management System (QMS) is effective with respect to preventing problems or errors. QCP or QMS is effective in maintaining and updating CTQP qualifications and requirements.",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,"Complete all testing and reporting on schedule to be incorporated into required documents. Avoided additional submittals or delays due to highway material testing related quality or completeness issues.",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,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M70:M83)=0),\"Not Rated\", AVERAGE(M70: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(O70: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":"9.4.1 Std. Foundation Studies","index":3,"n_rows":184,"n_cols":18,"rows_kept":184,"cut":false,"hidden":false,"merged":[[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],[181,7,183,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],[26,1,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,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],[40,1,40,6],[43,1,43,12],[44,2,47,11],[44,12,45,12],[51,2,51,12],[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],[65,3,65,11],[69,2,69,11],[71,3,71,11],[72,1,72,2],[72,3,72,11],[72,12,73,12],[68,2,68,11],[60,3,60,11],[61,3,61,11],[62,3,62,11],[63,3,63,11],[64,3,64,11],[81,12,82,12],[83,3,83,11],[84,1,84,2],[84,3,84,11],[84,12,85,12],[74,3,74,11],[75,1,75,2],[75,3,75,11],[75,12,76,12],[77,3,77,11],[78,3,78,11],[86,3,86,11],[87,1,87,2],[87,3,87,11],[102,3,102,11],[106,3,106,11],[108,3,108,11],[109,1,109,2],[109,3,109,11],[80,3,80,11],[81,1,81,2],[81,3,81,11],[99,3,99,11],[100,1,100,2],[100,3,100,11],[180,8,180,11],[58,2,58,12],[164,2,164,10],[166,3,166,11],[167,3,167,11],[150,3,150,11],[151,1,151,2],[151,3,151,11],[153,3,153,11],[154,1,154,2],[154,3,154,11],[145,1,145,2],[145,3,145,11],[145,12,146,12],[147,3,147,11],[148,1,148,2],[148,3,148,11],[148,12,149,12],[114,1,114,12],[144,3,144,11],[119,3,119,11],[120,1,120,2],[120,3,120,11],[120,12,121,12],[176,1,176,2],[176,3,176,11],[176,12,177,12],[168,3,168,11],[169,3,169,11],[170,3,170,11],[171,3,171,11],[174,2,174,11],[175,3,175,11],[122,3,122,11],[123,1,123,2],[123,3,123,11],[141,3,141,11],[142,1,142,2],[142,3,142,11],[133,1,133,2],[133,3,133,11],[100,12,101,12],[103,1,103,2],[103,3,103,11],[116,3,116,11],[93,3,93,11],[94,3,94,11],[96,3,96,11],[97,1,97,2],[97,3,97,11],[87,12,88,12],[89,3,89,11],[90,1,90,2],[90,3,90,11],[90,12,91,12],[97,12,98,12],[117,1,117,2],[117,3,117,11],[117,12,118,12],[109,12,110,12],[111,3,111,11],[112,1,112,2],[112,3,112,11],[112,12,113,12],[105,3,105,11],[126,3,126,11],[127,1,127,2],[127,3,127,11],[127,12,128,12],[129,3,129,11],[130,1,130,2],[130,3,130,11],[130,12,131,12],[132,3,132,11],[157,1,157,11],[158,2,161,11],[158,12,159,12],[133,12,134,12],[135,3,135,11],[136,1,136,2],[136,3,136,11],[138,3,138,11],[139,1,139,2],[139,3,139,11],[139,12,140,12],[142,12,143,12],[154,12,155,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,"STANDARD FOUNDATION STUDIES - 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":"M181","v":"NOT RATED"},null,null,null,"Total Items:",28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R72:R176)","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 15 - 27 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. NOTE: Work Type 9.4.1 evaluators are required to have a rating score in each Evaluation Section. \n "]
[]
[]
[]
[]
[null,"A.","ROADWAY, REDUNDANT BRIDGE, AND MISCELLANEOUS STRUCTURE FOUNDATION STUDIES  (90%)"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Roadway, Redundant, and Miscellaneous Structure Foundation Study effort far exceeded FDOT expectations.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Roadway, Redundant, and Miscellaneous Structure Foundation Study often exceeded FDOT expectations.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Roadway, Redundant, and Miscellaneous Structure Foundation Study consistently achieved FDOT expectations.  Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Roadway, Redundant, and Miscellaneous Structure Foundation Study sometimes achieved FDOT expectations.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Roadway, Redundant, and Miscellaneous Structure Foundation Study consistently did not achieve FDOT expectations.  Objectives achieved with significant involvement by FDOT."]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,"EXPECTATION: In general, meeting the following objectives with minimal involvement by FDOT is desirable, however, communication and coordination between the geotechnical firm and the Department is encouraged.         "]
[]
[null,null,1,"Completeness of project review and office reconnaissance.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M72>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M72=\"N/A\",\"\",(IF(M72=\"\",\"\",(IF(M72<3,\"COMMENTS REQUIRED\",(IF(M72>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M73=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"Completeness of tentative work plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M75>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M76=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Completeness of engineering analysis and evaluations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M78>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M78=\"N/A\",\"\",(IF(M78=\"\",\"\",(IF(M78<3,\"COMMENTS REQUIRED\",(IF(M78>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M79=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Completeness and quality of reports.",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,5,"Draft plots of auger, SPT borings, CPT soundings and prepare boring/sounding location plan. Include vicinity map, USGS and NRCS maps depicting project location.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M84>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M84=\"N/A\",\"\",(IF(M84=\"\",\"\",(IF(M84<3,\"COMMENTS REQUIRED\",(IF(M84>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M85=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Appropriately evaluate and analyze foundation alternatives, wall stability, box culvert settlement/stability, soil parameters for lateral load analysis, and soil parameters for signs, signals, high mast lights and strain poles.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M87>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M88=\"comments required\", 1,0)","v":0}]
[]
[null,null,7,"Appropriately develop Geotechnical recommendations for treatment of problematic soils (muck, peat, clay, silt, etc.) or anticipated construction issues relating to pile or shaft installations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M90>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M90=\"N/A\",\"\",(IF(M90=\"\",\"\",(IF(M90<3,\"COMMENTS REQUIRED\",(IF(M90>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M91=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,8,"Prepare preliminary and final Geotechnical roadway/structures reports that are well written and complete, and that includes appropriate foundation construction/testing recommendations, and required Technical Special Provisions.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M94>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M95=\"comments required\", 1,0)","v":0}]
[]
[null,null,9,"Demonstrates knowledge of Department and District Procedures and demonstrates knowledge of FM, AASHTO, ASTM, Structures Manual, and Soils and Foundations Handbook geotechnical requirements.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97=\"N/A\",\"\",(IF(M97=\"\",\"\",(IF(M97<3,\"COMMENTS REQUIRED\",(IF(M97>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M98=\"comments required\", 1,0)","v":0}]
[]
[null,null,10,"Effectively resolve issues and make decisions based on solid logic with sufficient supporting detail. ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M100>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M100=\"N/A\",\"\",(IF(M100=\"\",\"\",(IF(M100<3,\"COMMENTS REQUIRED\",(IF(M100>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M101=\"comments required\", 1,0)","v":0}]
[]
[null,null,11,"Anticipate constructability issues and recommend solutions to minimize the potential for construction cost & time overruns (e.g. vibration and settlement impacts, minimizing unforeseen site conditions, etc.).",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M103>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M103=\"N/A\",\"\",(IF(M103=\"\",\"\",(IF(M103<3,\"COMMENTS REQUIRED\",(IF(M103>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M104=\"comments required\", 1,0)","v":0}]
[]
[null,null,12,"Respond appropriately to Department review comments and verify issues are resolved as responded.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M106>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M107=\"comments required\", 1,0)","v":0}]
[]
[null,null,13,"Appropriately coordinate geotechnical issues with Structural and Hydraulic disciplines as required.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M109>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M109=\"N/A\",\"\",(IF(M109=\"\",\"\",(IF(M109<3,\"COMMENTS REQUIRED\",(IF(M109>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M110=\"comments required\", 1,0)","v":0}]
[]
[null,null,14,"Complete all work on schedule to be incorporated into required reports & plan review Submittals (i.e. BDR, 30%, 60%, 90%, 100%).  Avoided additional phase submittals or delays due to foundation study and reporting quality or completeness issues.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M112>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M112=\"N/A\",\"\",(IF(M112=\"\",\"\",(IF(M112<3,\"COMMENTS REQUIRED\",(IF(M112>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M113=\"comments required\", 1,0)","v":0}]
[]
[null,"Additional evaluation criteria that may only apply to Materials/Testing Contracts:"]
[]
[null,null,"15*","Review plans, PIP, DSIP, construction logs submittals or associated assigned tasks while providing comments and responding appropriately to Department review comments.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M117>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M118=\"comments required\", 1,0)","v":0}]
[]
[null,null,"16*","Complete all work on schedule to be incorporated into required reports and meet specification/CPAM timelines for construction reports or recommendations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M120>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M120=\"N/A\",\"\",(IF(M120=\"\",\"\",(IF(M120<3,\"COMMENTS REQUIRED\",(IF(M120>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M121=\"comments required\", 1,0)","v":0}]
[]
[null,null,"17*","Perform Dynamic Load Testing in accordance with standard testing procedures.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M123>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M123=\"N/A\",\"\",(IF(M123=\"\",\"\",(IF(M123<3,\"COMMENTS REQUIRED\",(IF(M123>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M124=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,"18*","Perform Wave Equation Analyses on quantity of piles specified in the project contract documents or as requested by the Department.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M127>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M128=\"comments required\", 1,0)","v":0}]
[]
[null,null,"19*","Recommend solutions to the DGE when pile driving problems occur.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M130=\"N/A\",\"\",(IF(M130=\"\",\"\",(IF(M130<3,\"COMMENTS REQUIRED\",(IF(M130>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M131=\"comments required\", 1,0)","v":0}]
[]
[null,null,"20*","Observe and ensure Dynamic Load Testing in accordance with standard testing procedures.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M133>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M133=\"N/A\",\"\",(IF(M133=\"\",\"\",(IF(M133<3,\"COMMENTS REQUIRED\",(IF(M133>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M134=\"comments required\", 1,0)","v":0}]
[]
[null,null,"21*","Effectively review Dynamic Testing results, pile length letters, Driving Criteria etc. and provide comment/recommendations to the DGE.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M136>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M136=\"N/A\",\"\",(IF(M136=\"\",\"\",(IF(M136<3,\"COMMENTS REQUIRED\",(IF(M136>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M137=\"comments required\", 1,0)","v":0}]
[]
[null,null,"22*","Thoroughly review foundation certification packages and provided comments/recommendations to DGE for verification testing in a timely manner.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M139>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M139=\"N/A\",\"\",(IF(M139=\"\",\"\",(IF(M139<3,\"COMMENTS REQUIRED\",(IF(M139>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M140=\"comments required\", 1,0)","v":0}]
[]
[null,null,"23*","Coordinate with project inspection team for meetings, testing dates etc. and relay information to DGE as needed.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M142>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M142=\"N/A\",\"\",(IF(M142=\"\",\"\",(IF(M142<3,\"COMMENTS REQUIRED\",(IF(M142>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M143=\"comments required\", 1,0)","v":0}]
[]
[null,null,"24*","Thoroughly review pile driving logs and provide comments to the DGE in a timely manner.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M145>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M145=\"N/A\",\"\",(IF(M145=\"\",\"\",(IF(M145<3,\"COMMENTS REQUIRED\",(IF(M145>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M146=\"comments required\", 1,0)","v":0}]
[]
[null,null,"25*","Ensure final summary report is complete and submit data and documents to the DGE in timely manner.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M148>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M148=\"N/A\",\"\",(IF(M148=\"\",\"\",(IF(M148<3,\"COMMENTS REQUIRED\",(IF(M148>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M149=\"comments required\", 1,0)","v":0}]
[]
[null,null,"26*","Effectively deploy, install, utilize calibrated and fully functional field instrumentation equipment while demonstrating competent interpretation, presentation and recommendations of the data.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M151>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M151=\"N/A\",\"\",(IF(M151=\"\",\"\",(IF(M151<3,\"COMMENTS REQUIRED\",(IF(M151>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M152=\"comments required\", 1,0)","v":0}]
[]
[null,null,"27*","Meet specifications/CPAM timelines for construction reports or recommendations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M154>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M154=\"N/A\",\"\",(IF(M154=\"\",\"\",(IF(M154<3,\"COMMENTS REQUIRED\",(IF(M154>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M155=\"comments required\", 1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M72:M154)=0),\"Not Rated\", AVERAGE(M72:M154))","v":"Not Rated"},null,null,{"$f":"IF((COUNT(M157)=0),\"NA\",M157*0.9)","v":"NA"},{"$f":"IF(COUNT(P157)=0,-0.9,0)","v":-0.9}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M131=\"Not Rated\",\"\",(IF(O159>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O46:O155)","v":0}]
[]
[]
[]
[]
[]
[null,"B.","REDUNDANT BRIDGE FOUNDATION DESIGN STAFFING (10%)"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Roadway, Redundant, and Miscellaneous Structure Foundation Design staffing far exceeded FDOT expectations.  "]
[null,null,4,"Roadway, Redundant, and Miscellaneous Structure Foundation Design staffing often exceeded FDOT expectations.  "]
[null,null,3,"Roadway, Redundant, and Miscellaneous Structure Foundation Design staffing consistently achieved FDOT expectations.  "]
[null,null,2,"Roadway, Redundant, and Miscellaneous Structure Foundation Design staffing sometimes achieved FDOT expectations.  "]
[null,null,1,"Roadway, Redundant, and Miscellaneous Structure Foundation Design staffing consistently did not achieve FDOT expectations"]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"EXPECTATION:\nIndividual listed as Engineer of Record for the report is appropriate based on the complexity and type of study being conducted (Reference Rule 14-75).    Individuals listed as Designer, Design Checker, and Engineer of Record on the calculations are appropriate based on the complexity and type of study being conducted (Reference Rule 14-75).  At least one individual active in the study qualifies the Firm for the work group. ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M176>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M176=\"N/A\",\"\",(IF(M176=\"\",\"\",(IF(M176<3,\"COMMENTS REQUIRED\",(IF(M176>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M177=\"comments required\", 1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M176:M178)=0),\"Not Rated\", AVERAGE(M176:M178))","v":"Not Rated"},null,null,{"$f":"IF((COUNT(M179)=0),\"NA\",M179*0.1)","v":"NA"},{"$f":"IF(COUNT(P179)=0,-0.1,0)","v":-0.1}]
[]
[null,null,null,null,null,null,null,null,"Total WEIGHTED Score:",null,null,null,{"$f":"IF((COUNT(M157,M179)=0),\"NOT RATED\",IF((COUNT(M157,M179)=2),ROUND(SUM(P157,P179)/(1+SUM(Q157,Q179)),1),\"INCOMPLETE\"))","v":"NOT RATED"}]
[null,null,null,null,null,null,null,"Reminder: WG 9.4.1 evaluators are required to provide a rating score in each Evaluation Section. ",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P157:P179),3)","v":0},{"$f":"ROUND(SUM(Q157:Q179),2)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q157:Q179))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P182/P183","v":{"$error":"#DIV/0!"}}]

{"sheet":"9.4.2 NRDS BridgeFoundatStudies","index":4,"n_rows":144,"n_cols":18,"rows_kept":144,"cut":false,"hidden":false,"merged":[[142,7,144,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],[1,10,1,12],[2,5,2,6],[21,1,21,12],[22,1,22,12],[24,1,24,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],[26,1,26,12],[27,5,27,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[31,5,31,12],[3,1,3,3],[3,4,3,7],[3,10,3,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[11,4,11,8],[11,10,11,12],[19,1,20,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],[58,2,58,12],[60,3,60,11],[61,3,61,11],[62,3,62,11],[63,3,63,11],[64,3,64,11],[40,1,40,6],[43,1,43,12],[44,2,47,11],[44,12,45,12],[51,2,51,12],[53,1,56,12],[72,12,73,12],[74,3,74,11],[75,1,75,2],[75,3,75,11],[75,12,76,12],[77,3,77,11],[65,3,65,11],[68,2,68,11],[69,2,69,11],[71,3,71,11],[72,1,72,2],[72,3,72,11],[84,1,84,2],[84,3,84,11],[84,12,85,12],[86,3,86,11],[87,1,87,2],[87,3,87,11],[87,12,88,12],[78,3,78,11],[80,3,80,11],[81,1,81,2],[81,3,81,11],[81,12,82,12],[83,3,83,11],[96,3,96,11],[97,1,97,2],[97,3,97,11],[97,12,98,12],[99,3,99,11],[100,1,100,2],[100,3,100,11],[100,12,101,12],[89,3,89,11],[90,1,90,2],[90,3,90,11],[90,12,91,12],[93,3,93,11],[94,3,94,11],[111,1,111,12],[109,1,109,2],[109,3,109,11],[109,12,110,12],[102,3,102,11],[103,1,103,2],[103,3,103,11],[105,3,105,11],[106,3,106,11],[108,3,108,11],[114,12,115,12],[117,1,117,11],[118,2,121,11],[118,12,119,12],[127,3,127,11],[113,3,113,11],[114,1,114,2],[114,3,114,11],[125,2,125,12],[136,3,136,11],[137,1,137,2],[137,3,137,11],[137,12,138,12],[141,8,141,11],[128,3,128,11],[129,3,129,11],[130,3,130,11],[131,3,131,11],[132,3,132,11],[135,2,135,11]]}
[]
[]
[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,"NON-REDUNDANT DRILLED SHAFT BRIDGE FOUNDATION STUDIES - 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 WEIGHTED SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M142","v":"NOT RATED"},null,null,null,"Total Items:",28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Items graded:",{"$f":"SUM(R72:R137)","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 item 14 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. NOTE: Work Type 9.4.2 evaluators are required to have a rating score in each Evaluation Section. \n "]
[]
[]
[]
[]
[null,"A.","NON-REDUNDANT DS BRIDGE FOUNDATION DESIGN  (90%)"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Roadway, Redundant, and Miscellaneous Structure Foundation Study effort far exceeded FDOT expectations.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Roadway, Redundant, and Miscellaneous Structure Foundation Study often exceeded FDOT expectations.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Roadway, Redundant, and Miscellaneous Structure Foundation Study consistently achieved FDOT expectations.  Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Roadway, Redundant, and Miscellaneous Structure Foundation Study sometimes achieved FDOT expectations.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Roadway, Redundant, and Miscellaneous Structure Foundation Study consistently did not achieve FDOT expectations.  Objectives achieved with significant involvement by FDOT."]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,"EXPECTATION: In general, meeting the following objectives with minimal involvement by FDOT is desirable, however, communication and coordination between the geotechnical firm and the Department is encouraged.         "]
[]
[null,null,1,"Completeness of project review and office reconnaissance.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M72>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M72=\"N/A\",\"\",(IF(M72=\"\",\"\",(IF(M72<3,\"COMMENTS REQUIRED\",(IF(M72>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M73=\"comments required\", 1,0)","v":0}]
[]
[null,null,2,"Completeness of tentative work plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M75>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M76=\"comments required\", 1,0)","v":0}]
[]
[null,null,3,"Completeness of engineering analysis and evaluations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M78>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M78=\"N/A\",\"\",(IF(M78=\"\",\"\",(IF(M78<3,\"COMMENTS REQUIRED\",(IF(M78>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M79=\"comments required\", 1,0)","v":0}]
[]
[null,null,4,"Completeness and quality of reports.",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,5,"Draft plots of auger, SPT borings, CPT soundings and prepare boring/sounding location plan. Include vicinity map, USGS and NRCS maps depicting project location.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M84>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M84=\"N/A\",\"\",(IF(M84=\"\",\"\",(IF(M84<3,\"COMMENTS REQUIRED\",(IF(M84>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M85=\"comments required\", 1,0)","v":0}]
[]
[null,null,6,"Appropriately evaluate and analyze non-redundant drilled shaft bridge foundations.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M87>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M88=\"comments required\", 1,0)","v":0}]
[]
[null,null,7,"Prepare preliminary and final reports that are well written and complete, and that include appropriate bridge foundation construction/testing recommendations, and required Technical Special Provisions.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M90>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M90=\"N/A\",\"\",(IF(M90=\"\",\"\",(IF(M90<3,\"COMMENTS REQUIRED\",(IF(M90>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M91=\"comments required\", 1,0)","v":0}]
[]
[]
[null,null,8,"Demonstrates knowledge of Department and District Procedures and demonstrates knowledge of FM, AASHTO, ASTM, Structures Manual, and Soils and Foundations Handbook geotechnical requirements.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M94>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M95=\"comments required\", 1,0)","v":0}]
[]
[null,null,9,"Effectively resolve issues and make decisions based on solid logic with sufficient supporting detail. ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97=\"N/A\",\"\",(IF(M97=\"\",\"\",(IF(M97<3,\"COMMENTS REQUIRED\",(IF(M97>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M98=\"comments required\", 1,0)","v":0}]
[]
[null,null,10,"Anticipate constructability issues and recommend solutions to minimize the potential for construction cost & time overruns (e.g. vibration and settlement impacts, minimizing unforeseen site conditions, etc.).",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M100>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M100=\"N/A\",\"\",(IF(M100=\"\",\"\",(IF(M100<3,\"COMMENTS REQUIRED\",(IF(M100>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M101=\"comments required\", 1,0)","v":0}]
[]
[null,null,11,"Respond appropriately to Department review comments and verify issues are resolved as responded.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M103>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M103=\"N/A\",\"\",(IF(M103=\"\",\"\",(IF(M103<3,\"COMMENTS REQUIRED\",(IF(M103>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M104=\"comments required\", 1,0)","v":0}]
[]
[null,null,12,"Appropriately coordinate geotechnical issues with Structural and Hydraulic disciplines as required.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M106>0,1,0)","v":0}]
[null,"Comments:",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,{"$f":"+IF(M107=\"comments required\", 1,0)","v":0}]
[]
[null,null,13,"Complete all work on schedule to be incorporated into required reports & plan review Submittals (i.e. BDR, 30%, 60%, 90%, 100%).  Avoided additional phase submittals or delays due to foundation study and reporting quality or completeness issues.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M109>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M109=\"N/A\",\"\",(IF(M109=\"\",\"\",(IF(M109<3,\"COMMENTS REQUIRED\",(IF(M109>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M110=\"comments required\", 1,0)","v":0}]
[]
[null,"Additional evaluation criteria that may only apply to Materials/Testing Contracts:"]
[]
[null,null,"14*","Perform test and analyze Drilled Shaft construction effectively (TITDS, SID, CSL, etc.).",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M114>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M114=\"N/A\",\"\",(IF(M114=\"\",\"\",(IF(M114<3,\"COMMENTS REQUIRED\",(IF(M114>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M115=\"comments required\", 1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M72:M114)=0),\"Not Rated\", AVERAGE(M72:M114))","v":"Not Rated"},null,null,{"$f":"IF((COUNT(M117)=0),\"NA\",M117*0.9)","v":"NA"},{"$f":"IF(COUNT(P117)=0,-0.9,0)","v":-0.9}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M115=\"Not Rated\",\"\",(IF(O119>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O46:O115)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"B.","NON-REDUNDANT DRILLED SHAFT BRIDGE FOUNDATION DESIGN STAFFING (10%) "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Non-Redundant Drilled Shaft Bridge Foundation staffing far exceeded FDOT expectations.  "]
[null,null,4,"Non-Redundant Drilled Shaft Bridge Foundation staffing often exceeded FDOT expectations.  "]
[null,null,3,"Non-Redundant Drilled Shaft Bridge Foundation staffing consistently achieved FDOT expectations.  "]
[null,null,2,"Non-Redundant Drilled Shaft Bridge Foundation staffing sometimes achieved FDOT expectations.  "]
[null,null,1,"Non-Redundant Drilled Shaft Bridge Foundation staffing consistently did not achieve FDOT expectations"]
[]
[]
[null,null,"Evaluation Items",null,null,null,null,null,null,null,null,null,"Score"]
[null,null,1,"EXPECTATION:\nIndividual listed as Engineer of Record for the report is appropriate based on the complexity and type of study being conducted (Reference Rule 14-75).    Individuals listed as Designer, Design Checker, and Engineer of Record on the calculations are appropriate based on the complexity and type of study being conducted (Reference Rule 14-75).  At least one individual active in the study qualifies the Firm for the work group. ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M137>0,1,0)","v":0}]
[null,"Comments:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M137=\"N/A\",\"\",(IF(M137=\"\",\"\",(IF(M137<3,\"COMMENTS REQUIRED\",(IF(M137>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""},null,{"$f":"+IF(M138=\"comments required\", 1,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M137:M139)=0),\"Not Rated\", AVERAGE(M137:M139))","v":"Not Rated"},null,null,{"$f":"IF((COUNT(M140)=0),\"NA\",M140*0.1)","v":"NA"},{"$f":"IF(COUNT(P140)=0,-0.1,0)","v":-0.1}]
[]
[null,null,null,null,null,null,null,null,"Total WEIGHTED Score:",null,null,null,{"$f":"IF((COUNT(M117,M140)=0),\"NOT RATED\",IF((COUNT(M117,M140)=2),ROUND(SUM(P117,P140)/(1+SUM(Q117,Q140)),1),\"INCOMPLETE\"))","v":"NOT RATED"},null,null,{"$f":"ROUND(SUM(P117:P140),3)","v":0},{"$f":"ROUND(SUM(Q117:Q140),2)","v":-1}]
[null,null,null,null,null,null,null,"Reminder: WG 9.4.2 evaluators are required to provide a rating score in each Evaluation Section. ",null,null,null,null,null,null,null,{"$f":"(1+SUM(Q117:Q140))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P142/P143","v":{"$error":"#DIV/0!"}}]

{"sheet":"9.5 Geo. Specialty Lab Testing","index":5,"n_rows":90,"n_cols":18,"rows_kept":90,"cut":false,"hidden":false,"merged":[[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],[5,4,5,8],[5,10,5,12],[6,4,6,8],[6,10,6,12],[7,4,7,8],[7,10,7,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],[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],[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],[72,3,72,11],[73,1,73,2],[73,3,73,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],[73,12,74,12],[75,3,75,11],[82,1,82,11],[83,2,86,11],[83,12,84,12],[76,3,76,11],[89,8,89,11],[78,3,78,11],[79,1,79,2],[79,3,79,11],[79,12,80,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,"GEOTECHNICAL SPECIALTY LAB TESTING - 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":"M90","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:R81)","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. All comments must be aggregated in the \"Combined Evaluation Section Comments\" field, regardless of the average score for that section.\n "]
[]
[]
[]
[]
[null,"A.","GEOTECHNICAL SPECIALTY LAB TESTING"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Geotechnical Specialty Lab Testing far exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with minimal involvement by FDOT."]
[null,null,4,"Geotechnical Specialty Lab Testing often exceeded FDOT expectations, requirements and guidelines.  Objectives achieved with some involvement by FDOT."]
[null,null,3,"Geotechnical Specialty Lab Testing consistently achieved FDOT expectations, requirements and guidelines. Objectives achieved with expected involvement by FDOT."]
[null,null,2,"Geotechnical Specialty Lab Testing sometimes achieved FDOT requirements and guidelines.  Objectives achieved with substantial involvement by FDOT."]
[null,null,1,"Geotechnical Specialty Lab Testing 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,"Perform permeability, consolidation, unconfined compression, direct shear, splitting tensile and triaxial tests according to Department approved specifications and in accordance with standard procedures (FM, AASHTO & ASTM, etc.)",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,"Demonstrates knowledge of FM AASHTO & ASTM standard test procedures.",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,"Provide complete, appropriate and well written test reports.",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,"Complete all testing and reporting on schedule to be incorporated into required engineering reports.",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,null,null,null,null,null,null,null,null,null,"Evaluation Section Average Score:",{"$f":"IF((COUNT(M70:M81)=0),\"Not Rated\", AVERAGE(M70:M81))","v":"Not Rated"}]
[null,"Combined Evaluation Section Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M82=\"Not Rated\",\"\",(IF(O84>0,\"COMMENTS REQUIRED\", \"\")))","v":""},null,{"$f":"+SUM(O70:O81)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R37=0),\"Not Rated\",AVERAGE(M82))","v":"Not Rated"}]