{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Progress Report Phase III","Personnel Summary","Direct Cost Summary","CPFF Invoice"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":23,"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":"Instructions","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,1]]}
[]
[]
["To expedite processing your invoices, please follow these guidelines when preparing & submitting invoices for payment:"]
[]
["1.","Complete the worksheets in order of appearance. Project information and totals feed into progressive worksheets.   Complete where shaded grey or yellow only."]
[]
["2.","When necessary, add lines for additional items, employees and/or subconsultants.  Buttons are provided in each worksheet to add rows."]
[]
["3.","Use appropriate invoice form for the type of contract you have.  Please make sure you use the latest form.  "]
[]
[null,"Note:  The most recent invoices posted on the internet do not have a retainage line.  As of November 2003, we no longer retain from the consultants.  Please download the latest version of the invoice form."]
[]
["4.","Submit two complete packages (with attachments) and two copies of the invoice form.  The Progress Report and Invoice sheets must be SIGNED and DATED by the appropriate consultant staff prior to submittal."]
[]
[null,"Note:  PTB and Job number from original selection must appear on all pages of invoice. Do NOT use the construction project number."]
[]
[null,"Please note:  Meals can be charged only if associated with travel.  If overnight travel, per diem should be used in ¼ day increments in accordance with the Illinois State Travel Control Board (http://www.state.il.us/cms/2_servicese_oth/trvlguid.htm).  "]
[]
[null,"Direct costs must be negotiated & included in your agreement to be reimbursable.  Please do not submit direct costs that cannot be processed.  If a direct cost needs to be added, a supplemental agreement must be approved."]
[]
["5.","Subconsultants should submit the proper state invoice form to the prime consultant for payment.  A copy of each subconsultant invoice MUST be signed as approved by the prime consultant and included with the invoice from the prime consultant as documentation for Services by Others. The subconsultant Progress Report  Phase III MUST also be signed as approved, verifying the subconsultant has completed the percentage of work they are invoicing the prime consultant for."]
["6.","Do NOT include copies of timecards nor receipts unless requested for special circumstances"]
[]
["7.","When approved overhead changes, submit a copy of the approval letter with the first affected invoice."]
[]
["8.","To PRINT the CPFF Invoice with attachments, key in \"Ctrl+p\".  Otherwise select the appropriate sheets and select File then Print from the pull down menu.  The sheets should be submitted in the following order:"]
[null,"                                                                    \u0097  CPFF Invoice"]
[null,"                                                                    \u0097  Progress Report Phase III"]
[null,"                                                                    \u0097  Personnel Summary"]
[null,"                                                                    \u0097  Direct Cost Summary"]
[]
[null,"Note:  final print should be set to print document in black & white so that shading in fields will not be shown."]

{"sheet":"Progress Report Phase III","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,1,37,2],[38,1,38,2],[39,1,39,2],[11,7,11,8],[5,7,5,8],[6,7,6,8],[8,7,8,8],[9,7,9,8],[36,1,36,2]]}
[]
[null,null,null,null,null,null,null,null,"Construction Engineering"]
[null,null,null,null,null,null,null,null,"Progress Report"]
["Consultant:"]
[]
["PTB / Item #",null,null,null,null,null,"Invoice No."]
["Route",null,null,null,null,null,"Work Order No."]
["Section"]
["County",null,null,null,null,null,"Invoice Period Starting:"]
["Job No.",null,null,null,null,null,"Invoice Period Ending:"]
[]
["Note: This form needs to be submitted with each monthly invoice. Please make sure that you list each construction",null,null,null,null,null,"Resident Engineer"]
["contract and its values. (Please note: A, B, C Jobs must be separated.)"]
[]
[null,"Manhours",null,null,"Engineering $ Summary"]
["Const. Contract #","Total Man-hours","Projected Manhours to Complete","Expended Manhours to Date","Total $ Auth. (1)","Total $ Projected to Complete (2)","Total $ Expended to Date","% of Contract Complete","Projected $/Surplus to Completion\n(1)-(2)"]
[null,null,null,null,null,null,null,{"$f":"IF(E17=0,\"\",G17/E17)","v":""},{"$f":"IF(ISBLANK(E17),\"\",IF(ISBLANK(F17),\"\",E17-F17))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(E18=0,\"\",G18/E18)","v":""},{"$f":"IF(ISBLANK(E18),\"\",IF(ISBLANK(F18),\"\",E18-F18))","v":""}]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,"",""]
[]
["Totals",{"$f":"IF(SUM(B17:B25)=0,0,SUM(B17:B25))","v":0},{"$f":"IF(SUM(C17:C25)=0,0,SUM(C17:C25))","v":0},{"$f":"IF(SUM(D17:D25)=0,0,SUM(D17:D25))","v":0},{"$f":"IF(SUM(E17:E25)<=0,0,SUM(E17:E25))","v":0},{"$f":"IF(SUM(F17:F25)=0,0,SUM(F17:F25))","v":0},{"$f":"IF(SUM(G17:G25)=0,0,SUM(G17:G25))","v":0},{"$f":"IFERROR(G26/E26,0)","v":0},{"$f":"IFERROR(E26-F26,0)","v":0}]
[]
["Contract Value:",null,null,null,null,null,"Date"]
["Amount of original contract"]
["Amount of Modification One"]
[]
[]
[]
["Current Upper Limit of Compensation:",null,null,null,{"$f":"IF(SUM(E29:E32)=0,0,SUM(E29:E32))","v":0}]
[]
["Programmed Dollar Values:",null,null,null,"Amount Remaining"]
["FY09 ="]
["FY10 =",null,null,null,null,"Submitted by:"]
[null,null,null,null,null,"Consultant:",{"$f":"IF(B4=\"\",\"\",B4)","v":""}]
[]
[]
[null,"Project is Progressing within the fiscal year and job duration funding limits"]
[null,"Project is not progressing within the fiscal year and job duration funding limits"]
["Check one of the above",null,null,null,"Reviewed and approved by:"]

{"sheet":"Personnel Summary","index":2,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[13,0,13,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[26,0,26,1],[27,0,27,1],[38,0,38,1],[47,0,47,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[28,0,28,1],[29,0,29,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[19,0,19,1],[46,0,46,1]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Cost Plus Fixed Fee"]
[null,null,null,null,null,null,null,null,null,null,"Personnel Summary"]
[null,null,null,null,null,null,null,null,null,null,"for Period"]
[]
["Firm Name",{"$f":"IF('Progress Report Phase III'!B4=\"\",\"\",'Progress Report Phase III'!B4)","v":""},null,null,null,null,"From:",{"$f":"IF('Progress Report Phase III'!H9=\"\",\"\",'Progress Report Phase III'!H9)","v":""},null,"To:",{"$f":"IF('Progress Report Phase III'!H109=\"\",\"\",'Progress Report Phase III'!H109)","v":""}]
[]
["PTB / Item #",null,null,null,null,null,null,null,null,"Invoice No.",{"$f":"IF('Progress Report Phase III'!H6=\"\",\"\",'Progress Report Phase III'!H6)","v":""}]
["Route"]
["Section",null,null,null,null,null,null,null,null,"Work Order No.",{"$f":"IF('Progress Report Phase III'!H7>0,'Progress Report Phase III'!H7,\" \")","v":" "}]
["County"]
["Job No."]
[]
["Employee",null,"Classification","Regular Hours","Overtime Premium Hours","Hours","Rate**","Direct\nSalaries\nTotal",null,"Premium Rate","Overtime Premium Cost"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D15),\"\",D15+E15)","v":""},null,{"$f":"IF(ISBLANK(F15),\"\",IF(ISBLANK(G15),\"\",IFERROR(F15*G15,\"\")))","v":""},null,null,{"$f":"IF(J15>0,J15*E15,\" \")","v":" "}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D16),\"\",D16+E16)","v":""},null,{"$f":"IF(ISBLANK(F16),\"\",IF(ISBLANK(G16),\"\",IFERROR(F16*G16,\"\")))","v":""},null,null,{"$f":"IF(J16>0,J16*E16,\" \")","v":" "}]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",null,"",null,null," "]
[null,null,null,null,null,"",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(ISNUMBER(D40+E40),D40+E40,\" \")","v":0},null,{"$f":"IF(+F40*G40>0,+F40*G40,\" \")","v":" "},null,null," "]
["Total Labor excluding QC/QA",null,null,{"$f":"IF(SUM(D15:D40)=0,\"\",SUM(D15:D40))","v":""},{"$f":"IF(SUM(E15:E40)=0,\"\",SUM(E15:E40))","v":""},"",null,{"$f":"IF(SUM(H15:H40)=0,0,SUM(H15:H40))","v":0},null,"Total",{"$f":"IF(SUM(K15:K40)=0,0,SUM(K15:K40))","v":0}]
[]
["QC/QA"]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D44),\"\",D44+E44)","v":""},null,{"$f":"IF(ISBLANK(F44),\"\",IF(ISBLANK(G44),\"\",IFERROR(F44*G44,\"\")))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D45),\"\",D45)","v":""},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(ISNUMBER(D49+E49),D49+E49,\" \")","v":0},null,{"$f":"IF(ISBLANK(D49),\"\",IF(ISBLANK(G49),\"\",IFERROR(F49*G49,\"\")))","v":""}]
["Total Labor for QC/QA",null,null,{"$f":"IF(SUM(D44:D49)=0,\"\",SUM(D44:D49))","v":""},null,{"$f":"IF(SUM(F44:F49)=0,\"\",SUM(F44:F49))","v":""},null,{"$f":"IF(SUM(H44:H49)=0,0,SUM(H44:H49))","v":0}]
["TOTAL LABOR",null,null,null,null,null,null,{"$f":"IFERROR(H41+H50,0)","v":0}]

