{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Configurator_EN","Order_list","Prices","v","a","Valves actuators list"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":2,"defined_names":17,"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":"Configurator_EN","index":0,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":false,"merged":[[36,2,36,15],[37,2,37,11],[2,16,2,17],[2,14,2,15],[25,1,25,10],[27,1,27,10],[28,1,28,10],[29,1,29,10],[30,1,30,10],[32,1,32,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"-","-"]
[]
[null,"            V5005",null,"            V5004",null,null,null,null,null,null,null,"           MT4/MT8  ",null,null,"        M6410/7410",null,"M5410 ",null,null,"          M6061/M7061"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VMS242A008 (blue)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measuring connectors: VS2600C1",null,null,null,null,"VMS242A009 (red)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"6."]
[null,"Type in the desired flow",null,null,null,null,null,null,null,null,"2."]
[null,"1.  liters/hour",0,null,null,null,null,null,null,null,"3."]
[null,"Valve part number","Min flow\nl/h","Max flow\nl/h","DN size","stroke mm","Flow char.","Type connect","Check valves","Price local currency","4. Select valve","Actuator part number","Stroke","Action unpower","Voltage","End switch","Run time","Manual operation","With cable in m","Price local currency","5. Select actuator",null,"Draining valve: VA3401A008"]
[null,{"$f":"IFERROR(v!AB1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,Prices!A2:B87,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC1=\"\",\"\",a!AC1),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L16,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(v!AB2,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,Prices!A3:B88,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC2=\"\",\"\",a!AC2),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L17,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(v!AB3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,Prices!A4:B89,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC3=\"\",\"\",a!AC3),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L18,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(v!AB4,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,Prices!A5:B90,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC4=\"\",\"\",a!AC4),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L19,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(v!AB5,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,Prices!A6:B91,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC5=\"\",\"\",a!AC5),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L20,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},null,null,"AC-25TF","DN25, 1 nut, 1 tailpiece 1 Gasket"]
[null,{"$f":"IFERROR(v!AB6,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,Prices!A7:B92,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC6=\"\",\"\",a!AC6),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L21,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},null,null,"AC-40TF","DN40, 1 nut, 1 tailpiece 1 Gasket"]
[null,{"$f":"IFERROR(v!AB7,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,Prices!A8:B93,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC7=\"\",\"\",a!AC7),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L22,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},null,null,"AC-50TF","DN50, 1 nut, 1 tailpiece 1 Gasket"]
[null,{"$f":"IFERROR(v!AB8,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,Prices!A9:B94,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC8=\"\",\"\",a!AC8),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L23,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""}]
[null,{"$f":"IFERROR(v!AB9,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,Prices!A10:B95,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC9=\"\",\"\",a!AC9),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L24,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},null,null,"V5004SA3265"]
[null,{"$f":"IFERROR(v!AB10,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,v!$B$1:$C$38,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,Prices!A11:B96,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(IF(a!AC10=\"\",\"\",a!AC10),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$D$45,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$E$45,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$F$45,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$I$45,7,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$K$45,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$L$45,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,a!$C$1:$G$45,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L25,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},null,null,"Shaft adapter for"]
[null,"1. Type in the required flow in liters per hour starting with the lowest flow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," rotary valves"]
[null,"2. Select actuator's control mode (V5004TF have included actuators)"]
[null,"3. Selec the type of actuator",{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,v!$B$1:$C$38,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flanged versions"]
[null,"4. Select one of suitable's valves",{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,v!$B$1:$C$38,2,FALSE),\"\")","v":""},null,null,null,null,null,"   ",null,null,null,null,null,null,null,"Actuator part",null,"Valve part"]
[null,"5. Select one of suitable's valves",{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,v!$B$1:$C$38,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1050",null,"M5004TF1050"]
[null,"6. Add your valve and actuator selection to the order_list",{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$D$38,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$E$38,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$F$38,5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$G$38,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$K$38,10,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$J$38,9,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,v!$B$1:$C$38,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1065",null,"M5004TF1065"]
[null,"7. Select sheet Order list and fill-in quantities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1080",null,"M5004TF1080"]
[null,"Notice: to avoid a pop-up error message when you start this programme go to file ®options®advanced® under general unckeck Ask to update automatic links",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1100",null,"M5004F1100"]
[null,"For furter information please refer to our online documentation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1125",null,"M5004F1125"]
[null,"Datasheet and mounting instructions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1150",null,"M5004F1150"]
[null,"For furter information please refer to our online documentation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1200LF",null,"5004TF1200LF"]
[null,"For V5004:","https://products.ecc.emea.honeywell.com/europe/ssearch/index.php?w=V5004 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1200HF",null,"V5004TF1200HF"]
[null,"For V5005:","https://products.ecc.emea.honeywell.com/europe/ssearch/index.php?w=V5005 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1250LF",null,"V5004TF1250LF",null,null,"VMS242A002 (with flushing valve)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M5004F1250HF",null,"V5004TF1250HF"]

{"sheet":"Order_list","index":1,"n_rows":125,"n_cols":40,"rows_kept":125,"cut":false,"hidden":false,"merged":[]}
["Project, position","Valve\nPart number","Valve  \ndescription",null,"Actuator \npart number",null,"Actuator\ndescription","Price of \nthe valve","Price of\n the actuator","Valve QTY","Actuator QTY","Total price",null,"Functions"]
[null,null,{"$f":"IFERROR(VLOOKUP(B2,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E2,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B2,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E2,Prices!A2:B87,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF(I2=\"\",H2*J2,(H2*J2)+(I2*K2)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B3,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E3,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B3,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E3,Prices!A3:B88,2,FALSE),\"\")","v":""},null,null,{"$f":"IFERROR(IF(I3=\"\",H3*J3,(H3*J3)+(I3*K3)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MT4-230-NC-2.5M","V5004TY10150150","V5004T1","Therm NC","2Pt, 3Pt",null,{"$f":"VLOOKUP(N10,$AD$4:$AE$37,2,FALSE)","v":{"$error":"#N/A"}},"A",{"$f":"VLOOKUP(N10,AD3:AJ36,7,FALSE)","v":{"$error":"#N/A"}},null,null,"V5004TY10252200"]
[null,null,{"$f":"IFERROR(VLOOKUP(B4,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E4,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B4,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E4,Prices!A4:B89,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B5,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E5,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B5,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E5,Prices!A5:B90,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B6,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E6,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B6,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E6,Prices!A6:B91,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B7,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E7,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B7,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E7,Prices!A7:B92,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B8,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E8,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B8,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E8,Prices!A8:B93,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B9,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E9,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E9,Prices!A9:B94,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B10,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E10,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E10,Prices!A10:B95,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B11,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E11,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E11,Prices!A11:B96,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B12,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E12,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E12,Prices!A12:B97,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B13,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E13,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E13,Prices!A13:B98,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B14,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E14,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E14,Prices!A14:B99,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B15,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E15,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B15,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E15,Prices!A15:B100,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B16,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E16,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B16,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E16,Prices!A16:B101,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B17,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E17,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B17,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E17,Prices!A17:B102,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B18,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E18,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B18,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E18,Prices!A18:B103,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B19,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E19,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B19,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E19,Prices!A19:B104,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B20,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E20,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B20,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E20,Prices!A20:B105,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B21,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E21,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B21,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E21,Prices!A21:B106,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B22,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E22,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B22,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E22,Prices!A22:B107,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B23,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E23,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B23,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E23,Prices!A23:B108,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B24,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E24,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B24,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E24,Prices!A24:B109,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B25,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E25,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B25,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E25,Prices!A25:B110,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B26,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E26,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B26,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E26,Prices!A26:B111,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B27,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E27,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B27,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E27,Prices!A27:B112,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B28,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E28,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B28,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E28,Prices!A28:B113,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B29,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E29,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B29,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E29,Prices!A29:B114,2,FALSE),\"\")","v":""},null,null,""]
[null,null,{"$f":"IFERROR(VLOOKUP(B30,'Valves actuators list'!$A$1:$B$38,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E30,'Valves actuators list'!$C$1:$D$49,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B30,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E30,Prices!A30:B115,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E31,'[1]Valves actuators list'!A30:B67,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B31,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E31,Prices!A31:B116,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E32,'[1]Valves actuators list'!A31:B68,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B32,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E32,Prices!A32:B117,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E33,'[1]Valves actuators list'!A32:B69,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B33,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E33,Prices!A33:B118,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E34,'[1]Valves actuators list'!A33:B70,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B34,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E34,Prices!A34:B119,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E35,'[1]Valves actuators list'!A34:B71,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B35,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E35,Prices!A35:B120,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E36,'[1]Valves actuators list'!A35:B72,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B36,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E36,Prices!A36:B121,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E37,'[1]Valves actuators list'!A36:B73,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B37,Prices!$A$2:$B$87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E37,Prices!A37:B122,2,FALSE),\"\")","v":""},null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E38,'[1]Valves actuators list'!A38:B75,2,FALSE),\"\")","v":""},"Total",{"$f":"IFERROR(VLOOKUP(E38,[1]Prices!A88:B122,2,FALSE),\"\")","v":""},null,null,{"$f":"SUM(L2:L37)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E39,'[1]Valves actuators list'!A39:B76,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B39,[1]Prices!A40:B88,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E39,[1]Prices!A89:B123,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E40,'[1]Valves actuators list'!A40:B77,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B40,[1]Prices!A41:B89,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E40,[1]Prices!A90:B124,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E41,'[1]Valves actuators list'!A41:B78,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B41,[1]Prices!A42:B90,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E41,[1]Prices!A91:B125,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E42,'[1]Valves actuators list'!A42:B79,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B42,[1]Prices!A43:B91,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E42,[1]Prices!A92:B126,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E43,'[1]Valves actuators list'!A43:B80,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B43,[1]Prices!A44:B92,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E43,[1]Prices!A93:B127,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E44,'[1]Valves actuators list'!A44:B81,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B44,[1]Prices!A45:B93,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E44,[1]Prices!A94:B128,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E45,'[1]Valves actuators list'!A45:B82,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B45,[1]Prices!A46:B94,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E45,[1]Prices!A95:B129,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E46,'[1]Valves actuators list'!A46:B83,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B46,[1]Prices!A47:B95,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E46,[1]Prices!A96:B130,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E47,'[1]Valves actuators list'!A47:B84,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B47,[1]Prices!A48:B96,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E47,[1]Prices!A97:B131,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B48,'[1]Valves actuators list'!C48:D96,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E48,'[1]Valves actuators list'!A48:B85,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B48,[1]Prices!A49:B97,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E48,[1]Prices!A98:B132,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B49,'[1]Valves actuators list'!C49:D97,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E49,'[1]Valves actuators list'!A49:B86,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B49,[1]Prices!A50:B98,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E49,[1]Prices!A99:B133,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B50,'[1]Valves actuators list'!C50:D98,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E50,'[1]Valves actuators list'!A50:B87,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B50,[1]Prices!A51:B99,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E50,[1]Prices!A100:B134,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B51,'[1]Valves actuators list'!C51:D99,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E51,'[1]Valves actuators list'!A51:B88,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B51,[1]Prices!A52:B100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E51,[1]Prices!A101:B135,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B52,'[1]Valves actuators list'!C52:D100,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E52,'[1]Valves actuators list'!A52:B89,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B52,[1]Prices!A53:B101,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E52,[1]Prices!A102:B136,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B53,'[1]Valves actuators list'!C53:D101,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E53,'[1]Valves actuators list'!A53:B90,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B53,[1]Prices!A54:B102,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E53,[1]Prices!A103:B137,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B54,'[1]Valves actuators list'!C54:D102,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E54,'[1]Valves actuators list'!A54:B91,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B54,[1]Prices!A55:B103,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E54,[1]Prices!A104:B138,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B55,'[1]Valves actuators list'!C55:D103,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E55,'[1]Valves actuators list'!A55:B92,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B55,[1]Prices!A56:B104,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E55,[1]Prices!A105:B139,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B56,'[1]Valves actuators list'!C56:D104,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E56,'[1]Valves actuators list'!A56:B93,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B56,[1]Prices!A57:B105,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E56,[1]Prices!A106:B140,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B57,'[1]Valves actuators list'!C57:D105,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E57,'[1]Valves actuators list'!A57:B94,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B57,[1]Prices!A58:B106,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E57,[1]Prices!A107:B141,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B58,'[1]Valves actuators list'!C58:D106,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E58,'[1]Valves actuators list'!A58:B95,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B58,[1]Prices!A59:B107,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E58,[1]Prices!A108:B142,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B59,'[1]Valves actuators list'!C59:D107,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E59,'[1]Valves actuators list'!A59:B96,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B59,[1]Prices!A60:B108,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E59,[1]Prices!A109:B143,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B60,'[1]Valves actuators list'!C60:D108,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E60,'[1]Valves actuators list'!A60:B97,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B60,[1]Prices!A61:B109,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E60,[1]Prices!A110:B144,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B61,'[1]Valves actuators list'!C61:D109,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E61,'[1]Valves actuators list'!A61:B98,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B61,[1]Prices!A62:B110,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E61,[1]Prices!A111:B145,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B62,'[1]Valves actuators list'!C62:D110,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E62,'[1]Valves actuators list'!A62:B99,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B62,[1]Prices!A63:B111,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E62,[1]Prices!A112:B146,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B63,'[1]Valves actuators list'!C63:D111,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E63,'[1]Valves actuators list'!A63:B100,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B63,[1]Prices!A64:B112,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E63,[1]Prices!A113:B147,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B64,'[1]Valves actuators list'!C64:D112,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E64,'[1]Valves actuators list'!A64:B101,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B64,[1]Prices!A65:B113,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E64,[1]Prices!A114:B148,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B65,'[1]Valves actuators list'!C65:D113,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E65,'[1]Valves actuators list'!A65:B102,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B65,[1]Prices!A66:B114,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E65,[1]Prices!A115:B149,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B66,'[1]Valves actuators list'!C66:D114,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E66,'[1]Valves actuators list'!A66:B103,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B66,[1]Prices!A67:B115,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E66,[1]Prices!A116:B150,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B67,'[1]Valves actuators list'!C67:D115,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E67,'[1]Valves actuators list'!A67:B104,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B67,[1]Prices!A68:B116,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E67,[1]Prices!A117:B151,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B68,'[1]Valves actuators list'!C68:D116,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E68,'[1]Valves actuators list'!A68:B105,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B68,[1]Prices!A69:B117,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E68,[1]Prices!A118:B152,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B69,'[1]Valves actuators list'!C69:D117,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E69,'[1]Valves actuators list'!A69:B106,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B69,[1]Prices!A70:B118,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E69,[1]Prices!A119:B153,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B70,'[1]Valves actuators list'!C70:D118,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E70,'[1]Valves actuators list'!A70:B107,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B70,[1]Prices!A71:B119,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E70,[1]Prices!A120:B154,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B71,'[1]Valves actuators list'!C71:D119,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E71,'[1]Valves actuators list'!A71:B108,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B71,[1]Prices!A72:B120,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E71,[1]Prices!A121:B155,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B72,'[1]Valves actuators list'!C72:D120,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E72,'[1]Valves actuators list'!A72:B109,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B72,[1]Prices!A73:B121,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E72,[1]Prices!A122:B156,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B73,'[1]Valves actuators list'!C73:D121,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E73,'[1]Valves actuators list'!A73:B110,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B73,[1]Prices!A74:B122,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E73,[1]Prices!A123:B157,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B74,'[1]Valves actuators list'!C74:D122,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E74,'[1]Valves actuators list'!A74:B111,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B74,[1]Prices!A75:B123,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E74,[1]Prices!A124:B158,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B75,'[1]Valves actuators list'!C75:D123,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E75,'[1]Valves actuators list'!A75:B112,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B75,[1]Prices!A76:B124,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E75,[1]Prices!A125:B159,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B76,'[1]Valves actuators list'!C76:D124,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E76,'[1]Valves actuators list'!A76:B113,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B76,[1]Prices!A77:B125,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E76,[1]Prices!A126:B160,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B77,'[1]Valves actuators list'!C77:D125,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E77,'[1]Valves actuators list'!A77:B114,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B77,[1]Prices!A78:B126,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E77,[1]Prices!A127:B161,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B78,'[1]Valves actuators list'!C78:D126,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E78,'[1]Valves actuators list'!A78:B115,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B78,[1]Prices!A79:B127,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E78,[1]Prices!A128:B162,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B79,'[1]Valves actuators list'!C79:D127,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E79,'[1]Valves actuators list'!A79:B116,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B79,[1]Prices!A80:B128,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E79,[1]Prices!A129:B163,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B80,'[1]Valves actuators list'!C80:D128,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E80,'[1]Valves actuators list'!A80:B117,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B80,[1]Prices!A81:B129,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E80,[1]Prices!A130:B164,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B81,'[1]Valves actuators list'!C81:D129,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E81,'[1]Valves actuators list'!A81:B118,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B81,[1]Prices!A82:B130,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E81,[1]Prices!A131:B165,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B82,'[1]Valves actuators list'!C82:D130,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E82,'[1]Valves actuators list'!A82:B119,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B82,[1]Prices!A83:B131,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E82,[1]Prices!A132:B166,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B83,'[1]Valves actuators list'!C83:D131,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E83,'[1]Valves actuators list'!A83:B120,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B83,[1]Prices!A84:B132,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E83,[1]Prices!A133:B167,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B84,'[1]Valves actuators list'!C84:D132,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E84,'[1]Valves actuators list'!A84:B121,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B84,[1]Prices!A85:B133,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E84,[1]Prices!A134:B168,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B85,'[1]Valves actuators list'!C85:D133,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E85,'[1]Valves actuators list'!A85:B122,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B85,[1]Prices!A86:B134,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E85,[1]Prices!A135:B169,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B86,'[1]Valves actuators list'!C86:D134,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E86,'[1]Valves actuators list'!A86:B123,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B86,[1]Prices!A87:B135,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E86,[1]Prices!A136:B170,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B87,'[1]Valves actuators list'!C87:D135,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E87,'[1]Valves actuators list'!A87:B124,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B87,[1]Prices!A88:B136,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E87,[1]Prices!A137:B171,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B88,'[1]Valves actuators list'!C88:D136,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E88,'[1]Valves actuators list'!A88:B125,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B88,[1]Prices!A89:B137,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E88,[1]Prices!A138:B172,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B89,'[1]Valves actuators list'!C89:D137,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E89,'[1]Valves actuators list'!A89:B126,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B89,[1]Prices!A90:B138,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E89,[1]Prices!A139:B173,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B90,'[1]Valves actuators list'!C90:D138,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E90,'[1]Valves actuators list'!A90:B127,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B90,[1]Prices!A91:B139,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E90,[1]Prices!A140:B174,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B91,'[1]Valves actuators list'!C91:D139,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E91,'[1]Valves actuators list'!A91:B128,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B91,[1]Prices!A92:B140,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E91,[1]Prices!A141:B175,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B92,'[1]Valves actuators list'!C92:D140,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E92,'[1]Valves actuators list'!A92:B129,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B92,[1]Prices!A93:B141,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E92,[1]Prices!A142:B176,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B93,'[1]Valves actuators list'!C93:D141,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E93,'[1]Valves actuators list'!A93:B130,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B93,[1]Prices!A94:B142,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E93,[1]Prices!A143:B177,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B94,'[1]Valves actuators list'!C94:D142,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E94,'[1]Valves actuators list'!A94:B131,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B94,[1]Prices!A95:B143,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E94,[1]Prices!A144:B178,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B95,'[1]Valves actuators list'!C95:D143,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E95,'[1]Valves actuators list'!A95:B132,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B95,[1]Prices!A96:B144,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E95,[1]Prices!A145:B179,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B96,'[1]Valves actuators list'!C96:D144,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E96,'[1]Valves actuators list'!A96:B133,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B96,[1]Prices!A97:B145,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E96,[1]Prices!A146:B180,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B97,'[1]Valves actuators list'!C97:D145,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E97,'[1]Valves actuators list'!A97:B134,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B97,[1]Prices!A98:B146,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(E97,[1]Prices!A147:B181,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B98,'[1]Valves actuators list'!C98:D146,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E98,'[1]Valves actuators list'!A98:B135,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E98,[1]Prices!A148:B182,2,FALSE),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B99,'[1]Valves actuators list'!C99:D147,2,FALSE),\"\")","v":""},null,null,null,{"$f":"IFERROR(VLOOKUP(E99,'[1]Valves actuators list'!A99:B136,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E99,[1]Prices!A149:B183,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E100,'[1]Valves actuators list'!A100:B137,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E100,[1]Prices!A150:B184,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E101,'[1]Valves actuators list'!A101:B138,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E101,[1]Prices!A151:B185,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E102,'[1]Valves actuators list'!A102:B139,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E102,[1]Prices!A152:B186,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E103,'[1]Valves actuators list'!A103:B140,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E103,[1]Prices!A153:B187,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E104,'[1]Valves actuators list'!A104:B141,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E104,[1]Prices!A154:B188,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E105,'[1]Valves actuators list'!A105:B142,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E105,[1]Prices!A155:B189,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E106,'[1]Valves actuators list'!A106:B143,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E106,[1]Prices!A156:B190,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E107,'[1]Valves actuators list'!A107:B144,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E107,[1]Prices!A157:B191,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E108,'[1]Valves actuators list'!A108:B145,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E108,[1]Prices!A158:B192,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E109,'[1]Valves actuators list'!A109:B146,2,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(E109,[1]Prices!A159:B193,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E110,'[1]Valves actuators list'!A110:B147,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E111,'[1]Valves actuators list'!A111:B148,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E112,'[1]Valves actuators list'!A112:B149,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E113,'[1]Valves actuators list'!A113:B150,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E114,'[1]Valves actuators list'!A114:B151,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E115,'[1]Valves actuators list'!A115:B152,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E116,'[1]Valves actuators list'!A116:B153,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E117,'[1]Valves actuators list'!A117:B154,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E118,'[1]Valves actuators list'!A118:B155,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E119,'[1]Valves actuators list'!A119:B156,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E120,'[1]Valves actuators list'!A120:B157,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E121,'[1]Valves actuators list'!A121:B158,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E122,'[1]Valves actuators list'!A122:B159,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E123,'[1]Valves actuators list'!A123:B160,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E124,'[1]Valves actuators list'!A124:B161,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(E125,'[1]Valves actuators list'!A125:B162,2,FALSE),\"\")","v":""}]

{"sheet":"Prices","index":2,"n_rows":87,"n_cols":2,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Parts numbers","Price local Currency"]
["MT4-024-NO"]
["MT4-024-NO-2.5M"]
["MT4-024S-NO"]
["MT4-024-NC"]
["MT4-024-NC-2.5M"]
["MT4-024S-NC"]
["MT4-230-NO"]
["MT4-230-NO-2.5M"]
["MT4-230S-NO"]
["MT4-230-NC"]
["MT4-230-NC-2.5M"]
["MT4-230S-NC"]
["MT8-024-NO"]
["MT8-024-NO-2.5M"]
["MT8-024S-NO"]
["MT8-024-NC"]
["MT8-024-NC-2.5M"]
["MT8-024S-NC"]
["MT8-230-NO"]
["MT8-230-NO-2.5M"]
["MT8-230S-NO"]
["MT8-230-NC"]
["MT8-230-NC-2.5M"]
["MT8-230S-NC"]
["M5410C1001"]
["M5410L1001"]
["M7410A1001"]
["M7410A1001-3M"]
["M7410A1001-5M"]
["M7410A1001-10M"]
["M7410C1007"]
["M7410C1007-3M"]
["M7410C1007-5M"]
["M7410C1007-10M"]
["M6410C2023"]
["M6410C4029"]
["M6410L2023"]
["M6410L4029"]
["M7410E5001"]
["M7410E5001-3M"]
["M7410E5001-5M"]
["M7410E5001-10M"]
["M7410E1002"]
["M7410E1002-10M"]
["M7410E2026"]
["M7410E4022"]
["M7061E1012"]
["M6061A1013"]
["M6061L1019"]
["V5004TY10150150"]
["V5004TY10150600"]
["V5004TY10150780"]
["V5004TY10201000"]
["V5004TY10201500"]
["V5004TY10251500"]
["V5004TY10202200"]
["V5004TY10202700"]
["V5004TY10252200"]
["V5004TY10252700"]
["V5004TY10322700"]
["V5004TY10323000"]
["V5004TY10326000"]
["V5004TY10409000"]
["V5004TY10501200"]
["V5004TY10501700"]
["V5004TF1050"]
["V5004TF1065"]
["V5004TF1080"]
["V5004TF1100"]
["V5004TF1125"]
["V5004TF1150"]
["V5005TY10150350"]
["V5005TY10151000"]
["V5005TY10201000"]
["V5005TY10201500"]
["V5005TY10251000"]
["V5005TY10251500"]
["V5005TY20150350"]
["V5005TY20151000"]
["V5005TY20201000"]
["V5005TY20201500"]
["V5005TY20251000"]
["V5005TY20251500"]
["VM242A0101"]
["VA3401A008 "]
["VS2600C1"]

{"sheet":"v","index":3,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["V5004T1","V5004TY10150150","Yes",45,150,15,2.9,"Linear","A","Int. thread","eq%",1,{"$f":"D1*1.3","v":58.5},{"$f":"E1*0.85","v":127.5},{"$f":"P1&\":\"&COUNTIF($P$1:P1,P1)","v":"93:1"},{"$f":"IFERROR((M1+N1)/2,0)","v":93},{"$f":"ABS($AE$7-P1)","v":93},{"$f":"RANK(Q1,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q1,Q1)-1","v":1},{"$f":"IF(AND($AE$7>(Q1*90%),$AE$7<N1),B1,\"\")","v":""},{"$f":"IF(S1=B1,P1,\"\")","v":""},{"$f":"IFERROR((T1-$AE$7),\"\")","v":""},{"$f":"IFERROR(ABS(U1),\"\")","v":""},{"$f":"IF(S1=B1,L1,\"\")","v":""},{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W1)),\"\")","v":""},{"$f":"RANK(AA1,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA1,AA1)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X1,COLUMNS($B$1:B1)),\"\")","v":""},{"$f":"VLOOKUP(Z1,S1:V38,4,FALSE)","v":""},{"$f":"IFERROR(VLOOKUP(1,$Y$1:$Z$20,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(AB1,$B$1:$I$38,8,FALSE),\"\")","v":""}]
["V5004T1","V5004TY10150600","Yes",60,600,15,2.9,"Linear","A","Int. thread","eq%",2,78,510,{"$f":"P2&\":\"&COUNTIF($P$1:P2,P2)","v":"294:1"},294,294,{"$f":"RANK(Q2,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q2,Q2)-1","v":4},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W2)),\"\")","v":""},{"$f":"RANK(AA2,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA2,AA2)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X2,COLUMNS($B$1:B2)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(2,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T1","V5004TY10150780","Yes",78,780,15,2.9,"Linear","A","Int. thread","eq%",3,101.4,663,{"$f":"P3&\":\"&COUNTIF($P$1:P3,P3)","v":"382,2:1"},382.2,382.2,{"$f":"RANK(Q3,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q3,Q3)-1","v":5},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W3)),\"\")","v":""},{"$f":"RANK(AA3,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA3,AA3)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X3,COLUMNS($B$1:B3)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(3,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T1","V5004TY10201000","Yes",100,1000,20,2.9,"Linear","A","Int. thread","eq%",4,130,850,{"$f":"P4&\":\"&COUNTIF($P$1:P4,P4)","v":"490:1"},490,490,{"$f":"RANK(Q4,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q4,Q4)-1","v":6},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W4)),\"\")","v":""},{"$f":"RANK(AA4,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA4,AA4)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X4,COLUMNS($B$1:B4)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(4,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T1","V5004TY10201500","Yes",450,1500,20,2.9,"Linear","A","Int. thread","eq%",5,585,1275,{"$f":"P5&\":\"&COUNTIF($P$1:P5,P5)","v":"930:1"},930,930,{"$f":"RANK(Q5,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q5,Q5)-1","v":17},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W5)),\"\")","v":""},{"$f":"RANK(AA5,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA5,AA5)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X5,COLUMNS($B$1:B5)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(5,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T1","V5004TY10251500","Yes",450,1500,25,2.9,"Linear","A","Int. thread","eq%",6,585,1275,{"$f":"P6&\":\"&COUNTIF($P$1:P6,P6)","v":"930:2"},930,930,{"$f":"RANK(Q6,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q6,Q6)-1","v":18},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W6)),\"\")","v":""},{"$f":"RANK(AA6,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA6,AA6)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X6,COLUMNS($B$1:B6)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(6,$Y$1:$Z$20,2,FALSE),\"\")","v":""},"","Flow calculation"]
["V5004T2","V5004TY10202200","Yes",220,2200,20,6,"Linear","B","ext. thread","eq%",7,286,1870,{"$f":"P7&\":\"&COUNTIF($P$1:P7,P7)","v":"1078:1"},1078,1078,{"$f":"RANK(Q7,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q7,Q7)-1","v":19},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W7)),\"\")","v":""},{"$f":"RANK(AA7,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA7,AA7)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X7,COLUMNS($B$1:B7)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(7,$Y$1:$Z$20,2,FALSE),\"\")","v":""},"","Requ flow",{"$f":"Configurator_EN!C14","v":0}]
["V5004T2","V5004TY10202700","Yes",270,2700,20,6,"Linear","B","ext. thread","eq%",8,351,2295,{"$f":"P8&\":\"&COUNTIF($P$1:P8,P8)","v":"1323:1"},1323,1323,{"$f":"RANK(Q8,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q8,Q8)-1","v":21},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W8)),\"\")","v":""},{"$f":"RANK(AA8,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA8,AA8)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X8,COLUMNS($B$1:B8)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(8,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T2","V5004TY10252200","Yes",220,2200,25,6,"Linear","B","ext. thread","eq%",9,286,1870,{"$f":"P9&\":\"&COUNTIF($P$1:P9,P9)","v":"1078:2"},1078,1078,{"$f":"RANK(Q9,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q9,Q9)-1","v":20},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W9)),\"\")","v":""},{"$f":"RANK(AA9,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA9,AA9)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X9,COLUMNS($B$1:B9)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(9,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T2","V5004TY10252700","Yes",270,2700,25,6,"Linear","B","ext. thread","eq%",10,351,2295,{"$f":"P10&\":\"&COUNTIF($P$1:P10,P10)","v":"1323:2"},1323,1323,{"$f":"RANK(Q10,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q10,Q10)-1","v":22},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W10)),\"\")","v":""},{"$f":"RANK(AA10,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA10,AA10)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X10,COLUMNS($B$1:B10)),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(10,$Y$1:$Z$20,2,FALSE),\"\")","v":""},""]
["V5004T2","V5004TY10322700","Yes",270,2700,32,6,"Linear","B","ext. thread","eq%",11,351,2295,{"$f":"P11&\":\"&COUNTIF($P$1:P11,P11)","v":"1323:3"},1323,1323,{"$f":"RANK(Q11,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q11,Q11)-1","v":23},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W11)),\"\")","v":""},{"$f":"RANK(AA11,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA11,AA11)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X11,COLUMNS($B$1:B11)),\"\")","v":""},"",null,""]
["V5004T2","V5004TY10323000","Yes",300,3000,32,6,"Linear","B","ext. thread","eq%",12,390,2550,{"$f":"P12&\":\"&COUNTIF($P$1:P12,P12)","v":"1470:1"},1470,1470,{"$f":"RANK(Q12,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q12,Q12)-1","v":24},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W12)),\"\")","v":""},{"$f":"RANK(AA12,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA12,AA12)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X12,COLUMNS($B$1:B12)),\"\")","v":""},"",null,""]
["V5004T2","V5004TY10326000","Yes",1800,6000,32,"90°","Rotary","R","ext. thread","eq%",13,2340,5100,{"$f":"P13&\":\"&COUNTIF($P$1:P13,P13)","v":"3720:1"},3720,3720,{"$f":"RANK(Q13,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q13,Q13)-1","v":25},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W13)),\"\")","v":""},{"$f":"RANK(AA13,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA13,AA13)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X13,COLUMNS($B$1:B13)),\"\")","v":""},"",null,""]
["V5004TR","V5004TY10409000","Yes",2700,9000,40,"90°","Rotary","R","ext. thread","eq%",14,3510,7650,{"$f":"P14&\":\"&COUNTIF($P$1:P14,P14)","v":"5580:1"},5580,5580,{"$f":"RANK(Q14,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q14,Q14)-1","v":26},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W14)),\"\")","v":""},{"$f":"RANK(AA14,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA14,AA14)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X14,COLUMNS($B$1:B14)),\"\")","v":""},"",null,""]
["V5004TR","V5004TY10501200","Yes",3300,11000,50,"90°","Rotary","R","ext. thread","eq%",15,4290,9350,{"$f":"P15&\":\"&COUNTIF($P$1:P15,P15)","v":"6820:1"},6820,6820,{"$f":"RANK(Q15,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q15,Q15)-1","v":27},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W15)),\"\")","v":""},{"$f":"RANK(AA15,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA15,AA15)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X15,COLUMNS($B$1:B15)),\"\")","v":""},"",null,""]
["V5004TR","V5004TY10501700","Yes",5400,18000,50,"90°","Rotary","R","ext. thread","eq%",16,7020,15300,{"$f":"P16&\":\"&COUNTIF($P$1:P16,P16)","v":"11160:1"},11160,11160,{"$f":"RANK(Q16,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q16,Q16)-1","v":29},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W16)),\"\")","v":""},{"$f":"RANK(AA16,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA16,AA16)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X16,COLUMNS($B$1:B16)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1050","Yes",2000,20000,50,"90°","Included","I","Flanges","eq%",17,2600,17000,{"$f":"P17&\":\"&COUNTIF($P$1:P17,P17)","v":"9800:1"},9800,9800,{"$f":"RANK(Q17,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q17,Q17)-1","v":28},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W17)),\"\")","v":""},{"$f":"RANK(AA17,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA17,AA17)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X17,COLUMNS($B$1:B17)),\"\")","v":""},{"$f":"VLOOKUP(Z17,S17:V54,4,FALSE)","v":""},null,""]
["V5004TF","V5004TF1065","Yes",3000,30000,65,"90°","Included","I","Flanges","eq%",18,3900,25500,{"$f":"P18&\":\"&COUNTIF($P$1:P18,P18)","v":"14700:1"},14700,14700,{"$f":"RANK(Q18,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q18,Q18)-1","v":30},"","",{"$f":"IFERROR((T18-$AE$7),\"\")","v":""},"","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W18)),\"\")","v":""},{"$f":"RANK(AA18,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA18,AA18)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X18,COLUMNS($B$1:B18)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1080","Yes",3000,30000,80,"90°","Included","I","Flanges","eq%",19,3900,25500,{"$f":"P19&\":\"&COUNTIF($P$1:P19,P19)","v":"14700:2"},14700,14700,{"$f":"RANK(Q19,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q19,Q19)-1","v":31},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W19)),\"\")","v":""},{"$f":"RANK(AA19,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA19,AA19)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X19,COLUMNS($B$1:B19)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1100","Yes",5500,55000,100,"90°","Included","I","Flanges","eq%",20,7150,46750,{"$f":"P20&\":\"&COUNTIF($P$1:P20,P20)","v":"26950:1"},26950,26950,{"$f":"RANK(Q20,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q20,Q20)-1","v":32},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W20)),\"\")","v":""},{"$f":"RANK(AA20,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA20,AA20)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X20,COLUMNS($B$1:B20)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1125","Yes",9000,90000,125,"90°","Included","I","Flanges","eq%",21,11700,76500,{"$f":"P21&\":\"&COUNTIF($P$1:P21,P21)","v":"44100:1"},44100,44100,{"$f":"RANK(Q21,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q21,Q21)-1","v":33},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W21)),\"\")","v":""},{"$f":"RANK(AA21,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA21,AA21)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X21,COLUMNS($B$1:B21)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1150","Yes",15000,150000,150,"90°","Included","I","Flanges","eq%",22,19500,127500,{"$f":"P22&\":\"&COUNTIF($P$1:P22,P22)","v":"73500:1"},73500,73500,{"$f":"RANK(Q22,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q22,Q22)-1","v":34},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W22)),\"\")","v":""},{"$f":"RANK(AA22,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA22,AA22)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X22,COLUMNS($B$1:B22)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1200LF","Yes",20000,200000,200,"90°","Included","I","Flanges","eq%",23,26000,170000,{"$f":"P23&\":\"&COUNTIF($P$1:P23,P23)","v":"98000:1"},98000,98000,{"$f":"RANK(Q23,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q23,Q23)-1","v":35},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W23)),\"\")","v":""},{"$f":"RANK(AA23,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA23,AA23)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X23,COLUMNS($B$1:B23)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1200HF","Yes",30000,300000,200,"90°","Included","I","Flanges","eq%",24,39000,255000,{"$f":"P24&\":\"&COUNTIF($P$1:P24,P24)","v":"147000:1"},147000,147000,{"$f":"RANK(Q24,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q24,Q24)-1","v":36},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W24)),\"\")","v":""},{"$f":"RANK(AA24,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA24,AA24)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X24,COLUMNS($B$1:B24)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1250LF","Yes",30000,300000,250,"90°","Included","I","Flanges","eq%",25,39000,255000,{"$f":"P25&\":\"&COUNTIF($P$1:P25,P25)","v":"147000:2"},147000,147000,{"$f":"RANK(Q25,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q25,Q25)-1","v":37},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W25)),\"\")","v":""},{"$f":"RANK(AA25,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA25,AA25)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X25,COLUMNS($B$1:B25)),\"\")","v":""},"",null,""]
["V5004TF","V5004TF1250HF","Yes",50000,500000,250,"90°","Included","I","Flanges","eq%",26,65000,425000,{"$f":"P26&\":\"&COUNTIF($P$1:P26,P26)","v":"245000:1"},245000,245000,{"$f":"RANK(Q26,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q26,Q26)-1","v":38},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W26)),\"\")","v":""},{"$f":"RANK(AA26,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA26,AA26)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X26,COLUMNS($B$1:B26)),\"\")","v":""},"",null,""]
["V5005T1","V5005TY10150350","Yes",20,350,15,2.5,"Linear","A","Int. thread","Linear",27,26,297.5,{"$f":"P27&\":\"&COUNTIF($P$1:P27,P27)","v":"161,75:1"},161.75,161.75,{"$f":"RANK(Q27,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q27,Q27)-1","v":2},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W27)),\"\")","v":""},{"$f":"RANK(AA27,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA27,AA27)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X27,COLUMNS($B$1:B27)),\"\")","v":""},"",null,""]
["V5005T1","V5005TY10151000","Yes",100,1000,15,2.5,"Linear","A","Int. thread","Linear",28,130,850,{"$f":"P28&\":\"&COUNTIF($P$1:P28,P28)","v":"490:2"},490,490,{"$f":"RANK(Q28,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q28,Q28)-1","v":7},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W28)),\"\")","v":""},{"$f":"RANK(AA28,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA28,AA28)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X28,COLUMNS($B$1:B28)),\"\")","v":""},"",null,""]
["V5005T1","V5005TY10201000","Yes",100,1000,20,2.5,"Linear","A","Int. thread","Linear",29,130,850,{"$f":"P29&\":\"&COUNTIF($P$1:P29,P29)","v":"490:3"},490,490,{"$f":"RANK(Q29,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q29,Q29)-1","v":8},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W29)),\"\")","v":""},{"$f":"RANK(AA29,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA29,AA29)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X29,COLUMNS($B$1:B29)),\"\")","v":""},"",null,""]
["V5005T1","V5005TY10201500","Yes",200,1500,20,2.5,"Linear","A","Int. thread","Linear",30,260,1275,{"$f":"P30&\":\"&COUNTIF($P$1:P30,P30)","v":"767,5:1"},767.5,767.5,{"$f":"RANK(Q30,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q30,Q30)-1","v":13},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W30)),\"\")","v":""},{"$f":"RANK(AA30,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA30,AA30)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X30,COLUMNS($B$1:B30)),\"\")","v":""},"",null,""]
["V5005T1","V5005TY10251000","Yes",100,1000,25,2.5,"Linear","A","Int. thread","Linear",31,130,850,{"$f":"P31&\":\"&COUNTIF($P$1:P31,P31)","v":"490:4"},490,490,{"$f":"RANK(Q31,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q31,Q31)-1","v":9},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W31)),\"\")","v":""},{"$f":"RANK(AA31,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA31,AA31)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X31,COLUMNS($B$1:B31)),\"\")","v":""},"",null,""]
["V5005T1","V5005TY10251500","Yes",200,1500,25,2.5,"Linear","A","Int. thread","Linear",32,260,1275,{"$f":"P32&\":\"&COUNTIF($P$1:P32,P32)","v":"767,5:2"},767.5,767.5,{"$f":"RANK(Q32,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q32,Q32)-1","v":14},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W32)),\"\")","v":""},{"$f":"RANK(AA32,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA32,AA32)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X32,COLUMNS($B$1:B32)),\"\")","v":""},"",null,""]
["V5005T2","V5005TY20150350","No",20,350,15,2.5,"Linear","A","Int. thread","Linear",33,26,297.5,{"$f":"P33&\":\"&COUNTIF($P$1:P33,P33)","v":"161,75:2"},161.75,161.75,{"$f":"RANK(Q33,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q33,Q33)-1","v":3},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W33)),\"\")","v":""},{"$f":"RANK(AA33,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA33,AA33)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X33,COLUMNS($B$1:B33)),\"\")","v":""},"",null,""]
["V5005T2","V5005TY20151000","No",100,1000,15,2.5,"Linear","A","Int. thread","Linear",34,130,850,{"$f":"P34&\":\"&COUNTIF($P$1:P34,P34)","v":"490:5"},490,490,{"$f":"RANK(Q34,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q34,Q34)-1","v":10},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W34)),\"\")","v":""},{"$f":"RANK(AA34,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA34,AA34)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X34,COLUMNS($B$1:B34)),\"\")","v":""},"",null,""]
["V5005T2","V5005TY20201000","No",100,1000,20,2.5,"Linear","A","Int. thread","Linear",35,130,850,{"$f":"P35&\":\"&COUNTIF($P$1:P35,P35)","v":"490:6"},490,490,{"$f":"RANK(Q35,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q35,Q35)-1","v":11},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W35)),\"\")","v":""},{"$f":"RANK(AA35,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA35,AA35)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X35,COLUMNS($B$1:B35)),\"\")","v":""},"",null,""]
["V5005T2","V5005TY20201500","No",200,1500,20,2.5,"Linear","A","Int. thread","Linear",36,260,1275,{"$f":"P36&\":\"&COUNTIF($P$1:P36,P36)","v":"767,5:3"},767.5,767.5,{"$f":"RANK(Q36,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q36,Q36)-1","v":15},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W36)),\"\")","v":""},{"$f":"RANK(AA36,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA36,AA36)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X36,COLUMNS($B$1:B36)),\"\")","v":""},"",null,""]
["V5005T2","V5005TY20251000","No",100,1000,25,2.5,"Linear","A","Int. thread","Linear",37,130,850,{"$f":"P37&\":\"&COUNTIF($P$1:P37,P37)","v":"490:7"},490,490,{"$f":"RANK(Q37,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q37,Q37)-1","v":12},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W37)),\"\")","v":""},{"$f":"RANK(AA37,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA37,AA37)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X37,COLUMNS($B$1:B37)),\"\")","v":""},"",null,""]
["V5005T2","V5005TY20251500","No",200,1500,25,2.5,"Linear","A","Int. thread","Linear",38,260,1275,{"$f":"P38&\":\"&COUNTIF($P$1:P38,P38)","v":"767,5:4"},767.5,767.5,{"$f":"RANK(Q38,$Q$1:$Q$38,1)+COUNTIF($Q$1:Q38,Q38)-1","v":16},"","","","","",{"$f":"IFERROR(SMALL($W$1:$W$38,ROWS(W$1:$W38)),\"\")","v":""},{"$f":"RANK(AA38,$AA$1:$AA$20,1)+COUNTIF($AA$1:AA38,AA38)-1","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(INDEX($B$1:$L$38,$X38,COLUMNS($B$1:B38)),\"\")","v":""},"",null,""]
[]
["Valve\nType","Part Number","Safe cons","Min flow","Max flow","DN size","Stroke","Valve \naction","Action \ntype","Connection","Flow \ncharacterist","Sequence Number","Min flow +30%","Max flow -15%","Aver flow Countif","AVG flow\n +30-15%","Closest to the request","Ranking","Parts that meet criteria","Diff Avg vs requ fl","Diff Avg vs requ fl","ABS deviation","Sequ. Number unsort.","Sequ. Number sorted","Ranking","Parts betw +29% &\n-15% of min/max flow","ABS flow dev",null,"Stroke\n type"]

