{"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":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[14,11,33,11],[35,0,36,5],[17,4,17,5],[15,4,15,5],[16,4,16,5],[18,0,18,5],[33,0,33,5],[20,6,21,8],[32,3,32,5],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,2],[21,1,21,3],[14,0,14,5],[8,5,8,8],[9,0,9,3],[9,7,9,8],[35,6,36,7],[35,8,36,8],[20,0,20,5],[10,4,10,5],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[12,6,12,8],[12,0,13,5],[39,6,39,7],[0,0,0,8],[1,0,1,8],[6,0,6,3],[7,0,7,3],[8,0,8,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[4,4,4,8],[2,4,2,8],[5,0,5,3],[7,4,7,5],[3,4,3,5],[3,7,3,8],[6,4,6,5],[38,0,38,4],[38,5,38,7],[37,0,37,4],[19,0,19,5],[37,5,37,7],[10,6,11,6],[10,7,11,8],[11,0,11,4]]}
["Cost Breakdown Form",null,null,null,null,null,null,null,null,{"$f":"SUM(A46:A49)","v":0}]
["for Maximum Not-to-Exceed (MNTE) 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 NDOT39 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,"Maximum Not-to-Exceed Amount",null,null,null,null,null,null,"Do Not Delete This Column"]
["Agreement amount thru supplement #",null,null,null,null,null,null,null,null,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",null,null,null,null,null,null,null,{"$f":"G15+H15","v":0},null,{"$f":"SUM(L15:O15)","v":0},"↓  INVOICE LOG  ↓",null,0,"Direct Labor"]
[null,null,"Overhead @",null,"of direct labor",null,{"$f":"ROUND(G15*$D$16, 2)","v":0},null,{"$f":"G16+H16","v":0},null,0,null,null,0,"Overhead"]
[null,null,"Profit @",null,"of labor+overhead",null,{"$f":"ROUND((G15+G16)*$D$17,2)","v":0},null,0,null,0,null,null,0,"Fixed Fee"]
[null,null,"FCCM @",null,"of direct labor",null,{"$f":"ROUND(G15*D18,2)","v":0},null,0,null,0,null,null,0,"FCCM"]
["Other Labor (Fixed Billing Rates)",null,null,null,null,null,null,null,0,null,0,null,null,0]
["Direct Costs (Non-Labor)",null,null,null,null,null,null,null,{"$f":"G20+H20","v":0},null,0,null,null,0,"Direct Costs (Non-Labor)"]
["  Outside Services (Subconsultants):",null,null,null,null,null,{"$f":"IF((I36+0.01)<(SUM(E23:E28)-SUM(I23:I28)),\"ERROR: Total Agreement Amount Remaining must NOT be less than unbilled subconsultant costs\",IF(OR(F23=\"over\",F24=\"over\",F25=\"over\",F26=\"over\",F27=\"over\",F28=\"over\"),\"One or more Subs are overbilled\",\"\"))","v":""}]
[null,"Name",null,null,"Max Amount",null,null,null,null,null,null,null,null,null,"Subconsultant Costs"]
[null,null,null,null,null,{"$f":"IF(I23>E23,\"OVER\",\"\")","v":""},null,null,{"$f":"G23+H23","v":0},null,{"$f":"SUM(L23:O23)","v":0},null,null,0,"Sub #1"]
[null,null,null,null,null,{"$f":"IF(I24>E24,\"OVER\",\"\")","v":""},null,null,0,null,{"$f":"SUM(L24:O24)","v":0},null,null,0,"Sub #2"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L25:O25)","v":0},null,null,0,"Sub #3"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L26:O26)","v":0},null,null,0,"Sub #4"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L27:O27)","v":0},null,null,0,"Sub #5"]
[null,null,null,null,null,"",null,null,0,null,{"$f":"SUM(L28:O28)","v":0},null,null,0,"Sub #6"]
["Adjustments:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustments"]
[null,"    Overhead",null,null,null,null,null,null,{"$f":"G30+H30","v":0},null,{"$f":"SUM(L30:O30)","v":0},null,null,0,"OH"]
[null,"    Profit",null,null,null,null,null,null,{"$f":"G31+H31","v":0},null,{"$f":"SUM(L31:O31)","v":0},null,null,0,"FF"]
[null,"    FCCM",null,null,null,null,null,null,{"$f":"G32+H32","v":0},null,{"$f":"SUM(L32:O32)","v":0},null,null,0,"FCCM"]
[null,"Description:",null,null,null,null,null,null,{"$f":"G33+H33","v":0},null,{"$f":"SUM(L33:O33)","v":0},null,null,0,"other"]
["Total Amount DUE >>",null,null,null,null,null,{"$f":"SUM(G15:G20)+SUM(G22:G28)+SUM(G33:G33)","v":0},{"$f":"SUM(H15:H20)+SUM(H22:H28)+SUM(H33:H33)","v":0},{"$f":"G34+H34","v":0},null,{"$f":"SUM(K15:K33)","v":0},null,{"$f":"SUM(M15:M33)","v":0},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(H11-I34<0,\"Overbilled\",H11-I34)","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(I39),IF(G34>0,\"enter date above\",\"\"),\"\")","v":""}]
[]
["NDOT Form 162b, v18.1024 (macro)"]
[]
["Notes:"]
[1,"If Agreement covers multiple Control Numbers, use the smallest number for this Cost Breakdown Form"]
[{"$f":"IF(I36=\"overbilled\",1,0)","v":0}]
[{"$f":"IF(OR(F23=\"OVER\",F24=\"over\",F25=\"over\",F26=\"over\",F27=\"over\",F28=\"over\"),1,0)","v":0}]
[{"$f":"IF(H7<G10,1,0)","v":0}]
[{"$f":"IF(I36<(SUM(E23:E28)-SUM(I23:I28)),1,0)","v":0}]