{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["P&G's","Road Construction","Drainage","BOQ Summary"],"read":"whole","date_system":"1900"}

{"sheet":"P&G's","index":0,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[1,2,1,3],[3,2,3,4],[5,2,5,5]]}
[]
["EMPLOYER",null,"AIRPORTS COMPANY SOUTH AFRICA"]
[]
["DEPARTMENT",null,"CIVIL MAINTENANCE"]
[]
["(RFQ TITLE)",null,"Pavement & Surface 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: GENERAL REQUIREMENTS AND PROVISIONS"]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
["C1.2.5","Safety",{"$nulls":5},{"$f":"IF(OR(AND(F16=\"Prov\",G16=\"Sum\"),(G16=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F16*G16),\"\",IF(F16*G16=0,\"\",ROUND(F16*G16,2))))","v":""}]
[]
["C1.2.5.1",null,"Health and safety plan",null,"Lump Sum",1,{"v":30000,"d":"R30,000.00"},{"$f":"G18*F18","v":{"v":30000,"d":"R30,000.00"}}]
[]
["PC 1.3.7",null,"Airside induction and permits",null,"Prov-Sum",1,{"v":30000,"d":"R30,000.00"},{"$f":"G20*F20","v":{"v":30000,"d":"R30,000.00"}}]
[]
[]
["C1.2.1","Environmental Management"]
[]
["C1.2.1.1",null,"Monitoring of compliance with and reporting on the EMP",null,"Lump Sum",1,null,{"v":20000,"d":"R20,000.00"}]
[]
["C1.3.1","The Contractor's general obligations"]
[]
["C1.3.1.1",null,"Fixed obligations",null,"lump sum",1,{"v":30000,"d":"R30,000.00"},{"$f":"G29*F29","v":{"v":30000,"d":"R30,000.00"}}]
["C1.3.1.2",null,"Value-related obligations",null,"lump sum",1,{"v":30000,"d":"R30,000.00"},{"$f":"G30*F30","v":{"v":30000,"d":"R30,000.00"}}]
[]
[null,"TOTAL",{"$nulls":5},{"$f":"SUM(H16:H31)","v":{"v":140000,"d":"140,000.00"}}]
[]
["SCHEDULE B: TEMPORARY TRAFFIC-CONTROL FACILITIES"]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
["C 1.5.7","Temporary traffic control facilities"]
[]
[null,"PC 1.5.14","Provision of lighting on site areas for night works",null,"Lump-Sum",1,{"v":80000,"d":"R80,000.00"},{"$f":"G40*F40","v":{"v":80000,"d":"R80,000.00"}}]
[]
[null,"C1.5.7.1","Delineators including mounting bases and ballast:"]
[null,"(b) ","Double sided, reversible left or right (size indicated)",null,"Number(No,)",50]
[]
[null,"C1.5.7.2","Traffic cones, minimum height 750 mm",null,"number (No.)",100]
[null,"C1.5.7.4","Traffic controllers",null,"Lump-Sum",1,{"v":60000,"d":"R60,000.00"},{"$f":"G46*F46","v":{"v":60000,"d":"R60,000.00"}}]
[null,"TOTAL"]

