{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["G702","G703"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"G702","index":0,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[28,7,28,9],[29,7,29,11]]}
["APPLICATION AND CERTIFICATE FOR PAYMENT",null,null,null,null,null,null,"AIA DOCUMENT G702",null,null,null,null,"Page ___of ____ pages"]
[]
["TO:",null,null,null,null,null,"Project:  ",null,"APPLICATION NO.:",null,null,null,"Distribution to:"]
[null,null,null,null,null,null,null,null,"PERIOD TO:",null,null,null,null,"OWNER"]
[null,null,null,null,null,null," ",null,"PROJECT NOS.:",null,null,null,null,"ARCHITECT"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"CONTRACTOR"]
["FROM:",null,null,null,null,"VIA ARCHITECT:",null,null,"CONTRACT DATE:",null,null,null,null,"LENDER"]
[]
[null,null,null,null,null,null,null,null,"P.O. NUMBER:"]
["CONTRACT FOR:"]
["CONTRACTOR'S APPLICATION FOR PAYMENT"]
[null,null,null,null,null,null,null,"The undersigned Contractor certifies that to the best of the Contractor's knowledge, "]
[null,null,null,null,null,null,null,"information and belief, the Work covered by this Application for Payment has been"]
["Application is made for payment, as shown below, in connection with the Contract",null,null,null,null,null,null,"completed in accordance with the Contract Documents, that all amounts have been "]
["Continuation Sheet, AIA Document G703, is attached.",null,null,null,null,null,null,"paid by the Contractor for Work for which previous Certificates for Payment were issued"]
[null,null,null,null,null,null,null,"and payments received from the Owner, and that current payment shown herein is now due."]
["1.","ORIGINAL CONTRACT SUM………………………………..",null,null,null,{"$f":"'G703'!C39","v":0}]
[]
["2.","Net Change By Change Orders……………………………",null,null,null,{"$f":"+E50","v":0},null,"CONTRACTOR:"]
[]
["3.","CONTRACT SUM TO DATE…………………………………",null,null,null,{"$f":"+F19+F17","v":0}]
[]
["4.","TOTAL COMPLETED & STORED TO DATE……………..",null,null,null,{"$f":"'G703'!G39","v":0},null,"By:",null,null,null,null,null,"Date:"]
[null,"(Column G on Form G703)"]
[null,null,null,null," "]
["5.","RETAINAGE:"]
[null,"a. ",5,"% of Completed Work",{"$f":"'G703'!J39","v":0}]
[null,null,"(Columns D + E on G703)"]
[null,"b. ",null,"% of Stored Material ",0]
[null,null,"(Column F on G703)"]
[null,"Total Retainage (Line 5a + 5b or"]
[null,null,"Total In Column I of G703)…………………………",null,null,{"$f":"+E29+E27","v":0},null,"CERTIFICATE FOR PAYMENT"]
[null,null,null,null,null,null,null,"In accordance with the Contract Documents, based on on-site observations and the data"]
["6.","TOTAL EARNED LESS RETAINAGE………………………",null,null,null,{"$f":"+F23-F32","v":0},null,"comprising this application, the Architect certifies t the Owner that to the best of the "]
[null,"(Line 4 less Line 5 Total)",null,null,null,null,null,"Architect's knowledge, information, and belief, the Work has progressed as indicated, the"]
[null,null,null,null,null,null,null,"quality of the Work is in accordance with the Contract Documents, and the Contractor"]
["7.","LESS PREVIOUS CERTIFICATES FOR PAYMENT",null,null,null,null,null,"is entitled to payment of the AMOUNT CERTIFIED."]
[null,"(Line 6 from prior Certificate)………………………………………………………………"]
[null,null,null,null,null,"."]
["8.","CURRENT PAYMENT DUE…………………………………",null,null,null,{"$f":"+F34-F38","v":0},null,"AMOUNT CERTIFIED………………………………………………………………",null,null,null,null,null,null,{"$f":"+F40","v":0}]
[null,null,null,null,null,null,null,"(Attach explanation if amount certified differs from the amount applied for.  Initial all "]
["9.","BALANCE TO FINISH, PLUS RETAINAGE",null,null,null,null,null,"figures on the Application and on the Continuation Sheet that changed to conform to"]
[null,"(Line 3 less Line 6) ",null,null,{"$f":"F21-F34","v":0},null,null,"the amount certified.)"]
[null,null,null,null,null,null,null,"ARCHITECT:"]
[null,"CHANGE ORDER SUMMARY",null,null,"ADDITIONS","DEDUCTIONS"]
[null,"Total changes approved in",null,null,0]
[null,"previous months by Owner",null,null,0,0,null,"By:",null,null,null,null,null,"Date:"]
[null,"Total approved this Month",null,null,0,null,null,"This Certificate is not negotiable.  The AMOUNT CERTIFIED is payable only to the "]
[null,null,null,"TOTALS",{"$f":"SUM(E46:E48)","v":0},{"$f":"SUM(F46:F48)","v":0},null,"Contractor named herein.  Issuance, payment and acceptance of payment are without"]
[null,"NET CHANGES by Change Order",null,null,0,null,null,"prejudice to any rights of the Owner or Contractor under the Contract."]

