{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["6.1 Traffic Engineering Studies","6.2 Traffic Signal Timing","6.3.1 ITS Analysis and Design","6.3.2 ITS Implementation","6.3.3 ITS Communications","6.3.4 ITS Software Development"],"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":"6.1 Traffic Engineering Studies","index":0,"n_rows":82,"n_cols":19,"rows_kept":82,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,4,4,8],[4,10,4,12],[14,7,16,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],[22,1,22,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],[11,4,11,8],[11,10,11,12],[19,1,20,12],[21,1,21,12],[24,1,24,12],[26,1,26,12],[33,1,33,12],[36,1,38,4],[36,5,38,11],[36,12,38,12],[66,3,66,11],[40,1,40,6],[40,10,40,12],[41,1,41,6],[44,1,44,12],[45,2,48,11],[45,12,46,12],[55,1,58,12],[60,2,60,12],[61,2,61,10],[63,2,63,11],[65,3,65,11],[73,2,76,11],[73,12,74,12],[79,8,79,11],[67,3,67,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[72,1,72,12]]}
[]
[]
[]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 6."]
[]
[]
[]
[]
[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,"TRAFFIC ENGINEERING AND OPERATIONS STUDIES - QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M80","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S72:S136)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R72:R79)","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(M37=\"not rated\",\"\",(IF(M37=\"\",\"\",(IF(M37<3,\"COMMENTS REQUIRED\",(IF(M37>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","Traffic Engineering Studies"]
[]
[null,null,"EXPECTATION:\nDemonstrate knowledge and experience of traffic engineering and operational problems and the determination of traffic operational improvements for safety and efficiency.  The following objectives shall be applied in the evaluation of this Work Type: \n1. Traffic Engineering documentation demonstrate knowledge of Department and District specific procedures. \n2. Documentation of the Studies demonstrate knowledges and requirements of FDOT Manual on Uniform Traffic Studies, FDOT Traffic Analysis Handbook, and the FDOT Traffic Engineering Manual Completeness of traffic, roadway, signal, and crash data presented.\n\nNOTE: Deliverables include Traffic Engineering Studies and Reports for the following: Signing, marking, and signal inventories; Traffic counts; Intersection and collision diagrams; Signal warrant and intersection analysis; Travel time and delay studies; and Miscellaneous other traffic analysis. Errors described as: Major error = wrong functional class, wrong road name, design criteria error, wrong county, major elements missing from report, incomplete forms or analysis, incorrect or inappropriate conclusions; Minor error = spelling, format, grammar."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Traffic Engineering Studies far exceed FDOT expectations, requirements and guidelines.  No errors observed.  Above objectives achieved with no assistance by FDOT."]
[null,null,4,"Traffic Engineering Studies often exceed FDOT expectations, requirements and guidelines.  Average number of minor errors observed.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Traffic Engineering Studies consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Traffic Engineering Studies sometimes achieved FDOT expectations.  Some major and minor errors.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Traffic Engineering Studies 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(M72)=0),\"NA\",M72*(S72/$R$39))","v":"NA"},{"$f":"IF(COUNT(P72)=0,-(S72/$R$39),0)","v":-1},{"$f":"COUNT(M72)","v":0},{"$f":"IF(L72=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P82,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P72:P79)","v":0},{"$f":"SUM(Q72:Q79)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q72:Q79))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P80/P81","v":{"$error":"#DIV/0!"}}]