{"sheet":"Road Construction","index":1,"n_rows":137,"n_cols":8,"rows_kept":137,"merged":[[45,1,45,2],[50,1,50,2]]}
["SCHEDULE C : ROAD CONSTRUCTION"]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[{"$nulls":7},{"$f":"IF(OR(AND(F5=\"Prov\",G5=\"Sum\"),(G5=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F5*G5),\"\",IF(F5*G5=0,\"\",ROUND(F5*G5,2))))","v":""}]
["C 4.3.4","Saw-cutting existing materials within the following ",{"$nulls":5},""]
[null,"average depth ranges:",{"$nulls":5},""]
[]
[null,"C4.3.4.1","Asphalt",{"$nulls":4},""]
[]
[null,"(a)","Up to 50 mm",null,"m",{"v":3000,"d":"3,000"}]
[]
[null,"(b)","Exceeding 50 mm and up to 100 mm",null,"m",{"v":3000,"d":"3,000"}]
[{"$nulls":3},""]
[null,"(c)","Exceeding 100 mm and up to 150 mm",null,"m",{"v":1000,"d":"1,000"}]
[]
[null,"C4.3.4.4","Concrete material:"]
[]
[null,"(a)","Up to 50 mm",null,"m",{"v":5000,"d":"5,000"}]
[]
[null,"(b)","Exceeding 50 mm and up to 100 mm",null,"m",{"v":5000,"d":"5,000"}]
[{"$nulls":3},""]
[null,"(c)","Exceeding 100 mm and up to 150 mm",null,"m",{"v":2000,"d":"2,000"}]
[]
["C4.3.5","Providing the milling machine on the site:"]
[]
[null,"C4.3.5.1","Small milling machine with a cutting width of 1,2 m or smaller",null,"No.","Rate only"]
[null,"C4.3.5.2","Large milling machine with a cutting width exceeding 1,2 m",null,"No.","Rate only"]
[]
["C.4.3.6","Milling and removal of existing asphalt layers with "]
[null,"an average milling depth"]
[null,"(Contractor takes ownership):"]
[]
[null,"C 4.3.6.1","Not exceeding 50 mm",null,"m³",720]
[]
[null,"C 4.3.6.2","Exceeding 50 mm but not exceeding 100 mm",null,"m³",720]
[]
[null,"C 4.3.6.3","Exceeding 100 mm",null,"m³",720]
[]
["C4.3.8","Excavating material by milling:"]
[]
[null,"C4.3.8.1","Crushed stone material",null,"m³","Rate only"]
[null,"C4.3.8.2","Cemented material",null,"m³","Rate only"]
[null,"C4.3.8.3","Natural gravel material",null,"m³","Rate only"]
[]
["C4.3.9","Excavating material by using conventional road construction equipment:"]
[]
[null,"C4.3.9.2","Cemented material",null,"m³",800]
[null,"C4.3.9.3","Natural gravel material",null,"m³",800]
[]
["C4.3.12","Removing of existing concrete material within the following average depth ranges by:"]
[]
[null,"C4.3.12.1","The break-up method:"]
[null,"(a)","Not exceeding 150 mm",null,"m³",80]
[null,"(b)","Exceeding 150 mm but not exceeding 250 mm",null,"m³",50]
[]
[null,"C4.3.12.2","The break-up method using labour enhanced methods of construction:"]
[null,"(a)","Not exceeding 75 mm",null,"m³",720]
[null,"(b)","Exceeding 75 mm but not exceeding 200 mm",null,"m³",550]
[]
["C4.3.14","Removing of existing road edging and services structures:"]
[]
[null,"C4.3.14.1","Removing of existing road edging using construction equipment:"]
[null,"(a)","Kerbing and edge beams:",null,"m³","Rate only"]
[null,"(i)","In situ concrete kerbing and edge beams",null,"m","Rate only"]
[null,"(ii)","Precast concrete kerbing (specify type or figure)",null,"m","Rate only"]
[null,"(iii)","Precast concrete kerbing (specify type or figure) and situ concrete channel (specify dimensions)",null,"No.","Rate only"]
[null,"(b)","Kerb inlets",null,"No.","Rate only"]
[null,"(c)","Grid inlets",null,"No.","Rate only"]
[null,"(d)","Etc., for other services structures",null,"No.","Rate only"]
[]
["C6.1.4","Texturing and curing the concrete pavement"]
[]
[null,"C6.1.4.1","Burlap-dragged and grooved texture:"]
[null,"(a)","Paver constructed",null,"m²",350]
[null,"C6.1.4.3","Curing:"]
[null,"(a)","Paver constructed",null,"m²",650]
[]
["C6.1.5","Variation in the rate of application of the curing compound",null,null,"l",2000]
[]
["C7.1.2","Transverse and longitudinal crack and joint repairs incorporating the following treatments"]
[]
[null,"C7.1.2.1","Routing of active cracks",null,"m",500]
[null,"C7.1.2.2","Routing of non-active cracks",null,"m",500]
[null,"C7.1.2.5","Saw cutting of cracks and joints in one operation ",null,"m",200]
[]
[null,"C6.1.6.6","Forming and sealing joints between asphalt and concrete pavements",null,"m",350]
[]
["C 6.2.1","Segmental block paving"]
[]
[null,"C 6.2.1.1","Concrete block paving ",null,"m²",700]
[]
[null,"PC 6.2.1.2","Repairing of existing paving",null,"m²",400]
[]
["C 7.2","Repair of uncontrlled cracks and existing joints"]
[]
["C 7.2.1","Crack repairs",null,null,"m",{"v":4000,"d":"4,000"}]
[]
["C 7.3","Maintenance of concrete layers"]
[]
[null,"C 7.3.5","Partial Depth Repairs using hand placed acrylic resin grout",null,"m²",100]
[null,null,"(ABE/SIKA products or aproved alternatives)"]
[null,null,"minimum of 50 mm and a maximum of 75 mm."]
[]
["C 9.1.3","Application of bond coat"]
[]
[null,"C 9.1.3.1","Stable –grade 30 % net bitumen emulsion as specified. Applied with a calibrated distributer",null,"l",{"v":3000,"d":"3,000"}]
[]
["C9.1.10","Variation rates"]
[]
[null,"C9.1.10.1"," AC surface 50/70 grade bitumen",null,"t","Rate-only"]
[null,"C9.1.10.2","Aggregate",null,"t","Rate-only"]
[null,"C9.1.10.3","Active filler (lime unless stated in Contract Documentation)",null,"t","Rate-only"]
[]
["C 9.1.5","Asphalt Surfacing"]
[]
[null,"C 9.1.5.2 ","Asphalt Rehabilitation"]
[null,"(a)","Stone skeletal mix – continuously graded as defined",null,"t",{"v":1000,"d":"1,000"}]
[null,null," (medium AC surface 50/70 grade bitumen at"]
[null,null,"average depth of 55mm)"]
[]
[null,"(b)","Stone skeletal mix – SMA"]
[]
[null,"(h)","Cold mix",null,"t",10]
[]
["C 9.1.4","Asphalt base"]
[null,"C 9.1.4.2","Rehabilitation"]
[null,"(e)","BTB method (layer not exceeding 150mm)",null,"t",200]
[]
["C9.1.13","Coring of asphalt layers"]
[]
[null,"C9.1.13.1","100 mm diameter",null,"No.",30]
[null,"C9.1.13.2","150 mm diameter",null,"No.",30]
[]
["C11.8.12","Removal of undesirable vegetation",null,null,"m²",1000]
[]
[null,"TOTAL"]

