{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Cover","Demolitions","Storage tanks & reticulation","Millers shed","Perimeter wall","Summary"],"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":"Cover","index":0,"n_rows":16,"n_cols":1,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["BILL OF QUANTITIES"]
[]
["FOR"]
[]
["THE PROPOSED LILANDA MARKET WATER RETICULATION SYSTEM"]
[]
["FOR"]
["THE UNITED NATIONS DEVELOPMENT PROGRAMME"]
[]
[]
["ON PLOT No. 20842, ALICK NKATA ROAD, LONG ACRES, LUSAKA."]

{"sheet":"Demolitions","index":1,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"LILANDA MARKET WATER RETICULATION SYSTEM"]
[]
[null,"Preamble"]
[]
[null,"The Contractor is required to verify on site all measurements  "]
[null,"of the drawings which are part of the tender."]
[]
[null,"All reference levels and measurements for all building works "]
[null,"should be verified and agreed with  UNDP Engineer before commencement of works"]
[]
[null,"All items are provisonal and subject to"]
[null,"re-measurement on site"]
[]
[]
[1,"Demolitions"]
[null,"The contractor shall take all due care to provide shoring, needling, strutting and all temporary works necessary for supporting the existing structure in the course of demolitions and construction until it becomes self supporting  All debris should be removed from site as soon as possible to an approved tipping location and levelled and made environmentally safe. The contractor shall load and transport demolished materials to an authorized disposal site."]
[]
["A","Carefully demolish millers shed approximately 15 square meters, including grubbing up foundations and make good all disturbed works.","item",1,null,{"$f":"D19*E19","v":0}]
[]
["B","Carefully demolish cracked perimeter wall approximately 18 square meters, including grubbing up foundations and make good all disturbed works.","item",1,null,{"$f":"D21*E21","v":0}]
[]
[]
[null,"TOTAL CARRIED TO SUMMARY",null,null,{"$f":"SUM(E2:E23)","v":0},{"$f":"SUM(F2:F23)","v":0}]

{"sheet":"Storage tanks & reticulation","index":2,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"LILANDA MARKET WATER RETICULATION SYSTEM"]
[]
[null,"Preamble"]
[]
[null,"The Contractor is required to verify on site all measurements  "]
[null,"of the drawings which are part of the tender."]
[]
[null,"All reference levels and measurements for all building works "]
[null,"should be verified and agreed with  UNDP Engineer before commencement of works."]
[]
[null,"All items are provisonal and subject to"]
[null,"re-measurement on site."]
[]
[]
[1,"Supply & install uPVC storage tanks, steel tank stand & inlet and outlet pipes"]
[]
["A","Supply & construct 6m high steel tank, with carrying capacity of 10.5 tonnes, preferably with IPE 160*82*12kg/m for the columns and beams, 150*50 for the tank base or Timber, 80*80*8mm stiffeners and 50*50*6mm for the brasses. Class 25 concrete bases as per Engineer's drawing.","Item",1]
[]
["B","Supply and installation of uPVC Tank 5,000 litres equipped wth automated floating switch. The ground tank shall sit onto a reinforced concrete base.","Nr",1]
[]
["C","Supply and installation of uPVC Tank 10,000 litres equipped wth automated floating switch. The shall sit onto steel plate, with expanded wire fixed on the walk way around the tank.","Nr",1]
[]
["D","Trenching, supply & laying DN32mm HDPE discharge from the water source to the installed ground tank, elavated tank & DN50mm uPVC distribution pipeline complete with all connecting fittings to be backfilled with excavated material, not exceeding 300m length. ","m",270]
[]
["D","Allow for hardrock trenching along distribution pipeline","m",250]
[]
[null,"Supply and install 3/4'' lockable garden G.I stand taps complete with all connecting fittings, mounted in 150x150mm x200mm deep concrete bases, to be connected from the distribution line.","Nr",6]
[]
[]
[2,"Ground tank base & steel cage"]
[null,"Reinforced concrete slab"]
["A","Scarify and compact surface to receive new concrete","m²",2]
[]
["B","Supply and cast 2600x2600mm 150mm depth Class 25 concrete slab, reinforced with conforce 87 wire.","m²",2]
[]
["C","Supply of booster pump with discharge and suction fittings, Q=5m3/hr and H= 30m, single phase pump, the accessories should include anti dry run protection, pump control panel and float switches incorporated in the both bottom and overhead tank, inclusive of all electrical supply power connections from the supply point","item",1]
[]
[null,"Steel cage"]
["D","Fabricate steel cage (2500x2500mm) for uPVC ground storage tank using glvanised steel woven mesh ≈11mm hole size, fixed to 50x50x8mm Right Square Angle frame bolted to concrete slab. Complete with steel framed gate with heavy duty lock.","item",1]
[]
["E","IBR (0.5mm) roof sheeting and fixed to steel cage according to manufacture's instructions/ measured net - with allowance for laps  including all labours to roofing sheets, galvanised serrated ridge closures and galvanised serrated eaves closures.","m²",8]
[]
[null,"TOTAL CARRIED TO SUMMARY",null,null,{"$f":"SUM(E22:E46)","v":0},{"$f":"SUM(F22:F44)","v":0}]

{"sheet":"Millers shed","index":3,"n_rows":87,"n_cols":6,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"LILANDA MARKET WATER RETICULATION SYSTEM"]
[]
[null,"Preamble"]
[]
[null,"The Contractor is required to verify on site all measurements  "]
[null,"of the drawings which are part of the tender."]
[]
[null,"All reference levels and measurements for all building works "]
[null,"should be verified and agreed with  UNDP Engineer before commencement of works"]
[]
[null,"All items are provisonal and subject to"]
[null,"re-measurement on site"]
[]
[]
[1,"Substructure"]
[null,"The contractor shall take all due care to provide shoring, needling, strutting and all temporary works necessary for supporting the existing structures in the course of works"]
[null,"The contractor rate includes all necessary machinery and labour complete as instructed by engineer in charge including all lead and lift."]
[null,"Earth work excavation for foundations including all labour, shoring, strutting and dewatering wherever necessary transport, tools, tackles, equipment, fuel, etc., complete"]
[]
[null,"Excavations and Earthworks"]
["A","Excavate oversite average 150 mm deep to remove top soil and wheel spread and level on site where directed","m²",20]
[]
["B","Excavate for foundation trench exceeding 0.25 but not exceeding 1 metre and get out","m³",10]
[]
["C","Backfilling in layers not exceeding 100 mm thick around foundations with approved laterite or other approved materials.","m³",7.5]
[]
["D","Scarify and compact surface to receive new concrete","m²",9.5]
[]
[null,"Disposal "]
["E","Load and transport surplus excavated materials to an authorized  disposal site.","item",1]
[]
[null,"Termite Treatment "]
["F","Ant proofing as described to exposed surfaces of excavations, top of hardcore bed and foundation walls.","m²",35]
[]
["G","500 gauge polythene sheeting damp proof membrane laid on hardcore  with 150 mm side and end laps","m²",16]
[]
[]
[null,"Concrete works"]
["H","Reinforced concrete foundation strips, mm 600 wide, mm 200 deep as per specification and detailed drawings provided by the architect/ engineerProviding and laying plain cement concrete of mix 1:3:6 in volumetric proportions for levelling course in foundations all as per specification","m³",2]
[]
["I","Reinforced concrete slab, thickness 100 mm,","m³",2]
[]
[null,"Reinforcement in slab"]
["J","87 conforce wire mesh in concrete slab laid on damp proof membrane with 200mm side and end laps","m²",20]
[]
[null,"Blockwork in foundation"]
["K","Hollow concrete blockwork in cement mortar 1:3 as described, filled with and including class 15 mass concrete 200 mm Wall","m²",10]
[]
[]
[2,"Superstructure"]
[null,"Blockwork"]
["A","Supply and build with high quality hollow concrete blocks,3.50 KN/mm minimum crushing strength, nominal, normal weight,  thickness 200mm blocks walls finished with plaster according to the drawings, specification and to the supervision engineer instructions. Portland structural cement mortar ( Proportion Specification cement and sand 1:4)","m²",48]
[]
[null,"Concrete works"]
["B","Supply and install precast reinforced concrete linols to window and door.","Nr.",2]
[]
["C","Supply and install 200 mm x 200 mm Terra cotta air brick of  approved type with copper gauze backing and building into 200  mm wall and render around in cement mortar According to specifications and Engineer's instructions.","Nr",2]
[]
[null,"Steel reinforcement"]
["D","Blockforce reinforcement  every third to 200 mm wall in superstructure walls","m",80]
[]
[]
[3,"Roofing"]
["A","IBR (0.5mm) roof sheeting and fixed to 75x50x20x3mm lipped channel purlins @1200mm c/c according to manufacture's instructions/ measured net - with allowance for laps  including all labours to roofing sheets, galvanised serrated ridge closures and galvanised serrated eaves closures","m²",20]
[]
[]
[4,"Doors & windows"]
[null,"Doors"]
["A","Supply and install door size 800x1960x45 hung on buts to metal frame, complete with mortice lockset.","Nr",1]
[]
[null,"Windows"]
["B","Supply and install 1000x1200mm wide windows complete with steel frame, pegs, stays and 4mm glass panes- fixed in position using approved window putty.","Nr",1]
[]
[]
[5,"Electricals"]
[null,"CAS and IEE wiring rules shall be followed for all Electrical Installations."]
["A","Supply, deliver, install, connect and set to work the electrical fittings as specified or others of similar standard and performance specification approved by the Engineer."]
[]
["B","Supply and wiring for light points (interior light points) with  2Rx1.5sqmm 1.5sqmm ECC PVC insulated single core standard copper conductor cable (ZAMEFA) in 20mm PVC conduit surface run /concealed in ceiling, wall, column, floor, including supply and fixing of 6amps flush type modular(plate) control switches fixed in 3x3'' metal flush box; suitable flush mounted switches and all necessary components and earthing with 1Rx1.5sqmm insulated copper wire run inside the conduit including supply of all fixing materials,accessories,and interconnections complete as required and approved by the  Engineer.","Nr",1]
[]
["C","Supply and wiring for Power  points (Trunking mounted for Legrand pvc trunking 803 50x130mm) with  2Rx2.5sqmm 2.5sqmm insulated single core standard copper conductor cable in 20mm pvc conduitsurface run /concealed in ceiling, wall, column, floor, including supply and fixing of 13A Mosaic Double sockets with fixing materials, accessories and interconnections complete as required and approved by the Engineer.","Nr",2]
[]
["D","Supply and installation of Flourescent light fitting, complete with 2nr 36 watt cool white tubes complete with necessary ballast and all other accessories prewired. Light fitting as philips or as approved by the Engineer.","Nr",2]
[]
[]
[null,"TOTAL CARRIED TO SUMMARY",null,null,{"$f":"SUM(E2:E86)","v":0},{"$f":"SUM(F2:F86)","v":0}]

{"sheet":"Perimeter wall","index":4,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"LILANDA MARKET WATER RETICULATION SYSTEM"]
[]
[null,"Preamble"]
[]
[null,"The Contractor is required to verify on site all measurements  "]
[null,"of the drawings which are part of the tender."]
[]
[null,"All reference levels and measurements for all building works "]
[null,"should be verified and agreed with  UNDP Engineer before commencement of works"]
[]
[null,"All items are provisonal and subject to"]
[null,"re-measurement on site"]
[]
[1,"Brickwork- Perimeter Wall"]
["A","Excavate for foundation trench exceeding 0.25 but not exceeding 1.50 metres and get out","m³",7.5]
[]
["B","Backfilling in layers not exceeding 100 mm thick around foundations with approved laterite or other approved materials.","m³",4.8]
[]
["C","Scarify and compact surface to receive new concrete","m²",4.8]
[]
["D","Load and transport surplus excavated materials to an authorized  disposal site.","item",1]
[]
["E","Ant proofing as described to exposed surfaces of excavations, top of hardcore bed and foundation walls.","m²",30]
[]
["F","Reinforced concrete foundation strips, mm 600 wide, mm 200 deep as per specification and Engineer's drawing. Providing and laying plain cement concrete of mix 1:3:6 in volumetric proportions for levelling course in foundations all as per specification.","m³",1]
[]
["G","Supply and build with high quality hollow concrete blocks,3.50 KN/mm minimum crushing strength, nominal, normal weight,  thickness 200mm blocks walls finished with plaster according to the drawings, specification and to the supervision engineer instructions. Portland structural cement mortar ( Proportion Specification cement and sand 1:4)","m²",24]
[]
["H","Brickforce reinforcement  every third course to 200 mm wall in superstructure walls","m",27]
[]
[]
[null,"TOTAL CARRIED TO SUMMARY",null,null,{"$f":"SUM(E2:E32)","v":0},{"$f":"SUM(F2:F32)","v":0}]

{"sheet":"Summary","index":5,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[19,3,19,4],[22,3,22,4],[31,3,31,4],[0,1,0,2],[0,3,0,4],[8,3,8,4],[12,3,12,4],[16,3,16,4],[18,3,18,4]]}
["Item","Description",null,"Amount"]
[]
[null,"Summary"]
[]
[1,"Demolitions",null,null,{"$f":"Demolitions!F24","v":0}]
[2,"Storage tanks & reticulation",null,null,{"$f":"'Storage tanks & reticulation'!F46","v":0}]
[3,"Millers shed",null,null,{"$f":"'Millers shed'!F87","v":0}]
[4,"Perimeter wall",null,null,{"$f":"'Perimeter wall'!F33","v":0}]
{"$rows_empty":16}
[null,"NOTES"]
[1,"This Bill shall include for Material Cost, Labour, Transport, Mark-up and an allowance for waste."]
[]
[2,"Contractor to take all necessary precaution before commencement of works"]
[]
[]
[]
[null,"Total Cost ",null,{"$f":"SUM(D4:E30)","v":0}]
[]
[null,"Add P's n G's @     ",0.1,null,{"$f":"D32*10%","v":0}]
[]
[null,"Add Contingency Sum   @  10 %",null,null,{"$f":"(D32+E34)*10%","v":0}]
[]
[null,"GRAND TOTAL",null,null,{"$f":"SUM(D32:E36)","v":0}]