{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["GENERAL REQUIREMENTS","IBR SECTION","CLIP-LOCK SECTION","SUMMARY SCHEDULE"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"GENERAL REQUIREMENTS","index":0,"n_rows":46,"n_cols":8,"rows_kept":46}
[]
[]
["EMPLOYER",null,null,"AIRPORTS COMPANY SOUTH AFRICA"]
[]
["DEPARTMENT",null,null,"CIVIL MAINTENANCE"]
[]
["(RFQ TITLE)",null,null,"K8 Hanger repairs"]
[{"$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]
[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"]
[]
[null,null,"NOTE: Safety file to include Risk assesment and"]
[{"$nulls":3},"fall protection plan for heights greater than 3m"]
[]
[]
[2,"Compliance with obtaining airside permits"]
[{"$nulls":7},{"$f":"IF(OR(AND(F35=\"Prov\",G35=\"Sum\"),(G35=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F35*G35),\"\",IF(F35*G35=0,\"\",ROUND(F35*G35,2))))","v":""}]
[null,"(a)","Provision for personal, "]
[null,null,"vehicle and hot works permits",null,"Prov-Sum",1,{"v":20000,"d":"R20,000.00"},{"$f":"F37*G37","v":{"v":20000,"d":"R20,000.00"}}]
[]
[]
[3,"Site establishment",null,null,"Lump Sum",1]
[]
[4,"Contingency for work not covered in the BOQ",null,null,"Prov-Sum",1,{"v":200000,"d":"R200,000.00"},{"$f":"F42*G42","v":{"v":200000,"d":"R200,000.00"}}]
[]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F45=\"Prov\",G45=\"Sum\"),(G45=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F45*G45),\"\",IF(F45*G45=0,\"\",ROUND(F45*G45,2))))","v":""}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H23:H45)","v":{"v":220000,"d":"R220,000.00"}}]

{"sheet":"IBR SECTION","index":1,"n_rows":31,"n_cols":8,"rows_kept":31}
[]
[]
[]
["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,"IBR SECTION REPAIRS",{"$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,"Note: Rates to include all fixings, accessories, and labour."]
[]
[1,"Remove and dispose of damaged roof sheets from site",null,null,"Lump sum",1]
[]
[2,"Supply and install 75 mm white fiberglass insulation, secured with",null,null,"m²",275]
[null," plastic-coated wire"]
[]
[3,"Re-tension and secure existing insulation straining wire",null,null,"m²",475]
[]
[4,"Supply and install 0.58 mm pre-coated IBR roof sheets with bullnosing",null,null,"m²",275]
[]
[5,"Supply and install 0.8 mm pre-coated internal and external flashings,",null,null,"m",125]
[null," 462mm girth"]
[]
[6,"Supply and install 8 × 3 mm internal gaskets to all side laps to prevent",null,null,"m",400]
[null,"leaks"]
[]
[7,"Supply and install 50 × 50 × 3 mm threaded and coated square tubing",null,null,"m",150]
[null," to support new IBR roof sheets"]
[]
[8,"Inspect and maintain roof bolts, sealing all bolts and replacing as required",null,null,"m²",750]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H12:H30)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"CLIP-LOCK SECTION","index":2,"n_rows":51,"n_cols":8,"rows_kept":51}
[]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[]
[null,"CLIP-LOCK SECTION REPAIRS"]
[null,"Note: Rates to include all fixings, accessories, and labour."]
[]
[1,"Strip roof to access damaged clip-lock roof sheets",null,null,"m²",{"v":4450,"d":"4,450"}]
[]
[2,"Remove and dispose of damaged roof sheets from site",null,null,"Lump Sum",1]
[]
[3,"Supply and install 0.58 mm pre-coated clip-lock roof sheets with clips",null,null,"m",316]
[]
[4,"Re-install roof sheets with new clips",null,null,"m²",{"v":4450,"d":"4,450"}]
[]
[5,"Seal all holes and tears in roof that is caused by wind driven sheets",null,null,"l/s",1]
[]
[6,"Allowance for on-site mill to roll full-length roof sheets",null,null,"day",1]
[]
[7,"Maintenance of clip-lock roof sheets, including installation of ",null,null,"m²",{"v":11200,"d":"11,200"}]
[null,"new saddle washers with 90 mm top-speed screws to all purlins"]
[]
[8,"Maintenance of internal box gutters, including cleaning, water testing, ",null,null,"m",140]
[null,"abrasion of all corrosion to bright metal, and one full coat of Lastiflex primer"]
[]
[9,"Apply two full coats of Lastiflex rubberizing waterproofing",null,null,"m",140]
[null," system to box gutters"]
[]
[10,"Abrade all rusted areas to bright metal lines (approx. 30% of surface)",null,null,"m²",{"v":3360,"d":"3,360"}]
[]
[11,"Prepare entire roof area using a mild chemical cleaning solution",null,null,"m²",{"v":11200,"d":"11,200"}]
[]
[12,"High-pressure industrial-strength water jet cleaning",null,null,"m²",{"v":11200,"d":"11,200"}]
[]
[13,"Apply patch primer to all rusted areas (approx. 30% of surface)",null,null,"m²",{"v":3360,"d":"3,360"}]
[]
[14,"Apply first coat of ULTRA primer at 45–50 µm DFT using airless compressor",null,null,"m²",{"v":11200,"d":"11,200"}]
[]
[15,"Apply first full coat of roof acrylic at 40–50 µm DFT using airless spray",null,null,"m²",{"v":11200,"d":"11,200"}]
[]
[16,"Apply second full coat of roof acrylic at 40–50 µm DFT using airless spray",null,null,"m²",{"v":11200,"d":"11,200"}]
[]
[17,"Perform random adhesion tests to verify adequate bonding",null,null,"Lump Sum",1]
[]
[18,"Trace and seal leaks after completion of works",null,null,"Lump Sum",1]
[]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H11:H50)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"SUMMARY SCHEDULE","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"merged":[[11,0,11,3],[12,0,12,3],[13,0,15,3]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[]
["SECTION","DESCRIPTION",null,null,"TOTAL"]
[]
["Schedule A","GENERAL REQUIREMENTS AND PROVISIONS",null,null,{"$f":"'GENERAL REQUIREMENTS'!H46","v":{"v":220000,"d":"R220,000.00"}}]
[]
["Schedule C","IBR SECTION",null,null,{"$f":"'IBR SECTION'!H31","v":{"v":0,"d":"R0.00"}}]
[]
["Schedule D","CLIP-LOCK SECTION",null,null,{"$f":"'CLIP-LOCK SECTION'!H51","v":{"v":0,"d":"R0.00"}}]
[]
["TOTAL EXCL VAT",{"$nulls":3},{"$f":"SUM(E6:E11)","v":{"v":220000,"d":"R220,000.00"}}]
["VAT@15%",{"$nulls":3},{"$f":"E12*0.15","v":{"v":33000,"d":"R33,000.00"}}]
["TOTAL",{"$nulls":3},{"$f":"SUM(E12:E13)","v":{"v":253000,"d":"R253,000.00"}}]