{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":116,"n_cols":6,"rows_kept":116,"cut":false,"hidden":false,"merged":[[103,0,103,3],[59,0,59,3],[45,0,45,3],[4,0,4,3]]}
[null,null,"Bill of Quantity"]
[" Rehabilitation of Buildings and Workshops of Ramadi Vocational Training Center Stage II"]
[" "," ","Anbar - Ramadi"]
["#","Item","Unit","Quantity","Price $","Total $"]
[" First: Rehabilitation of five excisting Trusses of training workshops\n"]
[null,"Civil Works    "]
[1,"Supply materials, tools and manpower to remove 2 Watchtower, the damaged generator floor and the damaged part of trusses floor, price should include removal of all debris and surplus material to a dump site approved by the relevant local authority, and all the works required to complete the Job.","M2",210,null,{"$f":"D7*E7","v":0}]
[2,"Supply materials, tools and manpower to remove the damaged steel structure of trusses  that consist of H steel section of 12 inch, the work includes welding works the main column with celling and beams with all required bolts and base plate for connection, and all the works required to complete the Job.","M.l",60,null,{"$f":"D8*E8","v":0}]
[3,"Supply materials, tools and manpower to install and connect rainwater course drainage of 20x 50 cm dimension using galvanized plate of gage 16 that must be installed it along the trusses, the work includes filling the joints by silicon and foam and installation 0.08 mm thickness galvanized plate at the junction pieces of sandwich panel for trusses roof (hat), and all the works required to complete the Job.","M.l",125,null,0]
[4,"Supply materials, tools, and manpower for PVC pipes 4\" dia and 6 atmospheric pressure for rainwater drainage pipe , the work includes installation of pipe on the wall with all accessories and required works to complete the Job.","M.l",50,null,0]
[5,"Supply materials, tools and manpower to install steel guard frame for trusses aluminum widows price should include painting with 3 layer of oil based paint in addition to anti rust prime coat, with all accessories and required works to complete the Job ","M2",90,null,0]
[6,"Supply and install steel handrail for Emergency ladder consist of steel square section of (2x2) inch dimension and 90 cm height, the work includes painting with 3 layers of oil based paints in addition to Anti rust Primer, and all the required works to complete the Job.","M.l",25,null,0]
[7,"Supply materials, tools, and manpower to install PVC door 0.8*2.1m for the sanitary units. Price include all related ironmongery, accessories with all the required works to complete the Job.","Ea.",12,null,0]
[8,"Provision of materials, work and equipment to build walls above the exsisting partitions  with 24 cm thickness and1.25  m height using clay bricks with cement - sand mortar 1:3 to cut off the six workshops taking into consideration that the building start from height of 4 m with all work requirements","M3",50,null,0]
[9," Provision of materials, work and equipment to install the Sandwich Panel of thikness 5 cm and plate thikness of 0.5 cm and panel lenth is 12 m  for roof and walls with replacing  the damaged parts on the other trusses and reparing the rain water drainage including refilling the joints with Silicon and foam  with all work requirements","M2",1650,null,0]
[10,"Provision of materials, work and equipment for internal and external wall finishes  by using  Three layers plastic paints with all work requirments","M2",3000,null,0]
[null,"Total for Civil Works",null,null,null,{"$f":"SUM(F7:F16)","v":0}]
[null,"Sanitary Works    "]
[1,"Supply, install and connect PVC water hose of 1-inch diameter to connect the trusses and gardnes with water source the work includes excavation, backfill using river soil, with all connection and installations accessories and all the required works to complete the Job.  ","M.l",600,null,{"$f":"D19*E19","v":0}]
[2," Supply, install and test  wash basin with stand vitreous china complete with all necessary fittings such as mixer, drain pipe, mirror, angle valves, flexible pipes,.etc. inside the trusses with all work requirements.","Ea.",13,null,{"$f":"D20*E20","v":0}]
[3," Provision of materials, work and equipment to Supply, install and test black uv resistant polyethylene tank in the roof, circular type of storage 2000 liter, complete with drain, overflow, inlet, outlet and mechanical float, and repairing the existing stand with all work requirements.","Ea.",3,null,0]
[null,"Total for Sanitary Works",null,null,null,{"$f":"SUM(F19:F21)","v":0}]
[null,"Electrical Works    "]
[1," Supply materials, tools and manpower to repair the main electrical transformer of 1000 Kva capacity, the work includes all installation and connection accessories and all the required works to complete the Job.  as below:",null,null,null,{"$f":"D24*E24","v":0}]
["A","Replacing fuse cutout complete with fuse holder and fuse link element with holder bimetal clamp connectors (rating current 100 ampere,11KV)","Ea.",1,null,{"$f":"D25*E25","v":0}]
["B","Supply, install and connect end joint outdoor of 11KV","Ea.",1,null,0]
["C","Supply, install and connect Cable 3x150 mm 11kv ","M.l",25,null,0]
["D","Complete revamping for 1000KVA power transforme, the work include : "]
[null,"-Supply, connec and install HV Bushings","Ea.",1,null,0]
[null,"- Supply, connec and install  LV Bushings","Ea.",1,null,0]
[null,"- Supply, connec and install  Cover gaskets","Ea.",1,null,0]
[null,"- Supply, connec and install  tap changer","Ea.",1,null,0]
[null,"- Supply, connec and install oil level indicator","Ea.",1,null,0]
[null,"- Supply, connec and install pressure valve","Ea.",1,null,0]
["E","Oil transforme type SHELL","barrel ",2,null,0]
[2,"Supply, install and connect electrical Cable of (4*240) mm2 which connecting between the electrical transformer and main distribution board with all installation and connection accessories and all the required works to complete the Job","M.l",12,null,0]
[3," Supply, install and connect armed cable of (4*95) mm2 which connecting between the electrical board in trusses and main distribution board in transformer room with all installation and connection accessories and all the required works to complete the Job","M.l",580,null,0]
[4,"Supply, install and connect electrical cable of (4*4) mm2 which connecting between the electrical board of air-conditioning units and electrical circuit breakers of air-conditioning units for mengment building and trusses with all installation and connection accessories and all the required works to complete the Job","M.l",2370,null,0]
[5,"Supply, install and connect electrical cable of (4*6) mm2 to feed the equipment in trusses, with all installation and connection accessories and all the required works to complete the Job","M.l",450,null,0]
[6,"Supply, install and connect main distribution board in transformer room with all installation and connection accessories and all the required works to complete the Job , consist of:\n1 Main circuit breaker of three phase and 1500 Amp and 65 KV capacity;\n1 MCCB 3PH 500A,50KA;\n2 MCCB 3PH 350A,35KA;\n1 MCCB 3PH 400 A,35KA;\n3 MCCB 3PH 630 A,50KA\n1 MCCB 3PH 100 A 25KA spare\n","Ea.",1,null,0]
[7,"Supply, install and connect Industrial socket of 32 A and 3 PH for equipment existing in the trusses with all installation and connection accessories and all the required works to complete the Job","Ea.",32,null,0]
[8,"Supply materials, tools and manpower to excavate cable trench of 60 cm deep and 50 cm width for pulling the cables from transformer room to sub distribution board in 6 trusses, the work include build return wall using concrete block of 20*20*40 cm and cement mortar with high 60 cm , provision and installation 2 PVC pipe of 6 inch dimension and 12 check point with installing plastic cover of 40x 40 cm  and spreading river soil  up and down the pipes and all the required works to complete the Job","M.l",150,null,0]
[9,"Provision of materials, work and equipment to supply and install Socket outlets, 13 & 15 A switched socket with white plastic cover fix on the base height (120 cm) from the ground level using wires measuring 4 mm 2 and Ground (2.5 mm 2) including all of plastic pipe and connection between the outlet of the electrical circuit with all work requirements","Ea.",320,null,0]
[null,"Total for Electrical Works",null,null,null,{"$f":"SUM(F24:F43)","v":0}]
[null,"Subtotal 1",null,null,null,{"$f":"F17+F22+F44","v":0}]
[" Seconed : Reconstruction of the  excisting damage  training workshops\n"]
[null,"Civil Works    "]
[1,"Provision of materials, work and equipment for external wall finishes  by using Cement plastering ","M2",400,null,{"$f":"D48*E48","v":0}]
[2,"Provision of materials, work and equipment for the interior walls finishing by  using brown and white gypsum; the work includes using vertical rulers each 70cm distance to ensure the perpendicular corners,  with all work requirements","M2",750,null,{"$f":"D49*E49","v":0}]
[3," Provision of materials, work and equipment to Provide, place and compact suitable material  for filling embankment (subgrade) to the required levels and   Spraying in all backfilling of foundations and all floor with anti-termite protection taking into consideration the instructions of manufacturer and cast 20 cm lean concrete (1:2:4) using using sulphate resistant cement with BRC layer and making  expansion joints every 3 m Filled with cork  with all work requirements","M3",140,null,0]
[4,"Provision of materials, work and equipment to install aluminum windows 7 No. dimentions of  (1*2)m with the protection frame and fixation of locks, handles, install shaded glass of 6mm thickness And put wire blocker flies,  with all work requirements","M2",110,null,0]
[5,"Provision of materials, work and equipment to install wooden doors (1*2)m of saj type and two faces with the (3*6)inch \"jawi\" wooden frame; the work includes the fixation of the door with the finishings, painting, locks of good quality with all work requirements","Ea.",12,null,0]
[6," Provision of materials, work and equipment to Provide, and install iron door Moving on the rail, two partitions of dimensions (6 × 6) m using Cage Plate (16 mm) type and two faces   as well as the paint against rust and three layers of oil coating with all work requirements","Ea.",1,null,0]
[null,"Total for Civil Works",null,null,null,{"$f":"SUM(F48:F53)","v":0}]
[null,"Electrical Works   ",null,null,null,0]
[1,"Supply, install and connect electrical cable of (2*10) mm2 to feed Welding Machines in new truss, with all installation and connection accessories and all the required works to complete the Job","M.l",300,null,0]
[2,"Supply, install and connect sub distribution for truss with all installation and connection accessories and all the required works to complete the Job , consist of:\n1 Main circuit breaker of three phase and 630 Amp and 50 KV capacity;\n30 MCCB 3PH  63 A, 6KA\n20 MCCB 1PH 10 A, 6 KA\n35 MCCB 1PH 6 A, 6 KA\n10 MCCB 1PH 20 A, 6 KA\n","Ea.",1,null,0]
[null,"Total for Electrical Works",null,null,null,{"$f":"SUM(F55:F57)","v":0}]
[null,"Subtotal 2",null,null,null,{"$f":"F54+F58","v":0}]
[" Thired: Administration and Reception Building\n"]
[null,"Civil Works    "]
[1," Supply materials, tools, and manpower to remove the damaged ceramic wall tiles of sanitary unit wall and re finish using the ceramic tiles of 60*30cm, the price includes cement sand mortar 1:3, filling the Joints with white cement and all the required works to complete the Job. ","M2",40,null,{"$f":"D62*E62","v":0}]
[2," Supply materials, tools, and manpower to remove the damaged ceramic floor tiles of sanitary units floor and re finish using the ceramic tiles of 30x30cm, the price includes cement sand mortar 1:3, filling the Joints with white cement and all the required works to complete the Job. ","M2",100,null,{"$f":"D63*E63","v":0}]
[3," Supply materials, tools and manpower to finish the wall skirting using (60x15) cm granite skirting tiles and cement sand mortar 1:3, filling the Joints with white cement and all the required works to complete the Job. ","M.l",85,null,0]
[4,"Supply materials, tools and manpower to install teak wooden doors of (2*2.1)m with repairing the  Redwood (Jawi) frames, the price should include installation of locks and handles, 2 layers of paint in addition to undercoat and all accessories, with all required works to complete the Job.","Ea",5,null,0]
[5,"Supply and install steel door with  (2.1x1)m dimension , frame thickness 2 inch,  and  1.5mm thick steel  plate,  the work includes painting with  anti-rust paint and 3 layers of oil paints, locks , connections accessories , and all the required works to complete the Job.","Ea",3,null,0]
[6,"Supply materials, tools and manpower to repair the main steel doo for the buildingr, the work includes  welding, replacing the handles, locks, installation of 6 mm glass and painting with 3 layers of oil based paints with all the required works to complete the Job .","Ea",1,null,0]
[7,"Supply materials, tools and manpower to install new PVC windows of 8cm section width; the work includes the anti-flies net, handles and glass of 4mm thickness with all accessories and work requirements to complete the Job.","M2",15,null,0]
[8,"Supply materials, tools, and manpower to install PVC door 0.8*2.1m for the sanitary units. Price include all related ironmongery, accessories with all the required works to complete the Job.","Ea.",16,null,0]
[9," supply materials , tools and manpower to install sun shade roof for  the generator and fuel tank of   2.5 m highs ,consist of  4x4 inch steel square section for column , (3x1.5) inch steel rectangle section for beams and 0.8 mm thick corrugated plates for roof , the work includes painting with three layers of oil based paint, weldingand all the works required to complete the Job. ","M2",50,null,0]
[10,"Supply and install sunshade pantile with steel frame consist of  4x4 inch steel square section for column , (3x1.5) inch steel rectangle section for beams and pantile for roof that is installed at the entrance to the building, and all the required works to complete the Job","M2",75,null,0]
[11,"Supply materials, tools and manpower to finish the external passages of building with interlock tiles of 6 cm thickness and sand , the work includes spreading soil layer that not contain organic material and 15 cm sub-base layer \"class C\"  well compacted, the work includes filling the joints with fine sand, and all the required works to complete the Job.","M2",350,null,0]
[12,"Supply materials, tools and manpower to remove the damaged old false ceiling for sanitary unit and install new PVC false ceiling of (60x60) cm dimensions; the work includes the grids , all  accessories installation with installation and connection ceiling spot light contains 85 W economical bulb, with all the required works to complete job","M2",100,null,0]
[13,"Provision of materials, work and equipment  to  paint the internal and external walls with three layers using plastic paints with all work requirements","M2",2100,null,0]
[null,"Total for Civil Works",null,null,null,{"$f":"SUM(F62:F74)","v":0}]
[null,"Sanitary Works      "]
[1,"Supply materials, tools and manpower to removing the old damaged sewage net of the sanitary unit in the ground and first floor, with all the required works to complete the Job.","M.l",100,null,{"$f":"D77*E77","v":0}]
[2,"Supply materials, tools and manpower for 4\" PVC pipe, 6 bar atmospheric pressure, for the sewage net of the sanitary unit in the ground and first floor. The price should includes all connections, fittings, Joints, with all the required works to complete the Job.","M.l",60,null,{"$f":"D78*E78","v":0}]
[3,"Supply materials, tools and manpower for 6\" PVC pipe, 6 bar atmospheric pressure, for the sewage net of the sanitary unit in the ground and first floor. The price should includes all connections, fittings, Joints, with all the required works to complete the Job.","M.l",40,null,0]
[4,"Supply materials, tools, and manpower for squat WC \"Eastern or Turkish WC\" with 6 litter tank equipped with siphon flush valve, 32mm pvc pipe,  chrome tap with hose, connection with the plumbing system,  with all the necessary accessories and required works to complete the Job.","Ea.",8,null,0]
[5,"Supply materials, tools, and manpower for squat WC \"western ceramic toilet\"  hose, connection with the plumbing system,  with all the necessary accessories and required works to complete the Job.","Ea.",4,null,0]
[6,"Supply, install and connect ½ inch diameter galvanized pipe with all accessories connection and installation and taps with all the required works to complete the Job.","M.l",150,null,0]
[7," Supply, install and connect water pipe (PPR) of 1-inch diameter to connect the building with water source the work includes excavation, backfill using river soil, with all connection and installations accessories and all the required works to complete the Job.  ","M.l",100,null,0]
[8," Provision of materials, work and equipment to Supply, install and test electric water heater 160 litre rated at 3 kW,wall mounted, provided with inlet, outlet connection, and safety valve with all work requirments.","Ea.",3,null,0]
[null,"Total for Sanitary Works",null,null,null,{"$f":"SUM(F77:F84)","v":0}]
[null,"Electrical Works      "]
[1,"Supply, install and connect armed cable of (4*150) mm2 which connecting between the electrical board in management building and main distribution board with all installation and connection accessories and all the required works to complete the Job","M.l",200,null,{"$f":"D87*E87","v":0}]
[2,"Supply, install and connect electrical cable of (4*50) mm2 which connecting between the electrical board in management building and electrical board of air-conditioning units in ground and first floors with all installation and connection accessories and all the required works to complete the Job","M.l",25,null,{"$f":"D88*E88","v":0}]
[3,"Supply, install and connect armed cable of (4*25) mm2 which connecting between the management building and reception building with all installation and connection accessories and all the required works to complete the Job","M.l",85,null,0]
[4,"Supply, install and connect main distribution for administration building  with all installation and connection accessories and all the required works to complete the Job , consist of:\n1 Main circuit breaker of three phase and 630 Amp and 50 KV capacity;\n7 MCCB 3PH 100 A 25KA\n1 MCCB 3PH 300A,35 KA;\n\n","Ea.",1,null,0]
[5,"Supply, install and connect sub distribution board for air-conditioning units in ground floor with all installation and connection accessories and all the required works to complete the Job , consist of:\n1 Main circuit breaker of three phase and 160Amp and 25 KV capacity;\n6 MCCB 3PH  63 A, 6KA\n","Ea.",1,null,0]
[6,"Supply, install and connect sub distribution board for air-conditioning units in first floor  with all installation and connection accessories and all the required works to complete the Job , consist of:\n1 MCCB 3PH  160 A, 25KA\n6 MCCB 3PH 63A, 6 KA\n","Ea.",1,null,0]
[7,"supply ,install, connect and operate 400 Watt LED projector and circuit breakers they should be distributed around wall fence,trusses and above the building and all accessories with all the required works to complete the Job.","Ea.",35,null,0]
[8,"Supply, install and connect circuit breaker of 12 line, 3PH with all installation and connection accessories and all the required works to complete the Job","Ea.",1,null,0]
[9,"Supply materials, tools and manpower to removing the old damaged circuit breaker panel of 18 line and supplying, installation and connection new circuit breaker panel of 18 line, 3PH with all installation and connection accessories and all the required works to complete the Job","Ea.",6,null,0]
[10,"Supply, install and connect electronic telephone exchange consist of MCB, 80 internal phone line and selector switch with all installation and connection accessories and all the required works to complete the Job","Ea.",1,null,0]
[11,"Supply, connect and operate electrical point with electrical switch using single copper wires of (1 x 2.5)mm2, the work includes  pulling wires inside the existing PVC conduits and connecting it from sub-distribution board with all installation and connection accessories all the required works to complete the Job. as following :",null,null,null,0]
["A"," Electrical single switch for lighting","Ea.",30,null,0]
["B","Electrical double switch for lighting","Ea.",25,null,0]
["C"," Electrical triple switch for lighting","Ea.",20,null,0]
[12," Supply, install and operate ceiling spot light contains 100 wat economical bulb  with all work requirements","Ea.",100,null,0]
[null,"Total for Electrical Works",null,null,null,{"$f":"SUM(F87:F101)","v":0}]
[null,"Subtotal 3",null,null,null,{"$f":"F75+F85+F102","v":0}]
[" Fourth/ Construction of Cars's roofing and parking and land scaping\n "]
[null,"Civil Works     "]
[1,"Supply materials, tools and manpower to backfill the garden with  blended soil of 20 cm with afforestation as following: "]
["A","Backfill with clean and blended soil","M3",1650,null,{"$f":"D107*E107","v":0}]
["B","Supplying and planting the natural grass","M2",600,null,{"$f":"D108*E108","v":0}]
["C ","Supplying and planting the palm trees with length no less than 2m.","Ea.",50,null,0]
["D","Supplying and planting the Conocarpus tree with length no less than 1.5m","Ea.",80,null,0]
[2,"Supply and install Concrate Frame of 1 m length and 4 cm thicik which in used in Framing gardens, price should include installation and painting with three layerd oil based paint, with all the required works to complete job ","M.l",630,null,0]
[3,"Supply and install mosaic garden benches in gardens and all the required works to complete the Job","Ea.",18,null,0]
[4," Provision of materials, work and equipment to Provide and placing of roads and parking curbs , the work included all requirments to complete the job","Ea.",350,null,0]
[null,"Total for Civil Works",null,null,null,{"$f":"SUM(F107:F113)","v":0}]
[null,"Subtotal 4",null,null,null,{"$f":"F114","v":0}]
[null,"Total Cost $",null,null,null,{"$f":"F45+F59+F103+F115","v":0}]