{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["5.1, 5.2, 5.3 Bridge Inspection","5.4 Bridge Load Rating "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"5.1, 5.2, 5.3 Bridge Inspection","index":0,"n_rows":177,"n_cols":19,"rows_kept":177,"cut":false,"hidden":false,"merged":[[174,8,174,11],[47,12,48,12],[74,12,75,12],[113,12,114,12],[167,12,168,12],[66,3,66,11],[67,3,67,11],[68,3,68,11],[69,3,69,11],[103,2,103,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[74,2,77,11],[163,3,163,11],[9,10,9,12],[61,2,61,12],[56,1,59,12],[179,1,179,12],[178,1,178,12],[175,7,177,12],[38,12,40,12],[157,2,157,11],[159,3,159,11],[160,3,160,11],[161,3,161,11],[43,1,43,6],[107,3,107,11],[105,3,105,11],[106,3,106,11],[108,3,108,11],[10,4,10,8],[10,10,10,12],[38,5,40,11],[38,1,40,4],[15,7,18,12],[1,10,1,12],[2,5,2,6],[3,1,3,3],[3,4,3,7],[3,10,3,12],[4,1,4,3],[4,4,4,8],[4,10,4,12],[6,4,6,8],[6,10,6,12],[5,10,5,12],[8,4,8,8],[8,10,8,12],[5,4,5,8],[7,4,7,8],[42,10,42,12],[7,10,7,12],[21,1,22,12],[26,1,26,12],[23,1,23,12],[24,1,24,12],[9,4,9,8],[42,1,42,6],[11,4,11,8],[11,10,11,12],[28,1,28,12],[35,1,35,12],[46,1,46,12],[164,3,164,11],[166,1,166,12],[167,2,170,11],[109,3,109,11],[110,3,110,11],[112,1,112,12],[113,2,116,11],[162,3,162,11],[62,2,62,10],[155,2,155,10],[101,2,101,10],[47,2,50,11],[64,2,64,11]]}
[]
[]
[]
[null,"Consultant Contract #",null,null,null,null,null,null,"FM No(s).:"]
[null,"Project Title:"]
[null,"Prime Consultant Business Name:"]
[null,"Sub Consultant Business Name:"]
[null,"Engineer of Record:"]
[null,"Design Firm:"]
[null,"Consultant Project Manager:"]
[null,"FDOT Project Manager:"]
[null,"FDOT PM Phone No:"]
[]
[]
[]
[null,null,null,null,null,null,null,"If more than one Work Type is being evaluated, use a separate but identical evaluation form for each Work Type within Group 5."]
[]
[]
[]
[]
[]
[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 is restricted to FDOT Project Managers."]
[]
[null,"BRIDGE INSPECTION 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 AVERAGE SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M175","v":"Not Rated"},null,null,null,"Total Sections:",{"$f":"SUM(S72:S172)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R172)","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(M39=\"not rated\",\"\",(IF(M39=\"\",\"\",(IF(M39<3,\"COMMENTS REQUIRED\",(IF(M39>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions:"]
[null,"For each evaluation item below, please rate from 1 to 5 in accordance with the performance rating scale. Ratings in ½ point (0.5) increments between 1 and 5 are permitted. Comments are required for all rating scores less than 3 and greater than 4, but comments are encouraged for all evaluation items rated. \n\nPLEASE NOTE:  Work Group 5 evaluators are REQUIRED to provide a rating score for each evaluation item."]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","BRIDGE INSPECTION "]
[]
[null,null,"EXPECTATION:\nBridge inspection is performed in accordance with all approved Federal and State statutes, policies, guidelines, and standards (e.g., National Bridge Inspection Standards (NBIS), the FDOT “Bridge and Other Structures Inspection and Reporting Manual”, Bridge Management System (BMS) Coding Guide, Bridge Inspection Field Guide, etc.).  Bridge inspection findings accurately represent the current condition of the bridge.  Proper inspection methods (e.g., visual, non-destructive testing, and/or material sampling) utilized during inspection.  Bridge safely inspected with appropriate equipment and manpower.  All bridge members (based on the inspection type) were carefully accessed and examined.   Demonstrates knowledge of Department and District Procedures. \n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, communication and coordination between the bridge inspection firm and the Department is encouraged."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Compliance with technical criteria far exceeded FDOT expectations. Above objectives achieved with only minor assistance by FDOT."]
[null,null,4,"Compliance with technical criteria exceeded FDOT expectations. Above objectives achieved with some assistance by FDOT. "]
[null,null,3,"Compliance with technical criteria met FDOT expectations. Above objectives achieved with expected assistance by FDOT."]
[null,null,2,"Compliance with technical criteria did not meet minimum FDOT expectations. Above objectives achieved with substantial assistance by FDOT. "]
[null,null,1,"Compliance with technical criteria significantly missed minimum FDOT expectations. Above objectives achieved with significant assistance by FDOT. \t"]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M73)=0),\"NA\",M73*(S73/$R$39))","v":"NA"},{"$f":"IF(COUNT(P73)=0,-(S73/$R$39),0)","v":-0.33333333333333331},{"$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,"B.","INSPECTION REPORTING"]
[]
[null,null,"EXPECTATION:\nBridge inspection reporting is accurate, complete, and in accordance with all approved Federal and State statutes, policies, guidelines, and standards (e.g., National Bridge Inspection Standards (NBIS), the FDOT “Bridge and Other Structures Inspection and Reporting Manual”, Bridge Management System (BMS) Coding Guide, Bridge Inspection Field Guide, etc.).  Bridge inspection report accurately documents inspection findings for each bridge element, inspector recommendations, photographs and sketches, Comprehensive Inventory Data Report (CIDR) information, among other items, to reflect the current condition of the bridge and for load rating purposes.  Demonstrates knowledge of Department and District Procedures. Reports demonstrate that a thorough Quality Control Process was followed prior to submitting.\n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, communication and coordination between the bridge inspection firm and the Department is encouraged.\n "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Inspection reporting far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with only minor editing by FDOT."]
[null,null,4,"Inspection reporting often exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some editing by FDOT. "]
[null,null,3,"Inspection reporting consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected editing by FDOT."]
[null,null,2,"Inspection reporting sometimes achieved FDOT expectations.  Above objectives achieved with substantial editing by FDOT. "]
[null,null,1,"Inspection reporting consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance and editing by FDOT."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M112)=0),\"NA\",M112*(S112/$R$39))","v":"NA"},{"$f":"IF(COUNT(P112)=0,-(S112/$R$39),0)","v":-0.33333333333333331},{"$f":"COUNT(M112)","v":0},{"$f":"IF(L112=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,"C.","INSPECTION PERSONNEL  "]
[]
[null,null,"EXPECTATION:\nThe Professional Engineer performing the inspection is appropriate based on the bridge type and complexity of the bridge being inspected (Reference Rule 14-75). The Professional Engineer performing the inspection or the Professional Engineer overseeing the inspection qualifies the Firm under Work Type 5.1, 5.2, and 5.3 as applicable.  The Firm utilized necessary equipment, and safe access techniques to accomplish the bridge inspection."]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Inspection personnel qualifications far exceed expectations and requirements to accomplish the inspection (i.e., significant experience in structural inspections for similar bridge types)."]
[null,null,4,"Inspection personnel qualifications exceed expectations and requirements to accomplish the inspection (i.e., substantial experience in structural inspections for similar bridge types)."]
[null,null,3,"Inspection personnel qualifications met expectations and requirements to accomplish the inspection (i.e., basic experience in structural inspections for similar bridge types)."]
[null,null,2,"Inspection personnel qualifications did not meet minimum expectations to accomplish the inspection (i.e., inadequate experience in structural inspections for similar bridge types), but did meet minimum requirements."]
[null,null,1,"Inspection personnel qualifications significantly lacked minimum experience or did not meet minimum requirements to accomplish the inspection (i.e., no experience in structural inspections for similar bridge types)."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M166)=0),\"NA\",M166*(S166/$R$39))","v":"NA"},{"$f":"IF(COUNT(P166)=0,-(S166/$R$39),0)","v":-0.33333333333333331},{"$f":"COUNT(M166)","v":0},{"$f":"IF(L166=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M166=\"N/A\",\"\",(IF(M166=\"\",\"\",(IF(M166<3,\"COMMENTS REQUIRED\",(IF(M166>4,\"COMMENTS REQUIRED\",\"\")))))))","v":""}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R40=R39),P177,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P173)","v":0},{"$f":"SUM(Q73:Q173)","v":-1}]
[null,null,null,null,null,null,null,"Reminder: Work Group 5 evaluators are required to provide a rating score for each evaluation item. ",null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q173))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P175/P176","v":{"$error":"#DIV/0!"}}]

