{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calculator","General Data","Reducing tee","Valve","Flanges","Pipe Data"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Calculator","index":0,"n_rows":38,"n_cols":33,"rows_kept":38,"cut":false,"hidden":false,"merged":[[31,20,31,21],[33,20,33,21],[37,25,37,26],[37,29,37,31],[34,8,34,10],[34,19,34,21],[29,8,29,10],[29,19,29,21],[30,8,30,10],[30,19,30,21],[31,9,31,10],[32,9,32,10],[33,9,33,10],[6,18,6,19],[6,20,6,21],[6,28,6,30],[6,15,6,17],[7,15,7,17],[3,1,3,2],[3,6,3,7],[3,11,3,13],[3,16,3,17],[3,20,3,21],[6,4,6,6],[7,4,7,6],[8,4,8,6],[8,15,8,17],[16,2,16,4],[16,8,16,10],[16,18,16,20],[16,23,16,25],[16,28,16,30],[26,18,26,20],[26,23,26,25],[26,29,26,31],[16,13,16,15],[17,13,17,15],[17,18,17,20],[20,2,20,4],[26,2,26,4],[26,8,26,10],[26,13,26,15],[32,20,32,21],[32,25,32,26],[32,29,32,31]]}
[]
[null,null,null,null,"PIPE CALCULATOR"]
[]
[null,"Size1",null,null,null,null,"Size2",null,null,null,null,"Rating",null,null,null,"Sch.","Sch.",null,null,null,"Face"]
[]
[]
[null,"OD(mm)",null,null,{"$f":"'General Data'!G40","v":356},null,null,null,"Pipe Wt empty (kg/m)",null,null,null,null,null,null,{"$f":"'General Data'!T39","v":""}]
[null,"OD/(2mm",null,null,{"$f":"ROUND(E7/2,1)","v":178},null,null,null,"Pipe Wt water (kg/m)",null,null,null,null,null,null,{"$f":"'General Data'!T40","v":""}]
[null,"OD(in)",null,null,{"$f":"'General Data'!F39","v":14},null,null,null,"Wall thk. (mm)",null,null,null,null,null,null,{"$f":"'Pipe Data'!B47","v":19.05}]
[]
[]
[]
[]
[]
[]
[]
[null,"A =",{"$f":"'General Data'!H39","v":533},null,null,"mm",null,"B=",{"$f":"'General Data'!I39","v":222},null,null,"mm","C=",{"$f":"'General Data'!K39","v":279},null,null,"mm","C=",{"$f":"'Reducing tee'!G223","v":"…."},null,null,"mm","E=",{"$f":"'General Data'!J39","v":165},null,null,"mm","H=",{"$f":"'Reducing tee'!M223","v":"…."},null,null,"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M=",{"$f":"'General Data'!L39","v":279},null,null,"mm","M=",{"$f":"'Reducing tee'!H223","v":"…."},null,null,"mm"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A =",{"$f":"Valve!D174","v":889},null,null,"mm",null,"A =",{"$f":"Valve!J174","v":889},null,null,"mm","A =",{"$f":"Valve!F174","v":889},null,null,"mm","D=",{"$f":"Valve!H174","v":"..."},null,null,"mm","A =",{"$f":"Valve!N174","v":889},null,null,"mm",null,"A =",{"$f":"Valve!L174","v":889},null,null,"mm"]
[]
[]
[null,null,null,null,null,null,"B=",null,{"$f":"Flanges!D162","v":412.8},null,null,"mm",null,null,null,null,null,"B=",null,{"$f":"Flanges!L162","v":""},null,null,"mm"]
[null,null,null,null,null,null,"L=",null,{"$f":"Flanges!E162","v":165},null,null,"mm",null,null,null,null,null,"L=",null,{"$f":"Flanges!M162","v":""},null,null,"mm"]
[null,null,null,null,null,null,"No.of Bolt",null,null,{"$f":"Flanges!F162","v":20},null,null,null,null,null,null,null,"No.of Bolt",null,null,{"$f":"Flanges!N162","v":""}]
[null,null,null,null,null,null,"Bolt Dia",null,null,{"$f":"Flanges!G162","v":""},null,"in",null,null,null,null,null,"Bolt Dia",null,null,{"$f":"Flanges!O162","v":""},null,"in",null,"S=",{"$f":"Flanges!J162","v":69.9},null,"mm","Wt",{"$f":"Flanges!K162","v":""},null,null,"kg"]
[null,null,null,null,null,null,"Bolt Len.",null,null,{"$f":"Flanges!H162","v":""},null,"mm",null,null,null,null,null,"Bolt Len.",null,null,{"$f":"Flanges!P162","v":""},null,"mm"]
[null,null,"Weight of Flange",null,null,null,null,null,{"$f":"Flanges!I162","v":150},null,null,"kg",null,"Weight of Flange",null,null,null,null,null,{"$f":"Flanges!Q162","v":""},null,null,"kg"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S=",{"$f":"Flanges!R162","v":""},null,"mm","Wt",{"$f":"Flanges!S162","v":""},null,null,"kg"]

{"sheet":"General Data","index":1,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Sl.No.","NPS","rating","Schedule","Face","OD (IN)","OD mm","elbow 90 A","elbow 45 B","Cap E","Tee C","Tee M"]
[1.0,0.5,125.0,"5S","RF",0.84,21.3,38.0,16.0,25.0,25.0,25.0]
[2.0,0.75,150.0,"10S","FF",1.05,26.7,38.0,19.0,25.0,29.0,29.0]
[3.0,1.0,300.0,"40S",null,1.32,33.4,38.0,22.0,38.0,38.0,38.0]
[4.0,1.25,600.0,"80S",null,1.66,42.2,48.0,25.0,38.0,48.0,48.0]
[5.0,1.5,900.0,5.0,null,1.9,48.3,57.0,29.0,38.0,57.0,57.0]
[6.0,2.0,1200.0,10.0,null,2.38,60.3,76.0,35.0,38.0,64.0,64.0]
[7.0,2.5,1500.0,20.0,null,2.88,73.0,95.0,44.0,38.0,76.0,76.0]
[8.0,3.0,2500.0,30.0,null,3.5,88.9,114.0,51.0,51.0,86.0,86.0]
[9.0,3.5,3000.0,"STD",null,4.0,101.6,133.0,57.0,64.0,95.0,95.0]
[10.0,4.0,6000.0,40.0,null,4.5,114.3,152.0,64.0,64.0,105.0,105.0]
[11.0,5.0,null,60.0,null,5.56,141.3,190.0,79.0,76.0,124.0,124.0]
[12.0,6.0,null,"XS",null,6.62,168.3,229.0,95.0,89.0,143.0,143.0]
[13.0,8.0,null,80.0,null,8.62,219.1,305.0,127.0,102.0,178.0,178.0]
[14.0,10.0,null,100.0,null,10.75,273.0,381.0,159.0,127.0,216.0,216.0]
[15.0,12.0,null,120.0,null,12.75,323.8,457.0,190.0,152.0,254.0,254.0]
[16.0,14.0,null,140.0,null,14.0,355.6,533.0,222.0,165.0,279.0,279.0]
[17.0,16.0,null,160.0,null,16.0,406.4,610.0,254.0,178.0,305.0,305.0]
[18.0,18.0,null,"XXS",null,18.0,457.0,686.0,286.0,203.0,343.0,343.0]
[19.0,20.0,null,null,null,20.0,508.0,762.0,318.0,229.0,381.0,381.0]
[20.0,22.0,null,null,null,22.0,559.0,838.0,343.0,254.0,419.0,419.0]
[21.0,24.0,null,null,null,24.0,610.0,914.0,381.0,267.0,432.0,432.0]
[22.0,26.0,null,null,null,26.0,660.0,991.0,405.0,267.0,495.0,495.0]
[23.0,28.0,null,null,null,28.0,711.0,1067.0,438.0,267.0,521.0,521.0]
[24.0,30.0,null,null,null,30.0,762.0,1143.0,470.0,267.0,559.0,559.0]
[25.0,32.0,null,null,null,32.0,813.0,1219.0,502.0,267.0,597.0,597.0]
[26.0,34.0,null,null,null,34.0,864.0,1295.0,533.0,267.0,635.0,635.0]
[27.0,36.0,null,null,null,36.0,914.0,1372.0,565.0,267.0,673.0,673.0]
[28.0,38.0,null,null,null,38.0,965.0,1448.0,600.0,305.0,711.0,711.0]
[29.0,40.0,null,null,null,40.0,1016.0,1524.0,632.0,305.0,749.0,749.0]
[30.0,42.0,null,null,null,42.0,1067.0,1600.0,660.0,305.0,762.0,711.0]
[31.0,44.0,null,null,null,44.0,1118.0,1676.0,695.0,343.0,813.0,762.0]
[32.0,46.0,null,null,null,46.0,1168.0,1753.0,727.0,343.0,851.0,800.0]
[33.0,48.0,null,null,null,48.0,1219.0,1829.0,759.0,343.0,889.0,838.0]
[]
[]
[]
["Return sl no",16.0,4.0,13.0,1.0]
["Search res",{"$f":"VLOOKUP(B38,A2:G34,2,TRUE)","v":14},{"$f":"VLOOKUP(C38,A2:G34,3,TRUE)","v":600},{"$f":"VLOOKUP(D38,A2:D34,4,TRUE)","v":80},{"$f":"VLOOKUP(E38,A2:E34,5,FALSE)","v":"RF"},{"$f":"VLOOKUP(B38,A2:F34,6,TRUE)","v":14},{"$f":"VLOOKUP(B38,A2:G34,7,TRUE)","v":355.6},{"$f":"VLOOKUP(B38,A2:H34,8,TRUE)","v":533},{"$f":"VLOOKUP(B38,A2:I34,9,TRUE)","v":222},{"$f":"VLOOKUP(B38,A2:J34,10,TRUE)","v":165},{"$f":"VLOOKUP(B38,A2:K34,11,TRUE)","v":279},{"$f":"VLOOKUP(B38,A2:L34,12,TRUE)","v":279}]
["Return in calcul",null,null,null,null,null,{"$f":"ROUND(G39,0)","v":356}]
[1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0]
[]
[]
[]
["don't touch cell"]

{"sheet":"Reducing tee","index":2,"n_rows":223,"n_cols":13,"rows_kept":223,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"1st size","2nd size",null,"TEE C","TEE M",null,"1st size","2nd size",null,"RED H"]
[1.0,0.25,1.0,0.5,0.25,{"$f":"D2&E2","v":"0.50.25"},25.0,25.0,null,0.75,0.375,{"$f":"J2&K2","v":"0.750.375"},38.0]
[2.0,0.375,2.0,0.5,0.375,"0.50.375",25.0,25.0,null,0.75,0.5,"0.750.5",38.0]
[3.0,0.5,3.0,0.75,0.375,"0.750.375",29.0,29.0,null,1.0,0.5,"10.5",51.0]
[4.0,0.75,4.0,0.75,0.5,"0.750.5",29.0,29.0,null,1.0,0.75,"10.75",51.0]
[5.0,1.0,5.0,1.0,0.5,"10.5",38.0,38.0,null,1.25,0.5,"1.250.5",51.0]
[6.0,1.25,6.0,1.0,0.75,"10.75",38.0,38.0,null,1.25,0.75,"1.250.75",51.0]
[7.0,1.5,7.0,1.25,0.5,"1.250.5",48.0,48.0,null,1.25,1.0,"1.251",51.0]
[8.0,2.0,8.0,1.25,0.75,"1.250.75",48.0,48.0,null,1.5,0.5,"1.50.5",64.0]
[9.0,2.5,9.0,1.25,1.0,"1.251",48.0,48.0,null,1.5,0.75,"1.50.75",64.0]
[10.0,3.0,10.0,1.5,0.5,"1.50.5",57.0,57.0,null,1.5,1.0,"1.51",64.0]
[11.0,3.5,11.0,1.5,0.75,"1.50.75",57.0,57.0,null,1.5,1.25,"1.51.25",64.0]
[12.0,4.0,12.0,1.5,1.0,"1.51",57.0,57.0,null,2.0,0.75,"20.75",76.0]
[13.0,5.0,13.0,1.5,1.25,"1.51.25",57.0,57.0,null,2.0,1.0,"21",76.0]
[14.0,6.0,14.0,2.0,0.75,"20.75",64.0,44.0,null,2.0,1.25,"21.25",76.0]
[15.0,8.0,15.0,2.0,1.0,"21",64.0,51.0,null,2.0,1.5,"21.5",76.0]
[16.0,10.0,16.0,2.0,1.25,"21.25",64.0,57.0,null,2.5,1.0,"2.51",89.0]
[17.0,12.0,17.0,2.0,1.5,"21.5",64.0,60.0,null,2.5,1.25,"2.51.25",89.0]
[18.0,14.0,18.0,2.5,1.0,"2.51",76.0,57.0,null,2.5,1.5,"2.51.5",89.0]
[19.0,16.0,19.0,2.5,1.25,"2.51.25",76.0,64.0,null,2.5,2.0,"2.52",89.0]
[20.0,18.0,20.0,2.5,1.5,"2.51.5",76.0,67.0,null,3.0,1.25,"31.25",89.0]
[21.0,20.0,21.0,2.5,2.0,"2.52",76.0,70.0,null,3.0,1.5,"31.5",89.0]
[22.0,22.0,22.0,3.0,1.25,"31.25",86.0,70.0,null,3.0,2.0,"32",89.0]
[23.0,24.0,23.0,3.0,1.5,"31.5",86.0,73.0,null,3.0,2.5,"32.5",89.0]
[24.0,26.0,24.0,3.0,2.0,"32",86.0,76.0,null,3.5,1.25,"3.51.25",102.0]
[25.0,28.0,25.0,3.0,2.5,"32.5",86.0,83.0,null,3.5,1.5,"3.51.5",102.0]
[26.0,30.0,26.0,3.5,1.5,"3.51.5",95.0,79.0,null,3.5,2.0,"3.52",102.0]
[27.0,32.0,27.0,3.5,2.0,"3.52",95.0,83.0,null,3.5,2.5,"3.52.5",102.0]
[28.0,34.0,28.0,3.5,2.5,"3.52.5",95.0,89.0,null,3.5,3.0,"3.53",102.0]
[29.0,36.0,29.0,3.5,3.0,"3.53",95.0,92.0,null,4.0,1.5,"41.5",102.0]
[30.0,38.0,30.0,4.0,1.5,"41.5",105.0,86.0,null,4.0,2.0,"42",102.0]
[31.0,40.0,31.0,4.0,2.0,"42",105.0,89.0,null,4.0,2.5,"42.5",102.0]
[32.0,42.0,32.0,4.0,2.5,"42.5",105.0,95.0,null,4.0,3.0,"43",102.0]
[33.0,44.0,33.0,4.0,3.0,"43",105.0,98.0,null,4.0,3.5,"43.5",102.0]
[34.0,46.0,34.0,4.0,3.5,"43.5",105.0,102.0,null,5.0,2.0,"52",127.0]
[null,null,35.0,5.0,2.0,"52",124.0,105.0,null,5.0,2.5,"52.5",127.0]
[null,null,36.0,5.0,2.5,"52.5",124.0,108.0,null,5.0,3.0,"53",127.0]
[null,null,37.0,5.0,3.0,"53",124.0,111.0,null,5.0,3.5,"53.5",127.0]
[null,null,38.0,5.0,3.5,"53.5",124.0,114.0,null,5.0,4.0,"54",127.0]
[null,null,39.0,5.0,4.0,"54",125.0,117.0,null,6.0,2.5,"62.5",140.0]
[null,null,40.0,6.0,2.5,"62.5",143.0,121.0,null,6.0,3.0,"63",140.0]
[null,null,41.0,6.0,3.0,"63",143.0,124.0,null,6.0,3.5,"63.5",140.0]
[null,null,42.0,6.0,3.5,"63.5",143.0,127.0,null,6.0,4.0,"64",140.0]
[null,null,43.0,6.0,4.0,"64",143.0,130.0,null,6.0,5.0,"65",140.0]
[null,null,44.0,6.0,5.0,"65",143.0,137.0,null,8.0,3.5,"83.5",152.0]
[null,null,45.0,8.0,3.5,"83.5",178.0,152.0,null,8.0,4.0,"84",152.0]
[null,null,46.0,8.0,4.0,"84",178.0,156.0,null,8.0,5.0,"85",152.0]
[null,null,47.0,8.0,5.0,"85",178.0,162.0,null,8.0,6.0,"86",152.0]
[null,null,48.0,8.0,6.0,"86",178.0,168.0,null,10.0,4.0,"104",178.0]
[null,null,49.0,10.0,4.0,"104",216.0,184.0,null,10.0,5.0,"105",178.0]
[null,null,50.0,10.0,5.0,"105",216.0,191.0,null,10.0,6.0,"106",178.0]
[null,null,51.0,10.0,6.0,"106",216.0,194.0,null,10.0,8.0,"108",178.0]
[null,null,52.0,10.0,8.0,"108",216.0,203.0,null,12.0,5.0,"125",203.0]
[null,null,53.0,12.0,5.0,"125",254.0,216.0,null,12.0,6.0,"126",203.0]
[null,null,54.0,12.0,6.0,"126",254.0,219.0,null,12.0,8.0,"128",203.0]
[null,null,55.0,12.0,8.0,"128",254.0,229.0,null,12.0,10.0,"1210",203.0]
[null,null,56.0,12.0,10.0,"1210",254.0,241.0,null,14.0,6.0,"146",330.0]
[null,null,57.0,14.0,6.0,"146",279.0,238.0,null,14.0,8.0,"148",330.0]
[null,null,58.0,14.0,8.0,"148",279.0,248.0,null,14.0,10.0,"1410",330.0]
[null,null,59.0,14.0,10.0,"1410",279.0,257.0,null,14.0,12.0,"1412",330.0]
[null,null,60.0,14.0,12.0,"1412",279.0,270.0,null,16.0,8.0,"168",356.0]
[null,null,61.0,16.0,6.0,"166",305.0,264.0,null,16.0,10.0,"1610",356.0]
[null,null,62.0,16.0,8.0,"168",305.0,273.0,null,16.0,12.0,"1612",356.0]
[null,null,63.0,16.0,10.0,"1610",305.0,283.0,null,16.0,14.0,"1614",356.0]
[null,null,64.0,16.0,12.0,"1612",305.0,295.0,null,18.0,10.0,"1810",381.0]
[null,null,65.0,16.0,14.0,"1614",305.0,305.0,null,18.0,12.0,"1812",381.0]
[null,null,66.0,18.0,8.0,"188",343.0,298.0,null,18.0,14.0,"1814",381.0]
[null,null,67.0,18.0,10.0,"1810",343.0,308.0,null,18.0,16.0,"1816",381.0]
[null,null,68.0,18.0,12.0,"1812",343.0,321.0,null,20.0,12.0,"2012",508.0]
[null,null,69.0,18.0,14.0,"1814",343.0,330.0,null,20.0,14.0,"2014",508.0]
[null,null,70.0,18.0,16.0,"1816",343.0,330.0,null,20.0,16.0,"2016",508.0]
[null,null,71.0,20.0,8.0,"208",381.0,324.0,null,20.0,18.0,"2018",508.0]
[null,null,72.0,20.0,10.0,"2010",381.0,333.0,null,22.0,14.0,"2214",508.0]
[null,null,73.0,20.0,12.0,"2012",381.0,346.0,null,22.0,16.0,"2216",508.0]
[null,null,74.0,20.0,14.0,"2014",381.0,356.0,null,22.0,18.0,"2218",508.0]
[null,null,75.0,20.0,16.0,"2016",381.0,356.0,null,22.0,20.0,"2220",508.0]
[null,null,76.0,20.0,18.0,"2018",381.0,368.0,null,24.0,16.0,"2416",508.0]
[null,null,77.0,22.0,10.0,"2210",419.0,359.0,null,24.0,18.0,"2418",508.0]
[null,null,78.0,22.0,12.0,"2212",419.0,371.0,null,24.0,20.0,"2420",508.0]
[null,null,79.0,22.0,14.0,"2214",419.0,381.0,null,24.0,22.0,"2422",508.0]
[null,null,80.0,22.0,16.0,"2216",419.0,381.0,null,26.0,18.0,"2618",610.0]
[null,null,81.0,22.0,18.0,"2218",419.0,394.0,null,26.0,20.0,"2620",610.0]
[null,null,82.0,22.0,20.0,"2220",419.0,406.0,null,26.0,22.0,"2622",610.0]
[null,null,83.0,24.0,10.0,"2410",432.0,384.0,null,26.0,24.0,"2624",610.0]
[null,null,84.0,24.0,12.0,"2412",432.0,397.0,null,28.0,20.0,"2820",610.0]
[null,null,85.0,24.0,14.0,"2414",432.0,406.0,null,28.0,22.0,"2822",610.0]
[null,null,86.0,24.0,16.0,"2416",432.0,406.0,null,28.0,24.0,"2824",610.0]
[null,null,87.0,24.0,18.0,"2418",432.0,419.0,null,28.0,26.0,"2826",610.0]
[null,null,88.0,24.0,20.0,"2420",432.0,432.0,null,30.0,22.0,"3022",610.0]
[null,null,89.0,24.0,22.0,"2422",432.0,432.0,null,30.0,24.0,"3024",610.0]
[null,null,90.0,26.0,12.0,"2612",495.0,422.0,null,30.0,26.0,"3026",610.0]
[null,null,91.0,26.0,14.0,"2614",495.0,432.0,null,30.0,28.0,"3028",610.0]
[null,null,92.0,26.0,16.0,"2616",495.0,432.0,null,32.0,24.0,"3224",610.0]
[null,null,93.0,26.0,18.0,"2618",495.0,444.0,null,32.0,26.0,"3226",610.0]
[null,null,94.0,26.0,20.0,"2620",495.0,457.0,null,32.0,28.0,"3228",610.0]
[null,null,95.0,26.0,22.0,"2622",495.0,470.0,null,32.0,30.0,"3230",610.0]
[null,null,96.0,26.0,24.0,"2624",495.0,483.0,null,34.0,26.0,"3426",610.0]
[null,null,97.0,28.0,12.0,"2812",521.0,448.0,null,34.0,28.0,"3428",610.0]
[null,null,98.0,28.0,14.0,"2814",521.0,457.0,null,34.0,30.0,"3430",610.0]
[null,null,99.0,28.0,16.0,"2816",521.0,457.0,null,34.0,32.0,"3432",610.0]
[null,null,100.0,28.0,18.0,"2818",521.0,470.0,null,36.0,26.0,"3626",610.0]
[null,null,101.0,28.0,20.0,"2820",521.0,483.0,null,36.0,28.0,"3628",610.0]
[null,null,102.0,28.0,22.0,"2822",521.0,495.0,null,36.0,30.0,"3630",610.0]
[null,null,103.0,28.0,24.0,"2824",521.0,508.0,null,36.0,32.0,"3632",610.0]
[null,null,104.0,28.0,26.0,"2826",521.0,521.0,null,36.0,34.0,"3634",610.0]
[null,null,105.0,30.0,10.0,"3010",559.0,460.0,null,38.0,26.0,"3826",610.0]
[null,null,106.0,30.0,12.0,"3012",559.0,473.0,null,38.0,28.0,"3828",610.0]
[null,null,107.0,30.0,14.0,"3014",559.0,483.0,null,38.0,30.0,"3830",610.0]
[null,null,108.0,30.0,16.0,"3016",559.0,483.0,null,38.0,32.0,"3832",610.0]
[null,null,109.0,30.0,18.0,"3018",559.0,495.0,null,38.0,34.0,"3834",610.0]
[null,null,110.0,30.0,20.0,"3020",559.0,508.0,null,38.0,36.0,"3836",610.0]
[null,null,111.0,30.0,22.0,"3022",559.0,521.0,null,40.0,30.0,"4030",610.0]
[null,null,112.0,30.0,24.0,"3024",559.0,533.0,null,40.0,32.0,"4032",610.0]
[null,null,113.0,30.0,26.0,"3026",559.0,546.0,null,40.0,34.0,"4034",610.0]
[null,null,114.0,30.0,28.0,"3028",559.0,546.0,null,40.0,36.0,"4036",610.0]
[null,null,115.0,32.0,14.0,"3214",597.0,508.0,null,40.0,38.0,"4038",610.0]
[null,null,116.0,32.0,16.0,"3216",597.0,508.0,null,42.0,30.0,"4230",610.0]
[null,null,117.0,32.0,18.0,"3218",597.0,521.0,null,42.0,32.0,"4232",610.0]
[null,null,118.0,32.0,20.0,"3220",597.0,533.0,null,42.0,34.0,"4234",610.0]
[null,null,119.0,32.0,22.0,"3222",597.0,546.0,null,42.0,36.0,"4236",610.0]
[null,null,120.0,32.0,24.0,"3224",597.0,559.0,null,42.0,38.0,"4238",610.0]
[null,null,121.0,32.0,26.0,"3226",597.0,572.0,null,42.0,40.0,"4240",610.0]
[null,null,122.0,32.0,28.0,"3228",597.0,572.0,null,44.0,36.0,"4436",610.0]
[null,null,123.0,32.0,30.0,"3230",597.0,584.0,null,44.0,38.0,"4438",610.0]
[null,null,124.0,34.0,16.0,"3416",635.0,533.0,null,44.0,40.0,"4440",610.0]
[null,null,125.0,34.0,18.0,"3418",635.0,546.0,null,44.0,42.0,"4442",610.0]
[null,null,126.0,34.0,20.0,"3420",635.0,559.0,null,46.0,38.0,"4638",711.0]
[null,null,127.0,34.0,22.0,"3422",635.0,572.0,null,46.0,40.0,"4640",711.0]
[null,null,128.0,34.0,24.0,"3424",635.0,584.0,null,46.0,42.0,"4642",711.0]
[null,null,129.0,34.0,26.0,"3426",635.0,597.0,null,46.0,44.0,"4644",711.0]
[null,null,130.0,34.0,28.0,"3428",635.0,597.0,null,48.0,40.0,"4840",711.0]
[null,null,131.0,34.0,30.0,"3430",635.0,610.0,null,48.0,42.0,"4842",711.0]
[null,null,132.0,34.0,32.0,"3432",635.0,622.0,null,48.0,44.0,"4844",711.0]
[null,null,133.0,36.0,16.0,"3616",673.0,559.0,null,48.0,46.0,"4846",711.0]
[null,null,134.0,36.0,18.0,"3618",673.0,572.0,null,null,null,""]
[null,null,135.0,36.0,20.0,"3620",673.0,584.0,null,null,null,""]
[null,null,136.0,36.0,22.0,"3622",673.0,597.0,null,null,null,""]
[null,null,137.0,36.0,24.0,"3624",673.0,610.0,null,null,null,""]
[null,null,138.0,36.0,26.0,"3626",673.0,622.0,null,null,null,""]
[null,null,139.0,36.0,28.0,"3628",673.0,622.0,null,null,null,""]
[null,null,140.0,36.0,30.0,"3630",673.0,635.0,null,null,null,""]
[null,null,141.0,36.0,32.0,"3632",673.0,648.0,null,null,null,""]
[null,null,142.0,36.0,34.0,"3634",673.0,660.0,null,null,null,""]
[null,null,143.0,38.0,18.0,"3818",711.0,597.0,null,null,null,""]
[null,null,144.0,38.0,20.0,"3820",711.0,610.0,null,null,null,""]
[null,null,145.0,38.0,22.0,"3822",711.0,622.0,null,null,null,""]
[null,null,146.0,38.0,24.0,"3824",711.0,635.0,null,null,null,""]
[null,null,147.0,38.0,26.0,"3826",711.0,648.0,null,null,null,""]
[null,null,148.0,38.0,28.0,"3828",711.0,648.0,null,null,null,""]
[null,null,149.0,38.0,30.0,"3830",711.0,673.0,null,null,null,""]
[null,null,150.0,38.0,32.0,"3832",711.0,686.0,null,null,null,""]
[null,null,151.0,38.0,34.0,"3834",711.0,698.0,null,null,null,""]
[null,null,152.0,38.0,36.0,"3836",711.0,711.0,null,null,null,""]
[null,null,153.0,40.0,18.0,"4018",749.0,622.0,null,null,null,""]
[null,null,154.0,40.0,20.0,"4020",749.0,635.0,null,null,null,""]
[null,null,155.0,40.0,22.0,"4022",749.0,648.0,null,null,null,""]
[null,null,156.0,40.0,24.0,"4024",749.0,660.0,null,null,null,""]
[null,null,157.0,40.0,26.0,"4026",749.0,673.0,null,null,null,""]
[null,null,158.0,40.0,28.0,"4028",749.0,673.0,null,null,null,""]
[null,null,159.0,40.0,30.0,"4030",749.0,698.0,null,null,null,""]
[null,null,160.0,40.0,32.0,"4032",749.0,711.0,null,null,null,""]
[null,null,161.0,40.0,34.0,"4034",749.0,724.0,null,null,null,""]
[null,null,162.0,40.0,36.0,"4036",749.0,737.0,null,null,null,""]
[null,null,163.0,40.0,38.0,"4038",749.0,749.0,null,null,null,""]
[null,null,164.0,42.0,16.0,"4216",762.0,635.0,null,null,null,""]
[null,null,165.0,42.0,18.0,"4218",762.0,648.0,null,null,null,""]
[null,null,166.0,42.0,20.0,"4220",762.0,660.0,null,null,null,""]
[null,null,167.0,42.0,22.0,"4222",762.0,660.0,null,null,null,""]
[null,null,168.0,42.0,24.0,"4224",762.0,660.0,null,null,null,""]
[null,null,169.0,42.0,26.0,"4226",762.0,698.0,null,null,null,""]
[null,null,170.0,42.0,28.0,"4228",762.0,698.0,null,null,null,""]
[null,null,171.0,42.0,30.0,"4230",762.0,711.0,null,null,null,""]
[null,null,172.0,42.0,32.0,"4232",762.0,711.0,null,null,null,""]
[null,null,173.0,42.0,34.0,"4234",762.0,711.0,null,null,null,""]
[null,null,174.0,42.0,36.0,"4236",762.0,711.0,null,null,null,""]
[null,null,175.0,42.0,38.0,"4238",762.0,711.0,null,null,null,""]
[null,null,176.0,42.0,40.0,"4240",762.0,711.0,null,null,null,""]
[null,null,177.0,44.0,22.0,"4422",813.0,686.0,null,null,null,""]
[null,null,178.0,44.0,24.0,"4424",813.0,698.0,null,null,null,""]
[null,null,179.0,44.0,26.0,"4426",813.0,698.0,null,null,null,""]
[null,null,180.0,44.0,28.0,"4428",813.0,698.0,null,null,null,""]
[null,null,181.0,44.0,30.0,"4430",813.0,711.0,null,null,null,""]
[null,null,182.0,44.0,32.0,"4432",813.0,711.0,null,null,null,""]
[null,null,183.0,44.0,34.0,"4434",813.0,724.0,null,null,null,""]
[null,null,184.0,44.0,36.0,"4436",813.0,724.0,null,null,null,""]
[null,null,185.0,44.0,38.0,"4438",813.0,737.0,null,null,null,""]
[null,null,186.0,44.0,40.0,"4440",813.0,749.0,null,null,null,""]
[null,null,187.0,44.0,42.0,"4442",813.0,762.0,null,null,null,""]
[null,null,188.0,44.0,20.0,"4420",813.0,686.0,null,null,null,""]
[null,null,189.0,46.0,22.0,"4622",851.0,724.0,null,null,null,""]
[null,null,190.0,46.0,24.0,"4624",851.0,724.0,null,null,null,""]
[null,null,191.0,46.0,26.0,"4626",851.0,737.0,null,null,null,""]
[null,null,192.0,46.0,28.0,"4628",851.0,737.0,null,null,null,""]
[null,null,193.0,46.0,30.0,"4630",851.0,737.0,null,null,null,""]
[null,null,194.0,46.0,32.0,"4632",851.0,749.0,null,null,null,""]
[null,null,195.0,46.0,34.0,"4634",851.0,749.0,null,null,null,""]
[null,null,196.0,46.0,36.0,"4636",851.0,762.0,null,null,null,""]
[null,null,197.0,46.0,38.0,"4638",851.0,762.0,null,null,null,""]
[null,null,198.0,46.0,40.0,"4640",851.0,775.0,null,null,null,""]
[null,null,199.0,46.0,42.0,"4642",851.0,787.0,null,null,null,""]
[null,null,200.0,46.0,44.0,"4644",851.0,800.0,null,null,null,""]
[null,null,201.0,48.0,22.0,"4822",889.0,737.0,null,null,null,""]
[null,null,202.0,48.0,24.0,"4824",889.0,737.0,null,null,null,""]
[null,null,203.0,48.0,26.0,"4826",889.0,762.0,null,null,null,""]
[null,null,204.0,48.0,28.0,"4828",889.0,762.0,null,null,null,""]
[null,null,205.0,48.0,30.0,"4830",889.0,762.0,null,null,null,""]
[null,null,206.0,48.0,32.0,"4832",889.0,787.0,null,null,null,""]
[null,null,207.0,48.0,34.0,"4834",889.0,787.0,null,null,null,""]
[null,null,208.0,48.0,36.0,"4836",889.0,787.0,null,null,null,""]
[null,null,209.0,48.0,38.0,"4838",889.0,813.0,null,null,null,""]
[null,null,210.0,48.0,40.0,"4840",889.0,813.0,null,null,null,""]
[null,null,211.0,48.0,42.0,"4842",889.0,813.0,null,null,null,""]
[null,null,212.0,48.0,44.0,"4844",889.0,838.0,null,null,null,""]
[null,null,213.0,48.0,46.0,"4846",889.0,838.0,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Size 2",null,"Size 1","size12",null,null,null,null,"Size 1","size12"]
[null,null,null,{"$f":"'General Data'!B39","v":14},{"$f":"D217&B220","v":"141"},null,null,null,null,{"$f":"D217","v":14},{"$f":"J217&B220","v":"141"}]
[]
["Return sl no",5.0]
["Search res",{"$f":"VLOOKUP(B219,A2:B35,2,TRUE)","v":1},null,null,null,null,{"$f":"(VLOOKUP(E217,F2:G214,2,FALSE))","v":"#N/A"},{"$f":"(VLOOKUP(E217,F2:H214,3,FALSE))","v":"#N/A"},null,null,null,null,{"$f":"(VLOOKUP(K217,L2:M134,2,FALSE))","v":"#N/A"}]
["Return in calcul",null,null,null,null,null,{"$f":"G220","v":"#N/A"},"#N/A",null,null,null,null,{"$f":"M220","v":"#N/A"}]
[null,null,null,null,null,null,{"$f":"ISERROR(G221)","v":true},true,null,null,null,null,{"$f":"ISERROR(M221)","v":true}]
[null,null,null,null,null,null,{"$f":"IF(G222=TRUE,\"….\",G221)","v":"…."},"….",null,null,null,null,{"$f":"IF(M222=TRUE,\"….\",M221)","v":"…."}]

{"sheet":"Valve","index":3,"n_rows":174,"n_cols":14,"rows_kept":174,"cut":false,"hidden":false,"merged":[]}
["Size","Rating",null,"Gate",null,"Check",null,"Check D",null,"Globe",null,"Plug",null,"Ball"]
[0.25,125.0,{"$f":"B2&A2","v":"1250.25"},"...",null,". . .",null,"...",null,". . .",null,".",null,"..."]
[0.375,125.0,"1250.375",". . .",null,". . .",null,"...",null,". . .",null,".",null,". . ."]
[0.5,125.0,"1250.5","..,",null,"...",null,"...",null,"...",null,"...",null,"..,"]
[0.75,125.0,"1250.75","...",null,". . .",null,"...",null,". . .",null,"...",null,"..."]
[1.0,125.0,"1251",". . .",null,"...",null,"...",null,"...",null,140.0,null,". . ."]
[1.25,125.0,"1251.25",". . .",null,". . .",null,"...",null,". . .",null,"...",null,". . ."]
[1.5,125.0,"1251.5",". . .",null,". . .",null,"...",null,". . .",null,165.0,null,". . ."]
[2.0,125.0,"1252",178.0,null,203.0,null,"...",null,203.0,null,190.0,null,178.0]
[2.5,125.0,"1252.5",190.0,null,216.0,null,"...",null,216.0,null,210.0,null,190.0]
[3.0,125.0,"1253",203.0,null,241.0,null,"...",null,241.0,null,229.0,null,203.0]
[4.0,125.0,"1254",229.0,null,292.0,null,"...",null,292.0,null,229.0,null,229.0]
[5.0,125.0,"1255",254.0,null,330.0,null,"...",null,330.0,null,356.0,null,254.0]
[6.0,125.0,"1256",267.0,null,356.0,null,"...",null,356.0,null,394.0,null,267.0]
[8.0,125.0,"1258",292.0,null,495.0,null,"...",null,495.0,null,457.0,null,292.0]
[10.0,125.0,"12510",330.0,null,622.0,null,"...",null,622.0,null,533.0,null,330.0]
[12.0,125.0,"12512",356.0,null,698.0,null,"...",null,698.0,null,610.0,null,356.0]
[14.0,125.0,"12514",381.0,null,787.0,null,"...",null,787.0,null,686.0,null,381.0]
[16.0,125.0,"12516",406.0,null,914.0,null,"...",null,914.0,null,762.0,null,406.0]
[18.0,125.0,"12518",432.0,null,". .",null,"...",null,". .",null,864.0,null,432.0]
[20.0,125.0,"12520",457.0,null,"...",null,"...",null,"...",null,914.0,null,457.0]
[22.0,125.0,"12522",". . .",null,". .",null,"...",null,". .",null,"...",null,". . ."]
[24.0,125.0,"12524",508.0,null,"...",null,"...",null,"...",null,1067.0,null,508.0]
[26.0,125.0,"12526","...",null,". .",null,"...",null,". .",null,"...",null,"..."]
[28.0,125.0,"12528","...",null,"..",null,"...",null,"..",null,".",null,"..."]
[30.0,125.0,"12530",". .",null,". .",null,"...",null,". .",null,1295.0,null,". ."]
[32.0,125.0,"12532",". .",null,"...",null,"...",null,"...",null,"...",null,". ."]
[34.0,125.0,"12534",". .",null,". .",null,"...",null,". .",null,".",null,". ."]
[36.0,125.0,"12536",". .",null,". .",null,"...",null,". .",null,1600.0,null,". ."]
[0.25,150.0,"1500.25",102.0,null,102.0,null,51.0,null,102.0,null,"...",null,"..."]
[0.375,150.0,"1500.375",102.0,null,102.0,null,51.0,null,102.0,null,"...",null,". . ."]
[0.5,150.0,"1500.5",108.0,null,108.0,null,57.0,null,108.0,null,"...",null,108.0]
[0.75,150.0,"1500.75",117.0,null,117.0,null,64.0,null,117.0,null,"...",null,117.0]
[1.0,150.0,"1501",127.0,null,127.0,null,70.0,null,127.0,null,"...",null,127.0]
[1.25,150.0,"1501.25",140.0,null,140.0,null,76.0,null,140.0,null,"...",null,140.0]
[1.5,150.0,"1501.5",165.0,null,165.0,null,83.0,null,165.0,null,"...",null,165.0]
[2.0,150.0,"1502",178.0,null,203.0,null,102.0,null,203.0,null,"...",null,178.0]
[2.5,150.0,"1502.5",190.0,null,216.0,null,108.0,null,216.0,null,"...",null,190.0]
[3.0,150.0,"1503",203.0,null,241.0,null,121.0,null,241.0,null,"...",null,203.0]
[4.0,150.0,"1504",229.0,null,292.0,null,146.0,null,292.0,null,305.0,null,229.0]
[5.0,150.0,"1505",254.0,null,356.0,null,178.0,null,356.0,null,381.0,null,"..."]
[6.0,150.0,"1506",267.0,null,406.0,null,203.0,null,406.0,null,394.0,null,394.0]
[8.0,150.0,"1508",292.0,null,495.0,null,248.0,null,495.0,null,457.0,null,457.0]
[10.0,150.0,"15010",330.0,null,622.0,null,"31 1",null,622.0,null,533.0,null,533.0]
[12.0,150.0,"15012",356.0,null,698.0,null,349.0,null,698.0,null,610.0,null,610.0]
[14.0,150.0,"15014",381.0,null,787.0,null,394.0,null,787.0,null,686.0,null,686.0]
[16.0,150.0,"15016",406.0,null,914.0,null,457.0,null,914.0,null,762.0,null,762.0]
[18.0,150.0,"15018",432.0,null,978.0,null,"...",null,978.0,null,864.0,null,864.0]
[20.0,150.0,"15020",457.0,null,978.0,null,"...",null,978.0,null,914.0,null,914.0]
[22.0,150.0,"15022","...",null,1067.0,null,"...",null,1067.0,null,". . .",null,". . ."]
[24.0,150.0,"15024",508.0,null,1295.0,null,"...",null,1295.0,null,1067.0,null,1067.0]
[26.0,150.0,"15026",559.0,null,1295.0,null,"...",null,1295.0,null,". . .",null,". . ."]
[28.0,150.0,"15028",610.0,null,1448.0,null,"...",null,1448.0,null,". . .",null,". . ."]
[30.0,150.0,"15030",610.0,null,1524.0,null,"...",null,1524.0,null,". . .",null,". . ."]
[32.0,150.0,"15032","...",null,"...",null,"...",null,"...",null,"...",null,"..."]
[34.0,150.0,"15034","...",null,"...",null,"...",null,"...",null,". . .",null,"..."]
[36.0,150.0,"15036",711.0,null,1956.0,null,"...",null,1956.0,null,". . .",null,"..."]
[0.5,300.0,"3000.5",140.0,null,"...",null,"...",null,152.0,null,"...",null,140.0]
[0.75,300.0,"3000.75",152.0,null,"...",null,"...",null,178.0,null,"...",null,152.0]
[1.0,300.0,"3001",165.0,null,215.0,null,"...",null,203.0,null,"...",null,165.0]
[1.25,300.0,"3001.25",178.0,null,229.0,null,"...",null,216.0,null,"...",null,178.0]
[1.5,300.0,"3001.5",190.0,null,241.0,null,"...",null,229.0,null,"...",null,190.0]
[2.0,300.0,"3002",216.0,null,267.0,null,"...",null,267.0,null,"...",null,216.0]
[2.5,300.0,"3002.5",241.0,null,292.0,null,"...",null,292.0,null,"...",null,241.0]
[3.0,300.0,"3003",282.0,null,318.0,null,159.0,null,318.0,null,"...",null,282.0]
[4.0,300.0,"3004",305.0,null,356.0,null,178.0,null,356.0,null,"...",null,305.0]
[5.0,300.0,"3005",381.0,null,400.0,null,200.0,null,400.0,null,"...",null,". . ."]
[6.0,300.0,"3006",403.0,null,444.0,null,222.0,null,444.0,null,403.0,null,403.0]
[8.0,300.0,"3008",419.0,null,533.0,null,279.0,null,559.0,null,502.0,null,502.0]
[10.0,300.0,"30010",457.0,null,622.0,null,"31 1",null,622.0,null,568.0,null,568.0]
[12.0,300.0,"30012",502.0,null,711.0,null,356.0,null,711.0,null,711.0,null,648.0]
[14.0,300.0,"30014",762.0,null,838.0,null,". . .",null,"...",null,762.0,null,762.0]
[16.0,300.0,"30016",838.0,null,864.0,null,". . .",null,"...",null,838.0,null,838.0]
[18.0,300.0,"30018",914.0,null,978.0,null,". . .",null,"...",null,914.0,null,914.0]
[20.0,300.0,"30020",991.0,null,1016.0,null,". . .",null,"...",null,991.0,null,"99 1"]
[22.0,300.0,"30022",1092.0,null,1118.0,null,". . .",null,"...",null,1092.0,null,1092.0]
[24.0,300.0,"30024",1143.0,null,1346.0,null,". . .",null,"...",null,1143.0,null,1143.0]
[26.0,300.0,"30026",1245.0,null,1346.0,null,". . .",null,"...",null,1245.0,null,1245.0]
[28.0,300.0,"30028",1346.0,null,1499.0,null,". . .",null,"...",null,1346.0,null,1346.0]
[30.0,300.0,"30030",1397.0,null,1594.0,null,". . .",null,"...",null,1397.0,null,1397.0]
[32.0,300.0,"30032",1524.0,null,". . .",null,". . .",null,"...",null,1524.0,null,1524.0]
[34.0,300.0,"30034",1626.0,null,". . .",null,". . .",null,"...",null,1626.0,null,1626.0]
[36.0,300.0,"30036",1727.0,null,2083.0,null,". . .",null,"...",null,1727.0,null,1727.0]
[0.5,600.0,"6000.5",165.0,null,165.0,null,83.0,null,165.0,null,"...",null,165.0]
[0.75,600.0,"6000.75",190.0,null,190.0,null,95.0,null,190.0,null,"...",null,190.0]
[1.0,600.0,"6001",241.0,null,241.0,null,121.0,null,241.0,null,216.0,null,241.0]
[1.25,600.0,"6001.25",330.0,null,330.0,null,165.0,null,330.0,null,229.0,null,330.0]
[1.5,600.0,"6001.5",216.0,null,216.0,null,108.0,null,216.0,null,241.0,null,216.0]
[2.0,600.0,"6002",229.0,null,229.0,null,114.0,null,229.0,null,330.0,null,229.0]
[2.5,600.0,"6002.5",292.0,null,292.0,null,146.0,null,292.0,null,292.0,null,292.0]
[3.0,600.0,"6003",356.0,null,356.0,null,178.0,null,356.0,null,356.0,null,356.0]
[4.0,600.0,"6004",432.0,null,432.0,null,216.0,null,432.0,null,432.0,null,432.0]
[5.0,600.0,"6005",508.0,null,508.0,null,254.0,null,508.0,null,"...",null,"..."]
[6.0,600.0,"6006",559.0,null,559.0,null,279.0,null,559.0,null,559.0,null,559.0]
[8.0,600.0,"6008",660.0,null,660.0,null,330.0,null,660.0,null,660.0,null,660.0]
[10.0,600.0,"60010",787.0,null,787.0,null,394.0,null,787.0,null,787.0,null,787.0]
[12.0,600.0,"60012",838.0,null,838.0,null,419.0,null,838.0,null,838.0,null,838.0]
[14.0,600.0,"60014",889.0,null,889.0,null,"...",null,889.0,null,889.0,null,889.0]
[16.0,600.0,"60016",991.0,null,991.0,null,". . .",null,991.0,null,"99 1",null,991.0]
[18.0,600.0,"60018",1092.0,null,1092.0,null,". . .",null,1092.0,null,1092.0,null,1092.0]
[20.0,600.0,"60020",1194.0,null,1194.0,null,"...",null,1194.0,null,"1194(",null,1194.0]
[22.0,600.0,"60022",1295.0,null,1295.0,null,". . .",null,1295.0,null,1295.0,null,1295.0]
[24.0,600.0,"60024",1397.0,null,1397.0,null,". . .",null,1397.0,null,1397.0,null,1397.0]
[26.0,600.0,"60026",1448.0,null,1448.0,null,". . .",null,1448.0,null,1448.0,null,1448.0]
[28.0,600.0,"60028",1549.0,null,1600.0,null,"...",null,1600.0,null,"...",null,1549.0]
[30.0,600.0,"60030",1651.0,null,1651.0,null,". . .",null,1651.0,null,1778.0,null,1651.0]
[32.0,600.0,"60032",1778.0,null,"...",null,". . .",null,"...",null,1778.0,null,1778.0]
[34.0,600.0,"60034",1930.0,null,"...",null,". . .",null,"...",null,1930.0,null,1930.0]
[36.0,600.0,"60036",2083.0,null,2083.0,null,". . .",null,2083.0,null,2083.0,null,2083.0]
[0.75,900.0,"9000.75",". .",null,229.0,null,114.0,null,229.0,null,"...",null,". . ."]
[1.0,900.0,"9001",254.0,null,254.0,null,127.0,null,254.0,null,254.0,null,254.0]
[1.25,900.0,"9001.25",279.0,null,279.0,null,140.0,null,279.0,null,279.0,null,279.0]
[1.5,900.0,"9001.5",305.0,null,305.0,null,152.0,null,305.0,null,305.0,null,305.0]
[2.0,900.0,"9002",368.0,null,368.0,null,184.0,null,368.0,null,368.0,null,368.0]
[2.5,900.0,"9002.5",419.0,null,419.0,null,210.0,null,419.0,null,419.0,null,419.0]
[3.0,900.0,"9003",381.0,null,381.0,null,190.0,null,381.0,null,381.0,null,381.0]
[4.0,900.0,"9004",457.0,null,457.0,null,229.0,null,457.0,null,457.0,null,457.0]
[5.0,900.0,"9005",559.0,null,559.0,null,279.0,null,559.0,null,"...",null,610.0]
[6.0,900.0,"9006",610.0,null,610.0,null,305.0,null,610.0,null,610.0,null,737.0]
[8.0,900.0,"9008",737.0,null,737.0,null,368.0,null,737.0,null,737.0,null,838.0]
[10.0,900.0,"90010",838.0,null,838.0,null,419.0,null,838.0,null,838.0,null,965.0]
[12.0,900.0,"90012",965.0,null,965.0,null,483.0,null,965.0,null,965.0,null,1029.0]
[14.0,900.0,"90014",1029.0,null,1029.0,null,514.0,null,1029.0,null,"...",null,1130.0]
[16.0,900.0,"90016",1130.0,null,1130.0,null,660.0,null,1130.0,null,1130.0,null,1219.0]
[18.0,900.0,"90018",1219.0,null,1219.0,null,737.0,null,1219.0,null,"...",null,1321.0]
[20.0,900.0,"90020",1321.0,null,1321.0,null,826.0,null,1321.0,null,1321.0,null,1549.0]
[22.0,900.0,"90022","...",null,"...",null,991.0,null,"...",null,"...",null,". . ."]
[24.0,900.0,"90024",1549.0,null,1549.0,null,". . .",null,1549.0,null,"...",null,". . ."]
[0.5,1500.0,"15000.5","...",null,216.0,null,108.0,null,216.0,null,"...",null,". . ."]
[0.75,1500.0,"15000.75","...",null,229.0,null,114.0,null,229.0,null,"...",null,". . ."]
[1.0,1500.0,"15001",254.0,null,254.0,null,127.0,null,254.0,null,254.0,null,". . ."]
[1.25,1500.0,"15001.25",279.0,null,279.0,null,140.0,null,279.0,null,279.0,null,". . ."]
[1.5,1500.0,"15001.5",305.0,null,305.0,null,152.0,null,305.0,null,305.0,null,". . ."]
[2.0,1500.0,"15002",368.0,null,368.0,null,184.0,null,368.0,null,368.0,null,368.0]
[2.5,1500.0,"15002.5",419.0,null,419.0,null,210.0,null,419.0,null,419.0,null,419.0]
[3.0,1500.0,"15003",470.0,null,470.0,null,235.0,null,470.0,null,470.0,null,470.0]
[4.0,1500.0,"15004",546.0,null,546.0,null,273.0,null,546.0,null,546.0,null,546.0]
[5.0,1500.0,"15005",673.0,null,673.0,null,337.0,null,673.0,null,"...",null,". . ."]
[6.0,1500.0,"15006",705.0,null,705.0,null,353.0,null,705.0,null,705.0,null,705.0]
[8.0,1500.0,"15008",832.0,null,832.0,null,416.0,null,832.0,null,832.0,null,832.0]
[10.0,1500.0,"150010","99 1",null,991.0,null,495.0,null,991.0,null,991.0,null,991.0]
[12.0,1500.0,"150012",1130.0,null,1130.0,null,565.0,null,1130.0,null,1130.0,null,1130.0]
[14.0,1500.0,"150014",1257.0,null,1257.0,null,629.0,null,1257.0,null,"...",null,1257.0]
[16.0,1500.0,"150016",1384.0,null,1384.0,null,". . .",null,1384.0,null,1384.0,null,1384.0]
[18.0,1500.0,"150018",1537.0,null,1537.0,null,". . .",null,1537.0,null,"...",null,"..."]
[20.0,1500.0,"150020",1664.0,null,1664.0,null,". . .",null,1664.0,null,"...",null,"..."]
[22.0,1500.0,"150022","...",null,"...",null,". . .",null,"...",null,"...",null,"..."]
[24.0,1500.0,"150024",1943.0,null,1943.0,null,". . .",null,1943.0,null,"...",null,"..."]
[0.5,2500.0,"25000.5",264.0,null,264.0,null,132.0,null,264.0,null,". . .",null,"..."]
[0.75,2500.0,"25000.75",273.0,null,273.0,null,137.0,null,273.0,null,". . .",null,"..."]
[1.0,2500.0,"25001",308.0,null,308.0,null,154.0,null,308.0,null,308.0,null,"..."]
[1.25,2500.0,"25001.25",349.0,null,349.0,null,175.0,null,349.0,null,"...",null,"..."]
[1.5,2500.0,"25001.5",384.0,null,384.0,null,192.0,null,384.0,null,384.0,null,"..."]
[2.0,2500.0,"25002","45 1",null,451.0,null,226.0,null,451.0,null,451.0,null,451.0]
[2.5,2500.0,"25002.5",508.0,null,508.0,null,254.0,null,508.0,null,508.0,null,508.0]
[3.0,2500.0,"25003",578.0,null,578.0,null,289.0,null,578.0,null,578.0,null,578.0]
[4.0,2500.0,"25004",673.0,null,673.0,null,337.0,null,673.0,null,673.0,null,673.0]
[5.0,2500.0,"25005",794.0,null,794.0,null,397.0,null,794.0,null,794.0,null,"..."]
[6.0,2500.0,"25006",914.0,null,914.0,null,457.0,null,914.0,null,914.0,null,914.0]
[8.0,2500.0,"25008",1022.0,null,1022.0,null,"51 1",null,1022.0,null,1022.0,null,1022.0]
[10.0,2500.0,"250010",1270.0,null,1270.0,null,635.0,null,1270.0,null,1270.0,null,1270.0]
[12.0,2500.0,"250012",1422.0,null,1422.0,null,"71 1",null,1422.0,null,1422.0,null,1422.0]
[14.0,2500.0,"250014",". .",null,"...",null,". . .",null,"...",null,"...",null,"..."]
[16.0,2500.0,"250016",". .",null,"...",null,". . .",null,"...",null,"...",null,"..."]
[18.0,2500.0,"250018",". . .",null,"...",null,"...",null,"...",null,". . .",null,"..."]
[]
[]
[]
[null,null,null,"rating",null,"rating",null,"rating",null,"rating",null,"rating",null,"rating"]
["Sl no return",null,null,{"$f":"VLOOKUP(C172,C2:D165,2,FALSE)","v":889},null,{"$f":"VLOOKUP(C172,C2:F165,4,FALSE)","v":889},null,{"$f":"VLOOKUP(C172,C2:H165,6,FALSE)","v":"..."},null,{"$f":"VLOOKUP(C172,C2:J165,8,FALSE)","v":889},null,{"$f":"VLOOKUP(C172,C2:L165,10,FALSE)","v":889},null,{"$f":"VLOOKUP(C172,C2:N165,12,FALSE)","v":889}]
["value taken from data",{"$f":"'General Data'!B39","v":14},null,{"$f":"'General Data'!C39","v":600},null,{"$f":"'General Data'!M39","v":""},null,null,null,{"$f":"'General Data'!S39","v":""},null,{"$f":"'General Data'!Y39","v":""},null,{"$f":"'General Data'!AE39","v":""}]
["value returned",null,{"$f":"D171&B171","v":"60014"},{"$f":"D170","v":889},null,{"$f":"F170","v":889},null,{"$f":"H170","v":"..."},null,{"$f":"J170","v":889},null,{"$f":"L170","v":889},null,{"$f":"N170","v":889}]
[null,null,null,{"$f":"ISERROR(D172)","v":false},null,{"$f":"ISERROR(F172)","v":false},null,{"$f":"ISERROR(H172)","v":false},null,{"$f":"ISERROR(J172)","v":false},null,{"$f":"ISERROR(L172)","v":false},null,{"$f":"ISERROR(N172)","v":false}]
[null,null,null,{"$f":"IF(D173=TRUE,\"….\",D172)","v":889},null,{"$f":"IF(F173=TRUE,\"….\",F172)","v":889},null,{"$f":"IF(H173=TRUE,\"….\",H172)","v":"..."},null,{"$f":"IF(J173=TRUE,\"….\",J172)","v":889},null,{"$f":"IF(L173=TRUE,\"….\",L172)","v":889},null,{"$f":"IF(N173=TRUE,\"….\",N172)","v":889}]

{"sheet":"Flanges","index":4,"n_rows":162,"n_cols":19,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"WN",null,null,null,null,null,null,"RJ"]
["Size","Rating",null,"B","L","No.of Bolt","Bolt Dia","Bolt Len.","Weight","S","BL. Flange","B","L","No.of Bolt","Bolt Dia","Bolt Len.","Weight","S","BL. Flange"]
[0.5,150.0,{"$f":"B3&A3","v":"1500.5"},"60,3",48.0,4.0,null,null,0.6,11.2]
[0.75,150.0,"1500.75","69,8",52.0,4.0,null,null,0.8,12.7]
[1.0,150.0,"1501",79.4,56.0,4.0,null,null,1.1,14.3]
[1.25,150.0,"1501.25",88.9,57.0,4.0,null,null,1.4,15.7]
[1.5,150.0,"1501.5",98.4,62.0,4.0,null,null,1.8,17.5]
[2.0,150.0,"1502",120.6,63.0,4.0,null,null,2.7,19.1]
[2.5,150.0,"1502.5",139.7,70.0,4.0,null,null,4.0,22.3]
[3.0,150.0,"1503",152.4,70.0,4.0,null,null,4.5,23.9]
[3.5,150.0,"1503.5",177.8,71.0,8.0,null,null,6.2,23.9]
[4.0,150.0,"1504",190.5,76.0,8.0,null,null,7.0,23.9]
[5.0,150.0,"1505",215.9,89.0,8.0,null,null,8.6,23.9]
[6.0,150.0,"1506",241.3,89.0,8.0,null,null,10.8,25.4]
[8.0,150.0,"1508",298.4,102.0,8.0,null,null,18.0,28.5]
[10.0,150.0,"15010",362.0,102.0,12.0,null,null,24.0,30.2]
[12.0,150.0,"15012",431.8,114.0,12.0,null,null,37.0,31.8]
[14.0,150.0,"15014",476.2,127.0,12.0,null,null,47.0,35.0]
[16.0,150.0,"15016",539.8,127.0,16.0,null,null,58.0,36.6]
[18.0,150.0,"15018",577.8,140.0,16.0,null,null,64.0,39.7]
[20.0,150.0,"15020",635.0,144.0,20.0,null,null,77.0,42.9]
[24.0,150.0,"15024",749.3,152.0,20.0,null,null,118.0,47.7]
[0.5,300.0,"3000.5",34.9,52.0,4.0,null,null,1.5,14.2]
[0.75,300.0,"3000.75",42.9,57.0,4.0,null,null,1.8,15.7]
[1.0,300.0,"3001",50.8,62.0,4.0,null,null,2.0,17.5]
[1.25,300.0,"3001.25",63.5,65.0,4.0,null,null,2.5,19.0]
[1.5,300.0,"3001.5",73.0,68.0,4.0,null,null,3.5,20.6]
[2.0,300.0,"3002",92.1,70.0,8.0,null,null,4.0,22.4]
[2.5,300.0,"3002.5",104.8,76.0,8.0,null,null,5.0,25.4]
[3.0,300.0,"3003",127.0,79.0,8.0,null,null,7.0,28.4]
[3.5,300.0,"3003.5",139.7,81.0,8.0,null,null,9.2,30.2]
[4.0,300.0,"3004",157.2,86.0,8.0,null,null,11.0,31.8]
[5.0,300.0,"3005",185.7,98.0,8.0,null,null,14.0,35.0]
[6.0,300.0,"3006",215.9,98.0,12.0,null,null,19.0,36.6]
[8.0,300.0,"3008",269.9,111.0,12.0,null,null,30.0,41.1]
[10.0,300.0,"30010",323.8,117.0,16.0,null,null,41.0,47.8]
[12.0,300.0,"30012",381.0,130.0,16.0,null,null,62.0,50.8]
[14.0,300.0,"30014",412.8,143.0,20.0,null,null,84.0,53.8]
[16.0,300.0,"30016",469.9,146.0,20.0,null,null,111.0,57.2]
[18.0,300.0,"30018",533.4,159.0,24.0,null,null,138.0,60.5]
[20.0,300.0,"30020",584.2,162.0,24.0,null,null,171.0,63.5]
[24.0,300.0,"30024",692.2,168.0,24.0,null,null,247.0,69.9]
[0.5,600.0,"6000.5",34.9,52.0,4.0,null,null,1.5,14.2]
[0.75,600.0,"6000.75",42.9,57.0,4.0,null,null,2.0,15.7]
[1.0,600.0,"6001",50.8,62.0,4.0,null,null,2.5,17.5]
[1.25,600.0,"6001.25",63.5,67.0,4.0,null,null,3.2,20.6]
[1.5,600.0,"6001.5",73.0,70.0,4.0,null,null,4.5,22.4]
[2.0,600.0,"6002",92.1,73.0,8.0,null,null,5.5,25.4]
[2.5,600.0,"6002.5",104.8,79.0,8.0,null,null,8.0,28.4]
[3.0,600.0,"6003",127.0,83.0,8.0,null,null,10.5,31.8]
[3.5,600.0,"6003.5",139.7,86.0,8.0,null,null,15.6,35.0]
[4.0,600.0,"6004",157.2,102.0,8.0,null,null,19.0,38.1]
[5.0,600.0,"6005",185.7,114.0,8.0,null,null,31.0,44.5]
[6.0,600.0,"6006",215.9,117.0,12.0,null,null,37.0,47.8]
[8.0,600.0,"6008",269.9,133.0,12.0,null,null,53.0,55.6]
[10.0,600.0,"60010",323.8,152.0,16.0,null,null,86.0,63.5]
[12.0,600.0,"60012",381.0,156.0,20.0,null,null,102.0,66.5]
[14.0,600.0,"60014",412.8,165.0,20.0,null,null,150.0,69.9]
[16.0,600.0,"60016",469.9,178.0,20.0,null,null,190.0,76.2]
[18.0,600.0,"60018",533.4,184.0,20.0,null,null,240.0,82.6]
[20.0,600.0,"60020",584.2,190.0,24.0,null,null,295.0,88.9]
[24.0,600.0,"60024",692.2,203.0,24.0,null,null,365.0,101.6]
[0.5,900.0,"9000.5",34.9,60.0,4.0,null,null,2.0,22.4]
[0.75,900.0,"9000.75",42.9,70.0,4.0,null,null,3.0,25.4]
[1.0,900.0,"9001",50.8,73.0,4.0,null,null,4.0,28.4]
[1.25,900.0,"9001.25",63.5,73.0,4.0,null,null,4.6,28.4]
[1.5,900.0,"9001.5",73.0,83.0,4.0,null,null,6.5,31.8]
[2.0,900.0,"9002",92.1,102.0,8.0,null,null,11.5,38.1]
[2.5,900.0,"9002.5",104.8,105.0,8.0,null,null,15.8,41.1]
[3.0,900.0,"9003",127.0,102.0,8.0,null,null,14.5,38.1]
[4.0,900.0,"9004",157.2,114.0,8.0,null,null,23.0,44.5]
[5.0,900.0,"9005",185.7,127.0,8.0,null,null,37.0,50.8]
[6.0,900.0,"9006",215.9,140.0,12.0,null,null,50.0,55.6]
[8.0,900.0,"9008",269.9,162.0,12.0,null,null,85.0,63.5]
[10.0,900.0,"90010",323.8,184.0,16.0,null,null,118.0,69.9]
[12.0,900.0,"90012",381.0,200.0,20.0,null,null,163.0,79.2]
[14.0,900.0,"90014",412.8,213.0,20.0,null,null,186.0,85.9]
[16.0,900.0,"90016",469.9,216.0,20.0,null,null,224.0,88.9]
[18.0,900.0,"90018",533.4,229.0,20.0,null,null,300.0,101.6]
[20.0,900.0,"90020",584.2,248.0,20.0,null,null,373.0,108.0]
[24.0,900.0,"90024",692.2,292.0,20.0,null,null,680.0,139.7]
[0.5,1500.0,"15000.5",34.9,60.0,4.0,null,null,2.0,22.4]
[0.75,1500.0,"15000.75",42.9,70.0,4.0,null,null,3.0,25.4]
[1.0,1500.0,"15001",50.8,73.0,4.0,null,null,4.0,28.4]
[1.25,1500.0,"15001.25",63.5,73.0,4.0,null,null,4.6,28.4]
[1.5,1500.0,"15001.5",73.0,83.0,4.0,null,null,6.5,31.8]
[2.0,1500.0,"15002",92.1,102.0,8.0,null,null,11.5,38.1]
[2.5,1500.0,"15002.5",104.8,105.0,8.0,null,null,15.8,41.1]
[3.0,1500.0,"15003",127.0,118.0,8.0,null,null,22.0,47.8]
[4.0,1500.0,"15004",157.2,124.0,8.0,null,null,30.0,53.8]
[5.0,1500.0,"15005",185.7,155.0,8.0,null,null,58.0,73.2]
[6.0,1500.0,"15006",215.9,171.0,12.0,null,null,70.0,82.6]
[8.0,1500.0,"15008",269.7,213.0,12.0,null,null,119.0,91.9]
[10.0,1500.0,"150010",323.8,254.0,12.0,null,null,204.0,108.0]
[12.0,1500.0,"150012",381.0,283.0,16.0,null,null,303.0,124.0]
[14.0,1500.0,"150014",412.8,298.0,16.0,null,null,426.0,133.4]
[16.0,1500.0,"150016",469.9,311.0,16.0,null,null,567.0,146.0]
[18.0,1500.0,"150018",533.4,327.0,16.0,null,null,737.0,162.0]
[20.0,1500.0,"150020",584.2,356.0,16.0,null,null,930.0,177.8]
[24.0,1500.0,"150024",692.2,406.0,16.0,null,null,1510.0,203.2]
[0.5,2500.0,"25000.5",34.9,73.0,4.0,null,null,3.6,30.2]
[0.75,2500.0,"25000.75",42.9,79.0,4.0,null,null,4.0,31.8]
[1.0,2500.0,"25001",50.8,89.0,4.0,null,null,6.0,35.0]
[1.25,2500.0,"25001.25",63.5,95.0,4.0,null,null,9.0,38.1]
[1.5,2500.0,"25001.5",73.0,111.0,4.0,null,null,13.0,44.5]
[2.0,2500.0,"25002",92.1,127.0,8.0,null,null,19.0,50.8]
[2.5,2500.0,"25002.5",104.8,143.0,8.0,null,null,24.0,57.2]
[3.0,2500.0,"25003",127.0,168.0,8.0,null,null,43.0,66.5]
[4.0,2500.0,"25004",157.2,190.0,8.0,null,null,66.0,76.2]
[5.0,2500.0,"25005",185.7,229.0,8.0,null,null,111.0,91.9]
[6.0,2500.0,"25006",215.9,273.0,8.0,null,null,172.0,108.0]
[8.0,2500.0,"25008",269.9,317.0,12.0,null,null,261.0,127.0]
[10.0,2500.0,"250010",323.8,419.0,12.0,null,null,485.0,165.1]
[12.0,2500.0,"250012",381.0,464.0,12.0,null,null,730.0,184.2]
[26.0,150.0,"15026",806.0,120.0,24.0,1.75,215.0,140.0,70.0,305.0,"….","….","….","….","….","….","….","…."]
[28.0,150.0,"15028",864.0,125.0,28.0,1.75,215.0,160.0,72.0,365.0,"….","….","….","….","….","….","….","…."]
[30.0,150.0,"15030",914.0,135.0,28.0,1.5,230.0,185.0,75.0,430.0,"….","….","….","….","….","….","….","…."]
[32.0,150.0,"15032",978.0,145.0,28.0,1.5,255.0,235.0,80.0,540.0,"….","….","….","….","….","….","….","…."]
[34.0,150.0,"15034",1029.0,150.0,32.0,1.5,255.0,250.0,83.0,600.0,"….","….","….","….","….","….","….","…."]
[36.0,150.0,"15036",1086.0,160.0,32.0,1.5,280.0,295.0,90.0,735.0,"….","….","….","….","….","….","….","…."]
[38.0,150.0,"15038",1150.0,165.0,32.0,1.5,280.0,365.0,97.0,885.0,"….","….","….","….","….","….","….","…."]
[40.0,150.0,"15040",1200.0,175.0,36.0,1.5,290.0,405.0,105.0,1020.0,"….","….","….","….","….","….","….","…."]
[42.0,150.0,"15042",1257.0,185.0,36.0,1.5,300.0,460.0,108.0,1170.0,"….","….","….","….","….","….","….","…."]
[44.0,150.0,"15044",1314.0,190.0,40.0,1.5,320.0,510.0,113.0,1325.0,"….","….","….","….","….","….","….","…."]
[46.0,150.0,"15046",1365.0,200.0,40.0,1.5,330.0,555.0,118.0,1485.0,"….","….","….","….","….","….","….","…."]
[48.0,150.0,"15048",1422.0,210.0,44.0,1.25,330.0,615.0,120.0,1665.0,"….","….","….","….","….","….","….","…."]
[54.0,150.0,"15054",1594.0,230.0,44.0,1.25,360.0,880.0,123.0,2235.0,"….","….","….","….","….","….","….","…."]
[60.0,150.0,"15060",1759.0,250.0,52.0,1.25,380.0,1125.0,132.0,2955.0,"….","….","….","….","….","….","….","…."]
[26.0,300.0,"30026",876.0,185.0,28.0,1.625,255.0,270.0,90.0,510.0,876.0,185.0,28.0,1.625,280.0,285.0,85.0,505.0]
[28.0,300.0,"30028",940.0,195.0,28.0,1.625,265.0,330.0,95.0,625.0,940.0,195.0,28.0,1.625,290.0,345.0,90.0,620.0]
[30.0,300.0,"30030",997.0,210.0,28.0,1.75,290.0,380.0,100.0,725.0,997.0,210.0,28.0,1.75,305.0,395.0,95.0,725.0]
[32.0,300.0,"30032",1054.0,220.0,28.0,1.875,305.0,435.0,110.0,825.0,1054.0,220.0,28.0,1.875,330.0,460.0,100.0,850.0]
[34.0,300.0,"30034",1105.0,230.0,28.0,1.875,320.0,490.0,115.0,970.0,1105.0,230.0,28.0,1.875,345.0,515.0,105.0,980.0]
[36.0,300.0,"30036",1168.0,240.0,32.0,2.0,330.0,550.0,120.0,1125.0,1168.0,240.0,32.0,2.0,355.0,580.0,110.0,1135.0]
[38.0,300.0,"30038",1219.0,255.0,32.0,2.0,335.0,635.0,125.0,1290.0,1219.0,255.0,32.0,2.0,360.0,655.0,115.0,1250.0]
[40.0,300.0,"30040",1276.0,265.0,36.0,2.0,345.0,695.0,130.0,1475.0,1276.0,265.0,36.0,2.0,375.0,710.0,115.0,1560.0]
[42.0,300.0,"30042",1340.0,275.0,36.0,2.0,350.0,780.0,135.0,1690.0,1340.0,275.0,36.0,2.0,380.0,795.0,120.0,1815.0]
[44.0,300.0,"30044",1397.0,285.0,36.0,2.0,355.0,855.0,140.0,1905.0,1397.0,285.0,36.0,2.0,385.0,880.0,125.0,2120.0]
[46.0,300.0,"30046",1454.0,300.0,40.0,2.0,360.0,945.0,145.0,2155.0,1454.0,300.0,40.0,2.0,395.0,965.0,130.0,2295.0]
[48.0,300.0,"30048",1543.0,310.0,40.0,2.0,375.0,1070.0,155.0,2550.0,1543.0,310.0,40.0,2.0,405.0,1115.0,140.0,2710.0]
[54.0,300.0,"30054",1549.0,265.0,28.0,2.25,445.0,1060.0,160.0,2835.0,1550.0,265.0,28.0,2.5,545.0,1060.0,155.0,2735.0]
[60.0,300.0,"30060",1702.0,280.0,32.0,2.25,470.0,1300.0,170.0,3645.0,1700.0,280.0,32.0,2.5,570.0,1300.0,165.0,3490.0]
[26.0,600.0,"60026",914.0,220.0,28.0,1.875,340.0,450.0,125.0,810.0,965.0,225.0,28.0,1.875,362.0,470.0,115.0,745.0]
[28.0,600.0,"60028",965.0,235.0,28.0,2.0,350.0,505.0,135.0,950.0,1022.0,235.0,28.0,2.0,375.0,540.0,125.0,880.0]
[30.0,600.0,"60030",1022.0,250.0,28.0,2.0,360.0,575.0,140.0,1245.0,1080.0,250.0,28.0,2.0,381.0,600.0,130.0,1050.0]
[32.0,600.0,"60032",1080.0,260.0,28.0,2.25,375.0,645.0,150.0,1300.0,1130.0,260.0,28.0,2.25,406.0,685.0,140.0,1225.0]
[34.0,600.0,"60034",1130.0,270.0,28.0,2.25,380.0,705.0,155.0,1480.0,1194.0,270.0,28.0,2.25,413.0,750.0,145.0,1405.0]
[36.0,600.0,"60036",1194.0,285.0,28.0,2.5,400.0,815.0,165.0,1735.0,1250.0,285.0,28.0,2.5,432.0,845.0,155.0,1625.0]
[38.0,600.0,"60038",1251.0,300.0,28.0,2.5,415.0,935.0,170.0,1970.0,1295.0,300.0,28.0,2.5,444.0,960.0,160.0,1870.0]
[40.0,600.0,"60040",1295.0,315.0,28.0,2.75,440.0,1005.0,180.0,2245.0,1365.0,315.0,28.0,2.75,470.0,1045.0,170.0,2085.0]
[42.0,600.0,"60042",1365.0,325.0,28.0,2.75,440.0,1160.0,190.0,2530.0,1422.0,325.0,28.0,2.75,470.0,1190.0,180.0,2410.0]
[44.0,600.0,"60044",1422.0,335.0,28.0,3.0,470.0,1295.0,195.0,3020.0,1480.0,335.0,28.0,3.0,495.0,1325.0,185.0,2765.0]
[46.0,600.0,"60046",1480.0,350.0,28.0,3.0,475.0,1425.0,205.0,3220.0,1537.0,350.0,28.0,3.0,495.0,1430.0,195.0,3110.0]
[48.0,600.0,"60048",1537.0,360.0,28.0,3.0,490.0,1545.0,210.0,3540.0,915.0,360.0,28.0,3.0,508.0,1530.0,200.0,3445.0]
[]
[null,"Rating"]
[]
["Return sl no",{"$f":"B160&C160","v":"60014"},null,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0]
["Search res",null,null,{"$f":"VLOOKUP(B158,C3:D154,2,FALSE)","v":412.8},{"$f":"VLOOKUP(B158,C3:E154,3,FALSE)","v":165},{"$f":"VLOOKUP(B158,C3:F154,4,FALSE)","v":20},{"$f":"VLOOKUP(B158,C3:G154,5,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:H154,6,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:I154,7,FALSE)","v":150},{"$f":"VLOOKUP(B158,C3:J154,8,FALSE)","v":69.9},{"$f":"VLOOKUP(B158,C3:K154,9,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:L154,10,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:M154,11,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:N154,12,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:O154,13,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:P154,14,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:Q154,15,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:R154,16,FALSE)","v":""},{"$f":"VLOOKUP(B158,C3:S154,17,FALSE)","v":""}]
["Return in calcul",{"$f":"'General Data'!C39","v":600},{"$f":"'General Data'!B39","v":14},{"$f":"D159","v":412.8},165,20,"","",150,69.9,"","","","","","","","",""]
[null,null,null,{"$f":"ISERROR(D160)","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,{"$f":"IF(D161=TRUE,\"….\",D160)","v":412.8},165,20,"","",150,69.9,"","","","","","","","",""]

{"sheet":"Pipe Data","index":5,"n_rows":47,"n_cols":38,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"C3","v":"5S"},{"$f":"RIGHT(D2,2)","v":""},{"$f":"E3","v":"10S"},{"$f":"RIGHT(F2,2)","v":""},{"$f":"G3","v":"40S"},{"$f":"RIGHT(H2,2)","v":""},{"$f":"I3","v":"80S"},{"$f":"RIGHT(J2,2)","v":""},{"$f":"K3","v":"5"},{"$f":"RIGHT(L2,2)","v":""},{"$f":"M3","v":"10"},{"$f":"RIGHT(N2,2)","v":""},{"$f":"O3","v":"20"},{"$f":"RIGHT(P2,2)","v":""},{"$f":"Q3","v":"30"},{"$f":"RIGHT(R2,2)","v":""},{"$f":"S3","v":"STD"},{"$f":"RIGHT(T2,2)","v":""},{"$f":"U3","v":"40"},{"$f":"RIGHT(V2,2)","v":""},{"$f":"W3","v":"60"},{"$f":"RIGHT(X2,2)","v":""},{"$f":"Y3","v":"XS"},{"$f":"RIGHT(Z2,2)","v":""},{"$f":"AA3","v":"80"},{"$f":"RIGHT(AB2,2)","v":""},{"$f":"AC3","v":"100"},{"$f":"RIGHT(AD2,2)","v":""},{"$f":"AE3","v":"120"},{"$f":"RIGHT(AF2,2)","v":""},{"$f":"AG3","v":"140"},{"$f":"RIGHT(AH2,2)","v":""},{"$f":"AI3","v":"160"},{"$f":"RIGHT(AJ2,2)","v":""},{"$f":"AK3","v":"XXS"},{"$f":"RIGHT(AL2,2)","v":""}]
["NPS","OD","S-5S",null,"S-10S",null,"S-40S",null,"S-80S",null,"S-5",null,"S-10",null,"S-20",null,"S-30",null,"S-STD",null,"S-40",null,"S-60",null,"S-XS",null,"S-80",null,"S-100",null,"S-120",null,"S-140",null,"S-160",null,"S-XXS"]
[null,null,{"$f":"RIGHT(C2,2)","v":"5S"},null,{"$f":"RIGHT(E2,3)","v":"10S"},null,{"$f":"RIGHT(G2,3)","v":"40S"},null,{"$f":"RIGHT(I2,3)","v":"80S"},null,{"$f":"RIGHT(K2,1)","v":"5"},null,{"$f":"RIGHT(M2,2)","v":"10"},null,{"$f":"RIGHT(O2,2)","v":"20"},null,{"$f":"RIGHT(Q2,2)","v":"30"},null,{"$f":"RIGHT(S2,3)","v":"STD"},null,{"$f":"RIGHT(U2,2)","v":"40"},null,{"$f":"RIGHT(W2,2)","v":"60"},null,{"$f":"RIGHT(Y2,2)","v":"XS"},null,{"$f":"RIGHT(AA2,2)","v":"80"},null,{"$f":"RIGHT(AC2,3)","v":"100"},null,{"$f":"RIGHT(AE2,3)","v":"120"},null,{"$f":"RIGHT(AG2,3)","v":"140"},null,{"$f":"RIGHT(AI2,3)","v":"160"},null,{"$f":"RIGHT(AK2,3)","v":"XXS"}]
["IN",null,"IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM","IN","MM"]
[0.5,0.84,0.065,{"$f":"C5*25.4","v":1.651},0.083,{"$f":"E5*25.4","v":2.1082},0.109,{"$f":"G5*25.4","v":2.7686},0.147,{"$f":"I5*25.4","v":3.7338},0.065,{"$f":"K5*25.4","v":1.651},0.083,{"$f":"M5*25.4","v":2.1082},"….","….","….","….",0.109,{"$f":"S5*25.4","v":2.7686},0.109,{"$f":"U5*25.4","v":2.7686},"….","….",0.147,{"$f":"Y5*25.4","v":3.7338},0.147,{"$f":"AA5*25.4","v":3.7338},"….","….","….","….","….","….",0.188,{"$f":"AI5*25.4","v":4.7752},0.294,{"$f":"AK5*25.4","v":7.4676}]
[0.75,1.05,0.065,1.651,0.083,2.1082,0.113,2.8702,0.154,3.9116,0.065,1.651,0.083,2.1082,"….","….","….","….",0.113,2.8702,0.113,2.8702,"….","….",0.154,3.9116,0.154,3.9116,"….","….","….","….","….","….",0.219,5.5626,0.308,7.8232]
[1.0,1.315,0.065,1.651,0.109,2.7686,0.133,3.3782,0.179,4.5466,0.065,1.651,0.109,2.7686,"….","….","….","….",0.133,3.3782,0.133,3.3782,"….","….",0.179,4.5466,0.179,4.5466,"….","….","….","….","….","….",0.25,6.35,0.358,9.0932]
[1.25,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[1.5,1.9,0.065,{"$f":"C9*25.4","v":1.651},0.109,{"$f":"E9*25.4","v":2.7686},0.145,{"$f":"G9*25.4","v":3.683},0.2,{"$f":"I9*25.4","v":5.08},0.065,{"$f":"K9*25.4","v":1.651},0.109,{"$f":"M9*25.4","v":2.7686},"….","….","….","….",0.145,{"$f":"S9*25.4","v":3.683},0.145,{"$f":"U9*25.4","v":3.683},"….","….",0.2,{"$f":"Y9*25.4","v":5.08},0.2,{"$f":"AA9*25.4","v":5.08},"….","….","….","….","….","….",0.281,{"$f":"AI9*25.4","v":7.1374},0.4,{"$f":"AK9*25.4","v":10.16}]
[2.0,2.375,0.065,1.651,0.109,2.7686,0.154,3.9116,0.218,5.5372,0.065,1.651,0.109,2.7686,"….","….","….","….",0.154,3.9116,0.154,3.9116,"….","….",0.218,5.5372,0.218,5.5372,"….","….","….","….","….","….",0.344,8.7376,0.436,11.0744]
[2.5,2.875,0.083,2.1082,0.12,3.048,0.203,5.1562,0.276,7.0104,0.083,2.1082,0.12,3.048,"….","….","….","….",0.203,5.1562,0.203,5.1562,"….","….",0.276,7.0104,0.276,7.0104,"….","….","….","….","….","….",0.375,9.525,0.552,14.0208]
[3.0,3.5,0.083,2.1082,0.12,3.048,0.216,5.4864,0.3,7.62,0.083,2.1082,0.12,3.048,"….","….","….","….",0.216,5.4864,0.216,5.4864,"….","….",0.3,7.62,0.3,7.62,"….","….","….","….","….","….",0.438,11.1252,0.6,15.24]
[3.5,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[4.0,4.5,0.083,{"$f":"C14*25.4","v":2.1082},0.12,{"$f":"E14*25.4","v":3.048},0.237,{"$f":"G14*25.4","v":6.0198},0.337,{"$f":"I14*25.4","v":8.5598},0.083,{"$f":"K14*25.4","v":2.1082},0.12,{"$f":"M14*25.4","v":3.048},"….","….","….","….",0.237,{"$f":"S14*25.4","v":6.0198},0.237,{"$f":"U14*25.4","v":6.0198},"….","….",0.337,{"$f":"Y14*25.4","v":8.5598},0.337,{"$f":"AA14*25.4","v":8.5598},"….","….",0.438,{"$f":"AE14*25.4","v":11.1252},"….","….",0.531,{"$f":"AI14*25.4","v":13.4874},0.674,{"$f":"AK14*25.4","v":17.1196}]
[5.0,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[6.0,6.625,0.109,{"$f":"C16*25.4","v":2.7686},0.134,{"$f":"E16*25.4","v":3.4036},0.28,{"$f":"G16*25.4","v":7.112},0.432,{"$f":"I16*25.4","v":10.9728},0.109,{"$f":"K16*25.4","v":2.7686},0.134,{"$f":"M16*25.4","v":3.4036},"….","….","….","….",0.28,{"$f":"S16*25.4","v":7.112},0.28,{"$f":"U16*25.4","v":7.112},"….","….",0.432,{"$f":"Y16*25.4","v":10.9728},0.432,{"$f":"AA16*25.4","v":10.9728},"….","….",0.562,{"$f":"AE16*25.4","v":14.2748},"….","….",0.719,{"$f":"AI16*25.4","v":18.2626},0.864,{"$f":"AK16*25.4","v":21.9456}]
[8.0,8.625,0.109,2.7686,0.148,3.7592,0.322,8.1788,0.5,12.7,0.109,2.7686,0.148,3.7592,0.25,{"$f":"O17*25.4","v":6.35},0.277,{"$f":"Q17*25.4","v":7.0358},0.322,8.1788,0.322,8.1788,0.406,{"$f":"W17*25.4","v":10.3124},0.5,12.7,0.5,12.7,0.594,{"$f":"AC17*25.4","v":15.0876},0.719,18.2626,0.812,{"$f":"AG17*25.4","v":20.6248},0.906,23.0124,0.875,22.225]
[10.0,10.75,0.134,3.4036,0.165,4.191,0.365,9.271,"….","….",0.134,3.4036,0.165,4.191,0.25,6.35,0.307,7.7978,0.365,9.271,0.365,9.271,"….","….",0.5,12.7,0.594,15.0876,0.719,18.2626,0.844,21.4376,1.0,25.4,1.125,28.575,"….","…."]
[12.0,12.75,0.156,3.9624,0.18,4.572,"….","….","….","….",0.156,3.9624,0.18,4.572,0.25,6.35,0.33,8.382,0.375,9.525,0.406,10.3124,0.562,{"$f":"W19*25.4","v":14.2748},0.5,12.7,0.688,17.4752,0.844,21.4376,1.0,25.4,1.125,28.575,1.312,33.3248,"….","…."]
[14.0,14.0,0.156,3.9624,"….","….","….","….","….","….","….","….",0.25,6.35,0.312,7.9248,"….","….",0.375,9.525,0.438,11.1252,0.594,15.0876,0.5,12.7,0.75,19.05,0.938,23.8252,1.094,27.7876,1.125,28.575,1.406,35.7124,"….","…."]
[16.0,16.0,0.165,4.191,"….","….","….","….","….","….","….","….",0.25,6.35,0.312,7.9248,"….","….",0.375,9.525,"….","….",0.656,16.6624,0.5,12.7,0.844,21.4376,1.031,26.1874,1.219,30.9626,1.438,36.5252,1.594,40.4876,"….","…."]
[18.0,18.0,0.165,4.191,"….","….","….","….","….","….","….","….",0.25,6.35,0.312,7.9248,0.438,{"$f":"Q22*25.4","v":11.1252},0.375,9.525,0.562,{"$f":"U22*25.4","v":14.2748},0.75,19.05,0.5,12.7,0.938,23.8252,1.156,29.3624,1.375,34.925,1.562,39.6748,1.781,45.2374,"….","…."]
[20.0,20.0,0.188,4.7752,"….","….","….","….","….","….","….","….",0.25,6.35,0.375,9.525,"….","….",0.375,9.525,0.594,15.0876,0.812,20.6248,0.5,12.7,1.031,26.1874,1.281,32.5374,1.5,38.1,1.75,44.45,1.969,50.0126,"….","…."]
[22.0,22.0,0.188,4.7752,"….","….","….","….","….","….","….","….",0.25,6.35,"….","….","….","….",0.375,9.525,"….","….",0.875,22.225,0.5,12.7,1.125,28.575,1.375,34.925,1.625,41.275,1.875,47.625,2.125,53.975,"….","…."]
[24.0,24.0,0.218,5.5372,0.25,{"$f":"E25*25.4","v":6.35},"….","….","….","….","….","….",0.25,6.35,0.375,{"$f":"O25*25.4","v":9.525},0.562,{"$f":"Q25*25.4","v":14.2748},0.375,9.525,0.688,{"$f":"U25*25.4","v":17.4752},0.969,24.6126,0.5,12.7,1.219,30.9626,1.531,38.8874,1.812,46.0248,2.062,52.3748,2.343,59.5122,"….","…."]
[26.0,26.0,0.25,6.35,0.312,7.9248,"….","….","….","….","….","….",0.312,7.9248,0.5,12.7,"….","….",0.375,9.525,"….","….","….","….",0.5,12.7,"….","….","….","….","….","….","….","….","….","….","….","…."]
[28.0,28.0,"….","….","….","….","….","….","….","….","….","….",0.312,7.9248,0.5,12.7,0.625,{"$f":"Q27*25.4","v":15.875},0.375,9.525,"….","….","….","….",0.5,12.7,"….","….","….","….","….","….","….","….","….","….","….","…."]
[30.0,30.0,0.25,"….","….","….","….","….","….","….","….","….",0.312,7.9248,0.5,12.7,0.625,15.875,0.375,9.525,"….","….","….","….",0.5,12.7,"….","….","….","….","….","….","….","….","….","….","….","…."]
[32.0,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[34.0,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[36.0,36.0,0.25,"….","….","….","….","….","….","….","….","….",0.312,{"$f":"M31*25.4","v":7.9248},0.5,{"$f":"O31*25.4","v":12.7},0.625,{"$f":"Q31*25.4","v":15.875},0.375,{"$f":"S31*25.4","v":9.525},0.5,{"$f":"U31*25.4","v":12.7},"….","….",0.5,{"$f":"Y31*25.4","v":12.7},"….","….","….","….","….","….","….","….","….","….","….","…."]
[38.0,38.0,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[40.0,40.0,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….",0.375,{"$f":"S33*25.4","v":9.525},"….","….","….","….",0.5,{"$f":"Y33*25.4","v":12.7},"….","….","….","….","….","….","….","….","….","….","….","…."]
[42.0,42.0,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….",0.375,9.525,0.5,{"$f":"U34*25.4","v":12.7},"….","….",0.5,12.7,"….","….","….","….","….","….","….","….","….","….","….","…."]
[44.0,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[46.0,null,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","…."]
[48.0,48.0,"….","….","….","….","….","….","….","….","….","….","….","….","….","….","….","….",0.375,{"$f":"S37*25.4","v":9.525},"….","….","….","….",0.5,{"$f":"Y37*25.4","v":12.7},"….","….","….","….","….","….","….","….","….","….","….","…."]
[]
[]
[null,null,null,"5S","","10S","","40S","","80S","",5.0,"",10.0,"",20.0,"",30.0,"","STD","",40.0,"",60.0,"","XS","",80.0,"",100.0,"",120.0,"",140.0,"",160.0,"","XXS"]
[]
[1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0]
["BF",{"$f":"'General Data'!B39","v":14},null,{"$f":"VLOOKUP(B43,A5:D37,4,FALSE)","v":3.9624},null,{"$f":"VLOOKUP(B43,A5:F37,6,FALSE)","v":"…."},null,{"$f":"VLOOKUP(B43,A5:H37,8,FALSE)","v":"…."},null,{"$f":"VLOOKUP(B43,A5:J37,10,FALSE)","v":"…."},null,{"$f":"VLOOKUP(B43,A5:L37,12,FALSE)","v":"…."},null,{"$f":"VLOOKUP(B43,A5:N37,14,FALSE)","v":6.35},null,{"$f":"VLOOKUP(B43,A5:P37,16,FALSE)","v":7.9248},null,{"$f":"VLOOKUP(B43,A5:R37,18,FALSE)","v":"…."},null,{"$f":"VLOOKUP(B43,A5:T37,20,FALSE)","v":9.525},null,{"$f":"VLOOKUP(B43,A5:AL37,22,FALSE)","v":11.1252},null,{"$f":"VLOOKUP(B43,A5:AL37,24,FALSE)","v":15.0876},null,{"$f":"VLOOKUP(B43,A5:AL37,26,FALSE)","v":12.7},null,{"$f":"VLOOKUP(B43,A5:AL37,28,FALSE)","v":19.05},null,{"$f":"VLOOKUP(B43,A5:AL37,30,FALSE)","v":23.8252},null,{"$f":"VLOOKUP(B43,A5:AL37,32,FALSE)","v":27.7876},null,{"$f":"VLOOKUP(B43,A5:AL37,34,FALSE)","v":28.575},null,{"$f":"VLOOKUP(B43,A5:AL37,36,FALSE)","v":35.7124},null,{"$f":"VLOOKUP(B43,A5:AL37,38,FALSE)","v":"…."}]
[]
["SCH",{"$f":"'General Data'!D39","v":80}]
[]
["return",{"$f":"HLOOKUP(B45,D40:AL43,4,FALSE)","v":19.05}]