{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Summary of BOQ","PAGE 1-8","PAGE 2-8","PAGE 3-8","PAGE 4-8","PAGE 5-8","PAGE 6-8","PAGE 7-8","PAGE 8-8"],"not_rendered":{"defined_names":8,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Summary of BOQ","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[5,1,5,4],[9,1,9,4],[27,0,27,2],[28,0,28,2],[29,0,29,2]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,null,"SUMMARY OF BILL OF QUANTITIES"]
["Section ",{"$nulls":3},"Total"]
[1,"PRELIMINARARY AND GENERAL",{"$nulls":3},"R"]
[null,"AA","PRELIMINARIES","R"]
[null,"AB","GENERAL SPECIFICATIONS","R"]
[null,"AH","OCCUPATIONAL HEALTH and SAFETY","R"]
[2,"REMEDIATION WORKS",{"$nulls":3},"R"]
[null,"B","SITE CLEARANCE","R"]
[null,"C","CONCRETE WORK","R"]
[null,"DA","EARTHWORKS : BULK","R"]
[null,"DB","EARTHWORKS FOR PIPE TRENCHES","R"]
[null,"DD","EARTHWORKS FOR STRUCTURES","R"]
[null,"EB","GRADED CRUSHED STONE","R"]
[null,"ED","ROAD ASPHALT","R"]
[null,"EF","KERBS AND HAUNCHES","R"]
[null,"EG","SIDEWALKS, FOOTPATHS and MEDIAN AREAS","R"]
[null,"EH","STEEL GUARDRAILS & CONC.MEDIAN BARRIERS","R"]
[null,"EL","DUMPROCK SUBGRADE IMPROVEMENT","R"]
[null,"F","PROTECTION WORKS","R"]
[null,"PG","NON PRESSURE PIPELINES and PC CULVERTS","R"]
[null,"PH","MANHOLES and APPURTENANT DRAINAGE WORKS","R"]
[null,"TA","ROAD SIGNS","R"]
[null,"TB","ROAD MARKING","R"]
[]
["SUB TOTAL ",{"$nulls":4},"R"]
["ADD VAT (15%) - (only if a registered VAT Vendor",{"$nulls":4},"R"]
["TOTAL CARRIED TO FORM OF TENDER",{"$nulls":4},"R"]

{"sheet":"PAGE 1-8","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[13,0,13,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,"SECTION",1,"PRELIMINARY & GENERAL"]
[null,"PART","AA","PRELIMINARIES"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"GCC 2015","sum","GENERAL CONDITIONS OF CONTRACT (GCC 2015) READ IN CONJUNCTION WITH THE CONTRACT DATA (Fixed Charge Obligations)",1]
[2,"GCC 2015","sum","Time Related Obligations",1]
[3,"SANS 1921-1","sum","SANS 1921-1: GENERAL ENGINEERING AND CONSTRUCTION WORKS READ IN CONJUNCTION WITH ASSOCIATED SPECIFICATION DATA IN SCOPE OF WORKS (Fixed Charge Items)",1]
[4,"SANS 1921-1","months","Time Related Items",1]
[5,"PS.13","PC Sum","Community liason officer (Allow for a CLO to be appointed for each ward/task order)",{"$f":"90*8*22*6","v":95040}]
[6,null,"%","Contractor's overheads, charges and profits on item 5 above",{"$f":"90*8*22*6","v":95040}]
["TOTAL CARRIED TO SECTION 1 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","AB","GENERAL SPECIFICATION"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"AB.4/PS.AB.1.2","sum","Contractor's Camp Site/Store Yard",1]
[2,"AB.5/PS.AB.6","sum","Notice Board",1]
[3,"AB.7","sum","Initial supply of all signs, barricades and delineators",1]
[4,"AB.6 ","sum","Cost of Samples and Contractor's Preliminary and Site Control Testing",1]
[5,"AB.7","PC Sum","Maintenance of Pedestrian and Traffic Facilities",10000]
[6,"AB.7","sum","Maintenance of all signs, barricades and delineators",1]
[8,"PS.11","PC Sum","Survey for, and preparation of 'As-Built' Drawings",5000]
[7,"AB.5/PS.AB.5","PC Sum","Progress Photographs (Before, during & after completion)",500]
[9,null,"PC Sum","Survey coordiation of existing valves, manholes, catchpits, and cable duct makers",10000]
["TOTAL CARRIED TO SECTION 1 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]

{"sheet":"PAGE 2-8","index":2,"n_rows":10,"n_cols":7,"rows_kept":10}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,"PART","AH","OCCUPATIONAL HEALTH AND SAFETY"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"AH.14.1","sum","Contractor's initial obligations in respect of the Occupational Health and Safety Act and Construction Regulations",1]
[2,"AH.14.2","sum","Contractor's time related obligations in respect of the Occupational Health and Safety Act and Construction Regulations",1]
[3,"AH.14.3","sum","Submission of the Health and Safety File",1]
["TOTAL CARRIED TO SECTION 1 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]

{"sheet":"PAGE 3-8","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"merged":[[17,0,17,4],[25,0,25,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,"SECTION",2,"ZAKWE PLACE AND SURROUNDING LANES - WARD 17"]
[null,"PART","B","SITE CLEARANCE"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"B.8.2","m2","General clearance and grubbing in road reserve",{"$f":"(336*5)+(195*4)+(100*3.75)","v":2835}]
[2,"B.8.4/PS.B.3","No.","Removal of trees of girth exceeding 1,5m",3]
[3,"B.8.5","m","Removal of 1.8m high wire mesh fence and store on site for re-use",10]
[4,"B.8.9","m3","Removal of brickwork",3]
[5,"B.8.10","m3","Removal of unreinforced concrete",0.5]
[7,"B.8.19","m3","Removal of disused pipes, 300 - 500 mm diameter and spoil at tip. Rate to include all haulage",10]
[8,null,"PC Sum","Relocation/lowering water meters/valves - includes plumbers rates & supply and transport of all materials.",5000]
[9,null,"PC Sum","Lowering of water mains as deemed necessary per instruction of Engineer's Representative.",5000]
[10,"B.8.21","m3","Backfilling with suitable material from site",50]
[11,"B.8.21","m3","Backfilling with suitable material imported from an off-site source",100]
["TOTAL CARRIED TO SECTIOB 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART ","C","CONCRETE WORK"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"C.8.1","m","Reinforced Concrete V-Drain as per standard detail (600m wide x 100mm thick) - using 25/20Mpa concrete with Mesh Ref 193. Include all necessary excavation, shuttering, formwork, expansion joints & finishing. As per directed on site by Engineer's Representative.",300]
[2,"C.8.2","m3","Supply and lay concrete roadway (Ready-mix 125mm thick) 30/26 Mpa including transverse joints, curing and with rough stiff bristled broom finish applied tranversely across the width of the road to create striations of about 1,5mm to 3,0mm in depth. The concrete mix, mxing, batching, transportating, placing, compaction, and curing shall comply with the requirements of Part C: Concrete Work. The rate shall cover excavation, formation preparation, all necessary compaction",50]
[3,"C.8.1 PS.C.7","m2","Install mesh ref 395 om concrete slab",400]
["TOTAL CARRIED TO SECTION 2 SUMMARY; ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]

{"sheet":"PAGE 4-8","index":4,"n_rows":28,"n_cols":7,"rows_kept":28,"merged":[[16,0,16,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,"PART ","DA","EARTHWORKS:BULK"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"DA.8.3","m3","Excavate soft material and place directly into fill ",350]
[2,"DA.8.3","m3","Excavate soft material to spoil ",60]
[3,"DA.8.3","m3","Extra over above for the excavation of intermediate material to spoil",30]
[4,"DA.8.3","m3","Extra over above for excavation of hard material to spoil",20]
[5,"DA.8.3","m3","Extra over above for the excavation of boulders greater than 0,15 m3 to spoil.",10]
[6,"DA.8.3","m3","Excavate unsuitable material below embankments or formation and spoil at tip",10]
[7,"DA.8.4","m3","Import G7 material from contractor's off-site source inclusive of haulage and royalties",170]
[8,"DA.8.5","m3","Compact soft material from site to 95% Mod. A.A.S.H.T.O.",155]
[9,"DA.8.9","m2","Formation",250]
[10,"DA.8.4","m3","Import G9 material from contractor's off-site source inclusive of haulage and royalties",150]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[]
[null,"PART ","DB","EARTHWORKS FOR PIPE TRENCHES"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[]
[1,null,"m","Supply and lay Type A subsoil as per standard detail. Rate to include clean coarse sand, drainage grade geofabric, 100mm subsoil pipe and 13.2mm stone chipings.",25]
[2,"DB.8.5  PS.PB.1/2/3/4/6/8/9/20","m3","Excavate and backfill in all material for 450mm diameter pipe where depth is:- - Over 0,0 m and not exceeding 1,5 m",10]
[3,"DB.8.5              PS.PB.1/2/3/4/6/8/9/20","m3","Excavate and backfill in all material for 450mm diameter pipe where depth is:- - Over 1,5 m and not exceeding 2,0 m",5]
[4,"DA.8.6","m3","Extra over item [1 & 2] for hard material",3]
[5,"DB.8.9/PS.DB.1/9","m","Supply, placing and compacting of Class C bedding for 450mm diameter pipe as per STD detail 38575",20]

{"sheet":"PAGE 5-8","index":5,"n_rows":49,"n_cols":7,"rows_kept":49,"merged":[[6,0,6,4],[14,0,14,4],[22,0,22,4],[30,0,30,4],[40,0,40,4],[48,0,48,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
["Continued","PART ","DB","EARTHWORKS FOR PIPE TRENCHES"]
[]
[6,"DB.8.19","m3","Prove existing services by hand excavation, where depth is --Over 0,0m and not exceeding 1,5m",3]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","DD","EARTHWORKS FOR STRUCTURES"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"DA.8.2","m3","Excavate in all material for GEOLOK/GABIONS retaining wall to spoil",50]
[2,"DA.8.2","m3","Extra over item 1 for hard material",5]
[3,"DA.8.3","m3","Backfill and compact behind the GABION/GEOLOK retaining wall using imported G9 material from the contractor's own source. Rate to include all haulage and royalties",50]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","EB","GRADED CRUSHED STONE "]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EB.8(1)/PS.EB.1","m3","Supply, lay, process and compact G5, Natural Gravel 125 mm thick compacted to 97% Mod AASHTO",245]
[2,"EB.8(1)/PS.EB.1","m3","Supply, lay, process and compact G2, Crushed Stone 125 mm thick compacted to 100% Mod AASHTO",285]
[3,"EB.8(2)","m2","Prime Coat 0.6litres/m2",1930]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","ED","ROAD ASPHALT"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"ED.8.3","tons","Private Plant Asphalt Sa-S14. Bitumen content % as per mix design entered at time of use",150]
[2,"ED.8.4","m2","Tack coat ,0.3m/l2. Shall be sprayed onto road surface.",100]
[3,"AA.ED","m","Saw Cut existing asphalt surface to a depth of 50mm.",50]
["TOTAL CARRIED TO SECTIOB 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","EF","KERBS AND HAUNCHES"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EF.8.1","m","Modified Type F mountable kerb and fillet/channel inclusive of base and haunching ",20]
[2,"EF.8.1/PS.EF.1","m","Modified Type A barrier kerb and fillet/channel inclusive of base and haunching",350]
[3,"EF.8.1","m","Extra over item 1 for curves of radius less than 25m",20]
[4,"EF.8.1","m","Extra over item 1 curves for curves of radius less than 2m",5]
[5,"EF.8.1/ PS.EF.2","m","Figure 12 (150x75) kerb as edge restriant inclusive of base and haunching ",240]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","EG","SIDEWALKS, FOOTPATHS AND MEDIAN AREAS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EG.8.1 PS.EG.1","m2","Asphalt Sidewalk / Footpath with 100mm G2 graded crushed stone overlaid by 25mm Mix A asphalt (Rate to include weedkiller)",150]
[2,"EG.8.3","m","Soft board expansion joint including post construction sealant",75]
[3,"EG.8.3","m2","Supply and place ref 193 mesh reinforcing as directed by Engineer",{"$f":"E46*2","v":300}]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]

{"sheet":"PAGE 6-8","index":6,"n_rows":35,"n_cols":7,"rows_kept":35,"merged":[[11,0,11,4],[19,0,19,4],[28,0,28,4],[34,0,34,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,"PART","EF","KERBS AND HAUNCHES"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EF.8.1","m","Modified Type F mountable kerb and fillet/channel inclusive of base and haunching ",20]
[2,"EF.8.1/PS.EF.1","m","Modified Type A barrier kerb and fillet/channel inclusive of base and haunching",350]
[3,"EF.8.1","m","Extra over item 1 for curves of radius less than 25m",20]
[4,"EF.8.1","m","Extra over item 1 curves for curves of radius less than 2m",5]
[5,"EF.8.1/ PS.EF.2","m","Figure 12 (150x75) kerb as edge restriant inclusive of base and haunching ",240]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","EG","SIDEWALKS, FOOTPATHS AND MEDIAN AREAS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EG.8.1 PS.EG.1","m2","Asphalt Sidewalk / Footpath with 100mm G2 graded crushed stone overlaid by 25mm Mix A asphalt (Rate to include weedkiller)",150]
[2,"EG.8.3","m","Soft board expansion joint including post construction sealant",75]
[3,"EG.8.3","m2","Supply and place ref 193 mesh reinforcing as directed by Engineer",{"$f":"E17*2","v":300}]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","EH","STEEL GUARDRAILS & CONC. MEDIAN BARRIERS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EH.8.1","m","Straight steel guard rails ",50]
[2,"EH.8.1","m","Curved steel guardrails ",15]
[3,"EH.8.1","no.","End wings ",4]
[4,"EH.8.1","no.","Precast concrete posts ",15]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","EL","DUMPROCK SUBGRADE IMPROVEMENT"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"EL.8","m3","Dumprock subgrade improvement, 300 mm thick",20]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]

{"sheet":"PAGE 7-8","index":7,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[15,0,15,4],[22,0,22,4],[32,0,32,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
[null,"PART","F","PROTECTION"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"F.8.1/PS.F.1","m2","Imported topsoil from commercial source 100mm thick",100]
[2,"F.8.3","m2","Grass sodding",80]
[3,"F.8.6","m3","Gabion boxes, 1000 mm depth",100]
[4,"F.8.6","m3","Gabion boxes, 500 mm depth",60]
[5,"F.8.6","m3","Gabion mattresses, 300 mm thick",20]
[6,"F.8.7/C.8.1","m3","Grade 20/19 concrete to GEOLOK wall footing inclusive of reinforcing (refer to manufacturers specification)",10]
[7,"PS.F.5","m2","Install Geolok 400 blocks retaining wall as per the Engineers specification. Rate shall include transport, labour and installation",100]
[8,null,"no.","Supply and lay 50mm diameter PVC weepholes inclusive of no fines plug.",50]
[9,"PS.F.4","m2","Drainage grade geofabrics",70]
["TOTAL CARRIED TO SECTION 2 SUMMARY: : ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","PG","NON PRESSURE PIPELINES AND CULVERTS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"PG.8.2","m","Supply and lay  450 mm diameter concrete Class 100D stormwater pipe. The rate shall include procurement, transport and labour",15]
[2,"PG.8.6","m3","Grade 15/26 concrete to anchor blocks",3]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","PH","MANHOLES AND APPARTENANT DRAINAGE WORKS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"PH.8.4/PS.PH.3","no.","Constructed standard headwall (Type A) as per standard drawings No. 38476 & as per directed on site. Rate to include all labour, material & plant.",1]
[2,"PH.8.3","no.","Manhole Type D3. Depth :- - Over 0,0 m and not exceeding 1,5 m",1]
[3,"PH.8.3","no.","Manhole Type D3. Depth :- - Over 1.5 m and not exceeding 2,5 m",1]
[4,"PH.8.2","no.","Manhole type S1. Depth :- - Over 0,0 m and not exceeding 1,5 m",1]
[5,"PH.8.2","no.","Manhole type S1. Depth :- - Over 0,0 m and not exceeding 1,5 m",1]

{"sheet":"PAGE 8-8","index":8,"n_rows":24,"n_cols":15,"rows_kept":24,"merged":[[6,0,6,4],[15,0,15,4],[23,0,23,4]]}
["1R-25439"]
["Upgrade of Zakwe Place and surrounding Lanes, in Ward 17"]
[]
["Continued","PART","PH","MANHOLES AND APPARTENANT DRAINAGE WORKS"]
[]
[6,"PH.8.5.3/PS.PH.3","m2","230 mm brickwork to new manhole or repairs",3]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","TA","ROAD SIGNS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"TA.8.1","no.","Supply and erect road sign boards, area not exceeding 2m2",3]
[2,"TA.8.4","m3","Concrete grade 20/19 for road sign footings",1.5]
[3,"TA.8.2","m","Supply and erect 75mm x 75mm square hot dipped galvanised steel supports. Rate to include all haulage.",3,{"$nulls":9},11]
[4,"TA.8.3","m3","Excavate and backfill for road sign supports",3]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]
[]
[null,"PART","TB","ROAD MARKINGS"]
[]
["Item No","Clause","Unit","Long Description","Scheduled Qty","Rate","Total"]
[1,"TB.8.1.1","m","Painted road lines (THERMO PLASTIC) 150mm wide (white), including setting out and premarking.",340]
[2,"TB.8.1.1","m","Painted road lines (THERMO PLASTIC) 300mm wide (white), including setting out and premarking.",25]
[3,"TB.8.1.2","m2","Road Marking (THERMO PLASIC) for lettering, symbols and traffic islands (white), including setting out lettering, symbols and traffic island markings",1]
["TOTAL CARRIED TO SECTION 2 SUMMARY: ZAKWE PLACE AND SURROUNDING LANES - WARD 17",{"$nulls":4},"R"]