{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["General Requirements","4940","Summary"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"General Requirements","index":0,"n_rows":41,"n_cols":8,"rows_kept":41}
[]
[]
["EMPLOYER",null,null,"AIRPORTS COMPANY SOUTH AFRICA"]
[]
["DEPARTMENT",null,null,"CIVIL MAINTENANCE"]
[]
["(RFQ TITLE)",null,null,"Replacement of perimeter fence"]
[{"$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"]
[]
[{"$nulls":3},"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":30000,"d":"30,000.00"},{"$f":"F26*G26","v":{"v":30000,"d":"30,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,"Prov-Sum",1,{"v":50000,"d":"50,000.00"},{"$f":"F32*G32","v":{"v":50000,"d":"50,000.00"}}]
[null,null,"vehicle and hot works permits"]
[]
[3,"(a)","Site establishment",null,"Lump Sum",1,{"v":30000,"d":"30,000.00"},{"$f":"F35*G35","v":{"v":30000,"d":"30,000.00"}}]
[]
[5,"(a)","Contingency for work not covered in the BOQ",null,"%",5]
[]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F40=\"Prov\",G40=\"Sum\"),(G40=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F40*G40),\"\",IF(F40*G40=0,\"\",ROUND(F40*G40,2))))","v":""}]
[null,"TOTAL"]

{"sheet":"4940","index":1,"n_rows":26,"n_cols":8,"rows_kept":26,"merged":[[9,2,9,3],[15,2,15,3],[19,2,19,3],[20,2,20,3],[65,2,66,3]]}
["SCHEDULE B"]
[]
[]
["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":""}]
[1,"Concertina Razor Coil",{"$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":""}]
[]
[null,"(a)","Supply and installation of Razor concertina coil",null,"m",{"v":44000,"d":"44,000"},null,{"$f":"F10*G10","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Coil diameter Ø450mm"]
[{"$nulls":3},"Blade type – Super Blade"]
[]
[2,"Razor mesh"]
[]
[null,"(a)","Supply and installation of Razor Mesh",null,"m2",{"v":52800,"d":"52,800"},null,{"$f":"F16*G16","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Aperture Size: Standard density 300mm x 150mm"]
[{"$nulls":3},"Sheet Height: Height 1.2m Length 6.0m"]
[]
[3,"T Brackets"]
[null,"(a)","Supply and installation of T brackets",null,"No.",{"v":22000,"d":"22,000"},null,{"$f":"F21*G21","v":{"v":0,"d":"0.00"}}]
[]
[4,"Disposal of old fence material at accredited facility",null,null,"Lump Sum",1,null,{"$f":"F23*G23","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":7},{"$f":"SUM(H7:H25)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Summary","index":2,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[0,0,0,3],[1,1,1,3],[2,1,2,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,0,9,3],[10,0,10,3],[11,0,13,3]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[]
["SECTION","DESCRIPTION",null,null,"TOTAL"]
[]
["Schedule A","General requirements and provisisons",null,null,{"$f":"'General Requirements'!H41","v":{"v":0,"d":"R0.00"}}]
[]
["Schedule B","4940: Replacement of perimeter fence components",null,null,{"$f":"'4940'!$H$26","v":{"v":0,"d":"R0.00"}}]
[]
["TOTAL EXCL VAT",{"$nulls":3},{"$f":"SUM(E6:E9)","v":{"v":0,"d":"R0.00"}}]
["VAT@15%",{"$nulls":3},{"$f":"E10*1.15","v":{"v":0,"d":"R0.00"}}]
["TOTAL"]