{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Min-Max Flow Rates","Calculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Min-Max Flow Rates","index":0,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,3,0,6]]}
["Size, ND",null,null,"Nominal Flow, m3/s",{"$nulls":8},"m3/h",{"$f":"1/3600","v":2.7777777777777778E-4},"mm/s",{"$f":"10^(-3)","v":1E-3}]
[{"$f":"10^(-3)","v":1E-3},null,null,"min FS settable",null,null,"max FS settable",{"$nulls":5},"m3/min",{"$f":"1/60","v":1.6666666666666666E-2},"cm/s",{"$f":"10^(-2)","v":0.01}]
["mm","m","inches","0,4 m/s","1 m/s",null,"10 m/s",null,"PF55S","PF75S","PF75H",null,"m3/s",1,"m/s",1]
[0,0,0,0,0,0,0,{"$nulls":5},"l/h",{"$f":"10^(-3)/3600","v":2.7777777777777776E-7},"in/s",2.5399999999999999E-2]
[3,{"$f":"A5*$A$2","v":3.0000000000000001E-3},"1/8",{"$f":"PI()*(($B5/2)^2)*0.4","v":2.8274333882308137E-6},{"$f":"PI()*(($B5/2)^2)*1","v":7.0685834705770344E-6},{"$f":"E5*Calculation!$D$2","v":7.0685834705770342E-5},{"$f":"PI()*(($B5/2)^2)*10","v":7.0685834705770342E-5},{"$f":"\"DN\"&A5","v":"DN3"},"not available","not available","PF75H-5###########A###########",null,"l/min",{"$f":"10^(-3)/60","v":1.6666666666666667E-5},"ft/s",0.30480000000000002]
[6,{"$f":"A6*$A$2","v":6.0000000000000001E-3},"1/4",{"$f":"PI()*(($B6/2)^2)*0.4","v":1.1309733552923255E-5},{"$f":"PI()*(($B6/2)^2)*1","v":2.8274333882308137E-5},{"$f":"E6*Calculation!$D$2","v":2.8274333882308137E-4},{"$f":"PI()*(($B6/2)^2)*10","v":2.8274333882308137E-4},{"$f":"\"DN\"&A6","v":"DN6"},"not available","not available","PF75H-5###########B###########",null,"l/s",{"$f":"10^(-3)","v":1E-3},"yd/s",0.91439999999999999]
[10,0.01,"3/8",3.1415926535897935E-5,7.8539816339744827E-5,{"$f":"E7*Calculation!$D$2","v":7.8539816339744822E-4},7.8539816339744822E-4,"DN10","PF55S-##.######.1#######","not available","PF75H-5###########C###########",null,"Imp. gal/h",{"$f":"0.00454609/3600","v":1.2628027777777779E-6}]
[15,1.4999999999999999E-2,"1/2",7.0685834705770342E-5,1.7671458676442585E-4,{"$f":"E8*Calculation!$D$2","v":1.7671458676442584E-3},1.7671458676442584E-3,"DN15","PF55S-##.######.2#######","not available","PF75H-5###########D###########",null,"Imp. gal/min",{"$f":"0.00454609/60","v":7.5768166666666671E-5}]
[20,0.02,"3/4",1.2566370614359174E-4,3.1415926535897931E-4,{"$f":"E9*Calculation!$D$2","v":3.1415926535897929E-3},3.1415926535897929E-3,"DN20","PF55S-##.######.3#######","not available","PF75H-5###########E###########",null,"Imp. gal/s",{"$f":"0.00454609","v":4.54609E-3}]
[25,2.5000000000000001E-2,1,1.9634954084936211E-4,4.9087385212340522E-4,{"$f":"E10*Calculation!$D$2","v":4.9087385212340517E-3},4.9087385212340517E-3,"DN25","PF55S-##.######.4#######","PF75S-5###########F###########","PF75H-5###########F###########",null,"US. liq. gal/h",{"$f":"0.003785411784/3600","v":1.0515032733333334E-6}]
[32,3.2000000000000001E-2,1.25,3.2169908772759483E-4,8.0424771931898698E-4,{"$f":"E11*Calculation!$D$2","v":8.0424771931898696E-3},8.0424771931898696E-3,"DN32","PF55S-##.######.5#######","PF75S-5###########G###########","PF75H-5###########G###########",null,"US. liq. gal/min",{"$f":"0.003785411784/60","v":6.3090196400000003E-5}]
[40,0.04,1.5,5.0265482457436696E-4,1.2566370614359172E-3,{"$f":"E12*Calculation!$D$2","v":1.2566370614359171E-2},1.2566370614359171E-2,"DN40","PF55S-##.######.6#######","PF75S-5###########H###########","PF75H-5###########H###########",null,"US. liq. gal/s",{"$f":"0.003785411784","v":3.7854117840000001E-3}]
[50,0.05,2,7.8539816339744844E-4,1.9634954084936209E-3,{"$f":"E13*Calculation!$D$2","v":1.9634954084936207E-2},1.9634954084936207E-2,"DN50","PF55S-##.######.7#######","PF75S-5###########I###########","PF75H-5###########I###########"]
[65,6.5000000000000002E-2,2.5,1.3273228961416879E-3,3.3183072403542195E-3,{"$f":"E14*Calculation!$D$2","v":3.3183072403542194E-2},3.3183072403542194E-2,"DN65","not available","PF75S-5###########J###########","PF75H-5###########J###########"]
[80,0.08,3,2.0106192982974678E-3,5.0265482457436689E-3,{"$f":"E15*Calculation!$D$2","v":5.0265482457436686E-2},5.0265482457436686E-2,"DN80","not available","PF75S-5###########K###########","PF75H-5###########K###########"]
[100,0.1,4,3.1415926535897937E-3,7.8539816339744835E-3,{"$f":"E16*Calculation!$D$2","v":7.8539816339744828E-2},7.8539816339744828E-2,"DN100","not available","PF75S-5###########L###########","PF75H-5###########L###########"]
[125,0.125,5,4.9087385212340517E-3,1.2271846303085129E-2,{"$f":"E17*Calculation!$D$2","v":0.12271846303085129},0.12271846303085129,"DN125","not available","PF75S-5###########M###########","not available"]
[150,0.15,6,7.0685834705770355E-3,1.7671458676442587E-2,{"$f":"E18*Calculation!$D$2","v":0.17671458676442586},0.17671458676442586,"DN150","not available","PF75S-5###########N###########","not available"]
[200,0.2,8,1.2566370614359175E-2,3.1415926535897934E-2,{"$f":"E19*Calculation!$D$2","v":0.31415926535897931},0.31415926535897931,"DN200","not available","PF75S-5###########O###########","not available"]
[250,{"$f":"A20*$A$2","v":0.25},10,1.9634954084936207E-2,4.9087385212340517E-2,{"$f":"E20*Calculation!$D$2","v":0.49087385212340517},0.49087385212340517,{"$f":"\"DN\"&A20","v":"DN250"},"not available","PF75S-5###########P###########","not available"]
[{"$nulls":7},"Flow rate too high"]
[{"$nulls":7},"Flow rate too low"]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"D7*60*1000","v":1.8849555921538761}]

