{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Contractor Invoice","Details"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Contractor Invoice","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[11,7,11,9],[12,7,12,9],[10,7,10,10],[13,0,13,4],[0,7,0,10],[10,0,10,4],[9,0,9,10],[3,0,3,10],[4,1,4,5],[1,0,1,10],[2,0,2,10],[5,0,6,0],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[13,7,13,10],[33,0,33,10],[36,7,36,10],[35,7,35,10],[24,0,24,10],[26,1,26,2],[35,0,35,4],[31,0,31,10],[34,0,34,10],[32,0,32,10],[30,3,30,4],[30,6,30,9],[29,0,29,4],[25,6,25,10],[26,6,26,9],[28,6,28,10],[29,6,29,10],[5,1,5,5],[6,1,6,5],[25,0,25,4],[28,0,28,4],[22,0,22,10],[23,0,23,10],[19,0,19,4],[21,0,21,4],[7,1,7,5],[8,1,8,5],[17,0,17,10],[20,0,20,10],[12,0,12,4],[11,0,11,4],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[27,0,27,4],[27,6,27,7],[18,0,18,4],[14,0,14,10],[16,7,16,10],[18,7,19,10],[21,7,21,9],[15,7,15,9],[15,0,15,4],[16,0,16,4]]}
["UNIVERSITY OF FLORIDA",null,null,null,null,null,null,"PLANNING DESIGN AND CONSTRUCTION"]
["CERTIFICATE OF PARTIAL OR FINAL PAYMENT"]
["QUICK RESPONSE PROJECTS"]
[]
["Contractor:"," ",null,null,null,null,null,"Date:",null,"2017-06-13"]
["Address:",null,null,null,null,null,null,"Project Number:",null,"MP"]
[null,null,null,null,null,null,null,"Project Name:",null,"Sample Project Name"]
["Contact Person:",null,null,null,null,null,null,"P.O. Number:",null,1800]
["Project Manager:",null,null,null,null,null,null,"Invoice Number:",null,1]
[]
["ORIGINAL CONTRACT SUM",null,null,null,null,0]
["Additions to Date",null,null,null,null,0,null,"CO#: "]
["Deductions to Date",null,null,null,null,0,null,"CO#: "]
["ADJUSTED CONTRACT SUM",null,null,null,null,{"$f":"SUM(F11:F13)","v":0}]
[]
["Work Performed to Date",null,null,null,null,0,null,"Complete to Date %:",null,null,{"$f":"(F16/F14)*100","v":{"$error":"#DIV/0!"}}]
["Balance to Finish",null,null,null,null,{"$f":"F14-F16","v":0}]
[]
["Less Retainage (10%)",null,null,null,null,0]
["Less Previous Payments",null,null,null,null,0]
[]
["DUE THIS PAYMENT",null,null,null,null,{"$f":"F16-F19-F20","v":0},null,"Completion Date (Warranty):"]
[]
["CERTIFICATION BY CONTRACTOR:  According to the best of my knowledge and belief, I certify that all items and amounts shown on the face of this Application are correct, that all Work has been performed and material supplied  in full accordance with the terms and conditions of the Contract, and that all just and lawful bills against me and my Subcontractors for labor and equipment employed in the performance of this Contract have been paid in full in accordance with the terms and conditions.  I further certify that all Subcontractors providing service for the Work are  licensed according to the requirements of the State of Florida."]
[]
["Date:",null,null,null,null,null,"Contractor:"]
["State of:  ",null,null,"County of:"," ",null,"Subscribed and sworn before me this "]
[null,null,null,null,null,null,"day of                                         ",null,null,"  ,20"]
["Notary Public:",null,null,null,null,null," "]
["Commission Number:",null,null,null,null,null,"Commissions Expires:"]
["Personally know   ",null,null,"Produced Identification",null,null,"       Type of Identification Produced"]
["(Check the appropriate block and fill in the type of identification, if identification was required.)"]
[]
[]
["Reviewed and recommended for payment by Owner's representative:"]
[]
["Date:",null,null,null,null,null,null,"PDC Project Manager"]

{"sheet":"Details","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,2,25,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[0,0,0,2],[17,2,17,4],[18,2,18,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[19,2,19,4],[20,2,20,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,0,31,5],[0,4,0,6],[1,0,1,6],[2,0,2,6],[7,2,7,4],[8,2,8,4],[9,2,9,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[21,2,21,4],[26,2,26,4],[27,2,27,4]]}
["UNIVERSITY OF FLORIDA",null,null,null,"PLANNING DESIGN AND CONSTRUCTION"]
["CERTIFICATE OF FINAL OR PARTIAL PAYMENT"]
["QUICK RESPONSE PROJECTS"]
[]
["QUANTITY","UNIT","DESCRIPTION",null,null,"UNIT PRICE","AMOUNT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL",null,null,null,null,null,{"$f":"SUM(G6:G31)","v":0}]