{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Isolating valves"],"read":"whole","date_system":"1900"}

{"sheet":"Isolating valves","index":0,"n_rows":70,"n_cols":9,"rows_kept":70,"merged":[[67,3,67,4],[68,3,68,4],[69,3,69,4]]}
[]
[null,"Supply and delivery of plumbing material for the following buildings : 2,3,4,8,10,12, 14F, 14G, 15,17,19,20,21,22,23,33,34,39,41,42,43,44,45 and 46  and Irrigation Network"]
[]
["ITEM NO","Description","UNIT","QTY","Unit Price\n(Excl VAT)","Total Price\n(Excl VAT)"]
[null,"Material for the buildings"]
[1,"Supply Lever Full Bore Ball valve  Brass 80mm","EA",40,null,{"$f":"D6*E6","v":0}]
[2,"Supply Lever Full Bore Ball valve Brass 65mm","EA",45,null,{"$f":"D7*E7","v":0}]
[3,"Supply Lever Full Bore Ball  valve Brass 50mm","EA",40,null,0]
[4,"Supply Ranger coupling 80mm","EA",80,null,0]
[5,"Supply Ranger coupling 65mm","EA",70,null,0]
[6,"Supply Ranger coupling 50mm","EA",60,null,0]
[7,"Supply Barrel Nipple  GALV 80mm","EA",80,null,0]
[8,"Supply  Barrel Nipple  GALV 65mm","EA",70,null,0,null,null," "]
[9,"Supply Barrel Nipple  GALV 50mm","EA",60,null,0]
[10,"Supply  63mm Male Compression Adaptor class 16 HDPE","EA",20,null,0,null," "]
[11,"Supply 50mm Male Compression Adaptor class 16 HDPE","EA",20,null,0]
[12,"Supply 22mm Copper pipe 5,5m class 1","Each",40,null,0]
[13,"Supply 22mmx90 degree Copper Elbow","Each",200,null,0]
[14,"Supply 22mm Copper coupling","Each",20,null,0]
[15,"Supply  22mm Female Tee Brass","Each",30,null,0]
[16,"Supply  22mm Female Elbow Brass","Each",200,null,0]
[17,"Supply 22mm female Adapter Brass","Each",10,null,0]
[18,"Supply  22mm Male Adapter Brass","Each",10,null,0]
[19,"Supply  22mm Ballcock Full way Lever Valve","Each",5,null,0]
[20,"Supply  22x15mm Copper Reducer","Each",20,null,0]
[21,"Supply  20-24mm Holder Bats","Each",50,null,0]
[22,"Supply 28-42mm Holder Bats","Each",30,null,0]
[23,"Supply 42mm Copper pipe class 1","Each",40,null,0]
[24,"Supply 42mm x 90 Degree Copper Elbow","Each",30,null,0]
[25,"Supply  42mm Tee Copper","Each",15,null,0]
[26,"Supply 42mm Coupling","Each",20,null,0]
[27,"Supply  42x22mm Copper Tee","Each",10,null,0]
[28,"Supply  42x28mm Copper Tee","Each",10,null,0]
[29,"Supply  42mmx90 Degree Male Copper Elbow","Each",15,null,0]
[30,"Supply  42mmx90 Degree Female Copper Elbow","Each",15,null,0]
[31,"Supply  42mm Female Adaptor","Each",10,null,0]
[32,"Supply  42mm Male Adaptor","Each",10,null,0]
[33,"Supply 42mm Ballcock Full way Lever Valve","Each",13,null,0]
[34,"Supply 42x22mm Copper Reducer","Each",10,null,0]
[35,"Supply 28x22mm Copper Reducer","Each",10,null,0]
[36,"Supply 22mm Cross Over","Each",50,null,0]
[37,"Supply 42mm Cross Over","Each",50,null,0]
[38,"Supply  Pipe Joint Compound 500mL","Each",2,null,0]
[39,"Supply Flux Frys Power Flow","Each",5,null,0]
[40,"Supply PTFE Thread Seal Tape Yellow 19mmx30mx0,1","Each",3,null,0]
[41,"Supply  Hemp IMP Hank 200GR","Each",2,null,0]
[42,"Supply flex-braided connector - F X F - 450mm length, 0.5\" x 0.5\"","Each",300,null,0]
[43,"Supply  Ball O Stop Mxf 15Mm Lever","Each",20,null,0]
[null,"Irrigattion Network Material"]
[44,"Supply 110mm class 16 HDPE pipe ","Each",2000,null,{"$f":"E50*D50","v":0}]
[45,"Supply 63mm class 16 HDPE","Each",500,null,{"$f":"E51*D51","v":0}]
[46,"Supply 110mm 90° Bends class 16 HDPE","Each",10,null,0]
[47,"Supply 110mm Male Compression Adaptor class 16 HDPE","Each",12,null,0]
[48,"Supply 110mm equal Tees class 16 HDPE","Each",5,null,0]
[49,"Supply 110mm Female Compression Adaptor class 16 HDPE","Each",7,null,0]
[50,"Supply Compression Coupling 110mm","Each",5,null,0]
[51,"Supply Compression Female Tee 110mm x 80mm class 16 HDPE","Each",6,null,0]
[52,"Supply  uPVC solvent weld male adapter 110mm","Each",2,null,0]
[53,"Supply 63mm Female Compression Adaptor class 16 HDPE","Each",7,null,0]
[54,"Supply Male Compression Adaptor class 16 HDPE","Each",8,null,0]
[55,"Supply 63mm 90° Bends class 16 HDPE","Each",7,null,0]
[56,"Supply Compression Coupling 63mm","Each",5,null,0]
[57,"Supply  63mm equal Tees class 16 HDPE","Each",6,null,0]
[58,"Supply uPVC solvent weld male adapter 63mm","Each",5,null,0]
[59,"Supply Lever Full Bore Ball Brass 110mm","Each",6,null,0]
[60,"Supply  Lever Full Bore Ball Brass 63mm","Each",4,null,0]
[61,"Supply Extra over-valve boxes.  400mm x 400mm cover","Each",10,null,0]
[{"$nulls":3},"Subtotal (Excl. VAT)",null,{"$f":"SUM(F6:F67)","v":0}]
[{"$nulls":3},"15% Vat",null,{"$f":"F68*0.15","v":0}]
[{"$nulls":3},"Total (Incl. VAT)",null,{"$f":"SUM(F68:F69)","v":0}]