{"sheet":"Calculation","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Max. flow rate",1,"m3/h",{"$f":"VLOOKUP(C1,'Min-Max Flow Rates'!M1:N12,2,0)*Calculation!B1","v":2.7777777777777778E-4},"m3/s"]
["Max. allowed flow speed",10,"m/s",{"$f":"VLOOKUP(C2,'Min-Max Flow Rates'!O1:P6,2,0)*Calculation!B2","v":10},"m/s"]
[null,null,null,{"$f":"D1/(PI()*(10^(-3)*INDEX('Min-Max Flow Rates'!A4:H20,IF(MATCH(D1,'Min-Max Flow Rates'!G4:G20,1)>16,17,MATCH(D1,'Min-Max Flow Rates'!G4:G20,1)+1),1)/2)^2)/VLOOKUP(E3,'Min-Max Flow Rates'!O1:P6,2,0)","v":9.8243792032034172},"m/s"]
[null,null,null,{"$f":"IF(E4>17,'Min-Max Flow Rates'!H21,INDEX('Min-Max Flow Rates'!F4:H20,Calculation!E4,3))","v":"DN6"},{"$f":"MATCH(D1,'Min-Max Flow Rates'!G4:G20,1)+1+IF(D3>10,ROUNDDOWN(D2/10,0),0)+IF(D3>D2,ROUNDUP(D3/D2,0),0)","v":3}]
["You need a Magmeter with nomininal dimaeter",{"$f":"IF(B7>B1,'Min-Max Flow Rates'!H22,IF(E4>17,'Min-Max Flow Rates'!H21,INDEX('Min-Max Flow Rates'!F4:H20,Calculation!E4,3)))","v":"DN6"}]
["Resulting max. flow speed ",{"$f":"IF(B7>B1,'Min-Max Flow Rates'!H22,IF(E4>17,'Min-Max Flow Rates'!H21,D1/(PI()*(10^(-3)*INDEX('Min-Max Flow Rates'!A4:A20,Calculation!E4,1)/2)^2)/VLOOKUP(C6,'Min-Max Flow Rates'!O1:P6,2,0)))","v":9.8243792032034172},{"$f":"C2","v":"m/s"}]
["Min. measurable flow rate",{"$f":"INDEX('Min-Max Flow Rates'!A4:H20,IF(Calculation!E4>17,17,Calculation!E4),4)/VLOOKUP(C1,'Min-Max Flow Rates'!M1:N12,2,0)","v":4.0715040790523717E-2},{"$f":"C1","v":"m3/h"}]
[]
["Recommended compact flow meter",{"$f":"_xlfn.IFNA(VLOOKUP(B5,'Min-Max Flow Rates'!H5:K20,2,0),B5)","v":"not available"},{"$f":"IF(B9<>\"not available\",HYPERLINK(\"https://www.baumer.com/p/39513\",\"Link to PF55S on baumer.com\"),\"\")","v":""}]
["Recommended industrial flow meter",{"$f":"_xlfn.IFNA(VLOOKUP(B5,'Min-Max Flow Rates'!H5:K20,3,0),B5)","v":"not available"},{"$f":"IF(B10<>\"not available\",HYPERLINK(\"https://www.baumer.com/p/42442\",\"Link to PF75S on baumer.com\"),\"\")","v":""}]
["Recommended hygienic flow meter",{"$f":"_xlfn.IFNA(VLOOKUP(B5,'Min-Max Flow Rates'!H5:K20,4,0),B5)","v":"PF75H-5###########B###########"},{"$f":"IF(B11<>\"not available\",HYPERLINK(\"https://www.baumer.com/p/39514\",\"Link to PF75H on baumer.com\"),\"\")","v":"Link to PF75H on baumer.com"}]