{"sheet":"6.2 Traffic Signal Timing","index":1,"n_rows":83,"n_cols":19,"rows_kept":83,"cut":false,"hidden":false,"merged":[[74,2,77,11],[74,12,75,12],[81,7,82,12],[80,8,80,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[67,3,67,11],[40,1,40,6],[40,10,40,12],[41,1,41,6],[44,1,44,12],[45,2,48,11],[45,12,46,12],[56,1,59,12],[61,2,61,12],[62,2,62,10],[64,2,64,11],[66,3,66,11],[24,1,24,12],[26,1,26,12],[33,1,33,12],[36,1,38,4],[36,5,38,11],[36,12,38,12],[22,1,22,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],[11,4,11,8],[11,10,11,12],[14,7,16,12],[19,1,20,12],[21,1,21,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,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 6."]
[]
[]
[]
[]
[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,"TRAFFIC ENGINEERING AND OPERATIONS STUDIES - QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M81","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S73:S120)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R79)","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(M37=\"not rated\",\"\",(IF(M37=\"\",\"\",(IF(M37<3,\"COMMENTS REQUIRED\",(IF(M37>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","Traffic Signal Timing"]
[]
[null,null,"EXPECTATION:\nThis type of work is defined as the timing of traffic signals to improve traffic flow and safety. Department and local maintaining agency approved traffic engineering computerized timing programs shall be used. This type of work includes data collection, intersection analysis and documentation, corridor analysis and documentation, signal timing implementation and fine tuning, and post implementation timing evaluation. The following objectives shall be applied in the evaluation of this Work Type: \n1. Traffic Signal Timing Analysis and Recommendations documentation demonstrate knowledge of Department and Maintaining Agency specific procedures related to Signal Timing Analysis and updates.\n2. Traffic flow and operational level of service (reduced delay) shall be achieved over existing conditions.\n\nNOTE: Errors described as: Major error = error in documentation of existing data, alternative signal timing analysis, etc.; Minor error = spelling, format, grammar. "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Traffic Signal Timing Analysis and documentation far exceed FDOT expectations, requirements and guidelines.  No errors observed.  Above objectives achieved with no assistance by FDOT."]
[null,null,4,"Traffic Signal Timing Analysis and documentation often exceed FDOT expectations, requirements and guidelines.  Average number of project systems engineering management plan  observed.  Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Traffic Signal Timing Analysis and documentation consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Traffic Signal Timing Analysis and documentation sometimes achieved FDOT expectations.  Some major errors and minor errors.  Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Traffic Signal Timing Analysis and documentation consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M73)=0),\"NA\",M73*(S73/$R$39))","v":"NA"},{"$f":"IF(COUNT(P73)=0,-(S73/$R$39),0)","v":-1},{"$f":"COUNT(M73)","v":0},{"$f":"IF(L73=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P83,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P79)","v":0},{"$f":"SUM(Q73:Q79)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q79))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P81/P82","v":{"$error":"#DIV/0!"}}]

{"sheet":"6.3.1 ITS Analysis and Design","index":2,"n_rows":83,"n_cols":19,"rows_kept":83,"cut":false,"hidden":false,"merged":[[74,2,77,11],[74,12,75,12],[80,8,80,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[67,3,67,11],[40,1,40,6],[40,10,40,12],[41,1,41,6],[44,1,44,12],[45,2,48,11],[45,12,46,12],[56,1,59,12],[61,2,61,12],[62,2,62,10],[64,2,64,11],[66,3,66,11],[24,1,24,12],[26,1,26,12],[33,1,33,12],[36,1,38,4],[36,5,38,11],[36,12,38,12],[22,1,22,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],[11,4,11,8],[11,10,11,12],[14,7,16,12],[19,1,20,12],[21,1,21,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,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 6."]
[]
[]
[]
[]
[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,"TRAFFIC ENGINEERING AND OPERATIONS STUDIES - QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M81","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S73:S124)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R80)","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(M37=\"not rated\",\"\",(IF(M37=\"\",\"\",(IF(M37<3,\"COMMENTS REQUIRED\",(IF(M37>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","Intelligent Transportation Systems Analysis and Design"]
[]
[null,null,"EXPECTATION:\nThis type of work requires experience involving the production of competently engineered design, and preparation of construction plans and specifications for ITS systems, freeway operations systems, dynamic message sign systems, closed circuit television camera systems, detection systems, and automatic vehicle identification systems. The experience must also involve traffic engineering software applications, freeway control software, and computerized timing programs.  The following objectives shall be applied in the evaluation of this Work Type: \n1. Minimize number of Re-submittals necessary prior to approval by the Department.  \n2. Accurate, complete, and in compliance with the FDOT Design and Traffic Engineering Manuals.\n3. Demonstrate proper coordination with other project design disciplines, and adjacent projects. \n4. Minimize the number of major comments in the Electronic Review Comments (ERC) system.  A major comment is defined as one that would result in a substantial change in the design.\n5. Consistency with Concept of Operations (ConOps) and Project Systems Engineering Management Plan (PSEMP) requirements for the project.\n\nNOTE: Deliverables to be considered within this grading item include ITS Plans, Maintenance of Communication Plans, Electrical Plans, Power systems Plans, etc."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"ITS Design Plans are prepared in accordance with policies, guidelines and procedures of the Department and far exceed FDOT expectations, with no assistance from FDOT staff. ITS Designs and control systems are delivered on time and frequently completed early."]
[null,null,4,"ITS Design Plans are prepared in accordance with policies, guidelines and procedures of the Department and often exceed FDOT expectations. ITS Designs and control systems are delivered on time and occasionally completed early."]
[null,null,3,"ITS Design Plans are prepared in accordance with policies, guidelines and procedures of the Department and meet FDOT expectations. ITS Designs and control systems are delivered on time."]
[null,null,2,"ITS Design Plans are prepared in accordance with policies, guidelines and procedures of the Department with some assistance from FDOT Staff. ITS Designs and control systems are occasionally delivered late."]
[null,null,1,"ITS Design Plans are prepared in accordance with policies, guidelines and procedures of the Department with substantial assistance from FDOT Staff. ITS Designs and control systems are frequently delivered late."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M73)=0),\"NA\",M73*(S73/$R$39))","v":"NA"},{"$f":"IF(COUNT(P73)=0,-(S73/$R$39),0)","v":-1},{"$f":"COUNT(M73)","v":0},{"$f":"IF(L73=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P83,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P80)","v":0},{"$f":"SUM(Q73:Q80)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q80))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P81/P82","v":{"$error":"#DIV/0!"}}]

{"sheet":"6.3.2 ITS Implementation","index":3,"n_rows":83,"n_cols":19,"rows_kept":83,"cut":false,"hidden":false,"merged":[[74,2,77,11],[74,12,75,12],[81,7,83,12],[84,1,84,12],[85,1,85,12],[80,8,80,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[67,3,67,11],[40,1,40,6],[40,10,40,12],[41,1,41,6],[44,1,44,12],[45,2,48,11],[45,12,46,12],[56,1,59,12],[61,2,61,12],[62,2,62,10],[64,2,64,11],[66,3,66,11],[24,1,24,12],[26,1,26,12],[33,1,33,12],[36,1,38,4],[36,5,38,11],[36,12,38,12],[22,1,22,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],[11,4,11,8],[11,10,11,12],[14,7,16,12],[19,1,20,12],[21,1,21,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,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 6."]
[]
[]
[]
[]
[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,"TRAFFIC ENGINEERING AND OPERATIONS STUDIES - QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M81","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S73:S137)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R79)","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(M37=\"not rated\",\"\",(IF(M37=\"\",\"\",(IF(M37<3,\"COMMENTS REQUIRED\",(IF(M37>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","Intelligent Transportation Systems Implementation"]
[]
[null,null,"EXPECTATION:\nThis type of work requires experience involving real time traffic control systems, system installation and testing, integration, and knowledge of Construction Engineering Inspection (CEI) requirements for intelligent transportation construction projects.  The following objectives shall be applied in the evaluation of this Work Type: \n1. Minimize number of field adjustments and changes during construction. \n2. Minimize construction Requests for Information (RFIs) requiring Engineer of Record (EOR) direction and guidance during construction.   "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"ITS Construction projects are inspected in accordance with Department ITS Design Plans, Specifications, Construction Project Administration Manual and far exceed FDOT expectations, with no assistance from FDOT Staff."]
[null,null,4,"ITS Construction projects are inspected in accordance with Department ITS Design Plans, Specifications, Construction Project Administration Manual and often exceed FDOT expectations."]
[null,null,3,"ITS Construction projects are inspected in accordance with Department ITS Design Plans, Specifications, Construction Project Administration Manual and meet FDOT expectations."]
[null,null,2,"ITS Construction projects are inspected in accordance with Department ITS Design Plans, Specifications, Construction Project Administration Manual with assistance from FDOT Staff."]
[null,null,1,"ITS Construction projects are inspected in accordance with Department ITS Design Plans, Specifications, Construction Project Administration Manual with substantial assistance from FDOT Staff."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M73)=0),\"NA\",M73*(S73/$R$39))","v":"NA"},{"$f":"IF(COUNT(P73)=0,-(S73/$R$39),0)","v":-1},{"$f":"COUNT(M73)","v":0},{"$f":"IF(L73=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P83,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P79)","v":0},{"$f":"SUM(Q73:Q79)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q79))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P81/P82","v":{"$error":"#DIV/0!"}}]

{"sheet":"6.3.3 ITS Communications","index":4,"n_rows":83,"n_cols":19,"rows_kept":83,"cut":false,"hidden":false,"merged":[[74,2,77,11],[74,12,75,12],[81,7,83,12],[80,8,80,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[67,3,67,11],[40,1,40,6],[40,10,40,12],[41,1,41,6],[44,1,44,12],[45,2,48,11],[45,12,46,12],[56,1,59,12],[61,2,61,12],[62,2,62,10],[64,2,64,11],[66,3,66,11],[24,1,24,12],[26,1,26,12],[33,1,33,12],[36,1,38,4],[36,5,38,11],[36,12,38,12],[22,1,22,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],[11,4,11,8],[11,10,11,12],[14,7,16,12],[19,1,20,12],[21,1,21,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,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 6."]
[]
[]
[]
[]
[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,"TRAFFIC ENGINEERING AND OPERATIONS STUDIES - QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M81","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S73:S128)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R80)","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(M37=\"not rated\",\"\",(IF(M37=\"\",\"\",(IF(M37<3,\"COMMENTS REQUIRED\",(IF(M37>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","Intelligent Transportation Systems Communications"]
[]
[null,null,"EXPECTATION:\nThis type of work requires documented experience involving electronic engineering of system hardware, digital system design, specifications, and utilization. The experience must involve electrical engineering of power and communications, including power distribution, standby power supply, lightning protection, hardware interconnect, fiber optic networks, wireless communications networks, local area networks, wide area networks, internet communications, data recording, data transmission, modulating, and multiplexing techniques.  \n\nNOTE: Deliverables to be considered within this grading item include Communications Plans, Communications Technical memorandums and Reports.   "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"ITS Communications are developed and specified in accordance with digital design plans and specifications. All systems work including Traffic Management Center communications are complete and far exceed FDOT expectations, with no assistance from FDOT."]
[null,null,4,"ITS Communications are completed in accordance with digital design plans and specifications. All systems work including Traffic Management Center communications are complete and frequently exceed FDOT expectations, with some assistance from FDOT."]
[null,null,3,"ITS Communications are completed in accordance with digital design plans and specifications. All systems work including Traffic Management Center communications are complete and meet FDOT expectations, with expected assistance from FDOT."]
[null,null,2,"ITS Communications are completed in accordance with digital design plans and specifications. All systems work including Traffic Management Center communications are complete with more than expected assistance from FDOT Staff."]
[null,null,1,"ITS Communications are completed in accordance with digital design plans and specifications. All systems work including Traffic Management Center communications are complete with substantial assistance from FDOT Staff."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M73)=0),\"NA\",M73*(S73/$R$39))","v":"NA"},{"$f":"IF(COUNT(P73)=0,-(S73/$R$39),0)","v":-1},{"$f":"COUNT(M73)","v":0},{"$f":"IF(L73=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P83,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P80)","v":0},{"$f":"SUM(Q73:Q80)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q80))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P81/P82","v":{"$error":"#DIV/0!"}}]

{"sheet":"6.3.4 ITS Software Development","index":5,"n_rows":83,"n_cols":19,"rows_kept":83,"cut":false,"hidden":false,"merged":[[74,2,77,11],[74,12,75,12],[81,7,83,12],[80,8,80,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[67,3,67,11],[40,1,40,6],[40,10,40,12],[41,1,41,6],[44,1,44,12],[45,2,48,11],[45,12,46,12],[56,1,59,12],[61,2,61,12],[62,2,62,10],[64,2,64,11],[66,3,66,11],[24,1,24,12],[26,1,26,12],[33,1,33,12],[36,1,38,4],[36,5,38,11],[36,12,38,12],[22,1,22,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],[11,4,11,8],[11,10,11,12],[14,7,16,12],[19,1,20,12],[21,1,21,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,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 6."]
[]
[]
[]
[]
[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,"TRAFFIC ENGINEERING AND OPERATIONS STUDIES - QUALITY EVALUATION CRITERIA",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5]
[null,"GENERAL PERFORMANCE RATING SCALE",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,5,"Outstanding Performance",null,null," - Consultant consistently exceeded expectations.",null,null,null,null,null,null,null,null,null,3.5]
[null,4,"Above Satisfactory Performance",null,null," - Consultant consistently met, often exceeded, expectations.",null,null,null,null,null,null,null,null,null,3]
[null,3,"Satisfactory Performance",null,null," - Consultant consistently met expectations.",null,null,null,null,null,null,null,null,null,2.5]
[null,2,"Below Satisfactory Performance",null,null," - Consultant inconsistently met expectations.",null,null,null,null,null,null,null,null,null,2]
[null,1,"Unacceptable Performance",null,null," - Consultant consistently failed to meet expectations.",null,null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"**{See specific performance measure guidelines within each criteria item}**"]
[]
[]
[null,null,null,null,null,"TOTAL SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M81","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S73:S127)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R79)","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(M37=\"not rated\",\"\",(IF(M37=\"\",\"\",(IF(M37<3,\"COMMENTS REQUIRED\",(IF(M37>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n "]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","Intelligent Transportation Systems Software Development"]
[]
[null,null,"EXPECTATION:\nThis type of work requires documented experience in software development, specifically with intelligent transportation systems applications, and computer science (real-time process control software systems, including real-time executive Input/Output (I/O) processing and priority interrupt-based processing). The experience must also involve system software testing and debugging, data base software, graphical user interfaces, system documentation, and training of operations personnel.   \n\nThe following objectives shall be applied in the evaluation of this Work Type: \n1. Minimize number of submittals of coding and software application for Department review.\n2. Maintain consistency with other established Department software that may interface and support the application being developed. "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"All ITS software development, testing, debugging, system documentation and training are completed and far exceed FDOT expectations, with no assistance from FDOT. "]
[null,null,4,"All ITS software development, testing, debugging, system documentation and training are completed and frequently exceed FDOT expectations, with some assistance from FDOT."]
[null,null,3,"All ITS software development, testing, debugging, system documentation and training are completed and meet FDOT expectations, with expected level of assistance from FDOT."]
[null,null,2,"All ITS software development, testing, debugging, system documentation and training are completed below FDOT expectations and with more than expected assistance from FDOT Staff."]
[null,null,1,"All ITS software development, testing, debugging, system documentation and training are completed far below FDOT expectations and with substantial assistance from FDOT Staff."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M73)=0),\"NA\",M73*(S73/$R$39))","v":"NA"},{"$f":"IF(COUNT(P73)=0,-(S73/$R$39),0)","v":-1},{"$f":"COUNT(M73)","v":0},{"$f":"IF(L73=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P83,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P80)","v":0},{"$f":"SUM(Q73:Q80)","v":-1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q80))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P81/P82","v":{"$error":"#DIV/0!"}}]