{"sheet":"a","index":4,"n_rows":47,"n_cols":29,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[null,"Therm NO","MT4-024-NO",4,"open","24Vac/dc",1,"2Pt, 3Pt","No","A",240,"With cap",1,{"$f":"VLOOKUP(Configurator_EN!N13,v!B1:I45,8,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(N1=\"A\",C1,IF(N1=\"B\",C13,IF(N1=\"R\",C43,IF(N1= \"Motor fast\",C25,IF(N1=\"I\",\"Actuator included\",\"\")))))","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(O1,$C$1:$H$45,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O1,C1:M45,11,FALSE),\"\")","v":""},{"$f":"IF(Configurator_EN!$M$1=a!P1,a!Q1,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R1)),\"\")","v":""},{"$f":"IFERROR(MATCH(S1,$Q$1:$Q$45,0),\"\")","v":1},{"$f":"IFERROR(INDEX($O$1:$O$45,T1,0),\"\")","v":""},{"$f":"IF(Configurator_EN!$N$1=a!W1,a!U1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(U1,$X$1:$Y$45,2,FALSE),\"\")","v":""},"MT4-024-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W1,a!S1,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z1)),\"\")","v":""},{"$f":"IFERROR(INDEX($X$1:$X$45,AA1,1),\"\")","v":""},{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H16=\"Flanges\"),\"Included\",AB1)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT4-024-NO-2.5M",4,"open","24Vac/dc",2.5,"2Pt, 3Pt","No","A",240,"With cap",2,"-",{"$f":"IF(N1=\"A\",C2,IF(N1=\"B\",C14,IF(N1=\"R\",C44,IF(N1=\"Motor fast\",C26,IF(N1=\"I\",\"Actuator included\",\"\")))))","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(O2,$C$1:$H$45,6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O2,C2:M46,11,FALSE),\"\")","v":""},{"$f":"IF(Configurator_EN!$M$1=a!P2,a!Q2,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R2)),\"\")","v":""},{"$f":"IFERROR(MATCH(S2,$Q$1:$Q$45,0),\"\")","v":1},{"$f":"IFERROR(INDEX($O$1:$O$45,T2,0),\"\")","v":""},{"$f":"IF(Configurator_EN!$N$1=a!W2,a!U2,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(U2,$X$1:$Y$45,2,FALSE),\"\")","v":""},"MT4-024-NO-2.5M","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W2,a!S2,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z2)),\"\")","v":""},{"$f":"IFERROR(INDEX($X$1:$X$45,AA2,1),\"\")","v":""},{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H17=\"Flanges\"),\"Included\",AB2)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT4-024S-NO",4,"open","24Vac/dc",1,"2Pt, 3Pt",1,"A",240,"With cap",3,"2Pt, 3Pt",{"$f":"IF(N1=\"A\",C3,IF(N1=\"B\",C15,IF(N1=\"R\",C45,IF(N1=\"I\",\"Actuator included\",\"\"))))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P3,a!Q3,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R3)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W3,a!U3,\"\")","v":""},"","MT4-024S-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W3,a!S3,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z3)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H18=\"Flanges\"),\"Included\",AB3)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT4-024-NC",4,"Close","24Vac/dc",1,"2Pt, 3Pt","No","A",240,"With cap",4,"0…10V",{"$f":"IF(N1=\"A\",C4,IF(N1=\"B\",C16,IF(N1=\"R\",\"\",IF(N1=\"I\",\"Actuator included\",\"\"))))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P4,a!Q4,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R4)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W4,a!U4,\"\")","v":""},"","MT4-024-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W4,a!S4,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z4)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H19=\"Flanges\"),\"Included\",AB4)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT4-024-NC-2.5M",4,"Close","24Vac/dc",2.5,"2Pt, 3Pt","No","A",240,"With cap",5,"-",{"$f":"IF(N1=\"A\",C5,IF(N1=\"B\",C17,IF(N1=\"R\",\"\",IF(N1=\"I\",\"Actuator included\",\"\"))))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P5,a!Q5,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R5)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W5,a!U5,\"\")","v":""},"","MT4-024-NC-2.5M","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W5,a!S5,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z5)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H20=\"Flanges\"),\"Included\",AB5)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT4-024S-NC",4,"Close","24Vac/dc",1,"2Pt, 3Pt",1,"A",240,"With cap",6,"Therm NO",{"$f":"IF(N1=\"A\",C6,IF(N1=\"B\",C18,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P6,a!Q6,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R6)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W6,a!U6,\"\")","v":""},"","MT4-024S-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W6,a!S6,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z6)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H21=\"Flanges\"),\"Included\",AB6)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT4-230-NO",4,"open","230Vac",1,"2Pt, 3Pt","No","A",240,"With cap",7,"Therm NC",{"$f":"IF(N1=\"A\",C7,IF(N1=\"B\",C19,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P7,a!Q7,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R7)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W7,a!U7,\"\")","v":""},"","MT4-230-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W7,a!S7,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z7)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H22=\"Flanges\"),\"Included\",AB7)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT4-230-NO-2.5M",4,"open","230Vac",2.5,"2Pt, 3Pt","No","A",240,"With cap",8,"Motor",{"$f":"IF(N1=\"A\",C8,IF(N1=\"B\",C20,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P8,a!Q8,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R8)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W8,a!U8,\"\")","v":""},"","MT4-230-NO-2.5M","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W8,a!S8,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z8)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H23=\"Flanges\"),\"Included\",AB8)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT4-230S-NO",4,"open","230Vac",1,"2Pt, 3Pt",1,"A",240,"With cap",9,null,{"$f":"IF(N1=\"A\",C9,IF(N1=\"B\",C21,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P9,a!Q9,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R9)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W9,a!U9,\"\")","v":""},"","MT4-230S-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W9,a!S9,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z9)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H24=\"Flanges\"),\"Included\",AB9)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT4-230-NC",4,"Close","230Vac",1,"2Pt, 3Pt","No","A",240,"With cap",10,null,{"$f":"IF(N1=\"A\",C10,IF(N1=\"B\",C22,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P10,a!Q10,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R10)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W10,a!U10,\"\")","v":""},"","MT4-230-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W10,a!S10,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z10)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H25=\"Flanges\"),\"Included\",AB10)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT4-230-NC-2.5M",4,"Close","230Vac",2.5,"2Pt, 3Pt","No","A",240,"With cap",11,null,{"$f":"IF(N1=\"A\",C11,IF(N1=\"B\",C23,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P11,a!Q11,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R11)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W11,a!U11,\"\")","v":""},"","MT4-230-NC-2.5M","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W11,a!S11,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z11)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H26=\"Flanges\"),\"Included\",AB11)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT4-230S-NC",4,"Close","230Vac",1,"2Pt, 3Pt",1,"A",240,"With cap",12,null,{"$f":"IF(N1=\"A\",C12,IF(N1=\"B\",C24,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P12,a!Q12,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R12)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W12,a!U12,\"\")","v":""},"","MT4-230S-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W12,a!S12,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z12)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H27=\"Flanges\"),\"Included\",AB12)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT8-024-NO",8,"open","24Vac/dc",1,"2Pt, 3Pt","No","B",360,"With cap",13,null,{"$f":"IF(N1=\"A\",C35,IF(N1=\"B\",C27,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P13,a!Q13,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R13)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W13,a!U13,\"\")","v":""},"","MT8-024-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W13,a!S13,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z13)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H28=\"Flanges\"),\"Included\",AB13)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT8-024-NO-2.5M",8,"open","24Vac/dc",2.5,"2Pt, 3Pt","No","B",360,"With cap",14,null,{"$f":"IF(N1=\"A\",C36,IF(N1=\"B\",C28,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P14,a!Q14,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R14)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W14,a!U14,\"\")","v":""},"","MT8-024-NO-2.5M","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W14,a!S14,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z14)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H29=\"Flanges\"),\"Included\",AB14)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT8-024S-NO",8,"open","24Vac/dc",1,"2Pt, 3Pt",1,"B",360,"With cap",15,null,{"$f":"IF(N1=\"A\",C37,IF(N1=\"B\",C29,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P15,a!Q15,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R15)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W15,a!U15,\"\")","v":""},"","MT8-024S-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W15,a!S15,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z15)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H30=\"Flanges\"),\"Included\",AB15)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT8-024-NC",8,"Close","24Vac/dc",1,"2Pt, 3Pt","No","B",360,"With cap",16,null,{"$f":"IF($N$1=\"A\",C38,IF($N$1=\"B\",C30,IF($N$1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P16,a!Q16,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R16)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W16,a!U16,\"\")","v":""},"","MT8-024-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W16,a!S16,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z16)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H31=\"Flanges\"),\"Included\",AB16)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT8-024-NC-2.5M",8,"Close","24Vac/dc",2.5,"2Pt, 3Pt","No","B",360,"With cap",17,null,{"$f":"IF(N1=\"A\",\"\",IF(N1=\"B\",C27,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P17,a!Q17,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R17)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W17,a!U17,\"\")","v":""},"","MT8-024-NC-2.5M","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W17,a!S17,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z17)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H32=\"Flanges\"),\"Included\",AB17)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT8-024S-NC",8,"Close","24Vac/dc",1,"2Pt, 3Pt",1,"B",360,"With cap",18,null,{"$f":"IF(N1=\"A\",\"\",IF(N1=\"B\",C28,IF(N1=\"I\",\"Actuator included\",\"\")))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P18,a!Q18,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R18)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W18,a!U18,\"\")","v":""},"","MT8-024S-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W18,a!S18,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z18)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H33=\"Flanges\"),\"Included\",AB18)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT8-230-NO",8,"open","230Vac",1,"2Pt, 3Pt","No","B",390,"With cap",19,null,{"$f":"IF($N$1=\"B\",C29,IF($N$1=\"I\",\"Actuator included\",\"\"))","v":{"$error":"#N/A"}},"","",{"$f":"IF(Configurator_EN!$M$1=a!P19,a!Q19,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R19)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W19,a!U19,\"\")","v":""},"","MT8-230-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W19,a!S19,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z19)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!I37=\"Flanges\"),\"Included\",AB19)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT8-230-NO-2.5M",8,"open","230Vac",2.5,"2Pt, 3Pt","No","B",390,"With cap",20,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P20,a!Q20,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R20)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W20,a!U20,\"\")","v":""},"","MT8-230-NO-2.5M","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W20,a!S20,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z20)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!#REF!=\"Flanges\"),\"Included\",AB20)","v":{"$error":"#N/A"}}]
[null,"Therm NO","MT8-230S-NO",8,"open","230Vac",1,"2Pt, 3Pt",1,"B",390,"With cap",21,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P21,a!Q21,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R21)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W21,a!U21,\"\")","v":""},"","MT8-230S-NO","Therm NO",{"$f":"IF(Configurator_EN!$N$1=a!W21,a!S21,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z21)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!#REF!=\"Flanges\"),\"Included\",AB21)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT8-230-NC",8,"Close","230Vac",1,"2Pt, 3Pt","No","B",390,"With cap",22,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P22,a!Q22,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R22)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W22,a!U22,\"\")","v":""},"","MT8-230-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W22,a!S22,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z22)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!#REF!=\"Flanges\"),\"Included\",AB22)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT8-230-NC-2.5M",8,"Close","230Vac",2.5,"2Pt, 3Pt","No","B",390,"With cap",23,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P23,a!Q23,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R23)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W23,a!U23,\"\")","v":""},"","MT8-230-NC-2.5M","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W23,a!S23,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z23)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!#REF!=\"Flanges\"),\"Included\",AB23)","v":{"$error":"#N/A"}}]
[null,"Therm NC","MT8-230S-NC",8,"Close","230Vac",1,"2Pt, 3Pt",1,"B",390,"With cap",24,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P24,a!Q24,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R24)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W24,a!U24,\"\")","v":""},"","MT8-230S-NC","Therm NC",{"$f":"IF(Configurator_EN!$N$1=a!W24,a!S24,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z24)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H39=\"Flanges\"),\"Included\",AB24)","v":{"$error":"#N/A"}}]
[null,"Fast run","M5410C1001",6.5,"Standstill","24Vac/dc",1.5,"2Pt, 3Pt","No","B","3.6&16","With cap",25,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P25,a!Q25,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R25)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W25,a!U25,\"\")","v":""},"","M5410C1001","Fast run",{"$f":"IF(Configurator_EN!$N$1=a!W25,a!S25,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z25)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H40=\"Flanges\"),\"Included\",AB25)","v":{"$error":"#N/A"}}]
[null,"Fast run","M5410L1001",6.5,"Standstill","230Vac",1.5,"2Pt, 3Pt","No","B","3.6&16","With cap",26,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P26,a!Q26,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R26)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W26,a!U26,\"\")","v":""},"","M5410L1001","Fast run",{"$f":"IF(Configurator_EN!$N$1=a!W26,a!S26,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z26)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H41=\"Flanges\"),\"Included\",AB26)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410C1007",6.5,"Standstill","24Vac",0.9,"2Pt, 3Pt","No","B",150,"No",27,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P27,a!Q27,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R27)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W27,a!U27,\"\")","v":""},"","M7410C1007","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W27,a!S27,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z27)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H42=\"Flanges\"),\"Included\",AB27)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410C1007-3M",6.5,"Standstill","24Vac",3,"2Pt, 3Pt","No","B",150,"No",28,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P28,a!Q28,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R28)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W28,a!U28,\"\")","v":""},"","M7410C1007-3M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W28,a!S28,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z28)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H43=\"Flanges\"),\"Included\",AB28)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410C1007-5M",6.5,"Standstill","24Vac",5,"2Pt, 3Pt","No","B",150,"No",29,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P29,a!Q29,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R29)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W29,a!U29,\"\")","v":""},"","M7410C1007-5M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W29,a!S29,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z29)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H44=\"Flanges\"),\"Included\",AB29)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410C1007-10M",6.5,"Standstill","24Vac",10,"2Pt, 3Pt","No","B",150,"No",30,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P30,a!Q30,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R30)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W30,a!U30,\"\")","v":""},"","M7410C1007-10M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W30,a!S30,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z30)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H45=\"Flanges\"),\"Included\",AB30)","v":{"$error":"#N/A"}}]
[null,"Motor","M6410C2023",6.5,"Standstill","24Vac",1.5,"2Pt, 3Pt","No","B",150,"Yes",31,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P31,a!Q31,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R31)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W31,a!U31,\"\")","v":""},"","M6410C2023","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W31,a!S31,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z31)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H46=\"Flanges\"),\"Included\",AB31)","v":{"$error":"#N/A"}}]
[null,"Motor","M6410C4029",6.5,"Standstill","24Vac",1.5,"2Pt, 3Pt",2,"B",150,"Yes",32,null,{"$error":"#N/A"},"","",{"$f":"IF(Configurator_EN!$M$1=a!P32,a!Q32,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R32)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W32,a!U32,\"\")","v":""},"","M6410C4029","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W32,a!S32,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z32)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H47=\"Flanges\"),\"Included\",AB32)","v":{"$error":"#N/A"}}]
[null,"Motor","M6410L2023",6.5,"Standstill","230Vac",1.5,"2Pt, 3Pt","No","B",150,"Yes",33,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P33,a!Q33,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R33)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W33,a!U33,\"\")","v":""},"","M6410L2023","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W33,a!S33,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z33)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H48=\"Flanges\"),\"Included\",AB33)","v":{"$error":"#N/A"}}]
[null,"Motor","M6410L4029",6.5,"Standstill","230Vac",1.5,"2Pt, 3Pt",2,"B",150,"Yes",34,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P34,a!Q34,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R34)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W34,a!U34,\"\")","v":""},"","M6410L4029","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W34,a!S34,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z34)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H49=\"Flanges\"),\"Included\",AB34)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E5001",2.9,"Standstill","24Vac",1.5,"0…10V","No","A",70,"No",35,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P35,a!Q35,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R35)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W35,a!U35,\"\")","v":""},"","M7410E5001","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W35,a!S35,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z35)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H50=\"Flanges\"),\"Included\",AB35)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E5001-3M",2.9,"Standstill","24Vac",3,"0…10V","No","A",70,"No",36,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P36,a!Q36,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R36)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W36,a!U36,\"\")","v":""},"","M7410E5001-3M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W36,a!S36,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z36)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H51=\"Flanges\"),\"Included\",AB36)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E5001-5M",2.9,"Standstill","24Vac",5,"0…10V","No","A",70,"No",37,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P37,a!Q37,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R37)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W37,a!U37,\"\")","v":""},"","M7410E5001-5M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W37,a!S37,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z37)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H52=\"Flanges\"),\"Included\",AB37)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E5001-10M",2.9,"Standstill","24Vac",10,"0…10V","No","A",70,"No",38,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P38,a!Q38,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R38)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W38,a!U38,\"\")","v":""},"","M7410E5001-10M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W38,a!S38,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z38)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H53=\"Flanges\"),\"Included\",AB38)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E1002",6.5,"Standstill","24Vac",1.5,"0…10V","No","B",150,"No",39,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P39,a!Q39,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R39)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W39,a!U39,\"\")","v":""},"","M7410E1002","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W39,a!S39,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z39)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H54=\"Flanges\"),\"Included\",AB39)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E1002-10M",6.5,"Standstill","24Vac",10,"0…10V","No","B",150,"No",40,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P40,a!Q40,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R40)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W40,a!U40,\"\")","v":""},"","M7410E1002-10M","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W40,a!S40,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z40)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H55=\"Flanges\"),\"Included\",AB40)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E2026",6.5,"Standstill","24Vac",1.5,"0…10V","No","B",150,"Yes",41,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P41,a!Q41,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R41)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W41,a!U41,\"\")","v":""},"","M7410E2026","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W41,a!S41,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z41)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H56=\"Flanges\"),\"Included\",AB41)","v":{"$error":"#N/A"}}]
[null,"Motor","M7410E4022",6.5,"Standstill","24Vac",1.5,"0…10V",2,"B",150,"Yes",42,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P42,a!Q42,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R42)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W42,a!U42,\"\")","v":""},"","M7410E4022","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W42,a!S42,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z42)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H57=\"Flanges\"),\"Included\",AB42)","v":{"$error":"#N/A"}}]
[null,"Motor","M7061E1012","90°","Standstill","24Vac/dc","-","0…10V",null,"R",90,"Yes",43,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P43,a!Q43,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R43)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W43,a!U43,\"\")","v":""},"","M7061E1012","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W43,a!S43,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z43)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H58=\"Flanges\"),\"Included\",AB43)","v":{"$error":"#N/A"}}]
[null,"Motor","M6061A1013","90°","Standstill","24Vac","-","2Pt, 3Pt","Yes","R",90,"Yes",44,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P44,a!Q44,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R44)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W44,a!U44,\"\")","v":""},"","M6061A1013","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W44,a!S44,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z44)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H59=\"Flanges\"),\"Included\",AB44)","v":{"$error":"#N/A"}}]
[null,"Motor","M6061L1019","90°","Standstill","230Vac","-","2Pt, 3Pt","Yes","R",90,"Yes",45,null,null,"","",{"$f":"IF(Configurator_EN!$M$1=a!P45,a!Q45,\"\")","v":""},{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R45)),\"\")","v":""},1,"",{"$f":"IF(Configurator_EN!$N$1=a!W45,a!U45,\"\")","v":""},"","M6061L1019","Motor",{"$f":"IF(Configurator_EN!$N$1=a!W45,a!S45,\"\")","v":""},{"$f":"IFERROR(SMALL($Z$1:$Z$45,ROWS(Z$1:$Z45)),\"\")","v":""},"",{"$f":"IF(AND(a!$N$1=\"I\",Configurator_EN!H60=\"Flanges\"),\"Included\",AB45)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N19=\"B\",C60,IF(N23=\"I\",\"Actuator included\",\"\"))","v":""},null,"",null,{"$f":"IFERROR(SMALL($R$1:$R$45,ROWS($R$1:R46)),\"\")","v":""},{"$f":"O46","v":""}]
[null,"Actuator\n type","Part Number","Stroke Action","powerless","Voltage","Cable","Ctrl mode","End \nswitches","Type","Run time","Manual","Helper1\n","lists","part number A, B R, I correct stroke","CTRL signal","Type  number","number  by CTRL","aligned numbers","match","index",null,null,"Part Number","Actuator\n type","Helper2","Helper3"]

