{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Amar Dalou Water Yard BoQ"],"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":"Amar Dalou Water Yard BoQ","index":0,"n_rows":117,"n_cols":6,"rows_kept":117,"cut":false,"hidden":false,"merged":[[51,1,51,3],[0,1,0,5],[7,0,11,0],[7,2,11,3],[13,1,13,3],[14,0,23,0],[14,2,22,3],[5,0,5,5],[25,1,25,3],[26,0,37,0],[26,2,37,3],[41,0,48,0],[41,2,48,3],[52,0,64,0],[52,2,65,3],[69,0,70,0],[69,2,70,2],[69,3,70,3],[88,1,88,3],[89,0,95,0],[89,2,94,3],[97,1,97,3],[69,5,70,5],[71,1,71,3],[72,0,77,0],[72,2,77,3],[79,1,79,3],[80,0,86,0],[80,2,85,3],[69,4,70,4]]}
[null,"Bills of Quantities for lot 3-Amar Dalou Water Yard"]
[null,"Project name: Construction of Water Yard in Amar Dalou"]
[null,"Project Location: Amar dalou Area -Gaisan Locality y-Blue Nile State",null,null,"Currency:"]
[null,"Subject: Technical Specifications and Bills of Quantities"]
[]
["Instruction to bidders: All Prices of items shall include Supplying, Installing, Connecting and testing unless otherwise indicated. The Contractor is required to have approved full coordinated workshop drawings before starting contract activities, the price shall also include all such works. Rates shall include all materials, workmanship testing and commissioning.\nThe Contractor should install, construct & erect all works according to drawings, specifications & Instructions of the Engineer.\nThe Workmanship and Material to be used shall, unless otherwise Specified, comply with the Latest Editions of the Requirements, Standards, Regulations, Recommendations, Code of Practice (BS, ASTM or Equivalent National requirements)."]
["Item #","Specifications","Quantity","Unit","Unit Price  ","Total Amount "]
[1,"Geophysical survey:","Technical Notes"]
[null,"Provision of the following works:"]
[null,"-          Conduction of geophysical survey in the area to check the availability of the underground water and inspecting the geological nature of the ground to make decision over the most appropriate drilling system."]
[null,"-          The contractor shall use the most appropriate technical system for curry out of the geophysical survey."]
[null,"The price inclusive preparation of geophysical survey report contains information on the best location (s) for drilling the borehole, soil type and means of drilling. "]
[1.1000000000000001,"Conduct geophysical survey for siting the appropriate location for drilling of the borehole and preparing the report.",1,"item",null,{"$f":"E13*C13","v":0}]
[null,"Subtotal for the Geophysical survey works (to be carried to summery below)",null,null,null,{"$f":"F13","v":0}]
[2,"Boreholes drilling works:","Technical Notes"]
[null,"Technical Notes"]
[null,"Unless otherwise stated rate  inclusive :"]
[null," Drilling a borehole of 6-8 inch diameter using the most appropriate drilling system."]
[null," Provision and installation of productive casing of steel casing pipe of 6 to 8 inch prepared with filtering. (final size shall be determined after bore hole drilling)"]
[null,"-          Developing the bore hole by airlift pumping and surging ,jetting and block surging or any better technical approved by the engineer"]
[null,"-          Conduct water pumping test for 6 hours and recovery test for 3 hours."]
[null,"-          Take samples in existence of the engineer and make water chemical test at reliable laboratory approved by National Water Corporation."]
[null,"-          Backfilling with gravel and grouting with plain concrete and closing the borehole properly."]
[null,"Prepare final bore hole report."]
[2.1,"Drilling a bore hole of 6-8 inch diameter to the specification mentioned above.",1,"Item ",null,{"$f":"E25*C25","v":0}]
[null,"Subtotal for the Bore hole drilling works (to be carried to summery below)",null,null,null,{"$f":"F25","v":0}]
[3,"Provision and installation  of dual system Submersible pump , , Solar system and the generator works:","Technical Notes"]
[null,"Technical notes:"]
[null,"Unless otherwise stated rate  inclusive :"]
[null,"-          Provide and installation of dual system (Solar/generator) operated submersible pump, multi-state, 3 phase, 240/415V, 50 Hz, all parts stainless steel."]
[null," The capacity of the pump at duty is to be within the range of 6-8 m3/hr but the actual size shall be determined  by the contractor after the pumping test (to be set according to the history of the area and finalized after borehole drilling)."]
[null,"-          Total head is 80 meter."]
[null,"  Price inclusive provision and installation of the galvanized steel pipes. The nominal borehole galvanized steel pipes shall be within the range of  2inch to 2.5 inch (the final size shall be determined after bore hole drilling and pumping test) inch of. "]
[null,"-          Price inclusive providing tools box with appropriate tools."]
[null," Price inclusive provision and installation of electrical 6mm2 cables, cable concealing, trenching, protection. Earthling and any other provision necessary for finishing good quality. Price inclusive as well the control panel with all standard accessories and protection requirements."]
[null," Complete set of solar panel total electrical output to cover the load of the two submercible pumps  but  should not be less than 6 KVA."]
[null,"Price incluisve   provision of materials and fabrication of steel stand for the solar pannel , concrete foundation . The solar pannel shall be attached and properly fixed to the steel stand in amaner to prevent removal."]
[null,"All the testing and commission works."]
[3.1,"Provison of materials and construction of Steel levevated tank with all accessries as per drawings and technical requirements in technical notes above mentioned. ",1,"Item ",null,{"$f":"E39*C39","v":0}]
[3.2,"Provision and installation of dual power operated submersible pumps with complete all accessries such as cables and connection to control panel.",1,"Item ",null,{"$f":"E40*C40","v":0}]
[3.3,"Provision and installation of  complete set of solar power system to cover the load of the  pumps with all standard accessries ,steel stands ,cables and control pannels and testing.",1,"Item ",null,{"$f":"E41*C41","v":0}]
[3.3,"Backup generator with Convertor: ","Technical Notes"]
[null," Provision and installation of 12 KVA generator (Perkins or equivalent quality) with all accessories."]
[null,"-          Electrical start, diesel engine, including batteries, non-sound proof, with anti-vibration mounting, voltage 240voltage, 3 phases, 1500 rpm, and water cooled, 50Hz in line with BS quality standards, fuel tank for 8 hour continuous operations, engine monitoring facilities, auto-shut in case of failure."]
[null,"-          Battery charger with meter."]
[null,"-          Warranty for year at least."]
[null,"-          Convertor for changing operating system from solar to generated power."]
[null,"-          Tool kits and extra 5 fuel filters. "]
[null,"-          The generator shall be used for operating the 2 submersible pumps of the water yard."]
["3.3.1","Provision of and installation of 12KVA generator to specifications above detailed. ",1,"Item ",null,{"$f":"E50*C50","v":0}]
["3.3.2","Provision and installation of electrical convertor to allow the usage of dual system solar and generator with all accessories. ",1,"Item",null,{"$f":"E51*C51","v":0}]
[null,"Subtotal for the Provision and installation  of dual system Submersible pump , , Solar system and the generator works: (to be carried to summery below)",null,null,null,{"$f":"SUM(F39:F51)","v":0}]
[4,"Elevated Tank and Distribution Points:","Technical Notes"]
[null,"Unless otherwise stated rate  inclusive :"]
[null,"Unless otherwise stated rate inclusive:"]
[null,"-          Provide materials, fabrication, assembling of steel elevated tank of 10,000 Galoon size with steel tower of 6-meter height to the drawings attached."]
[null,"-          Provide materials, labor, all fittings, trench digging and laying of all the inlet, outlet and the over flow pipe to the drawings attached."]
[]
[null,"-          Provide materials cast 10 cm depth plain under footing and the area enclosed by the great beam to the drawings with proper curing"]
[null,"-          Provide materials and cast reinforced concrete for footing, short columns and the great beam to the drawings attached with proper curing"]
[null,"-          All the steel works are to be painted with antirust and final painting coats"]
[null,"-          All the pipes and fittings are of stainless galvanized steel"]
[null," Supply materials such as 3-inch galvanized steel pipe and all other accessories and making cart water collection point to the drawings attached."]
[null,"  Rate inclusive as well the galvanized steel water pipe line from the boreholes to the water elevated tank as well as the water pipe line from the elevated tank to the water distributions point’s points."]
[null,"Rate inclusive  the galvanized steel inlet pipe from the bore hole to the elevataed tank and the outlet pipe line with all accessries and fittings."]
[null,"Provide materials, labor, all fittings, trench digging and laying water pipeand making carts water collections points .the carts water collection point should ve at least 40 meter from bore hole"]
[4.0999999999999996,"Provison of materials and connecting the   boreholes  with existing elevated tank as per drawings attached.",1,"item",null,{"$f":"E67*C67","v":0}]
[4.2,"Provision of materials and making Cart water collection point. Rate inclusive the galvanized steel pipe, valves, fixing the stand pipe with plain concrete and the 2-3 inch flexible pipe with fastening clamps.",1,"Item",null,{"$f":"E68*C68","v":0}]
[4.3,"Provision of materials and making Geri-can water collection point. Rate inclusive the 3 inch HDPE pipes  and 3 inch galvanized steel pipes for the stand, valves, water taps, provision of materials and constructing the taps stand as per drawings.The gerican collection points shall be placed 150 meter from each other.",3,"Item",null,{"$f":"E69*C69","v":0}]
[4.4000000000000004,"Animal Troughs:",2,"Item",null,{"$f":"E70*C70","v":0}]
[null,"Provision of materials and making animal troughs point and proper painting them with anti-rust paint and final oil painting. Rate inclusive the galvanized steel pipes, valves, water taps, the plain concrete base drawings."]
[null,"Subtotal for the Elevated Tank and Distribution Points (to be carried to summery below)",null,null,null,{"$f":"SUM(F67:F71)","v":0}]
[5,"Fence works:","Technical Notes"]
[null,"Technical notes:"]
[null,"Unless otherwise stated rate  inclusive :"]
[null,"-          Provider of all materials, labor and curing the cement works with water 3 times per day for at least three days"]
[null,"-          The fence shall be fabricated from  good thorny wire and 2 inch iron angle painted with antirust paints placed @ 2 meter c/c to the drawings attached"]
[null,"-           The plain concrete is 1:3:6 cement sand gravel mix."]
[5.0999999999999996,"Provide material and fabricate steel fence (20m*20m) with steel gate of 3meter*2 meter  to the drawings and specification attached.",80,"ml",null,{"$f":"E79*C79","v":0}]
[null,"Subtotal for the Fence Works (to be carried to summery below)",null,null,null,{"$f":"F79","v":0}]
[6,"Generator  Room:","Technical Notes"]
[null,"Technical notes:"]
[null,"Rate inclusive :"]
[null," Provide all materials, fabrication of steel Zink room of 4m*4m*3m from 4*8 box pipes ,steel Zink sheets to the drawings attached."]
[null,"-          Provide materials cast plain concrete 10 cm depth inside the room he drawings attached. Price inclusive curing with water"]
[null,"-          Provide materials and cast reinforced concrete 20 cm depth for the generator base "]
[null,"-          the room is to have one door and three windows as indicated in the drawings"]
[6.1,"Provide materials and fabricate steel generator room to the drawings attached.",1,"Item",null,{"$f":"E88*C88","v":0}]
[null,"Subtotal for Generator Room: (to be carried to summery below)",null,null,null,{"$f":"F88","v":0}]
[7,"Signboard Works: \nTechnical notes:\n","Technical Notes"]
[null,"-          Provide materials and fabrication of steel sign board, transporting, fixing in position with plain concrete as detailed in the drawings."]
[null,"-          Writing and drawing logos that shall be furnished by UNDP. "]
[null,"-          The frame of board shall be fabricated from 4*8 steel box pipes."]
[null,"-          The signboard shall be sheeted with good quality steel."]
[null,"The main frame and the steel sheet shall             be painted with antirust paint and two                  final coats. "]
[null,{"$f":"B89","v":"Subtotal for Generator Room: (to be carried to summery below)"}]
[7.1,"Making steel signboard for the water yard and fixing it position to the details indicated in the drawings and specifications above indicated and.  ",1,"item",null,{"$f":"E97*C97","v":0}]
[null,"Subtotal for the signboard works (to be carried to summery below)",null,null,null,{"$f":"F97","v":0}]
[null,"Summary of the Cost: (Please clearly state the bid currency)"]
[]
["item ","Item Specifications ","Amount "]
[1,{"$f":"B14","v":"Subtotal for the Geophysical survey works (to be carried to summery below)"},{"$f":"F14","v":0}]
[2,{"$f":"B26","v":"Subtotal for the Bore hole drilling works (to be carried to summery below)"},{"$f":"F26","v":0}]
[3,{"$f":"B52","v":"Subtotal for the Provision and installation  of dual system Submersible pump , , Solar system and the generator works: (to be carried to summery below)"},{"$f":"F52","v":0}]
[4,{"$f":"B72","v":"Subtotal for the Elevated Tank and Distribution Points (to be carried to summery below)"},{"$f":"F72","v":0}]
[5,{"$f":"B80","v":"Subtotal for the Fence Works (to be carried to summery below)"},{"$f":"F80","v":0}]
[6,{"$f":"B89","v":"Subtotal for Generator Room: (to be carried to summery below)"},{"$f":"F89","v":0}]
[7,{"$f":"B98","v":"Subtotal for the signboard works (to be carried to summery below)"},{"$f":"F98","v":0}]
[null,"Grand total of the  cost of construction of Amar Dalou the water yard",{"$f":"SUM(C102:C107)","v":0}]
[]
[]
[null,"Name of Bidder (Company / Firm):                     "]
[null,"Authorized signature:"]
[null,"Name of Authorized signatory:"]
[null,"Functional Title:                         "]
[null,"Email Address:"]
[null,"Contact Number:"]