{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":166,"n_cols":6,"rows_kept":166,"cut":false,"hidden":false,"merged":[[108,2,108,4],[161,2,161,4],[59,0,60,0],[59,1,60,1],[59,2,60,2],[59,3,60,3],[59,4,60,4],[59,5,60,5],[51,5,53,5],[56,0,58,0],[56,1,58,1],[56,2,58,2],[56,3,58,3],[56,4,58,4],[56,5,58,5],[0,0,0,3],[1,0,1,3],[20,2,20,4],[51,0,53,0],[51,1,53,1],[51,2,53,2],[51,3,53,3],[51,4,53,4]]}
[" Bill of Quantities"]
["Lot 2- A Garden in Dumbutu (LRR) and Boraba (CRR-S)"]
["Item","Description","Unit","Quantity","Unit Rate   GMD","Amount      GMD"]
[1,"General items"]
[1.1000000000000001,"Mobilization of equipment, personel and construction materials including drilling rig, pumping test equipment, well installation and errection facilities (pumps, generators, pipes troughs, building materials …etc). The item is inclusive of site clearing and levelling.","LS",1]
[1.2,"Demobilization of equipment and personnel from site including cleaning the site from debris and reinstatement to it's original condition","LS",1]
[null,"Total Bill No 1 -  General Items"]
[]
[2,"Borehole Drilling and Installation"]
["2.1","Borehole Drilling"]
["2.1.1","Drilling of standard boreholes of 6\" diameter from 0 meter to the water depth estimated to be 60m (depths vary per site).","ml",60]
["2.1.2","Supply and install 6\" diameter standard UPVC casing covering 70% of the drilled depth. ","ml",45]
["2.1.3","Supply and install 6\" diameter standard UPVC screen covering  30% of the drilled depth. ","ml",15]
["2.1.4","Supply and insert filter gravel packing( 2mm to 4mm size) 1000mm above the screen .","LS",1]
["2.1.5","Provide  a 0.5m x 0.5 m  concrete around well to 0.3m depth from ground level","m3",0.75]
["2.1.6","Borehole development work ","LS",1]
["2.1.7","Recovery and test pumping constant discharge including installation and removal of test pumping equipment (draw down and recovery measurement)","LS",1]
["2.1.8","Collection and testing of water sample for chemical and bacteriological analysis ","LS",1]
["2.1.9","End cap and well protection","LS",1]
[]
[null,"Total cost for a unit Borehole"]
[]
[null,"Total Bill No 2- Borehole drilling","No",2]
[]
[3,"Supply and installation of Solar water Pumping System"]
[]
[3.1,"The  solar modules should be in weather proof glass enclosure rated between  300 - 350Wp inclined at 15%  to the horizontal incorporating water proof connection boxes  and connecting cable glands  with anti -theft fixings and the whole assembly able to withstand wind speed of 150km/hr and with easy access for maintenanance "]
["3.1.2","The Solar  module must be able to provide enough power to pump a minimum flow rate of 8m3/h at a 40m head. Cost to include solar panels, support structures, cables and all other required accessories","LS",2]
[3.2,"Install submersible centrifugal  or helical rotor pump to fit 6\" cased borehole  and constructed in stainless steel with non return valve  pressure of 2 bars fitted with easily removable riser pipe with portable water grade internal surface with HDPE fittings at pump outlet .The pump should be able to provide 8m3/h at 40m head","No",2]
[]
[null," Total Bill No 3 -  Solar water pumping system"]
[]
[4,"Supply of water storage tanks"]
[4.0999999999999996,"Plastic cylindrical tank with potable water grade inner liner, with inlet, outlet, overflow and wash-out connections .The whole tank to be set on 5m high elevated hot-dipped galvanised steel tower and secured to reinforced concrete foundations . The cost to include the tank , foundation and the required pipe works."]
[4.2,"Cost for the supply and installation of a three layered plastic tank of  5m3  capacity ","No",3]
[4.3,"Install a galvanised steel tower  5m high  with one meter high enclosure to protect the tanks (each of 5m3 capacity) . The platform should be acesible with a ladder and supported by bracings and anchored to the ground in a  80cm depth of concrete foundation.","No",2]
[4.4000000000000004,"Construct a 1.5m x 1.5m x 0.7m deep ground concrete reservoirs. The reservoirs must be reinforced with 8mm rod with concrete thickness of 10cm.The interior must be waterproofed to prevent leakages","No",28]
[]
[null,"Total Bill No 4 - Water storage tanks"]
[]
[5,"Water Distribution system"]
[5.0999999999999996,"Excavation and backfilling of excavations for all types of soil for pipes up to Ø 63 including supply and installation of a compacted sand bed (15 cm) including  evacuation of water and all other conditions. The price should include all the necessary fittings from the tank outlet to the end of the distribution system"]
[5.2,"Supply and Install PVC pressure pipes (PN 6) Ø 63","ml",{"$f":"112+110","v":222}]
[5.3,"Supply and Install PVC pressure pipes (PN 6) Ø 50","ml",{"$f":"675+575","v":1250}]
[5.4,"Installation of galvanised steel tap stands with two taps 3/4'' to supply water to the  ground concrete reservoirs","No",{"$f":"16+12","v":28}]
[5.5,"Supply of 3/4' hosepipes (50 m roll)","No",10]
[null,"Total Bill No 5 - Water distribution system"]
[]
[6,"Chain-link Fencing"]
[6.1,"The chain-link to be supplied and installed shall be composed of 2-metre galvanized or PVC/LLDPE-coated galvanised steel (BS 1722-1:2006 or equivalent) with 50x50 mm mesh and minimum wire diameter of 3.8mm. The fencing is to be installed on a concrete plinth and supported by posts of galvanised steel (or other corrosion-resistant material) encased in the plinth. A maximum spacing of 3000mm is to be allowed between posts. Posts must be braced on both sides at 15m intervals together with all corner posts."]
[6.2,"Excavate 300mm X 400mm deep for the post foundation","m3",{"$f":"20+19","v":39}]
[6.3,"Excavate trenches  for strip foundation to support plinth  depth not exceeding 200mm.","m3",{"$f":"15+14","v":29}]
[]
[]
[6.4,"Concrete for the supporting post foundation","m3",{"$f":"13+13","v":26}]
[6.5,"Concrete for the plinth supporting the chain link wire","m3",{"$f":"20+19","v":39}]
[6.6,"Supply and install on plinth, complete fencing comprising chain- link fabric, supporting and corner posts, tensioning wire, tensioners and all other accessories as required","m",{"$f":"488+470","v":958}]
[]
[]
[6.7,"Supply & install supporting posts, angle supports in galvanised steel to receive chain link. ","No",{"$f":"163+157","v":320}]
[]
[]
[null,"Total Bill No 6 - Chain-link fencing"]
[]
[7,"Garden Toilets"]
[7.1,"Site clearance"]
[null,"Clear all shrubs weeds, root bulbs  and debris from site","m2",{"$f":"2.5*2.6","v":6.5}]
[7.2,"Excavation"]
[null,"2600 x 2500 x 2500mm depth","m3",{"$f":"2.6*2.5*2.5","v":16.25}]
[null,"Surface treatments with anti- termite ","m2",{"$f":"2.6*2.5","v":6.5}]
[7.3,"Re-inforcement"]
[null,"6mm stirup to columns","ml",{"$f":"(6/0.2)*0.6*6","v":108}]
[null,"10mm, columns","ml",{"$f":"(5.5*4)*6","v":132}]
[null,"10mm ground beam","ml",{"$f":"13*4","v":52}]
[null,"6mm stirup to ground beam","ml",{"$f":"(52/0.2)*0.8","v":208}]
[null,"Mesh fabric, 10mm, 150mm both ways to floor slab","ml",90]
[7.4,"Formwork"]
[null,"Soffit of slab, left in","m2",{"$f":"2.6*2.5","v":6.5}]
[null,"to edges of slab","m2",{"$f":"13*0.15","v":1.95}]
[null,"Ground beam","m2",{"$f":"13*0.15*2","v":3.9}]
[null,"to columns","m2",{"$f":"6*0.15*2","v":1.7999999999999998}]
[7.5,"Concrete"]
[null,"Plain in-situ concrete: 20n/mm2; 20mm laterite aggregate size"]
[null,"Foundations base; 150mm thick","m3",{"$f":"2.6*2.5*0.15","v":0.97499999999999998}]
[null,"Columns","m3",{"$f":"(0.15*0.15*5.5)*6","v":0.74249999999999994}]
[null,"Ground beam","m3",{"$f":"(13*0.15*0.2)","v":0.39}]
[7.6,"Masonry"]
[null,"Cement sand blocks; hollow; 2.5N/mm2; cement  wall of  150mm thick","m2",{"$f":"15.4*5.5","v":84.7}]
[7.7,"Wall finishes"]
[null,"Render: Cement - sand (1:4 mix)to new wall 12mm thick to walls","m2",{"$f":"D88*2","v":169.4}]
[7.8,"Roof"]
[null,"50 x 75mm red wood trussess at 800mm spacing anchored on the walls","m",12]
[null,"50 X50 mm red wood timber purlins at 600mm spacing","m",12]
[null,"Aluzinc profile (0.5mm gauge) roofing sheets properly bolted as recommended","m2",{"$f":"(2.5*2.6)*1.1","v":7.15}]
[null,"Barge boards, 100 x 100mm ","m",11]
[7.9,"Doors"]
[null,"Fabricated steel door, comprising 25 x 25 x 1.5mm SHS frame with 10 x 10mm ","No",2]
[null,"SHS jamb, 1.5mm steel plate welded to 25 x 25mm midframes Barrel bolt lock"]
[null,"Prime with red oxide before fixing and paint 2 coats after installation"]
[7.1,"Window"]
[null,"600 x 600 mm openings covered with galvanised mesh","No",2]
[7.11,"Painting and decoration"]
[null,"Prepare, prime and paint 2 finish coats to rendered walls","m2",{"$f":"(15.4*3)*2","v":92.4}]
[7.12,"Floor finishes"]
[null,"Basaltic screed laid on concrete, 40mm (1: 1 1/2 : 3 mix)","m2",{"$f":"2.6*2.5","v":6.5}]
[7.13,"Fitting and fixtures"]
[null,"110 diameter vent pipe fix to wall with proprietary strap (2 Nr)","m",4]
[]
[null,"Total cost for a unit Garden Toilet"]
[]
[null,"Total Bill No 7 - Garden Toilets","No",2]
[]
[8,"Farm rest area & Storage"]
[]
[8.1,"Site clearance"]
[null,"Clear all shrubs weeds, root bulbs  and debris from site","m2",{"$f":"7*10","v":70}]
[8.1999999999999993,"Excavation"]
[null,"Strip foundation of 600 x 900 x 6000mm depth","m3",{"$f":"36*0.6*0.6","v":12.959999999999999}]
[null,"Surface treatments with anti- termite ","m2",{"$f":"9*6","v":54}]
[null,"Harcore Compaction","m3",{"$f":"9*6*0.3","v":16.2}]
[8.3000000000000007,"Re-inforcement"]
[null,"6mm stirup to columns","ml",{"$f":"(4/0.2)*0.6*12","v":144}]
[null,"12 mm, columns","ml",{"$f":"4*4*12","v":192}]
[null,"10mm ground beam","ml",{"$f":"36*4","v":144}]
[null,"6mm ground beam","ml",{"$f":"(36/0.2)*0.9","v":162}]
[null,"10mm to lintel","ml",{"$f":"18*4","v":72}]
[null,"10mm to ring beam","ml",{"$f":"D124","v":144}]
[null,"Mesh fabric, 6mm, 150mm both ways to floor slab","ml",756]
[8.4,"Formwork"]
[null,"to ground beams","m2",{"$f":"(36*0.3)*2","v":21.599999999999998}]
[null,"to colums","m2",{"$f":"0.6*4*12","v":28.799999999999997}]
[null,"to ring beam","m2",{"$f":"18*0.2*2","v":7.2}]
[null,"to lintel","m2",{"$f":"18*0.2*2","v":7.2}]
[8.5,"Concrete"]
[null,"Plain in-situ concrete: 20n/mm2; 20mm laterite aggregate size"]
[null,"Strip Foundations","m3",{"$f":"36*0.2*0.2","v":1.4400000000000002}]
[null,"Columns","m3",{"$f":"4*0.15*0.15*12","v":1.08}]
[null,"Ground beam","m3",{"$f":"36*0.3*0.15","v":1.6199999999999999}]
[null,"lintel","m3",{"$f":"18*0.2*0.15","v":0.54}]
[null,"Ring beam","m3",{"$f":"D138","v":1.6199999999999999}]
[8.6,"Masonry"]
[null,"Cement sand blocks; hollow; 2.5N/mm2; cement  wall of  150mm thick","m2",{"$f":"(18*4)+(18*1.5)+(2*1.5*1.2)*2","v":106.2}]
[8.6999999999999993,"Roof"]
[null,"50 x 75mm red wood trussess at 1500mm spacing anchored on the walls","No",3]
[null,"50 X50 mm red wood timber purlins at 600mm spacing","m",100]
[null,"Aluzinc profile (0.5mm gauge) roofing sheets properly bolted","m2",{"$f":"32*2","v":64}]
[null,"Barge boards, 100 x 100mm ","m",33]
[8.8000000000000007,"Doors"]
[null,"Fabricated steel door, comprising 25 x 25 x 1.5mm SHS frame","No",1]
[null,"with 10 x 10mm SHS jamb, 1.5mm steel plate welded to 25 x25mm midframes"]
[null,"Barrel bolt lock and eyes for padlock lock."]
[null,"Prime with red oxide before fixing and paint 2 coats after installation"]
[8.9,"Windows"]
[null,"600 x 600 mm openings covered with galvanised mesh","No",1]
[8.1,"Wall Finishes"]
[null,"Render: Cement-sand (1:4 mix)  to new wall","m2",{"$f":"(18*3)*2 +(15*1.2)*2","v":144}]
[8.11,"Painting and decorations"]
[null,"Prepare, prime and paint 2 finish coats to rendered walls","m2",{"$f":"D156","v":144}]
[8.1199999999999992,"Floor Finishes"]
[null,"Basaltic screed laid on concrete, 40mm (1: 1 1/2 : 3 mix)","m2",{"$f":"9*6","v":54}]
[]
[null,"Total cost for a Unit Farm rest house and Storage"]
[]
[null,"Bill No 8 - Total for Farm rest house and storage","No",2]
[]
[null,"Total cost for the entire works"]