{"sheet":"Direct Cost Summary","index":3,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,6,24,7],[28,0,28,1],[18,0,18,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[26,0,26,1],[26,6,26,7],[19,6,19,7],[25,6,25,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[20,6,20,7],[13,0,13,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,6,18,7],[14,6,14,7],[15,6,15,7],[16,6,16,7],[17,6,17,7]]}
[]
[null,null,null,null,null,null,null,"Cost Plus Fixed Fee"]
[null,null,null,null,null,null,null,"Direct Cost Summary"]
[null,null,null,null,null,null,null,"for Period"]
[]
["Firm Name",{"$f":"IF('Progress Report Phase III'!B4=\"\",\"\",'Progress Report Phase III'!B4)","v":""},null,null,"      From:",{"$f":"IF('Progress Report Phase III'!H9=\"\",\"\",'Progress Report Phase III'!H9)","v":""},"To:",{"$f":"IF('Progress Report Phase III'!H109=\"\",\"\",'Progress Report Phase III'!H109)","v":""}]
[]
["PTB/Item #",{"$f":"IF('Progress Report Phase III'!B6>0,'Progress Report Phase III'!B6,\" \")","v":" "},null,null,null,null,"Invoice No.",{"$f":"IF('Progress Report Phase III'!H6=\"\",\"\",'Progress Report Phase III'!H6)","v":""}]
["Route",{"$f":"IF('Progress Report Phase III'!B7>0,'Progress Report Phase III'!B7,\" \")","v":" "}]
["Section",{"$f":"IF('Progress Report Phase III'!B8>0,'Progress Report Phase III'!B8,\" \")","v":" "},null,null,null,null,"Work Order No.",{"$f":"IF('Progress Report Phase III'!H7>0,'Progress Report Phase III'!H7,\" \")","v":" "}]
["County",{"$f":"IF('Progress Report Phase III'!B9>0,'Progress Report Phase III'!B9,\" \")","v":" "}]
["Job No.",{"$f":"IF('Progress Report Phase III'!B10>0,'Progress Report Phase III'!B10,\" \")","v":" "}]
[]
["Item",null,"Max Allowable Rate","Rate","Quantity","Total","Remarks"]
["Overtime Premium (See Personnel Summary)",null,null,null,null,{"$f":"IF('Personnel Summary'!K41=\"\",0,'Personnel Summary'!K41)","v":0}]
["Mileage",null,null,null,null,{"$f":"IF(ISBLANK(D16),\"\",IF(ISBLANK(E16),\"\",+E16*D16))","v":""}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D17),\"\",IF(ISBLANK(E17),\"\",+E17*D17))","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
["Total for period",null,null,null,null,{"$f":"IF(SUM(F15:F28)=0,0,SUM(F15:F28))","v":0}]

