{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Group 8 Survey and Mapping"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Group 8 Survey and Mapping","index":0,"n_rows":230,"n_cols":18,"rows_kept":230,"cut":false,"hidden":false,"merged":[[48,1,48,12],[70,2,70,12],[45,1,45,6],[5,4,5,8],[6,4,6,8],[7,4,7,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[11,4,11,8],[11,10,11,12],[30,1,30,12],[37,1,37,12],[40,12,42,12],[19,7,21,12],[40,5,42,11],[40,1,42,4],[168,3,168,11],[170,1,170,12],[7,10,7,12],[9,10,9,12],[79,3,79,11],[80,3,80,11],[82,1,82,12],[15,7,17,12],[8,10,8,12],[44,10,44,12],[44,1,44,6],[10,10,10,12],[27,1,27,12],[28,1,28,12],[25,1,26,12],[167,3,167,11],[208,2,208,12],[209,2,209,10],[228,8,229,12],[228,6,228,7],[171,2,174,11],[171,12,172,12],[232,1,232,12],[211,2,211,11],[213,3,213,11],[214,3,214,11],[215,3,215,11],[216,3,216,11],[217,3,217,11],[218,3,218,11],[220,1,220,12],[227,1,227,11],[221,2,224,11],[221,12,222,12],[231,1,231,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,10,6,12],[5,10,5,12],[49,2,52,11],[49,12,50,12],[115,3,115,11],[116,3,116,11],[118,1,118,12],[114,3,114,11],[83,12,84,12],[107,2,107,10],[66,1,66,12],[67,1,67,12],[77,3,77,11],[78,3,78,11],[109,2,109,11],[111,3,111,11],[112,3,112,11],[71,2,71,10],[119,2,122,11],[166,3,166,11],[119,12,120,12],[159,2,159,10],[156,2,156,11],[161,2,161,11],[163,3,163,11],[164,3,164,11],[165,3,165,11],[113,3,113,11],[75,3,75,11],[76,3,76,11],[73,2,73,11],[83,2,86,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,"Surveyor of Record:"]
[null,"Survey 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 8."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This worksheet provides specific performance measure guidelines for the performance rating scale as it pertains to each criteria item in this evaluation area. This worksheet also serves as backup documentation for drafting and discussing the evaluations. The scores and comments must be transferred to the official evaluation within the FDOT Consultant Evaluation (CE) internal application:"]
[]
[null,"https://ce.fdot.gov/"]
[null,"Access to the internal CE application for inputting performance evaluations is restricted to FDOT Project Managers."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,4]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,3]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5]
[null,"**{See specific performance measure guidelines within each evaluation item}**",null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,"Scores are REQUIRED for all sections. The TOTAL WEIGHTED SCORE will ONLY be shown once ALL sections are scored.",null,null,null,"TOTAL WEIGHTED SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M228","v":"Not Rated"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",null,{"$f":"COUNT(M220,M170,M118,M82)","v":0}]
[]
[]
[]
[null,"FDOT Project Manager",null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,"General Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M41=\"not rated\",\"\",(IF(M41=\"INCOMPLETE\",\"\",(IF(M41<3,\"COMMENTS REQUIRED\",(IF(M41>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. "]
[null,"PLEASE NOTE:  Work Group 8 evaluators are REQUIRED to provide a rating score for each evaluation item.  "]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","SUBMITTALS ",null,null,null,null,null,null,null,null," (30%)"]
[]
[null,null,"EXPECTATION:\n1. Minimize number of Submittals prior to approval by the Department.  \n2. Submittals are accurate, complete, and in compliance with the FDOT Survey and Mapping Handbooks, Department direction/preference and Consultant's Scope of Services.\n3. Submittals demonstrate that a thorough Quality Control Process was followed prior to submitting. \n4. Submittals include a documented contract compliance checklist.\n5. Submittals demonstrate proper coordination with Project Manager and adjacent projects. \n6. Minimize the number of major survey comments and QA/QC Comments.  A major comment is defined as one that would result in a substantial change due to survey error. \n7. Provides solutions to issues when they occur.\n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the survey firm and the Department is encouraged.\n "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"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(M82)=0),\"NA\",M82*0.3)","v":"NA"},{"$f":"IF(COUNT(P82)=0,-0.3,0)","v":-0.3}]
[null,"Comments:"]
[null,null,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,"B.","QA/QC PLANS, DATA AND PRODUCTS (20%)",null,null,null,null,null,null,null,null," (20%)"]
[]
[null,null,"EXPECTATION:\n1. All Department processes and District specific procedures have been utilized.\n2. All applicable items from the District Survey Data Processing and Review QA/QC Management Plan are complete.\n3. All applicable items for the District Map Preparation and Review QA/QC Management Plan are complete.  \n4. Responses to comments completed in timely manner.\n5. Responses to comments are coordinated with commenter. \n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the survey firm and the Department is encouraged.\n "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"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(M118)=0),\"NA\",M118*0.2)","v":"NA"},{"$f":"IF(COUNT(P118)=0,-0.2,0)","v":-0.2}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M118=\"N/A\",\"\",(IF(M118=\"\",\"\",(IF(M118<3,\"COMMENTS REQUIRED\",(IF(M118>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"C.","PROJECT SCOPING AND COMPLIANCE",null,null,null,null,null,null,null,null," (20%)"]
[]
[null,null,"EXPECTATION:\n1.  Assist in final scope development for survey and mapping needs. Identifies advertised scope adequacy and makes suggestions for scope additions/deletions/adjustments by understanding project needs and requirements.\n2.  Documentation of Scope Compliance with a Checklist and/or other conformance documentation.    \n3.  Provide products that comply with scope-identified deliverables and Department requirements that are clear, easily understood, accurate and meet the scope limits.\n4.  Timely resolution of issues and scope clarifications.\n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the Survey firm and the Department is encouraged.\n"]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"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(M170)=0),\"NA\",M170*0.2)","v":"NA"},{"$f":"IF(COUNT(P170)=0,-0.2,0)","v":-0.2}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M170=\"N/A\",\"\",(IF(M170=\"\",\"\",(IF(M170<3,\"COMMENTS REQUIRED\",(IF(M170>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"D.","PRODUCT MEETS CUSTOMER'S NEED ",null,null,null,null,null,null,null,null," (30%)"]
[]
[null,null,"EXPECTATION:\n1.  Thorough understanding of District surveying and mapping processes and expectations.\n2.  Proactive in meeting with District Surveying and Mapping staff and provides high level of input on agency's possible needs, feedback, requirements, etc.\n3.  Works independently and provides recommendations.\n4.  Attends meetings with a written agenda and knowledge to discuss issues.  Provides proposals and follow-up on all issues.\n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, comment resolution, communication and coordination between the survey firm and the Department is encouraged.  "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Sometimes achieved FDOT expectations.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"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(M220)=0),\"NA\",M220*0.3)","v":"NA"},{"$f":"IF(COUNT(P220)=0,-0.3,0)","v":-0.3}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M220=\"N/A\",\"\",(IF(M220=\"\",\"\",(IF(M220<3,\"COMMENTS REQUIRED\",(IF(M220>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[null,"Total Weighted Score:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((COUNT(M82:M220)=0),\"Not Rated\",IF((COUNT(M82:M220)=4),ROUND(SUM(P82:P220)/(1+SUM(Q82:Q220)),1),\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"ROUND(SUM(P82:P220),1)","v":0},{"$f":"ROUND(SUM(Q82:Q220),1)","v":-1}]
[null,null,null,null,null,null,"Reminder: ",null,"Work Group 8 evaluators are required to provide a rating score for each evaluation item. ",null,null,null,null,null,null,{"$f":"(1+SUM(Q82:Q220))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P228/P229","v":{"$error":"#DIV/0!"}}]