{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Schedule A & B","Schedule C","Schedule D","Summary"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Schedule A & B","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"merged":[[48,1,48,3],[49,1,49,3],[57,1,58,3]]}
[]
[]
["EMPLOYER",null,null,"AIRPORTS COMPANY SOUTH AFRICA"]
[]
["DEPARTMENT",null,null,"CIVIL MAINTENANCE"]
[]
["(RFQ TITLE)",null,null,"Maintenance of airside and landside road markings (5years)"]
[{"$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},""]
[{"$nulls":7},""]
[1,"Compliance with OHS Act Regulations",{"$nulls":5},""]
[null,"(including the Construction Regulations 2014):"]
[{"$nulls":7},""]
[null,"(a)"," Submission  of Health ",null,"Lump Sum",1,{"v":20000,"d":"20,000.00"},{"$f":"F26*G26","v":{"v":20000,"d":"20,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},""]
[null,"(a)","Provision for personal, "]
[null,null,"vehicle and hot works permits",null,"Prov-Sum",1,{"v":20000,"d":"20,000.00"},{"$f":"F33*G33","v":{"v":20000,"d":"20,000.00"}}]
[]
[]
[null,"(b)","Site establishment",null,"Lump Sum",1,{"v":20000,"d":"20,000.00"},{"$f":"F36*G36","v":{"v":20000,"d":"20,000.00"}}]
[]
[{"$nulls":7},{"$f":"IF(OR(AND(F38=\"Prov\",G38=\"Sum\"),(G38=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F38*G38),\"\",IF(F38*G38=0,\"\",ROUND(F38*G38,2))))","v":""}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G26:G37)","v":{"v":60000,"d":"60,000.00"}},{"$f":"SUM(H26:H37)","v":{"v":60000,"d":"60,000.00"}}]
[]
[]
["SCHEDULE B"]
[]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
[]
[]
[1,"Contingency"]
[]
[null,"(a)",null,"Contingency for works that are not in the BOQ",{"v":0.1,"d":"10%"},{"v":1,"d":"1.00"}]
[{"$nulls":7},{"$f":"IF(OR(AND(F53=\"Prov\",G53=\"Sum\"),(G53=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F53*G53),\"\",IF(F53*G53=0,\"\",ROUND(F53*G53,2))))","v":""}]
[2,"Temporary traffic-control facilities:"]
[]
[null,"(a)",null,"Traffic Accomodation","Lump-Sum",1,{"v":300000,"d":"300,000.00"},{"$f":"F56*G56","v":{"v":300000,"d":"300,000.00"}}]
[]
[3,"Provision of lighting on site to work on areas during night works"]
[]
[null,"(a)",null,"Lighting for night works","Lump Sum",1,{"v":500000,"d":"500,000.00"},{"$f":"F60*G60","v":{"v":500000,"d":"500,000.00"}}]
[]
[]
[null,"TOTAL"]

{"sheet":"Schedule C","index":1,"n_rows":85,"n_cols":8,"rows_kept":85,"merged":[[13,3,14,3],[58,3,59,3]]}
["SCHEDULE C"]
["ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[{"$nulls":7},{"$f":"IF(OR(AND(F3=\"Prov\",G3=\"Sum\"),(G3=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F3*G3),\"\",IF(F3*G3=0,\"\",ROUND(F3*G3,2))))","v":""}]
[null,"ROAD MARKINGS FOR AIRSIDE",{"$nulls":5},""]
[{"$nulls":7},""]
[null,"Water-based road marking paint on runways",{"$nulls":5},""]
[]
["C11.7.1.1",null,null,"White lines broken/unbroken"]
[null,"(a)",null,"900mm wide runway centerlines","km",{"v":1200,"d":"1,200.00"},null,{"$f":"F9*G9","v":{"v":0,"d":"0.00"}}]
[null,"(b)",null,"200mm edge lines","km",{"v":76,"d":"76.0"},null,{"$f":"F10*G10","v":{"v":0,"d":"0.00"}}]
[]
["C11.7.1.4",null,null,"White lettering & symbols"]
[]
[null,"(a)",null,"Threshold markings, runway designation, aiming blocks, TDZ, displaced threshold","m²",{"v":10000,"d":"10,000"},null,{"v":0,"d":"0.00"}]
[]
[]
[null,"Retro-reflective road marking paint on taxiways"]
[]
["C11.7.2.1",null,null,"Yellow lines broken/unbroken"]
[null,"(a)",null,"150mm wide unbroken","km",600,null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"150mm wide broken","km",123,null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.4",null,null,"Yellow lettering & symbols "]
[null,"(a)",null,"Holding point markings (Visual & Instrumental holding points)","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.6",null,null,"Red lettering & symbols"]
[null,"(a)",null,"Mandatory instruction markings(runway intersections &/holding points)","m²",{"v":6000,"d":"6,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.1.4",null,null,"White lettering & symbols"]
[null,"(a)",null,"White background for the above","m²",{"v":8000,"d":"8,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.7",null,null,"Transverse lines, painted islands and arrestor bed markings (any colour)"]
[null,"(a)",null,"Jet blast fence checkered pattern","m²",500,null,{"v":0,"d":"0.00"}]
[]
[{"$nulls":3},"Removal of existing road markings "]
[null,"(a)",null,"Blacking out ofinnacurate/unwanted road markings","m²",{"v":3500,"d":"3,500"},null,{"v":0,"d":"0.00"}]
[]
[null,"Retro-reflective road marking paint on Aprons "]
[]
["C11.7.2.1",null,null,"White lines unbroken"]
[null,"(a)",null,"150mm unbroken lines","km",500,null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"150mm broken lines","km",200,null,{"v":0,"d":"0.00"}]
[null,"(c)",null,"100mm unbroken lines","km",250,null,{"v":0,"d":"0.00"}]
[null,"(d)",null,"100mm broken lines","km",75,null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.2",null,null,"Yellow lines broken or unbroken "]
[null,"(a)",null,"Stand lead in line, taxiway & taxilane centreline (200mm)","km",400,null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"Apron & taxiway edge (150mm)","km",350,null,{"v":0,"d":"0.00"}]
[null,"(c)",null,"Equipment parking line (150mm)","km",250,null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.5",null,null,"Yellow lettering and symbols "]
[null,"(a)",null,"Maximum wingspan markings","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"Taxilane designation markings","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[null,"(c)",null,"Multiple marshaller and towing stop lines ","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.6",null,null,"Red lettering and symbols"]
[null,"(a)",null,"No entry markings","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.7",null,null,"Transverse lines, painted island and arrestor bed markings (any colour) (paint type indicated)"]
[]
[null,"(a)",null,"Restricted stand by area, no parking area, underground services etc","m²",{"v":4000,"d":"4,000"},null,{"v":0,"d":"0.00"}]
[]
[{"$nulls":3},"Removal of existing road markings "]
[null,"(a)",null,"Blacking out ofinnacurate/unwanted road markings","m²",500,null,{"$f":"G64*F64","v":{"v":0,"d":"0.00"}}]
[]
[null,"Retro-reflective road marking paint on Service Roads"]
[]
["C11.7.2.1",null,null,"White lines broken/unbroken"]
[null,"(a)",null,"150mm white lines broken (center line markings)","km",150,null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"150mm white lines unbroken (edge line markings)","km",170,null,{"v":0,"d":"0.00"}]
[null,"(c)",null,"100mm broken lines","km",50,null,{"v":0,"d":"0.00"}]
[null,"(d)",null,"100mm unbroken lines","km",50,null,{"$f":"F72*G72","v":{"v":0,"d":"0.00"}}]
[]
["C11.7.2.3",null,null,"White lettering & symbols"]
[null,"(a)",null," (stop sign, yield sign & pedestrian sign markings, etc)","m²",{"v":2200,"d":"2,200"},null,{"$f":"F75*G75","v":{"v":0,"d":"0.00"}}]
[]
[]
[{"$nulls":3},"Removal of existing road markings "]
[null,"(a)",null,"Blacking out ofinnacurate/unwanted road markings","m²",{"v":2000,"d":"2,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.5.4",null,null,"Variations in rate of application"]
[null,"(a)",null,"Retro-reflective beads","kg",100,null,{"v":0,"d":"0.00"}]
[]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H8:H84)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Schedule D","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[7,3,8,3],[11,3,12,3]]}
["SCHEDULE D",{"$nulls":6},"SECTION 5700"]
["ITEM NO","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
[{"$nulls":7},{"$f":"IF(OR(AND(F3=\"Prov\",G3=\"Sum\"),(G3=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F3*G3),\"\",IF(F3*G3=0,\"\",ROUND(F3*G3,2))))","v":""}]
[null,"ROAD MARKINGS FOR LANDSIDE",{"$nulls":5},""]
[]
[null,"Retro-reflective road marking paint on the landside road network"]
[]
["C11.7.1.14",null,null,"Labour enhanced hand painted kerb markings (any colour) (paint type indicated)"]
[]
[null,"(a)",null,"Painting of landside kerbs, all types","m²",200,null,{"$f":"F10*G10","v":{"v":0,"d":"0.00"}}]
[]
["C11.7.2.1",null,null,"White lines broken or unbroken "]
[]
[null,"(a)",null,"150mm white lines broken","km",40,null,{"$f":"F14*G14","v":{"v":0,"d":"0.00"}}]
[null,"(b)",null,"150mm white lines unbroken","km",40,null,{"v":0,"d":"0.00"}]
[null,"(c)",null,"100mm white lines broken","km",20,null,{"v":0,"d":"0.00"}]
[null,"(d)",null,"100mm white lines unbroken","km",20,null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.2",null,null,"Yellow lines broken or unbroken "]
[null,"(a)",null,"150mm yellow lines unbroken ","km",25,null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"150mm yellow lines broken ","km",20,null,{"v":0,"d":"0.00"}]
[]
[]
["C11.7.2.3",null,null,"Red lines broken or unbroken "]
[null,"(a)",null,"150mm red lines unbroken","km",15,null,{"v":0,"d":"0.00"}]
[null,"(b)",null,"150mm red lines broken","km",5,null,{"v":0,"d":"0.00"}]
[null,"(c)",null,"100mm red lines unbroken","km",10,null,{"v":0,"d":"0.00"}]
[null,"(d)",null,"100mm red line broken","km",8,null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.4",null,null,"White lettering and symbols"]
[null,"(a)",null," (stop sign, yield sign & pedestrian sign markings, etc)","m²",{"v":7000,"d":"7,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.6",null,null,"Red & White lettering & symbols "]
[null,"(a)",null,"Red and white lettering & symbols (mandatory markings)","m²",{"v":3500,"d":"3,500"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.5",null,null,"Yellow lettering & symbols"]
[null,"(a)",null,"Yellow lettering & symbols, handicapped parking etc","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.2.7",null,null,"Transverse lines, painted island & arrestor"]
[null,"(a)",null,"No parking, painted island, restricted parking areas etc","m²",{"v":3000,"d":"3,000"},null,{"v":0,"d":"0.00"}]
[]
[{"$nulls":3},"Removal of existing road markings ",{"$nulls":3},{"v":0,"d":"0.00"}]
[null,"(a)",null,"Blacking out of innacurate/unwanted road markings","m²",{"v":3500,"d":"3,500.0"},null,{"v":0,"d":"0.00"}]
[]
["C11.7.5.4",null,null,"Variations in rate of application"]
[null,"(a)",null,"Retro-reflective beads","kg",100,null,{"v":0,"d":"0.00"}]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H10:H46)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Summary","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[7,1,7,3],[9,1,9,3],[13,0,13,3],[14,0,14,3],[15,0,17,3],[15,4,17,4]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[]
["SECTION","DESCRIPTION",null,null,"TOTAL"]
[]
["Schedule A","GENERAL REQUIREMENTS AND PROVISIONS"]
[]
["Schedule B","CONTINGENCY & TEMPORARY TRAFFIC-CONTROL FACILITIES"]
[]
["Schedule C","ROAD MARKINGS FOR AIRSIDE"]
[]
["Schedule D","ROAD MARKINGS FOR LANDSIDE"]
[]
["TOTAL EXCL VAT",{"$nulls":3},{"$f":"SUM(E6:E12)","v":{"v":0,"d":"R0.00"}}]
["VAT@15%"]
["TOTAL"]