{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Summary","SS1 Bab Ishtar","SS2 Eskan Al Mowatinen","SS3 Al Majmuha","4-Factory Acceptance Tests"],"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":"Summary","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,0,8,2],[1,0,1,3]]}
[]
["PRICE SCHEDULE / SUMMARY OF PRICES - Lot 1"]
[]
["#","Description","Capacity","Grand Total Price (US$)"]
["SS1","Bab Ishtar","33/11 kV, 2*31.5 MVA",{"$f":"'SS1 Bab Ishtar'!$E$24","v":0}]
["SS2","Eskan Al Mowatinin","33/11 kV, 2*31.5 MVA",{"$f":"'SS2 Eskan Al Mowatinen'!$E$20","v":0}]
["SS3","Al Majmuha","33/11 kV, 2*31.5 MVA",{"$f":"'SS3 Al Majmuha'!E20","v":0}]
[4,"Factory Acceptance Tests","---------",{"$f":"'4-Factory Acceptance Tests'!F16","v":0}]
["GRAND TOTAL OF PRICES",null,null,{"$f":"SUM(D5:D8)","v":0}]

{"sheet":"SS1 Bab Ishtar","index":1,"n_rows":473,"n_cols":6,"rows_kept":473,"cut":false,"hidden":false,"merged":[[472,0,472,4],[461,0,462,0],[464,0,464,4],[471,0,471,4],[442,0,442,5],[240,1,240,5],[437,0,438,0],[437,2,438,2],[437,3,438,3],[437,4,438,4],[437,5,438,5],[439,0,439,4],[440,1,440,4],[444,0,444,5],[448,0,449,0],[448,2,448,5],[449,2,449,5],[433,0,434,0],[433,2,434,2],[433,3,434,3],[433,4,434,4],[433,5,434,5],[435,0,436,0],[435,2,436,2],[388,4,389,4],[388,5,389,5],[390,0,390,4],[435,3,436,3],[435,4,436,4],[435,5,436,5],[424,3,425,3],[424,4,425,4],[424,5,425,5],[426,0,427,0],[426,2,427,2],[426,3,427,3],[426,4,427,4],[426,5,427,5],[428,0,429,0],[428,2,429,2],[428,3,429,3],[428,4,429,4],[428,5,429,5],[430,0,430,4],[431,0,431,4],[424,0,425,0],[424,2,425,2],[420,0,421,0],[358,0,358,4],[346,3,347,3],[346,4,347,4],[346,5,347,5],[348,0,349,0],[348,2,349,2],[348,3,349,3],[348,4,349,4],[348,5,349,5],[350,0,350,4],[354,1,354,5],[346,0,347,0],[346,2,347,2],[313,3,314,3],[313,4,314,4],[313,5,314,5],[315,0,316,0],[315,2,316,2],[315,3,316,3],[315,4,316,4],[315,5,316,5],[351,1,351,4],[342,0,343,0],[342,2,343,2],[342,3,343,3],[342,4,343,4],[342,5,343,5],[344,0,345,0],[344,2,345,2],[344,3,345,3],[344,4,345,4],[344,5,345,5],[338,0,339,0],[338,2,339,2],[338,3,339,3],[338,4,339,4],[338,5,339,5],[127,0,128,0],[127,2,128,2],[127,3,128,3],[127,4,128,4],[127,5,128,5],[248,3,249,3],[248,4,249,4],[248,5,249,5],[250,0,251,0],[250,2,251,2],[250,3,251,3],[250,4,251,4],[250,5,251,5],[246,0,247,0],[246,2,247,2],[246,3,247,3],[246,4,247,4],[246,5,247,5],[248,0,249,0],[248,2,249,2],[230,0,231,0],[230,2,231,2],[230,3,231,3],[230,4,231,4],[121,1,121,5],[125,0,125,4],[109,0,110,0],[109,2,110,2],[109,3,110,3],[109,4,110,4],[109,5,110,5],[111,0,112,0],[111,2,112,2],[111,3,112,3],[111,4,112,4],[111,5,112,5],[81,0,81,4],[83,0,84,0],[83,2,84,2],[83,3,84,3],[83,4,84,4],[83,5,84,5],[85,0,86,0],[85,2,86,2],[85,3,86,3],[85,4,86,4],[85,5,86,5],[74,0,74,4],[76,0,77,0],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[78,0,79,0],[78,2,79,2],[78,3,79,3],[78,4,79,4],[78,5,79,5],[420,2,421,2],[420,3,421,3],[420,4,421,4],[420,5,421,5],[422,0,423,0],[422,2,423,2],[422,3,423,3],[422,4,423,4],[422,5,423,5],[416,0,417,0],[416,2,417,2],[416,3,417,3],[416,4,417,4],[416,5,417,5],[418,0,418,4],[419,0,419,4],[409,0,410,0],[409,2,410,2],[409,3,410,3],[409,4,410,4],[409,5,410,5],[411,0,411,4],[412,0,412,4],[414,0,415,0],[414,2,415,2],[414,3,415,3],[414,4,415,4],[414,5,415,5],[402,0,403,0],[402,2,403,2],[402,3,403,3],[402,4,403,4],[402,5,403,5],[404,0,404,4],[405,0,405,4],[407,0,408,0],[407,2,408,2],[407,3,408,3],[407,4,408,4],[407,5,408,5],[395,0,396,0],[395,2,396,2],[395,3,396,3],[395,4,396,4],[395,5,396,5],[397,0,397,4],[398,0,398,4],[400,0,401,0],[400,2,401,2],[400,3,401,3],[400,4,401,4],[400,5,401,5],[391,0,391,4],[393,0,394,0],[393,2,394,2],[393,3,394,3],[393,4,394,4],[393,5,394,5],[382,0,383,0],[382,2,383,2],[382,3,383,3],[382,4,383,4],[382,5,383,5],[384,0,385,0],[384,2,385,2],[384,3,385,3],[384,4,385,4],[384,5,385,5],[386,0,387,0],[386,2,387,2],[386,3,387,3],[386,4,387,4],[386,5,387,5],[388,0,389,0],[388,2,389,2],[388,3,389,3],[378,0,379,0],[378,2,379,2],[378,3,379,3],[378,4,379,4],[378,5,379,5],[380,0,381,0],[380,2,381,2],[380,3,381,3],[380,4,381,4],[380,5,381,5],[374,0,375,0],[374,2,375,2],[374,3,375,3],[374,4,375,4],[374,5,375,5],[376,0,377,0],[376,2,377,2],[376,3,377,3],[376,4,377,4],[376,5,377,5],[372,0,373,0],[366,0,367,0],[366,2,367,2],[366,3,367,3],[366,4,367,4],[366,5,367,5],[360,0,361,0],[360,2,361,2],[360,3,361,3],[360,4,361,4],[360,5,361,5],[362,0,363,0],[362,2,363,2],[362,3,363,3],[362,4,363,4],[362,5,363,5],[364,4,365,4],[364,5,365,5],[369,0,369,4],[370,0,370,4],[364,0,365,0],[364,2,365,2],[364,3,365,3],[340,0,341,0],[340,2,341,2],[340,3,341,3],[340,4,341,4],[340,5,341,5],[334,0,335,0],[334,2,335,2],[334,3,335,3],[334,4,335,4],[334,5,335,5],[336,0,337,0],[336,2,337,2],[336,3,337,3],[336,4,337,4],[336,5,337,5],[330,0,331,0],[330,2,331,2],[330,3,331,3],[330,4,331,4],[330,5,331,5],[332,0,333,0],[332,2,333,2],[332,3,333,3],[332,4,333,4],[332,5,333,5],[326,0,327,0],[326,2,327,2],[326,3,327,3],[326,4,327,4],[326,5,327,5],[328,0,329,0],[328,2,329,2],[328,3,329,3],[328,4,329,4],[328,5,329,5],[322,0,323,0],[322,2,323,2],[322,3,323,3],[322,4,323,4],[322,5,323,5],[324,0,325,0],[324,2,325,2],[324,3,325,3],[324,4,325,4],[324,5,325,5],[320,0,321,0],[320,2,321,2],[320,3,321,3],[320,4,321,4],[320,5,321,5],[317,0,317,4],[318,0,318,4],[307,0,308,0],[307,2,308,2],[307,3,308,3],[307,4,308,4],[307,5,308,5],[309,0,310,0],[309,2,310,2],[309,3,310,3],[309,4,310,4],[309,5,310,5],[311,0,312,0],[311,2,312,2],[311,3,312,3],[311,4,312,4],[311,5,312,5],[313,0,314,0],[313,2,314,2],[303,0,304,0],[303,2,304,2],[303,3,304,3],[303,4,304,4],[303,5,304,5],[305,0,306,0],[305,2,306,2],[305,3,306,3],[305,4,306,4],[305,5,306,5],[299,0,300,0],[299,2,300,2],[299,3,300,3],[299,4,300,4],[299,5,300,5],[301,0,302,0],[301,2,302,2],[301,3,302,3],[301,4,302,4],[301,5,302,5],[297,0,297,4],[288,0,289,0],[288,2,289,2],[288,3,289,3],[288,4,289,4],[288,5,289,5],[290,0,291,0],[290,2,291,2],[290,3,291,3],[290,4,291,4],[290,5,291,5],[292,0,293,0],[292,2,293,2],[292,3,293,3],[292,4,293,4],[292,5,293,5],[294,0,295,0],[294,2,295,2],[294,3,295,3],[294,4,295,4],[294,5,295,5],[296,0,296,4],[286,0,287,0],[286,2,287,2],[286,3,287,3],[286,4,287,4],[286,5,287,5],[279,0,280,0],[279,2,280,2],[279,3,280,3],[279,4,280,4],[279,5,280,5],[281,0,282,0],[281,2,282,2],[281,3,282,3],[281,4,282,4],[281,5,282,5],[283,0,283,4],[284,0,284,4],[277,0,278,0],[277,2,278,2],[277,3,278,3],[277,4,278,4],[277,5,278,5],[268,0,269,0],[268,2,269,2],[268,3,269,3],[268,4,269,4],[268,5,269,5],[270,0,271,0],[270,2,271,2],[270,3,271,3],[270,4,271,4],[270,5,271,5],[272,0,272,4],[273,0,273,4],[275,0,276,0],[275,2,276,2],[275,3,276,3],[275,4,276,4],[275,5,276,5],[253,0,253,4],[265,0,265,4],[266,0,266,4],[255,0,256,0],[257,0,258,0],[257,2,258,2],[257,3,258,3],[257,4,258,4],[257,5,258,5],[259,0,260,0],[259,2,260,2],[259,3,260,3],[259,4,260,4],[259,5,260,5],[261,0,262,0],[261,2,262,2],[261,3,262,3],[261,4,262,4],[261,5,262,5],[263,0,264,0],[263,2,264,2],[263,3,264,3],[263,4,264,4],[263,5,264,5],[252,0,252,4],[244,0,244,4],[234,0,235,0],[234,2,235,2],[234,3,235,3],[234,4,235,4],[234,5,235,5],[236,0,236,4],[237,0,237,4],[230,5,231,5],[232,0,233,0],[232,2,233,2],[232,3,233,3],[232,4,233,4],[232,5,233,5],[226,0,227,0],[226,2,227,2],[226,3,227,3],[226,4,227,4],[226,5,227,5],[228,0,229,0],[228,2,229,2],[228,3,229,3],[228,4,229,4],[228,5,229,5],[222,0,223,0],[222,2,223,2],[222,3,223,3],[222,4,223,4],[222,5,223,5],[224,0,225,0],[224,2,225,2],[224,3,225,3],[224,4,225,4],[224,5,225,5],[218,0,219,0],[218,2,219,2],[218,3,219,3],[218,4,219,4],[218,5,219,5],[220,0,221,0],[220,2,221,2],[220,3,221,3],[220,4,221,4],[220,5,221,5],[214,0,215,0],[214,2,215,2],[214,3,215,3],[214,4,215,4],[214,5,215,5],[216,0,217,0],[216,2,217,2],[216,3,217,3],[216,4,217,4],[216,5,217,5],[210,0,211,0],[210,2,211,2],[210,3,211,3],[210,4,211,4],[210,5,211,5],[212,0,213,0],[212,2,213,2],[212,3,213,3],[212,4,213,4],[212,5,213,5],[206,0,207,0],[206,2,207,2],[206,3,207,3],[206,4,207,4],[206,5,207,5],[208,0,209,0],[208,2,209,2],[208,3,209,3],[208,4,209,4],[208,5,209,5],[198,0,198,4],[199,0,199,4],[201,0,202,0],[201,2,202,2],[201,3,202,3],[201,4,202,4],[201,5,202,5],[203,0,203,4],[204,0,204,4],[196,0,197,0],[196,2,197,2],[196,3,197,3],[196,4,197,4],[196,5,197,5],[192,0,193,0],[192,2,193,2],[192,3,193,3],[192,4,193,4],[192,5,193,5],[194,0,195,0],[194,2,195,2],[194,3,195,3],[194,4,195,4],[194,5,195,5],[188,0,189,0],[188,2,189,2],[188,3,189,3],[188,4,189,4],[188,5,189,5],[190,0,191,0],[190,2,191,2],[190,3,191,3],[190,4,191,4],[190,5,191,5],[184,0,185,0],[184,2,185,2],[184,3,185,3],[184,4,185,4],[184,5,185,5],[186,0,187,0],[186,2,187,2],[186,3,187,3],[186,4,187,4],[186,5,187,5],[180,0,181,0],[180,2,181,2],[180,3,181,3],[180,4,181,4],[180,5,181,5],[182,0,183,0],[182,2,183,2],[182,3,183,3],[182,4,183,4],[182,5,183,5],[175,0,175,4],[176,0,176,4],[178,0,179,0],[178,2,179,2],[178,3,179,3],[178,4,179,4],[178,5,179,5],[173,0,174,0],[173,2,174,2],[173,3,174,3],[173,4,174,4],[173,5,174,5],[169,0,170,0],[169,2,170,2],[169,3,170,3],[169,4,170,4],[169,5,170,5],[171,0,172,0],[171,2,172,2],[171,3,172,3],[171,4,172,4],[171,5,172,5],[164,0,164,4],[165,0,165,4],[167,0,168,0],[167,2,168,2],[167,3,168,3],[167,4,168,4],[167,5,168,5],[162,0,163,0],[162,2,163,2],[162,3,163,3],[162,4,163,4],[162,5,163,5],[158,0,159,0],[158,2,159,2],[158,3,159,3],[158,4,159,4],[158,5,159,5],[160,0,161,0],[160,2,161,2],[160,3,161,3],[160,4,161,4],[160,5,161,5],[153,0,153,4],[154,0,154,4],[156,0,157,0],[156,2,157,2],[156,3,157,3],[156,4,157,4],[156,5,157,5],[151,0,152,0],[151,2,152,2],[151,3,152,3],[151,4,152,4],[151,5,152,5],[142,0,143,0],[142,2,143,2],[142,3,143,3],[142,4,143,4],[142,5,143,5],[146,0,146,4],[147,0,147,4],[149,0,150,0],[149,2,150,2],[149,3,150,3],[149,4,150,4],[149,5,150,5],[144,0,145,0],[144,2,145,2],[144,3,145,3],[144,4,145,4],[144,5,145,5],[136,0,137,0],[138,0,139,0],[138,2,139,2],[138,3,139,3],[138,4,139,4],[138,5,139,5],[140,0,141,0],[140,2,141,2],[140,3,141,3],[140,4,141,4],[140,5,141,5],[133,0,133,4],[134,0,134,4],[117,0,117,4],[113,0,114,0],[113,2,114,2],[113,3,114,3],[113,4,114,4],[113,5,114,5],[115,0,116,0],[115,2,116,2],[115,3,116,3],[115,4,116,4],[115,5,116,5],[118,0,118,4],[131,0,132,0],[129,0,130,0],[129,2,130,2],[129,3,130,3],[129,4,130,4],[129,5,130,5],[131,2,132,2],[131,3,132,3],[131,4,132,4],[131,5,132,5],[105,3,106,3],[105,4,106,4],[105,5,106,5],[107,0,108,0],[107,2,108,2],[107,3,108,3],[107,4,108,4],[107,5,108,5],[100,0,100,4],[105,0,106,0],[105,2,106,2],[98,0,99,0],[98,2,99,2],[98,3,99,3],[98,4,99,4],[98,5,99,5],[101,0,101,4],[103,0,104,0],[103,2,104,2],[103,3,104,3],[103,4,104,4],[103,5,104,5],[96,0,96,4],[87,0,88,0],[87,2,88,2],[87,3,88,3],[87,4,88,4],[87,5,88,5],[89,0,90,0],[89,2,90,2],[89,3,90,3],[89,4,90,4],[89,5,90,5],[95,0,95,4],[91,0,92,0],[91,2,92,2],[91,3,92,3],[91,4,92,4],[91,5,92,5],[93,0,94,0],[93,2,94,2],[93,3,94,3],[93,4,94,4],[93,5,94,5],[67,0,68,0],[67,2,68,2],[67,3,68,3],[67,4,68,4],[67,5,68,5],[17,1,17,3],[10,4,10,5],[1,0,1,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[19,1,19,5],[13,1,13,5],[23,0,23,3],[10,1,10,3],[11,1,11,3],[12,0,12,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[11,4,11,5],[12,4,12,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[25,0,25,5],[65,3,66,3],[65,4,66,4],[18,0,18,3],[20,1,20,3],[21,1,21,3],[22,0,22,3],[18,4,18,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[56,0,56,5],[57,0,57,5],[58,0,58,5],[59,0,59,5],[60,0,60,5],[53,0,53,5],[23,4,23,5],[65,5,66,5],[80,0,80,4],[27,4,27,5],[28,4,28,5],[41,0,47,0],[51,0,51,4],[27,3,29,3],[27,2,29,2],[27,1,29,1],[27,0,29,0],[71,0,72,0],[71,2,72,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[55,1,55,5],[63,0,63,4],[65,0,66,0],[65,2,66,2],[73,0,73,4],[69,0,70,0],[69,2,70,2],[69,3,70,3],[69,4,70,4],[69,5,70,5]]}
[]
["Partially Defected Substations: Bab Ishtar Substation "]
[]
["Substation Name: ",null,null,null,"Bab Ishtar"]
["Coordinates",null,null,null,"38SLF3408423151"]
["Capacity",null,null,null,"33/11 kV, 2*31.5 MVA"]
["Existing Substation switchgear Type",null,null,null,"ABB"]
["Existing Substation Transformer Type",null,null,null,"SEA"]
["Dimension",null,null,null,"(50*50)m"]
[]
["#","Description",null,null,"Grand Total Price (US$)"]
["A","Renovation for MV Equipment's Works",null,null,{"$f":"F52","v":0}]
["Total for Renovation for MV Equipment's works",null,null,null,{"$f":"SUM(E12)","v":0}]
["B","Civil Works"]
[1,"Subtotal for Renovation of switch gear hall & control rooms building",null,null,{"$f":"F119","v":0}]
[2,"Subtotal for renovation of Service Building",null,null,{"$f":"F238","v":0}]
[3,"Subtotal for renovation of  Guard house building",null,null,{"$f":"F352","v":0}]
[4,"Subtotal for Renovation of ( Internal Yard , External Sidewalk & External fence )",null,null,{"$f":"F441","v":0}]
["Total for Civil works",null,null,null,{"$f":"SUM(E15:F18)","v":0}]
["C","Auxiliary Works"]
[1," Electrical Works ",null,null,{"$f":"F465","v":0}]
[2,"Mechanical Works",null,null,{"$f":"F472","v":0}]
["Total for Auxiliary works",null,null,null,{"$f":"SUM(E21:F22)","v":0}]
["GRAND TOTAL OF PRICES",null,null,null,{"$f":"SUM(E23,E19,E13)","v":0}]
[]
["A- Renovation for MV Equipment's"]
[]
["Item No.","Description","Unit","Quantity","Tender Price"]
[{"$nulls":4},"Design/ Manufacturing \nDelivery to Site / Installing / Testing & Commissioning"]
[{"$nulls":4},"Unit price","Total Price"]
[1,"33kV AIS Metal Clad Switchgear Withdrawable for incoming feeder, including protection (ABB, ZS2)","Bays",2,null,{"$f":"D31*E31","v":0}]
[2,"33kV AIS Metal Clad Switchgear Withdrawable for transformer feeder, including protection (ABB, ZS2)","Bays",2,null,{"$f":"D32*E32","v":0}]
[3,"11kV AIS Metal Clad  Switchgear for Capacitor bank feeder, including protection (ABB, UniGear ZS1)","Bays",2,null,0]
[4,"33/11.5, 31.5MVA, Power Transformer ONAN, With Vacuum OLTC and Local Control Panel.(SEA, Italy)","Set",2,null,{"$f":"D34*E34","v":0}]
[5,"11kV Neutral Earthing Resister with on load switch, including protection etc. and surge arrester.","Set",2,null,{"$f":"D35*E35","v":0}]
[6,"11/0.4kV,250kVA Auxiliary Transformer.","Set",1,null,0]
[7,"Battery Bank 110VDC, ALCAD/ type LCE145P   (92 cells).","Set",1,null,0]
[8,"Battery Bank 48VDC, ALCAD/ type LCE145P (40 cells).","Set",1,null,0]
[9,"Complete C.B 11KV Incoming, Metal-clad Switchgear, ABB UniGear ZS1","Set",1,null,0]
[10,"Complete C.B 11KV Outgoing Feeder Metal-clad Switchgear, ABB UniGear ZS1","Set",3,null,0]
[11,"11 kV Side Protection Relay (O/C, E/F) REF 542 plus","Set",5,null,0]
[12,"33 kV end joint outdoor type cable termination suitable for (1*400mm2) Non- armored cables","Set",12,null,0]
[null,"33 kV end joint indoor type cable termination suitable for AIS Switchgears and (1*400mm2) Non- armored cables","Set",12,null,0]
[null,"33 kV straight joint cable termination suitable for (1*400mm2) Non- armored cables","Set",80,null,0]
[null,"24 kV end joint indoor type cable termination suitable for 11 kV AIS Switchgears (Incomers) and (1*400mm2) Non- armored cables","Set",40,null,0]
[null,"24 kV end joint outdoor type cable termination suitable for 11 kV AIS Switchgears (Aux. and Cap) and (1*150mm2) Non- armored cables","Set",12,null,0]
[null,"24 kV end joint indoor type cable termination suitable for 11 kV AIS Switchgears (OG) (3*150mm2) Non- armored cables",null,7,null,0]
[null,"24 kV straight joint cable termination suitable for (3*150mm2) Non- armored cables","Set",10,null,0]
[13,"Tools and handling equipment Including mobile roller cab and tools cabinet, any required Loose assortment for Substation maintenance (wrenches sets, Hexagon and Star key wrenches, reversible ratchet...etc.).","Set",1,null,0]
[14,"Set of high quality laptop Core i7, 2T Hard Drive,16 GB DDR4-2133 SDRAM (2 x 8 GB), 256 GB M.2 SATA TLC SSD, DVD+/-RW, 15.'6'' LED Monitor, USB 3, Original Windows 10 32/64 bit, Baggage and wireless Mouse.","pc",1,null,{"$f":"D50*E50","v":0}]
[15,"3 MVAR Capacitor Bank. ","Set",2,null,0]
["Total",{"$nulls":4},{"$f":"SUM(F31:F51)","v":0}]
[]
["B- Civil Works"]
[]
[1,"Renovation of switch gear hall & control rooms building"]
["General Specification "]
["1-  All the materials supplied by the contractor must be according to Iraq's standard Specifications"]
["2-  The contractor must provide samples , catalogues and specification of materials for testing and approval by the site engineer "]
["3-  Contractor must pay the cost for samples including any laboratory tests, both inside and outside the country as required "]
["4- The price of works includes all job requirements as per Iraq's standard specification."]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"CIVIL WORKS"]
["DIVISION A-PLASTERING AND PAINTING WORKS"]
["A","Plastering and painting works"]
["A1","Cement plastering","m²",40,null,{"$f":"D66*E66","v":0}]
[null,"Supply of materials, tools and manpower to repair wall cracks and remove the damaged cement plastering of external walls by removing the damaged cement plastering minimum 10 cm at each side of the crack, then treat the cracks with crack filler approved by manufacture with cement mortar 1:3 and using SBR at a rate according to the product's instructions for the additive material , later putting a layer of metal chicken mesh 10 cm overlap each side on the area with 3 layers of cement plastering , using aluminum vertical guide every 80cm ,  1:3. All needed works to complete the job, will be included within the price."]
["A2","Gypsum plastering","m²",40,null,{"$f":"D68*E68","v":0}]
[null,"Supply of all necessary materials, tools and manpower to remove the damaged gypsum plastering of internal walls and plastering with new gypsum plastering  in 2 layers minimum thickness 15mm. The work includes repairing of wall cracks by removing the damaged gypsum plastering 15 cm at each side of the crack, then filling the cracks with cement mortar 1:3 and using SBR at a rate according to the product's instructions for the additive material , later putting a layer of plastic mesh on the area under the gypsum plastering using aluminum vertical guide every 80cm . All needed works to complete the job, shall be included with in the price."]
["A3","Emulsion painting","m²",100,null,{"$f":"D70*E70","v":0}]
[null,"Supply of materials, tools and manpower to paint the interior walls for control hall , with 3 layers of emulsion painting. The job includes cleaning the walls and removing the dirt and dust before painting , repairing of wall cracks and filling by the gypsum plastering . All needed works to complete the job, shall be included within the price."]
["A4","Plastic painting","m²",700,null,{"$f":"D72*E72","v":0}]
[null,"Supply of materials, tools and manpower to paint the exterior walls with three-layer of silicon (water proof) painting. The works 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."]
["SUB TOTAL FOR PLASTERING AND PAINTING  WORK",{"$nulls":4},{"$f":"SUM(F66:F73)","v":0}]
["DIVISION B- ROOFING , CLADDING , CEILING AND TILING WORKS"]
["B","Roofing, Cladding, Ceiling and Tilling works"]
["B1","Gypsum suspended ceiling","m²",240,null,{"$f":"D77*E77","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Gypsum boards) for rooms in control building. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["B2","Plastic suspended ceiling","m²",26,null,{"$f":"D79*E79","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Plastic boards) for rooms in control building. 6mm thickness. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["SUB TOTAL FOR ROOFING ,CLADDING, TILING WORK",{"$nulls":4},{"$f":"SUM(F77:F80)","v":0}]
["DIVISION C -METAL WINDOWS AND  DOORS "]
["C","Windows, doors and steel works"]
["C1","Reinstall PVC windows :   ","m²",81,null,{"$f":"D84*E84","v":0}]
[null,"  Supply of materials, tools and manpower to remove old PVC windows and reinstall white PVC windows and windows for ventilation , with existing dimensions for control halls , kitchen and ventilation windows for toilet and bathroom  . The price of work includes anti-insects wire mesh, handle and frosted clear glass (6 mm). All needed works to complete the job, will be included within the price."]
["C2","Reinstall PVC doors (1x2)m:","EA",11,null,{"$f":"D86*E86","v":0}]
[null,"    Supply of materials, tools and manpower to remove old doors and reinstall new PVC doors (1*2)m . The price of work includes door lock, mortise, fixing a stopper on the floor or wall,  as well as all needed works to complete the job. DWG-Detail of PVC  door(1.0x2.0)m"]
["C3","Reinstall PVC partitions :   ","m²",100,null,{"$f":"D88*E88","v":0}]
[null,"  Supply of materials, tools and manpower to remove old PVC partitions and reinstall white PVC partitions. The price of work includes main frame width 70 mm , frosted clear glass (6 mm) for upper part of door ,  with all accessories , and  as well as all needed works to complete the job."]
["C4","Reinstall Wooden doors (1.3x2.15)m:","EA",1,null,{"$f":"D90*E90","v":0}]
[null,"Supply and install wooden doors with frame for replacing the  damaged doors with dimensions (1.3×2.15) m interior doors for control hall with decorations. Price of the work shall include removing the damaged doors. the inner portions space of the door is not more than 10cm, with good frames (15*7.5)cm from mahogany wood with architrave from mahogany wood covered the space between frame and wall with 7cm thick and 3.2cm width . Paint the two faces with special paint for teak paint and varnish, 2 layers , installation of door handles and hinges, as well as all needed works to complete the job. DWG-Wooden Door-1.0x2.0m"]
["C5","Reinstall steel doors (1.3x2.2)m:","EA",2,null,{"$f":"D92*E92","v":0}]
[null,"Supply of materials, tools and manpower to remove old steel doors and reinstall (1.3x2.2)m size for entrances of the control hall front and back  with decorations  . the doors supported by steel angles (25*25*3) mm . new steel plate on double face , the door should be balance with easily close/open . The price of work includes, hinges, door locks , mortise, fixing a stopper on the floor or wall, eye magic , painting of steel door by using anti-rust and 3 layers of oil painting, as well as all needed works to complete the job. DWG-Double Face Steel Door"]
["C6","Burglar steel bars","m²",80,null,{"$f":"D94*E94","v":0}]
[null,"Supply of materials, tools and manpower for installing windows burglar bars for windows with existing dimensions , by using  12mm square steel ,2 mm thickness. Including 2 layers of anti-rust and 1 layer of oil painting, as well as all needed works to complete the job. DWG- Bulgar bar Detail"]
["SUB TOTAL FOR METAL WINDOWS AND DOORS WORK",{"$nulls":4},{"$f":"SUM(F84:F95)","v":0}]
["DIVISION D -FENCE WALL , SUN SHADE , HANDRAIL  OTHER WORKS"]
["D","Fence wall, Sun shade and other works"]
["D1","Repair Aluminum Handrails","ML",6,null,{"$f":"D99*E99","v":0}]
[null,"Supply of materials, tools and manpower to repair the damaged Aluminum Handrails for exterior  2 stair of control rooms in switch gear building handrails sections of pipe measuring 2 inch and  use exist height of Handrails . All needed works to complete the job, will be included within the price."]
["SUB TOTAL FOR FENCE WALL, SUNSHADE,HANDRAIL AND OTHER WORK",{"$nulls":4},{"$f":"SUM(F99:F100)","v":0}]
["DIVISION I -SANITARY  WORKS"]
["I","Sanitary works"]
["I1","Water tank : ","EA",2,null,{"$f":"D104*E104","v":0}]
[null,"    Supply of necessary materials, tools and manpower for installing galvanized water tank of 1400 liter of capacity. Cylindrical shape and with plate gauge 16 (1.59mm) , supported by steel base made with 50mm (2\") angle shape, including the connection of the inlet and outlet pipes. The price of works includes all piping and fittings, valves, float valves, accessories as well as all needed works to complete the job."]
["I2","Storm pipes","ML",28,null,{"$f":"E106*D106","v":0}]
[null,"Supply of materials, tools and manpower to remove the damaged water drain and install new galvanized steel pipe 76mm (3\") for roof of control rooms and switch gear hall building , with all connections and accessories to fix with the roof and wall, as well as all needed works to complete the job."]
["I3","Ceramic lavatory pedestal","EA",1,null,{"$f":"E108*D108","v":0}]
[null,"Supply of  materials, tools and manpower to install ceramic lavatory pedestal (1 sink), mixer taps, locks valves, mirror and all needed accessories with complete water connections. All needed works to complete the job, will be included within the price."]
["I4","Reinstall Eastern style toilet","EA",2,null,{"$f":"E110*D110","v":0}]
[null,"Supply of materials, tools and manpower to remove the damaged eastern style toilets and install new ceramic eastern style toilets, with flushing water tanks, all accessories and water connection. All needed works to complete the job, shall be included within the price."]
["I5","Siphon","EA",3,null,{"$f":"E112*D112","v":0}]
[null,"Supply 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."]
["I6","Taps","EA",6,null,{"$f":"E114*D114","v":0}]
[null,"Supply of all necessary materials, tools and manpower to connect chrome water taps 1/2\" or 3/4\" and to install water connections. All needed works to complete the job, will be included within the price."]
["I7","Sewerage cleaning","LS",1,null,{"$f":"E116*D116","v":0}]
[null,"Supply of materials, machine and manpower to clean the sewerage pipes net, starting from the sanitary units, manholes to the main septic tank using high pressure air/water. The work includes replace the damaged manhole covers with new ones, as well as all needed works to complete the job."]
["SUB TOTAL FOR SANITARY WORK",{"$nulls":4},{"$f":"SUM(F104:F117)","v":0}]
["Subtotal for Renovation of switch gear hall & control rooms building",{"$nulls":4},{"$f":"F74+F81+F96+F101+F118","v":0}]
[]
[]
[2,"Renovation of ( service building )  "]
[]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"CIVIL WORKS"]
["DIVISION A - EXCAVATION & EARTH WORK "]
["A","  Price for Excavation items shall include the removal of any buried structure not part to be part of the proposed construction, including transport of excavated , surplus materials and buried structure (not part of the proposed construction ) from the site to a dump site approved by the relevant authority."]
["A1","Clearing, grubbing, stripping and leveling","L.S.",1,null,{"$f":"D128*E128","v":0}]
[null,"      Construction areas shall be cleared of  the damaged building to at least a depth of 20 cm and cleared of structure, pavement, sidewalks, concrete or masonry debris, trees, logs, upturned stumps, loose boulders, and any other objectionable material of any kind which would interfere with the performance or completion of the work, create a hazard to safety, or impair the subsequent usefulness of the work, or obstruct its operation . the work includes  removing all rubble and debris from the site to a dump site approved by the relevant authority.  All needed works to complete the job, shall be included within the price. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["A2","Excavation for footing :         ","m3",147,null,{"$f":"D130*E130","v":0}]
[null,"   Supply materials, tools, machinery and manpower for the excavation of  the building the  , with excavation range (0.5-1)m and remove all rubble and debris to outside the municipality boundaries to a dump site approved by the relevant authority. The works include compaction of the excavated area to be ready for the works by using suitable compactors and the bed of the excavated area should be cleaned and leveled the works in accordance with technical specifications. All needed works to complete the job, shall be included within the price. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["A3","Backfilling with sub base material :    ","M3",147,null,{"$f":"D132*E132","v":0}]
[null,"      Supply materials and manpower to fill with subbase materials in layers not exceeding max.25cm thickness to reach the required level for the streets and special yard including service building yard , well compacted to 95% modified proctor, and each layer shall be tested and approved by the construction laboratory. All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR EXCAVATION AND EARTH WORK",{"$nulls":4},{"$f":"SUM(F128:F133)","v":0}]
["DIVISION B - CONCRETE WORK"]
["B","Concrete works  "]
["B1","Blinding concrete for raft foundation  : "]
[null,"  Supply materials and manpower to cast plain concrete with compressive strength 21 Mpa by using cement- resistant salts , with 10 cm minimum thickness to the required elevations. All needed works to complete the job, shall be included within the price.  Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)","m2",110,null,{"$f":"D138*E138","v":0}]
["B2","Reinforced concrete for raft foundation :","m3",60,null,{"$f":"D139*E139","v":0}]
[null,"    Supply materials  and manpower to cast reinforced concrete at least 30 cm thickness,(14x14)m raft foundation dimension  with compressive strength 30 MPa. The work shall include provision of reinforcement bars and all needed for the job. All needed works to complete the job, shall be included within the price.   Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["B3","Reinforced concrete for the slab ,beams ,parapets , lintels, stairs and columns: ","m3",72,null,{"$f":"D141*E141","v":0}]
[null,"    Supply materials  and manpower to casting  fair face reinforced concrete at for the slab, beams, tie beams,  stairs , parapets, lintels and columns (according to the details for different sections).with compressive strength 30 MPa.  Formwork and reinforcement shall be included in the work with All needed works to complete the job, shall be included within the price.  Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["B4","Plain concrete for flooring under tiles : ","m2",155,null,{"$f":"D143*E143","v":0}]
[null,"   Supply materials and manpower to cast plain concrete 10cm thickness with compressive strength 21 MPa for floors under tiles of the external sidewalk .All needed works to complete the job, shall be included within the price. "]
["B5","Plain concrete for DPC : ","ML",100,null,{"$f":"D145*E145","v":0}]
[null,"   Supply materials and manpower to cast plain concrete 20cm thickness with compressive strength 21 MPa for DPC of wall . Using fare face of  formworks. All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR CONCERET WORK",{"$nulls":4},{"$f":"SUM(F138:F146)","v":0}]
["DIVISION C -FENCE WALL , SUN SHADE , HANDRAIL  OTHER WORKS"]
["C","Fence wall, Sun shade and other works"]
["C1","Masonry works under DPC wall  :  ","m3",43,null,{"$f":"D150*E150","v":0}]
[null,"     Supply of all necessary materials, tools and manpower for building solid block (15x20x40) cm  with 40 cm width and 60cm height under DPC , with cement sand mortar  1:3 in both sides, the wall shall be leveled vertically and horizontally , The price includes dumping of all debris and rubble to a site approved by local authorities, as well as all needed works to complete the job . All needed works to complete the job, shall be included within the price. "]
["C2","Masonry works upper DPC wall  :  ","m2",450,null,{"$f":"D152*E152","v":0}]
[null,"     Supply of all necessary materials, tools and manpower for building solid block (15x20x40) cm  with 20 cm width and 2.6 cm height upper DPC , with using cement sand mortar 1:3, the wall shall be leveled vertically and horizontally , The price includes dumping of all debris and rubble to a site approved by local authorities, as well as all needed works to complete the job . All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR FENCE WALL, SUNSHADE,HANDRAIL AND OTHER WORK",{"$nulls":4},{"$f":"SUM(F150:F153)","v":0}]
["DIVISION D -PLASTERING AND PAINTING WORKS"]
["D","Plastering and painting works"]
["D1","Cement plastering","m²",220,null,{"$f":"D157*E157","v":0}]
[null,"Supply of materials, tools and manpower to cement plastering of external walls , with cement: sand mortar 1:3 and  with 3 layers of cement plastering , first layer of slurry cement mortar ,second layer  must be used rough surface and final layer surface cement sand mortar , using aluminum vertical guide every 80cm . All needed works to complete the job will be included within the price. All needed works to complete the job, shall be included within the price. "]
["D2","Gypsum plastering","m²",150,null,{"$f":"D159*E159","v":0}]
[null,"Supply of all necessary materials, tools and manpower to gypsum plastering of internal walls in 2 layers minimum thickness 15mm. The work includes layer of plastic mesh on the area under the gypsum plastering , using aluminum vertical guide at each 80 cm for the walls . All needed works to complete the job, will be included within the price. All needed works to complete the job, shall be included within the price. "]
["D3","Plastic painting","m²",220,null,{"$f":"D161*E161","v":0}]
[null,"Supply of materials, tools and manpower to paint the exterior walls with three-layer of silicon (water proof) painting. The works 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. "]
["D4","Emulsion painting","m2",150,null,{"$f":"D163*E163","v":0}]
[null,"Supply of materials, tools and manpower to paint the interior and exterior walls, with 3 layers of emulsion painting. The job includes cleaning the walls and removing the dirt and dust before painting. All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR PLASTERING AND PAINTING  WORK",{"$nulls":4},{"$f":"SUM(F157:F164)","v":0}]
["DIVISION E -METAL WINDOWS AND  DOORS "]
["E","Windows, doors and steel works"]
["E1","Install PVC windows (1.5x2)m:","m²",65,null,{"$f":"D168*E168","v":0}]
[null,"  Supply of materials, tools, machineries and manpower to install PVC windows with dimensions (1.5x2)m and windows for ventilation (0.8x.06) m . Including anti-insects wire mesh, handle and crystal clear glass (6mm). All needed works to complete the job, will be included within the price.  "]
["E2","Burglar steel bars","m²",65,null,{"$f":"D170*E170","v":0}]
[null,"Supply of materials, tools and manpower for installing windows burglar bars for windows with dimensions (1.5x2.0m) and (0.6x0.8m), by using a square steel rod, 12mm. Including 2 layers of anti-rust and 1 layer of oil painting, as well as all needed works to complete the job. All needed works to complete the job, shall be included within the price.  DWG- Bulgar bar Detail"]
["E3","Install PVC doors (1x2)m:","EA",7,null,{"$f":"D172*E172","v":0}]
[null,"Supply of materials, tools and manpower to install new PVC doors (1x2m) .The price of work includes made of welded plastic elements supported from inside by steel plate with heavy hangers, door lock, handle, mortise, crystal clear glass (6mm), fixing a stopper on the floor or wall, as well as all needed works to complete the job. All needed works to complete the job, shall be included within the price. DWG-Detail of PVC  door(1.0x2.0)m"]
["E4","Install steel entrance door (1.5x2)m :","EA",1,null,{"$f":"D174*E174","v":0}]
[null,"    Supply of materials, tools and manpower to install (1.5x2)m size for entrance door  with decorations. the door supported by steel angles (25*25*3) mm  with new steel plate on double face, the door should be balance with easily close/open . The price of work includes, hinges, door locks , mortise, fixing a stopper on the floor or wall, eye magic , painting of steel door by using anti-rust and 3 layers of oil painting, as well as all needed works to complete the job. DWG-Double Face Steel Door"]
["SUB TOTAL FOR METAL WINDOWS AND DOORS WORK",{"$nulls":4},{"$f":"SUM(F168:F175)","v":0}]
["DIVISION F- ROOFING , CLADDING , CEILING AND TILING WORKS"]
["F","Roofing, Cladding, Ceiling and Tilling works"]
["F1","Roofing works:","m2",196,null,{"$f":"D179*E179","v":0}]
[null,"   Supply materials and manpower for roofing work by cleaning the concrete roof. The waterproof layers shall be built as follows: paint of two opposite layers of bitumen, two opposite layers of bitumen felt 4 mm thickness with minimum overlap of 10 cm, thermal insulation materials with compressed Styrofoam sheet 5 cm thickness, then paint of two opposite layers of bitumen, fine aggregate with cement above the compressed Styrofoam layer  minimum  5 cm thickness layer with slope ( 1:10)  to storm water drainage, mosaic tiles (40*40) grade 4, filling the joints with white cement , and implementing  joints 2 cm width for  filling it with sealant mastic with square area not more than ( 4*4)m. Price of the work shall  include all requirements to complete the job. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["F2","Lime Stone Sills for windows and entrance door :","ML",81,null,{"$f":"D181*E181","v":0}]
[null,"   Supplying materials, tools and manpower to  apply lime stone sill  for windows and entrance door, lime stone sill should be 5cm thickness and 40 cm width using cement: sand  mortar (1:3) .All needed works to complete the job, shall be included within the price. "]
["F3","Ceramic for walls (1.2 m height) :","m²",100,null,{"$f":"D183*E183","v":0}]
[null,"      Supply of materials, tools and manpower to place a new ceramic (30x60) cm at least 8 mm thick ,1.2m height, with cement: sand mortar(1:2). The price of works includes expansion joints, as well as all needed works to complete the job. "]
["F4","Tiling sanitary walls for kitchen and bathroom","m²",100,null,{"$f":"D185*E185","v":0}]
[null,"  Supply and install of wall ceramic tiles (25x40x1)cm for the sanitary and kitchen walls, the water absorption shall be 10 to 15%. The price of works includes expansion joints, with cement: sand mortar(1:2), as well as all needed works to complete the job. All needed works to complete the job, shall be included within the price. "]
["F5","Tiling Ceramic  floors for bathroom :","m2",9,null,{"$f":"D187*E187","v":0}]
[null,"   Supply of materials, tools and manpower for the bathroom floor tiles , size (30x30 ) cm , grade 4 on a layer of at least 3cm cement: sand mortar( 1:3), and filling the joints with white cement and  polishing the Ceramic tiles , the water absorption shall be 0.5 to 0.9% , with approved quality and color. The price include the all the material needed to install , as well as all needed works to complete the job. All needed works to complete the job, shall be included within the price. "]
["F6","Tiling mosaic floors for room , kitchen and corridor  :","m2",140,null,{"$f":"D189*E189","v":0}]
[null,"   Supply of materials, tools and manpower for the  room, kitchen and corridor , size (30x30 ) cm , grade 4 on a layer of at least 3cm cement sand mortar 1:3, and filling the joints with white cement and  polishing the mosaic tiles for  room kitchen and corridor  , the water absorption shall be 0.5 to 0.9% , with approved quality and color. The price include the all the material needed to install , as well as all needed works to complete the job. All needed works to complete the job, shall be included within the price. "]
["F7","Granit board for  steps/treads of entrance building stair :","EA",4,null,{"$f":"D191*E191","v":0}]
[null,"Supply and install of granite board of  3 cm thickness for the tread,  2cm for the riser, 30cm width and 2.5 m length with 3cm nose , and grooving external edge . and cement mortal (1:2) including cement and sand mortar bed, cutting, fittings, trims, curve edges, pointing with stock, polished & glazed mechanically on site after installation, and dumping of all debris to a site approved by local authorities, in case it is needed cleaning.  All needed works to complete the job, shall be included within the price. "]
["F8","Granit board for  steps/treads of  internal stair :","EA",21,null,{"$f":"D193*E193","v":0}]
[null,"Supply and install of granite board of  3 cm thickness for the tread,  2cm for the riser, 30cm width and 1.2 m length with 3cm nose , and grooving external edge . and cement mortal (1:2) including cement and sand mortar bed, cutting, fittings, trims, curve edges, pointing with stock, polished & glazed mechanically on site after installation, and dumping of all debris to a site approved by local authorities, in case it is needed cleaning, as well as all needed works to complete the job. All needed works to complete the job, shall be included within the price. "]
["F9","Gypsum suspended ceiling","m²",100,null,{"$f":"D195*E195","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Gypsum boards) for rooms in control building. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["F10","Plastic suspended ceiling","m²",35,null,{"$f":"D197*E197","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Plastic boards) for rooms in control building. 6mm thickness. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["SUB TOTAL FOR ROOFING ,CLADDING, TILING WORK",{"$nulls":4},{"$f":"SUM(F179:F198)","v":0}]
["DIVISION G -FENCE WALL , SUN SHADE , HANDRAIL  OTHER WORKS"]
["G","Fence wall, Sun shade and other works"]
["G1","Aluminum Handrails","ML",15,null,{"$f":"D202*E202","v":0}]
[null,"Supply of materials, tools and manpower to install Aluminum Handrails for internal stair  in switch gear building , handrails sections of pipe measuring 2 inch and  use 90 cm height of Handrails . All needed works to complete the job, will be included within the price."]
["SUB TOTAL FOR FENCE WALL, SUNSHADE,HANDRAIL AND OTHER WORK",{"$nulls":4},{"$f":"SUM(F202)","v":0}]
["DIVISION I -SANITARY  WORKS"]
["I","Sanitary works"]
["I1","Water tank : ","EA",2,null,{"$f":"D207*E207","v":0}]
[null,"    Supply of necessary materials, tools and manpower for installing galvanized water tank of 1400 liter of capacity. Cylindrical shape and with plate gauge 16(1.59mm) , supported by steel base made with 50mm (2\") angle shape, including the connection of the inlet and outlet pipes. The price of works includes all piping and fittings, valves, float valves, accessories as well as all needed works to complete the job."]
["I2","PPR water pipe from source to building :    ","ML",25,null,{"$f":"D209*E209","v":0}]
[null,"   Supplying materials , tools and manpower  to install 1\" dia pipe for cold water  from the major net to the station. The work includes all pipe fittings, connection works and all accessories . All needed works to complete the job, shall be included within the price. "]
["I3","Install galvanized steel pipes","ML",40,null,{"$f":"D211*E211","v":0}]
[null,"   Supply of materials, tools and manpower to install galvanized steel pipe 1/2\" (13mm) and 3/4\" (19mm) for external water net connection (hot cold), by covering the network with concrete. The price of works includes all necessary accessories needed, as well as all needed works to complete the job . All needed works to complete the job, shall be included within the price."]
["I4","PPR water pipes :    ","ML",40,null,{"$f":"D213*E213","v":0}]
[null,"    Supplying materials , tools and manpower  to install (Hot & Cold) 3/4\" dia to bathrooms and kitchen. The work includes all pipe fittings, connection works and all accessories . All needed works to complete the job, shall be included within the price. "]
["I5","Ceramic lavatory pedestal","EA",1,null,{"$f":"E215*D215","v":0}]
[null,"Supply of  materials, tools and manpower to install ceramic lavatory pedestal (1 sink), mixer taps, locks valves, mirror and all needed accessories with complete water connections. All needed works to complete the job, will be included within the price."]
["I6","Install Eastern style toilet","EA",1,null,{"$f":"E217*D217","v":0}]
[null,"Supply of materials, tools and manpower to install new ceramic eastern style toilets, with flushing water tanks, all accessories and water connection. All needed works to complete the job, shall be included within the price."]
["I7","Ceramic shower","EA",1,null,{"$f":"E219*D219","v":0}]
[null,"Supply of materials, tools and manpower to install ceramic shower (80x80cm), mixer taps, locks valves and all needed accessories with complete water connections. All needed works to complete the job, shall be included within the price."]
["I8","Shower head and mixer taps","EA",1,null,0]
[null,"Supply of materials, tools and manpower to install mixer taps with shower head, locks and all needed accessories for completing water connections. All needed works to complete the job, shall be included within the price."]
["I9","Taps","EA",3,null,{"$f":"E223*D223","v":0}]
[null,"Supply of all necessary materials, tools and manpower to connect chrome water taps 1/2\" or 3/4\" and to install water connections. All needed works to complete the job, will be included within the price."]
["I10","Installation of Kitchen Sink (single basin)with two wings:","EA",1,null,{"$f":"E225*D225","v":0}]
[null,"    Supplying materials , tools and manpower to install  Sink (single basin)with two wings, stainless steel, anti corrosion ,excellent type of gutter and pipe drainage, fixed on aluminum counter  2mlength and 60 cm width with drawers and chrome mixer 0.5 inch. All needed works to complete the job, shall be included within the price. "]
["I11","Storm pipes","ML",15,null,{"$f":"E227*D227","v":0}]
[null,"Supply of materials, tools and manpower to install new galvanized steel pipe 76mm (3\") for roof of  building , with all connections and accessories to fix with the roof and wall, as well as all needed works to complete the job."]
["I12","Sewer system pipes 4 inch (PVC)  :","ML",15,null,{"$f":"E229*D229","v":0}]
[null,"  Supply material, install P.V.C  sewer pipes, applied pressure 6 bar ,4\" dia for wash basin in the kitchen W.C and bathroom , with all required fittings for connection and rubber jointing, the work include all civil works from excavation, filling . All needed works to complete the job, shall be included within the price. "]
["I13","Sewer system pipes 6 inch (PVC) out side building :","ML",40,null,{"$f":"D231*E231","v":0}]
[null,"     Supply material, install P.V.C sewer pipes, applied pressure 6 bar , 6\" dia form the building to manholes, with all required fittings for connection and rubber jointing, the work include all civil works excavation, filling and covering pipe with 15cm concrete. All needed works to complete the job, shall be included within the price. "]
["I14","Floor Drain (15*15) cm:          ","EA",5,null,{"$f":"D233*E233","v":0}]
[null,"     Supply materials and manpower to install and inspect floor drain (15*15) cm with cover from (stainless steel) 4 inch. The work include UPVC trap dimeter 4 inch with all pipes and fittings and all requirement to complete a good work. All needed works to complete the job, shall be included within the price. "]
["I15"," Manholes(40cm*40cm): ","EA",5,null,{"$f":"D235*E235","v":0}]
[null,"   Supplying materials , tools and manpower to build manholes dimension 40×40 cm by using solid block(15X20X40) cm  and cement mortar(1: 3) and cement plastering from inside and outside, with cover from cast iron with cast iron frame fixed in concrete slab of manhole . All needed works to complete the job, shall be included within the price. DWG-Detail of the Manhole"]
["SUB TOTAL FOR SANITARY WORK",{"$nulls":4},{"$f":"SUM(F207:F236)","v":0}]
["Subtotal for renovation of Service Building",{"$nulls":4},{"$f":"F134+F147+F154+F165+F176+F199+F204+F237","v":0}]
[]
[]
[3,"Renovation of ( Guard house building )  "]
[]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"CIVIL WORKS"]
["DIVISION A - EXCAVATION & EARTH WORK "]
["A","  Price for Excavation items shall include the removal of any buried structure not part to be part of the proposed construction, including transport of excavated , surplus materials and buried structure (not part of the proposed construction ) from the site to a dump site approved by the relevant authority"]
["A1","Clearing, grubbing, stripping and leveling","L.S.",1,null,{"$f":"D247*E247","v":0}]
[null,"      Construction areas shall be cleared of  the damaged building to at least a depth of 20 cm and cleared of structure, pavement, sidewalks, concrete or masonry debris, trees, logs, upturned stumps, loose boulders, and any other objectionable material of any kind which would interfere with the performance or completion of the work, create a hazard to safety, or impair the subsequent usefulness of the work, or obstruct its operation . The work includes removing all rubble and debris from the site to a dump site approved by the relevant authority.  All needed works to complete the job, shall be included within the price. "]
["A2","Excavation for footing :         ","m3",60,null,{"$f":"D249*E249","v":0}]
[null,"   Supply materials, tools, machinery and manpower for the excavation of footing for the building, with excavation range (0.5-1)m and remove all rubble and debris to outside the municipality boundaries to a dump site approved by the relevant authority. The works include compaction of the excavated area to be ready for the works by using suitable compactors and the bed of the excavated area should be cleaned and leveled the works in accordance with technical specifications. All needed works to complete the job, shall be included within the price. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["A3","Backfilling with sub base material :    ","M3",60,null,{"$f":"D251*E251","v":0}]
[null,"     Supply materials and manpower to fill with subbase materials in layers not exceeding max.25cm thickness to reach the required level for the streets and special yard including service building yard , well compacted to 95% modified proctor, and each layer shall be tested and approved by the construction laboratory. All the work in accordance with technical specifications. All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR EXCAVATION AND EARTH WORK",{"$nulls":4},{"$f":"SUM(F247:F252)","v":0}]
["DIVISION B - CONCRETE WORK"]
["B","Concrete works  "]
["B1","Blinding concrete for raft foundation : "]
[null,"  Supply materials and manpower to cast plain concrete with compressive strength 21 Mpa by using cement- resistant salts , with 10 cm minimum thickness to the required elevations. All the work in accordance with technical specifications .All needed works to complete the job, shall be included within the price. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)","m2",78,null,{"$f":"D257*E257","v":0}]
["B2","Reinforced concrete for raft foundation :","m3",25,null,{"$f":"D258*E258","v":0}]
[null,"    Supply materials  and manpower to cast reinforced concrete at least 30 cm thickness,(13*6)m raft foundation dimension  with compressive strength 30 MPa. Reinforcement bar and formwork shall be included. All needed works to complete the job, shall be included within the price. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["B3","Reinforced concrete for the slab ,beams ,parapets , lintels, stairs and columns: ","m3",30,null,{"$f":"D260*E260","v":0}]
[null,"    Supply materials  and manpower to casting  fair face reinforced concrete at for the slab, beams, tie beams, parapets, lintels and columns (according to the details for different sections) with compressive strength 30 MPa. The work shall include reinforcement , formwork provision for all the works. All needed works to complete the job, shall be included within the price .Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["B4","Plain concrete for flooring under tiles : ","m2",60,null,{"$f":"D262*E262","v":0}]
[null,"   Supply materials and manpower to cast plain concrete 10cm thickness with compressive strength 21 MPa for floors under tiles of the external sidewalk .All needed works to complete the job, shall be included within the price. "]
["B5","Plain concrete for DPC : ","ML",60,null,{"$f":"D264*E264","v":0}]
[null,"   Supply materials and manpower to cast plain concrete 20cm thickness with compressive strength 21 MPa for DPC of wall . Using fair face of formworks .All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR CONCERET WORK",{"$nulls":4},{"$f":"SUM(F256:F265)","v":0}]
["DIVISION D -FENCE WALL , SUN SHADE , HANDRAIL  OTHER WORKS"]
["C","Fence wall, Sun shade and other works"]
["C1","Masonry works under DPC wall  :  ","m3",25,null,{"$f":"D269*E269","v":0}]
[null,"     Supply of all necessary materials, tools and manpower for building solid block (15x20x40) cm  with 40 cm width and 60cm height under DPC , with cement sand mortar 1:3 on both sides, the wall shall be leveled vertically and horizontally , The price includes dumping of all debris and rubble to a site approved by local authorities, as well as all needed works to complete the job . All needed works to complete the job, shall be included within the price. "]
["C2","Masonry works upper DPC wall  :  ","m2",170,null,{"$f":"D271*E271","v":0}]
[null,"     Supply of all necessary materials, tools and manpower for building solid block (15x20x40) cm  with 20 cm width and 2.6 cm height upper DPC , with using cement sand mortar 1:3, the wall shall be leveled vertically and horizontally , The price includes dumping of all debris and rubble to a site approved by local authorities, as well as all needed works to complete the job . all the work in accordance with technical specifications ."]
["SUB TOTAL FOR FENCE WALL, SUNSHADE,HANDRAIL AND OTHER WORK",{"$nulls":4},{"$f":"SUM(F269:F272)","v":0}]
["DIVISION D -PLASTERING AND PAINTING WORKS"]
["D","Plastering and painting works"]
["D1","Cement plastering","m²",130,null,{"$f":"D276*E276","v":0}]
[null,"Supply of materials, tools and manpower to cement plastering of external walls , with cement: sand mortar 1:3 and  with 3 layers of cement plastering , first layer of slurry cement mortar ,second layer  must be used rough surface and final layer surface cement sand mortar , using aluminum vertical guide at every 80cm . All needed works to complete the job will be included within the price. "]
["D2","Gypsum plastering","m²",60,null,{"$f":"D278*E278","v":0}]
[null,"Supply of all necessary materials, tools and manpower to gypsum plastering of internal walls in 2 layers minimum thickness 15mm. The work includes layer of plastic mesh on the area under the gypsum plastering , using aluminum vertical guide at each 80 cm for the walls . All needed works to complete the job, will be included within the price."]
["D3","Plastic painting","m²",130,null,{"$f":"D280*E280","v":0}]
[null,"Supply of materials, tools and manpower to paint the exterior walls with three-layer of silicon (water proof) painting. The works 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."]
["D4","Emulsion painting","m2",60,null,{"$f":"D282*E282","v":0}]
[null,"Supply of materials, tools and manpower to paint the interior and exterior walls, with 3 layers of emulsion painting. The job includes cleaning the walls and removing the dirt and dust before painting. All needed works to complete the job, shall be included within the price. "]
["SUB TOTAL FOR PLASTERING AND PAINTING  WORK",{"$nulls":4},{"$f":"SUM(F276:F283)","v":0}]
["DIVISION E -METAL WINDOWS AND  DOORS "]
["E","Windows, doors and steel works"]
["E1","Install PVC windows ( 1.5x2)m:","m²",13,null,{"$f":"D287*E287","v":0}]
[null,"  Supply of materials, tools, machineries and manpower to install PVC windows with dimensions (1.5x2)m and windows for ventilation (0.6x0.8) m . Including anti-insects wire mesh, handle and crystal clear glass (6mm). All needed works to complete the job, will be included within the price.  DWG-Detail of PVC  door(1.0x2.0)m"]
["E2","Burglar steel bars","m²",13,null,{"$f":"D289*E289","v":0}]
[null,"Supply of materials, tools and manpower for installing windows burglar bars for windows with dimensions (1.5x2.0m) and (0.6x0.8m), by using 12mm square steel, 2 cm thickness. Including 2 layers of anti-rust and 1 layer of oil painting, as well as all needed works to complete the job. DWG- Bulgar bar Detail"]
["E3","Install PVC doors (1x2)m:","EA",5,null,{"$f":"D291*E291","v":0}]
[null,"Supply of materials, tools and manpower to install new PVC doors (1x2m) .The price of work includes made of welded plastic elements supported from inside by steel plate with heavy hangers, door lock, handle, mortise, crystal clear glass (6mm), fixing a stopper on the floor or wall, as well as all needed works to complete the job.  DWG-Detail of PVC  door(1.0x2.0)m"]
["E4","Install steel entrance door  (1.5x2)m:","EA",1,null,{"$f":"D293*E293","v":0}]
[null,"    Supply of materials, tools and manpower to install (1.5x2)m size for entrance door  with ready Inscriptions . The door supported by steel angles (25*25*3) mm . Covered with new steel plate on double face . The door should be balance with easily close/open . The price of work includes, hinges, door locks , mortise, fixing a stopper on the floor or wall, eye magic , painting of steel door by using anti-rust and 3 layers of oil painting, as well as all needed works to complete the job. DWG-Double Face Steel Door"]
["E4","Steel ladder for guard house roof :","EA",1,null,{"$f":"D295*E295","v":0}]
[null,"     Supply materials and manpower to install a steel ladder by using  square steel pipe (50*50*3) mm for the external hall of control  and fixing with the floor by Steel Plate and screws . The work includes  painting with 3 layers using anti-rust and oil paints. All needed works to complete the job, shall be included within the price. DWG-Detail of Steel Ladder"]
["SUB TOTAL FOR METAL WINDOWS AND DOORS WORK",{"$nulls":4},{"$f":"SUM(F287:F296)","v":0}]
["DIVISION F- ROOFING , CLADDING , CEILING AND TILING WORKS"]
["F","Roofing, Cladding, Ceiling and Tilling works"]
["F1","Roofing works:","ML",78,null,{"$f":"D300*E300","v":0}]
[null,"   Supply materials and manpower for roofing work by cleaning the concrete roof. The waterproof layers shall be built as follows: paint of two opposite layers of bitumen, two opposite layers of bitumen felt 4 mm thickness with minimum overlap of 10 cm, thermal insulation materials with compressed Styrofoam sheet 5 cm thickness, then paint of two opposite layers of bitumen, fine aggregate with cement above the compressed Styrofoam layer  minimum  5 cm thickness layer with slope ( 1:10)  to storm water drainage, mosaic tiles (40*40) grade 4, filling the joints with white cement , and implementing  joints 2 cm width for  filling it with sealant mastic with square area not more than ( 4*4)m. Price of the work shall  include all requirements to complete the job. Bab Ishtar substation drawings ( guard hose service buildings).compressed (002)"]
["F2","Lime Stone Sills for windows and entrance door :","ML",42,null,{"$f":"D302*E302","v":0}]
[null,"   Supplying materials, tools and manpower to  apply limestone sill  for windows and entrance door, lime stone sill should be 5cm thickness and 40 cm width , using cement: sand  mortar (1:3) .All needed works to complete the job, shall be included within the price. "]
["F3","Ceramic for walls (1.2 m height) :","m²",40,null,{"$f":"D304*E304","v":0}]
[null,"      Supply of materials, tools and manpower to place a new ceramic of size(30x60) cm at least 8 mm thick ,1.2m height, with cement: sand mortar(1:2). The price of works includes expansion joints, as well as all needed works to complete the job. "]
["F4","Tiling sanitary walls for kitchen and bathroom","m²",100,null,{"$f":"D306*E306","v":0}]
[null,"  Supply and install of ceramic tiles (25x40x1)cm for the sanitary and kitchen walls, the water absorption shall be 10 to 15%. The price of works includes expansion joints, with cement: sand mortar(1:2).All needed works to complete the job, shall be included within the price. "]
["F5","Tiling Ceramic  floors for bathroom :","m2",15,null,{"$f":"D308*E308","v":0}]
[null,"   Supply of materials, tools and manpower for the bathroom floor tiles , size (30x30 ) cm , grade 4 on a layer of at least 3cm cement: sand mortar( 1:3), and filling the joints with white cement and  polishing the Ceramic tiles, the water absorption shall be 0.5 to 0.9% , with approved quality and color. The price shall include all the material needed to install , as well as all needed works to complete the job."]
["F6","Tiling mosaic floors for room , kitchen and corridor  :","m2",40,null,{"$f":"D310*E310","v":0}]
[null,"   Supply of materials, tools and manpower for the  room , kitchen and corridor , size (30x30 ) cm , grade 4 on a layer of at least 3cm cement sand mortar 1:3, and filling the joints with white cement and  polishing the mosaic tiles for room kitchen and corridor  , the water absorption shall be 0.5 to 0.9% , with approved quality and color. The price include the all the material needed to install , as well as all needed works to complete the job. "]
["F7","Granit board for  steps/treads of entrance building stair :","EA",4,null,{"$f":"D312*E312","v":0}]
[null,"Supply and install of granite board of  3 cm thickness for the tread,  2cm for the riser, 30cm width and 2.5 m length with 3cm nose , and grooving external edge . and cement mortal (1:2) including cement and sand mortar bed, cutting, fittings, trims, curve edges, pointing with stock, polished & glazed mechanically on site after installation, and dumping of all debris to a site approved by local authorities, in case it is needed cleaning, as well as all needed works to complete the job."]
["F9","Gypsum suspended ceiling","m²",100,null,{"$f":"D314*E314","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Gypsum boards) for rooms in control building. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["F10","Plastic suspended ceiling","m²",35,null,{"$f":"D316*E316","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Plastic boards) for rooms in control building. 6mm thickness. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["SUB TOTAL FOR ROOFING ,CLADDING, TILING WORK",{"$nulls":4},{"$f":"SUM(F300:F317)","v":0}]
["DIVISION I -SANITARY  WORKS"]
["I","Sanitary works"]
["I1","Water tank : ","EA",2,null,{"$f":"D321*E321","v":0}]
[null,"    Supply of necessary materials, tools and manpower for installing galvanized water tank of 1400 liter of capacity. Cylindrical shape and with plate gauge 16 ( 1.59mm) , supported by steel base made with 50mm (2\") angle shape, including the connection of the inlet and outlet pipes. The price of works includes all piping and fittings, valves, float valves, accessories as well as all needed works to complete the job."]
["I2","PPR water pipe from source to building :    ","ML",25,null,{"$f":"D323*E323","v":0}]
[null,"   Supplying materials , tools and manpower  to install 1\" diam pipe for cold water  from the major network to the station. The work includes all pipe fittings, connection works and all accessories to complete the work. All needed works to complete the job, shall be included within the price. "]
["I3","Install galvanized steel pipes","ML",25,null,{"$f":"D325*E325","v":0}]
[null,"   Supply of materials, tools and manpower to install galvanized steel pipe 1/2\" (13mm) and 3/4\" (19mm) for external water network connection (hot cold), including covering the network with concrete. The price of works includes all necessary accessories needed, as well as all needed works to complete the job . All needed works to complete the job, shall be included within the price. "]
["I4","PPR water pipes :    ","ML",35,null,{"$f":"D327*E327","v":0}]
[null,"         Supplying materials , tools and manpower  to install (Hot & Cold) 3/4\" dia to bathrooms and kitchen. The work includes all pipe fittings, connection works and all accessories and requirements to complete the job."]
["I5","Ceramic lavatory pedestal","EA",1,null,{"$f":"E329*D329","v":0}]
[null,"Supply of  materials, tools and manpower to install ceramic lavatory pedestal (1 sink), mixer taps, locks valves, mirror and all needed accessories with complete water connections. All needed works to complete the job, will be included within the price."]
["I6","Install Eastern style toilet","EA",1,null,{"$f":"E331*D331","v":0}]
[null,"Supply of materials, tools and manpower to install new ceramic eastern style toilet, with flushing water tanks, all accessories and water connection. All needed works to complete the job, shall be included within the price."]
["I7","Ceramic shower","EA",1,null,{"$f":"E333*D333","v":0}]
[null,"Supply of materials, tools and manpower to install ceramic shower (80x80cm), mixer taps, locks valves and all needed accessories with complete water connections. All needed works to complete the job, shall be included within the price."]
["I8","Shower head and mixer taps","EA",1,null,0]
[null,"Supply of materials, tools and manpower to install mixer taps with shower head, locks and all needed accessories for completing water connections. All needed works to complete the job, shall be included within the price."]
["I9","Taps","EA",2,null,{"$f":"E337*D337","v":0}]
[null,"Supply of all necessary materials, tools and manpower to connect chrome water taps 1/2\" or 3/4\" and to install water connections. All needed works to complete the job, will be included within the price."]
["I10","Installation of Kitchen Sink (single basin)with two wings:","EA",1,null,{"$f":"E339*D339","v":0}]
[null,"    Supplying materials , tools and manpower to install  Sink (single basin)with two wings, stainless steel, anti corrosion ,excellent type of gutter and pipe drainage, fixed on aluminum counter  2m length and 60 cm width with drawers and chrome mixer 0.5 inch. All needed works to complete the job, shall be included within the price.  "]
["I11","Storm pipes","ML",7,null,{"$f":"E341*D341","v":0}]
[null,"Supply of materials, tools and manpower to install new galvanized steel pipe 76mm (3\") for roof of  building , with all connections and accessories to fix with the roof and wall, as well as all needed works to complete the job."]
["I12","Sewer system pipes 4 inch (PVC)  :","ML",15,null,{"$f":"E343*D343","v":0}]
[null,"  Supply material, install P.V.C  sewer pipes, applied pressure 6 bar ,4\" dia for wash basin in the kitchen, W.C and bathroom , with all required fittings for connection and rubber jointing, the work include all civil works from excavation, filling . All needed works to complete the job, shall be included within the price. "]
["I13","Sewer system pipes 6 inch (PVC) out side building :","ML",40,null,{"$f":"D345*E345","v":0}]
[null,"     Supply material, install P.V.C sewer pipes, applied pressure 6 bar , 6\" dia from the building to manholes, with all required fittings for connection and rubber jointing, the work include all civil works excavation, Filling and covering pipe with 15cm concrete. all the work in accordance with technical specifications."]
["I14","Floor Drain (15*15) cm:          ","EA",5,null,{"$f":"D347*E347","v":0}]
[null,"      Supply materials and manpower to install and inspect floor drain (15*15) cm with cover from (stainless steel) 4 inch. The work include UPVC trap dimeter 4 inch with all pipes and fittings and all requirement to complete a good work. All needed works to complete the job, shall be included within the price. "]
["I15"," Manholes(40cm*40cm): ","EA",5,null,{"$f":"D349*E349","v":0}]
[null,"   Supplying materials , tools and manpower to build manholes dimension 40×40 cm by using solid block(15X20X40) cm  and cement mortar(1: 3) and cement plastering from inside and outside, with cover from cast iron with cast iron frame fixed in concrete slab of manhole .All needed works to complete the job, shall be included within the price. DWG-Detail of the Manhole"]
["SUB TOTAL FOR SANITARY WORK",{"$nulls":4},{"$f":"SUM(F321:F350)","v":0}]
[null,"Subtotal for renovation of  Guard house building",null,null,null,{"$f":"F253+F266+F273+F284+F297+F318+F351","v":0}]
[]
[]
[4,"Renovation of ( Internal Yard , External Sidewalk & External fence )  "]
[]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"CIVIL WORKS"]
["DIVISION A - EXCAVATION & EARTH WORK "]
["A","  Price for Excavation items shall include the removal of any buried structure not part to be part of the proposed construction, including transport of excavated , surplus materials and buried structure (not part of the proposed construction ) from the site to a dump site approved by the relevant authority"]
["A1","Clearing, grubbing, stripping and leveling","L.S.",1,null,{"$f":"D361*E361","v":0}]
[null,"      Construction areas shall be cleared of grass and weeds to at least a depth of 20 cm and cleared of structures, pavement, sidewalks, concrete or masonry debris, trees, logs, upturned stumps, loose boulders, and any other objectionable material of any kind which would interfere with the performance or completion of the work, create a hazard to safety, or impair the subsequent usefulness of the work, or obstruct its operation . the work includes  removing all rubble and debris from the site to a dump site approved by the relevant authority.  All needed works to complete the job, shall be included within the price. "]
["A2","Excavation for Internal Yard & External Sidewalk:         ","m3",750,null,{"$f":"D363*E363","v":0}]
[null,"   Supply materials, tools, machinery and manpower for the excavation of  Internal Yard & External Sidewalk in the substation site , with excavation range (0.5-1)m and remove all rubble and debris to outside the municipality boundaries to a dump site approved by the relevant authority. The works include compaction of the excavated area to be ready for the works by using suitable compactors and the bed of the excavated area should be cleaned and leveled the works in accordance with technical specifications. All needed works to complete the job, shall be included within the price. "]
["A3","Excavation for Boundary wall  strip footing:         ","m3",28,null,{"$f":"D365*E365","v":0}]
[null,"   Supply materials, tools, machinery and manpower for the excavation of  Boundary Wall in the substation site , with excavation 70 cm width and 80cm depth  and remove all rubble and debris to outside the municipality boundaries to a dump site approved by the relevant authority. The works include compaction of the excavated area to be ready for the works by using suitable compactors and the bed of the excavated area should be cleaned and leveled the works in accordance with technical specifications. All needed works to complete the job, shall be included within the price. "]
["A4","Backfilling with sub base material for internal yard :    ","M3",848,null,{"$f":"D367*E367","v":0}]
[null,"       Supply materials and manpower to fill with subbase materials in layers not exceeding max.25cm thickness to reach the required level for the streets and special yard including service building yard , well compacted to 95% modified proctor, and each layer shall be tested and approved by the construction laboratory. All needed works to complete the job, shall be included within the price. "]
["A5","Filling with sub base material for the yard behind curbstone :\n     Supply materials and manpower for filling with subbase materials in layers not exceeding max.25cm thick to reach the required level for sidewalk and yard behind curbstone , well compacted to 95% modified proctor for each layer shall be tested and approved by the construction laboratory. All the work in accordance with technical specifications as per part 4- civil specifications, clause 1.4.All needed works to complete the job, shall be included within the price. ","m3",40,null,{"$f":"D369*E369","v":0}]
["SUB TOTAL FOR EXCAVATION AND EARTH WORK",{"$nulls":4},{"$f":"SUM(F361:F369)","v":0}]
["DIVISION B - CONCRETE WORK"]
["B","Concrete works  "]
["B1","Blinding concrete for boundary wall Stripe footing  : "]
[null,"  Supply materials and manpower to cast plain concrete with compressive strength 21 Mpa by using cement- resistant salts , with 10 cm minimum thickness to the required elevations. All needed works to complete the job, shall be included within the price. ","M3",4,null,{"$f":"D374*E374","v":0}]
["B2","Pre cast curbstone works with footing for internal yard substation:","ml",120,null,{"$f":"E375*D375","v":0}]
[null,"Supply of materials, tools, machinery and manpower to install curbstone for  internal yard substation. Including concrete brick of (40 × 10) cm base concrete under curbstone and 15*15 cm behind curbstone, parallel to the path or road, and according to levels. The price of the work shall include filling joints with mortar of cement sand 1:3  painting with plastic painting two color and two layers .All needed works to complete the job, shall be included within the price. "]
["B3","Reinforced concrete for internal yard :","m3",226,null,{"$f":"D377*E377","v":0}]
[null,"    Supply materials  and manpower to cast reinforced concrete grade C25 with one layer (25*25)cm  for steel reinforcement mesh, including giving proper slope ,Machinery troweling ,making joints provided with adequate transverse and longitudinal expansion and contraction joints shall be provided, with the joints using approved expansion and sealant. The work in accordance with technical specifications"]
["B4","Reinforce concrete for boundary wall stripe footing :","m3",48,null,{"$f":"D379*E379","v":0}]
[null,"  Supply materials and manpower to cast reinforced concrete foundation (40*60)cm with compressive strength 30 Mpa. Using 6 bar ( 3 in top , 3 in bottom ) of diameter 12mm with stirrups diameter of bar 10 mm @ 20 cm . All needed works to complete the job, shall be included within the price. "]
["B5","Plain concrete for flooring under tiles of the external sidewalk: ","m2",200,null,{"$f":"D381*E381","v":0}]
[null,"   Supply materials and manpower to cast plain concrete 10cm thickness with compressive strength C 20.7 MPa for floors under tiles of the external sidewalk .All needed works to complete the job, shall be included within the price. "]
["B6","Reinforce concrete for shoulders outside station:","M2",150,null,{"$f":"D383*E383","v":0}]
[null,"    Supply materials and manpower to cast concrete 15 cm thickness and  1.5 m width in front of the station with compressive strength C 20.7 Mpa of the shoulders outside station with the  slope(1/10) to the street. All needed works to complete the job, shall be included within the price. "]
["B7","Reinforce concrete for shoulders outside station:","m2",150,null,{"$f":"D385*E385","v":0}]
[null,"      Supply materials and manpower to cast concrete 15 cm thickness and  1.5 m width in front of the station with compressive strength C20.7Mpa of the shoulders outside station with the  slope(1/10) to the street. All needed works to complete the job, shall be included within the price. "]
["B8","Reinforced concrete casting for the footings and columns of the metal main door :","m3",2,null,{"$f":"D387*E387","v":0}]
[null,"Supply of materials, tools and manpower for concrete casting for columns  (C-30MPA) concrete, with (0.4*0.4*)m with height (3.75) m ( from the ground level ) for columns. The work shall include for concrete columns 4 reinforcement bars of 16 mm with Ties Ø 10 mm @ 300 mm ,  the work include a foundation for 2 columns ( 1.2*1.2*0.4) m , casting reinforced concrete ,use rebar (Ø 12mm @ 200mm) in 2 layer and 2 direction  . The price shall include the formworks, as well as all needed works to complete the job. DWG-Detail of column and  footing-1.2x1.2x0.3"]
["B9","Reinforced concrete base works for Street Lighting:","EA",8,null,{"$f":"D389*E389","v":0}]
[null,"   Supplying materials, tools and manpower to cast reinforced concrete of a light pole for internal yard and street , the concrete base  (60*60*80) cm dimensions , using 4 vertical reinforced diameter 16 mm and 5 rings  diameter 10 mm  Installation bolts screw 16 mm are fixed with the concrete base to be later connected with the lamppost  ."]
["SUB TOTAL FOR CONCERET WORK",{"$nulls":4},{"$f":"SUM(F374:F390)","v":0}]
["DIVISION D -FENCE WALL , SUN SHADE , HANDRAIL  OTHER WORKS"]
["C","Fence wall, Sun shade and other works"]
["C1","Masonry works under Ground level  for substation fence wall  :  ","m3",12,null,{"$f":"D394*E394","v":0}]
[null,"     Supply of all necessary materials, tools and manpower for building solid block (15x20x40) cm  with 40 cm width and 60cm height under Ground level , with cement sand mortar 1:3 in both sides, the wall shall be leveled vertically and horizontally. The price includes dumping of all debris and rubble to a site approved by local authorities, as well as all needed works to complete the job . "]
["C2","Masonry works upper ground level for substation fence wall  :  ","m2",140,null,{"$f":"D396*E396","v":0}]
[null,"     Supply of all necessary materials, tools and manpower for building solid block (15x20x40) cm  with 40 cm width and 60cm height under DPC , with cement sand mortar 1:3 in both sides, the wall shall be leveled vertically and horizontally. The price includes dumping of all debris and rubble to a site approved by local authorities, as well as all needed works to complete the job . "]
["SUB TOTAL FOR FENCE WALL, SUNSHADE,HANDRAIL AND OTHER WORK",{"$nulls":4},{"$f":"SUM(F394:F397)","v":0}]
["DIVISION D -METAL WINDOWS AND  DOORS "]
["D","Windows, doors and steel works"]
["D1","Reinstall steel doors  ( 1x2.2)m:","EA",1,null,{"$f":"D401*E401","v":0}]
[null,"Supply of materials, tools and manpower to remove old steel doors and reinstall (1.0x2.2)m size for entrance of the substation with ready Inscriptions. The door shall be supported by steel angles (25*25*3) mm with new steel plate on double face , the door should be balance with easily close/open . The price of work includes, hinges, door locks , mortise, fixing a stopper on the floor or wall, eye magic , painting of steel door by using anti-rust and 3 layers of oil painting, as well as all needed works to complete the job. DWG-Double Face Steel Door"]
["D2","Main exterior metal sliding door for the station(7x2)m:","EA",1,null,{"$f":"D403*E403","v":0}]
[null,"   Supply materials and manpower to install main external metal door for the station double face door(7*2) using plate gauge 16, with frame of steel angle (50*50*3)mm with steel rail for the sliding door and fixed with the reinforce concrete column of 20 cm  thickness. The price include  door lock, mortise, painting of steel door using 2 layers anti-rust and 3 layers of oil painting. All the work in accordance with technical specifications as per part 4-civil specifications, clause 2.10 and DWG-Steel Sliding Door Main  Gate-7.0x2.0m"]
["SUB TOTAL FOR METAL WINDOWS AND DOORS WORK",{"$nulls":4},{"$f":"SUM(F401:F404)","v":0}]
["DIVISION E -PLASTERING AND PAINTING WORKS"]
["E","Plastering and painting works"]
["E1","Cement plastering","m²",100,null,{"$f":"D408*E408","v":0}]
[null,"Supply of materials, tools and manpower to repair wall cracks and remove the damaged cement plastering of external walls by removing the damaged cement plastering minimum 10 cm at each side of the crack, then treat the cracks with crack filler approved by manufacture with cement mortar 1:3 and using SBR at a rate according to the product's instructions for the additive martial , later putting a layer of metal chicken mesh 10 cm overlap each side on the area with 3 layers of cement plastering , using aluminum vertical guide every 80cm ,  1:3. All needed works to complete the job, will be included within the price."]
["E2","Plastic painting","m²",100,null,{"$f":"D410*E410","v":0}]
[null,"Supply of materials, tools and manpower to paint the exterior walls with three-layer of silicon (water proof) painting. The works 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."]
["SUB TOTAL FOR PLASTERING AND PAINTING  WORK",{"$nulls":4},{"$f":"SUM(F408:F411)","v":0}]
["DIVISION F- ROOFING , CLADDING , CEILING AND TILING WORKS"]
["F","Roofing, Cladding, Ceiling and Tilling works"]
["F1","Lime Stone Sills above the boundary wall:","ML",200,null,{"$f":"D415*E415","v":0}]
[null,"   Supplying materials, tools and manpower to  apply lime stone sill above the boundary wall, lime stone sill should be 5cm thickness and 40 cm width in addition covering the columns of the main gate  using cement mortar. All the work in accordance with technical specifications ."]
["F2","Tiling floors for walkways :","m2",200,null,{"$f":"D417*E417","v":0}]
[null,"   Supply of materials, tools and manpower for the walk ways floor tiles , size (30x30 ) cm , grade 4 on a layer of at least 3cm cement sand mortar 1:3, and filling the joints with white cement and  polishing the music tiles for  sidewalk behind curbstone, the water absorption shall be 0.5 to 0.9% , with approved quality and color. The price include the all the material needed to install , as well as all needed works to complete the job. "]
["SUB TOTAL FOR ROOFING ,CLADDING, TILING WORK",{"$nulls":4},{"$f":"SUM(F415:F418)","v":0}]
["DIVISION G- DEMOLITION AND REPAIRING WORK"]
["G1","Septic tank reconstruction","EA",1,null,{"$f":"E421*D421","v":0}]
[null,"Supply of materials, tools and manpower to re-building the damaged septic tank of size (4.4 × 4.4) m , and a depth of 2.7 m, by removing the remnants of damage and then building walls with 40 cm thick solid blocks with mortar 1: 3 cement sand mix ratio. The first grade of the wall thickness shall be 40 cm with 15 cm thick mass concrete poured to the ground underneath the wall and leave a hole( 1*1)m of the septic tank  without casting. The work includes casting ceiling Pad (top slab) with reinforced concrete, steel bar 16 mm / 20 cm in both directions, manholes pull dimensions (40x40cm), and tube venting from pipe size 2.5m including plastering  the walls with one coat with cement sand mortar and coated by Bitumen. All needed works to complete the job, will be included within the price. DWG- Detail for Septic Tank"]
["G2","Repairing of  Reinforced concrete for the external cable trench floor and walls:","M3",5,null,{"$f":"D423*E423","v":0}]
[null,"  Supply materials and manpower to Repairing and cast fair face reinforced concrete with compressive strength 30 Mpa for the external cable trench  floors and walls , 1m width ,install plastic pipes (2.5,6,8)inch diameter in the wall with 20 cm thickness."]
["G3","Precast concrete cover (8*30*160)cm:","M2",10,null,{"$f":"D425*E425","v":0}]
[null,"    Supply materials  and manpower to cast reinforce concrete covers with (160*30*8)cm and reinforcement with one layer of rebar diameter 12 mm (20 cm) in both directions, make steel hook on top the  precast concrete to lifted and put it in proper place . All needed work for completion of the job , shall be included with in the price. "]
["G4","Manhole (60*60) cm for electrical:","EA",15,null,{"$f":"D427*E427","v":0}]
[null,"    Supply materials and manpower to install and inspect floor drain (60*60) cm with  checkered  plate cover. Price of the work shall include all the requirements to complete the job. DWG-Detail of the Manhole"]
["G5"," Manholes(40cm*40cm): ","EA",12,null,{"$f":"D429*E429","v":0}]
[null,"   Supplying materials , tools and manpower to build manholes dimension 40×40 cm by using solid block(15X20X40) cm  and cement mortar(1: 3) and cement plastering from inside and outside, with cover from cast iron with cast iron frame fixed in concrete slab of manhole .  Price of the work shall include all the requirements to complete the job. DWG-Detail of the Manhole"]
["SUB TOTAL FOR DEMOLISHING AND REPARING WORK",{"$nulls":4},{"$f":"SUM(F421:F430)","v":0}]
["DIVISION I -SANITARY  WORKS"]
["I","Sanitary works"]
["I1","PVC drain pipes for internal yard and concrete trenches   :  ","ML",80,null,{"$f":"D434*E434","v":0}]
[null,"      Supply of materials, tools and manpower to install P.V.C  sewer pipes, applied pressure 6 bar , 6\" dia from switch gear building and external trench to  manholes , with all required fittings for connection and rubber jointing, the work include all civil works from excavation, filling .  Price of the work shall include all the requirements to complete the job."]
["I2","PPR water pipes:    ","ML",80,null,{"$f":"D436*E436","v":0}]
[null,"   Supplying materials , tools and manpower  to install 1\" dia pipe for cold water  from the major network to the station. The work includes all pipe fittings, connection works and all accessories .  Price of the work shall include all the requirements to complete the job."]
["I3","Taps","EA",5,null,{"$f":"E438*D438","v":0}]
[null,"Supply of all necessary materials, tools and manpower to connect chrome water taps 1/2\" or 3/4\" and to install water connections. All needed works to complete the job, will be included within the price."]
["SUB TOTAL FOR SANITARY WORK",{"$nulls":4},{"$f":"SUM(F434:F439)","v":0}]
[null,"Subtotal for Renovation of ( Internal Yard , External Sidewalk & External fence )",null,null,null,{"$f":"F370+F391+F398+F405+F412+F419+F431+F440","v":0}]
[]
["C- Auxiliary Works"]
[]
["Substation Auxiliary Electrical & Mechanical System"]
["#","Item Description","Unit","Qty","Price (US $)","Total (US $)"]
[null,"Minimum Requierement for Supply, install, test and commission Auxiliary systems for Substation:\n1- All Equipment's and works should comply with (Technical Specification of 33-11kV substation construction, clause 3. Building Services, and all related sub Claus).\n2- Sample or catalogues for each of equipment's have to be submitted for approval. "]
[null,"Electrical Works"]
[1,"Lighting, Fan, Exhaust Fan and Sockets Installation"]
[null," Supply materials, Installation and operation for Substation auxiliary Electric system,  \n"]
[1.1000000000000001,"Antiacid Exhaust fan size 10\" dia., wall mounting with fly mesh protection for battery room.","No.",2,null,{"$f":"E451*D451","v":0}]
[1.2,"Exhaust fan size 16\" dia., wall mounting with fly mesh protection","No.",2,null,{"$f":"D452*E452","v":0}]
[1.3,"LED Lighting Fixture 230 VAC, (52 W),(60cm*60cm), metal frame with transformer.","L.S.",37,null,{"$f":"D453*E453","v":0}]
[1.4,"Simple Fluorescent Lighting Fixture 230VAC, 2x40 W, 4 feet, Surface mounting or wall Mounted,  with T8 Tube (Service life Hour minimum 24000 Hrs.) with all accessories.","L.S.",24,null,{"$f":"D454*E454","v":0}]
[1.5,"Wall type fan (18)\" 230v,50Hz with remote control.","No.",6,null,{"$f":"D455*E455","v":0}]
[1.6,"13A Switch Socket outlet.","No.",20,null,{"$f":"E456*D456","v":0}]
[1.7,"15A Switch Socket outlet.","No.",5,null,0]
[1.8,"Lighting Switch: Supplying materials , tools and manpower to install, connect and commissioning  of (230VAC/6A) (single , double , triple and quadruple) light switches using screws, using single core wire (2*2.5mm2) installed inside best type heavy duty PVC( 20mm dia. thickness conduits, circular junction box, square plastic box, adapter, couplings, with all accessories), or using (Plastic Cable Duct PVC Trunking) with all accessories and all the requirements to complete a good work.","No.",10,null,0]
[1.9,"25A grid switch with indicator lamp for water boiler and Split units.","No.",6,null,0]
["1.10","Supply and install Electronic bell with all necessary accessories and wiring for Substation entrances.","No.",1,null,0]
[2,"Maintenance of Projector (400 W) Sodium evaporate type the price includes cable 2*10 mm2.","L.S.",8,null,{"$f":"D461*E461","v":0}]
[3,"Emergency Lighting System"]
[null,"Supply materials and installation of Emergency lighting fixture rechargeable (LED) (1x20watt), AC/DC, 5hour operation, emergency portable lighting should fixed and added for all rooms, and emergency exit lights for all building main doors.","L.S.",1,null,{"$f":"D463*E463","v":0}]
[4,"Fire Detection & Alarm System\nSupply, install, connect and commission of Fire Detection and Alarm System consisting of hard-wired, multi-station smoke detectors, with building wide annunciation. Complete Fire Detection and Alarm System shall be provided, to include, fire alarm control panel, pull (or push button) stations, horns, strobe lights, smoke and/or heat detectors, as required. Fire alarm cable shall be installed in recessed hard wall PVC conduit and plastered over it. In addition to building wide fire alarm annunciation, the system shall also be capable of automatically transmitting the alarm signal via telephone lines to the local Fire Department / Fire Station. System design shall be in accordance with the requirements of NFPA 72. Fire alarm system shall be complete and a standard product of one manufacturer. Contractor shall provide hard-wired carbon monoxide (CO2) detectors, with local in-room annunciation, in all rooms where wood burning or oil-fired heaters will be provided.","L.S.",1,null,{"$f":"E464*D464","v":0}]
["Subtotal for Electrical Works $",{"$nulls":4},{"$f":"SUM(F451:F464)","v":0}]
[]
[null,"Mechanical Works"]
[1,"Electrical water boiler: Supply materials, tools and manpower to install, establish, connect, and commissioning electrical heater 250 Liter with complete fittings & accessories . The work includes all electrical cable (3x4mm2), and all  requirements to complete a good work.","L.S.",1,null,{"$f":"E468*D468","v":0}]
[2,"Split unit Air-conditioning: Supply, install, connect and commissioning best quality wall mounted Split unit Air-conditioning (Cool & Heat) 2 ton.(24000btuh) using cable 2*4mm , switch 35 A, with all accessories and requirements to complete a good work. ","L.S.",1,null,{"$f":"E469*D469","v":0}]
[3,"Split unit Air-conditioning: Supply, install, connect and commissioning best quality vertically mounted Split unit Air-conditioning (Cool & Heat) 4 ton.(48000btuh) using cable 4*6mm , switch 63 A, with all accessories and requirements to complete a good work. ","L.S.",4,null,{"$f":"D470*E470","v":0}]
[4,"Supplying materials , tools and manpower to install, connect and commissioning the substation water pump , valves , electrical works , capacity 1/2 hp with all requirements to complete a good work. ","L.S.",1,null,{"$f":"E471*D471","v":0}]
["Subtotal for mechanical Works",{"$nulls":4},{"$f":"SUM(F468:F471)","v":0}]
[" Total ",{"$nulls":4},{"$f":"SUM(F472,F465)","v":0}]

{"sheet":"SS2 Eskan Al Mowatinen","index":2,"n_rows":116,"n_cols":6,"rows_kept":116,"cut":false,"hidden":false,"merged":[[66,0,67,0],[66,2,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[60,0,61,0],[60,2,61,2],[60,3,61,3],[60,4,61,4],[60,5,61,5],[46,0,47,0],[46,2,47,2],[46,3,47,3],[46,4,47,4],[46,5,47,5],[58,0,59,0],[58,2,59,2],[64,0,65,0],[64,2,65,2],[64,3,65,3],[64,4,65,4],[64,5,65,5],[53,0,54,0],[53,2,54,2],[53,3,54,3],[53,4,54,4],[53,5,54,5],[58,3,59,3],[58,4,59,4],[58,5,59,5],[62,0,62,4],[63,0,63,4],[55,0,55,4],[56,0,56,4],[42,0,43,0],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[40,0,40,4],[44,0,45,0],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[19,0,19,3],[21,0,21,5],[19,4,19,5],[1,0,1,5],[3,0,3,3],[3,4,3,5],[4,0,4,3],[4,4,4,5],[5,0,5,3],[5,4,5,5],[6,0,6,3],[6,4,6,5],[7,0,7,3],[7,4,7,5],[8,0,8,3],[8,4,8,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,0,12,3],[12,4,12,5],[14,0,14,3],[14,4,14,5],[13,1,13,3],[13,4,13,5],[30,0,30,3],[48,0,48,4],[49,0,49,4],[51,0,52,0],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[23,0,25,0],[23,1,25,1],[23,2,25,2],[23,3,25,3],[23,4,23,5],[24,4,24,5],[32,0,32,5],[15,1,15,5],[16,1,16,3],[16,4,16,5],[17,1,17,3],[17,4,17,5],[18,0,18,3],[18,4,18,5],[88,2,88,5],[68,3,69,3],[68,4,69,4],[68,5,69,5],[70,0,71,0],[70,2,71,2],[70,3,71,3],[70,4,71,4],[70,5,71,5],[72,0,73,0],[72,2,73,2],[72,3,73,3],[72,4,73,4],[72,5,73,5],[68,0,69,0],[68,2,69,2],[33,0,33,5],[34,0,34,5],[35,0,35,5],[36,0,36,5],[37,0,37,5],[97,0,98,0],[107,1,107,4],[114,1,114,4],[115,1,115,4],[74,0,75,0],[74,2,75,2],[74,3,75,3],[74,4,75,4],[74,5,75,5],[76,0,77,0],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[78,0,78,4],[81,0,81,5],[83,0,83,5],[87,0,88,0],[87,2,87,5]]}
[]
["Partially Defected Substations: Eskan Al Mowatinen Substation "]
[]
["Substation Name: ",null,null,null,"Eskan Al Mowatinen"]
["Coordinates",null,null,null,"38SLF4038725217"]
["Capacity",null,null,null,"33/11 kV, 2*31.5 MVA"]
["Existing Substation switchgear Type",null,null,null,"ABB"]
["Existing Substation Transformer Type"]
["Dimension",null,null,null,"(50*50)m"]
[]
["#","Description",null,null,"Grand Total Price (US$)"]
["A","Renovation for MV Equipment's Works",null,null,{"$f":"F31","v":0}]
["Total for Renovation for MV Equipment's works",null,null,null,{"$f":"SUM(E12)","v":0}]
["B","Civil Works",null,null,{"$f":"F80","v":0}]
["Total for Civil works",null,null,null,{"$f":"SUM(E14)","v":0}]
["C","Auxiliary Works"]
[1," Electrical Works ",null,null,{"$f":"F108","v":0}]
[2,"Mechanical Works",null,null,{"$f":"F115","v":0}]
["Total for Auxiliary works",null,null,null,{"$f":"SUM(E17:F18)","v":0}]
["GRAND TOTAL OF PRICES",null,null,null,{"$f":"SUM(E19,E15,E13)","v":0}]
[]
["A- Renovation for MV Equipment's"]
[]
["Item No.","Description","Unit","Quantity","Tender Price"]
[{"$nulls":4},"Design/ Manufacturing \nDelivery to Site / Installing / Testing & Commissioning"]
[{"$nulls":4},"Unit price","Total Price"]
[1,"33kV AIS Metal Clad Switchgear Withdrawable for incoming feeder, including protection (ABB, ZS2)","Bays",2,null,{"$f":"D27*E27","v":0}]
[2,"33kV AIS Metal Clad Switchgear Withdrawable for transformer feeder, including protection (ABB, ZS2)","Bays",2,null,{"$f":"D28*E28","v":0}]
[3,"Tools and handling equipment Including mobile roller cab and tools cabinet, any required Loose assortment for Substation maintenance (wrenches sets, Hexagon and Star key wrenches, reversible ratchet...etc.).","Set",1,null,0]
[4,"Set of high quality laptop Core i7, 2T Hard Drive,16 GB DDR4-2133 SDRAM (2 x 8 GB), 256 GB M.2 SATA TLC SSD, DVD+/-RW, 15.'6'' LED Monitor, USB 3, Original Windows 10 32/64 bit, Baggage and wireless Mouse.","pc",1,null,{"$f":"D30*E30","v":0}]
[{"$nulls":4},"Total",{"$f":"SUM(F27:F30)","v":0}]
[]
["B- Civil Works"]
["General Specification "]
["1-  All the materials supplied by the contractor must be according to Iraq's standard Specifications"]
["2-  The contractor must provide samples , catalogues and specification of materials for testing and approval by the site engineer "]
["3-  Contractor must pay the cost for samples including any laboratory tests, both inside and outside the country as required "]
["4- The price of works includes all job requirements as per Iraq's standard specification."]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"CIVIL WORKS"]
["DIVISION D-PLASTERING AND PAINTING WORKS"]
["D","Plastering and painting works"]
["D1","Cement plastering","m²",10,null,{"$f":"D43*E43","v":0}]
[null,"Supply of materials, tools and manpower to repair wall cracks and remove the damaged cement plastering for the external walls of switch gear and control rooms ,  boundary wall , and fire wall between transformers  by removing the damaged cement plastering minimum 10 cm at each side of the crack, then treat the cracks with crack filler approved by manufacture with cement mortar 1:3 and using SBR at a rate according to the product's instructions for the additive material , later putting a layer of metal chicken mesh 10 cm overlap each side on the area with 3 layers of cement plastering , using aluminum vertical guide every 80cm ,  1:3. and all needed works to complete the job, will be included within the price .all the work in accordance with technical specifications."]
["D3","Emulsion painting","m²",280,null,{"$f":"D45*E45","v":0}]
[null,"Supply of materials, tools and manpower to paint the interior walls for control hall & rooms , with 3 layers of emulsion painting. The job includes cleaning the walls and removing the dirt and dust before painting , repairing of wall cracks and filling by the gypsum plastering . All needed works to complete the job, shall be included within the price."]
["D4","Plastic painting","m²",1700,null,{"$f":"D47*E47","v":0}]
[null,"Supply of materials, tools and manpower to paint the exterior walls with three-layer of silicon (water proof) painting. The works include cleaning the walls and removing the dirt and dust repairing of wall cracks and filling by cement plastering before painting. All needed works to complete the job, will be included within the price."]
["SUB TOTAL FOR PLASTERING AND PAINTING  WORK",{"$nulls":4},{"$f":"SUM(F43:F48)","v":0}]
["DIVISION E -METAL WINDOWS AND  DOORS "]
["E","Windows, doors and steel works"]
["E4","Repair steel main gate","EA",2,null,{"$f":"D52*E52","v":0}]
[null,"Supply of materials, tools and manpower to repair the damaged main gate steel doors , dimensions (7x2.5)m . The price includes door lock, mortise, handles, oil painting of steel door by using anti-rust and 3 layers of oil painting, fixing a stopper on the floor or wall, with repair the steel rail for the sliding door and fixed it in the floor concrete , accessories, as well as all needed works to complete the job.\n"]
["E5","Burglar steel bars","m²",8,null,{"$f":"D54*E54","v":0}]
[null,"Supply of materials, tools and manpower for installing windows burglar bars for windows with exist dimensions , by using a steel hollow section (2x4cm), 2 mm thickness. Including 2 layers of anti-rust and 1 layer of oil painting, as well as all needed works to complete the job. DWG- Bulgar bar Detail"]
["SUB TOTAL FOR METAL WINDOWS AND DOORS WORK",{"$nulls":4},{"$f":"SUM(F52:F55)","v":0}]
["DIVISION F- ROOFING , CLADDING , CEILING AND TILING WORKS"]
["F","Roofing, Cladding, Ceiling and Tilling works"]
["F3","Gypsum suspended ceiling","m²",50,null,{"$f":"D59*E59","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Gypsum boards) for rooms in control building. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["F4","Plastic suspended ceiling","m²",25,null,{"$f":"D61*E61","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Plastic boards) for rooms in control building. 6mm thickness. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["SUB TOTAL FOR ROOFING ,CLADDING, TILING WORK",{"$nulls":4},{"$f":"SUM(F59:F62)","v":0}]
["DIVISION I -SANITARY  WORKS"]
["I2","Reinstall Ceramic lavatory pedestal","EA",1,null,{"$f":"E65*D65","v":0}]
[null,"Supply of  materials, tools and manpower to remove the damaged Ceramic lavatory pedestal and install new ceramic lavatory pedestal (1 sink) in the guard house building, mixer taps, locks valves, mirror and all needed accessories with complete water connections. All needed works to complete the job, will be included within the price."]
["I4","Ceramic shower","EA",1,null,{"$f":"E67*D67","v":0}]
[null,"Supply of materials, tools and manpower to install ceramic shower (80x80cm) in the guard house building , mixer taps, locks valves and all needed accessories with complete water connections. All needed works to complete the job, shall be included within the price."]
["I2","Siphon","EA",1,null,{"$f":"E69*D69","v":0}]
[null,"Supply 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."]
["I5","Shower head and mixer taps","EA",2,null,{"$f":"E71*D71","v":0}]
[null,"Supply of materials, tools and manpower to install mixer taps with shower head, locks and all needed accessories for completing water connections. All needed works to complete the job, shall be included within the price."]
["I6","Mixer taps for Kitchen","EA",1,null,{"$f":"E73*D73","v":0}]
[null,"Supply of materials, tools and manpower to install mixer taps for kitchen, locks and all needed accessories for completing water connections. All needed works to complete the job, shall be included within the price."]
["I7","Installation of Kitchen Sink (single basin)with two wings:","EA",1,null,{"$f":"E75*D75","v":0}]
[null,"    Supplying materials , tools and manpower to install  Sink (single basin)with two wings, stainless steel, anti corrosion ,excellent type of gutter and pipe drainage, fixed on aluminum counter supply & install Later\n, and chrome mixer 0.5 inch. All the work in accordance with technical specifications"]
["I8","Sewerage cleaning","LS",1,null,{"$f":"E77*D77","v":0}]
[null,"Supply of materials, machine and manpower to clean the sewerage pipes net, starting from the  sanitary units groups, manholes to the main septic tank using high pressure air/water. The work includes replace the damaged manhole covers with new ones, as well as all needed works to complete the job."]
["SUB TOTAL FOR SANITARY WORK",{"$nulls":4},{"$f":"SUM(F65:F78)","v":0}]
[null,"TOTAL  SUMMARY ",null,null,null,{"$f":"F49+F63+F56+F79","v":0}]
[]
["C- Auxiliary Works"]
[]
["Substation Auxiliary Electrical & Mechanical System"]
["#","Item Description","Unit","Qty","Price (US $)","Total (US $)"]
[null,"Minimum Requierement for Supply, install, test and commission Auxiliary systems for Substation:\n1- All Equipment's and works should comply with (Technical Specification of 33-11kV substation construction, clause 3. Building Services, and all related sub Claus).\n2- Sample or catalogues for each of equipment's have to be submitted for approval. "]
[null,"Electrical Works"]
[1,"Lighting, Fan, Exhaust Fan and Sockets Installation"]
[null," Supply materials, Installation and operation for Substation auxiliary Electric system,  \n"]
[1.1000000000000001,"Exhaust fan size 6\" dia., window mounting  with puling switch and cover.","No.",4,null,{"$f":"E90*D90","v":0}]
[1.2,"Antiacid Exhaust fan size 12\" dia., wall mounting with fly mesh protection for battery room.","No.",3,null,{"$f":"E91*D91","v":0}]
[1.3,"Simple Fluorescent Lighting Fixture 230VAC, 2x40 W, 4 feet, Surface mounting or wall Mounted,  with T8 Tube (Service life Hour minimum 24000 Hrs.) with all accessories.","L.S.",64,null,{"$f":"D92*E92","v":0}]
[1.4,"13A Switch Socket outlet.","No.",30,null,{"$f":"E93*D93","v":0}]
[1.5,"Lighting Switch: Supplying materials , tools and manpower to install, connect and commissioning  of (230VAC/6A) (single , double , triple and quadruple) light switches using screws, using single core wire (2*2.5mm2) installed inside best type heavy duty PVC( 20mm dia. thickness conduits, circular junction box, square plastic box, adapter, couplings, with all accessories), or using (Plastic Cable Duct PVC Trunk) with all accessories and all the requirements to complete a good work.","No.",20,null,0]
[1.6,"25A grid switch with indicator lamp for water boiler and Split units.","No.",2,null,0]
[1.7,"Supply and install Electronic bell with all necessary accessories and wiring for Substation entrances.","No.",1,null,0]
[2,"Maintenance of Projector (400 W) Sodium evaporate type the price includes cable 2*10 mm2.","L.S.",10,null,{"$f":"D97*E97","v":0}]
[3,"Emergency Lighting System"]
[null,"Supply materials and installation of Emergency lighting fixture rechargeable (LED) (1x20watt), AC/DC, 5hour operation, emergency portable lighting should fixed and added for all rooms, and emergency exit lights for all building main doors.","L.S.",1,null,{"$f":"D99*E99","v":0}]
[4,"Distribution Boards:\n            Supply and installation of factory fabricated distribution boards for light/power, concealed type made of M.S sheet 16 SWG degreased, derusted, zinc phosphated finished with electrostatic powder coating, of approved color with hinged door, lockable handle, protection plate, earth and neutral strip, complete internally wired, flexible earthing strap for door manufactured by any one of the approved manufacturers as specified and comprising as under:"]
[4.0999999999999996,"Distribution board (3 Phase/400V/50Hz ) , equipped with 24x1 phase ( Miniature circuit breakers) (10-25) Amps, with main isolator, switch 100Amp. .","No.",1,null,{"$f":"D101*E101","v":0}]
[5,"Maintenance of Lighting pole (7.5 M) height with single arm, fix to metal plate (40x40x1)cm The pole consist of galvanized pipe 6\"dia, 3m.l starting from the bottom and connect through 4\" to 2\" reducer to galvanized pipe 4\"dia,3 m.l finally connect through 4\" to 2\" reducer with single arm elbow galvanized pipe 2\",1.5 height to hold the lighting fixture. Using 2x1.5 mm2 cable from the base to the lamp through 2 Amp fuse with inspection hole contain the poles will be fixed on concrete basement 100x50x50cm3, 1:2:4 mix  with four anchor bolts 19mm ,50cm length with 3\" PVC elbow pipe to be used for cable installing , finally the mentioned concrete base should be leveled on 10cm height plain concrete .","No.",5,null,{"$f":"D102*E102","v":0}]
[5.0999999999999996,"Maintenance of Street Lighting Fixtures, weatherproof, enclosed metal case with bulk head glass cover,  equipped by 250 watt high pressure mercury vapor lamp & ballast, the fixture will be held on the pole elbow through adapter.","No.",5,null,0]
[5.2,"Electric Photo Cell Switch 10 Amp., 230 VAC with all connections and accessories using 3x1.5mm2 cable between the photo cell and the Contactor(125A) 3Ph using 125A circuit breaker inside the low tension panel, for the light street and with all requirement to complete the work.","No.",1,null,{"$f":"D104*E104","v":0}]
[6,"Fire Detection & Alarm System\nMaintenance of Fire Detection and Alarm System consisting of hard-wired, multi-station smoke detectors, with building wide annunciation. Complete Fire Detection and Alarm System shall be provided, to include, fire alarm control panel, pull (or push button) stations, horns, strobe lights, smoke and/or heat detectors, as required. Fire alarm cable shall be installed in recessed hard wall PVC conduit and plastered over it. In addition to building wide fire alarm annunciation, the system shall also be capable of automatically transmitting the alarm signal via telephone lines to the local Fire Department / Fire Station. System design shall be in accordance with the requirements of NFPA 72. Fire alarm system shall be complete and a standard product of one manufacturer. Contractor shall provide hard-wired carbon monoxide (CO2) detectors, with local in-room annunciation, in all rooms where wood burning or oil-fired heaters will be provided.","L.S.",1,null,{"$f":"E105*D105","v":0}]
[7,"Cables, Wires and cable trays and conduits:"]
[7.1,"Supply install, test and commission necessary cables and wires to complete the systems of (Lighting system, Fire detection system, 220 AC distribution for buildings, water heating system, Air conditioning system….etc.) and any other necessary equipment's (cable trays and conduits) to complete the entire work.\nAll the works and wiring sizing should comply with Iraqi specifications and supervisor engineer instructions.","L.S.",1,null,{"$f":"D107*E107","v":0}]
[null,"Subtotal for Electrical Works $",null,null,null,{"$f":"SUM(F90:F107)","v":0}]
[]
[null,"Mechanical Works"]
[1,"Electrical water boiler: Supply materials, tools and manpower to install, establish, connect, and commissioning electrical heater 250 Liter with complete fittings & accessories . The work includes all electrical cable (3x4mm2), and all  requirements to complete a good work.","L.S.",1,null,{"$f":"E111*D111","v":0}]
[2,"Split unit Air-conditioning: Supply, install, connect and commissioning best quality wall mounted Split unit Air-conditioning (Cool & Heat) 2.5 ton.(30000btuh) using cable 2*4mm , switch 35 A, with all accessories and requirements to complete a good work.","L.S.",1,null,{"$f":"E112*D112","v":0}]
[3,"Split unit Air-conditioning: Supply, install, connect and commissioning best quality vertically mounted Split unit Air-conditioning (Cool & Heat) 4 ton.(48000btuh) using cable 4*6mm , switch 63 A, with all accessories and requirements to complete a good work. ","L.S.",3,null,{"$f":"D113*E113","v":0}]
[4,"Supplying materials , tools and manpower to install, connect and commissioning the substation water pump , valves , electrical works , capacity 1/2 hp with all requirements to complete a good work. ","L.S.",1,null,{"$f":"E114*D114","v":0}]
[null,"Subtotal for mechanical Works",null,null,null,{"$f":"SUM(F111:F114)","v":0}]
[null," Total ",null,null,null,{"$f":"SUM(F115,F108)","v":0}]

{"sheet":"SS3 Al Majmuha","index":3,"n_rows":116,"n_cols":6,"rows_kept":116,"cut":false,"hidden":false,"merged":[[46,3,47,3],[46,4,47,4],[46,5,47,5],[57,5,58,5],[70,0,71,0],[70,2,71,2],[70,3,71,3],[70,4,71,4],[50,2,51,2],[50,3,51,3],[50,4,51,4],[50,5,51,5],[52,0,53,0],[52,2,53,2],[52,3,53,3],[52,4,53,4],[52,5,53,5],[54,0,54,4],[63,0,63,4],[61,0,62,0],[61,2,62,2],[68,0,69,0],[68,2,69,2],[68,3,69,3],[68,4,69,4],[68,5,69,5],[66,2,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[55,0,55,4],[57,0,58,0],[57,2,58,2],[57,3,58,3],[57,4,58,4],[48,4,49,4],[48,5,49,5],[23,4,23,5],[24,4,24,5],[33,0,33,5],[21,0,21,5],[31,0,31,3],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[42,0,42,4],[44,0,45,0],[44,2,45,2],[44,3,45,3],[44,4,45,4],[44,5,45,5],[35,0,35,5],[36,0,36,5],[37,0,37,5],[38,0,38,5],[39,0,39,5],[46,0,47,0],[46,2,47,2],[114,0,114,4],[115,1,115,4],[1,0,1,5],[3,0,3,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[7,0,7,3],[8,0,8,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[10,1,10,3],[11,1,11,3],[12,0,12,3],[13,1,13,3],[48,0,49,0],[48,2,49,2],[13,4,13,5],[14,4,14,5],[15,4,15,5],[70,5,71,5],[72,0,72,4],[73,0,73,4],[14,0,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,0,18,3],[19,0,19,3],[61,3,62,3],[61,4,62,4],[61,5,62,5],[64,0,64,4],[66,0,67,0],[59,0,60,0],[59,2,60,2],[59,3,60,3],[59,4,60,4],[59,5,60,5],[50,0,51,0],[48,3,49,3],[87,2,87,5],[97,0,98,0],[107,1,107,4],[75,0,76,0],[75,2,76,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[77,0,78,0],[77,2,78,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[84,0,84,5],[88,2,88,5],[82,0,82,5],[79,0,79,4],[87,0,88,0],[80,0,80,4]]}
[]
["Partially Defected Substations: Al Majmuha Substation "]
[]
["Substation Name: ",null,null,null,"Al Majmuha"]
["Coordinates",null,null,null,"38SLF3296927634"]
["Capacity",null,null,null,"33/11 kV, 2*31.5 MVA"]
["Existing Substation switchgear Type",null,null,null,"ABB"]
["Existing Substation Transformer Type"]
["Dimension",null,null,null,"(40*40) m"]
[]
["#","Description",null,null,"Grand Total Price (US$)"]
["A","Renovation for MV Equipment's Works",null,null,{"$f":"F32","v":0}]
["Total for Renovation for MV Equipment's works",null,null,null,{"$f":"SUM(E12)","v":0}]
["B","Civil Works",null,null,{"$f":"F81","v":0}]
["Total for Civil works",null,null,null,{"$f":"SUM(E14)","v":0}]
["C","Auxiliary Works"]
[1," Electrical Works ",null,null,{"$f":"F108","v":0}]
[2,"Mechanical Works",null,null,{"$f":"F115","v":0}]
["Total for Auxiliary works",null,null,null,{"$f":"SUM(E17:F18)","v":0}]
["GRAND TOTAL OF PRICES",null,null,null,{"$f":"SUM(E19,E15,E13)","v":0}]
[]
["A- Renovation for MV Equipment's"]
[]
[{"$nulls":4},"Tender Price"]
[{"$nulls":4},"Design/ Manufacturing \nDelivery to Site / Installing / Testing & Commissioning"]
["Item No.","Description","Unit","Quantity","Unit price","Total Price"]
[1,"Battery Bank 110VDC, ALCAD/ type LCE145P   (92 cells).","Set",1,null,{"$f":"D27*E27","v":0}]
[2,"Battery Charger 230VAC/48VDC, 50A.","Set",2,null,0]
[3,"Battery Bank 48VDC, ALCAD/ type LCE145P (40 cells).","Set",1,null,0]
[4,"Tools and handling equipment Including mobile roller cab and tools cabinet, any required Loose assortment for Substation maintenance (wrenches sets, Hexagon and Star key wrenches, reversible ratchet...etc.).","Set",1,null,0]
[5,"Set of high quality laptop Core i7, 2T Hard Drive,16 GB DDR4-2133 SDRAM (2 x 8 GB), 256 GB M.2 SATA TLC SSD, DVD+/-RW, 15.'6'' LED Monitor, USB 3, Original Windows 10 32/64 bit, Baggage and wireless Mouse.","pc",1,null,{"$f":"D31*E31","v":0}]
[{"$nulls":4},"Total",{"$f":"SUM(F27:F31)","v":0}]
[]
["B- Civil Works"]
[]
["General Specification "]
["1-  All the materials supplied by the contractor must be according to Iraq's standard Specifications"]
["2-  The contractor must provide samples , catalogues and specification of materials for testing and approval by the site engineer "]
["3-  Contractor must pay the cost for samples including any laboratory tests, both inside and outside the country as required "]
["4- The price of works includes all job requirements as per Iraq's standard specification."]
["#","Item Description","Unit","Qty","Price$","Total $"]
[null,"CIVIL WORKS"]
["DIVISION D-PLASTERING AND PAINTING WORKS"]
["D","Plastering and painting works"]
["D1","Cement plastering","m²",16,null,{"$f":"D45*E45","v":0}]
[null,"Supply of materials, tools and manpower to repair wall cracks and remove the damaged cement plastering for the external walls of switch gear and control rooms ,  boundary wall , by removing the damaged cement plastering minimum 10 cm at each side of the crack, then treat the cracks with crack filler approved by manufacture with cement mortar 1:3 and using SBR at a rate according to the product's instructions for the additive material , later putting a layer of metal chicken mesh 10 cm overlap each side on the area with 3 layers of cement plastering , using aluminum vertical guide every 80cm ,  1:3. and all needed works to complete the job, will be included within the price .all the work in accordance with technical specifications."]
["D2","Gypsum plastering","m²",10,null,{"$f":"D47*E47","v":0}]
[null,"Supply of all necessary materials, tools and manpower to remove the damaged gypsum plastering of internal walls and plastering with new gypsum plastering  in 2 layers minimum thickness 15mm. The work includes repairing of wall cracks by removing the damaged gypsum plastering 15 cm at each side of the crack, then filling the cracks with cement mortar 1:3 and using SBR at a rate according to the product's instructions for the additive material , later putting a layer of plastic mesh on the area under the gypsum plastering using aluminum vertical guide every 80cm . All needed works to complete the job .all the work in accordance with technical specifications."]
["D3","Emulsion painting","m²",400,null,{"$f":"D49*E49","v":0}]
[null,"Supply of materials, tools and manpower to paint the interior walls for control hall & rooms , with 3 layers of emulsion painting. The job includes cleaning the walls and removing the dirt and dust before painting , repairing of wall cracks and filling by the gypsum plastering . All needed works to complete the job, shall be included within the price."]
["D4","Oil painting","m²",150,null,{"$f":"D51*E51","v":0}]
[null,"Supply of materials, tools and manpower to paint the internal walls 2 m height ,steel door &  window, with three-layer of oil paint (water proof) painting. The works include cleaning the walls and removing the dirt and dust repairing of wall cracks and filling by gypsum plastering before painting. All needed works to complete the job, will be included within the price."]
["D5","Plastic painting","m²",900,null,{"$f":"D53*E53","v":0}]
[null,"Supply of materials, tools and manpower to paint the exterior walls with three-layer of silicon (water proof) painting. The works include cleaning the walls and removing the dirt and dust repairing of wall cracks and filling by cement plastering before painting. All needed works to complete the job, will be included within the price."]
["SUB TOTAL FOR PLASTERING AND PAINTING  WORK",{"$nulls":4},{"$f":"SUM(F45:F54)","v":0}]
["DIVISION E -METAL WINDOWS AND  DOORS "]
["E","Windows, doors and steel works"]
["E1","Reinstall PVC windows :   ","m²",40,null,{"$f":"D58*E58","v":0}]
[null,"  Supply of materials, tools and manpower to remove old Aluminum windows and reinstall white PVC windows and windows for ventilation ,best quality , with exist dimensions for control halls , kitchen and ventilation windows for toilet and bathroom  . The price of work includes anti-insects wire mesh, handle and frosted clear glass (6 mm). All needed works to complete the job, will be included within the price."]
["E2","Repair steel doors","EA",1,null,{"$f":"D60*E60","v":0}]
[null,"  Supply of materials, tools and manpower to repair the damaged steel doors dimensions (1.00*2.1) m dimensions for guard house building . The price includes door lock, mortise, handles, oil painting of steel door by using anti-rust and 3 layers of oil painting, fixing a stopper on the floor or wall , accessories, as well as all needed works to complete the job."]
["E3","Repair steel main gate","EA",2,null,{"$f":"D62*E62","v":0}]
[null,"Supply of materials, tools and manpower to repair the damaged main gate steel doors , dimensions (5.5x2.5)m . The price includes door lock, mortise, handles, oil painting of steel door by using anti-rust and 3 layers of oil painting, fixing a stopper on the floor or wall, with repair the steel rail for the sliding door and fixed it in the floor concrete , accessories, as well as all needed works to complete the job.\n"]
["SUB TOTAL FOR METAL WINDOWS AND DOORS WORK",{"$nulls":4},{"$f":"SUM(F58:F63)","v":0}]
["DIVISION F- ROOFING , CLADDING , CEILING AND TILING WORKS"]
["F","Roofing, Cladding, Ceiling and Tilling works"]
["F1","Repair for Roofing works:","ml",60,null,{"$f":"D67*E67","v":0}]
[null,"   Supply materials and manpower for roofing work by cleaning the mosaic tiles of roof  ,  remove the old mastic . then filling the joints with white cement , and implementing  joints 2 cm width for  filling it with sealant mastic with exist area of joints , as well as all needed works to complete the job. All the work in accordance with technical specifications"]
["F2","Gypsum suspended ceiling","m²",40,null,{"$f":"D69*E69","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Gypsum boards) for rooms in control building. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["F3","Plastic suspended ceiling","m²",20,null,{"$f":"D71*E71","v":0}]
[null,"Suspended ceiling:\nSupply  material tools and manpower to install false ceiling 60x60 cm (Plastic boards) for rooms in control building. 6mm thichkness. The price includes fixing galvanized steel sections (H-sections-beams) , inverted T-section , fixing with galvanized steel bar (Ø5mm ) at dimension (1.2x1.2m) and fixing with the roof using screws. The price of work includes the removal of old damaged false ceiling and work of spot lights, 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.  DWG-Suspended Ceiling"]
["SUB TOTAL FOR ROOFING ,CLADDING, TILING WORK",{"$nulls":4},{"$f":"SUM(F67:F72)","v":0}]
["DIVISION I -SANITARY  WORKS"]
["I","Sanitary works"]
["I1","Shower head and mixer taps","EA",1,null,{"$f":"E76*D76","v":0}]
[null,"Supply of materials, tools and manpower to install mixer taps with shower head, locks and all needed accessories for completing water connections. All needed works to complete the job, shall be included within the price."]
["I2","Sewerage cleaning","LS",1,null,{"$f":"E78*D78","v":0}]
[null,"Supply of materials, machine and manpower to clean the sewerage pipes net, starting from the sanitary units, manholes to the main septic tank using high pressure air/water. The work includes replace the damaged manhole covers with new ones, as well as all needed works to complete the job."]
["SUB TOTAL FOR SANITARY WORK",{"$nulls":4},{"$f":"SUM(F76:F79)","v":0}]
["TOTAL  SUMMARY ",{"$nulls":4},{"$f":"F55+F73+F64+F80","v":0}]
[]
["C- Auxiliary Works"]
[]
["Substation Auxiliary Electrical & Mechanical System"]
["#","Item Description","Unit","Qty","Price (US $)","Total (US $)"]
[null,"Minimum Requierement for Supply, install, test and commission Auxiliary systems for Substation:\n1- All Equipment's and works should comply with (Technical Specification of 33-11kV substation construction, clause 3. Building Services, and all related sub Claus).\n2- Sample or catalogues for each of equipment's have to be submitted for approval. "]
[1,"Lighting, Fan, Exhaust Fan and Sockets Installation"]
[null," Supply materials, Installation and operation for Substation auxiliary Electric system,  \n"]
[1.1000000000000001,"Exhaust fan size 6\" dia., window mounting  with puling switch and cover.","No.",3,null,{"$f":"E90*D90","v":0}]
[1.2,"Antacid Exhaust fan size 12\" dia., wall mounting with fly mesh protection for battery room.","No.",1,null,{"$f":"E91*D91","v":0}]
[1.3,"Simple Fluorescent Lighting Fixture 2x40 W, 4 feet, Surface mounting or wall Mounted,  with T8 Tube (Service life Hour minimum 24000 Hrs.) with all accessories.","L.S.",60,null,{"$f":"D92*E92","v":0}]
[1.4,"13A Switch Socket outlet.","No.",30,null,{"$f":"E93*D93","v":0}]
[1.5,"Lighting Switch: Supplying materials , tools and manpower to install, connect and commissioning  of (220VAC/6A) (single , double , triple and quadruple) light switches using screws, using single core wire (2*2.5mm2) installed inside best type heavy duty PVC( 20mm dia. thickness conduits, circular junction box, square plastic box, adapter, couplings, with all accessories), or using (Plastic Cable Duct PVC Trunk) with all accessories and all the requirements to complete a good work.","No.",20,null,0]
[1.6,"25A grid switch with indicator lamp for water boiler and Split units.","No.",3,null,0]
[1.7,"Supply and install Electronic bell with all necessary accessories and wiring for Substation entrances.","No.",1,null,0]
[2,"Maintenance of Projector (400 W) Sodium evaporate type the price includes cable 2*10 mm2.","L.S.",8,null,{"$f":"D97*E97","v":0}]
[3,"Emergency Lighting System"]
[null,"Supply materials and installation of Emergency lighting fixture rechargeable (LED) (1x20watt), AC/DC, 5hour operation, emergency portable lighting should fixed and added for all rooms, and emergency exit lights for all building main doors.","L.S.",1,null,{"$f":"D99*E99","v":0}]
[4,"Distribution Boards:\n            Supply and installation of factory fabricated distribution boards for light/power, concealed type made of M.S sheet 16 SWG degreased, no corrosive zinc phosphated finished with electrostatic powder coating, of approved color with hinged door, lockable handle, protection plate, earth and neutral strip, complete internally wired, flexible earthing strap for door manufactured by any one of the approved manufacturers as specified and comprising as under:"]
[4.0999999999999996,"Distribution board (3 Phase/400V/50Hz ) , equipped with 24x1 phase ( Miniature circuit breakers) (10-25) Amps, with main isolator, switch 100Amp. .","No.",1,null,{"$f":"D101*E101","v":0}]
[5,"Maintenance of Lighting pole (7.5 M) height with single arm, fix to metal plate (40x40x1)cm The pole consist of galvanized pipe 6\"dia, 3m.l starting from the bottom and connect through 4\" to 2\" reducer to galvanized pipe 4\"dia,3 M.l finally connect through 4\" to 2\" reducer with single arm elbow galvanized pipe 2\",1.5 height to hold the lighting fixture. Using 2x1.5 mm2 cable from the base to the lamp through 2 Amp fuse with inspection hole contain the poles will be fixed on concrete basement 100x50x50cm3, 1:2:4 mix  with four anchor bolts 19mm ,50cm length with 3\" PVC elbow pipe to be used for cable installing , finally the mentioned concrete base should be leveled on 10cm height plain concrete .","No.",3,null,{"$f":"D102*E102","v":0}]
[5.0999999999999996,"Maintenance of Street Lighting Fixtures, weatherproof, enclosed metal case with bulk head glass cover,  equipped by 250 watt high pressure mercury vapor lamp & ballast, the fixture will be held on the pole elbow through adapter.","No.",3,null,0]
[5.2,"Electric Photo Cell Switch 10 Amp., 230 VAC with all connections and accessories using 3x1.5mm2 cable between the photo cell and the Contactor(125A) 3Ph using 125A circuit breaker inside the low tension panel, for the light street and with all requirement to complete the work.","No.",1,null,{"$f":"D104*E104","v":0}]
[6,"Fire Detection & Alarm System\nMaintenance of Fire Detection and Alarm System consisting of hard-wired, multi-station smoke detectors, with building wide annunciation. Complete Fire Detection and Alarm System shall be provided, to include, fire alarm control panel, pull (or push button) stations, horns, strobe lights, smoke and/or heat detectors, as required. Fire alarm cable shall be installed in recessed hard wall PVC conduit and plastered over it. In addition to building wide fire alarm annunciation, the system shall also be capable of automatically transmitting the alarm signal via telephone lines to the local Fire Department / Fire Station. System design shall be in accordance with the requirements of NFPA 72. Fire alarm system shall be complete and a standard product of one manufacturer. Contractor shall provide hard-wired carbon monoxide (CO2) detectors, with local in-room annunciation, in all rooms where wood burning or oil-fired heaters will be provided.","L.S.",1,null,{"$f":"E105*D105","v":0}]
[7,"Cables, Wires and cable trays and conduits:"]
[7.1,"Supply install, test and commission necessary cables and wires to complete the systems of (Lighting system, Fire detection system, 220 AC distribution for buildings, water heating system, Air conditioning system….etc.) and any other necessary equipment's (cable trays and conduits) to complete the entire work.\nAll the works and wiring sizing should comply with Iraqi specifications and supervisor engineer instructions.","L.S.",1,null,{"$f":"D107*E107","v":0}]
[null,"Subtotal for Electrical Works ",null,null,null,{"$f":"SUM(F90:F107)","v":0}]
[]
[null,"Mechanical Works"]
[1,"Electrical water boiler: Supply materials, tools and manpower to install, establish, connect, and commissioning electrical heater 120 Liter with complete fittings & accessories . The work includes all electrical cable (3x4mm2), and all  requirements to complete a good work.","L.S.",1,null,{"$f":"E111*D111","v":0}]
[2,"Split unit Air-conditioning: Supply, install, connect and commissioning best quality wall mounted Split unit Air-conditioning (Cool & Heat) 2.5 ton.(30000btuh) using cable 2*4mm , switch 35 A, with all accessories and requirements to complete a good work.","L.S.",2,null,{"$f":"E112*D112","v":0}]
[3,"Split unit Air-conditioning: Supply, install, connect and commissioning best quality vertically mounted Split unit Air-conditioning (Cool & Heat) 4 ton.(48000btuh) using cable 4*6mm , switch 63 A, with all accessories and requirements to complete a good work. ","L.S.",2,null,{"$f":"D113*E113","v":0}]
[4,"Supplying materials , tools and manpower to install, connect and commissioning the substation water pump , valves , electrical works , capacity 1/2 hp with all requirements to complete a good work. ","L.S.",1,null,{"$f":"E114*D114","v":0}]
["Subtotal for mechanical Works",{"$nulls":4},{"$f":"SUM(F111:F114)","v":0}]
[null," Total ",null,null,null,{"$f":"SUM(F115,F108)","v":0}]

{"sheet":"4-Factory Acceptance Tests","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,1,15,4],[3,0,3,5],[10,0,10,5],[5,1,6,1],[5,3,6,3],[7,0,7,4]]}
[]
[]
[]
[" Power Transformer Factory Acceptance Tests:"]
["#","Substation","FAT","Power transformer Brand","QTY","Total Price (US$)"]
[1,"SS1 Bab Ishtar,\n","Factory Visit to Power Transformer Factory During Design Period (4 Persons/1 week), pocket money for each of attendances is (150US$/ Day).","Offered Brand",1]
[2,null,"Power transformer FAT (According to T.S.) (4Person/ 1 Week), pocket money for each of attendances is (150US$/ Day).",null,1]
["Sub Total for Power Transformer FAT",{"$nulls":4},{"$f":"SUM(F6:F7)","v":0}]
[]
[]
["MV Switchgear Factory Acceptance Tests:"]
["#",null,"FAT","MV Switchgear Brand","QTY","Total Price (US$)"]
[1,"SS5 Bab Ishtar,\nSS2 Eskan Al Mowatinen","33kV AIS Switchgears, (4 Person/ 1 week), pocket money for each of attendances is (150US$/ Day).",null,1]
[{"$nulls":5},{"$f":"SUM(F13:F13)","v":0}]
[]
[null,"Total for FAT",null,null,null,{"$f":"SUM(F8,F14)","v":0}]