{"sheet":"Drainage","index":2,"n_rows":48,"n_cols":8,"rows_kept":48}
["SCHEDULE D: DRAINAGE"]
[]
["ITEM","DESCRIPTION",null,null,"UNIT","QUANTITY","RATE","AMOUNT"]
["NO"]
[]
["C 2.3.32","Covers and frames for water main manholes, valve and"]
[null," hydrant chambers and other structures"]
[null,"C 2.3.32.1","Pre-cast Concrete Covers"]
[null,null,"(a) Light-dutty",null,"No.",50]
[]
[null,"C 2.3.32.2","Cast Iron Covers"]
[null,null,"(a) Circular",null,"No.",50]
[null,null,"(b) Square",null,"No.",50]
[]
[null,"C 2.3.32.3","Stormwater Grit Covers",null,"No.",50]
[{"$nulls":7},{"$f":"IF(OR(AND(F16=\"Prov\",G16=\"Sum\"),(G16=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(F16*G16),\"\",IF(F16*G16=0,\"\",ROUND(F16*G16,2))))","v":""}]
["C 3.1.3","Excavation, clearing and disposal of accumulated sediment in existing lined drains and drainage systems"]
[]
[null,"C3.1.3.1","Using conventional methods (up to 1,5 m):"]
[null,"(a)","Manholes and inlet and outlet structures",null,"m³",150]
[null,"(b)","Culvert barrels",null,"m³",150]
[null,"(c)","Concrete or other lined side drains",null,"m³",150]
[]
[null,"C3.1.3.2","Using conventional methods (in excess of 1,5 m):"]
[null,"(a)","Manholes and inlet and outlet structures",null,"m³",150]
[null,"(b)","Culvert barrels",null,"m³",150]
[null,"(c)","Concrete or other lined side drains",null,"m³",150]
[]
[null,"C3.1.3.3","Using labour enhanced construction methods:"]
[null,"(a)","Manholes and inlet and outlet structures",null,"m³",150]
[null,"(b)","Culvert barrels",null,"m³",150]
[null,"(c)","Concrete or other lined side drains",null,"m³",150]
[]
[null,"PC 3.1.3.4","Unblock using High pressure machine for all drains",null,"No.",100]
[null,null,"(Rate inclusive of reinstating existing drain gratings)"]
[]
["C11.2.3",null,"Gabion boxes and mattresses:"]
[]
[null,"C11.2.3.1","Galvanized gabion boxes 2m x 1m x 0.5m",null,"m³",100]
[]
["C3.3.6",null,"Concrete chutes"]
[]
[null,"C3.3.6.1","Prefabricated concrete chutes",null,"m",100]
[]
[null,null,"Subtotal",{"$nulls":4},{"$f":"SUM(H5:H34)","v":0}]
[]
[null,null,"Mark up ",1.2]
[null,"TOTAL CARRIED TO SUMMARY"]

{"sheet":"BOQ Summary","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"merged":[[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[21,1,22,1]]}
["SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[]
["SECTION","DESCRIPTION",null,null,"TOTAL"]
[]
["Schedule A","GENERAL REQUIREMENTS AND PROVISIONS",null,null,{"$f":"'P&G''s'!H32","v":{"v":140000,"d":"R140,000.00"}}]
[]
["Schedule B","TEMPORARY TRAFFIC-CONTROL FACILITIES",null,null,{"$f":"'P&G''s'!H40+'P&G''s'!H46","v":{"v":140000,"d":"R140,000.00"}}]
[]
["Schedule C","ROAD CONSTRUCTION"]
[]
["Schedule D","DRAINAGE"]
[]
["Subtotal"]
["CONTINGENCIES @15%"]
["TOTAL EXCL VAT"]
["VAT@15%"]
["TOTAL"]