{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TC 40-2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"TC 40-2","index":0,"n_rows":56,"n_cols":56,"rows_kept":56,"cut":false,"hidden":false,"merged":[[24,0,24,56],[9,1,9,56],[4,1,4,56],[8,1,8,6],[8,7,8,56],[23,27,23,33],[23,34,23,40],[23,41,23,47],[46,45,47,56],[11,27,11,33],[12,27,12,33],[11,34,11,40],[12,34,12,40],[11,41,11,47],[12,41,12,47],[31,1,31,47],[31,48,31,56],[32,1,32,47],[32,48,32,56],[39,1,39,47],[39,48,39,56],[40,1,40,47],[40,48,40,56],[13,41,13,47],[21,48,21,56],[22,48,22,56],[20,1,20,26],[21,1,21,26],[22,1,22,26],[21,34,21,40],[22,34,22,40],[21,27,21,33],[22,27,22,33],[15,1,15,26],[16,1,16,26],[17,1,17,26],[20,34,20,40],[6,42,6,46],[6,47,6,56],[6,7,6,15],[6,16,6,21],[6,22,6,41],[12,48,12,56],[11,1,12,26],[13,1,13,26],[14,1,14,26],[13,48,13,56],[19,34,19,40],[19,27,19,33],[19,48,19,56],[17,27,17,33],[19,1,19,26],[15,41,15,47],[18,27,18,33],[18,34,18,40],[20,48,20,56],[36,1,36,56],[44,1,44,56],[25,1,25,41],[26,1,26,41],[27,1,27,41],[29,48,29,56],[29,1,29,47],[28,1,28,56],[14,48,14,56],[15,48,15,56],[16,48,16,56],[17,48,17,56],[18,48,18,56],[18,1,18,26],[37,1,37,47],[37,48,37,56],[25,42,25,45],[26,42,26,45],[27,42,27,45],[35,48,35,56],[35,1,35,47],[30,48,30,56],[33,48,33,56],[34,48,34,56],[48,8,48,33],[48,40,48,56],[41,48,41,56],[42,48,42,56],[55,2,55,23],[55,25,55,44],[55,46,55,55],[50,46,51,55],[50,25,51,44],[50,2,51,23],[53,46,54,55],[53,25,54,44],[53,2,54,23],[52,25,52,44],[52,46,52,55],[52,2,52,23],[45,1,45,47],[45,48,45,56],[41,1,41,47],[42,1,42,47],[3,1,3,56],[27,48,27,56],[6,1,6,6],[25,48,25,56],[26,48,26,56],[43,1,43,47],[43,48,43,56],[16,41,16,47],[17,41,17,47],[18,41,18,47],[19,41,19,47],[20,41,20,47],[21,41,21,47],[22,41,22,47],[23,48,23,56],[15,34,15,40],[16,34,16,40],[15,27,15,33],[16,27,16,33],[17,34,17,40],[13,27,13,33],[14,27,14,33],[38,1,38,47],[38,48,38,56],[30,1,30,47],[33,1,33,47],[34,1,34,47],[23,1,23,26],[0,42,0,56],[1,16,1,41],[2,16,2,41],[2,42,2,50],[2,51,2,52],[2,53,2,54],[2,55,2,56],[1,51,1,56],[1,42,1,50],[5,1,5,56],[0,1,2,15],[0,16,0,41],[7,1,7,6],[7,7,7,56],[10,1,10,56],[13,34,13,40],[14,34,14,40],[14,41,14,47],[11,48,11,56],[20,27,20,33]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KENTUCKY TRANSPORTATION CABINET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TC 40-2     "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Department of Highways",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev.",null,null,null,null,null,null,null,null,"12/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVISION OF PROFESSIONAL SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,null,null,null,null,null,null,null,1,null,"of",null,1]
[null,"ENGINEERING AND RELATED SERVICES FEE PROPOSAL"]
[]
[null,"  SECTION 1:  PROJECT INFORMATION"]
[null,"DATE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY:",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ITEM #:",null,null,null,null,""]
[null,"PROJECT:",null,null,null,null,null,""]
[null,"DESC:",null,null,null,null,null,""]
[]
[null,"  SECTION 2:  BUDGET INFORMATION"]
[null,"FEE CONSIDERATIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROPOSED",null,null,null,null,null,null,"NEGOTIATED",null,null,null,null,null,null,"AVERAGE",null,null,null,null,null,null,"ESTIMATED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HOURS",null,null,null,null,null,null,"HOURS",null,null,null,null,null,null,"RATE",null,null,null,null,null,null,"COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI14=\"\",ROUND(AB14*AP14,2),ROUND(AI14*AP14,2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI15=\"\",ROUND(AB15*AP15,2),ROUND(AI15*AP15,2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"TOTAL PRODUCTION HOURS & PAYROLL  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM(AB14:AH23)=0,\"\",SUM(AB14:AH23)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM(AI14:AO23)=0,\"\",SUM(AI14:AO23)),\"\")","v":""},null,null,null,null,null,null,{"$f":"IFERROR(AW24/AI24,\"\")","v":""},null,null,null,null,null,null,{"$f":"SUM(AW14:BE23)","v":0}]
[]
[null,"OVERHEAD (",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",")",{"$f":"(AQ26*0.01)*SUM(AW14:BE23)","v":0}]
[null,"PROFIT (",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",")",{"$f":"(AQ27*0.01)*(AW24+AW26)","v":0}]
[null,"COST OF MONEY (",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",")",{"$f":"(AQ28*0.01)*AW24","v":0}]
[]
[null,"DIRECT COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMOUNT"]
[]
[]
[]
[]
[]
[null,"TOTAL DIRECT COSTS  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AW31:BD35)","v":0}]
[]
[null,"SUBCONSULTANTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AMOUNT"]
[]
[]
[]
[]
[]
[null,"TOTAL SUBCONSULTANTS  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AW39:BD43)","v":0}]
[]
[null,"TOTAL FEE  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AW24,AW26,AW27,AW28,AW36,AW44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Rounded to the nearest dollar"]
[null,"  SECTION 3:  SIGNATURE"]
[null,"  FIRM NAME:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," SIGNED BY: "]
[]
[]
[]
[null,null,"CONSULTANT SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE"]
[]
[]
[null,null,"PROFESSIONAL SERVICES SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TITLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATE"]