{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Monthly Report"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"Monthly Report","index":0,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,6,3,7],[42,5,42,7],[41,5,41,7],[35,5,35,7],[40,5,40,7],[39,5,39,7],[38,5,38,7],[37,5,37,7],[36,5,36,7],[47,5,47,7],[46,5,46,7],[45,5,45,7],[44,5,44,7],[43,5,43,7],[49,5,49,7],[15,6,15,7],[14,6,14,7],[0,3,0,7],[1,3,1,7],[2,3,2,7],[5,0,5,7],[6,0,6,7],[12,5,13,5],[12,6,13,7],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[48,5,48,7],[55,4,55,5],[54,1,54,3],[18,6,18,7],[17,6,17,7],[16,6,16,7],[23,6,23,7],[22,6,22,7],[21,6,21,7],[20,6,20,7],[19,6,19,7],[28,6,28,7],[27,6,27,7],[26,6,26,7],[25,6,25,7],[24,6,24,7],[50,5,50,7]]}
["TAD Project #:",null,"Prime Contractor Name:"]
["TAD Contract #:",null,"Project Title:"]
["Original Contract Amount ($):",null,"Revised Contract \nAmount $ (if applicable):"]
["Pay Estimate #:",null,"Contr. Award Date:",null,null,"Final Report?","[Select]"]
[]
["Instructions: This form shall be submitted with each pay estimate.  Entries must include all types of subcontracts awarded or committed, including: professional or consultant services, construction, purchase of materials or supplies, lease or purchase of equipment and any other types of services.\n"]
["Note: Refer to the Executed Construction Contract for more details and requirements for subcontracts. This form is also used by TDOT to verify receipt of WEEKLY certified payrolls. For Federally funded construction projects exceeding $2,000, the Prime Contractor is responsible for payment of prevailing wages and fringe benefits. Certified payrolls applies to the Prime and all Subcontractors, excluding Professional Employees subject to CFR Title 29 Part 541.300. See Flyer for more info.\n"]
["Type of Contracts"]
["Subcontract",null,"*Report the full amount to committed and paid to suppliers.\n"]
["Supplier*","If you have any questions about this form or what you are required to document, please contact the Engineer or Airport Sponsor."]
["Manufacturer"]
["Contracts and Subcontracts Awarded/Committed and Payments Made (Include all types of subcontracts)"]
["Type of Contract or Agreement","Business/Vendor Name","Original Contract Amount ($)","Date of Award/ Commitment ","Did Sub work this Pay Estimate # (Yes/No)?","Amount Paid this Period ($)","Amount Previously Paid ($)"]
[]
[null,null,null,null,null,{"$f":"0","v":0},{"$f":"0","v":0}]
[null,null,null,null,null,{"$f":"0","v":0},{"$f":"0","v":0}]
[null,null,null,null,null,{"$f":"0","v":0},{"$f":"0","v":0}]
[null,null,null,null,null,{"$f":"0","v":0},{"$f":"0","v":0}]
[null,null,null,null,null,{"$f":"0","v":0},{"$f":"0","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Add rows as needed"]
[]
[]
["Payment Summaries for Completed Contracts (Complete with Final Report)"]
[null,"Date of Final Project Acceptance:"]
[]
["Type of Contract or Agreement","Business/Vendor Name","Total Paid to date (Dollars)","Est. Final Payment (Dollars; if not paid already)","Sum","Est. Total Payment (Dollars)"]
[{"$f":"A15","v":0},{"$f":"B15","v":0},null,{"$f":"0","v":0},"=",{"$f":"SUM(C37:D37)","v":0}]
[{"$f":"A16","v":0},0,null,{"$f":"0","v":0},"=",{"$f":"SUM(C38:D38)","v":0}]
[0,0,null,{"$f":"0","v":0},"=",{"$f":"SUM(C39:D39)","v":0}]
[0,0,null,{"$f":"0","v":0},"=",{"$f":"SUM(C40:D40)","v":0}]
[0,0,null,{"$f":"0","v":0},"=",{"$f":"SUM(C41:D41)","v":0}]
[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,"="]
["Add rows as needed"]
[]
[null,"Name & Title of Individual Completing Report (Type or Print Clearly)"]
[null,"I certify that contracts have been executed with the above firms, amounts listed are accurate and payments were made in accordance with contractual obligations. Cancelled checks and/or supporting information will be on file for inspection or audit."]
[null,"Name:",null,"Phone:"]
[]
[null,"Title:",null,"Date Report Prepared/Revised:"]