{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["BILL SCHEDULE","BILL 1 - Labour rates","BILL 2- Pumps","BILL 3- Motor","BILL 4- Compressor","BILL 5- Evaporative Condensor","BILL 6- Air Handling Unit","BILL 7- Cold rooms","BILL 8-Refrigeration Equip","BILL 9-Filters","BILL 10- Valve","Bill 11-V-Belts","BILL 12- Electrical control box","BILL SUMMARY"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"BILL SCHEDULE","index":0,"n_rows":46,"n_cols":15,"rows_kept":46,"merged":[[2,0,2,1],[2,2,2,13],[4,2,4,13],[5,2,5,13]]}
[]
[{"$nulls":14}," "]
["Item",null,"Description",{"$nulls":11},"No. of Pages"]
[]
[null,null,"SECTION 3- SCHEDULE OF RATES "]
[]
[null,1,"BILL NO 1: LABOUR RATES",{"$nulls":11},1]
[]
[]
[null,{"$f":"B7+1","v":2},"BILL NO 2: PUMPS",{"$nulls":11},1]
[]
[]
[null,{"$f":"B10+1","v":3},"BILL NO 3: MOTOR",{"$nulls":11},6]
[]
[]
[null,{"$f":"B13+1","v":4},"BILL NO 4: COMPRESSOR",{"$nulls":11},1]
[]
[]
[null,{"$f":"B16+1","v":5},"BILL NO 5: EVAPORATIVE CONDENSOR",{"$nulls":11},3]
[]
[]
[null,{"$f":"B19+1","v":6},"BILL NO 6: AIR HANDLING UNITS",{"$nulls":11},3]
[]
[]
[null,{"$f":"B22+1","v":7},"BILL NO 7: COLD ROOMS",{"$nulls":11},3]
[]
[]
[null,{"$f":"B25+1","v":8},"BILL NO 8: REFRIGERANTS",{"$nulls":11},1]
[]
[]
[null,{"$f":"B28+1","v":9},"BILL NO 9: FILTERS ",{"$nulls":11},1]
[]
[]
[null,{"$f":"B31+1","v":10},"BILL NO 10: VALVES AND PIPING ",{"$nulls":11},1]
[]
[]
[null,{"$f":"B34+1","v":11},"BILL NO 11: V-BELTS",{"$nulls":11},1]
[]
[]
[null,12,"BILL NO 12: ELECTRICAL CONTROL BOX",{"$nulls":11},1]
[]
[]
[null,null,"BILL SUMMARY",{"$nulls":11},1]
[]
[]
[null,"  ","FINAL SUMMARY",{"$nulls":11},1]

{"sheet":"BILL 1 - Labour rates","index":1,"n_rows":38,"n_cols":13,"rows_kept":38,"merged":[[0,1,0,8],[1,1,1,8],[7,1,7,8],[10,1,10,8],[25,1,25,8],[33,1,33,8]]}
[]
["Item","Description",{"$nulls":7},"Unit","Qty","Rate","Amount"]
[]
[null,"MECHANICAL WORKS"]
[]
[null,"BILL OF QUANTITIES: BILL NO 1 OF 12"]
[]
[null,"LABOUR RATES"]
[]
[]
[null,"Tenderers shall price all labour rates in accordance with the latest applicable Main Collective Agreement of the Metal and Engineering Industries Bargaining Council (MEIBC), including all statutory wages, allowances, overtime premiums, leave pay, provident fund contributions, travelling costs, overheads and profit."]
[]
[]
[]
[null,"LABOUR RATES"]
[null,"(NORMAL WORKING HOURS (Monday to Friday in shifts)- 05:00-14:00 AND 08:00-17:00)"]
[]
[1,"Contract Manager Technician or higher (Diploma/ Degree)",{"$nulls":7},"hr",1240,"R","R"]
[]
[2,"Mechanical Trade Test Artisan (Site Technician)",{"$nulls":7},"hr",6016,"R","R"]
[]
[{"$f":"A20+1","v":3},"Mechanical Artisan Assistant",{"$nulls":7},"hr",6016,"R","R"]
[]
[]
[]
[null,"LABOUR RATES FOR AFTER HOURS (17:00-05:00), SATURDAY AND PUBLIC HOLIDAYS"]
[]
[4,"Mechanical Trade Test Artisan (After first hour, Incl. travel expenses)",{"$nulls":7},"hr",1240,"R","R"]
[]
[5,"Mechanical Artisan Assistant (Incl. travel expenses)",{"$nulls":7},"hr",1240,"R","R"]
[]
[]
[]
[null,"LABOUR RATES FOR  SUNDAY"]
[]
[6,"Mechanical Trade Test Artisan (After first hour, Incl. travel expenses)",{"$nulls":7},"hr",1240,"R","R"]
[]
[7,"Mechanical Artisan Assistant (After first hour, Incl. travel expenses)",{"$nulls":7},"hr",1240,"R","R"]

{"sheet":"BILL 2- Pumps","index":2,"n_rows":72,"n_cols":14,"rows_kept":72,"merged":[[1,3,1,10],[57,3,57,6],[62,3,62,6],[65,3,65,6],[67,3,67,6],[72,3,72,12],[73,3,73,10],[77,3,77,10],[78,3,78,10]]}
[]
[null,null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[{"$nulls":3},"RIPENING PLANT & COLD STORES  AMMONIA"]
[]
[{"$nulls":3},"BILL OF QUANTITIES: BILL NO 2 OF 12"]
[{"$nulls":3},"PUMPS"]
[]
[null,null,1,"Chilled Water Pumps Replacement 2 x 46kw Model No:2255M1292",{"$nulls":7},"No",1]
[]
[null,null,2,"Chilled Water Pumps Overhaul 2 x 46kw Model No:2255M1292",{"$nulls":7},"No.",1]
[]
[null,null,3,"Strip Pumps on site",{"$nulls":7},"No.",1]
[]
[null,null,4,"Strip Rotating Assembly in Workshop",{"$nulls":7},"No.",1]
[]
[null,null,5,"Check and Polish Shaft",{"$nulls":7},"No.",1]
[]
[null,null,6,"Sandblast and Primer",{"$nulls":7},"No.",1]
[]
[null,null,7,"New Bearings",{"$nulls":7},"No.",1]
[]
[null,null,8,"New Mechanical Seal",{"$nulls":7},"No.",1]
[]
[null,null,9,"New Set of Fastener ",{"$nulls":7},"No.",1]
[]
[null,null,10,"New Set of Grease Nipples",{"$nulls":7},"No.",1]
[]
[null,null,11,"New Set of Gaskets, Silicon Gasket Sealant",{"$nulls":7},"No.",1]
[]
[null,null,12,"New Set of O-Rings",{"$nulls":7},"No.",1]
[]
[null,null,13,"New Set of Oil Seals",{"$nulls":7},"No.",1]
[]
[null,null,14,"Clean and Paint Casing ",{"$nulls":7},"No.",1]
[]
[null,null,15,"Assemble Pump to Complete",{"$nulls":7},"No.",1]
[]
[null,null,16,"Ammonia NH3 Oil Pumps Overhaul ",{"$nulls":7},"No.",1]
[{"$nulls":3},"GEA FES Compressor no: 1&2 "]
[{"$nulls":3},"P/N 290-003910-022/ 36A002W606G1"]
[]
[null,null,16,"Ammonia NH3 Oil Pumps Replacement",{"$nulls":7},"No.",1]
[]
[null,null,17,"Ammonia NH3 Oil Pump Overhaul ",{"$nulls":7},"No.",1]
[{"$nulls":3},"Grasso RR-R305-28"]
[{"$nulls":3},"FES P/N 290003910-022"]
[{"$nulls":3},"SN: 8188940013"]
[]
[null,null,18,"Ammonia NH3 Oil Pumps Replacement",{"$nulls":7},"No.",1]
[]
[null,null,19,"Ammonia NH3 Oil Pump Overhaul ",{"$nulls":7},"No.",1]
[{"$nulls":3},"FES YORK "]
[{"$nulls":3},"Model no: 290 000910-554"]
[]
[null,null,20,"Ammonia NH3 Oil Pumps Replacement",{"$nulls":7},"No.",1]
[]
[null,null,21,"Ammonia NH3 Liquid Pump Overhaul",{"$nulls":7},"No.",1]
[{"$nulls":3},"Model no: 290 000910-554     GP51"]
[]
[null,null,22,"Ammonia NH3 Liquid Pumps Replacement GP51",{"$nulls":7},"No.",1]
[]
[null,null,23,"Ammonia NH3 Liquid Pump Overhaul",{"$nulls":7},"No.",1]
[{"$nulls":3},"Model no: 290 000910-554   GP52"]
[]
[null,null,24,"Ammonia NH3 Liquid Pumps Replacement GP52",{"$nulls":7},"No.",1]
[]
[null,null,25,"Compressor oil pump Overhaul",{"$nulls":7},"No.",1]
[{"$nulls":3},"Model no. 290 003910 022 ",null,"Oil 22GPM"]
[{"$nulls":3},"1.50\" 250Ø Flanges, Relief Neoprene & drive W/3HP"]
[]
[null,null,26,"Compressor oil pump Replacement",{"$nulls":7},"No.",1]

{"sheet":"BILL 3- Motor","index":3,"n_rows":149,"n_cols":12,"rows_kept":149,"merged":[[1,1,1,8],[136,1,136,10],[137,1,137,8],[141,1,141,8],[142,1,142,8],[158,1,158,10],[159,1,159,10]]}
[]
["Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,"BILL OF QUANTITIES: BILL NO 3 OF 12"]
[null,"MOTOR"]
[]
[null,"1.1 KW AC fan Motor Three Phase with 40cm Fan Blade"]
[1,"Bearings ",{"$nulls":7},"No.",1]
[2,"shaft ",{"$nulls":7},"No.",1]
[3,"Armature  ",{"$nulls":7},"No.",1]
[4,"Stator",{"$nulls":7},"No.",1]
[5,"seals",{"$nulls":7},"No.",1]
[6,"Cooling Fan",{"$nulls":7},"No.",1]
[7,"windings and Bake",{"$nulls":7},"No.",1]
[8,"Brush Assembly",{"$nulls":7},"No.",1]
[9,"frame",{"$nulls":7},"No.",1]
[10,"Rotor",{"$nulls":7},"No.",1]
[11,"End Shields",{"$nulls":7},"No.",1]
[12,"1.1 KW AC fan Motor Three Phase with 40cm Fan Blade Replacement ",{"$nulls":7},"No.",1]
[]
[null,"2.2 KW AC fan Motor Three Phase with Fan Blade"]
[13,"Bearings ",{"$nulls":7},"No.",1]
[14,"shaft ",{"$nulls":7},"No.",1]
[15,"Armature  ",{"$nulls":7},"No.",1]
[16,"Stator",{"$nulls":7},"No.",1]
[17,"seals",{"$nulls":7},"No.",1]
[18,"Cooling Fan",{"$nulls":7},"No.",1]
[19,"windings and Bake",{"$nulls":7},"No.",1]
[20,"Brush Assembly",{"$nulls":7},"No.",1]
[21,"frame",{"$nulls":7},"No.",1]
[22,"Rotor",{"$nulls":7},"No.",1]
[23,"End Shields",{"$nulls":7},"No.",1]
[24,"2.2 KW AC fan Motor Three Phase with Fan Blade Replacement ",{"$nulls":7},"No.",1]
[]
[null,"2.2KW Baltimore Evaporative Condenser Fan Motor"]
[25,"Bearings ",{"$nulls":7},"No.",1]
[26,"shaft ",{"$nulls":7},"No.",1]
[27,"Armature  ",{"$nulls":7},"No.",1]
[28,"Stator",{"$nulls":7},"No.",1]
[29,"seals",{"$nulls":7},"No.",1]
[30,"Cooling Fan",{"$nulls":7},"No.",1]
[31,"windings and Bake",{"$nulls":7},"No.",1]
[32,"Brush Assembly",{"$nulls":7},"No.",1]
[33,"frame",{"$nulls":7},"No.",1]
[34,"Rotor",{"$nulls":7},"No.",1]
[35,"New Set of Oil Seals",{"$nulls":7},"No.",1]
[36,"Clean and Paint Casing ",{"$nulls":7},"No.",1]
[37,"Assemble Pump to Complete",{"$nulls":7},"No.",1]
[38,"2.2KW Baltimore Evaporative Condenser Fan Motor Replacement ",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 Couple Pump Motors 5.5kw "]
[39,"Strip Pump on site",{"$nulls":7},"No.",1]
[40,"Strip Rotating Assembly in Workshop",{"$nulls":7},"No.",1]
[41,"Check and Polish Shaft",{"$nulls":7},"No.",1]
[42,"Sandblast and Primer",{"$nulls":7},"No.",1]
[43,"New Bearings",{"$nulls":7},"No.",1]
[44,"New Mechanical Seal",{"$nulls":7},"No.",1]
[45,"New Set of Fastener ",{"$nulls":7},"No.",1]
[46,"New Set of Grease Nipples",{"$nulls":7},"No.",1]
[47,"New Set of Gaskets, Silicon Gasket Sealant",{"$nulls":7},"No.",1]
[48,"New Set of O-Rings",{"$nulls":7},"No.",1]
[49,"New Set of Oil Seals",{"$nulls":7},"No.",1]
[50,"Clean and Paint Casing ",{"$nulls":7},"No.",1]
[51,"Assemble Pump to Complete",{"$nulls":7},"No.",1]
[52,"Ammonia NH3 Couple Pump Motors 5.5kw Replacement",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 Open Drive 257kw x 2 Compressor Motor"]
[53,"Bearings ",{"$nulls":7},"No.",1]
[54,"shaft ",{"$nulls":7},"No.",1]
[55,"Armature  ",{"$nulls":7},"No.",1]
[56,"Stator",{"$nulls":7},"No.",1]
[57,"seals",{"$nulls":7},"No.",1]
[58,"Cooling Fan",{"$nulls":7},"No.",1]
[59,"windings and Bake",{"$nulls":7},"No.",1]
[60,"Brush Assembly",{"$nulls":7},"No.",1]
[61,"frame",{"$nulls":7},"No.",1]
[62,"Rotor",{"$nulls":7},"No.",1]
[63,"End Shields",{"$nulls":7},"No.",1]
[64,"Ammonia NH3 Open Drive 257kw x 2 Compressor Motor Replacement",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 Open Drive 75kw Compressor Motor"]
[65,"Bearings ",{"$nulls":7},"No.",1]
[66,"shaft ",{"$nulls":7},"No.",1]
[67,"Armature  ",{"$nulls":7},"No.",1]
[68,"Stator",{"$nulls":7},"No.",1]
[69,"seals",{"$nulls":7},"No.",1]
[70,"Cooling Fan",{"$nulls":7},"No.",1]
[71,"windings and Bake",{"$nulls":7},"No.",1]
[72,"Brush Assembly",{"$nulls":7},"No.",1]
[73,"frame",{"$nulls":7},"No.",1]
[74,"Rotor",{"$nulls":7},"No.",1]
[75,"End Shields",{"$nulls":7},"No.",1]
[76,"Ammonia NH3 Open Drive 75kw Compressor Motor Replacement",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 Open Drive 100KW Compressor Motor"]
[77,"Bearings ",{"$nulls":7},"No.",1]
[78,"shaft ",{"$nulls":7},"No.",1]
[79,"Armature  ",{"$nulls":7},"No.",1]
[80,"Stator",{"$nulls":7},"No.",1]
[81,"seals",{"$nulls":7},"No.",1]
[82,"Cooling Fan",{"$nulls":7},"No.",1]
[83,"windings and Bake",{"$nulls":7},"No.",1]
[84,"Brush Assembly",{"$nulls":7},"No.",1]
[85,"frame",{"$nulls":7},"No.",1]
[86,"Rotor",{"$nulls":7},"No.",1]
[87,"End Shields",{"$nulls":7},"No.",1]
[88,"Ammonia NH3 Open Drive 100KW Compressor Motor Replacement",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 Open Drive 220 kw Compressor Motor"]
[89,"Bearings ",{"$nulls":7},"No.",1]
[90,"shaft ",{"$nulls":7},"No.",1]
[91,"Armature  ",{"$nulls":7},"No.",1]
[92,"Stator",{"$nulls":7},"No.",1]
[93,"seals",{"$nulls":7},"No.",1]
[94,"Cooling Fan",{"$nulls":7},"No.",1]
[95,"windings and Bake",{"$nulls":7},"No.",1]
[96,"Brush Assembly",{"$nulls":7},"No.",1]
[97,"frame",{"$nulls":7},"No.",1]
[98,"Rotor",{"$nulls":7},"No.",1]
[99,"End Shields",{"$nulls":7},"No.",1]
[100,"Ammonia NH3 Open Drive 220 kw Compressor Motor Replacement",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 Open Drive 288 kw Compressor Motor no 3"]
[101,"Bearings ",{"$nulls":7},"No.",1]
[102,"shaft ",{"$nulls":7},"No.",1]
[103,"Armature  ",{"$nulls":7},"No.",1]
[104,"Stator",{"$nulls":7},"No.",1]
[105,"seals",{"$nulls":7},"No.",1]
[106,"Cooling Fan",{"$nulls":7},"No.",1]
[107,"windings and Bake",{"$nulls":7},"No.",1]
[108,"Brush Assembly",{"$nulls":7},"No.",1]
[109,"frame",{"$nulls":7},"No.",1]
[110,"Rotor",{"$nulls":7},"No.",1]
[111,"End Shields",{"$nulls":7},"No.",1]
[112,"Ammonia NH3 Open Drive 288 kw Compressor Motor no 3 Replacement",{"$nulls":7},"No.",1]
[]
["Item","Description",{"$nulls":9},"Rate"]
[null,"MECHANICAL WORKS"]
[null,"BILL OF QUANTITIES: BILL NO 3 OF 12"]
[]
[null,"COLLECTION"]
[null,"LUMINAIRES"]
[]
[null,"Page 32"]
[null,"Page 33"]
[null,"Page 34"]
[null,"Page 35"]
[null,"Page 36"]

{"sheet":"BILL 4- Compressor","index":4,"n_rows":52,"n_cols":13,"rows_kept":52,"merged":[[1,2,1,9],[54,2,54,9],[58,2,58,9],[59,2,59,9]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 4 OF 12"]
[null,null,"COMPRESSOR REPAIR AND OVERHAUL"]
[]
[null,1,"Ammonia NH3 Screw Compressors Overhaul ",{"$nulls":7},"No.",1]
[null,null,"GEA FES Compressors 1&2 "]
[null,null,"Model no : RR-365-28 "]
[null,null,"SN: R1305 & R1298"]
[]
[null,2,"Ammonia NH3 Screw Compressors Replacement",{"$nulls":7},"No.",1]
[]
[null,3,"Ammonia NH3 Screw Compressor no: 3 Overhaul ",{"$nulls":7},"No.",1]
[null,null,"Grasso RR-R305-28"]
[null,null,"SN: R2085"]
[null,null,"Overhaul refer to GEA annexure 2"]
[]
[null,4,"Ammonia NH3 Screw Compressor no: 3 Replacement ",{"$nulls":7},"No.",1]
[]
[null,5,"Ammonia NH3 Screw Compressor no: 4 Overhaul ",{"$nulls":7},"No.",1]
[null,null,"GEA FES Compressor"]
[null,null,"SN: MKGA-2170"]
[null,null,"Model no: 2705"]
[]
[null,6,"Ammonia NH3 Screw Compressor no: 4 Replacement",{"$nulls":7},"No.",1]
[]
[null,7,"Ammonia NH3 Reciprocating Compressor no: 1&2 Overhaul ",{"$nulls":7},"No.",1]
[null,null,"Two Cylinder Reciprocating Compressor GEA GRASSO"]
[null,null,"Model no: 150827-0390 & 150827-0311 "]
[null,null,"Evacuation/Drying the refrigerating system"]
[null,null,"Evacuation, leak testing and start-up of the compressor/package"]
[null,null,"Evacuation of refrigerant before servicing"]
[null,null,"Leak-tightness after servicing"]
[null,null,"Evacuation after servicing"]
[null,null,"Start -up after servicing"]
[null,null,"General Recommendations"]
[]
[null,8,"Ammonia NH3 Reciprocating Compressor no: 1&2 Replacement",{"$nulls":7},"No.",1]
[]
[null,9,"Ammonia NH3 Reciprocating Compressor no: 3 Overhaul ",{"$nulls":7},"No.",1]
[null,null,"Three Cylinder Reciprocating Compressor GEA GRASSO"]
[null,null,"Model no: RC 312"]
[null,null,"Serial no: 98011039"]
[]
[null,10,"Ammonia NH3 Reciprocating Compressor no: 3 Repalcement",{"$nulls":7},"No.",1]
[]
[null,11,"Ammonia NH3 Reciprocating Compressor no: 4 Overhaul ",{"$nulls":7},"No.",1]
[null,null,"Six Cylinder Reciprocating Compressor GEA GRASSO"]
[null,null,"Serial no: 120717-4389"]
[null,12,"Ammonia NH3 Reciprocating Compressor no: 4 Repalcement",{"$nulls":7},"No.",1]

{"sheet":"BILL 5- Evaporative Condensor","index":5,"n_rows":93,"n_cols":12,"rows_kept":93,"merged":[[1,1,1,8],[7,1,7,8],[35,1,35,8],[37,1,37,8],[59,1,59,8],[63,1,63,8],[65,3,65,4],[66,3,66,4],[92,0,92,10]]}
[]
["Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,"BILL OF QUANTITIES: BILL NO 5 OF 12"]
[null,"EVAPORATIVE CONDENSERS"]
[]
[null,"Ammonia NH3 Evaporative Condensers Ripening Plant"]
[1,"Cooling Tower Nozzle ",{"$nulls":7},"No.",1]
[2,"Cooling Tower Sprayer",{"$nulls":7},"No.",1]
[3,"Cooling Tower Impeller",{"$nulls":7},"No.",1]
[4,"Drift Eliminators",{"$nulls":7},"No.",1]
[5,"Distribution Pipes",{"$nulls":7},"No.",1]
[6,"PVC Fill Blocks",{"$nulls":7},"No.",1]
[7,"PVC Drift Eliminators",{"$nulls":7},"No.",1]
[8,"Fill Grids",{"$nulls":7},"No.",1]
[9,"Cooling tower Gearbox",{"$nulls":7},"No.",1]
[10,"Cooling Tower Drive Shaft",{"$nulls":7},"No.",1]
[11,"Cooling Tower Hub Assembly",{"$nulls":7},"No.",1]
[12,"Cooling Tower Couplings",{"$nulls":7},"No.",1]
[13,"Cooling Tower Louvers",{"$nulls":7},"No.",1]
[14,"Honeycomb drift Eliminator ",{"$nulls":7},"No.",1]
[15,"Trickle Pack Fill",{"$nulls":7},"No.",1]
[16,"Fan Motor",{"$nulls":7},"No.",1]
[17,"Fan Blade",{"$nulls":7},"No.",1]
[18,"Cooling Tower Vibration Switch",{"$nulls":7},"No.",1]
[19,"Cooling Tower Drum Fan Assembly",{"$nulls":7},"No.",1]
[20,"Cooling Tower Water Supply Ball valve",{"$nulls":7},"No.",1]
[21,"Cooling Tower Sumps",{"$nulls":7},"No.",1]
[22,"Pully V Belts",{"$nulls":7},"No.",1]
[23,"Cooling Tower Electrical Control Box",{"$nulls":7},"No.",1]
[24,"Cooling Tower Motor Stand",{"$nulls":7},"No.",1]
[25,"Cooling Tower bleed off valve",{"$nulls":7},"No.",1]
[26,"Cooling Tower Bypass Valve and Coil",{"$nulls":7},"No.",1]
[27,"Cooling Tower Non Return Valve",{"$nulls":7},"No.",1]
[28,"Ammonia NH3 Evaporative Condensers Ripening Plant Replacement ",{"$nulls":7},"No.",1]
[]
[null,"Ammonia NH3 3 x Evaporative Condensers Cold storage"]
[29,"Cooling Tower Nozzle ",{"$nulls":7},"No.",1]
[30,"Cooling Tower Sprayer",{"$nulls":7},"No.",1]
[31,"Cooling Tower Impeller",{"$nulls":7},"No.",1]
[32,"Drift Eliminators",{"$nulls":7},"No.",1]
[33,"Distribution Pipes",{"$nulls":7},"No.",1]
[34,"PVC Fill Blocks",{"$nulls":7},"No.",1]
[35,"PVC Drift Eliminators",{"$nulls":7},"No.",1]
[36,"Fill Grids",{"$nulls":7},"No.",1]
[37,"Cooling Tower Couplings",{"$nulls":7},"No.",1]
[38,"Cooling Tower Louvers",{"$nulls":7},"No.",1]
[39,"Honeycomb drift Eliminator ",{"$nulls":7},"No.",1]
[40,"Trickle Pack Fill",{"$nulls":7},"No.",1]
[41,"Fan Motor ",{"$nulls":7},"No.",1]
[42,"Fan Blade",{"$nulls":7},"No.",1]
[43,"Cooling Tower Vibration Switch",{"$nulls":7},"No.",1]
[44,"Cooling Tower Water Supply Ball valve",{"$nulls":7},"No.",1]
[45,"Cooling Tower Sumps",{"$nulls":7},"No.",1]
[46,"Cooling Tower Electrical Control Box",{"$nulls":7},"No.",1]
[47,"Cooling Tower Motor Stand",{"$nulls":7},"No.",1]
[48,"Cooling Tower bleed off valve",{"$nulls":7},"No.",1]
[]
["Item","Description",{"$nulls":9},"Rate"]
[null,"MECHANICAL WORKS"]
[null,"BILL OF QUANTITIES: BILL NO 5 OF 12"]
[]
[null,"COLLECTION"]
[]
["F","Page 39",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["F","Page 40",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
{"$rows_empty":25}
["TOTAL CARRIED TO BILL SUMMARY Page 53",{"$nulls":10},"R"]

{"sheet":"BILL 6- Air Handling Unit","index":6,"n_rows":74,"n_cols":13,"rows_kept":74,"merged":[[1,2,1,9],[44,2,44,9],[48,2,48,9],[49,2,49,9],[73,2,73,11]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 6 OF 12"]
[null,null,"AIR HANDLING UNITS "]
[]
["G",null,"84.0 kw Air Handling Unit"]
[null,1,"Ahu Coil Sensor ",{"$nulls":7},"No.",1]
[null,2,"Three Way Valve",{"$nulls":7},"No.",1]
[null,3,"solenoid Coil",{"$nulls":7},"No.",1]
[null,4,"V belts",{"$nulls":7},"No.",1]
[null,5,"Drum fan set and Cowling",{"$nulls":7},"No.",1]
[null,6,"Ahu Digital Controller Schneider or equivalent ",{"$nulls":7},"No.",1]
[null,7,"Bearing Set ",{"$nulls":7},"No.",1]
[null,8,"Shaft ",{"$nulls":7},"No.",1]
[null,9,"Bender Fitting and Nipple",{"$nulls":7},"No.",1]
[null,10,"PVC Plastic Pipe 1 x metre",{"$nulls":7},"No.",1]
[null,11,"PVC Plastic Pipe Fitting",{"$nulls":7},"No.",1]
[null,12,"Drain Pipe",{"$nulls":7},"No.",1]
[null,13,"Chilled water Gages x 2",{"$nulls":7},"No.",1]
[null,14,"Drip Tray",{"$nulls":7},"No.",1]
[null,15,"Pressure Sensor",{"$nulls":7},"No.",1]
[null,16,"84.0 kw Air Handling Unit Replacement",{"$nulls":7},"No.",1]
[]
["G",null,"150.0 kw Air Handling Unit"]
[null,17,"Ahu Coil Sensor ",{"$nulls":7},"No.",1]
[null,18,"Dumper Sensors",{"$nulls":7},"No.",1]
[null,19,"Three Way Valve",{"$nulls":7},"No.",1]
[null,20,"solenoid Coil",{"$nulls":7},"No.",1]
[null,21,"V belts",{"$nulls":7},"No.",1]
[null,22,"Drum fan set and Cowling",{"$nulls":7},"No.",1]
[null,23,"Ahu Digital Controller Schneider or equivalent ",{"$nulls":7},"No.",1]
[null,24,"Bearing Set ",{"$nulls":7},"No.",1]
[null,25,"Shaft ",{"$nulls":7},"No.",1]
[null,26,"Bender Fitting and Nipple",{"$nulls":7},"No.",1]
[null,27,"PVC Plastic Pipe 1 x metre",{"$nulls":7},"No.",1]
[null,28,"PVC Plastic Pipe Fitting",{"$nulls":7},"No.",1]
[null,29,"Drain Pipe",{"$nulls":7},"No.",1]
[null,30,"Chilled water Gages x 2",{"$nulls":7},"No.",1]
[null,31,"Drip Tray",{"$nulls":7},"No.",1]
[null,32,"Pressure Sensor",{"$nulls":7},"No.",1]
[null,33,"150.0 kw Air Handling Unit Replacement ",{"$nulls":7},"No.",1]
[]
[null,"Item","Description",{"$nulls":9},"Rate"]
[null,null,"MECHANICAL WORKS"]
[null,null,"BILL OF QUANTITIES: BILL NO 6 OF 12"]
[]
[null,null,"COLLECTION"]
[null,null,"LUMINAIRES"]
[]
[null,"G","Page 42",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"G","Page 43",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
{"$rows_empty":20}
[null,null,"TOTAL CARRIED TO BILL SUMMARY Page 53",{"$nulls":9},"R"]

{"sheet":"BILL 7- Cold rooms","index":7,"n_rows":74,"n_cols":12,"rows_kept":74,"merged":[[1,1,1,8],[44,1,44,8],[48,1,48,8],[49,1,49,8],[73,1,73,10]]}
[]
["Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,"BILL OF QUANTITIES: BILL NO 7 OF 12"]
[null,"COLD ROOMS SALES FLOOR"]
[]
[null,"Cold-room Sales Floor"]
[1,"MTZ 125 380V Reciprocating Compressor (404a/507a)",{"$nulls":7},"No.",1]
[2,"500 dia ZEIL Fan Assembly ",{"$nulls":7},"No.",1]
[3,"HP/LP Auto Fan Cycling Switch",{"$nulls":7},"No.",1]
[4,"25 Watts Evaporator Fan Motors  ",{"$nulls":7},"No.",1]
[5,"16 Watts Evaporator Fan Motors",{"$nulls":7},"No.",1]
[6,"Suction Drier",{"$nulls":7},"No.",1]
[7,"Liquid Drier",{"$nulls":7},"No.",1]
[8,"Sight Glass",{"$nulls":7},"No.",1]
[9,"Suction Accumulator",{"$nulls":7},"No.",1]
[10,"Expansion Valve  ",{"$nulls":7},"No.",1]
[11,"Oil Separator",{"$nulls":7},"No.",1]
[12,"Solenoid Valve",{"$nulls":7},"No.",1]
[13,"Danfoss 202c Controller",{"$nulls":7},"No.",1]
[14,"Orifice ",{"$nulls":7},"No.",1]
[15,"380 V Electrical Isolator ",{"$nulls":7},"No.",1]
[null,"Ripening Doors Repairs "]
[16,"Gear Box ",{"$nulls":7},"No.",1]
[17,"Chain mechanism ",{"$nulls":7},"No.",1]
[18,"Close open switches ",{"$nulls":7},"No.",1]
[19,"Power Switch",{"$nulls":7},"No.",1]
[20,"Electrical Motor 0.37kw, RPM 1340 Replacement",{"$nulls":7},"No.",1]
[21,"Electrical Contactor  ",{"$nulls":7},"No.",1]
[22,"Auxiliary ",{"$nulls":7},"No.",1]
[23,"Relays ",{"$nulls":7},"No.",1]
[24,"Limit Switch",{"$nulls":7},"No.",1]
[25,"Door wheel ",{"$nulls":7},"No.",1]
[null,"Cold strorage doors",{"$nulls":7},"No.",1]
[26,"Gear Box ",{"$nulls":7},"No.",1]
[27,"Chain mechanism ",{"$nulls":7},"No.",1]
[28,"Close open switches ",{"$nulls":7},"No.",1]
[29,"Power Switch",{"$nulls":7},"No.",1]
[30,"Electrical Motor 0.37kw, RPM 1340 Replacement",{"$nulls":7},"No.",1]
[31,"Electrical Contactor  ",{"$nulls":7},"No.",1]
[32,"Auxiliary ",{"$nulls":7},"No.",1]
[33,"Relays ",{"$nulls":7},"No.",1]
[34,"Limit Switch",{"$nulls":7},"No.",1]
[35,"Door wheel ",{"$nulls":7},"No.",1]
["Item","Description",{"$nulls":9},"Rate"]
[null,"MECHANICAL WORKS"]
[null,"BILL OF QUANTITIES: BILL NO 7 OF 12"]
[]
[null,"COLLECTION"]
[null,"LUMINAIRES"]
[]
["G","Page 45",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["G","Page 46",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
{"$rows_empty":20}
[null,"TOTAL CARRIED TO BILL SUMMARY Page 53",{"$nulls":9},"R"]

{"sheet":"BILL 8-Refrigeration Equip","index":8,"n_rows":20,"n_cols":13,"rows_kept":20,"merged":[[1,2,1,9],[30,2,30,9],[34,2,34,9],[35,2,35,9]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 8 OF 12"]
[null,null,"Refrigeration Equipment "]
[]
["I",null,"Supply, Install And Commission Refrigeration Equipment to Cold Room \n"]
[null,1,"Thermocoil condensing unit pack model no (CTP 050-1-12-E-N) ",{"$nulls":7},"No.",1]
[null,null,"Refrigerant R404a /R507a. or equal approved by Mechanical Building Services. "]
[null,2,"Thermocoil blower coils model no (TEB 031-1-E-4-4) or equal approved",{"$nulls":7},"No.",1]
[null,null," by Mechanical Building Services with expansion valves. "]
[]
["I",null,"Refrigerant, Oil  & Parker Coils"]
[null,3,"Supply R22 Refrigerant 7KG",{"$nulls":7},"No.",1]
[null,4,"Supply R404a Refrigerant 7KG",{"$nulls":7},"No.",1]
[null,5,"Supply R507a Refrigerant 7KG",{"$nulls":7},"No.",1]
[null,6,"Ammonia NH3 67kg",{"$nulls":7},"No.",1]
[null,7,"Parker Coils",{"$nulls":7},"No.",1]
[null,8,"Grasso Compressor Oil # 9  per drum (210lt)",{"$nulls":7},"No.",1]

{"sheet":"BILL 9-Filters","index":9,"n_rows":13,"n_cols":13,"rows_kept":13,"merged":[[1,2,1,9],[24,2,24,9],[28,2,28,9],[29,2,29,9]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 9 OF 12"]
[null,null,"FILTERS "]
[]
["J",null,"Primary Filters for 28 AHU Supply Only"]
[null,1,"Size 625x400 x50",{"$nulls":7},"No.",1]
[null,2,"Size 500x400x50",{"$nulls":7},"No.",1]
[null,3,"Size 600 x 600 x50",{"$nulls":7},"No.",1]
[null,4,"Size 600 x 30 x50",{"$nulls":7},"No.",1]
[null,5,"Size 595 x 595 x50",{"$nulls":7},"No.",1]

{"sheet":"BILL 10- Valve","index":10,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[1,2,1,9],[23,2,23,9],[27,2,27,9],[28,2,28,9]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 10 OF 12"]
[null,null,"VALVES AND PIPING"]
[]
["K",null,"Valve Station R717 (Ammonia)"]
[null,1,"Solenoid valves EVRA3-20",{"$nulls":7},"No.",1,"R"]
[null,2,"Solenoid valves EVRAT10-20",{"$nulls":7},"No.",1,"R"]
[null,3,"Danfoss Coil A32F600.11",{"$nulls":7},"No.",1,"R"]
[null,4,"Refrigerant Float Switch Valve Hansen NH3",{"$nulls":7},"No.",1,"R"]
[null,5,"EKC Danfoss 202A Controller",{"$nulls":7},"No.",1,"R"]
[null,6,"Hanson Spare 220 volt Solenoid Coils",{"$nulls":7},"No.",1,"R"]
[null,7,"Piping work associated ",{"$nulls":7},"No.",1,"R"]
[null,8,"HS4A Solenoid Valve Hansen",{"$nulls":7},"No.",1,"R"]
[null,9,"Constant Flow Valve FRVA 20/25/32",{"$nulls":7},"No.",1,"R"]
[null,10,"Pressure Reducing Valve NR3XL",{"$nulls":7},"No.",1,"R"]
[null,11,"H5632R/300, NH3 Pressure Relief Valve",{"$nulls":7},"No.",1,"R"]
[null,12,"Galvanized SCH 5 Pip  6m",{"$nulls":7},"No.",1,"R"]
[null,13,"Zinc-Rich Primers to treat piping against rust 25 L",{"$nulls":7},"No.",1,"R"]

{"sheet":"Bill 11-V-Belts","index":11,"n_rows":11,"n_cols":13,"rows_kept":11,"merged":[[1,2,1,9],[25,2,25,9],[29,2,29,9],[30,2,30,9]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 11 OF 12"]
[null,null,"V-BELTS"]
[]
["L",null,"V-Belts "]
[]
[null,1,"Sizes SPB 350",{"$nulls":7},"No.",1]
[null,2,"Sizes SPB 3800",{"$nulls":7},"No.",1]

{"sheet":"BILL 12- Electrical control box","index":12,"n_rows":39,"n_cols":13,"rows_kept":39,"merged":[[1,2,1,9],[39,2,39,9],[43,2,43,9],[44,2,44,9]]}
[]
[null,"Item","Description",{"$nulls":7},"Unit","Qty","Rate"]
[]
[null,null,"RIPENING PLANT & COLD STORES  AMMONIA"]
[null,null,"BILL OF QUANTITIES: BILL NO 12 OF 12"]
[null,null,"ELECTRICAL CONTROL BOX"]
[]
["N",null,"Electrical Components Compressor no:1"]
[null,1,"ABB A260-30 Contactor (Watts: 80, 220-240v, IEN 60947-4-1 EN 60947-4-1)",{"$nulls":7},"No.",1]
[null,2,"Soft Starter with 500Amp fuses (ABB equivalent)",{"$nulls":7},"No.",1]
[null,3,"Isolator 630Amp",{"$nulls":7},"No.",1]
[null,4,"Complete Panel Replacement ",{"$nulls":7},"No.",1]
[]
["N",null,"Electrical Components Ammonia Pumps"]
[null,5,"Contactor 4kw",{"$nulls":7},"No.",1]
[null,6,"Overload  10 to 16 Amps",{"$nulls":7},"No.",1]
[]
["N",null,"Ripening Rooms Electrics"]
[null,7,"Isolator 380V",{"$nulls":7},"No.",1]
[null,8,"Overload 2.5 to 4.0 Amps",{"$nulls":7},"No.",1]
[null,9,"Contactors 4kw C45a 10 Amps",{"$nulls":7},"No.",1]
[null,10,"Complete Panel Replacement ",{"$nulls":7},"No.",1]
[]
["N",null,"Evaporative Condenser Fan Electrics"]
[null,11,"Contactor 4kw ",{"$nulls":7},"No.",1]
[null,12,"Overload 9 to 14 Amps",{"$nulls":7},"No.",1]
[null,13,"Isolator 380V",{"$nulls":7},"No.",1]
[null,14,"Complete Panel Replacement ",{"$nulls":7},"No.",1]
[]
["N",null,"Chilled Water Pump Electrics "]
[null,15,"Contactor CA 3-60 N. 11",{"$nulls":7},"No.",1]
[null,16,"Overload 40-52 Amps",{"$nulls":7},"No.",1]
[null,17,"Isolator 380V",{"$nulls":7},"No.",1]
[null,null,"Complete Panel Replacement ",{"$nulls":7},"No.",1]
[]
["N",null,"Compressor no:4 Electrics"]
[null,18,"Contactor ABB AF460-30 (132kw, 460Amps)",{"$nulls":7},"No.",1]
[null,19,"Overload ABB PSTX Model PSTX 470-600-70",{"$nulls":7},"No.",1]
[null,20,"Complete Panel Replacement ",{"$nulls":7},"No.",1]

{"sheet":"BILL SUMMARY","index":13,"n_rows":44,"n_cols":16,"rows_kept":44,"hidden":true,"merged":[[0,1,1,13],[0,14,1,14],[2,2,2,13],[3,2,3,13]]}
[]
[]
[null,"Page","Description",{"$nulls":11}," Rate"]
[null,null,"SCHEDULE OF RATES - BILL SUMMARY "]
[]
[null,30,"BILL NO 1: LABOUR RATES TOTAL AMOUNT",{"$nulls":11},"R",{"$f":"'BILL 1 - Labour rates'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,31,"BILL NO 2: PUMPS",{"$nulls":11},"R",{"$f":"'BILL 2- Pumps'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,37,"BILL NO 3: MOTOR",{"$nulls":11},"R",{"$f":"'BILL 3- Motor'!M151","v":0}]
[]
[]
[null,37,"BILL NO 4: COMPRESSOR",{"$nulls":11},"R",{"$f":"'BILL 4- Compressor'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,41,"BILL NO 5: EVAPORATIVE CONDENSOR",{"$nulls":11},"R",{"$f":"'BILL 5- Evaporative Condensor'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,44,"BILL NO 6: AIR HANDLING UNIT",{"$nulls":11},"R",{"$f":"'BILL 6- Air Handling Unit'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,47,"BILL NO 7: COLD ROOMS",{"$nulls":11},"R",{"$f":"'BILL 7- Cold rooms'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,48,"BILL NO 8: REFRIGERANTS",{"$nulls":11},"R",{"$f":"'BILL 8-Refrigeration Equip'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,49,"BILL NO 9: FILTERS",{"$nulls":11},"R",{"$f":"'BILL 9-Filters'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,50,"BILL NO 10: VALVE",{"$nulls":11},"R",{"$f":"'BILL 10- Valve'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,51,"BILL NO 11: V-BELTS AND PIPING",{"$nulls":11},"R",{"$f":"'Bill 11-V-Belts'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,52,"BILL NO 12: ELECTRICAL CONTROL BOX",{"$nulls":11},"R",{"$f":"'BILL 12- Electrical control box'!#REF!","v":{"$error":"#REF!"}}]
[null,null,"TOTAL EXCLUDING VAT  (CARRIED TO FINAL SUMMARY)",{"$nulls":11},"R",{"$f":"SUM(P6:P39)","v":{"$error":"#REF!"}}]
[]
[{"$nulls":13},"15% VAT","R",{"$f":"P40*15%","v":{"$error":"#REF!"}}]
[]
[{"$nulls":13},"TOTAL INCLUDING 15% VAT","R",{"$f":"P40+P42","v":{"$error":"#REF!"}}]