{"sheet":"G703","index":1,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["CONTINUATION SHEET",null,null,null,"AIA DOCUMENT G703",null,null,null,"Page 2 of  ",3]
["AIA Document G702, APPLICATION AND CERTIFICATE FOR PAYMENT,",null,null,null,null,null,null,"                                       APPLICATION NO.:"]
["containing Contractor's signed Certification, is attached.",null,null,null,null,null,null,"                                    APPLICATION DATE:"]
["In tabulations below, amounts are stated to the nearest dollar.",null,null,null,null,null,null,"                                                    PERIOD TO:"]
["Use Column \"I\" on Contracts where variable retainage for line items may apply.",null,null,null,null,null,null,"                      ARCHITECT'S PROJECT NO:"]
[]
["A","B","C","D","E","F","G",null,"H","I"]
[null,null,null,"          WORK COMPLETED",null,"MATERIALS","TOTAL"]
["ITEM",null,"SCHEDULED","ON PREVIOUS","THIS PERIOD","PRESENTLY","COMPLETED","%","BALANCE","RETAINAGE"]
["NO","DESCRIPTION OF WORK","VALUE","APPLICATION",null,"STORED","AND STORED",null,"TO","(may vary)"]
[null,null,null,null,null,"(NOT IN","TO DATE","(G/C)","FINISH"]
[null,null,null,"(D + E)",null,"D or E)","(D+E+F)",null,"(C-G)"]
[1,null,null,null,null,null,{"$f":"SUM(D13:F13)","v":0},0,0,{"$f":"0.05*G13","v":0}]
[{"$f":"A13+1","v":2},null,null,null,null,null,{"$f":"SUM(D14:F14)","v":0},{"$f":"IFERROR(G14/C14,0)","v":0},{"$f":"IF(C14>0,(ROUND(+C14-G14,0)),\" \")","v":" "},0]
[{"$f":"A14+1","v":3},null,null,null,null,null,{"$f":"SUM(D15:F15)","v":0},{"$f":"IFERROR(G15/C15,0)","v":0}," ",0]
[4,null,null,null,null,null,0,0," ",0]
[5,null,null,null,null,null,0,0,{"$f":"IF(C17>0,(ROUND(+C17-G17,0)),\" \")","v":" "},0]
[{"$f":"A17+1","v":6},null,null,null,null,null,0,0," ",0]
[7,null,null,null,null,null,0,0," ",0]
[8,null,null,null,null,null,{"$f":"SUM(D20:F20)","v":0},0,{"$f":"IF(C20>0,(ROUND(+C20-G20,0)),\" \")","v":" "},0]
[9,null,null,null,null,null,{"$f":"SUM(D21:F21)","v":0},0,{"$f":"IF(C21>0,(ROUND(+C21-G21,0)),\" \")","v":" "},0]
[10,null,null,null,null,null,{"$f":"SUM(D22:F22)","v":0},0,{"$f":"IF(C22>0,(ROUND(+C22-G22,0)),\" \")","v":" "},0]
[11,null,null,null,null,null,{"$f":"SUM(D23:F23)","v":0},0,{"$f":"IF(C23>0,(ROUND(+C23-G23,0)),\" \")","v":" "},0]
[{"$f":"A23+1","v":12},null,null,null,null,null,0,0," ",0]
[13,null,null,null,null,null,0,0," ",0]
[14,null,null,null,null,null,0,0," ",{"$f":"0.05*G26","v":0}]
[15,null,null,null,null,null,0,0,{"$f":"IF(C27>0,(ROUND(+C27-G27,0)),\" \")","v":" "},{"$f":"0.05*G27","v":0}]
[16,null,null,null,null,null,0,0," ",0]
[17,null,null,null,null,null,0,0," ",0]
[18,null,null,null,null,null,0,0," ",0]
[{"$f":"A30+1","v":19},null,null,null,null,null,{"$f":"SUM(D31:F31)","v":0},{"$f":"IFERROR(G31/C31,0)","v":0},{"$f":"IF(C31>0,(ROUND(+C31-G31,0)),\" \")","v":" "},{"$f":"0.05*G31","v":0}]
[{"$f":"A31+1","v":20},null,null,null,null,null,{"$f":"SUM(D32:F32)","v":0},{"$f":"IFERROR(G32/C32,0)","v":0},{"$f":"IF(C32>0,(ROUND(+C32-G32,0)),\" \")","v":" "},{"$f":"0.05*G32","v":0}]
[{"$f":"A32+1","v":21},null,null,null,null,null,{"$f":"SUM(D33:F33)","v":0},{"$f":"IFERROR(G33/C33,0)","v":0},{"$f":"IF(C33>0,(ROUND(+C33-G33,0)),\" \")","v":" "},{"$f":"0.05*G33","v":0}]
[{"$f":"A33+1","v":22},null,null,null,null,null,0,0," ",0]
[23,null,null,null,null,null,0,0," ",0]
[24,null,null,null,null,null,0,0," ",0]
[25,null,null,null,null,null,0,0," ",0]
[26,null,null,null,null,null,0,0," ",0]
[null,"TOTAL",{"$f":"SUM(C13:C38)","v":0},{"$f":"SUM(D13:D38)","v":0},{"$f":"SUM(E13:E38)","v":0},{"$f":"SUM(F13:F38)","v":0},{"$f":"SUM(G13:G38)","v":0},{"$f":"IFERROR(G39/C39,0)","v":0},{"$f":"SUM(I13:I38)","v":0},{"$f":"SUM(J13:J38)","v":0}]