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

{"sheet":"Table 1","index":0,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,7,9,8],[10,4,10,5],[7,4,7,5],[6,0,6,3],[7,0,7,3],[8,0,8,3],[0,2,0,8],[2,0,2,3],[3,0,3,3],[4,0,4,3],[4,4,4,8],[2,4,2,8],[5,0,5,3],[3,4,3,5],[3,7,3,8],[1,2,1,8],[9,0,9,3],[6,4,6,5],[8,5,8,8],[11,0,11,4],[32,0,32,4],[32,5,32,7],[12,6,12,8],[12,0,13,5],[29,6,30,7],[29,8,30,8],[17,0,17,5],[26,3,26,5],[26,1,26,2],[23,1,23,3],[24,1,24,3],[14,0,14,3],[14,4,14,5],[38,1,38,9],[14,11,27,11],[29,0,30,5],[15,0,15,5],[27,0,27,5],[18,1,18,3],[17,6,18,8],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[35,0,35,4],[31,0,31,4],[16,0,16,5],[33,6,33,7],[31,5,31,7]]}
[null,null,"Cost Breakdown Form",null,null,null,null,null,null,{"$f":"SUM(A43:A46)","v":0}]
[null,null,"Specific Rates of Compensation (Fixed Labor) Agreements"]
["Company Name:"]
["Control No.:",null,null,null,null,null,"Project No.:"]
["Project Location:"]
["AFE No.:",null,null,null,"n/a"]
["Agreement No.:",null,null,null,null,null,"Expire Date:"]
["Invoice No.:",null,null,null,null,null,"Invoice Date:"]
["% Work Completed:",null,null,null,null,{"$f":"IF(ISBLANK(E8),\"\",IF(E9=1,\"Please submit a completed NDOT-39 per instructions on form\",IF(ISBLANK(E9),\"Please indicate % Work Completed\",\"\")))","v":""}]
["Current Billing Period:",null,null,null,null,"thru",null,{"$f":"IF(H7<G10, \"BEYOND EXPIRATION DATE\",\"\")","v":""}]
[null,null,null,"Agreement No:",{"$f":"IF(E7=\"\",\"\",UPPER(E7))","v":""},null,"Actual Labor Costs","Direct Non-labor Costs","Total Contract Amount",null,null,null,null,"Do Not Delete This Column"]
["Agreement amount thru supplement #",null,null,null,null,null,null,null,{"$f":"G12+H12","v":0},null,{"$f":"G10+1","v":"1900-01-01"},"Invoice Date:"]
[null,null,null,null,null,null,"Amount                                              ",null,null,null,{"$f":"E8","v":0},"Period End:",null,0]
[null,null,null,null,null,null,"This Period","Previously Billed","To Date",null,"Sum of previously billed","Invoice #:",null,"zero"]
["Direct Labor Costs",null,null,null,{"$f":"IF(I15>G12,\"labor overbilled\",\"\")","v":""},null,null,null,{"$f":"G15+H15","v":0},null,{"$f":"SUM(L15:O15)","v":0},"↓ INVOICE LOG ↓",null,0,"Direct Labor"]
[]
["Direct Costs (Non-Labor)",null,null,null,null,null,null,null,{"$f":"G17+H17","v":0},null,{"$f":"SUM(L17:O17)","v":0},null,null,0,"Direct Costs (Non-Labor)"]
["  Outside Services (Subconsultants):",null,null,null,null,null,{"$f":"IF(I30=\"overbilled\", \"Agreement Overbilled\",IF((I30+0.001)<(SUM(E20:E25)-SUM(I20:I25)),\"ERROR: Total Agreement Amount Remaining must NOT be less than unbilled subconsultant costs\",IF(OR(F20=\"over\",F21=\"over\",F22=\"over\",F23=\"over\",F24=\"over\",F25=\"over\"),\"ERROR: One or more Subs are overbilled\",\"\")))","v":""}]
[null,"Name",null,null,"Max Amount",null,null,null,null,null,null,null,null,null,"Outside Services (Subconsultants):"]
[null,null,null,null,null,{"$f":"IF(I20>E20,\"OVER\",\"\")","v":""},null,null,{"$f":"G20+H20","v":0},null,{"$f":"SUM(L20:O20)","v":0},null,null,0,"Sub #1"]
[null,null,null,null,null,{"$f":"IF(I21>E21,\"OVER\",\"\")","v":""},null,null,0,null,{"$f":"SUM(L21:O21)","v":0},null,null,0,"Sub #2"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L22:O22)","v":0},null,null,0,"Sub #3"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L23:O23)","v":0},null,null,0,"Sub #4"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L24:O24)","v":0},null,null,0,"Sub #5"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L25:O25)","v":0},null,null,0,"Sub #6"]
["Adjustments:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustments"]
[null,"Description:",null,null,null,null,null,null,{"$f":"G27+H27","v":0},null,{"$f":"SUM(L27:O27)","v":0},null,null,0]
["Total Amount DUE >>",null,null,null,null,null,{"$f":"SUM(G15:G17)+SUM(G20:G25)+G27","v":0},{"$f":"SUM(H15:H17)+SUM(H20:H25)+H27","v":0},{"$f":"G28+H28","v":0},null,{"$f":"SUM(K15:K27)","v":0},null,{"$f":"SUM(M15:M27)","v":0},{"$f":"SUM(N15:N27)","v":0}]
[]
["By submitting this form electronically to State, Consultant certifies submitted costs are actual and allowed by contract",null,null,null,null,null,"Total Agreement Amount Remaining:",null,{"$f":"IF(I12+0.001-I28<0,\"Overbilled\",I12-I28)","v":0}]
[]
["Signature (typed or signed name required):",null,null,null,null,"Title:",null,null,"Date:"]
[]
[null,null,null,null,null,"Consultant's email contact for invoice-related questions:",null,null,{"$f":"IF(ISBLANK(I33),IF(G28>0,\"enter date above\",\"\"),\"\")","v":""}]
[]
["NDOT Form 162a,  v18.0801 (macro)"]
[]
["Notes:"]
[1,"If Agreement covers multiple control numbers (projects) use the smallest number for this Cost Breakdown Form, then your invoice should include the breakdown of costs between all projects."]
[]
[]
[]
[{"$f":"IF(H7<G10, 1,0)","v":0},"check that end of service period date is not past agreement expiration date"]
[{"$f":"IF(I12-I28<0,1,0)","v":0},"check that agreement is not overbilled"]
[{"$f":"IF(OR(F20=\"OVER\",F21=\"over\",F22=\"over\",F23=\"over\",F24=\"over\",F25=\"over\"),1,0)","v":0},"check that each sub is not overbilled"]
[{"$f":"IF(I30<(SUM(E20:E25)-SUM(I20:I25)),1,0)","v":0},"check that unbilled sub costs are not more than what is left in agreement"]