{"sheet":"Valves actuators list","index":5,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["V5004TY10150150","PICV, DN15, 20…400KPA, 45…150L/H,W gauge ports ","MT4-024-NO","THERMAL ACTUATOR,   4MM,   24V,   NO"]
["V5004TY10150600","PICV, DN15, 25…400KPA, 60…600L/H,W gauge ports","MT4-024-NO-2.5M","THERMAL ACTUATOR, 4MM, 24V, NO, 2.5M"]
["V5004TY10150780","PICV, DN15, 35…400KPA, 78…780L/H,W gauge ports","MT4-024S-NO","THERMAL ACTUATOR, 4MM, 24V, NO, SWITCH"]
["V5004TY10201000","PICV, DN20, 30…400KPA, 100…1000L/H,W gauge ports","MT4-024-NC","THERMAL ACTUATOR,   4MM,  24V,   NC"]
["V5004TY10201500","PICV, DN20, 35…400KPA, 450…1500L/H,W gauge ports","MT4-024-NC-2.5M","THERMAL ACTUATOR, 4MM, 24V, NC, 2.5M"]
["V5004TY10251500","PICV, DN25, 35…400KPA, 450…1500L/H,W gauge ports","MT4-024S-NC","THERMAL ACTUATOR, 4MM, 24V, NC,  SWITCH"]
["V5004TY10202200","PICV, DN20, 25…400KPA, 220…2200L/H,W gauge ports","MT4-230-NO","THERMAL ACTUATOR,   4MM,   230V,   NO"]
["V5004TY10202700","PICV, DN20, 25…400KPA, 270…2700L/H,W gauge ports","MT4-230-NO-2.5M","THERMAL ACTUATOR, 4MM  230V,  NO,  2.5M"]
["V5004TY10252200","PICV, DN25, 25…400KPA, 220…2200L/H,W gauge ports","MT4-230S-NO","THERMAL ACTUATOR, 4MM, 230V, NO, SWITCH"]
["V5004TY10252700","PICV, DN25, 25…400KPA, 270…2700L/H,W gauge ports","MT4-230-NC","THERMAL ACTUATOR, 4MM,  230V, NC"]
["V5004TY10322700","PICV, DN32, 25…400KPA, 270…2700L/H,W gauge ports","MT4-230-NC-2.5M","THERMAL ACTUATOR, 4MM, 230V, NC, 2.5M"]
["V5004TY10323000","PICV, DN32, 35…400KPA, 300…3000L/H,W gauge ports","MT4-230S-NC","THERMAL ACTUATOR, 4MM, 230V, NC, SWITCH"]
["V5004TY10326000","PICV, DN32, 30…400KPA, 1800…6000L/H,W gauge ports","MT8-024-NO","THERMAL ACTUATOR, 8MM, 24V, NO"]
["V5004TY10409000","PICV, DN40, 35…400KPA, 2700…9000L/H,W gauge ports","MT8-024-NO-2.5M","THERMAL ACTUATOR, 8MM, 24V, NO, 2.5M"]
["V5004TY10501200","PICV, DN50, 40…400KPA, 3300…11000L/H,W gauge ports","MT8-024S-NO","THERMAL ACTUATOR , 8MM, 24V, NO, SWITCH"]
["V5004TY10501700","PICV, DN50, 35…400KPA, 5400…18000L/H,W gauge ports","MT8-024-NC","THERMAL ACTUATOR,  8MM, 24V, NC"]
["V5004TF1050","PICV, DN50, 40…400KPA, 2000…20000L/H,W gauge ports","MT8-024-NC-2.5M","THERMAL ACTUATOR , 8MM, 24V, 8MM, NC, 2.5M"]
["V5004TF1065","PICV, DN65, 30…400KPA, 3000…30000L/H,W gauge ports","MT8-024S-NC","THERMAL ACTUATOR , 8MM, 24V, SWITCH"]
["V5004TF1080","PICV, DN80, 30…400KPA, 3000…30000L/H,W gauge ports","MT8-230-NO","THERMAL ACTUATOR,  8MM, 230V, NO"]
["V5004TF1100","PICV, DN100, 30…400KPA, 5500…55000L/H,W gauge ports","MT8-230-NO-2.5M","THERMAL ACTUATOR, 8MM, 230V, NO, 2.5M"]
["V5004TF1125","PICV, DN125, 35…400KPA, 9000…90000L/H,W gauge ports","MT8-230S-NO","THERMAL ACTUATOR, 8MM, 230V, NO, SWITCH"]
["V5004TF1150","PICV, DN150, 50…400KPA, 15000…150000L/H,W gauge ports","MT8-230-NC","THERMAL ACTUATOR, 8MM, 230V, NC"]
["V5005TY10150350"," PICV,DN15,max.400KPA,20…350L/H,W gauge ports ","MT8-230-NC-2.5M","THERMAL ACTUATOR, 8MM, 230V, NC, 2.5M"]
["V5005TY10151000"," PICV,DN15,max.400KPA,100…1000L/H,W gauge ports ","MT8-230S-NC","THERMAL ACTUATOR, 8MM, 230V, NC, SWITCH"]
["V5005TY10201000"," PICV,DN20,max.400KPA,100…1000L/H,W gauge ports ","M5410C1001","FAST REACTING ACTUATOR, 6,5MM, 24V"]
["V5005TY10201500"," PICV,DN20,max.400KPA,200…1500L/H,W gauge ports ","M5410L1001","FAST REACTING ACTUATOR, 6,5MM, 230v"]
["V5005TY10251000"," PICV,DN25,max.400KPA,100…1000L/H,W gauge ports ","M7410A1001","ACTUATOR 3-POS, 4MM, 24V, 90N, 0,9M"]
["V5005TY10251500"," PICV,DN25,max.400KPA,200…1500L/H,W gauge ports ","M7410A1001-3M","ACTUATOR 3-POS, 4MM, 24V, 90N, 3M"]
["V5005TY20150350"," PICV,DN15,max.400KPA,20…350L/H,W gauge ports","M7410A1001-5M","ACTUATOR 3-POS, 4MM, 24V, 90N, 5M"]
["V5005TY20151000"," PICV,DN15,max.400KPA,100…1000L/H,W gauge ports","M7410A1001-10M","ACTUATOR 3-POS, 4MM, 24V, 90N, 10M"]
["V5005TY20201000"," PICV,DN20,max.400KPA,100…1000L/H,W gauge ports","M7410C1007","ACTUATOR 3-POS 6,5MM, 24V, 180N, 1,5M"]
["V5005TY20201500"," PICV,DN20,max.400KPA,200…1500L/H,W gauge ports","M7410C1007-3M","ACTUATOR 3-POS 6,5MM, 24V, 180N, 3M"]
["V5005TY20251000","PICV, DN25, max. 400KPA, 100…1000L/H,W gauge ports","M7410C1007-5M","ACTUATOR 3-POS 6,5MM, 24V, 180N, 5M"]
["V5005TY20251500","PICV, DN25, max. 400KPA, 200…1500L/H,W gauge ports","M7410C1007-10M","ACTUATOR 3-POS 6,5MM, 24V, 180N, 10M"]
["V5004TF1200LF","PICV, DN200, 40…400kPa, 20000…200000l/h,W gauge ports","M6410C2023","ACTUATOR 3-POS 6,5MM, 24V, 180N, MAN OP"]
["V5004TF1200HF","PICV, DN200, 40…400kPa, 30000…300000l/h,W gauge ports","M6410C4029","ACTUATOR 3-POS 6,5MM, 24V, 180N, MAN OP, AUX SW"]
["V5004TF1250LF","PICV, DN250, 40…400kPa, 30000…300000l/h,W gauge ports","M6410L2023","ACTUATOR 3-POS 6,5MM, 230V, 180N, MAN OP"]
["V5004TF1250HF","PICV, DN250, 65…400kPa, 50000…500000l/h,W gauge ports","M6410L4029","ACTUATOR 3-POS 6,5MM, 230V, 180N, MAN OP, AUX SW"]
[null,null,"M7410E5001","ACTUATOR 0...10V, 2,9MM, 24V, 90N, 1,5M"]
[null,null,"M7410E5001-3M","ACTUATOR 0...10V, 2,9MM, 24V, 90N, 3M"]
[null,null,"M7410E5001-5M","ACTUATOR 0...10V, 2,9MM, 24V, 90N, 5M"]
[null,null,"M7410E5001-10M","ACTUATOR 0...10V, 2,9MM, 24V, 90N, 10M"]
[null,null,"M7410E1002","ACTUATOR 0...10V, 6,5MM, 24V, 180N, 1,5M"]
[null,null,"M7410E1002-10M","ACTUATOR 0...10V, 6,5MM, 24V, 180N, 10M"]
[null,null,"M7410E2026","ACTUATOR 0...10V, 6,5MM, 24V, 180N, MAN OP, 1,5M"]
[null,null,"M7410E4022","ACTUATOR 0...10V, 6,5MM, 24V, 180N, MAN OP, 1,5M AUX SW"]
[null,null,"M7061E1012","ROTARY ACTUATOR, 0...10V, 90°, 24V, 10NM"]
[null,null,"M6061A1013","ROTARY ACTUATOR 3-POS, 90°, 24V, 10NM"]
[null,null,"M6061L1019","ROTARY ACTUATOR 3-POS, 90°, 230V, 10NM"]