{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Materials"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Materials","index":0,"n_rows":417,"n_cols":11,"rows_kept":417,"merged":[[0,0,0,10],[1,0,3,0],[1,1,3,1],[1,2,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,8,3,8],[1,9,3,9],[1,10,3,10],[94,0,96,0],[94,1,96,1],[94,2,96,4],[94,5,96,5],[94,6,96,6],[94,7,96,7],[94,8,96,8],[181,0,183,0],[181,1,183,1],[181,2,183,4],[181,5,183,5],[181,6,183,6],[181,7,183,7],[181,8,183,8],[318,0,320,0],[318,1,320,1],[318,2,320,4],[318,5,320,5],[318,6,320,6],[318,7,320,7],[318,8,320,8],[414,1,414,7],[415,1,415,7]]}
["Supply of materials"]
["PAYMENT REFERS","ITEM NO","DESCRIPTION",null,null,"UNIT","RATE"," QTY","AMOUNT","Drawing No.","Additional Information"]
[]
[]
["SANS","A.3 ","MEDIUM-PRESSURE PIPELINES"]
["1200 L"]
["8.2.1"]
[{"$nulls":8},{"$f":"G8*H8","v":0}]
["8.2.2","A.3.2","Supply and delivery ",{"$nulls":5},0]
[null,null,".01","O-PVC 500 class PN12.5 Pipes:"]
[{"$nulls":3},".01","160m diameter pipe","No.",null,1,{"$f":"G11*H11","v":0}]
[{"$nulls":3},".02","350mm diameter","No.",null,1,{"$f":"G12*H12","v":0}]
[]
[]
[null,null,".02","O-PVC 500 class PN12.5 bends:",{"$nulls":4},0]
[{"$nulls":3},".01","110mm diameter",{"$nulls":3},0]
[{"$nulls":4},"a) 11.25 and 22.5 deg","No.",null,1,0]
[{"$nulls":4},"b) 45 deg","No.",null,1,0]
[{"$nulls":4},"c) 90 deg","No.",null,1,0]
[{"$nulls":3},".01","160mm diameter",{"$nulls":3},0]
[{"$nulls":4},"a) 11.25 and 22.5 deg","No.",null,1,0]
[{"$nulls":4},"b) 45 deg","No.",null,1,0]
[{"$nulls":4},"c) 90 deg","No.",null,1,0]
[{"$nulls":3},".04","355mm diameter",{"$nulls":3},0]
[{"$nulls":4},"a) 11.25 and 22.5 deg","No.",null,1,0]
[{"$nulls":4},"b) 45 deg","No.",null,1,0]
[{"$nulls":4},"c) 90 deg","No.",null,1,0]
[]
[{"$nulls":3},".04","500mm diameter",{"$nulls":3},{"$f":"G29*H29","v":0}]
[{"$nulls":4},"a) 11.25 and 22.5 deg","No.",null,1,0]
[{"$nulls":4},"b) 45 deg","No.",null,1,0]
[{"$nulls":4},"c) 90 deg","No.",null,1,0]
[null,null,".03","Flange Adaptors",{"$nulls":4},0]
[{"$nulls":3},".01","450mm diameter","No.",null,1,0]
[null,null,".04","Reducers",{"$nulls":4},0]
[{"$nulls":3},".01","355 x 160mm","No.",null,1,0]
[{"$nulls":3},".02","355 x 200mm","No.",null,1,0]
[{"$nulls":3},".03","400 x 200mm","No.",null,1,0]
[{"$nulls":3},".04"," 450 x 200mm","No.",null,1,0]
[{"$nulls":3},".05","450 x 355mm","No.",null,1,0]
[{"$nulls":3},".06","450 x 450mm","No.",null,1,0]
[{"$nulls":3},".07","500 x 160mm","No.",null,1,0]
[{"$nulls":3},".08","500 x 450mm","No.",null,1,0]
[{"$nulls":3},".09","630 x 500mm","No.",null,1,0]
[{"$nulls":3},".10","400 x 350mm",null,null,1,0]
[null,null,".05","Tees (PN16)",{"$nulls":4},0]
[{"$nulls":3},".01","450 x 160mm","No.",null,1,{"$f":"G47*H47","v":0}]
[{"$nulls":3},".02","450 x 200mm","No.",null,1,0]
[]
[]
[null,"A.5","AIR VALVE CHAMBERS AND ASSEMBLY"]
["SANS"]
["1200G","A.5.1","Precast Concrete"]
[null,null,"Supply and delivery"]
[null,null,"(As specified per dwg : DWS-LNW-ECS078-03-508)"]
[null,null,"(a)","Different types of precast elements",{"$nulls":4},{"$f":"G56*H56","v":0}]
[{"$nulls":3},".01","Concrete manhole rings 1250mm diameter",{"$nulls":3},0]
[{"$nulls":4},".02   500mm length","No.",null,1,0,"DWS-LNW-ECS078-ISI-508"]
[{"$nulls":4},".03   1000mm length","No.",null,1,0,"DWS-LNW-ECS078-ISI-508"]
[{"$nulls":3},".02","Concrete manhole rings 1500mm diameter",{"$nulls":3},0]
[{"$nulls":4},".02   500mm length","No.",null,1,0,"DWS-LNW-ECS078-ISI-508"]
[{"$nulls":4},".03   1000mm length","No.",null,1,0,"DWS-LNW-ECS078-ISI-508"]
[]
[{"$nulls":3},".03","0.1 Concrete roof slab with lockable access","No.",null,1,0,"DWS-LNW-ECS078-ISI-508"]
[{"$nulls":4}," manhole, including air vents for 1250mm",{"$nulls":3},0]
[{"$nulls":4},"0.2 Concrete roof slab with lockable access","No.",null,1,{"$f":"G66*H66","v":0},"DWS-LNW-ECS078-ISI-508"]
[{"$nulls":4}," manhole, including air vents for 1500mm"]
["SANS","A.5.2","Air Valve Assembly"]
[null,null,"Supply and delivery"]
[]
[null,null,"NEW",null,"VJ ADAPTOR"]
[{"$nulls":4},".01   110Ø","No.",null,1,{"$f":"G72*H72","v":0},"DWS-LNW-ECS078-ISI-820","Pipe list No. 1"]
[{"$nulls":4},".02   160Ø","No.",null,1,{"$f":"G73*H73","v":0},"DWS-LNW-ECS078-ISI-820","Pipe list No. 2"]
[{"$nulls":4},".03  200Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 3"]
[{"$nulls":4},".04   250Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 4"]
[{"$nulls":4},".05   315Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 5"]
[{"$nulls":4},".06   355Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 6"]
[{"$nulls":4},".08   450Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 8"]
[{"$nulls":4},".09  500Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 9"]
[{"$nulls":4},".10  630Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 10"]
[null,null,"NEW",null,"T-Junction  (Equal Tee Piece)",{"$nulls":3},0]
[{"$nulls":8},0]
[{"$nulls":4},".02   160Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 2"]
[{"$nulls":4},".03  200Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 3"]
[{"$nulls":4},".04   250Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 4"]
[{"$nulls":4},".05   315Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 5"]
[{"$nulls":4},".06   355Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 6"]
[{"$nulls":4},".08   450Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 8"]
[{"$nulls":4},".09  500Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 9"]
[{"$nulls":4},".10  630Ø","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 10"]
[]
[null,"TOTAL CARRIED FORWARD",{"$nulls":6},{"$f":"SUM(I51:I90)","v":0}]
[]
[]
["PAYMENT REFERS","ITEM NO","DESCRIPTION",null,null,"UNIT",null," QTY"," AMOUNT"]
[]
[]
[]
[{"$nulls":4},"Riser Steel pipe"]
[]
[{"$nulls":4},".02   DN 50mm (160mm diameter main pipe)","No.",null,1,{"$f":"G101*H101","v":0},"DWS-LNW-ECS078-ISI-820","Pipe list No. 2"]
[{"$nulls":4},".03   DN 50mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 3"]
[{"$nulls":4},".04   DN 50mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 4"]
[{"$nulls":4},".05   DN 50mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 5"]
[{"$nulls":4},".06   DN 80mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 6"]
[{"$nulls":4},".08   DN 100mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 8"]
[{"$nulls":4},".09   DN 100mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 9"]
[{"$nulls":4},".10   DN 150mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 10"]
[{"$nulls":3},".02","RSV gate valve",{"$nulls":3},0]
[{"$nulls":4},".02   DN 50mm (160mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 2"]
[{"$nulls":4},".03   DN 50mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 3"]
[{"$nulls":4},".04   DN 50mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 4"]
[{"$nulls":4},".05   DN 50mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 5"]
[{"$nulls":4},".06   DN 80mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 6"]
[{"$nulls":4},".08   DN 100mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 8"]
[{"$nulls":4},".09   DN 100mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 9"]
[{"$nulls":4},".10   DN 150mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 10"]
[{"$nulls":3},".03","Air release and vacuum break valve",{"$nulls":3},0]
[{"$nulls":4},".02   DN 50mm (160mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 2"]
[{"$nulls":4},".03   DN 50mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 3"]
[{"$nulls":4},".04   DN 50mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 4"]
[{"$nulls":4},".05   DN 50mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 5"]
[{"$nulls":4},".06   DN 80mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 6"]
[{"$nulls":4},".08   DN 100mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 8"]
[{"$nulls":4},".09   DN 100mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 9"]
[{"$nulls":4},".10   DN 150mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-821","Pipe list No. 10"]
[]
["SANS","A.6","SCOUR VALVE CHAMBERS AND ASSEMBLY"]
["1200G"]
[null,"A.6.4","Precast Concrete",{"$nulls":5},{"$f":"G130*H130","v":0}]
["8.6",null,"Supply and delivery",{"$nulls":5},0]
[null,null,"(As specified per dwg : DWS-LNW-ECS078-03-511",{"$nulls":5},0]
[null,null," to DWS-LNW-ECS078-03-513)",{"$nulls":5},0]
[null,null,".01","Different types of precast elements",{"$nulls":4},0]
[{"$nulls":8},0]
[{"$nulls":3},".01","Concrete manhole rings 1000mm diameter",{"$nulls":3},0]
[{"$nulls":4},"with step irons",{"$nulls":3},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":4},".02   500mm length","No.",null,1,0]
[{"$nulls":8},0]
[{"$nulls":4},".03   1000mm length","No.",null,1,0]
[{"$nulls":8},0]
[{"$nulls":3},".02","Concrete roof slab 1000mm with lockable access ","No.",null,1,{"$f":"G144*H144","v":0},"Refer to drawing "]
[{"$nulls":4},"manhole, including air vents"]
[]
[null,null,"SCOUR VALVE CHAMBERS"]
[null,null,"Scour Chamber- Revised Design"]
[]
["SANS"]
["1200L","A.6.5","Scour Valve Assembly"]
["8.2.3",null,"Supply and delivery"]
[null,null,"(As specified per dwg : DWS-LNW-ECS078-03-511"]
[null,null," to DWS-LNW-ECS078-03-513)"]
[null,null,".01","Scour tee"]
[{"$nulls":3},".01","DN 100mm (110mm diameter main pipe)","No.",null,1,{"$f":"G156*H156","v":0},"DWS-LNW-ECS078-ISI-511","Item 1.1"]
[{"$nulls":3},".02","DN 100mm (160mm diameter main pipe)","No.",null,1,{"$f":"G157*H157","v":0},"DWS-LNW-ECS078-ISI-511","Item 1.1"]
[{"$nulls":3},".03","DN 100mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.1"]
[{"$nulls":3},".04","DN 200mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[{"$nulls":3},".05","DN 200mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[{"$nulls":3},".06","DN 200mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[{"$nulls":3},".07","DN 200mm (400mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[{"$nulls":3},".08","DN 200mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[{"$nulls":3},".09","DN 200mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[{"$nulls":3},".10","DN 200mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.1"]
[null,null,".02","Gate valve",{"$nulls":4},0]
[{"$nulls":3},".01","DN 100mm (110mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.5"]
[{"$nulls":3},".02","DN 100mm (160mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.5"]
[{"$nulls":3},".03","DN 100mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.5"]
[{"$nulls":3},".04","DN 200mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".05","DN 200mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".06","DN 200mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".07","DN 200mm (400mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".08","DN 200mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".09","DN 200mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".10","DN 200mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[]
[]
[null,"TOTAL CARRIED FORWARD",{"$nulls":6},{"$f":"SUM(I129:I177)","v":0}]
[]
[]
["PAYMENT REFERS","ITEM NO","DESCRIPTION",null,null,"UNIT","RATE"," QTY"," AMOUNT"]
[]
[]
[]
[null,null,".03","Dismantling joint"]
[{"$nulls":3},".01","DN 100mm (110mm diameter main pipe)","No.",null,1,{"$f":"G187*H187","v":0},"DWS-LNW-ECS078-ISI-511","Item 1.5"]
[{"$nulls":3},".02","DN 100mm (160mm diameter main pipe)","No.",null,1,{"$f":"G188*H188","v":0},"DWS-LNW-ECS078-ISI-511","Item 1.5"]
[{"$nulls":3},".03","DN 100mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.5"]
[{"$nulls":3},".04","DN 200mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".05","DN 200mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".06","DN 200mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".07","DN 200mm (400mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".08","DN 200mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".09","DN 200mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[{"$nulls":3},".10","DN 200mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-512","Item 1.5"]
[]
[]
[null,null,"Scour Assembly- Revised Design"]
[null,null,"Supply and delivery"]
[null,null,"0.6",null,"Pipe Specials"]
[{"$nulls":3},"0.1","100 Ø Flanged Puddle Pipe","No.",null,1,{"$f":"G202*H202","v":0},"DWS-LNW-ECS078-ISI-511","Item 1.3"]
[{"$nulls":3},"0.2","100 Ø Plain ended Puddle Pipe","No.",null,1,{"$f":"G203*H203","v":0},"DWS-LNW-ECS078-ISI-511","Item 1.6"]
[{"$nulls":3},"0.3","100 Ø Flexible Coupling","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.2"]
[{"$nulls":3},"0.4","100 Ø Puddle Pipe-One end flanged","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.7"]
[{"$nulls":3},"0.5","100 Ø Blank Flange","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.8"]
[{"$nulls":3},"0.1","200 Ø Flanged Puddle Pipe","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.3"]
[{"$nulls":3},"0.2","200 Ø Plain ended Puddle Pipe","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.6"]
[{"$nulls":3},"0.3","200 Ø Flexible Coupling","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.2"]
[{"$nulls":3},"0.4","200 Ø Puddle Pipe-One end flanged","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.7"]
[{"$nulls":3},"0.5","200 Ø Blank Flange","No.",null,1,0,"DWS-LNW-ECS078-ISI-511","Item 1.8"]
[]
[]
[null,null,"ISOLATION VALVE CHAMBERS"]
[null,null,"Isolation Chamber- Revised Design"]
[]
["SANS",{"$nulls":7},{"$f":"G217*H217","v":0}]
["1200L","A.7.6","Isolation valve assembly",{"$nulls":5},0]
[{"$nulls":8},0]
["8.2.3",null,"Supply and delivery",{"$nulls":5},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[null,null,".01","Flange adaptor",{"$nulls":4},0]
[{"$nulls":3},".01","110mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.1"]
[{"$nulls":3},".02","160mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.2"]
[{"$nulls":3},".03","200mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.3"]
[{"$nulls":3},".04","250mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.4"]
[{"$nulls":3},".05","315mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.5"]
[{"$nulls":3},".06","355mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.6"]
[{"$nulls":3},".07","400mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.7"]
[{"$nulls":3},".08","450mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.8"]
[{"$nulls":3},".09","500mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.9"]
[{"$nulls":3},".10","630mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.10"]
[null,null,".02","Steel pipe section with puddle flange",{"$nulls":4},0]
[{"$nulls":8},0]
[{"$nulls":3},".01","110mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.1"]
[{"$nulls":3},".02","160mm diameter","No.",null,1,{"$f":"G237*H237","v":0},"DWS-LNW-ECS078-ISI-800","Pipe list No.2"]
[{"$nulls":3},".03","200mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.3"]
[{"$nulls":3},".04","250mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.4"]
[{"$nulls":3},".05","315mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.5"]
[{"$nulls":3},".06","355mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.6"]
[{"$nulls":3},".07","400mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.7"]
[{"$nulls":3},".08","450mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.8"]
[{"$nulls":3},".09","500mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.9"]
[{"$nulls":3},".10","630mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.10"]
[]
[null,null,".03","Butterfly valve",{"$nulls":4},{"$f":"G247*H247","v":0}]
[{"$nulls":3},".01","110mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.1"]
[{"$nulls":3},".02","160mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.2"]
[{"$nulls":3},".03","200mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.3"]
[{"$nulls":3},".04","250mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.4"]
[{"$nulls":3},".05","315mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.5"]
[{"$nulls":3},".06","355mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.6"]
[{"$nulls":3},".07","400mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.7"]
[{"$nulls":3},".08","450mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.8"]
[{"$nulls":3},".09","500mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.9"]
[{"$nulls":3},".10","630mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.10"]
[null,null,".04","Dismantling joint",{"$nulls":4},0]
[{"$nulls":3},".01","110mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.1"]
[{"$nulls":3},".02","160mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.2"]
[{"$nulls":3},".03","200mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.3"]
[{"$nulls":3},".04","250mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.4"]
[{"$nulls":3},".05","315mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.5"]
[{"$nulls":3},".06","355mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-800","Pipe list No.6"]
[{"$nulls":3},".07","400mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.7"]
[{"$nulls":3},".08","450mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.8"]
[{"$nulls":3},".09","500mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.9"]
[{"$nulls":3},".10","630mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-801","Pipe list No.10"]
[{"$nulls":8},0]
[null,null,"ISOLATION VALVE CHAMBER ASSEMBLY"]
[null,null,"Isolation Chamber- Revised Design"]
[null,null,"CONTRACTOR DID NOT ALLOWED FOR  THIS IN ORIGINAL"]
[null,null," ESTIMATE"]
[null,"A.7.7","Air Valve Assembly"]
[null,null,"Supply and delivery"]
[null,null,"(As specified per dwg : DWS-LNW-ECS078-03-508)"]
[]
[{"$nulls":3},".01","Riser Steel pipe"]
[]
[]
[{"$nulls":4},".02   DN 50mm (160mm diameter main pipe)","No.",null,1,{"$f":"G281*H281","v":0},"DWS-LNW-ECS078-ISI-810","Pipe list No.1"]
[{"$nulls":4},".03   DN 50mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.2"]
[{"$nulls":4},".04   DN 50mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.3"]
[{"$nulls":4},".05   DN 50mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-811","Pipe list No.4"]
[{"$nulls":4},".06   DN 80mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-811","Pipe list No.5"]
[{"$nulls":4},".08   DN 100mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.7"]
[{"$nulls":4},".09   DN 100mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.8"]
[{"$nulls":4},".10   DN 150mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.9"]
[{"$nulls":8},0]
[{"$nulls":3},".02","RSV gate valve",{"$nulls":3},0]
[{"$nulls":8},0]
[{"$nulls":4},".01   DN 50mm (110mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 1"]
[{"$nulls":4},".02   DN 50mm (160mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.1"]
[{"$nulls":4},".03   DN 50mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.2"]
[{"$nulls":4},".04   DN 50mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.3"]
[{"$nulls":4},".05   DN 50mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-811","Pipe list No.4"]
[{"$nulls":4},".06   DN 80mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-811","Pipe list No.5"]
[{"$nulls":4},".08   DN 100mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.7"]
[{"$nulls":4},".09   DN 100mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.8"]
[{"$nulls":4},".10   DN 150mm (630mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.9"]
[{"$nulls":8},0]
[{"$nulls":3},".03","Air release and vacuum break valve",{"$nulls":3},0]
[{"$nulls":8},0]
[{"$nulls":4},".01   DN 50mm (110mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-820","Pipe list No. 1"]
[{"$nulls":4},".02   DN 50mm (160mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.1"]
[{"$nulls":4},".03   DN 50mm (200mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.2"]
[{"$nulls":4},".04   DN 50mm (250mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-810","Pipe list No.3"]
[{"$nulls":4},".05   DN 50mm (315mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-811","Pipe list No.4"]
[{"$nulls":4},".06   DN 80mm (355mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-811","Pipe list No.5"]
[{"$nulls":4},".08   DN 100mm (450mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.7"]
[{"$nulls":4},".09   DN 100mm (500mm diameter main pipe)","No.",null,1,0,"DWS-LNW-ECS078-ISI-812","Pipe list No.8"]
[{"$nulls":4},".10   DN 150mm (630mm diameter main pipe)","No.",null,1,{"$f":"G312*H312","v":0},"DWS-LNW-ECS078-ISI-812","Pipe list No.9"]
[]
[]
[]
[null,"TOTAL CARRIED FORWARD",{"$nulls":6},{"$f":"SUM(I270:I314)","v":0}]
[]
[]
["PAYMENT REFERS","ITEM NO","DESCRIPTION",null,null,"UNIT","RATE"," QTY"," AMOUNT"]
[]
[]
["SANS"]
["1200L","A.8.1","Flowmeter assembly",{"$nulls":5},{"$f":"G323*H323","v":0}]
[{"$nulls":8},0]
["8.2.3",null,"Supply and delivery",{"$nulls":5},0]
[{"$nulls":8},0]
[null,null,".01","Flange adaptor-Item 1.2",{"$nulls":4},0]
[{"$nulls":8},0]
[{"$nulls":3},".01","100mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.2"]
[{"$nulls":8},0]
[null,null,".02","Steel pipe section with puddle flange one end flanged",{"$nulls":4},0]
[{"$nulls":3},"one end plain (to be calculated for each chamber)",{"$nulls":4},0]
[{"$nulls":3},".01","100mm diameter (890mm length)","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.1"]
[null,null,".03","Steel pipe section with puddle flanges both sides ",{"$nulls":4},0]
[{"$nulls":3},".01","100mm diameter (900mm Length 450mm x 450mm) Item 1.5","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.5"]
[{"$nulls":3},".02","100mm diameter (1040 mm Length 500mm x 350mm) Item 1.4","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.4"]
[null,null,".04","RSV Gate Valve Item 1.6",{"$nulls":4},0]
[{"$nulls":3},".01","100mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.6"]
[null,null,".05","Watermeter H4000 Honeywell both ends flanged Item 1.3",{"$nulls":4},0]
[{"$nulls":3},".01","100mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.3"]
[null,null,".06","Coated mild steel pipe both ends flanged Item ",{"$nulls":4},0]
[{"$nulls":3},".01","100mm diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.17"]
[{"$nulls":8},0]
[null,null,".08","45° Coated Mild Steel Elbow both ends flanged item 1.10",{"$nulls":4},0]
[{"$nulls":3},"0.1","100mm Diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.10"]
[null,null,".09","90° Coated Mild Steel Elbow both ends flanged item 1.16",{"$nulls":4},0]
[{"$nulls":3},"0.1","100mm Diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.16"]
[null,null,".10","45° Galvanized Elbow both ends Female Thread Item 1.12",{"$nulls":4},0]
[{"$nulls":3},".01","100mm Diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.12"]
[null,null,".11","90° Galvanized Elbow both ends Female Thread item 1.14",{"$nulls":4},0]
[{"$nulls":3},".01","100mm Diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.14"]
[null,null,".12","Galvinized pipe piece both ends Male Thread Item 1.15",{"$nulls":4},0]
[{"$nulls":3}," (to be calculated for each chamber/Reservoir)",{"$nulls":4},0]
[{"$nulls":3},"0.1","100mm Diameter (6m Lenghts)","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.15"]
[null,null,".13","Galvanized Threaded Flanges (1600/4) Item 1.19",{"$nulls":4},0]
[{"$nulls":3},".01","100mm Diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.19"]
[null,null,".14","Equilibrium Valve both ends Flanged Item 1.18",{"$nulls":4},0]
[{"$nulls":3},".01","100mm Diameter","No.",null,1,0,"DWS-LNW-ECS078-ISI-0690","Item 1.18"]
[]
["SANS"]
["1200 L","A.10.1",null,"GRP Materials "]
["8.2.1"]
[null,null,".01","Supply and delivery"]
[{"$nulls":4},"350mm GRP rocker pipe 1m Long","No",null,1,{"$f":"G364*H364","v":0},"Glass reinforced pipes from Flowtite"]
[{"$nulls":4},"355mm GRP to Steel Flange adapter","No",null,1,0,"Glass reinforced pipes from Flowtite"]
[{"$nulls":4},"450mm GRP rocker pipe 1m Long","No",null,1,0,"Glass reinforced pipes from Flowtite"]
[{"$nulls":4},"450mm GRP to Steel Flange adapter","No",null,1,0,"Glass reinforced pipes from Flowtite"]
[{"$nulls":4},"630mm GRP rocker pipe 1m Long","No",null,1,0,"Glass reinforced pipes from Flowtite"]
[{"$nulls":4},"630mm GRP to Steel Flange adapter","No",null,1,0,"Glass reinforced pipes from Flowtite"]
[]
["SANS"]
["1200 L","A.10.1","GRP Fittings",{"$nulls":5},{"$f":"G372*H372","v":0}]
["8.2.2",{"$nulls":7},0]
[null,null,"Supply and delivery",{"$nulls":5},0]
[{"$nulls":8},0]
[{"$nulls":3},".01","450mm GRP to Steel Flange adapter","m",null,480,0]
[]
[null,null,".02","GRP Bends ",{"$nulls":4},0]
[]
[{"$nulls":3},".01","630mm diameter",{"$nulls":3},0]
[{"$nulls":4},"a) 11.25 and 22.5 deg","No.",null,1,0]
[{"$nulls":4},"b) 45 deg","No.",null,1,0]
[{"$nulls":4},"c) 90 deg","No.",null,1,0]
[]
[]
[null,"A.10.1","Other materials"]
[null,null,"Supply and delivery"]
[null,null,".01","Bolts, Nuts  - Hot dipped Galvanised "]
[{"$nulls":3},".01","M16 X 70mm","No.",null,1,{"$f":"G389*H389","v":0},"Hot Dipped Galvanised"]
[{"$nulls":3},".02","M20 x 90mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".03","M24 x 130mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".04","M30 x 160mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".05","M24 x 200mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".06","M24 x 240mm","No.",null,1,0,"Hot Dipped Galvanised"]
[]
[null,null,".02","Washer - Hot dipped Galvanised ",null,"No."]
[{"$nulls":3},".01","M16 X 70mm","No.",null,1,{"$f":"G397*H397","v":0},"Hot Dipped Galvanised"]
[{"$nulls":3},".02","M20 x 90mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".03","M24 x 130mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".04","M30 x 160mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".05","M24 x 200mm","No.",null,1,0,"Hot Dipped Galvanised"]
[{"$nulls":3},".06","M24 x 240mm","No.",null,1,0,"Hot Dipped Galvanised"]
[]
[null,null,".03","Gasket - Compressed Non-Asbestos Fibre full face T1600/3"]
[{"$nulls":3},".01","100mm","No.",null,1,{"$f":"G405*H405","v":0}]
[{"$nulls":3},".02","200mm","No.",null,1,0]
[{"$nulls":3},".03","350mm","No.",null,1,0]
[{"$nulls":3},".04","450mm","No.",null,1,0]
[{"$nulls":3},".05","500mm","No.",null,1,0]
[{"$nulls":3},".06","630mm","No.",null,1,0]
[]
[{"$nulls":8},{"$f":"G412*H412","v":0}]
[]
[null,"TOTAL CARRIED FORWARD",{"$nulls":6},{"$f":"SUM(I371:I412)","v":0}]
[null,"15% VAT"]
[null,"TOTAL"]
[{"$nulls":4},"NB: The quantity of 1 is for price comparison only, LNW will finalise the quantities with the appointed bidders."]