{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INVOICE SUMMARY SHEET","SCHEDULE I","ADDITIONAL SCHEDULE I","SCHEDULE II","ADDITIONAL SCHEDULE II","SCHEDULE III","PROGRESS REPORT A","PROGRESS REPORT B","LUMP SUM","   "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"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":"INVOICE SUMMARY SHEET","index":0,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,12,6,17],[3,4,3,5],[4,1,4,5],[5,1,5,5],[3,1,3,2],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[44,0,44,17],[23,16,23,17],[26,16,26,17],[27,16,27,17],[28,16,28,17],[25,13,25,14],[31,16,31,17],[33,16,33,17],[36,16,36,17],[42,16,42,17],[38,0,38,17],[41,13,41,15],[29,16,29,17],[35,16,35,17],[28,3,28,6],[46,0,47,7],[89,7,89,10],[50,7,50,9],[48,0,48,7],[46,11,47,17],[48,11,48,17],[52,3,53,7],[52,8,58,17],[55,3,58,7],[54,3,54,7],[50,14,50,16],[0,14,0,17],[2,4,2,10],[0,4,1,10],[1,15,1,17],[2,15,2,17],[12,7,13,8],[12,9,13,9],[40,0,40,17],[8,9,8,10],[10,9,10,10],[21,13,21,14],[26,13,26,14],[29,13,29,14],[13,2,13,5],[19,16,19,17],[21,16,21,17],[9,12,13,17],[7,0,8,0],[14,2,14,6],[7,1,10,5],[7,9,7,10]]}
[null,null,null,null," ENVIRONMENTAL DIVISION",null,null,null,null,null,null,null,null,null,"TDOT RECEIVED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,"INVOICE SUMMARY",null,null,null,null,null,null,null,null,null,"Name:"]
["PIN",null,null,"REGION",null,null,null,"INVOICE DATE",null,null,null,null,"FIRM NAME "]
["PROJECT #",null,null,null,null,null,null,"INVOICE #"]
["COUNTY",null,null,null,null,null,null,"AGREEMENT #"]
[null,null,null,null,null,null,null,"WORK ORDER #"]
["ROUTE / TERMINI",null,null,null,null,null,null,"PROGRESS #"]
[null,null,null,null,null,null,null,"SUPPLIER ID",null,null,null,null," FIRMS REMITTANCE ADDRESS"]
[]
[null,null,null,null,null,null,null,"FINAL INVOICE? "]
[null,null,null,null,null,null,null,null,null,"(Yes or No)"]
["ENVIRONMENTAL DIVISION CONTACT INFORMATION",null,null,null,null,null,null,"DBE Sub Consultant"]
["PROJECT MANAGER:"]
["DISCIPLINE:",null,"NATURAL CHANNEL STREAM DESIGN",null,null,null,null,null,null,"(Yes or No)"]
[]
[" ",null,"                          INVOICE SERVICE RANGE:",null,null,null,null,null,"TO:"]
[]
[]
[null,"I.","Direct Labor        (Per Schedule No. 1 - attached)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE I'!$H$59","v":0}]
[]
[null,"II.","Overhead:           Payroll Additives, General & Administrative.",null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"ROUND((Q20*N22),2)","v":0}]
[null,null,"                          (Direct Labor as shown in I. times Billed Overhead rate)"]
["SUBTOTAL LABOR & OVERHEAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Q20:R22),2)","v":0}]
[]
[null,"III.","Net Fee per agreement:",null,null,null,null,null,null,null,null,null,null,{"$f":"'PROGRESS REPORT A'!$G$58","v":0}]
[null,null,null,"Percentage Complete To Date:",null,null,null,null,null,null,null,null,null,{"$f":"'PROGRESS REPORT A'!$F$59","v":0},null,"%",{"$f":"'PROGRESS REPORT A'!$G$59","v":0}]
[null,null,null,"Less: Net Fee Billed to Date:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'PROGRESS REPORT A'!$G$60","v":0}]
[null,null,null,"Net Fee Due this invoice or",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Q27-Q28,2)","v":0}]
[null,null,null,"Final Invoice taking Net Fee",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Direct Costs:       (Per Schedule 2 - attached)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'SCHEDULE II'!$L$77","v":0}]
[]
[null,null,"Sub-Consultants: (Per Schedule 3 - attached)",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
["AMOUNT DUE THIS INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Q24+Q29+Q30+Q32+Q34),2)","v":0}]
[]
[]
[]
[]
[]
[]
[]
["I, the undersigned, do hereby certify that the above invoice is true and correct to the best of my knowledge and that payment has not been received or costs previously invoiced."]
[]
[]
[]
["Firm's Signature                                                                           Title",null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["ENV. DIVISION APPROVALS ONLY"]
[]
["CONTRACTS SECTION",null,null,"Department of Transportation ENVIRONMENTAL DIVISION",null,null,null,null,"PROJECT MANAGER"]
["PO #"]
[null,null,null,"Date :"]
["REC #",null,null,"Approved By:"]
[]
["VOUCHER #"]

{"sheet":"SCHEDULE I","index":1,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,0,7],[58,5,58,6],[3,5,3,6],[2,0,2,1],[3,0,3,1],[2,2,2,4],[3,2,3,4],[57,5,57,6]]}
["Schedule I - Direct Labor Summary"]
[]
["Consultant Firm",null,{"$f":"'INVOICE SUMMARY SHEET'!$M$5","v":0},null,null,null,"Invoice #",{"$f":"'INVOICE SUMMARY SHEET'!$J$5","v":0}]
["Project No.",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0},null,null,"Progress Billing No",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[]
[]
[null,"DATE","EMPLOYEE","POSITION","TASK SUMMARY","HOURLY RATE","TOTAL HOURS WORKED","COST"]
[null,null,null,null,null,0,null,{"$f":"ROUND((F8*G8),2)","v":0}]
[null,null,null,null,null,0,null,{"$f":"ROUND((F9*G9),2)","v":0}]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,"DIRECT LABOR SUBTOTAL",null,{"$f":"ROUND(SUM(H8:H57),2)","v":0}]
[null,null,null,null,null,"TOTAL DIRECT LABOR",null,{"$f":"H58+'ADDITIONAL SCHEDULE I'!H58","v":0}]

