{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Page1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Page1","index":0,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":false,"merged":[[81,12,81,13],[13,12,13,13],[0,3,1,6],[13,8,13,9],[5,3,5,12],[7,3,7,12],[9,3,9,12],[11,3,11,12],[13,3,13,4]]}
[null,null,null,"Payment Certificate"]
[{"$nulls":10},"Certificate No:"]
[null,null,null,"Issued in terms of Clause 25 of the"]
[null,null,null,"Principal Building Agreement Edition 6.2 - May 2018",{"$nulls":6},"Interim or Final"]
[]
[null,null,"Employer "]
[]
[null,null," Contractor "]
[]
[null,null,"Works "]
[]
[null,null,"Site "]
[]
[null,null,"Valuation Date   ",null,null,null,"Issue Date",null,{"$f":"NOW()","v":"2019-03-29T15:40:53.230"},null,"Payment due date",null,{"$f":"I14+14","v":"2019-04-12T15:40:53.230"}]
[{"$nulls":6},"A",null,"B",null,"C",null,"D"]
[{"$nulls":6},"CONTRACT SUM",null,"CURRENT",null,"CURRENT",null,"CURRENT"]
[{"$nulls":8},"CONTRACT VALUE",null,"VALUATION",null,"CERTIFICATION"]
[]
[null,"1.0   Value of the work executed [25.3.1]"]
[]
[null,"2.1   Materials and goods on site [25.3.2]"]
[]
[null,"2.2   Materials and goods off site [25.3.2]"]
[]
[null,"3.0",null," Subtotal ",{"$nulls":6},{"$f":"IF(K19=\"\",\"\",SUM(K19:K23))","v":""}]
[]
[null,"4.0   Security adjustments applicable [25.3.3]",{"$nulls":4},"If applicable, state %",null,10,"%",{"$f":"IF(K19=\"\",\"\",K25*I27/100)","v":""},null,{"$f":"IF(K25=\"\",\"\",K25-K27)","v":""}]
[]
[null,"5.0   Net contract sum",{"$nulls":6},{"$f":"IF(G29=\"\",\"\",G29+I31)","v":""}]
[]
[null,"6.0   Authorised adjustments to contract value [26.0]"]
[]
[null,"7.0   Cost fluctuations [25.3.4]",{"$nulls":10},{"$f":"IF(I33=\"\",\"\",IF(K33=\"\",\"\",K33))","v":""}]
[]
[null,"8.0",null,"TOTAL AMOUNT CERTIFIED",{"$nulls":8},{"$f":"IF(M33=\"\",M27,M27+M33)","v":""}]
[]
[null,"9.0     Less           ","Previous amount certified [25.3.6]"]
[]
[null,"10.0",null,"NET AMOUNT CERTIFIED",{"$nulls":8},{"$f":"IF(M35=\"\",\"\",M35-M37)","v":""}]
[]
[null,"11.1  Less   ","Expense and loss payable to the employer [Recovery Statement subtotal 1.0]"]
[]
[null,"11.2  Less   ","Penalty levied and payable to the employer [Recovery Statement 1.11]"]
[]
[null,"11.3  Add    ","Damages payable to the contractor [Recovery Statement 2.3]"]
[]
[null,"12.0",null," Subtotal ",null,null,{"$f":"IF(G29=\"\",\"\",G29+G33)","v":""},null,{"$f":"IF(I29=\"\",\"\",SUM(I29)+I33)","v":""},null,"(excluding tax)",null,{"$f":"IF(M39=\"\",\"\",M39-M41-M43+M45)","v":""}]
[]
[null,"13.0  Add","Tax on 12.0 [25.3.8]",null,15,"%",{"$f":"IF(G47=\"\",\"\",G47*(E49/100))","v":""},null,{"$f":"IF(I47=\"\",\"\",I47*E49/100)","v":""},null,null,null,{"$f":"IF(M47=\"\",\"\",M47*E49/100)","v":""}]
[]
[null,"14.1  Less   ","Default interest payable to the employer [Recovery Statement 1.12]"]
[]
[null,"14.2  Less   ","Recoupment from contractor of an advance payment [Recovery Statement 1.10]"]
[]
[null,"14.3  Add    ","Default interest payable to the contractor [Recovery Statement 2.1]"]
[]
[null,"14.4  Add    ","Compensatory interest payable to the contractor [Recovery Statement 2.2]"]
[]
[null,"14.5  Add","Expense and loss caused by a direct contractor [Recovery statement 2.4]"]
[]
[null,"14.6  Add","Damages [Recovery Statement 2.3]"]
[]
[null,"14.7  Add","Advance payment made to the contractor [Recovery Statement 2.5]"]
[]
[null,"14.8   Add","Termination of a subcontract agreement, employer's default [Recovery Statement 2.6]"]
[]
[null,"14.9   Add","Other non-taxable amounts [25.3.10]"]
[]
[null,"15.0",null,"TOTAL",null,null,{"$f":"IF(G47=\"\",\"\",SUM(G47:G49))","v":""},null,{"$f":"IF(I49=\"\",\"\",SUM(I47:I49))","v":""}]
[]
[null,"16.0    Currency","ZAR","CERTIFIED AMOUNT DUE FOR PAYMENT to the:",{"$nulls":6},"CONTRACTOR",null,{"$f":"IF(M47=\"\",\"\",SUM(M47:M49)-M51-M53+M55+M57+M59+M61+M63+M65+M67)","v":""}]
[]
[null,"17.0    Contract sum execution (Security for construction - variable - only)",{"$nulls":8},"(D8.0/A12.0x100)",null,{"$f":"IF(M71=\"\",\"\",M35/G47*100)","v":""},"%"]
[]
[null,"         Security status"]
[null,"         Mark each box as appropriate: ✓or ✕",{"$nulls":4},"D17.0 < 50%",null,"D17.0 > 50%≥       ",null,"Practical Completion",null,"Final Completion"]
[]
[]
[]
[]
[]
[{"$nulls":8},"Signature",null,"Date:",null,{"$f":"NOW()","v":"2019-03-29T15:40:53.230"}]
[{"$nulls":8},"Signed by the principal agent who, as agent for the employer, certifies"]
[{"$nulls":8},"that the positive or negative amount stated in D16.0 is due and payable by"]
[null,"        Name and address of the principal agent's practice ",{"$nulls":6},"the date stated, irrespective of the date of signature of this certificate"]
[{"$nulls":12},"© Copyright reserved: JBCC® PBA Edition 6.2 PAYMENT CERTIFICATE - May 2018"]