{"sheet":"CPFF Invoice","index":4,"n_rows":63,"n_cols":23,"rows_kept":63,"cut":false,"hidden":false,"merged":[[54,5,54,8],[17,7,17,8],[54,0,54,3],[2,0,2,8],[3,0,3,8],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3]]}
[]
[]
["COST PLUS FIXED FEE"]
["INVOICE (PHASE III)"]
[null,null,null,null,null,"Date:",null,"Invoice No.",{"$f":"IF('Progress Report Phase III'!H6=\"\",\"\",'Progress Report Phase III'!H6)","v":""}]
[null,null,null,null,null,null,null,"Work Order No.",{"$f":"IF('Progress Report Phase III'!H7>0,'Progress Report Phase III'!H7,\" \")","v":" "}]
[]
["To:"," ",null,null,null,"From:",{"$f":"IF('Progress Report Phase III'!B4=\"\",\"\",'Progress Report Phase III'!B4)","v":""}]
[null," ",null,null,null,"Firm Address:"]
[null," "]
[null," "]
[null," "]
[]
[]
["PTB / Item #",{"$f":"IF('Progress Report Phase III'!B6>0,'Progress Report Phase III'!B6,\" \")","v":" "},null,null,"Project"]
["Route",{"$f":"IF('Progress Report Phase III'!B7>0,'Progress Report Phase III'!B7,\" \")","v":" "},null,null,"County",{"$f":"IF('Progress Report Phase III'!B9>0,'Progress Report Phase III'!B9,\" \")","v":" "},null,"Consultant's Job Number"]
["Section",{"$f":"IF('Progress Report Phase III'!B8>0,'Progress Report Phase III'!B8,\" \")","v":" "},null,null,"Job No.",{"$f":"IF('Progress Report Phase III'!B10>0,'Progress Report Phase III'!B10,\" \")","v":" "}]
["Phase"]
[]
[null,null,null,null,null,"For Professional Services performed as set forth in the Agreement dated:"]
[null,null,null,null,null,"& Supplemental Agreement(s) dated:"]
[]
[]
["1)  Invoice Period",null,null,null,null,"From:",{"$f":"IF('Progress Report Phase III'!H9=\"\",\"\",'Progress Report Phase III'!H9)","v":""},"To:",{"$f":"IF('Progress Report Phase III'!H10=\"\",\"\",'Progress Report Phase III'!H10)","v":""}]
[]
[null,null,null,null,null,"This Invoice","Previously Invoiced","Earned to Date","Max allowable",null,null,null,null,null,null,null,null,null," "," "," "," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central Office","Enter IDOT Contact Person's Name","Illinois Department of Transportation","Enter Address","Enter City, State & Zip"]
["2)  Maximum Payable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prime Consultant","Enter Prime Consultant Liaison Engineer","Enter Prime Consultant Company","Enter Address","Enter City, State & Zip"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 1","Diane M. O'Keefe, Region 1 Engineer","Illinois Department of Transportation","201 West Center Court","Schaumburg, IL  60196"]
["3)  Direct Salaries",null,null,null,null,{"$f":"+'Personnel Summary'!H41","v":0},null,{"$f":"IFERROR(+F30+G30,0)","v":0},null,null,null,null,null,null,null,null,null,null,"District 2","George F. Ryan, Region 2 Engineer","Illinois Department of Transportation","819 Depot Avenue","Dixon, IL  61021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 3","George F. Ryan, Region 2 Engineer","Illinois Department of Transportation","700 East Norris Drive","Ottawa, IL  61350"]
["4)  QC/QA ",null,null,null,null,{"$f":"+'Personnel Summary'!H50","v":0},null,{"$f":"IFERROR(+F32+G32,0)","v":0},null,null,null,null,null,null,null,null,null,null,"District 4","Joseph E. Crowe, Region 3 Engineer","Illinois Department of Transportation","401 Main","Peoria, IL  61602"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 5","Joseph E. Crowe, Region 3 Engineer","Illinois Department of Transportation","13473 IL Hwy. 133, P.O. Box 610","Paris, IL  61944"]
["5)  Payroll & Overhead ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 6","Roger L. Driskell, Region 4 Engineer","Illinois Department of Transportation","126 East Ash","Springfield, IL  62704"]
[null,"this invoice",null,null,null,{"$f":"IFERROR(+C35*F30+C35*F32,0)","v":0},null,{"$f":"IFERROR(+F35+G35,0)","v":0},null,null,null,null,null,null,null,null,null,null,"District 7","Roger L. Driskell, Region 4 Engineer","Illinois Department of Transportation","400 W. Wabash","Effingham, IL  62401"]
[null,"average ",{"$f":"IFERROR(+H35/(H30+H32),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 8","Mary C. Lamie, Region 5 Engineer","Illinois Department of Transportation","1102 Eastport Plaza","Collinsville, IL  62234"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"District 9","Mary C. Lamie, Region 5 Engineer","Illinois Department of Transportation","P.O. Box 100","Carbondale, IL  62903"]
["6)  Fixed Fee =",{"$f":"'Progress Report Phase III'!H26","v":0},null,null,null,{"$f":"IFERROR(+I38*B38,0)-G38","v":0},null,{"$f":"IFERROR(+F38+G38,0)","v":0}]
[]
["7)  Direct Costs Prime",null,null,null,null,{"$f":"+'Direct Cost Summary'!F29","v":0},null,{"$f":"IFERROR(+F40+G40,0)","v":0}]
[]
["8)  Services by others"]
[null,null,null,null,null,null,null,{"$f":"IF(F43+G43=0,0,F43+G43)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F44+G44=0,0,F44+G44)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F45+G45=0,0,F45+G45)","v":0}]
[null,null,null,null,null,null,null,{"$f":"+F46+G46","v":0}]
[]
["9)  Total invoiced for project including this invoice",null,null,null,null,null,null,{"$f":"IF(SUM(H28:H46)=0,0,SUM(H28:H46))","v":0}]
[]
["10)  Previously Invoiced",null,null,null,null,null,{"$f":"IF(SUM(G28:G46)=0,0,SUM(G28:G46))","v":0}]
[]
["11)  Payment Due this invoice",null,null,null,null,{"$f":"IF(SUM(F28:F46)=0,0,SUM(F28:F46))","v":0}]
[]
[]
["I have reviewed the invoice and found it in compliance with “The Simple Guide To Consultant Payments” published on the Consultant Engineering Sharepoint site.  The percent of work shown as completed on this invoice matches the attached Progress Report signed by the project engineer.",null,null,null,null,"I certify the costs included in this invoice have been expended and the percent of work shown as completed on this invoice is correct.  As the prime consultant, work invoices included in this invoice for work done by others were reviewed and approved."]
[]
["Approved"]
["IDOT Rep.",null,"Date:","     ",null,"Consultant:",{"$f":"IF('Progress Report Phase III'!B4=\"\",\"\",'Progress Report Phase III'!B4)","v":""}]
[]
["Accepted By:",null,"Date:","     ",null,"By / Date:",null,null,"     "]
[null,null,null,null,null,"(Name)"]
["Checked",null,"Date:","     ",null,"(Title)"]
["Distribution:  2 complete packages plus 2 copies of invoice form to Liaison Engineer."]