{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["MAMFE COUNCIL"],"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":"MAMFE COUNCIL","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,0,28,4],[1,0,1,5],[24,1,24,4],[25,1,25,4],[26,1,26,4],[3,1,3,3],[6,1,6,2],[7,1,7,4],[27,1,27,4],[17,1,17,3],[23,1,23,3]]}
[]
["BILL OF QUANTITIES FOR THE CONSTRUCTION OF  AN EQUIPPED BOREHOLE WITH A SOLAR PUMPING SYSTEM, WATER TOWER AND STAND TAPS AT PREVENTIVE HOSPITAL MAMFE, MAMFE COUNCIL AREA"]
["N0","DESCRIPTION OF WORKS","UNIT","QTS","UNIT PRICE","TOTAL COST"]
["Lot 100","SITE INSTALLATION AND PRELIMINARY WORKS"]
[101,"Site installation, Site clearance and logistic (transportation to and from of personnel and equipment","ff",1,null,{"$f":"E5*D5","v":0}]
[102,"Studies execution plans, detailing and drilling report, training of mangement commitee team and supply of a tool box","ff",1,null,{"$f":"E6*D6","v":0}]
[null,"SUB TOTAL LOT 100",null,null,null,{"$f":"SUM(F5:F6)","v":0}]
["LOT 200","REALIZATION OF A SOLAR POWER BORE HOLE AND A WATER TOWER"]
["200.1","Reinforced concrete for the construction of a storage tower 3.10x3.10  with a height of 9m roof inclusive and control room having a metalic door of 100x210cm with ventilation spaces at the top edge.","ff",10,null,{"$f":"E9*D9","v":0}]
["200.2","Supply and installation of two 5m3 black P V C water  tank with all accessories","u",2,null,{"$f":"E10*D10","v":0}]
["200.3","Geophysical studies and report.","ff",1,null,0]
["200.4","drilling; piping of the entire height, Cleaning and Development of the borehole by the air-lift method and connection to the water tower(panaflex PVC D 32 NP10), Filling with gravel materials.","ff",1,null,0]
["200.5","Pumping and Recharge  test [Aquifer test] and report","ff",1,null,0]
["200.6","supply and installation of a Solar power pump with a flow rate of 5m3/h max head= 100m including solar pannel with bateries(250 AMP, 5 KVA with a hybrid invertor )and metallic mounting frame support for the solar panel with protective system.","ff",1,null,0]
["200.7","water quality testing(Sampling and physico-chemical  Analysis of water from the borehole), treatment and dysinfection, and connection to the water tank ","ff",1,null,0]
["200.11","Roofing of the water tower","ff",1,null,0]
["200.12","Installation of a metallic ladder on the tower and  metallic rails round the slab carrying the tanks ","ff",1,null,0]
[null,"SUB TOTAL LOT 200",null,null,null,{"$f":"SUM(F9:F17)","v":0}]
["LOT 300","PIPELINE AND CONSTRUCTION OF STAND TAPS/VALVE CHAMBERS"]
[301,"excavation and backfilling of pipeline 0,3x0,7 with roasted signals","Ml",300,null,{"$f":"E20*D20","v":0}]
[302,"supply and installation of panaflex pvc D40 NP10 with accessories","ml",300,null,{"$f":"E21*D21","v":0}]
[303,"construction of  stand taps with soakaway pit and control chambers","U",3,null,{"$f":"E22*D22","v":0}]
[304,"construction of  a bore hole chamber and a concrete cover of 60x60cm","u",1,null,{"$f":"E23*D23","v":0}]
[null,"SUB TOTAL LOT 300",null,null,null,{"$f":"SUM(F20:F23)","v":0}]
["LOT","DESCRIPTION"]
["LOT 100","SITE INSTALLATION AND PRELIMINARY WORKS",null,null,null,{"$f":"F7","v":0}]
["LOT 200","REALIZATION OF A SOLAR POWERED BOREHOLE AND A WATER TOWER",null,null,null,{"$f":"F18","v":0}]
["LOT 300","PIPELINE AND CONSTRUCTION OF STAND TAPS/VALVE CHAMBERS",null,null,null,{"$f":"F24","v":0}]
["TOTAL COST ",{"$nulls":4},{"$f":"SUM(F26:F28)","v":0}]