{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Application Page","G703_Master"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":12,"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":"Application Page","index":0,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[51,3,52,4],[28,7,28,9],[45,3,46,3],[45,4,46,4],[47,3,48,3],[49,3,50,3],[49,4,50,4],[47,4,48,4],[16,1,16,2],[2,4,2,5],[12,4,12,6],[15,4,15,5],[4,1,4,2],[6,1,6,2],[8,1,8,2],[12,1,12,2],[14,1,14,2],[15,1,15,2]]}
["APPLICATION FOR PAYMENT",null,null,null,null,null,null,null,null,"PAGE     1     OF",2,null,"PAGES"]
[]
["TO:",null,null,"PROJECT",null,null,null,"APPLICATION NO: ",null,null,"Distribution to:"]
[]
[null,"COHN CONSTRUCTION SERVICES, LLC",null,"NAME AND",null,null,null,null,null,null,null,"OWNER"]
[]
[null,"P.O. BOX 2005",null,"LOCATION:",null,null,null,null,null,null,null,"ARCHITECT"]
[]
[null,"COLUMBIA, SC 29202",null,null,null,null,null,"PERIOD TO: ",null,null,"X","CONTRACTOR"]
[]
["FROM:",null,null,null,null,null,null,null,null,null,null,"BANK"]
[]
[null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,"PROJECT NOS: "]
[]
["FOR: ",null,null,null,null,null,null,"DATE:"]
[]
["OWNER/DEVELOPER'S APPLICATION FOR PAYMENT",null,null,null,null,null,"Contractor's signature below is his assurance to Owner, concerning the payment herein applied for, ",null,null,null,null,null,null,null,null,null,"DID YOU CHECK YOUR WORK???"]
["Application is made for payment, as shown below, in connection with the Project.",null,null,null,null,null,"that: (1) the Work has been performed as required in the Contract Docuyemnts, (2) all sums paid to "]
["Continuation Sheet, is attached.",null,null,null,null,null,"Contractor under the Contract have been used to pay Contractor's costs for labor, materials and other",null,null,null,null,null,null,null,null,null,"The value on the G702 Lines should equal the total of the G703 columns as follows:"]
[" ",null,null,null,null,null,"obligations under the Contract for Work previously paid for, and (3) Contractor is legally entitled to"]
[" ",null,null,null,null,null,"this payment.",null,null,null,null,null,null,null,null,null,"G702",null,"Line 3 = G703 (column \"C\")"]
[]
["1.  ORIGINAL PROJECT SUM ",null,null," $",{"$f":"G703_Master!E47","v":0},null,null,null,null,null,null,null,null,null,null,null,"G702",null,"Line 4 = G703 (column \"G\")"]
["2.  Net change by Change Orders ",null,null," $",{"$f":"G703_Master!E48","v":0},null,"CONTRACTOR:",null,{"$f":"+IF(B13=\"\",\"\",B13)","v":""}]
["3.  PROJECT SUM TO DATE (Line 1 ± 2)                                        $",null,null,"$",{"$f":"IF(SUM(E25,E26)=0,\"\",SUM(E25,E26))","v":""},null,null,null,null,null,null,null,null,null,null,null,"G702",null,"Line 5 = G703 (column \"I\")"]
["4.  TOTAL COMPLETED & STORED TO",null,null,"$",{"$f":"G703_Master!J41","v":0}]
["         DATE       (Column G on G703)",null,null,null,null,null,"By:",null,null,null," Date:",null,{"$f":"+I17","v":"00:00:00"},null,null,null,"G702",null,"Line 6 = G703 (column \"G\" minus “column \"I\")"]
["5.  RETAINAGE:"]
["a.",0,"% of Completed Work                 $",{"$f":"SUM((G703_Master!F41+G703_Master!G41)*('Application Page'!B31/100))","v":0},null,null,"State of:",null,"South Carolina","County of:",null,null,null,null,null,null,"G702",null,"Line 7 = Previous Pay Requests"]
[null,"(Column D + E on G703)",null,null,null,null,"Subscribed and sworn to before me this",null,null,{"$f":"DAY(M29)","v":0}," day of",null,{"$f":"TEXT(M29,\"mmmm\")","v":"January"},{"$f":"YEAR(M29)","v":1900}]
["b.",0,"% of Stored Material                   $",{"$f":"(G703_Master!I41)*('Application Page'!B33/100)","v":0},null,null,"Notary Public:  ",null,null,null,null,null,null,null,null,null,"G702",null,"Line 8 = Line 6 minus Line 7"]
[null,"(Column F on G703)",null,null,null,null,"My Commission expires:"]
["           Total Retainage (Lines 5a + 5b or",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G702",null,"Line 9 = G703 (column \"H\" + column \"I\")"]
[null,"Total in Column I of G703) ",null,"$",{"$f":"D31+D33","v":0},null,null,null,null,null,null,null,null,null,null,null,"G702",null,"\"Change Order Summary\""]
["6.  TOTAL EARNED LESS RETAINAGE ",null,null,"$",{"$f":"G703_Master!J41-G703_Master!M41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Any entries should also be added to the Line item list on the G703."]
[null,"(Line 4 Less Line 5 Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(standard description: \"Net of Change Order #1\" etc)."]
["7.  LESS PREVIOUS CERTIFICATES FOR"]
["     PAYMENT (Line 6 from prior Certificate) ",null,null,"$",{"$f":"G703_Master!F41*(1-('Application Page'!B31/100))","v":0}]
["8.  CURRENT PAYMENT DUE ",null,null,"$",{"$f":"E37-E40","v":0}]
["9.  BALANCE TO FINISH, INCLUDING RETAINAGE",null,null,"$",{"$f":"E27-E37","v":0}]
[null,"(Line 3 less Line 6)",null,{"$f":"+IF(E43=\"\",\"\",\"ERROR\")","v":""},{"$f":"+IF(ROUND(E42-D31-BaltoFin,2)<>0,ROUND(E42-D31-BaltoFin,2),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"ENTERING COs"]
[]
["CHANGE ORDER SUMMARY",null,null,"ADDITIONS","DEDUCTIONS",null,null,null,null,null,null,null,null,null,null,null,"G703",null,"Enter the CO Desciption as \"Net of Change Order # 1\""]
["     Total changes approved",null,null,{"$f":"G703_Master!E55","v":0},{"$f":"G703_Master!E56","v":0}]
["     in previous months by Owner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Line 2",null,"Confirm Net Change by Change Orders to reflect the correct total of COs"]
[null,null,null,{"$f":"G703_Master!E51","v":0},{"$f":"G703_Master!E52","v":0}]
["     Total approved this Month",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lines 3 and 4",null,"Confirm Amounts are correct from G703"]
[null,null,null,{"$f":"+G703_Master!E51+G703_Master!E55","v":0},{"$f":"+G703_Master!E52+G703_Master!E56","v":0}]
["     TOTALS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO Summary",null,"Update Total Changes in Previous Month"]
[null,null,null,{"$f":"D50+E50","v":0}]
["     NET CHANGES by Change Order",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO Summary",null,"Update Changes in This Month"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO Summary",null,"Confirm Totals and Net Changes"]

{"sheet":"G703_Master","index":1,"n_rows":59,"n_cols":241,"rows_kept":59,"cut":false,"hidden":false,"merged":[[7,5,7,7]]}
[null,null,"CONTINUATION SHEET",null,null,null,null,null,null,null,null,"  PAGE  2 OF 2  PAGES",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,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,"/WGPD"]
[null,null,"APPLICATION AND CERTIFICATION FOR PAYMENT, containing",null,null,null,null,null,null,null,"APPLICATION NO:","1",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,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,"/wir.{d 25}~{r 6}/cf~~{L 6}~"]
[null,null,"Signed certification is attached.",null,null,null,null,null,null,null,"APPLICATION DATE:",{"$f":"'Application Page'!M29","v":"00:00:00"},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,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,"/wgpe"]
[null,null,"In tabulations below, amounts are stated to the nearest dollar.",null,null,null,null,null,null,null,"PERIOD TO:",{"$f":"'Application Page'!I9","v":"00:00:00"},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,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,"/ru.{d 26}"]
[null,null,null,null,null,null,null,null,null,null,"ARCHITECT'S PROJECT NO:",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,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,"{L 5}"]
[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,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,"{L 9}"]
[null,null,"A","B","C","D","E",null,"F","G",null,"H","I",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,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,"/ru.{d 26}~"]
[null,null,"ITEM","DESCRIPTION OF WORK","SCHEDULED","WORK COMPLETED",null,null,"MATERIALS","TOTAL","%","BALANCE","RETAINAGE"]
[null,null,"NO.",null,"VALUE","FROM PREVIOUS","THIS PERIOD","%","PRESENTLY","COMPLETED","(G ÷ C)","TO FINISH","(IF VARIABLE"]
[null,"CO",null,null,null,"APPLICATION",null,"Complete","STORED","AND STORED",null,"(C - G)","RATE)"]
[null,"Date ",null,null,null,"(D + E)",null,null,"(NOT IN","TO DATE"]
[null,"Approved",null,null,null,null,null,null,"D OR E)","(D+E+F)"]
[null,null,null,"Original Scope:"]
["OC","Original Cont SOV",{"$f":"+IF(OFFSET(C14,-1,0)=\"\",1,OFFSET(C14,-1,0)+1)","v":1},null,null,null,{"$f":"+IF($E14=\"\",\"\",ROUND($E14*$H14-F14,2))","v":""},null,null,{"$f":"IF(ISBLANK(E14),\"\",F14+G14+I14)","v":""},{"$f":"IF(ISBLANK(J14),\"\",IF(ISERR(J14/E14),\"\",J14/E14))","v":""},{"$f":"IF(ISBLANK(E14),\"\",E14-J14)","v":""},{"$f":"IF(ISBLANK(E14),\"\",((F14+G14)*('Application Page'!$B$31/100))+((G703_Master!I14)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",{"$f":"+IF(OFFSET(C15,-1,0)=\"\",1,OFFSET(C15,-1,0)+1)","v":2},null,null,null,{"$f":"+IF($E15=\"\",\"\",ROUND($E15*$H15-F15,2))","v":""},null,null,{"$f":"IF(ISBLANK(E15),\"\",F15+G15+I15)","v":""},{"$f":"IF(ISBLANK(J15),\"\",IF(ISERR(J15/E15),\"\",J15/E15))","v":""},{"$f":"IF(ISBLANK(E15),\"\",E15-J15)","v":""},{"$f":"IF(ISBLANK(E15),\"\",((F15+G15)*('Application Page'!$B$31/100))+((G703_Master!I15)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",3,null,null,null,"",null,null,{"$f":"IF(ISBLANK(E16),\"\",F16+G16+I16)","v":""},{"$f":"IF(ISBLANK(J16),\"\",IF(ISERR(J16/E16),\"\",J16/E16))","v":""},{"$f":"IF(ISBLANK(E16),\"\",E16-J16)","v":""},{"$f":"IF(ISBLANK(E16),\"\",((F16+G16)*('Application Page'!$B$31/100))+((G703_Master!I16)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",4,null,null,null,"",null,null,{"$f":"IF(ISBLANK(E17),\"\",F17+G17+I17)","v":""},{"$f":"IF(ISBLANK(J17),\"\",IF(ISERR(J17/E17),\"\",J17/E17))","v":""},{"$f":"IF(ISBLANK(E17),\"\",E17-J17)","v":""},{"$f":"IF(ISBLANK(E17),\"\",((F17+G17)*('Application Page'!$B$31/100))+((G703_Master!I17)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",5,null,null,null,"",null,null,{"$f":"IF(ISBLANK(E18),\"\",F18+G18+I18)","v":""},{"$f":"IF(ISBLANK(J18),\"\",IF(ISERR(J18/E18),\"\",J18/E18))","v":""},{"$f":"IF(ISBLANK(E18),\"\",E18-J18)","v":""},{"$f":"IF(ISBLANK(E18),\"\",((F18+G18)*('Application Page'!$B$31/100))+((G703_Master!I18)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",6,null,null,null,"",null,null,{"$f":"IF(ISBLANK(E19),\"\",F19+G19+I19)","v":""},{"$f":"IF(ISBLANK(J19),\"\",IF(ISERR(J19/E19),\"\",J19/E19))","v":""},{"$f":"IF(ISBLANK(E19),\"\",E19-J19)","v":""},{"$f":"IF(ISBLANK(E19),\"\",((F19+G19)*('Application Page'!$B$31/100))+((G703_Master!I19)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",7,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E20),\"\",((F20+G20)*('Application Page'!$B$31/100))+((G703_Master!I20)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",8,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E21),\"\",((F21+G21)*('Application Page'!$B$31/100))+((G703_Master!I21)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",9,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E22),\"\",((F22+G22)*('Application Page'!$B$31/100))+((G703_Master!I22)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",10,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E23),\"\",((F23+G23)*('Application Page'!$B$31/100))+((G703_Master!I23)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",11,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E24),\"\",((F24+G24)*('Application Page'!$B$31/100))+((G703_Master!I24)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",12,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E25),\"\",((F25+G25)*('Application Page'!$B$31/100))+((G703_Master!I25)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",13,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E26),\"\",((F26+G26)*('Application Page'!$B$31/100))+((G703_Master!I26)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",14,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E27),\"\",((F27+G27)*('Application Page'!$B$31/100))+((G703_Master!I27)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",15,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E28),\"\",((F28+G28)*('Application Page'!$B$31/100))+((G703_Master!I28)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",16,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E29),\"\",((F29+G29)*('Application Page'!$B$31/100))+((G703_Master!I29)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",17,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E30),\"\",((F30+G30)*('Application Page'!$B$31/100))+((G703_Master!I30)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",18,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E31),\"\",((F31+G31)*('Application Page'!$B$31/100))+((G703_Master!I31)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",19,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E32),\"\",((F32+G32)*('Application Page'!$B$31/100))+((G703_Master!I32)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",20,null,null,null,"",null,null,{"$f":"IF(ISBLANK(E33),\"\",F33+G33+I33)","v":""},{"$f":"IF(ISBLANK(J33),\"\",IF(ISERR(J33/E33),\"\",J33/E33))","v":""},{"$f":"IF(ISBLANK(E33),\"\",E33-J33)","v":""},{"$f":"IF(ISBLANK(E33),\"\",((F33+G33)*('Application Page'!$B$31/100))+((G703_Master!I33)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",21,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E34),\"\",((F34+G34)*('Application Page'!$B$31/100))+((G703_Master!I34)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",22,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E35),\"\",((F35+G35)*('Application Page'!$B$31/100))+((G703_Master!I35)*('Application Page'!$B$33/100)))","v":""}]
["OC","Original Cont SOV",23,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E36),\"\",((F36+G36)*('Application Page'!$B$31/100))+((G703_Master!I36)*('Application Page'!$B$33/100)))","v":""}]
[]
[null,null,null,"Change Orders:"]
["CO",null,1,null,null,null,"",null,null,{"$f":"IF(ISBLANK(E39),\"\",F39+G39+I39)","v":""},{"$f":"IF(ISBLANK(J39),\"\",IF(ISERR(J39/E39),\"\",J39/E39))","v":""},{"$f":"IF(ISBLANK(E39),\"\",E39-J39)","v":""},{"$f":"IF(ISBLANK(E39),\"\",((F39+G39)*('Application Page'!$B$31/100))+((G703_Master!I39)*('Application Page'!$B$33/100)))","v":""}]
["CO",null,2,null,null,null,"",null,null,"","","",{"$f":"IF(ISBLANK(E40),\"\",((F40+G40)*('Application Page'!$B$31/100))+((G703_Master!I40)*('Application Page'!$B$33/100)))","v":""}]
[null,null,null,"GRAND TOTALS",{"$f":"SUM(E14:E40)","v":0},{"$f":"SUM(F14:F40)","v":0},{"$f":"SUM(G14:G40)","v":0},null,{"$f":"SUM(I14:I40)","v":0},{"$f":"SUM(J14:J40)","v":0},{"$f":"IF(J41=0,\"\",IF(ISERR(J41/E41),\"\",J41/E41))","v":""},{"$f":"SUM(L14:L40)","v":0},{"$f":"SUM(M14:M40)","v":0}]
[]
[]
[]
[]
[]
[null,null,"OC","Original Contract Total:",{"$f":"SUMIF(A14:A40,C47,E14:E40)","v":0}]
[null,null,"CO","Net Change by COs:",{"$f":"SUMIF(A14:A40,C48,E14:E40)","v":0}]
[null,null,null,"Contract Sum to Date:",{"$f":"SUM(E47:E48)","v":0}]
[]
[null,null,null,"CO Additions - Approved This Month:",{"$f":"+SUMIFS($E$39:$E$40,$B$39:$B$40,\">=\"&TEXT(CurrentDate,\"mm/dd/yyyy\"),$E$39:$E$40,\">0.0001\")","v":0},">=",{"$f":"'Application Page'!I9-DAY('Application Page'!I9)+1","v":"1900-01-01"}]
[null,null,null,"CO Deductions - Approved This Month:",{"$f":"+SUMIFS($E$39:$E$40,$B$39:$B$40,\">=\"&TEXT(CurrentDate,\"mm/dd/yyyy\"),$E$39:$E$40,\"<0.0001\")","v":0}]
[null,null,null,"Total CO Approved This Month",{"$f":"SUM(E51:E52)","v":0}]
[]
[null,null,null,"CO Additions - Approved Prior Month:",{"$f":"+SUMIFS($E$39:$E$40,$B$39:$B$40,\"<=\"&TEXT(PriorDate,\"mm/dd/yyyy\"),$E$39:$E$40,\">0.0001\")","v":0},"<=",{"$f":"'Application Page'!I9-DAY('Application Page'!I9)","v":"00:00:00"}]
[null,null,null,"CO Deductions - Approved Prior Month:",{"$f":"+SUMIFS($E$39:$E$40,$B$39:$B$40,\"<=\"&TEXT(PriorDate,\"mm/dd/yyyy\"),$E$39:$E$40,\"<0.0001\")","v":0}]
[null,null,null,"Total CO Approved Prior Month",{"$f":"SUM(E55:E56)","v":0}]
[]
[null,null,null,null,{"$f":"E53+E57","v":0}]