{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":57,"n_cols":7,"rows_kept":57,"merged":[[1,0,1,6],[17,7,30,9],[40,7,41,9],[45,7,45,9]]}
[]
["Bill of Quantities for Appointment of a Contractor(s) for the installation of soil nails (Ground anchors) and Terramesh wall at Tzaneen dam raising project for the Department of Water and sanitation"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","  RATE","AMOUNT"]
["NO","REFERS"]
[]
[]
[2,"COTO","SOIL NAIL WALL"]
[null,"C12.2 ","GROUND ANCHORS"]
[]
[2.1,"C12.2.13","Establishment on the site for drilling of soil nails/rockbolts","Sum",1,null,{"$f":"E11*F11","v":{"v":0,"d":"  0.00"}}]
[]
[2.2,"C12.2.14","Move to and set up at each soil nail/rockbolt position","No",864,null,{"$f":"E13*F13","v":{"v":0,"d":"  0.00"}}]
[]
[2.3,"C12.2.15","Install, grout and protect soil nails or rock bolts","No",864,null,{"v":0,"d":"  0.00"}]
[]
[2.4,"C12.2.15.1","25 mm dia. TB500 (with corrugated sheating) soil nails/rock bolts"]
["2.4.1",null,"i) 18 m long","No",{"$f":"352+398","v":750},null,{"v":0,"d":"  0.00"}]
["2.4.2",null,"ii) 17.5 m long","No",9,null,{"v":0,"d":"  0.00"}]
["2.4.3",null,"iii) 14.4 m long","No",21,null,{"v":0,"d":"  0.00"}]
["2.4.4",null,"iv) 11.5 m long","No",16,null,{"v":0,"d":"  0.00"}]
["2.4.5",null,"v) 8.6 m long","No",40,null,{"v":0,"d":"  0.00"}]
["2.4.6",null,"vi) 5.75 m long","No",28,null,{"v":0,"d":"  0.00"}]
[]
[2.5,"C12.2.15.2","R32N Self-drilling anchors (zinc coated), 90 mm dia. drill bit (type to be determined by contractor),  grouted (30 MPa) whilst drilling:"]
["2.5.1",null,"i) 18 m long","No",750,"Rate Only"]
["2.5.2",null,"ii) 17.5 m long","No",9,"Rate Only"]
["2.5.3",null,"iii) 14.4 m long","No",21,"Rate Only"]
["2.5.4",null,"iv) 11.5 m long","No",16,"Rate Only"]
["2.5.5",null,"v) 8.6 m long","No",40,"Rate Only"]
["2.5.6",null,"vi) 5.75 m long","No",28,"Rate Only"]
[]
[2.6,"C12.5.1","Establishment on site for shotcrete","Sum",1,null,{"v":0,"d":"  0.00"}]
[]
[2.7,"C12.5.2","Surface preparation for shotcreting","m2",1300,null,{"$f":"E35*F35","v":{"v":0,"d":"  0.00"}}]
[]
[2.8,"C12.5.3","Supply and installation of reinforcement:"]
["2.8.1","C12.5.3.1","Welded steel mesh fabric (Ref.395, black)","m2",1300,null,{"v":0,"d":"  0.00"}]
[]
[2.9,"C12.5.4","Shotcrete (150 mm thick 25 MPa):"]
["2.9.1","C12.5.4.1","Flash / base coat (unreinforced) (50 mm)","m2",1300,null,{"v":0,"d":"  0.00"}]
["2.9.2","C12.5.4.3","Final coat (100mm thick, undisturbed nozzle finish)","m2",1300,null,{"v":0,"d":"  0.00"}]
[]
["2.10","C12.5.4.4","Dental shotcrete (as instructed by the Engineer)","m3",50,null,{"v":0,"d":"  0.00"}]
[]
[2.11,"C12.5.5","Removal to spoil of material trimmed from slope","m3.km",650,null,{"v":0,"d":"  0.00"}]
[]
[2.12,"C12.5.8","Geocomposite / geosynthetic drain as specified","m",3550,null,{"v":0,"d":"  0.00"}]
[]
[null,null,"Lateral Support Work must be done in accordance with SAICE’s Lateral Support in Surface Excavations Code of Practice (1989) and COTO (2020)."]
[]
[]
["TOTAL",{"$nulls":4}," ",{"$f":"SUM(G11:G50)","v":{"v":0,"d":"R0.00"}}]
["CONTEGENCIES @10%",{"$nulls":4}," ",{"$f":"G53*0.1","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":6},{"$f":"SUM(G53:G54)","v":{"v":0,"d":"R0.00"}}]
["VAT @15%",{"$nulls":5},{"$f":"G55*0.15","v":{"v":0,"d":"R0.00"}}]
["GRAND TOTAL",{"$nulls":5},{"$f":"SUM(G55:G56)","v":{"v":0,"d":"R0.00"}}]