{"sheet":"ADDITIONAL SCHEDULE I","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,5,57,6],[0,0,0,7],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[3,5,3,6]]}
["Schedule I - Direct Labor Summary"]
[]
["Consultant Firm",null,{"$f":"'INVOICE SUMMARY SHEET'!$M$5","v":0},null,null,null,"Invoice #",{"$f":"'INVOICE SUMMARY SHEET'!$J$5","v":0}]
["Project No.",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0},null,null,"Progress Billing No",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[]
[]
[null,"DATE","EMPLOYEE","POSITION","TASK SUMMARY","HOURLY RATE","TOTAL HOURS WORKED","COST"]
[null,null,null,null,null,0,null,{"$f":"ROUND((F8*G8),2)","v":0}]
[null,null,null,null,null,0,null,{"$f":"ROUND((F9*G9),2)","v":0}]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,"SUBTOTAL DIRECT LABOR",null,{"$f":"ROUND(SUM(H8:H57),2)","v":0}]

{"sheet":"SCHEDULE II","index":3,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,10,3,12],[7,10,7,11],[46,6,46,9],[33,1,33,2],[46,3,46,5],[20,1,20,2],[7,1,7,5],[8,1,8,5],[20,10,20,11],[33,10,33,11],[46,10,46,11],[48,1,48,11],[63,1,63,5],[33,3,33,5],[20,3,20,5],[47,2,47,5],[47,6,47,11],[20,6,20,9],[46,1,46,2],[21,6,21,11],[22,1,22,11],[76,8,76,10],[70,7,70,10],[71,7,71,10],[59,7,59,11],[60,7,60,10],[61,7,61,10],[62,7,62,10],[63,7,63,10],[64,7,64,10],[65,7,65,10],[72,7,72,10],[69,7,69,10],[67,7,67,10],[68,7,68,10],[66,7,66,10],[0,0,0,12],[33,6,33,9],[34,2,34,5],[34,6,34,11],[35,1,35,11],[5,1,5,11],[9,1,9,11],[8,6,8,11],[7,6,7,9],[2,0,2,1],[3,0,3,1],[3,2,3,4],[2,10,2,12],[21,2,21,5],[2,2,2,4],[3,5,3,9]]}
["Schedule II - Summary of Direct Costs"]
[]
["Consultant Firm",null,{"$f":"'INVOICE SUMMARY SHEET'!$M$5","v":0},null,null,null,null,null,null,"Invoice #",{"$f":"'INVOICE SUMMARY SHEET'!$J$5","v":0}]
["Project No.",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0},null,null,"Progress Billing No",null,null,null,null,{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[]
[null,"Lodging and Mileage Summary"]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance: ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F12=\"Yes\",75%*K8,IF(F12=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J12*G12","v":0},{"$f":"ROUND(D12+E12+K12,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F13=\"Yes\",75%*K8,IF(F13=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J13*G13","v":0},{"$f":"ROUND(D13+E13+K13,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F14=\"Yes\",75%*K8,IF(F14=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F15=\"Yes\",75%*K8,IF(F15=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F16=\"Yes\",75%*K8,IF(F16=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F17=\"Yes\",75%*K8,IF(F17=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F18=\"Yes\",75%*K8,IF(F18=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L12:L18),2)","v":0}]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance:    ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F25=\"Yes\",75%*K8,IF(F25=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J25*G25","v":0},{"$f":"ROUND(D25+E25+K25,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F26=\"Yes\",75%*K8,IF(F26=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J26*G26","v":0},{"$f":"ROUND(D26+E26+K26,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F27=\"Yes\",75%*K8,IF(F27=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F28=\"Yes\",75%*K8,IF(F28=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F29=\"Yes\",75%*K8,IF(F29=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F30=\"Yes\",75%*K8,IF(F30=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F31=\"Yes\",75%*K8,IF(F31=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L25:L31),2)","v":0}]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance: ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F38=\"Yes\",75%*K8,IF(F38=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J38*G38","v":0},{"$f":"ROUND(D38+E38+K38,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F39=\"Yes\",75%*K8,IF(F39=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J39*G39","v":0},{"$f":"ROUND(D39+E39+K39,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F40=\"Yes\",75%*K8,IF(F40=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F41=\"Yes\",75%*K8,IF(F41=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F42=\"Yes\",75%*K8,IF(F42=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F43=\"Yes\",75%*K8,IF(F43=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F44=\"Yes\",75%*K8,IF(F44=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L38:L44),2)","v":0}]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance: ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F51=\"Yes\",75%*K8,IF(F51=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J51*G51","v":0},{"$f":"ROUND(D51+E51+K51,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F52=\"Yes\",75%*K8,IF(F52=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J52*G52","v":0},{"$f":"ROUND(D52+E52+K52,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F53=\"Yes\",75%*K8,IF(F53=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F54=\"Yes\",75%*K8,IF(F54=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F55=\"Yes\",75%*K8,IF(F55=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F56=\"Yes\",75%*K8,IF(F56=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F57=\"Yes\",75%*K8,IF(F57=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L51:L57),2)","v":0}]
[]
[null,null,null,null,null,null,null,"Other Direct Costs"]
[null,null,null,null,null,null,null,"Description",null,null,null,"Cost"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*DON'T FORGET TO ATTACH RECEIPTS*",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L62:L73),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL OF ALL DIRECT COSTS",null,null,{"$f":"ROUND(L74+L58+L45+L32+L19+'ADDITIONAL SCHEDULE II'!L77,2)","v":0}]

{"sheet":"ADDITIONAL SCHEDULE II","index":4,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,0,2,1],[2,2,2,4],[2,10,2,12],[3,0,3,1],[3,2,3,4],[3,5,3,9],[3,10,3,12],[5,1,5,11],[7,1,7,5],[7,6,7,9],[7,10,7,11],[8,1,8,5],[8,6,8,11],[9,1,9,11],[20,1,20,2],[20,3,20,5],[20,6,20,9],[21,2,21,5],[21,6,21,11],[20,10,20,11],[22,1,22,11],[33,1,33,2],[33,3,33,5],[33,6,33,9],[34,2,34,5],[34,6,34,11],[33,10,33,11],[63,1,63,5],[63,7,63,10],[35,1,35,11],[46,1,46,2],[46,3,46,5],[46,6,46,9],[47,2,47,5],[47,6,47,11],[46,10,46,11],[48,1,48,11],[59,7,59,11],[60,7,60,10],[61,7,61,10],[62,7,62,10],[70,7,70,10],[71,7,71,10],[72,7,72,10],[76,8,76,10],[64,7,64,10],[65,7,65,10],[66,7,66,10],[67,7,67,10],[68,7,68,10],[69,7,69,10]]}
["Schedule II - Summary of Direct Costs"]
[]
["Consultant Firm",null,{"$f":"'INVOICE SUMMARY SHEET'!$M$5","v":0},null,null,null,null,null,null,"Invoice #",{"$f":"'INVOICE SUMMARY SHEET'!$J$5","v":0}]
["Project No.",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0},null,null,"Progress Billing No",null,null,null,null,{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[]
[null,"Lodging and Mileage Summary"]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance: ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F12=\"Yes\",75%*K8,IF(F12=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J12*G12","v":0},{"$f":"ROUND(D12+E12+K12,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F13=\"Yes\",75%*K8,IF(F13=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J13*G13","v":0},{"$f":"ROUND(D13+E13+K13,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F14=\"Yes\",75%*K8,IF(F14=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F15=\"Yes\",75%*K8,IF(F15=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F16=\"Yes\",75%*K8,IF(F16=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F17=\"Yes\",75%*K8,IF(F17=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F18=\"Yes\",75%*K8,IF(F18=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L12:L18),2)","v":0}]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance:    ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F25=\"Yes\",75%*K8,IF(F25=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J25*G25","v":0},{"$f":"ROUND(D25+E25+K25,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F26=\"Yes\",75%*K8,IF(F26=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J26*G26","v":0},{"$f":"ROUND(D26+E26+K26,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F27=\"Yes\",75%*K8,IF(F27=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F28=\"Yes\",75%*K8,IF(F28=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F29=\"Yes\",75%*K8,IF(F29=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F30=\"Yes\",75%*K8,IF(F30=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F31=\"Yes\",75%*K8,IF(F31=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L25:L31),2)","v":0}]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance: ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F38=\"Yes\",75%*K8,IF(F38=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J38*G38","v":0},{"$f":"ROUND(D38+E38+K38,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F39=\"Yes\",75%*K8,IF(F39=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J39*G39","v":0},{"$f":"ROUND(D39+E39+K39,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F40=\"Yes\",75%*K8,IF(F40=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F41=\"Yes\",75%*K8,IF(F41=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F42=\"Yes\",75%*K8,IF(F42=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F43=\"Yes\",75%*K8,IF(F43=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F44=\"Yes\",75%*K8,IF(F44=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L38:L44),2)","v":0}]
[]
[null,"Consultant Name: ",null,null,null,null,"Per Diem Allowance: ",null,null,null,0]
[null,"Purpose:",null,null,null,null,"Destination:"]
[]
[null,null,"Date (MM/DD/YY)","Lodging (Rate + Tax)","Per Diem (1st/Last Day = 75%)","Arrival or Departure Date?","Mileage","Departure Location","Destination Location","Mileage Rate","Mileage Cost","Cost"]
[null,"Sunday",null,null,{"$f":"IF(F51=\"Yes\",75%*K8,IF(F51=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J51*G51","v":0},{"$f":"ROUND(D51+E51+K51,2)","v":0}]
[null,"Monday",null,null,{"$f":"IF(F52=\"Yes\",75%*K8,IF(F52=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,{"$f":"J52*G52","v":0},{"$f":"ROUND(D52+E52+K52,2)","v":0}]
[null,"Tuesday",null,null,{"$f":"IF(F53=\"Yes\",75%*K8,IF(F53=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Wednesday",null,null,{"$f":"IF(F54=\"Yes\",75%*K8,IF(F54=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Thursday",null,null,{"$f":"IF(F55=\"Yes\",75%*K8,IF(F55=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Friday",null,null,{"$f":"IF(F56=\"Yes\",75%*K8,IF(F56=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,"Saturday",null,null,{"$f":"IF(F57=\"Yes\",75%*K8,IF(F57=\"N/A\",0,K8))","v":0},"N/A",null,null,null,0.47,0,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L51:L57),2)","v":0}]
[]
[null,null,null,null,null,null,null,"Other Direct Costs"]
[null,null,null,null,null,null,null,"Description",null,null,null,"Cost"]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,"*DON'T FORGET TO ATTACH RECEIPTS*",null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"ROUND(SUM(L62:L73),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"SUBTOTAL OF DIRECT COSTS",null,null,{"$f":"ROUND(L74+L58+L45+L32+L19,2)","v":0}]

{"sheet":"SCHEDULE III","index":5,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,4,2,5],[3,0,3,1],[3,3,3,4],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[2,0,2,1],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[6,1,6,2],[7,1,7,2],[5,1,5,2],[8,1,8,2],[9,1,9,2],[0,0,0,6],[34,0,34,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,3,32,5],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2]]}
["Schedule III - Summary of Sub-Consultant Costs"]
[]
["Consultant Firm",null,{"$f":"'INVOICE SUMMARY SHEET'!$M$5","v":0},"Invoice #",{"$f":"'INVOICE SUMMARY SHEET'!$J$5","v":0}]
["Project No.",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0},"Progress Billing No",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[]
["DATE","DESCRIPTION",null,"RATE","UNIT","QUANTITY","TOTAL COST"]
[null,null,null,0,null,null,{"$f":"ROUND((D7*F7),2)","v":0}]
[null,null,null,0,null,null,{"$f":"ROUND((D8*F8),2)","v":0}]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,0,null,null,0]
[null,null,null,"TOTAL SUB-CONSULTANT COSTS",null,null,{"$f":"ROUND(SUM(G7:G32),2)","v":0}]
[]
["*DON'T FORGET TO ATTACH RECEIPTS*"]

{"sheet":"PROGRESS REPORT A","index":6,"n_rows":67,"n_cols":7,"rows_kept":67,"cut":false,"hidden":false,"merged":[[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[50,2,50,3],[19,2,19,3],[26,2,26,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[27,2,27,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[1,2,1,6],[2,1,2,2],[2,4,2,6],[3,4,3,6],[6,4,6,6],[4,4,4,6],[0,0,0,7],[54,2,54,3],[55,2,55,3],[66,2,68,6],[5,4,5,6],[8,4,8,6],[9,4,9,6],[3,1,9,2],[53,2,53,3],[20,2,20,3],[21,2,21,3],[51,2,51,3],[52,2,52,3],[13,2,13,3],[14,2,14,3],[15,2,15,3]]}
["Progress Report"]
[]
[null,"Route / Termini",null,"Consultant Firm Name",{"$f":"'INVOICE SUMMARY SHEET'!$M$5","v":0}]
[null,{"$f":"'INVOICE SUMMARY SHEET'!$B$8","v":0},null,"Agreement No. ",{"$f":"'INVOICE SUMMARY SHEET'!$J$6","v":0}]
[null,null,null,"Work Order #",{"$f":"'INVOICE SUMMARY SHEET'!$J$7","v":0}]
[null,null,null,"Progress Billing No. ",{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[null,null,null,"Work Completed Through ",{"$f":"'INVOICE SUMMARY SHEET'!$J$17","v":"00:00:00"}]
[]
[null,null,null,"Project No.",{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0}]
[null,null,null,"PIN",{"$f":"'INVOICE SUMMARY SHEET'!$B$4","v":0}]
[]
[]
[]
[null,"TDOT SCOPE","DESCRIPTION/COMMENTS",null,"PERCENTAGE OF WORK","PERCENTAGE COMPLETE TO DATE","EFFECTIVE PERCENTAGE"]
[null,null,null,null,0,0,{"$f":"ROUND((E15*F15)/100,1)","v":0}]
[null,null,null,null,0,0,{"$f":"ROUND((E16*F16)/100,1)","v":0}]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,"WORK COMPLETED TO DATE",null,null,null,{"$f":"ROUND(SUM(G15:G53),2)","v":0}]
[null,null,"LESS WORK COMPLETED TO DATE LAST INVOICE"]
[null,null,"WORK COMPLETED THIS PAY PERIOD",null,null,null,{"$f":"ROUND(G54-G55,2)","v":0}]
[]
[null,null,null,"NET FEE CEILING",null,null,0]
[null,null,null,"Percentage Completed to Date",null,{"$f":"G54","v":0},{"$f":"ROUND(F59%*G58,2)","v":0}]
[null,null,null,"Less Net Fee Billed to Date",null,null,0]
[null,null,null,"Net Fee Due this Invoice",null,null,{"$f":"ROUND(G59-G60,2)","v":0}]
[]
[]
[null,null,null,"Total Net Fee Billed as of Current Invoice",null,null,{"$f":"ROUND(G60+G61,2)","v":0}]
[]
[]
[null,"NOTES:"]

{"sheet":"PROGRESS REPORT B","index":7,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,3,2,8],[3,3,3,5],[4,4,4,5],[5,3,5,5],[0,0,0,8],[38,4,38,6],[38,7,38,8],[3,6,3,7],[4,6,4,7],[5,6,5,7],[6,6,6,7],[7,6,7,7],[35,5,35,6],[36,5,36,6],[6,4,6,5],[7,4,7,5],[9,7,9,8],[10,7,10,8],[11,7,11,8],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[24,1,24,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2]]}
["Progress Report"]
[]
[null,"Project:",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$8","v":0}]
[null,"PIN:",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$4","v":0},null,null,"Invoice Date",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$4","v":"00:00:00"}]
[null,"Project Number:",null,null,{"$f":"'INVOICE SUMMARY SHEET'!$B$5","v":0},null,"Invoice Number",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$5","v":0}]
[null,"County:",null,{"$f":"'INVOICE SUMMARY SHEET'!$B$6","v":0},null,null,"Progress Billing",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$8","v":0}]
[null,"Agreement Number:",null,null,{"$f":"'INVOICE SUMMARY SHEET'!$J$6","v":0},null,"Final Invoice",null,"NO"]
[null,"State/Federal Funded",null,null,null,null,"Work Order #",null,{"$f":"'INVOICE SUMMARY SHEET'!$J$7","v":0}]
[]
[null,"Work Order Ceiling (with Addenda)",null,null,null,null,null,0]
[null,"Net Fee Ceiling (With Addenda) ",null,null,null,null,null,0]
[null,"Total Cost (with Addenda)",null,null,null,null,null,{"$f":"ROUND(H10-H11,2)","v":0}]
[]
[]
[null,"Progress Billing",null,"Period Start","Period End","Percent this Period","Percent to Date","Total Cost this Period","Net Fee this Period"]
[null,1,null,"MON-DD-YR",null,0,0,0,0]
[null,2,null,null,null,0,0,0,0]
[null,3,null,null,null,0,0,0,0]
[null,4,null,null,null,0,0,0,0]
[null,5,null,null,null,0,0,0,0]
[null,6,null,null,null,0,0,0,0]
[null,7,null,null,null,0,0,0,0]
[null,8,null,null,null,0,0,0,0]
[null,9,null,null,null,0,0,0,0]
[null,10,null,null,null,0,0,0,0]
[null,11,null,null,null,0,0,0,0]
[null,12,null,null,null,0,0,0,0]
[null,13,null,null,null,0,0,0,0]
[null,14,null,null,null,0,0,0,0]
[null,15,null,null,null,0,0,0,0]
[null,16,null,null,null,0,0,0,0]
[null,17,null,null,null,0,0,0,0]
[null,18,null,null,null,0,0,0,0]
[null,19,null,null,null,0,0,0,0]
[null,20,null,null,null,0,0,0,0]
[null,null,null,null,null,"Total to Date",null,{"$f":"ROUND(SUM(H16:H35),2)","v":0},{"$f":"ROUND(SUM(I16:I35),2)","v":0}]
[null,null,null,null,null,"Remaining",null,{"$f":"ROUND(H12-H36,2)","v":0},{"$f":"ROUND(H11-I36,2)","v":0}]
[]
[null,null,null,null,"Work Order Remaining",null,null,{"$f":"ROUND(H37+I37,2)","v":0}]

{"sheet":"LUMP SUM","index":8,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[87,7,87,10],[43,0,43,17],[45,0,46,7],[45,11,46,17],[47,0,47,7],[47,11,47,17],[49,7,49,9],[49,14,49,17],[41,16,41,17],[23,16,23,17],[24,2,24,3],[24,16,24,17],[26,16,26,17],[27,16,27,17],[29,16,29,17],[31,16,31,17],[33,16,33,17],[38,7,38,8],[39,13,39,15],[40,13,40,15],[18,2,18,3],[18,16,18,17],[20,3,20,5],[21,2,21,5],[14,2,14,6],[7,9,7,10],[8,1,10,5],[8,9,8,10],[9,12,13,17],[10,9,10,10],[13,2,13,5],[0,4,1,10],[0,14,0,17],[1,15,1,17],[2,4,2,10],[2,15,2,17],[3,1,3,2],[3,4,3,5],[3,9,3,10],[51,3,52,7],[4,1,4,5],[4,9,4,10],[22,2,22,3],[51,8,57,17],[53,3,53,7],[54,3,57,7],[4,12,6,17],[5,1,5,5],[5,9,5,10],[6,1,6,5],[6,9,6,10],[22,16,22,17]]}
[null,null,null,null," ENVIRONMENTAL DIVISION",null,null,null,null,null,null,null,null,null,"TDOT RECEIVED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,"LUMP SUM INVOICE SUMMARY",null,null,null,null,null,null,null,null,null,"Name:"]
["PIN",null,null,"REGION",null,null,null,"INVOICE DATE",null,null,null,null,"FIRM NAME "]
["PROJECT #",null,null,null,null,null,null,"INVOICE #"]
["COUNTY",null,null,null,null,null,null,"AGREEMENT #"]
["ROUTE",null,null,null,null,null,null,"WORK ORDER #"]
[null,null,null,null,null,null,null,"PROGRESS #"]
["TERMINI",null,null,null,null,null,null,"SUPPLIER ID",null,null,null,null," FIRMS REMITTANCE ADDRESS"]
[]
[null,null,null,null,null,null,null,"FINAL INVOICE? "]
[null,null,null,null,null,null,null,null,null,"(Yes or No)"]
["ENVIRONMENTAL DIVISION CONTACT INFORMATION"]
["PROJECT MANAGER:",null,null,null,null,null,null,"DBE Sub Consultant"]
["WORK TYPE:",null,"NATURAL CHANNEL STREAM DESIGN",null,null,null,null,null,null,"(Yes or No)"]
[]
[" ",null,"                          INVOICE SERVICE RANGE:",null,null,null,null,null,"TO:"]
[]
[null,"I.","Work Order Ceiling:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"II.","% complete as of ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,"Current billable amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM((Q19*R21)),2)","v":0}]
[]
[null,null,"Less previously invoiced:",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["TOTAL DUE THIS INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Q23-Q25),2)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["I, the undersigned, do hereby certify that the above invoice is true and correct to the best of my knowledge and that payment has not been received or costs previously invoiced."]
[]
[]
[]
["Firm's Signature",null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["ENV. DIVISION APPROVALS ONLY",null,null,null,null,null,null,null,null,null,"SPEED CHART #: "]
[]
["CONTRACTS SECTION",null,null,"Department of Transportation ENVIRONMENTAL DIVISION",null,null,null,null,"PROJECT MANAGER"]
["PO #"]
[null,null,null,"Date :"]
["REC #",null,null,"Approved By:"]
[]
["VOUCHER #"]

{"sheet":"   ","index":9,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["ARCHAEOLOGY"]
["AIR & NOISE"]
["BEAUTIFICATION "]
["CULTURAL RESOURCES"]
["COMPLIANCE - CONSTRUCTION"]
["COMPLIANCE - FACILITY "]
["ECOLOGY"]
["ECOLOGY - BATS"]
["HAZARDOUS MATERIALS"]
["MITIGATION"]
["HISTORIC"]
["NATURAL CHANNEL STREAM DESIGN"]
["NEPA"]
["PERMITS"]
[]
[]
[]
[]
["YES"]
["NO"]
["N/A"]
[]
["HOURLY"]
["LUMP SUM"]