{"sheet":"5.4 Bridge Load Rating ","index":1,"n_rows":118,"n_cols":19,"rows_kept":118,"cut":false,"hidden":false,"merged":[[116,7,118,12],[119,1,119,12],[120,1,120,12],[115,8,115,11],[104,3,104,11],[105,3,105,11],[107,1,107,12],[108,2,111,11],[108,12,109,12],[103,3,103,11],[68,3,68,11],[69,3,69,11],[70,3,70,11],[71,3,71,11],[73,1,73,12],[74,2,77,11],[74,12,75,12],[96,2,96,10],[98,2,98,11],[100,3,100,11],[101,3,101,11],[102,3,102,11],[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],[19,1,20,12],[21,1,21,12],[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]]}
[]
[]
[]
[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 5."]
[]
[]
[]
[]
[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 is restricted to FDOT Project Managers."]
[]
[null,"BRIDGE INSPECTION 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 AVERAGE SCORE FOR ALL QUALITY CRITERIA:",null,null,null,null,null,null,{"$f":"M116","v":"Not Rated"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Sections:",{"$f":"SUM(S73:S172)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sections graded:",{"$f":"SUM(R73:R113)","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\nPLEASE NOTE:  Work Group 5 evaluators are REQUIRED to provide a rating score for each evaluation item."]
[]
[]
[]
[]
[null,null,"QUALITY EVALUATION CRITERIA"]
[null,"A.","BRIDGE LOAD RATING"]
[]
[null,null,"EXPECTATION:\nBridge load rating is performed in accordance with all approved Federal and State statutes, policies, guidelines, and standards (e.g., AASHTO Manual for Bridge Evaluation, FDOT Bridge Load Rating Manual, FDOT Structures Manual, etc.).  Demonstrates knowledge of Department and District Procedures. Complete and organized bridge load rating documentation provided based on as-inspected structural condition, including thorough narrative of inspection findings, methodology, analysis assumptions, and applicable as-built plans / inspection sketches.  Submittals demonstrate that a thorough Quality Control Process was followed prior to submitting.\n\nIn general, meeting the above objectives with minimal involvement by FDOT is desirable, however, communication and coordination between the load rating firm and the Department is encouraged. "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Load rating analysis and documentation far exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with minimal assistance from FDOT.  No errors were found during review of the load rating analysis."]
[null,null,4,"Load rating analysis and documentation exceeded FDOT expectations, requirements and guidelines.  Above objectives achieved with some assistance from FDOT.  Only insignificant errors were found during review of the load rating analysis."]
[null,null,3,"Load rating analysis and documentation consistently achieved FDOT expectations, requirements and guidelines.  Above objectives achieved with expected assistance from FDOT.  Minor errors may have been found during review of the load rating analysis."]
[null,null,2,"Load rating analysis and documentation did not achieve all FDOT expectations.  Above objectives achieved with substantial assistance from FDOT.  Errors were found in the load rating analysis that required resubmittal of the load rating. "]
[null,null,1,"Load rating analysis and documentation consistently did not achieve FDOT expectations.  Above objectives achieved with significant assistance and editing from FDOT. Multiple resubmissions of the load rating analysis were required due to significant errors."]
[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":-0.5},{"$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,"B.","LOAD RATING PERSONNEL"]
[]
[null,null,"EXPECTATION:\nIndividual listed as Load Rating Engineer of Record is appropriate based on the bridge type and complexity of the bridge being load rated (Reference Rule 14-75).    Individuals listed as load rating initiator, load rating checker for the load rating calculations are appropriate based on the complexity and type of bridge being load rated (Reference Rule 14-75).  At least one individual active in the load rating qualifies the Firm under Work Type 5.4. \n "]
[]
[null,null,"Score","Performance Measure Guidelines"]
[null,null,5,"Load rating personnel qualifications far exceed FDOT expectations to perform the analysis (i.e., significant experience in load rating analyses for similar bridge types)."]
[null,null,4,"Load rating personnel qualifications exceed FDOT expectations to perform the analysis (i.e., substantial experience in load rating analyses for similar bridge types)."]
[null,null,3,"Load rating personnel qualifications met FDOT expectations to perform the analysis (i.e., basic experience in load rating analyses for similar bridge types)."]
[null,null,2,"Load rating personnel qualifications did not meet minimum FDOT expectations to perform the analysis (i.e., inadequate experience in load rating analyses for similar bridge types)."]
[null,null,1,"Load rating personnel qualifications significantly missed minimum FDOT expectations to perform the analysis (i.e., no experience in load rating analyses for similar bridge types)."]
[null,null,null,null,null,null,null,null,null,null,null,"Score:",null,null,null,{"$f":"IF((COUNT(M107)=0),\"NA\",M107*(S107/$R$39))","v":"NA"},{"$f":"IF(COUNT(P107)=0,-(S107/$R$39),0)","v":-0.5},{"$f":"COUNT(M107)","v":0},{"$f":"IF(L107=0,0,1)","v":1}]
[null,"Comments:"]
[null,null,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,null,null,null,null,null,null,null,"Total Average Score:",null,null,null,{"$f":"IF((R40=0),\"Not Rated\",IF((R39=R40),P118,\"INCOMPLETE\"))","v":"Not Rated"},null,null,{"$f":"SUM(P73:P114)","v":0},{"$f":"SUM(Q73:Q114)","v":-1}]
[null,null,null,null,null,null,null,"Reminder: Work Group 5 evaluators are required to provide a rating score for each evaluation item. ",null,null,null,null,null,null,null,{"$f":"(1+SUM(Q73:Q114))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P116/P117","v":{"$error":"#DIV/0!"}}]