{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["BOQ","Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"BOQ","index":0,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[[48,7,48,11],[62,8,66,8],[62,9,66,9],[62,10,66,10],[62,11,66,11],[46,0,47,0],[35,0,36,0],[0,0,0,5],[69,1,69,4],[62,2,66,2],[62,3,66,3],[62,4,66,4],[62,5,66,5],[62,0,66,0],[2,1,2,5],[3,1,3,5],[4,1,4,5],[70,1,70,4],[48,1,48,5]]}
["Renovation of Sewage Building in Telkaif - Telkiaf sub district -Ninwa Governate\nGPS (36.489864 , 43.124567)"]
[null,"General Specification "]
[null,"1-  All works and materials supplied by the contractor must be according to Iraq's standard Specifications"]
[null,"2-  The contractor must provide samples , catalogues and specification of materials for testing and approval by the site engineer "]
[null,"3-  Contractor must pay the cost for samples including any laboratory tests, both inside and outside the country as required "]
[null,"4- The price of works includes all job requirements as per Iraq's standard specification."]
[null,"5- The contractor must provide PPE (Personal Protective Equipment) for all laborer's, personnel, engineers and possible visitors to the site"]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"Civil Works"]
[1,"Site preparation:\nSupply of materials, tools, machineries and manpower for site preparation, by cleaning and removing all debris, rubble and dump it to locations approved by the local authorities. ","LS",1,null,{"$f":"E10*D10","v":0}]
[2,"Plastic wall coverings:  \nSupply of materials, tools and manpower to install plastic sheet of 30cm width, for walls covering. Including U, L sections and all necessary accessories. All needed works to complete the job, will be included within the price.","m²",300,null,{"$f":"E11*D11","v":0}]
[3,"Sun shed (W6xL12m):\nSupply of materials, tools and manpower to install sun shed for garage of dimensions (6x12m), by using corrugated metal sheet thickness 1mm and by fixing metal structure, as indicated on drawings. The price of works includes columns 100x100mm (4\"x4\") and horizontal steel purlins (rectangular steel tube), with all accessories needed, as well as all works to complete the job. See attached drawings","m²",72,null,{"$f":"D12*E12","v":0}]
[4,"Cement plastering:\nSupply materials, tools and manpower to repair wall cracks. The work includes removing the damaged cement plastering of external walls & fence, 25cm at each side of the crack, then filling the cracks with crack filler and cement mortar 1:3 and by using SBR at a rate of 200gr per m², including applying a layer of chicken wire on the area with  3 layers of cement plastering 1:3 mix ratio. Price of the work shall include all requirements to complete  the job.","m²",20,null,{"$f":"E13*D13","v":0}]
[5,"Sliding steel door (W6XH2m):\nSupply of materials, tools and manpower to install sliding steel gate of dimensions (W6xH2m), consisting on two parts, by using plate gauge18 and steel pipe 50x50x2mm. Including door handles and railing channel. Price of the work shall include painting of steel door with anti-rust and two coats of oil paints with all requirements to complete the job. See attached drawing","EA",1,null,{"$f":"E14*D14","v":0}]
[6,"Main steel gate (W3.2xH2m): \nSupply materials, tools and manpower to install main steel gate of dimensions (W3.2xH2m) and two leaves, by using plate gauge16 and steel pipe 40x40x3mm, including door handles, paining , hinges and locks. The price includes the removal of old damaged door, as well as all needed works to complete the job. See attached drawings","EA",1,null,{"$f":"E15*D15","v":0}]
[7,"Steel doors repairing:\nSupply of materials, tools, machineries and manpower to repair damaged steel doors. Including handles, hinges, painting and accessories. All needed works to complete the job will be included within the price.","EA",4,null,{"$f":"E16*D16","v":0}]
[8,"Steel door (W1xH2m):                              \nSupply of materials, tools and manpower to install steel door, double face doors (W1×H2m), by using plate gauge 16(1.58mm) and steel frame (25x25x3)mm, with a layer of styropore to be placed between the two faces. The price includes removal of existing wooden doors, door lock, mortise, fixing a stopper on the floor or the wall,  painting by using 2 layers anti-rust and 3 layers of oil painting, accessories and all needed works to complete the job. See attached drawings","EA",4,null,{"$f":"D17*E17","v":0}]
[9,"Repair steel windows: \nSupply of materials, tools and manpower to repair damaged steel window, including anti-insects wire mesh, painting, hinges, handles and accessories. All needed works to complete the job will be included within the price.","EA",13,null,{"$f":"E18*D18","v":0}]
[10,"Wooden doors (W1xH2.1m):\nSupply of materials, tools and manpower to install wooden doors of dimensions 1x2.1m. Including removal of existing wooden doors, frame, handles, hinges, door lock, 2 layers of oils painting and accessories. All needed works to complete the job will be included within the price. See attached drawings","EA",7,null,0]
[11,"Plastic painting works:\nSupply materials , tools and manpower to paint the external walls and fence with three-layer of plastic (water proof) painting . Price of the work shall include cleaning the walls and fence and removing the dirt and dust before painting. All needed works to complete the job will be included within the price.","m²",1700,null,0]
[12,"Emulsion painting works:\nSupply materials , tools and manpower to paint the interior walls with three-layer of emulsion painting . Price of the job shall include cleaning the walls and removing the dirt and dust before painting. All needed works to complete the job will be included within the price.","m²",900,null,0]
[13,"Oil Painting:\nSupply materials, tools and manpower to paint steel doors, windows, and internal walls with a paint-stripe at 1.25m height, by using one layer of emulsion and 3 layers of oil paintings. All needed works to complete the job will be included within the price.","m²",250,null,0]
[14,"Crystal clear glass:\nSupply of materials, tools and manpower to remove the damaged glass and to install new crystal clear glass 4 mm with new paste, dumping of all debris to a site approved by local authorities, in case it is needed,  as well as all needed works to complete the job.","m²",30,null,0]
[15,"Mosaic Tiles :\nSupply of materials, tools and manpower to replace mosaic floor tiles, 3 cm thickness and dimensions 30x30cm, type #4. Including cement mortal (1:2) and sand mortar bed, cutting, fittings, trims, curve edges, removal of damaged ceramic and dumping of all debris to a site approved by local authorities, in case it is needed, as well as all needed works to complete the job. ","m²",20,null,0]
[16,"Floor polishing: \nSupply of materials, tools, machineries and manpower for polishing mosaic tiles (30x30cm). The price of works includes cleaning, smoothing,  polishing, as well as all needed works to complete the job.","m²",500,null,0]
[17,"Billboard:\nSupply materials, tools and man power to install the title of the Building on  frame of size 3×1 m, with good quality LED printed sticker. The frame shall be made of square pipe section 4x4 cm. Price of the work shall  include all requirements to complete the job.","EA",1,null,0]
[18,"Plastic suspended ceiling\nSupply materials, tools and manpower to install false ceiling 60x60 cm (plastic boards), 10 mm thickness, by using necessary accessories L, T sections, galvanized steel wire 2mm for fixing with the roof by screws The price includes the removal of old damaged false ceiling, dumping of all debris to a site approved by local authorities, in case it is needed, as well as all needed works to complete the job. See attached drawings","m²",450,null,{"$f":"D27*E27","v":0}]
[19,"Flag pole : \nSupply materials , tools and man power to install Flag pole of  6 m high by using  2.5\" (64cm) pipe. Price of the work shall include anti rust and three layers oil painting and all  requirements  to complete the job.","EA",1,null,{"$f":"E28*D28","v":0}]
[null,"Generator Base:"]
[20,"Reinforced concrete slab (5x6m):\nSupply of materials, tools and manpower to cast reinforced concrete slab (25Mpa) of thickness 15cm. Reinforced with BRC Ø4mm 15x15 cm. The price of works includes expansion joints every 4.0m. All needed works to complete the job, will be included within the price.","m²",30,null,{"$f":"D30*E30","v":0}]
[21,"Fuel Tank with Base:\nSupply and install steel oil tank , capacity 1,000 liter made of plate gauge 18 (1.41 mm) thickness, cylindrical shape supported by steel base made from (2x2) inch angle shape (thickness 2mm). Complete with valves, float valves and all piping and fittings. All needed work to complete the job will be included within the price.","EA",1,null,{"$f":"D31*E31","v":0}]
[null,"Generator Shed:"]
[22,"Shed (5x6m):                                          \nSupplying of materials, tools and manpower to  install metal sheds (5x6m). By using steel pipe 100x100x3 mm for columns and out line frame 100x100x3 mm for major purlin, 75x50x2mm for minor purlin  and covered by corrugated sheet of 1mm thickness. The price includes fixing, installing, painting 2 layers antirust and 3 layers oiled paint. The price of works includes excavation, concrete, reinforcement concrete for the columns and all requirements to complete a good work. See attached drawing","m²",30,null,{"$f":"D33*E33","v":0}]
[23,"BRC fence : \nSupply materials, tools and manpower to install BRC fence 100x100x4mm, 3m height and strengthening with angle iron 75x75x3 mm. All needed work to complete the job will be included within the price. See attached drawings","ml",22,null,{"$f":"D34*E34","v":0}]
[24,"Metal doors for generator: \nSupplying of materials, tools and manpower to install steel doors (H3.0×W3.0m) by using BRC (50x50x4mm) and angle iron frame (75x75x3mm). The price of works includes  door lock, mortise, fixing a stopper on the floor or the wall,  painting of steel door using 2 layers anti-rust and 3 layers of oil painting. All needed work to complete the job will be included within the price. See attached drawing","EA",1,null,{"$f":"D35*E35","v":0}]
[null,"Subtotal for Civil Works",null,null,null,{"$f":"SUM(F10:F35)","v":0}]
[null,"Sanitary works"]
[1,"Water tank: \nSupply of materials , tools and manpower to install galvanized water tank of 1400 liters capacity with plate gauge 16 cylindrical shape supported by steel base made from 2 inch angle shape . Price of the work shall include connection of the inlet and outlet pipes, fittings, Valves, float valves, accessories and all requirements to complete the job. ","EA",6,null,{"$f":"E38*D38","v":0}]
[2,"Drain pipes:\nSupply of materials, tools and manpower for removing damaged water drain pipes and for installing new galvanized steel pipes 3\" (76mm). Including all connections and needed accessories to fix on roof and walls. Price of the work shall  include all requirements to complete the job. See attached drawings","ml",15,null,{"$f":"D39*E39","v":0}]
[3,"PPR water pipes maintain:\nSupply of materials, tools and manpower for repairing PPR water pipes 1/2\" and 3/4\" (Hot Cold). The price of works includes all pipe fittings, connection works and all accessories needed, as well as all needed works to complete the job.","LS",1,null,{"$f":"D40*E40","v":0}]
[4,"Manhole cover:\nSupply of tools, materials and manpower to install cast Iron manhole cover of dimensions (30x30cm). All needed works to complete the job, will be included within the price.","EA",5,null,{"$f":"D41*E41","v":0}]
[5,"Taps:\nSupply materials, tools and manpower necessary to connect chrome water taps 1/2\" or 3/4\", water connections. Price of the works shall include all requirements to complete the job.","EA",15,null,{"$f":"E42*D42","v":0}]
[6,"Mixer taps:\nSupply of materials, tools and manpower to install mixer taps, locks and all  needed accessories for completing water connections. All needed works to complete the job, will be included within the price.","EA",3,null,{"$f":"D43*E43","v":0}]
[7,"Siphon:\nSupply of materials, tools and manpower to install siphon, locks valves and all needed accessories for completing water connections. All needed works to complete the job, will be included within the price.","EA",5,null,{"$f":"D44*E44","v":0}]
[8,"Maintenance of sewerage pipes:\nSupply materials, machinery and manpower to clean the sewerage pipes net starting from the sanitary units, along manholes and the main septic tank. By using high pressure air/water to open the blockages in the network. All needed works to complete the job, will be included within the price.","LS",1,null,{"$f":"E45*D45","v":0}]
[9,"Water pump:\nSupply materials, tools and manpower to connect water pump (1hp), Q=3m³/Hrs., H=60m with, ball valve and all fitting and accessories for connection. The price of works includes all accessories needed, as well as all needed works to complete the job. See attached compliance sheet","EA",1,null,{"$f":"E46*D46","v":0}]
[null,"Subtotal for Sanitary works ",null,null,null,{"$f":"SUM(F38:F46)","v":0}]
[null,"Electricals Works"]
[null,"Work includes supply, install, test, connect, commission and replace the damaged wires with new suitable size for offices, conference hall, canteen, guest house, corridors, toilets also including street light and periphery lighting ,repair and maintenance for Main Distribution Board. replace (if any) damaged bulbs, tube lights, switches, sockets, holders, fans, lighting fixtures, switch boards, MCBs,  Maintenance of internal Telephone lines, instruments, junction boxes and wiring for new connections if required."]
[1,"Socket Switch(13A):\nSupplying & fixing of combine 13A, 5 pin universal switch-socket with shuttered & indicator outlet, on PVC molded tough surface box, with 1.0kV grade, 2x 2.5 mm² PVC insulated copper conductor laying through  PVC conduit  (Dia 20 mm) pipe with all accessories. The price includes supplying,installing,connecting,laying and commissioning drilling, cutting  to complete works as required.      ","EA",32,null,{"$f":"D50*E50","v":0}]
[2,"Light Switch:\nSupply, install, connect and commission  of (230VAC/6A) (single , double , triple and quadruple) light switches using single core wire (2*1.5mm²) laid inside  PVC pipe ( 20mm dia) with all accessories. The price includes supplying,installing,connecting,laying and commissioning drilling, cutting  to complete works as required.","EA",35,null,{"$f":"D51*E51","v":0}]
[3,"Fluorescent Lighting:                \nSupplying ,Installation, testing and commissioning of prewired fluorescent fittings of all pendant type complete set  and tube rod 19mm dia( 4feet) connecting 6 Amps switch with1.0 kV grade, 2x 1.5  mm² PVC insulated  copper cable laid through PVC conduit/casing capping with all accessories. The price includes supplying,installing,connecting,laying and commissioning drilling, cutting  to complete works as required.","EA",40,null,{"$f":"D52*E52","v":0}]
[4,"Ceiling Fan (false ceiling):\nSupply, connect and install 230 VAC ceiling fan size 60x60 cm ( for false ceiling) with remote control and multi speeds, connecting with 2 x 1.5 mm² 1.0KV grade PVC insulated copper conductor with all accessories. The price includes supplying,installing,connecting,laying and commissioning to complete works as required.","EA",8,null,{"$f":"E53*D53","v":0}]
[5,"Bracket waterproof wall:           \nSupplying & Installing of bracket waterproof wall  prewired outdoor lighting luminaries suitable for GLS lamp 230VAC/23 watts complete with all accessories such as base, LED drive & LED bulb, glass, reflector, louvered, connecting with one way 6 Amps switch and 1.0KV grade 2 x 1.5 mm² PVC insulated copper conductor with all accessories.  The price includes supplying,installing,connecting,laying and commissioning to complete works as required. ","EA",12,null,{"$f":"E54*D54","v":0}]
[6,"Main Board:\nSupply, install, test, commission prefabricated Main Distribution Board (MDB) (100cm x 80cmx 40cm)  incorporated in DIN bar with following  incoming and outgoing as: The price includes supplying, installing, connecting, laying and commissioning to complete works  as required.\n\nA - [(1 No.) 200A,  4 pole MCCB type, breaking capacity 25 kA,  \nB - [(4 No.)  25A,  1Ph. MCB type].\nC - (1 No.)Voltmeter (0- 400 V) with selector switch (all Ph-Ph and Ph -N).\nD - (1 Set)Ammeter (0 -200 A), 200/5A with required CTs.\nE -  (1 No.)Hertz meter (48- 52 )Hz.\nF -  (1 No.) selector switch.(ON & OFF position)\nG -  (3 No.) Indicator lamp 230VAC.\nH -  Three-phase, four wires Kilowatt-hour meter \nI -  (4 strips Copper Bus-Bar 60 cm each length  300A., for three phase lines and  neutral )  with separate earth strip,","EA",1,null,{"$f":"D55*E55","v":0}]
[7,"Exhaust fan:                                       \nSupplying, fixing and connecting of exhaust fan 240 volt A.C 1400 rpm & 450mm sweep  (35cm) includes using 1.0KV grade 2x1.5 mm² PVC insulated copper conductor and one way 6 A/230VAC switch  with all accessories. The price includes supplying,installing,connecting,laying and commissioning to complete works as required.     ","EA",5,null,0]
[8,"Sub Distribution Boards:\nSupplying, installing, testing and commissioning of for 24 ways, TPN DB (DIN type, horizontal/vertical) with single door complete set to accommodate incoming miniature circuit breaker (MCB) triple pole, 1 x 100 Amps, 415 volt A.C 16 kA, and outgoing SP MCB 24 x 32 Amps on/in prefabricated  MS surface /MS cubical control panel board with all accessories. The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.    ","EA",1,null,0]
[9,"Electrical water boiler:                          \nSupply, install,  connect, and commission electrical heater 250 Liter capacity 3 kW, with complete fittings & accessories connecting 1.0kV grade, 3x4mm²  PVC insulated copper conductor with all accessories. The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.","EA",2,null,0]
[10,"Electrical bell:                          \nSupplying and Installing of electrical call bell 230 VAC/5 W connecting with 2x 1.5 mm², 1.0KV grade cable, PVC insulated copper conductor in PVC surface conduit and one way 6Amps bell switch with all accessories. The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.","EA",1,null,0]
[11,"Split Unit Air-Conditioning:                  \nSupply, install , connect and commission  wall mounted Split unit Air-conditioning (Cool & Heat) 2  ton.(24000btuh) using 1.0 kV grade, PVC insulated copper cable  2x2.5mm²), laid through PVC conduit pipe (20 mm dia)/cable tray with one way 25 A/230VAC switch with all accessories. The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.(Attached GTP/Compliance sheet)","EA",8,null,0]
[12,"Outdoor Lighting:\nSupply and install of prewired indoor recessed down light luminaries suitable for GLS/reflector lamp 1x100 watts/230 VAC complete set with all accessories such as base, holder & bulb, glass globe, reflector, fixing clip, etc., including supplying & laying/connecting of  single way (6 Amps) lighting switch with 2x 1.5 mm²,1.0KV grade cable, PVC insulated copper conductor cable laid through PVC conduit pipe (Ø20 mm) circular junction box, square plastic box, adapter with cable holder on walls and ceiling as required. The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.","EA",4,null,{"$f":"E61*D61","v":0}]
[13,"Unstallation Generator:\nInstall and test commission diesel  generator set (50) kVA , the price should includes , connecting all cables, ATS, fuel pipes connections","EA",1,null,{"$f":"E62*D62","v":0}]
[14,"Automatic Change Over Switch Board:\nSupply, Install, test and commission of Automatic Change Over  (h x w x d: 100cm x 80 cm x60cm),with iron base support (60cm) height with adequate metallic Board , enclosed metal frame made of iron sheet 2mm thickness painted with two layers of gray color oil paint, with upper & lower ventilation louvers and exhaust fan on the top of the panel,  using rubber gaskets and equipped with the following items. The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.","EA",1,null,{"$f":"E63*D63","v":0}]
[null,"A - (1 No.) Automatic change over (100A); change over switch, twin three pole or four pole electrically interlocked mains/stand by change over circuit breakers with (Manual/Auto) selector, includes automatic control unit, local operation with handle."]
[null,"B - (1Set= 4 strips) 60 cm length Copper Bus-Bar 150A for lines and neutral and separate earth strips "]
[null,"C - One (1) set of digital Multifunction meter (V, A, F, MW, MVAR...etc.)."]
[null,"D - (3No.) Signal lamps& control cabling terminal block and protection fuses, bottom cable entry."]
[15,"Spot Lighting:\nSupply, install, connect and commission spot lighting fixtures, LED (230VAC/18 W), LED type, metal shape(water proof). The price includes supplying,installing,connecting,laying and commissioning to complete works  as required.","EA",54,null,{"$f":"E68*D68","v":0}]
[16,"Power Cable  (4X35  mm²):\nSupply, install, test and lay (4X35 mm²) PVC sheath, Un-Armored  copper conductors.(From the Generator Main board to the main board of the building ( laid through PVC pipe ( 4\" dia) with cable termination lugs in both sides with all accessories. The price includes supplying, laying, installing, testing, cutting and connecting with all accessories to complete works as required.\n","ml",40,null,{"$f":"D69*E69","v":0}]
[null,"Subtotal for Electricals Works",null,null,null,{"$f":"SUM(F50:F69)","v":0}]
[null,"Total ",null,null,null,{"$f":"SUM(F70,F47,F36)","v":0}]

{"sheet":"Summary","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,8,5],[11,0,11,5],[14,0,14,5],[17,0,17,4],[0,0,0,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[7,1,7,4]]}
[{"$f":"BOQ!A1","v":"Renovation of Sewage Building in Telkaif - Telkiaf sub district -Ninwa Governate\nGPS (36.489864 , 43.124567)"}]
[null,"General Specification "]
[null,"1- All the materials supplied by the contractor must be according to Iraq's standard Specifications"]
[null,"2- The contractor must provide samples , catalogues and specification of materials for testing and approval by the site engineer "]
[null,"3- Contractor must pay the cost for samples including any laboratory test required"]
[null,"4- The price of works includes all job requierements as per Iraq's standard specification."]
[]
["#","Item Description",null,null,null,"Total $"]
["Civil Works"]
[]
[null,"Subtotal for Civil Works",null,null,null,{"$f":"BOQ!F36","v":0}]
["Sanitary Works","Sanitary works"]
[]
[null,"Subtotal for Sanitary works ",null,null,null,{"$f":"BOQ!F47","v":0}]
["Electrical Works","Electricals Works"]
[]
[null,"Subtotal for Electricals Works",null,null,null,{"$f":"BOQ!F70","v":0}]
["Total ",{"$nulls":4},{"$f":"F17+F14+F11","v":0}]