{"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":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[50,1,50,8],[41,0,41,4],[19,0,19,5],[42,0,42,4],[42,5,42,7],[20,0,20,5],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[43,6,43,7],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[0,0,0,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],[2,4,2,8],[5,0,5,3],[7,4,7,5],[3,4,3,5],[8,5,8,8],[3,7,3,8],[6,4,6,5],[1,2,1,8],[14,11,37,11],[39,0,40,5],[36,2,36,5],[17,4,17,5],[15,4,15,5],[16,4,16,5],[18,0,18,5],[37,0,37,5],[20,6,21,8],[25,1,25,3],[14,4,14,5],[33,1,33,3],[34,1,34,3],[35,1,35,3],[9,0,9,3],[9,7,9,8],[10,4,10,5],[11,4,11,5],[11,0,11,2],[10,2,10,3],[12,6,12,8],[12,0,13,5],[30,0,31,5],[48,1,48,8],[49,1,49,8]]}
["               Cost Breakdown Form",null,null,null,null,null,null,null,null,{"$f":"SUM(A52:A56)","v":0}]
[null,null,"           for Actual Cost Plus Fixed Fee (CPFF) Agreements"]
["Company Name:"]
["1. 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,"2. Expiration 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,"1900-01-01","thru",null,{"$f":"IF(H7<G10, \"BEYOND EXPIRATION DATE\",\"\")","v":""}]
[null,"AGR #",{"$f":"IF(E7=\"\",\"\",UPPER(E7))","v":""},null,"3. Direct Labor Costs",null,"3. All Other Costs","Max Fixed Fee (Profit)","Total Contract Amount",null,null,null,null,"Do Not Delete This Column"]
["Amount thru sup #",null,null,0,null,null,null,null,{"$f":"E12+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>E12,\"labor overbilled\",\"\")","v":""},null,null,0,{"$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},0,{"$f":"G16+H16","v":0},null,0,null,null,0,"Overhead"]
[null,null,"Fixed Fee @",null,"of labor+overhead",null,{"$f":"ROUND((G15+G16)*$D$17,2)","v":0},0,0,null,0,null,null,0,"Fixed Fee"]
[null,null,"FCCM @",null,"of direct labor",null,{"$f":"ROUND(G15*D18,2)","v":0},0,0,null,0,null,null,0,"FCCM"]
[null,null,null,null,null,null,null,0,null,null,0,null,null,0]
["Direct Costs (Non-Labor)",null,null,null,null,null,null,0,{"$f":"G20+H20","v":0},null,0,null,null,0,"Direct Costs (Non-Labor)"]
["Outside Services (Subconsultants):",null,null,null,null,null,{"$f":"IF((I40+0.01)<(SUM(E23:E32)-SUM(I23:I32)),\"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\",F29=\"over\",F30=\"over\",A31=\"over\",F32=\"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,0,{"$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,0,0,null,0,null,null,0,"Sub #2"]
[null,null,null,null,null,"",null,0,0,null,0,null,null,0,"Sub #3"]
[null,null,null,null,null,"",null,0,0,null,0,null,null,0,"Sub #4"]
[null,null,null,null,null,"",null,0,0,null,0,null,null,0,"Sub #5"]
[null,null,null,null,null,"",null,0,0,null,0,null,null,0,"Sub #6"]
[null,null,null,null,null,"",null,0,0,null,0,null,null,0,"Sub #7"]
[null,null,null,null,null,"",null,0,0,null,0,null,null,0,"Sub #8"]
["Comments:  ",null,null,null,null,null,null,null,0,null,0,null,null,0,"Sub #9"]
[null,null,null,null,null,null,null,null,0,null,0,null,null,0,"Sub #10"]
["Adjustments:",null,null,null,{"$f":"IF(H12-(I17+I35)<-0.001,\"ERROR: Fixed Fee is overbilled, make adjustment on line below\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Adjustments"]
[null,"    Overhead",null,null,null,null,null,0,{"$f":"G34+H34","v":0},null,{"$f":"SUM(L34:O34)","v":0},null,null,0,"OH"]
[null,"    Fixed Fee for profit",null,null,null,null,null,0,{"$f":"G35+H35","v":0},null,{"$f":"SUM(L35:O35)","v":0},null,null,0,"FF"]
[null,"    FCCM",null,null,null,null,null,0,{"$f":"G36+H36","v":0},null,{"$f":"SUM(L36:O36)","v":0},null,null,0,"FCCM"]
[null,"Other:",null,null,null,null,null,0,{"$f":"G37+H37","v":0},null,{"$f":"SUM(L37:O37)","v":0},null,null,0,"other"]
["Total Amount DUE >>",null,null,null,null,null,{"$f":"SUM(G15:G20)+SUM(G23:G30)+SUM(G34:G37)","v":0},{"$f":"SUM(H15:H20)+SUM(H23:H30)+SUM(H34:H37)","v":0},{"$f":"G38+H38","v":0},null,{"$f":"SUM(K15:K37)","v":0},null,{"$f":"SUM(M15:M37)","v":0},{"$f":"SUM(N15:N37)","v":0}]
[]
["By submitting this form electronically to State,  Consultant certifies submitted costs are actual and allowed by contract. ",null,null,null,null,null,null,"Total Agreement Amount Remaining:",{"$f":"IF(I12-I38<-0.001,\"Overbilled\",I12-I38)","v":0}]
[null,null,null,null,null,null,null,"Total Fixed Fee Remaining:",{"$f":"IF(H12-(I17+I35)>I40+0.001,I40,H12-(I17+I35))","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(I43),IF(G38>0,\"enter date above\",\"\"),\"\")","v":""}]
[]
["NDOT Form 162,  v20.0801 (macro)"]
[]
["Notes:"]
[1,"If Agreement covers multiple control numbers (projects) always use the smallest number for this Cost Breakdown Form, then your invoice should include the breakdown of costs between all projects."]
[2,"For CE agreements: The expiration date of the agreement is measured 60 calendar days from the construction completion date stated on the NDOT Form 91 “Notification of Contract Completion”."]
[3,"For agreements issued prior to 2019 that do not limit labor costs, under \"Direct Labor Costs\", enter the total cost of the agreement less the fixed fee for profit amount, and leave \"All Other Costs\" blank."]
[{"$f":"IF(I40=\"overbilled\",1,0)","v":0},"check that agreement is not overbilled"]
[{"$f":"IF(OR(F23=\"OVER\",F24=\"over\",F25=\"over\",F26=\"over\",A31=\"over\",F32=\"over\"),1,0)","v":0},"check that individual subs are not overbilled"]
[{"$f":"IF(H7<G10,1,0)","v":0},"check that service date is not past agreement expire date"]
[{"$f":"IF(I40<(SUM(E23:E32)-SUM(I23:I32)),1,0)","v":0},"check that unbilled sub costs are not more than what is left in agreement"]
[{"$f":"IF(H12-(I17+I35)<-0.001,1,0)","v":0},"check that fixed fee for profit is not overbilled"]