{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BOQ","Summary"],"read":"whole","date_system":"1900"}

{"sheet":"BOQ","index":0,"n_rows":238,"n_cols":7,"rows_kept":238}
[]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,1,"PRELIMINARY AND GENERAL"]
[null,"1,1","FIXED-CHARGE ITEMS"]
[null,"1.1.1","Contractual requirements","Sum","1,00"]
[null,null,"Provision of facilities on site:"]
[null,null,"1) Facilities for Engineer:"]
[null,null,"a) Engineers Office Type 2 and parking (No.=2)","Sum","1,00"]
[null,null,"b) Nameboards (No=2)","Sum","1,00"]
[null,null,"c) Communication","Prov Sum","1,00"]
[null,null,"d) Overhead profit on item above ","%",{"v":0.1,"d":"0"}]
[null,null,"e) Meeting room Type 1","Sum","1,00"]
[null,null,"f) Latrine facilities","Sum","1,00"]
[null,"1.1.2","2. Facilities for the contractor:"]
[null,null,"a) Offices and storage sheds","Sum","1,00"]
[null,null,"b) Ablution and latrine facilities","Sum","1,00"]
[null,null,"c) Tools and equipment","Sum","1,00"]
[null,null,"d) Access (See Sub Clause 5.8)","Sum","1,00"]
[null,null,"e) Plant","Sum","1,00"]
[null,null,"f) Water supplies and electric power","Sum","1,00"]
[null,null,"g) Dealing with water","Sum","1,00"]
[null,null,"OHS Act Obligations (Compilation of OHS Act file)","Sum","1,00"]
[null,null,"EMP Obligations","Sum","1,00"]
[null,"1.1.3","Removal of site Establishment","Sum","1,00"]
[]
[null,"1,2","TIME RELATED ITEMS"]
[null,"1,1,2","Contractual requirements","Month","18,00"]
[null,"1,2,2","Facilities for the Engineer"]
[null,null,"a) Engineers Office and parking (No.=2)","Month","18,00"]
[null,null,"b) Nameboards (No=2)","Month","18,00"]
[null,null,"c) Communication","Prov Sum","1,00"]
[null,null,"d) Overhead profit on item above","%",{"v":0.1,"d":"0"}]
[null,null,"e) Meeting room","Month","18,00"]
[null,null,"f) Latrine facilities","Month","18,00"]
[null,"1,2,3","Facilities for the Contractor"]
[null,null,"a) Offices and storage sheds","Month","18,00"]
[null,null,"b) Ablution and latrine facilities","Month","18,00"]
[null,null,"c)Tools and equipment","Month","18,00"]
[null,null,"d) Access (See Sub Clause 5.8)","Month","18,00"]
[null,null,"e) Plant","Month","18,00"]
[null,null,"f) Water supplies and electric power","Month","18,00"]
[null,null,"g) Dealing with water","Month","18,00"]
[null,null,"h) Supervision for the duration of construction","Month","18,00"]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"i) Company and head office overhead costs for the duration of the Contract","Month","18,00"]
[null,null,"j) Implementation and compliance with OHAS Acts","Month","18,00"]
[null,null,"k) Security Services","Month","18,00"]
[]
[null,"TOTAL CARRIED TO SUMMARY",{"$nulls":4},"R"]
[]
[null,2,"BOREHOLE CONSTRUCTION & REHABILITATION"]
[null,"2,1","BOREHOLE DRILLING"]
[null,null,"Establishment of Own Facilities to Site"]
[null,"2,1,1","Mobilisation and set-up of plant to/at first borehole","Sum","1,00"]
[null,"2,1,2","Set-up of plant per boreholes (after first) up to 10km","No","1,00"]
[null,null,"Inter-hole moves"]
[null,"2,1,3","For distances exceeding 10 km","Km","30,00"]
[null,"2,1,4","De-establishment from site"]
[null,"2,1,5","0 to 500 km","Sum","1,00"]
[]
[null,"2,2","DRILLING (Unconsolidated and consolidated sediments,"]
[null,null," igneous, metamorphic and fractured carbonate rocks)"]
[null,null,"Rotary air percussion with foam – 0 to 150 m"]
[null,"2,2,1","165 mm diameter","m","900,00"]
[null,"2,2,2","203 mm diameter","m","900,00"]
[]
[null,"2,3","CASING (supplied, delivered and installed)"]
[null,null,"(steel bevel-edged plain) "]
[null,"2,3,1","165 mm ID (minimum wall thickness 4 mm)","m"]
[null,"2,3,2","215 mm ID (minimum wall thickness 4.5 mm)","m","900,00"]
[null,"2,3,3","254 mm ID (minimum wall thickness 4.5 mm)","m"]
[null,"2,3,4","BOREHOLE DISINFECTION (complete per borehole)","No","11,00"]
[null,"2,3,5","BOREHOLE PROTECTION (complete per borehole) (including concrete collar, sanitary seal and casing lid)","No","11,00"]
[null,"2,3,6","BOREHOLE MARKING (complete per borehole) ","No","11,00"]
[null,"2,3,7","DATA RECORDING AND REPORTING (complete per borehole)","No","11,00"]
[null,"2,3,8","Development of Borehole (also for blow yield)","Hr"]
[]
[null,"2,4","REHABILITATION"]
[null,null,"EQUIPMENT REMOVAL AND RE-INSTALLATION"]
[null,null,"Hand pump, Windmills, Motorized, installations 25 to"]
[null,null,"65mm pipes"]
[null,"2,4,1","Removal for 1st 100m depth","No","5,00"]
[null,"2,4,2","Removal from depths extra-over 100m","m"]
[null,"2,4,3","Re-installation to 100m depth","No"]
[null,"2,4,4","Re-installation to depths extra-over 100m","m"]
[null,null,"Motorized installations above 65mm pipes"]
[null,"2,4,5","Removal for 1st 100m depth","No","5,00"]
[null,"2,4,6","Removal from depths extra-over 100m","m"]
[null,"2,4,7","Re-installation to 100m depth","No"]
[null,"2,4,8","Re-installation to depths extra-over 100m","m"]
[null,null,"Bore head superstructure"]
[null,"2,4,9","Dismantling of superstructure","No","5,00"]
[]
[null,"ITEM","DECSRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"2,4,10","Re-assembly of superstructure","No"]
[null,"2,4,11","Remove windmill from borehole","No"]
[null,"2,4,12","Fit / install windmill back onto borehole","No"]
[]
[null,"2,5","BOREHOLE TEST PUMPING"]
[null,"2,5,1","Mobilisation and set-up of testing equipment to/at first borehole"]
[null,"2,5,2","0 to 500 km","Sum","1,00"]
[null,"2,5,3","500 to 1000 km","Sum"]
[null,"2,5,4","Greater than 1000 km","Sum"]
[null,null,"Set-up of equipment per boreholes (after first)","No","1,00"]
[null,null,"Inter-hole moves"]
[null,"2,5,5","For distances up to 10 km","No","9,00"]
[null,"2,5,6","For distances exceeding 10 km","Km"]
[null,null,"De-establishment from site"]
[null,"2,5,7","0 to 500 km","Sum","1,00"]
[null,"2,5,8","500 to 1000 km","Sum"]
[null,"2,5,9","Greater than 1000 km","Sum"]
[null,null,"TEST PUMPING –"]
[null,null,"Installation of Test Pump (depth up to 120m)"]
[null,"2,5,10","For yield up to 10 ℓ/s","No","13,00"]
[null,"2,5,11","For yield greater than 10 ℓ/s to max 25l/s","No"]
[null,"2,5,13","Step Test (24Hrs per borehole)","No"]
[null,"2,5,14","Constant Discharge","No","13,00"]
[null,"2,5,15","Calibration Test","No"]
[null,"2,5,16","Test Pumping Report","No","1,00"]
[null,"2,5,17","Water quality analysis (sampling and testing)","Sum","1,00"]
[]
[null,"2,6","BOREHOLE RISER PIPE"]
[null,"2,6,1","50mm diameter class HDPE PN12.5","m",4000]
[]
[null,"2,7","BOREHOLES PUMP HOUSE STRUCTURE"]
[null,"2,7,1","Pump-house complete as per drawing","no","3,00"]
[]
[null,"2,8","MECHANICAL EQUIPMENT"]
[null,"2,8,1","Treat plant scheme for a single rising main","no","3,00"]
[null,"2,8,2","Supply and Install pumps","no","11,00"]
[]
[null,"TOTAL CARRIED TO SUMMARY",{"$nulls":4},"R"]
[]
[null,3,"PIPE LINES"]
[null," 3,1 ","SITE CLEARANCE"]
[null," 3.1.1 ","Clear and grub(1.0 metre wide strip)"," m ","25 264"]
[null," 3.1.2 ","Remove topsoil to nominal depth of 150mm and stockpile and reinstate"," m3 ","3 789,60"]
[null,null,"Remove and grub large trees and tree "]
[null,null,"stumps of girth:"]
[null," 3.1.3 ","Over 1,0 m and up to and including "," no ","25,00"]
[null,null,"2,0 m"]
[null,"3.1.4","Over 2,0 m and up to and including","no","5,00"]
[null,null,"3,0 m"]
[null," 3.1.5 ","Transport materials and debris to","m³-km","200,00"]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,null,"unspecified site and dump (Provisional)"]
[]
[null," 3,2 ","EARTHWORKS "]
[null,null,"Excavate in all material for trenches and dispose of surplus material using labour intensive construction methods for the depths of:"]
[null," 3.2.1 ","a) Over 0,0m and up to 1,0m"," m ","25264,00"]
[null," 3.2.2 ","b) Over 1,0m and up to 2.0m","m","-"]
[null," 3.2.3 ","c) Over 2m","m","-"]
[null," 3.2.4 ","Extra over Item 3.1 for :"]
[null," 3.2.5 ","1) Intermediate excavation."," m³ ","5 625,00 "]
[null," 3.2.6 ","2) Hard rock excavation."," m³ ","1 200,00 "]
[null," ","Excavation Ancillaries"]
[null,null,"Compaction in road reserve"]
[null," 3.2.8 ","a) Additional compaction to 93% mod AASHTO density in road reserves"," m³ ","                   10,00 "]
[null,null,"Existing services that intersect or adjoin a pipe trench"]
[null,null,"a) Services that intersect a trench"]
[null,"3.2.9","i) Cables.","No.","10,00"]
[null,null,"b) Services that adjoin a trench"]
[null," 3.2.10 ","i) Cables.","m","100,00"]
[null,null,"b) Services that adjoin a trench"]
[null,"3.2.11 ","i) Cables."," m "]
[]
[null," 3,3 ","BEDDING (PIPES)"]
[null,null,"Provision of bedding from trench excavation"]
[null," 3.3.1 ","a) Selected granular material"," m³ ","3 000,00"]
[null," 3.3.2 ","b) Selected fill material"," m³ ","2 000,00"]
[null,null,"Provision of bedding imported from commercial sources "]
[null," 3.3.3 ","a) Selected fill material for blanket"," m³ ","1 756,00"]
[null," 3.3.4 ","b) Selected granular material "," m³ ","1 453,00"]
[null," 3.3.5 ","c) 19mm stones"," m³ ","-"]
[]
[null," 3,4"," MEDIUM PRESSURE PIPELINES"]
[null,null,"Supply, lay, bed (class B bedding), test and disinfect, backfill complete with victaulic couplings denso wrapped, high impact PVC-O, PN 25 pipes:"]
[null," 3.4.1 ","a).DN110"," m ","7 272,00"]
[null," 3.4.2 ","b).DN90"," m ","4 642,00"]
[null,null,"b).DN75"," m ","8 802,00"]
[null,null,"c) 50 mm hdpe"," m ","4 547,00"]
[null,null,"Extra-over for the supply, lay and bedding of specials couplings:"]
[null,null,"a) uPVC pipes"]
[null,null,"DN110"]
[null,"3.4.3","i) 11.5°","No","15,00"]
[null,"3.4.4","ii) 22.5°","No","18,00"]
[null,"3.4.5","iii) 45°","No","2,00"]
[null,"3.4.6","iv) 90°","No","2,00"]
[null,null,"DN90"]
[null,"3.4.7","i) 11.5°","No","7,00"]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"3.4.8","ii) 22.5°","No","6,00"]
[null,"3.4.9","iii) 45°","No","1,00"]
[null,"3.4.10","iv) 90°","No","2,00"]
[null,null,"DN75"]
[null,"3.4.11","i) 11.5°","No","16,00"]
[null,"3.4.12","ii) 22.5°","No","12,00"]
[null,"3.4.13","iii) 45°","No","4,00"]
[null,"3.4.14","iv) 90°","No","1,00"]
[null,"3.4.15","110 X 75 Reducer","No","4,00"]
[null,"3.4.16","110x 50 Reducer","No","6,00"]
[null,"3.4.17","75 x 50 Reducer","No","6,00"]
[null,"3.4.18","50x 50 Tee","No","4,00"]
[null,"3.4.19","75 Tee","No","4,00"]
[null,"3.4.20","110 Tee","No","4,00"]
[null,"3.4.21","110 end cap","No","5,00"]
[null,null,"Supply install isolation valves complete in a chamber"]
[null,"3.4.22","DN50","No","5,0"]
[null,"3.4.23","DN100","No","5,0"]
[null,"3.4.24","DN75","No","5,0"]
[null,null,"Supply install valves complete in a chamber"]
[null,"3.4.25","25 mm double orifice air value, complete in a chamber","No","6,00"]
[null,"3.4.26","Supply install no-return valves complete in a chamber","No","6,00"]
[null,"3.4.27","Supply install scour  valves complete in a chamber","No","6,00"]
[null,"3.4.28","Construct Standpipe Complete with fittings","No","21,00"]
[]
[null,"3,5","Sundry Items"]
[null,"3,5.1","i) Concrete Thrust blocks","Sum","1,00"]
[null,"3.5.2","iii Testing and commissioning","Sum","1,00"]
[null,"3.5.3","iii) Pipe line markers","Sum","1,00"]
[]
[null,"TOTAL CARRIED TO SUMMARY",{"$nulls":4},"R"]
[]
[null,4,"STORAGE TANKS"]
[null,"4,1","DESIGN,SUPPLY & INSTALL COMPLETE WITH FITTINGS"]
[null,"4.1.1","100 KL tank on 10m steel stand","No","1,00"]
[null,"4.1.2","64 KL tank on 10m steel stand","No","1,00"]
[null,"4.1.3","27 KL tank on 10m steel stand","No","1,00"]
[null,"4.1.4","60 000 litres on concrete , platform 500mm above ground","No","1,00"]
[]
[null,"4,2","REPAIR LEAKS, STEEL TANKS"]
[null,"4.2.1","Repair 144 000 litres ground steel panel tank","No","2,00"]
[null,"4.2.2","Repair 120 000 litres  on 18 meters stand","No","1,00"]
[]
[null,"4,2","SUNDRY"]
[null,"4.2.1","Testing & commissioning","sum","1,00"]
[]
[null,"TOTAL CARRIED TO SUMMARY",{"$nulls":4},"R"]

{"sheet":"Summary","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[1,1,1,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2]]}
[]
[]
[null,"ITEM","DESCRIPTION","AMOUNT"]
[]
[null,"Section 1","PRELIMINARY AND GENERAL"]
[]
[null,"Section 2","BOREHOLES CONSTRUCTION & REHABILITATION"]
[]
[null,"Section 3","PIPELINES"]
[]
[null,"Section 4","STORAGE TANKS"]
[]
[null,"Sub-Total"]
[]
[null,"Provisional sum: Allowance for Contingencies (6.85% of Sub-Total)"]
[]
[null,"Total Construction Cost"]
[]
[null,"Value Added Tax at 15%"]
[]
[null,"Tender Closing Amount"]