{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["GENERAL REQUIREMENTS","REPAIRS OF EXISTING FENCES","NEW INSTALLATIONS OF FENCES & G","SUMMARY SCHEDULE OF QUANTITIES"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"GENERAL REQUIREMENTS","index":0,"n_rows":63,"n_cols":8,"rows_kept":63}
[]
[{"$nulls":7},"Bidders rate"]
["EMPLOYER",null,null,"AIRPORTS COMPANY SOUTH AFRICA"]
[]
["DEPARTMENT",null,null,"CIVIL MAINTENANCE"]
[]
["(RFQ TITLE)",null,null,"Maintenance of fences, gates and associated works"]
[{"$nulls":3},". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["SCHEDULE OF QUANTITIES"]
[]
["NB: ","TENDERERS MUST COMPLETE ALL SCHEDULE OF QUANTITIES AND IN BLACK INK."]
[null,"NOTE THAT THE CONTRACT EXPENDITURE MAY EXCEED THE QUANTITIES IN THE BOQ"]
[]
["SCHEDULE A"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F20=\"Prov\",G20=\"Sum\"),(G20=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F20*G20),\"\",IF(F20*G20=0,\"\",ROUND(F20*G20,2))))","v":""}]
[null,"GENERAL REQUIREMENTS AND PROVISIONS",{"$nulls":5},{"$f":"IF(OR(AND(F21=\"Prov\",G21=\"Sum\"),(G21=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F21*G21),\"\",IF(F21*G21=0,\"\",ROUND(F21*G21,2))))","v":""}]
[{"$nulls":7},{"$f":"IF(OR(AND(F22=\"Prov\",G22=\"Sum\"),(G22=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F22*G22),\"\",IF(F22*G22=0,\"\",ROUND(F22*G22,2))))","v":""}]
[1,"Compliance with OHS Act Regulations",{"$nulls":5},{"$f":"IF(OR(AND(F23=\"Prov\",G23=\"Sum\"),(G23=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F23*G23),\"\",IF(F23*G23=0,\"\",ROUND(F23*G23,2))))","v":""}]
[null,"(including the Construction Regulations 2014):"]
[{"$nulls":7},{"$f":"IF(OR(AND(F25=\"Prov\",G25=\"Sum\"),(G25=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F25*G25),\"\",IF(F25*G25=0,\"\",ROUND(F25*G25,2))))","v":""}]
[null,"(a)"," Submission  of Health ",null,"Lump Sum",1,{"v":50000,"d":"50,000.00"},{"$f":"F26*G26","v":{"v":50000,"d":"50,000.00"}}]
[null,null,"& Safety file & Compliance with",{"$nulls":4},{"$f":"IF(OR(AND(F27=\"Prov\",G27=\"Sum\"),(G27=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F27*G27),\"\",IF(F27*G27=0,\"\",ROUND(F27*G27,2))))","v":""}]
[null,null," Environmental  Management Plan"]
[]
[2,"Compliance with obtaining airside permits"]
[{"$nulls":7},{"$f":"IF(OR(AND(F31=\"Prov\",G31=\"Sum\"),(G31=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F31*G31),\"\",IF(F31*G31=0,\"\",ROUND(F31*G31,2))))","v":""}]
[null,"(a)","Provision for personal, "]
[null,null,"vehicle and hot works permits",null,"Prov-Sum",1,{"v":50000,"d":"50,000.00"},{"$f":"F33*G33","v":{"v":50000,"d":"50,000.00"}}]
[]
[]
[3,"(a)","Site establishment",null,"Lump Sum",1,{"v":20000,"d":"20,000.00"},{"$f":"F36*G36","v":{"v":20000,"d":"20,000.00"}}]
[]
[4,"(a)","Standby, monthly inspection and servicing",null,"Monthly",60,null,{"$f":"F38*G38","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},{"$f":"IF(OR(AND(F39=\"Prov\",G39=\"Sum\"),(G39=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F39*G39),\"\",IF(F39*G39=0,\"\",ROUND(F39*G39,2))))","v":""}]
[5,"(a)","Contingency for work not covered in the BOQ",null,{"v":0.1,"d":"10%"},1,null,{"$f":"F40*G40","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F43=\"Prov\",G43=\"Sum\"),(G43=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F43*G43),\"\",IF(F43*G43=0,\"\",ROUND(F43*G43,2))))","v":""}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H23:H43)","v":{"v":120000,"d":"120,000.00"}}]
[]
[]
["SCHEDULE B"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F54=\"Prov\",G54=\"Sum\"),(G54=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F54*G54),\"\",IF(F54*G54=0,\"\",ROUND(F54*G54,2))))","v":""}]
[1,"Temporary traffic-control facilities:"]
[]
[null,"(a)","Flagmen, signage, cones etc",null,"Prov-Sum",1,{"v":50000,"d":"R50,000.00"},{"$f":"F57*G57","v":{"v":50000,"d":"R50,000.00"}}]
[]
[2,"Corrosion resistant coatings for new installations"]
[]
[null,"(a)","Material and application",null,"m²",250,null,{"$f":"F61*G61","v":{"v":0,"d":"R0.00"}}]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H57:H62)","v":{"v":50000,"d":"R50,000.00"}}]

{"sheet":"REPAIRS OF EXISTING FENCES","index":1,"n_rows":73,"n_cols":8,"rows_kept":73}
["SCHEDULE C"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F7=\"Prov\",G7=\"Sum\"),(G7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F7*G7),\"\",IF(F7*G7=0,\"\",ROUND(F7*G7,2))))","v":""}]
[null,"EXISTING FENCES",{"$nulls":5},{"$f":"IF(OR(AND(F8=\"Prov\",G8=\"Sum\"),(G8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F8*G8),\"\",IF(F8*G8=0,\"\",ROUND(F8*G8,2))))","v":""}]
[]
["C11.5.9","Repairing existing fences"]
[null,"(i)","Concrete palisade ",null,"km",2,null,{"$f":"F11*G11","v":{"v":0,"d":"0.00"}}]
[]
[null,"(ii)","Diamond razor mesh",null,"km",5,null,{"$f":"F13*G13","v":{"v":0,"d":"0.00"}}]
[]
[null,"(iii)","Razor wire flat wrap",null,"m",550,null,{"v":0,"d":"0.00"}]
[{"$nulls":3},""]
[null,"(iv)","3 Coil barbed wire",null,"m",{"v":1200,"d":"1,200"},null,{"v":0,"d":"0.00"}]
[]
[null,"(v)","Diamond mesh",null,"m²",{"v":1000,"d":"1,000"},null,{"v":0,"d":"0.00"}]
[]
[null,"(vi)","Steel palisade",null,"m",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[]
[null,"(vii)","Welded mesh flat panel",null,"m",900,null,{"v":0,"d":"0.00"}]
[]
[null,"(viii)","Brick wall fencing (all types)",null,"m²",200,null,{"v":0,"d":"0.00"}]
[]
[null,"(ix)","Precast concrete wall",null,"m²",900,null,{"v":0,"d":"0.00"}]
[]
[null,"(x)","Precast concrete security wall(perimeter)",null,"m²",900,null,{"v":0,"d":"0.00"}]
[null,null,"Reapairing spalling concrete"]
[]
[null,"(xi)","Teraforce restraining blocks",null,"each",500,null,{"v":0,"d":"0.00"}]
[]
[]
[]
[null,"EXISTING GATES"]
[]
["C11.5.10.6","Repairing of existing gates"]
[]
[null,"(i)","Repairing existing gates (cutting & welding, ",null,"No.",50,null,{"v":0,"d":"0.00"}]
[null,null,"gate structural elements, repairing gate wheels &"]
[null,null,"rails & hinges)"]
[]
[null,"(ii)","Repairing of existing gates by cutting, welding without ",null,"No.",50,null,{"v":0,"d":"0.00"}]
[null,null,"replacements"]
[]
[null,"(iii)","Sandblasting of corroded gates and painting",null,"m²",950,null,{"v":0,"d":"0.00"}]
[]
[]
[null,"Bollards"]
[]
[null,"(i)","Repairing of steel bollards (welding)",null,"No.",50,null,{"v":0,"d":"0.00"}]
[]
[null,"(ii)","Repairing of concrete bollards",null,"No.",50,null,{"v":0,"d":"0.00"}]
[]
[null,"Guardrails"]
[]
[null,"(i)","Repairing of exisiting guardrails including timber ",null,"No.",200,null,{"v":0,"d":"0.00"}]
[null,null,"posts and refelctive plate"]
[]
[null,"(ii)","Repairing of guardrails without replacement of timber",null,"No.",250,null,{"v":0,"d":"0.00"}]
[null,null,"posts and reflective plates"]
[]
[null,"Painting of existing fences, gates & associated works (all types and sizes)"]
[]
[null,"(i)","Gates",null,"m²",{"v":1000,"d":"1,000"},null,{"v":0,"d":"0.00"}]
[]
[null,"(ii)","Fences (steel palisades, etc)",null,"m²",{"v":1000,"d":"1,000"},null,{"v":0,"d":"0.00"}]
[]
[null,"(iii)","Guardrails",null,"m²",{"v":1000,"d":"1,000"},null,{"v":0,"d":"0.00"}]
[]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H11:H71)","v":{"v":0,"d":"0.00"}}]

{"sheet":"NEW INSTALLATIONS OF FENCES & G","index":2,"n_rows":107,"n_cols":8,"rows_kept":107,"merged":[[9,1,11,3],[69,2,70,3]]}
["SCHEDULE D"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F7=\"Prov\",G7=\"Sum\"),(G7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F7*G7),\"\",IF(F7*G7=0,\"\",ROUND(F7*G7,2))))","v":""}]
[null," NEW INSTALLATIONS",{"$nulls":5},{"$f":"IF(OR(AND(F8=\"Prov\",G8=\"Sum\"),(G8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F8*G8),\"\",IF(F8*G8=0,\"\",ROUND(F8*G8,2))))","v":""}]
[]
["C11.5.1","Supply and erect new fencing material for new fences and for supplementing material in existing fences which are being repaired or removed:"]
[]
[]
[]
["C11.5.1","(a)","Steel palisade",null,"m",{"v":2000,"d":"2,000"},null,{"$f":"F14*G14","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1","(b)","Welded mesh flat panel",null,"m",250,null,{"$f":"F16*G16","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1","(c)","Brick wall fencing (all types)",null,"m²",200,null,{"$f":"F18*G18","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1","(d)","Precast concrete fence",null,"m²",250,null,{"$f":"F20*G20","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1","(e)","Precast concrete security wall (perimeter)",null,"each",30,null,{"$f":"F22*G22","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1","(f)","Teraforce restraining blocks (all types)",null,"each",50,null,{"$f":"F24*G24","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1.1",null,"Zinc-coated barbed wire",null,"km",15,null,{"$f":"F26*G26","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1.2",null,"Zinc-coated smooth wire",null,"km",5,null,{"$f":"F28*G28","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1.3",null,"Diamond mesh"]
[null,"(a)","Diamond Razor Mesh",null,"m²",475,null,{"$f":"F31*G31","v":{"v":0,"d":"0.00"}}]
[null,"(b)","Razor Wire Flat Wrap",null,"m²",500,null,{"$f":"F32*G32","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["C11.5.1.4",null,"Wire netting (all types)",null,"m²",450,null,{"$f":"F36*G36","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["C11.5.1.7",null,"Standards"]
[null,"(i)","Timber (all types)",null,"No.",100,null,{"$f":"F41*G41","v":{"v":0,"d":"0.00"}}]
[null,"(ii)","Steel (all types)",null,"No.",100,null,{"$f":"IF(OR(AND(F42=\"Prov\",G42=\"Sum\"),(G42=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F42*G42),\"\",IF(F42*G42=0,\"\",ROUND(F42*G42,2))))","v":""}]
[]
["C11.5.1.8",null,"Droppers"]
[null,"(i)","Timber",null,"No.",100,null,{"$f":"F45*G45","v":{"v":0,"d":"0.00"}}]
[null,"(ii)","Steel",null,"No.",100,null,{"$f":"F46*G46","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.1.9",null,"Straining posts, stays and anchors"]
[null,"(a)","Vertical"]
[null,"(i)","Steel straining posts",null,"No.",120,null,{"$f":"F50*G50","v":{"v":0,"d":"0.00"}}]
[null,"(ii)","Timber straining posts",null,"No.",120,null,{"$f":"F51*G51","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Inclined"]
[null,"(i)","Steel stays and anchors",null,"No.",100,null,{"$f":"F54*G54","v":{"v":0,"d":"0.00"}}]
[null,"(ii)","Timber stays and anchors",null,"No.",140,null,{"$f":"F55*G55","v":{"v":0,"d":"0.00"}}]
[null,"(iii)","Wire stays and anchors",null,"No.",120,null,{"$f":"F56*G56","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Horizontal"]
[null,"(i)","Steel stays and anchors",null,"No.",150,null,{"$f":"F59*G59","v":{"v":0,"d":"0.00"}}]
[null,"(ii)","Timber stays and anchors",null,"No.",130,null,{"$f":"F60*G60","v":{"v":0,"d":"0.00"}}]
[null,"(iii)","Wire stays and anchors",null,"No.",110,null,{"$f":"F61*G61","v":{"v":0,"d":"0.00"}}]
[]
[]
["C11.5.2",null,"Supply and installation of new gates",null,"No.",50,null,{"$f":"F64*G64","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.3",null,"Moving existing fences and gates (All types and sizes)",null,"km"]
["C11.5.3.1",null,"Fences",null,null,50,null,{"$f":"F67*G67","v":{"v":0,"d":"0.00"}}]
["C11.5.3.2",null,"Gates",null,null,50,null,{"$f":"F68*G68","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.4",null,"Dismantling existing fences and gates (All types and sizes)"]
[]
["C11.5.4.1",null,"Fences",null,"km",50,null,{"$f":"F72*G72","v":{"v":0,"d":"0.00"}}]
["C11.5.4.2",null,"Gates",null,"km",50,null,{"$f":"F73*G73","v":{"v":0,"d":"0.00"}}]
[]
["C11.5.5",null,"Providing temporary fences and gates (All types and sizes)"]
["C11.5.5.1",null,"Fences",null,"km",20,null,{"$f":"F76*G76","v":{"v":0,"d":"0.00"}}]
["C11.5.5.2",null,"Gates",null,"km",20,null,{"$f":"F77*G77","v":{"v":0,"d":"0.00"}}]
[]
[1,null,"Supply and erection of new bollards"]
[]
[null,"(i)","Replace of steel bollards (all types)",null,"No.",50,null,{"$f":"F81*G81","v":{"v":0,"d":"0.00"}}]
[null,"(ii)","Replace of concrete bollards (all types)",null,"No.",50,null,{"$f":"F82*G82","v":{"v":0,"d":"0.00"}}]
[]
[null,null,"Supply and erection of guardrails (all types)"]
[]
[null,"(i)","Replacement of exisiting guardrails including timber ",null,"No.",150,null,{"$f":"IF(OR(AND(F86=\"Prov\",G86=\"Sum\"),(G86=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F86*G86),\"\",IF(F86*G86=0,\"\",ROUND(F86*G86,2))))","v":""}]
[null,null,"posts and refelctive plate"]
[]
[null,"(ii)","Replacement of guardrails without replacement of timber",null,"No.",150,null,{"$f":"F89*G89","v":{"v":0,"d":"0.00"}}]
[null,null,"posts and reflective plates"]
[]
[null,"(iii)","New installation of exisiting guardrails including timber ",null,"No.",150,null,{"$f":"F92*G92","v":{"v":0,"d":"0.00"}}]
[null,null,"posts and refelctive plate"]
[]
[null,null,"Supply and erection of galvanised steel barriers"]
[null,null,"Replacement of existing or new installations of galvanised",null,"No.",150,null,{"$f":"F96*G96","v":{"v":0,"d":"0.00"}}]
[null,null,"steel protection barriers(all types)"]
[]
[null,"(iv)","Earthworks and excavations for new installations",null,"m3"]
[null,null,"Soft soil(manual excavations)",null,null,300,null,{"$f":"F100*G100","v":{"v":0,"d":"0.00"}}]
[null,null,"Soft/Medium soil(TLB excavations)",null,null,400,null,{"$f":"F101*G101","v":{"v":0,"d":"0.00"}}]
[null,null,"Hard ground/restricted access",null,null,750,null,{"$f":"F102*G102","v":{"v":0,"d":"0.00"}}]
[null,null,"Removal/disposal of excavated material",null,null,150,null,{"$f":"F103*G103","v":{"v":0,"d":"0.00"}}]
[]
[null,"(v)","Concrete plinth/foundations",null,"m3",10,null,{"$f":"F105*G105","v":{"v":0,"d":"0.00"}}]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H14:H96)","v":{"v":0,"d":"0.00"}}]

{"sheet":"SUMMARY SCHEDULE OF QUANTITIES","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[13,0,13,3],[14,0,14,3],[15,0,17,3]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[]
["SECTION","DESCRIPTION",null,null,"TOTAL"]
[]
["Schedule A","GENERAL REQUIREMENTS AND PROVISIONS"]
[]
["Schedule B","TEMPORARY TRAFFIC-CONTROL FACILITIES"]
[]
["Schedule C","REPAIRING FENCING"]
[]
["Schedule D","REPLACING FENCING"]
[]
["TOTAL EXCL VAT"]
["VAT@15%"]
["TOTAL"]