{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","Input","Output","Stoffdaten","ArtikelNr.","Language","Be-Um-rechnung","Düsen Blendenkit"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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":"Cover","index":0,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,5,26,5]]}
[]
[null,null,{"$f":"F26","v":2}]
[null,null,1,{"$f":"Language!E2","v":"Deutsch"},null,null,null,{"$f":"Input!A1","v":"Version 1.7 : JT 131118 Gen2"}]
[null,null,2,{"$f":"Language!F2","v":"English"}]
[null,null,3,{"$f":"Language!G2","v":"Français"}]
[null,null,4,{"$f":"Language!H2","v":"Italiano"}]
[null,null,5,{"$f":"Language!I2","v":"Español"}]
[null,null,6,{"$f":"Language!J2","v":"Polish"}]
[null,null,7,{"$f":"Language!K2","v":"…"}]
[null,null,8,{"$f":"Language!L2","v":"…"}]
[null,null,9,{"$f":"Language!M2","v":"…"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"Language!D12","v":"Language choice"}]
[null,null,null,"= 1",null,2]
[]
[null,null,null,"= 2"]
[]
[null,null,null,"= 3"]
[]
[null,null,null,"= 4"]
[]
[null,null,null,"= 5"]
[]
[null,null,null,"= 6"]

{"sheet":"Input","index":1,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[14,0,14,1],[3,2,3,6],[26,8,26,9]]}
["Version 1.7 : JT 131118 Gen2"]
[]
[]
[null,null,{"$f":"Language!D13","v":"Please enter only one pressure value!"}]
[null,null,{"$f":"Language!D6","v":"Compressor discharge pressure"},null,null,{"$f":"Language!D7","v":"Minimum inlet pressure"}]
[null,null,7.5,null,null,{"$f":"IF('Be-Um-rechnung'!A20=1,C6-0.5,C6-7)","v":7}]
[null,null,{"$f":"IF('Be-Um-rechnung'!$A$20=1,IF('Be-Um-rechnung'!$A$20=2,Language!$D$31,IF(Input!C6<5.5,Language!$D$31,IF(Input!C6>15.5,Language!$D$31,\" \"))),IF(Input!C6<80,Language!$D$31,IF(Input!C6>225,Language!$D$31,\" \")))","v":" "},null,null,{"$f":"IF('Be-Um-rechnung'!$A$20=1,IF('Be-Um-rechnung'!$A$20=2,Language!$D$33,IF(Input!F6<5,Language!$D$33,IF(Input!F6>15,Language!$D$33,\" \"))),IF(Input!F6<73,Language!$D$33,IF(Input!F6>217,Language!$D$33,\" \")))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"Language!D5","v":"Compressed air flow rate \nat 20°C and 1 bar a"}]
[8]
[{"$f":"IF('Be-Um-rechnung'!C9>Stoffdaten!M33,Language!D11,\" \")","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Language!D4","v":"Ambient temperature"},null,null,null,{"$f":"Language!D8","v":"Maximum inlet temperature"},null,null,{"$f":"Language!D9","v":"Outlet pressure dewpoint"}]
[null,25,null,null,null,35,null,null,"-70°C"]
[null,{"$f":"IF('Be-Um-rechnung'!$A$14=1,IF('Be-Um-rechnung'!$A$14=2,Language!$D$32,IF(Input!B26<1.5,Language!$D$32,IF(Input!B26>50,Language!$D$32,\" \"))),IF(Input!B26<35,Language!$D$32,IF(Input!B26>122,Language!$D$32,\" \")))","v":" "},null,null,null,{"$f":"IF('Be-Um-rechnung'!$A$14=1,IF('Be-Um-rechnung'!$A$14=2,Language!$D$10,IF(Input!F26<25,Language!$D$10,IF(Input!F26>50,Language!$D$10,\" \"))),IF(Input!F26<77,Language!$D$10,IF(Input!F26>122,Language!$D$10,\" \")))","v":" "},null,null,{"$f":"IF('Be-Um-rechnung'!J7=0,Language!D36,\" \")","v":" "}]
[null,null,null,null,null,null,null,{"$f":"'Be-Um-rechnung'!J10","v":12},{"$f":"'Be-Um-rechnung'!J10","v":12},{"$f":"'Be-Um-rechnung'!J10","v":12}]
[null,null,null,{"$f":"Language!D34","v":"Out of standard range! Check the inputs!"},null,null,null,{"$f":"'Be-Um-rechnung'!J10","v":12},{"$f":"'Be-Um-rechnung'!J10","v":12},{"$f":"'Be-Um-rechnung'!J10","v":12}]
[null,null,null,{"$f":"Language!D11","v":"Dryer must be sized by Parker!"},null,null,null,{"$f":"'Be-Um-rechnung'!J10","v":12},{"$f":"'Be-Um-rechnung'!J10","v":12},{"$f":"'Be-Um-rechnung'!J10","v":12}]
[null,null,null,{"$f":"Language!D35","v":"Inputs are OK! GO!"}]

{"sheet":"Output","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[27,2,27,3],[26,2,26,3],[0,0,0,4],[20,2,20,3],[22,2,22,3],[23,2,23,3],[24,2,24,3]]}
[{"$f":"Language!D14","v":"Dryer in accordance with standard specification"}]
[{"$f":"Input!A1","v":"Version 1.7 : JT 131118 Gen2"}]
["K-MT",{"$f":"IF(C5=ArtikelNr.!B3,Stoffdaten!N2,\"#NV\")","v":1},{"$f":"Language!D17","v":"Without dew-point dependant-switching \n(fixed cycle)"},{"$f":"Language!D18","v":"With dew-point dependant-switching \n(variable cycle)"}]
[]
[{"$f":"Language!D20","v":"Order Number/Catalogue Number"},null,{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,ArtikelNr.!B3, Language!D11)","v":"K1/16D2-G230M"},{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,ArtikelNr.!C3,Language!D11)","v":"K1/16D2-G230MT"}]
[]
[{"$f":"Language!D5","v":"Compressed air flow rate \nat 20°C and 1 bar a"},null,{"$f":"'Be-Um-rechnung'!B29","v":8},{"$f":"'Be-Um-rechnung'!B29","v":8},{"$f":"'Be-Um-rechnung'!C29","v":"m³/h"}]
[{"$f":"Input!F5","v":"Minimum inlet pressure"},null,{"$f":"'Be-Um-rechnung'!B20","v":7},{"$f":"'Be-Um-rechnung'!B20","v":7},{"$f":"'Be-Um-rechnung'!C20","v":"bar g"}]
[{"$f":"Input!F25","v":"Maximum inlet temperature"},null,{"$f":"'Be-Um-rechnung'!B14","v":35},{"$f":"'Be-Um-rechnung'!B14","v":35},{"$f":"'Be-Um-rechnung'!C14","v":"°C"}]
[{"$f":"Input!I25","v":"Outlet pressure dewpoint"},null,{"$f":"'Be-Um-rechnung'!B39","v":"-40"},{"$f":"'Be-Um-rechnung'!B39","v":"-40"},{"$f":"'Be-Um-rechnung'!D39","v":"°C"}]
[{"$f":"Language!D19","v":"Average purge-air consumption"},null,{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,ROUND(Stoffdaten!AC2,1), \"#NV\")","v":1.2},{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,ROUND(Stoffdaten!AJ2,1), \"#NV\")","v":1.1000000000000001},{"$f":"'Be-Um-rechnung'!C29","v":"m³/h"}]
[{"$f":"Language!D21","v":"Average outlet flow rate"},null,{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,ROUND((C7-C11),1), \"#NV\")","v":6.8},{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,ROUND((D7-D11),1), \"#NV\")","v":6.9},{"$f":"'Be-Um-rechnung'!C29","v":"m³/h"}]
[]
[{"$f":"Language!D39","v":"cycle  - total"},null,{"$f":"C15*2","v":10},{"$f":"D15*2","v":10.185675036861921},"min"]
[{"$f":"Language!D40","v":"adsorption"},null,{"$f":"Stoffdaten!AO34","v":5},{"$f":"Stoffdaten!AF33","v":5.0928375184309607},"min"]
[{"$f":"Language!D41","v":"regeneration"},null,{"$f":"Stoffdaten!AS36","v":4},{"$f":"C16","v":4},"min"]
[{"$f":"Language!D42","v":"pressurization"},null,1,{"$f":"C17","v":1},"min"]
[{"$f":"Language!D43","v":"Standby"},null,{"$f":"C14-C15-C16-C17","v":0},{"$f":"D14-D15-D16-D17","v":9.2837518430960664E-2},"min"]
[]
[{"$f":"IF(AND('Düsen Blendenkit'!B3=1,'Düsen Blendenkit'!B5<=95),IF(Stoffdaten!O2='Düsen Blendenkit'!H27,\" \",Language!D22),\" \")","v":" "},null,{"$f":"IF(AND('Düsen Blendenkit'!B3=1,'Düsen Blendenkit'!B5<=95),IF(Stoffdaten!O2='Düsen Blendenkit'!H27,\" \",'Düsen Blendenkit'!H27),\" \")","v":" "},{"$f":"IF(AND('Düsen Blendenkit'!B3=1,'Düsen Blendenkit'!B5<=95),IF(Stoffdaten!P2='Düsen Blendenkit'!H44,\" \",'Düsen Blendenkit'!H44),\" \")","v":" "},{"$f":"IF(AND('Düsen Blendenkit'!B3=1,'Düsen Blendenkit'!B5<=95),IF(Stoffdaten!O2='Düsen Blendenkit'!H27,\" \",\"mm\"),\" \")","v":" "}]
[{"$f":"IF(AND('Düsen Blendenkit'!B3=1,'Düsen Blendenkit'!B5<=95),IF(Stoffdaten!O2='Düsen Blendenkit'!H27,\" \",Language!D23),\" \")","v":" "},null,{"$f":"IF(AND('Düsen Blendenkit'!B3=1,'Düsen Blendenkit'!B5<=95),IF(Stoffdaten!O2='Düsen Blendenkit'!H27,\" \",ArtikelNr.!D3),\" \")","v":" "}]
[]
[{"$f":"Language!D26","v":"Dimensions (AxBxC)\n(Width) x (Height) x (Depth)"},null,{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,Stoffdaten!T2, \"#NV\")","v":"326 x 400 x 216"},null,"mm"]
[{"$f":"Language!D25","v":"Weight"},null,{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,Stoffdaten!U2, \"#NV\")","v":11.5},null,"kg"]
[{"$f":"Language!D24","v":"Standard connections\n(DIN ISO 228 or DIN 2633)"},null,{"$f":"IF('Be-Um-rechnung'!C4<=Stoffdaten!W2,Stoffdaten!V2, \"#NV\")","v":"1/4  \""},null,{"$f":"Language!D29 & \" (1*) \"","v":"Alternatives possible (1*) "}]
[]
[{"$f":"Language!D27","v":"Standard Voltage"},null,"230 VAC, 50-60 Hz",null,{"$f":"Language!D29 & \" (2*) \"","v":"Alternatives possible (2*) "}]
[{"$f":"Language!D28","v":"IP - Protection classification"},null,"IP 65"]
[]
[]
[]
[]
[]
[null,"(1*)",{"$f":"Language!D37 &\" \"& Language!D30","v":"Alternatively ANSI B 1.20.1 (NPT-F). Please consult Parker!"}]
[null,"(2*)",{"$f":"Language!D38&\" \"& Language!D30","v":"Alternatively 115V and 24 VDC. Please consult Parker!"}]

{"sheet":"Stoffdaten","index":3,"n_rows":158,"n_cols":45,"rows_kept":158,"cut":false,"hidden":true,"merged":[[11,2,11,7],[26,0,26,7],[9,2,9,7],[47,26,47,30]]}
[null,null,"W-Verweis",null,"S-Verweis",null,"Korrekturfaktor",null,null,null,null,null,"V in m³/h","TYP K-MT","Düse ohne ZHM","Düse mit ZHM",null,null,null,null,null,null,null,null,null,"mittlerer Luftbedarf Starrrer Zyklus Taupunktabhängig",null,null,null,null,null,"mittlerer Luftbedarf variabler Zyklus"]
[null,null,{"$f":"HLOOKUP('Be-Um-rechnung'!C5,C13:H14,2)","v":3},null,{"$f":"VLOOKUP('Be-Um-rechnung'!C4,Stoffdaten!B15:H25,C2+1)","v":1},null,{"$f":"IF('Be-Um-rechnung'!C6<-41,Stoffdaten!E3*Stoffdaten!A27,Stoffdaten!E3)","v":1},null,null,null,null,null,{"$f":"VLOOKUP(N2,$L$10:N33,2)","v":8.0000000999999994},{"$f":"VLOOKUP('Be-Um-rechnung'!C9,Stoffdaten!$M$9:N33,2)","v":1},{"$f":"VLOOKUP(N2,Stoffdaten!L9:O33,4)","v":0.7},{"$f":"VLOOKUP(N2,Stoffdaten!L9:P33,5)","v":0.7},{"$f":"VLOOKUP(N2,Stoffdaten!L9:Q33,6)","v":1E-3},{"$f":"VLOOKUP(N2,Stoffdaten!L9:R33,7)","v":0.8},{"$f":"VLOOKUP(N2,Stoffdaten!L9:S33,8)","v":1.17},{"$f":"VLOOKUP(N2,Stoffdaten!L9:T33,9)","v":"326 x 400 x 216"},{"$f":"VLOOKUP(N2,Stoffdaten!L9:U33,10)","v":11.5},{"$f":"VLOOKUP(N2,Stoffdaten!L9:V33,11)","v":"1/4  \""},{"$f":"VLOOKUP(N2,Stoffdaten!L9:W33,12)","v":16},null,"für Regeneration &",null,{"$f":"Z48*AA48/AF34+Z54","v":1.1616644738483843},"m³/h",{"$f":"SUM(Z5:AC5)","v":1.1616644738483843},null,"m³/h",{"$f":"AF48*AF35/AF33+AF54","v":1.1404884503425887},"Durchn. Luftbedarf gesammt",null,null,{"$f":"SUM(AG5:AJ5)","v":1.1404884503425887}]
[null,null,null,null,{"$f":"IF(ISNA(E2),0,E2)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Druckaufbau",null,{"$f":"100/'Be-Um-rechnung'!C3*Stoffdaten!AA2","v":14.520805923104804},"%",null,null,"%",{"$f":"100/'Be-Um-rechnung'!C3*Stoffdaten!AF2","v":14.256105629282359},"Durchn. Luftbedarf gesammt"]
[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,"L/sec","m³/min","m³/h","cfm",null,null,null,"L/sec","m³/min","m³/h","cfm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"IF('Be-Um-rechnung'!A29=1,Stoffdaten!AA2*0.27777778,0)","v":0},{"$f":"IF('Be-Um-rechnung'!A29=2,Stoffdaten!AA2*0.0166666667,0)","v":0},{"$f":"IF('Be-Um-rechnung'!A29=3,Stoffdaten!AA2*1,0)","v":1.1616644738483843},{"$f":"IF('Be-Um-rechnung'!A29=4,Stoffdaten!AA2*0.5885778,0)","v":0},null,null,"m³/h",{"$f":"IF('Be-Um-rechnung'!A29=1,Stoffdaten!AF2*0.27777778,0)","v":0},{"$f":"IF('Be-Um-rechnung'!A29=2,Stoffdaten!AF2*0.0166666667,0)","v":0},{"$f":"IF('Be-Um-rechnung'!A29=3,Stoffdaten!AF2*1,0)","v":1.1404884503425887},{"$f":"IF('Be-Um-rechnung'!A29=4,Stoffdaten!AF2*0.5885778,0)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Größe","V_max in m³/h","TYP K-MT","Düse ohne ZHM","Düse mit ZHM","Behälter-volumen m³","Trockenmittel/Behälter MS4A [kg]","Schüttvolumen","Dimensionen\n(AxBxC)\n[mm]","Gewicht\n[kg]","Anschluß","max. Betriebsdruck",null,null,"Berechnung mögliche variable Zeit bei Trocknergrösse 20 für nominale Belastung",null,null,null,null,null,"Berechnung mögliche variable Zeit für minnimale Last"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,1,"---","---",null,null,null,null,null,null,null,null,null,{"$f":"M2*$D$156","v":8.0000000999999994},"Eintritt m³/h",null,null,null,null,{"$f":"'Be-Um-rechnung'!C3","v":8},{"$f":"AA9","v":"Eintritt m³/h"},null,null,null,null,null,null,0,5,null,null,null,4]
[null,null,"Trockner-Eintrittstemperatur in °F",null,null,null,null,null,null,null,null,1,8.0000000999999994,2,0.7,0.7,1E-3,0.8,1.17,"326 x 400 x 216",11.5,"1/4  \"",16,null,null,35,"Eintritt °C",null,null,null,null,{"$f":"'Be-Um-rechnung'!C5","v":35},{"$f":"AA10","v":"Eintritt °C"},null,null,null,null,null,null,40.1,4,null,null,null,3]
["Für einen Drucktaupunkt",null,{"$f":"C13*1.8+32","v":77},86,95,104,113,122,null,null,null,2,15.000000099999999,3,0.9,0.9,2E-3,1.7,2.2000000000000002,"326 x 575 x 216",15.5,"1/4 \"",16,null,null,{"$f":"(273.15+35)/(273.15+20)","v":1.0511683438512707},"v korrektur in Nm³",null,null,null,null,{"$f":"(273.15+AF10)/(273.15+20)","v":1.0511683438512707},"v korrektur in Nm³",null,null,null,null,null,null,45.1,3,null,null,null,2]
["von -25 °C und -40 °C",null,"Trockner-Eintrittstemperatur in °C",null,null,null,null,null,null,null,null,3,25.000000100000001,4,1.1000000000000001,1.1000000000000001,4.0000000000000001E-3,2.7,3.6,"326 x 825 x 216",20,"1/4 \"",16,null,null,{"$f":"Z9*Z11","v":8.4093468559269997},"  Nm³/h",null,null,null,null,{"$f":"AF9*AF11","v":8.4093467508101654},"  Nm³/h",null,null,null,null,null,null,50.1,3,null,null,null,2]
["Mindest-Betriebsdruck",null,25,30,35,40,45,50,null,null,null,4,35.000000100000001,6,1.3,1.3,5.0000000000000001E-3,3.9,5.0999999999999996,"326 x 1075 x 216",25,"1/4 \"",16,null,null,7,"bar (g)",null,null,null,null,{"$f":"'Be-Um-rechnung'!C4","v":7},"bar (g)",null,null,null,null,null,null,60.1,"ERROR",null,null,null,"ERROR"]
["in bar (e) oder (g)",null,1,2,3,4,5,6,null,null,null,6,56.000000100000001,7,1.7,1.7,8.9999999999999993E-3,6.5,8.6,"496 x 1203 x 300",48,"1/2 \"",16,null,null,{"$f":"Z12/(Z13+1)","v":1.051168356990875},"Betriebsvolumen  Nm³ / h",null,null,null,null,{"$f":"AF12/(AF13+1)","v":1.0511683438512707},"Betriebsvolumen  Nm³ / h"]
[null,5,0.8,0.79,0.75,0.64,0.61,0.59,null,null,null,7,72.000000099999994,8,1.9,1.9,1.0999999999999999E-2,8.1999999999999993,10.83,"496 x 1428 x 300",56.5,"1/2 \"",16,null,null,{"$f":"Z14/60","v":1.7519472616514584E-2},"Betriebsvolumen  Nm³ / min",null,null,null,null,{"$f":"AF14/60","v":1.7519472397521177E-2},"Betriebsvolumen  Nm³ / min",null,null,null,null,null,null,{"$f":"AF10","v":35},{"$f":"VLOOKUP(AN15,AN9:AO13,2)","v":5},null,null,null,{"$f":"VLOOKUP(AN15,AN9:AS13,6)","v":4}]
[null,6,0.92,0.91,0.89,0.78,0.73,0.67,null,null,null,8,86.000000099999994,10,2.1,2.1,1.2999999999999999E-2,9.6,12.55,"496 x 1628 x 300",62.5,"3/4 \"",16,null,null,{"$f":"C153","v":39.625629961318261},"Wasserfracht g / Nm³",null,null,null,null,{"$f":"C154","v":39.625629961318261},"Wasserfracht g / Nm³",null,null,null,null,null,null,1,{"$f":"AO15","v":5},null,null,1,{"$f":"AS15","v":4}]
[null,7,1.03,1.02,1,0.91,0.82,0.79,null,null,null,10,105.00000009999999,15,2.2999999999999998,2.5,0.02,13.9,20.170000000000002,"870 x 1420 x 490",120,"1 \"",16,null,null,{"$f":"(Z15*Z16)/1000","v":6.9422013901945508E-4},"kg / min",null,null,null,null,{"$f":"(AF15*AF16)/1000","v":6.9422013034170342E-4},"kg / min",null,null,null,null,null,null,2,3,null,null,2,2]
[null,8,1.1599999999999999,1.1499999999999999,1.1299999999999999,1,0.94,0.86,null,null,null,15,145.00000009999999,20,2.8,3.1,2.5999999999999999E-2,18.3,26.42,"870 x 1750 x 490",142,"1 \"",16,null,null,{"$f":"'Be-Um-rechnung'!C6","v":-40},"Dtp.",null,null,null,null,{"$f":"'Be-Um-rechnung'!C6","v":-40},"Dtp.",null,null,null,null,null,null,3,4,null,null,3,3]
[null,9,1.3,1.28,1.26,1.08,1.03,0.99,null,null,null,20,200.00000009999999,25,3.4,3.4,4.2999999999999997E-2,22.8,33.01,"670 x 1530 x 490",143,"1 \"",16,null,null,{"$f":"IF('Be-Um-rechnung'!C6=-70,Stoffdaten!A32,Stoffdaten!B32)","v":0.45},"Beladungsfaktor",null,null,null,null,{"$f":"Z19","v":0.45},"Beladungsfaktor",null,null,null,null,null,null,4,5,null,null,4,4]
[null,10,1.39,1.37,1.31,1.1599999999999999,1.07,1.03,null,null,null,25,255.00000009999999,35,3.7,3.7,4.3999999999999997E-2,30.3,43.8,"670 x 1760 x 530",173,"1 1/2  \"",16,null,null,{"$f":"(Z17/Z19)*100","v":0.15427114200432335},"kg TroMi erf. / min Ads.-Zeit",null,null,null,null,{"$f":"(AF17/AF19)*100","v":0.15427114007593409},"kg TroMi erf. / min Ads.-Zeit",null,null,null,null,null,null,5,6,null,null,5,5]
[null,11,1.52,1.49,1.36,1.24,1.1000000000000001,1.07,null,null,null,35,350.00000010000002,45,4.0999999999999996,4.5,5.7000000000000002E-2,39.5,57.23,"830 x 1810 x 585",210,"2 1/2  \"",16,null,null,{"$f":"Z20*Z34","v":0.77135571002161674},"kg TroMi erf. / 5 Minuten Zyklus",null,null,null,null,{"$f":"AF20*AF34","v":0.77135570037967049},"kg TroMi erf. / 5 Minuten Zyklus",null,null,null,null,null,null,6,8,null,null,6,6]
[null,12,1.61,1.61,1.49,1.36,1.23,1.18,null,null,null,45,420.00000010000002,60,4.9000000000000004,4.9000000000000004,7.1999999999999995E-2,49.4,71.540000000000006,"860 x 1820 x 605",249,"3 1/2  \"",16,null,null,{"$f":"R2","v":0.8},"Menge Trockenmittel kg",null,null,null,null,{"$f":"R2","v":0.8},"Menge Trockenmittel kg",null,null,null,null,null,null,7,10,null,null,7,7]
[null,13,1.75,1.75,1.62,1.47,1.35,1.29,null,null,null,60,620.00000009999997,75,6,6,0.10199999999999999,69.2,100.15,"910 x 1870 x 635",277,"2 \"",16,null,null,{"$f":"Z21/Z22","v":0.96419463752702084},"Reserve Ausnutzung Trockenmittel",null,null,null,null,{"$f":"(AF21/AF22+1)/2","v":0.98209731273729406},"Reserve Ausnutzung Trockenmittel",null,null,null,null,null,null,8,12,null,null,8,8]
[null,14,1.89,1.89,1.71,1.57,1.46,1.38,null,null,null,75,750.00000009999997,95,6.6,6.6,0.13600000000000001,94.3,136.47,"1020 x 2000 x 640",408,"2 \"",16,null,null,{"$f":"AF24","v":0.98209731273729406},"theor. max. Ausnutzung Trockenmittel bei DTP.-Steuerung",null,null,null,null,{"$f":"AF23","v":0.98209731273729406},"theor. max. Ausnutzung Trockenmittel bei DTP.-Steuerung",null,null,null,null,null,null,9,15,null,null,9,9]
[null,15,2,2,1.79,1.67,1.57,1.46,null,null,null,95,940.00000009999997,120,7.4,7.4,0.17299999999999999,121.7,176.09,"1020 x 2020 x 670",510,"2 1/2  \"",16,null,null,{"$f":"IF(Z24>1,1,Z24)","v":0.98209731273729406},"max. Ausnutzung Trockenmittel bei DTP.-Steuerung",null,null,null,null,{"$f":"Z25","v":0.98209731273729406},"max. Ausnutzung Trockenmittel bei DTP.-Steuerung",null,null,null,null,null,null,10,20,null,null,10,10]
["Für einen Drucktaupunkt von -70 °C (bei max. 35 °C Eintrittstemperatur, 100 % relative Feuchte, gasdichter Verrohrung)",null,null,null,null,null,null,null,null,null,null,120,1200.0000001000001,150,7.8,8.3000000000000007,null,152.6,220.89,"1060 x 2080 x 840",640,"DN 50",10,null,null,0.9,"max. Ausnutzung Trockenmittel bei DTP.-Steuerung",null,null,null,null,{"$f":"Z26","v":0.9},"max. Ausnutzung Trockenmittel bei DTP.-Steuerung",null,null,null,null,null,null,11,25,null,null,11,11]
[0.53,null,null,null,null,null,null,null,null,null,null,150,1550.0000001000001,200,8.9,9.1999999999999993,null,187.9,271.97000000000003,"1270 x 2120 x 900",770,"DN 65",10,null,null,{"$f":"MAX(Z25:Z26)","v":0.98209731273729406},"Ausnutzung Trockenmittel",null,null,null,null,{"$f":"MAX(AF25:AF26)","v":0.98209731273729406},"Ausnutzung Trockenmittel",null,null,null,null,null,null,12,30,null,null,12,12]
[null,null,null,null,null,null,null,null,null,null,null,200,2000.0000001000001,250,"2x7,1","2x7,7",null,264.39999999999998,382.71,"1350 x 2160 x 990",955,"DN 65",10,null,null,{"$f":"Z22*Z27/Z20","v":5.0928374547704918},"theor variable Zeit",null,null,null,null,{"$f":"AF22*AF27/AF20","v":5.0928375184309607},"theor variable Zeit",null,null,null,null,null,null,13,35,null,null,13,13]
[null,null,null,null,null,null,null,null,null,null,null,250,2500.0000000999999,300,"2x8,0","2x8,3",null,309.5,447.97,"1530 x 2210 x 1040",1075,"DN 80",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,40,null,null,14,14]
[null,null,null,null,null,null,null,null,null,null,null,300,3000.0000000999999,380,"2x8,7","2x9,1",null,372.1,538.63,"1600 x 2255 x 1100",1500,"DN 80",10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,45,null,null,15,15]
[null,null,null,null,null,null,null,null,null,null,null,380,3800.0000000999999,500,"2x9,8","2x10,3",null,470.9,681.53,"1875 x 2385 x 1200",1990,"DN 100",10,null,null,"Limit max. Ads. Zyklus",null,null,null,null,null,"Limit max. Ads. Zyklus",null,null,null,null,null,null,null,16,50,null,null,16,16]
[0.30608933999999999,0.45,0.1,null,null,null,null,null,null,null,null,500,4850.0000000999999,600,"2x11,1","2x12",null,640.4,926.96,"1925 x 2660 x 1250",2410,"DN 100",10,null,null,60,"max. Ads. Bei K(E)-MT",null,null,null,null,60,{"$f":"AA32","v":"max. Ads. Bei K(E)-MT"},null,null,null,null,null,null,17,55,null,null,17,17]
[null,"Temp","Wasser",null,null,null,null,null,null,null,null,600,6100.0000000999999,null,"2x12,5","2x13,4",null,800.2,1158.19,"2160 x 2820 x 1565",2850,"DN 125",10,null,null,{"$f":"MIN(Z28,Z32)","v":5.0928374547704918},"max. variabler Ads.Zyklus",null,null,null,null,{"$f":"MIN(AF28,AF32)","v":5.0928375184309607},{"$f":"AA33","v":"max. variabler Ads.Zyklus"},null,null,null,null,null,null,18,60,null,null,18,18]
[null,-90,1E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"standard Ads.-Zyklus",null,null,null,null,{"$f":"AO34","v":5},"standard Ads.-Zyklus",null,null,null,null,null,null,1,{"$f":"VLOOKUP(AN34,AN16:AO33,2)","v":5},null,null,19,19]
[null,-85,2.5000000000000001E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"standard Reg. Zklus",null,null,null,null,{"$f":"AS37","v":4},"standard Reg. Zklus",null,null,null,null,null,null,null,{"$f":"IF(AR37<1,\"ERROR\",AO34)","v":5},null,null,20,20]
[null,-80,5.9999999999999995E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Berechung Reg.-Luftbedarf",null,null,null,null,null,"Berechung Reg.-Luftbedarf",null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(AR36,AR16:AS35,2)","v":4}]
[null,-75,1.2999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",{"$f":"D157","v":13.05},"Reg.-Luft Variabel",null,null,null,null,{"$f":"C158","v":13.05},{"$f":"AA37","v":"Reg.-Luft Variabel"},null,null,null,null,null,null,null,null,null,null,{"$f":"AO34-AS36","v":1},{"$f":"IF(AR37<1,\"ERROR\",AS36)","v":4}]
[null,-70,3.3E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",{"$f":"Z33/Z34*Z37","v":13.292305756950983},"Reg. Luft max. Beladung"]
[null,-65,6.4000000000000003E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z38*Z9/100","v":1.0633844738483844},"mittl. Reg.-Luft (bei nominaler Voll-Beladung)",null,null,null,null,{"$f":"AF37*AF9/100","v":1.044},"mittl. Reg.-Luft Variabel mit ZHM"]
[null,-60,1.0999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF40","v":0},"Aufnahmekapazitätsverhältnis durch andere Drucklufttemp. als 35°C",null,null,null,null,{"$f":"(C156/C153)-1","v":0},{"$f":"AA40","v":"Aufnahmekapazitätsverhältnis durch andere Drucklufttemp. als 35°C"}]
[null,-59,1.2999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Korrekturfaktur Einfluss Drucklufttemp.",null,null,null,null,{"$f":"Z41","v":1},{"$f":"AA41","v":"Korrekturfaktur Einfluss Drucklufttemp."}]
[null,-58,1.4999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+Z40*Z41","v":1},"korr. Aufnahmekapazitätsverhältnis durch andere Drucklufttemp. als 35°C",null,null,null,null,{"$f":"1+AF40*AF41","v":1},"korr. Aufnahmekapazitätsverhältnis durch andere Drucklufttemp. als 35°C"]
[null,-57,1.7000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Z42>C32,Z42,C32)","v":1},"Korrektur Drucklufttemp",null,null,null,null,{"$f":"IF(AF42>C32,AF42,C32)","v":1},"Korrektur Drucklufttemp"]
[null,-56,1.9E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z39/Z43","v":1.0633844738483844},"korrigierter mittl. Reg.-Luft (bei nominaler Voll-Beladung)",null,null,null,null,{"$f":"AF39/AF43","v":1.044},"korrigierter mittl. Reg.-Luft Variabel"]
[null,-55,2.1000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z9*AA45/100","v":0.48000000599999992},6,"% minimum Regeneration",null,null,null,{"$f":"AF9*AG45/100","v":0.48},{"$f":"AA45","v":6},"% minimum Regeneration"]
[null,-54,2.4E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"MAX(Z44:Z45)","v":1.0633844738483844},"korrigierter mittl. Reg.-Luft (bei nominaler Voll-Beladung)"]
[null,-53,2.7E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z46/Z35*Z34","v":1.3292305923104806},"max. Reg.-Luft (by Standard Zyklus-Verhältniss 4/5)",null,null,null,null,{"$f":"MAX(AF44:AF45)","v":1.044},"korrigierter mittl. Reg.-Luft Variabel"]
[null,-52,0.03,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z47*4/AA48","v":1.3292305923104806},{"$f":"AS37","v":4},null,null,null,null,{"$f":"Z48","v":1.3292305923104806},{"$f":"AA48","v":4}]
[null,-51,3.4000000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Druckaufbau",null,null,null,null,null,"Druckaufbau"]
[null,-50,3.7999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³",{"$f":"S2/1000","v":1.17E-3},"Behältervolumen",null,null,null,null,{"$f":"Z50","v":1.17E-3},{"$f":"AA50","v":"Behältervolumen"}]
[null,-49,4.2999999999999997E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Be-Um-rechnung'!C4","v":7},"Betriebsdruck (bar(g))",null,null,null,null,{"$f":"'Be-Um-rechnung'!C4","v":7},{"$f":"AA51","v":"Betriebsdruck (bar(g))"}]
[null,-48,4.8000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³",{"$f":"Z51*Z50","v":8.1899999999999994E-3},"Druckaufbau-Volumen",null,null,null,null,{"$f":"AF51*AF50","v":8.1899999999999994E-3},"Druckaufbau-Volumen"]
[null,-47,5.3999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"60/AO34","v":12},"Anzahl Druckaufbau / Stunde",null,null,null,null,{"$f":"60/AF33","v":11.781251568081686},"Anzahl Druckaufbau / Stunde"]
[null,-46,0.06,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z53*Z52","v":9.8279999999999992E-2},"mittl. Bedarf Druckaufbau",null,null,null,null,{"$f":"AF53*AF52","v":9.6488450342589002E-2},"mittl. Bedarf Druckaufbau"]
[null,-45,6.7000000000000004E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m³/h",{"$f":"Z52*60/AB55","v":0.49139999999999995},"max Bedarf während ",{"$f":"Z34-Z35","v":1},null,null,null,{"$f":"Z55","v":0.49139999999999995},"max Bedarf während 1,00 minutes"]
[null,-44,7.4999999999999997E-2]
[null,-43,8.3000000000000004E-2]
[null,-42,9.2999999999999999E-2]
[null,-41,0.104]
[null,-40,0.11700000000000001]
[null,-39,0.13]
[null,-38,0.14399999999999999]
[null,-37,0.16]
[null,-36,0.17799999999999999]
[null,-35,0.19800000000000001]
[null,-34,0.22]
[null,-33,0.24399999999999999]
[null,-32,0.27100000000000002]
[null,-31,0.30099999999999999]
[null,-30,0.33]
[null,-29,0.37]
[null,-28,0.41]
[null,-27,0.46]
[null,-26,0.51]
[null,-25,0.55000000000000004]
[null,-24,0.6]
[null,-23,0.66]
[null,-22,0.73]
[null,-21,0.8]
[null,-20,0.88]
[null,-19,0.96]
[null,-18,1.05]
[null,-17,1.1499999999999999]
[null,-16,1.27]
[null,-15,1.38]
[null,-14,1.51]
[null,-13,1.65]
[null,-12,1.8]
[null,-11,1.96]
[null,-10,2.1560000000000001]
[null,-9,2.339]
[null,-8,2.5369999999999999]
[null,-7,2.7509999999999999]
[null,-6,2.984]
[null,-5,3.238]
[null,-4,3.5129999999999999]
[null,-3,3.8889999999999998]
[null,-2,4.1349999999999998]
[null,-1,4.4870000000000001]
[null,0,4.8134384736047346]
[null,1,5.1593191530730493]
[null,2,5.5266461407631944]
[null,3,5.9165249186937761]
[null,4,6.3301052620191705]
[null,5,6.7685824153713599]
[null,6,7.233198277792189]
[null,7,7.7252425956090285]
[null,8,8.2460541625951578]
[null,9,8.7970220267445747]
[null,10,9.3795867029812037]
[null,11,9.9952413911120459]
[null,12,10.64553319832557]
[null,13,11.332064365528501]
[null,14,12.056493496806665]
[null,15,12.820536791289692]
[null,16,13.625969276693059]
[null,17,14.474626043807115]
[null,18,15.3684034811976]
[null,19,16.309260509380191]
[null,20,17.299219813728278]
[null,21,18.340369075371786]
[null,22,19.434862199344771]
[null,23,20.584920539238109]
[null,24,21.792834117615804]
[null,25,23.060962841453382]
[null,26,24.391737711860543]
[null,27,25.78766202735213]
[null,28,27.251312579935149]
[null,29,28.785340843284629]
[null,30,30.392474152285487]
[null,31,32.075516873223258]
[null,32,33.837351563913231]
[null,33,35.680940123064403]
[null,34,37.609324928181479]
[null,35,39.625629961318261]
[null,36,41.733061922001752]
[null,37,43.934911326658018]
[null,38,46.23455359387961]
[null,39,48.635450114884989]
[null,40,51.141149308530132]
[null,41,53.755287660246836]
[null,42,56.48159074429033]
[null,43,59.323874228692937]
[null,44,62.286044862334606]
[null,45,65.372101443550477,null,-40,13.05]
[null,46,68.586135769713067,null,-70,17.64]
[null,47,71.932333567237009]
[null,48,75.414975401471466]
[null,49,79.038437565957636]
[null,50,82.807192950543637]
[null,51,86.173000000000002]
[null,{"$f":"'Be-Um-rechnung'!C6","v":-40},{"$f":"VLOOKUP(B152,B34:C151,2)","v":0.11700000000000001}]
[null,35,{"$f":"C135","v":39.625629961318261}]
[null,{"$f":"'Be-Um-rechnung'!C5","v":35},{"$f":"VLOOKUP(B154,B34:C151,2)","v":39.625629961318261}]
[null,null,{"$f":"IF(B154>35,(C154-C153)*0.5,(C154-C153)*0.3)","v":0}]
[null,null,{"$f":"C153+C155","v":39.625629961318261},{"$f":"F145/D157","v":1}]
[null,null,{"$f":"$C$156/(1+'Be-Um-rechnung'!$C$4)/(C153/8)","v":1},{"$f":"IF('Be-Um-rechnung'!C6=-70,Stoffdaten!F146,Stoffdaten!F145)","v":13.05}]
[null,null,{"$f":"$D$157*C157","v":13.05}]

{"sheet":"ArtikelNr.","index":4,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14]
[null,"Trockner-BestellNr.","Trockner-BestellNr.","Blendenkit","Taupunktmessung","Signaldoppler","Reg.Gas-Rückführung","Anfahrvorrichtung","Feinfilterschalldämpfer"]
[{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:G19,1)","v":1},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:G27,2)","v":"K1/16D2-G230M"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:G27,3)","v":"K1/16D2-G230MT"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:G27,4)","v":"VASNOZ/K1-K95"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:G27,5)","v":"VASPDP/K1-K95"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:G27,6)","v":"VASMBS420"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:N27,7)","v":"VASRGR/K1-K8"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:N27,8)","v":"VASVPB/K1-K4/08"},{"$f":"VLOOKUP(Stoffdaten!N2,ArtikelNr.!A4:N27,9)","v":"VASFS3/K1-K4"}]
[1,"K1/16D2-G230M","K1/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K1-K4/08","VASFS3/K1-K4"]
[2,"K2/16D2-G230M","K2/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K1-K4/08","VASFS3/K1-K4"]
[3,"K3/16D2-G230M","K3/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K1-K4/08","VASFS3/K1-K4"]
[4,"K4/16D2-G230M","K4/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K1-K4/08","VASFS3/K1-K4"]
[6,"K6/16D2-G230M","K6/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K6-K7/15","VASFS3/K6-K8"]
[7,"K7/16D2-G230M","K7/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K6-K7/15","VASFS3/K6-K8"]
[8,"K8/16D2-G230M","K8/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K1-K8","VASVPB/K8/20","VASFS3/K6-K8"]
[10,"K10/16D2-G230M","K10/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K10-K20/25","VASFS3/K10-K15"]
[15,"K15/16D2-G230M","K15/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K10-K20/25","VASFS3/K10-K15"]
[20,"K20/16D2-G230M","K20/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K10-K20/25","VASFS3/K20-K25"]
[25,"K25/16D2-G230M","K25/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K25-K45/40","VASFS3/K20-K25"]
[35,"K35/16D2-G230M","K35/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K25-K45/40","VASFS3/K35-K60"]
[45,"K45/16D2-G230M","K45/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K25-K45/40","VASFS3/K35-K60"]
[60,"K60/16D2-G230M","K60/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K60-K75/50","VASFS3/K35-K60"]
[75,"K75/16D2-G230M","K75/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K60-K75/50","VASFS3/K75-K95"]
[95,"K95/16D2-G230M","K95/16D2-G230MT","VASNOZ/K1-K95","VASPDP/K1-K95","VASMBS420","VASRGR/K10-K95","VASVPB/K95/65","VASFS3/K75-K95"]
[120,"K120/10D1-F230M","K120/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[150,"K150/10D1-F230M","K150/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[200,"K200/10D1-F230M","K200/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[250,"K250/10D1-F230M","K250/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[300,"K300/10D1-F230M","K300/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[380,"K380/10D1-F230M","K380/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[500,"K500/10D1-F230M","K500/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]
[600,"K600/10D1-F230M","K600/10D1-F230MT",{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"},{"$f":"Language!D30","v":"Please consult Parker!"}]

{"sheet":"Language","index":5,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"Cover!C2","v":2},"Deutsch","English","Français","Italiano","Español","Polish","…","…","…"]
[null,null,1,"Auswahl",1,2,3,4,5,6,7,8,9]
[null,null,{"$f":"C3+1","v":2},{"$f":"HLOOKUP($D$2,Language!$E$3:M50,C4)","v":"Ambient temperature"},"Umgebungstemperatur","Ambient temperature","Temp Ambiante","Temperatura ambiente","Temperatura ambiente","Temperatura otoczenia"]
[null,null,{"$f":"C4+1","v":3},{"$f":"HLOOKUP($D$2,Language!$E$3:M51,C5)","v":"Compressed air flow rate \nat 20°C and 1 bar a"},"Volumenstrom bezogen \nauf 20°C und 1 bar a","Compressed air flow rate \nat 20°C and 1 bar a","Débit air comprimé \nà 20°C et 1 bar abs","Portata riferita \na 20°C e 1 bar ass.","Caudal de aire comprimido \na 20°C y 1 bar de presión absoluta ","Strumień sprężonego powietrza odniesiony \ndo 20°C i 1 bar a"]
[null,null,{"$f":"C5+1","v":4},{"$f":"HLOOKUP($D$2,Language!$E$3:M52,C6)","v":"Compressor discharge pressure"},"minimaler Betriebsdruck","Compressor discharge pressure","Pression sortie compresseur","Minima pressione di esercizio","Presión de descarga del compresor","Minimalne ciśnienie robocze"]
[null,null,{"$f":"C6+1","v":5},{"$f":"HLOOKUP($D$2,Language!$E$3:M53,C7)","v":"Minimum inlet pressure"},"minimaler Eintrittsdruck","Minimum inlet pressure","Pression entrée mini","Minima pressione in ingresso","Presión mínima de entrada","Minimalne ciśnienie na wlocie"]
[null,null,6,{"$f":"HLOOKUP($D$2,Language!$E$3:M54,C8)","v":"Maximum inlet temperature"},"maximale Eintrittstemperatur","Maximum inlet temperature","T°C entrée maxi","Massima temperatura in ingresso","Temperatura máxima de entrada","Maksymalne ciśnienie na wlocie"]
[null,null,{"$f":"C8+1","v":7},{"$f":"HLOOKUP($D$2,Language!$E$3:M55,C9)","v":"Outlet pressure dewpoint"},"Drucktaupunkt","Outlet pressure dewpoint","PDR sous pression requis","Punto di rugiada in pressione","Salida punto de rocío a presión","Ciśnieniowy punkt rosy"]
[null,null,{"$f":"C9+1","v":8},{"$f":"HLOOKUP($D$2,Language!$E$3:M56,C10)","v":"Out of range! Use 25 - 50°C or 77 - 122°F"},"Außerhalb des Bereiches von 25 - 50°C oder 77 - 122°F ","Out of range! Use 25 - 50°C or 77 - 122°F","Hors Standard ! Choisir dans la plage25 - 50°C ou 77 - 122°F","Fuori range ! Selez. da 25 - 50 °C oppure 77 - 122 °F","Fuera de rango ! Usar 25 - 50°C o 77 - 122 °F","Poza zakresem! Wybierz od 25 do 50°C lub 77 - 122 °F"]
[null,null,{"$f":"C10+1","v":9},{"$f":"HLOOKUP($D$2,Language!$E$3:M57,C11)","v":"Dryer must be sized by Parker!"},"Trockner im Werk anfragen!","Dryer must be sized by Parker!","Le sécheur doit être déterminé par Parker!","Selezione dell'essiccatore a cura Parker!","El secador debe ser dimensionado por Parker!","Osuszacz musi być dobrany fabrycznie!"]
[null,null,10,{"$f":"HLOOKUP($D$2,Language!$E$3:M58,C12)","v":"Language choice"},"Sprachauswahl","Language choice","Choix du langage","Scelta della lingua","Selección de idioma","Wybór języka"]
[null,null,11,{"$f":"HLOOKUP($D$2,Language!$E$3:M59,C13)","v":"Please enter only one pressure value!"},"Bitte nur einen Druckwert eingeben!","Please enter only one pressure value!","Merci de n'entrer qu'une seule valeur de pression","Inserire solo un valore di pressione","Por favor introduzca un único valor de presión","Proszę wprowadzić tylko jedną wartość ciśnienia !"]
[null,null,12,{"$f":"HLOOKUP($D$2,Language!$E$3:M60,C14)","v":"Dryer in accordance with standard specification"},"Trockner in der Standard Ausführung","Dryer in accordance with standard specification","Sécheur conforme aux spécifications standards","Essiccatore in accordo a specifiche standard","Secador conforme a la especificación standard","Osuszacz w standardowym wykonaniu"]
[null,null,13,{"$f":"HLOOKUP($D$2,Language!$E$3:M61,C15)","v":"Dryer choice with input data"},"Trocknerwahl mit Ihren Eingabedaten","Dryer choice with input data","Sélection Sécheur en fonction des données d'entrée","Scelta essiccatore sulla base dei dati cliente","Elección del secador con los datos de entrada","Dobór osuszacza według podanych wartości wejściowych"]
[null,null,14,{"$f":"HLOOKUP($D$2,Language!$E$3:M62,C16)","v":"Standard orifice Ø"},"Ø Blende im Standard","Standard orifice Ø"," Ø orifice standard ","Orifizio calibrato standard","Orificio standard Ø","Otwór standardowy  Ø"]
[null,null,15,{"$f":"HLOOKUP($D$2,Language!$E$3:M63,C17)","v":"Without dew-point dependant-switching \n(fixed cycle)"},"ohne Taupunkt-Steuerung \n(fester Zyklus)","Without dew-point dependant-switching \n(fixed cycle)","Cycles fixes \n(indépendants du PDR)","Senza controllo punto di rugiada \n(cicli fissi)","Sin control por punto de rocío \n(Ciclo fijo)","Bez sterowania zwrotnego \nod punktu rosy"]
[null,null,16,{"$f":"HLOOKUP($D$2,Language!$E$3:M64,C18)","v":"With dew-point dependant-switching \n(variable cycle)"},"mit Taupunkt-Steuerung ZHM 100 \n(variabler Zyklus)","With dew-point dependant-switching \n(variable cycle)","Cycles variables \n(dépendants du PDR)","Con controllo punto di rugiada \n(cicli variabili)","Con control por punto de rocío \n(Ciclo variable)","Ze sterowaniem zwrotnym \nod punktu rosy"]
[null,null,17,{"$f":"HLOOKUP($D$2,Language!$E$3:M65,C19)","v":"Average purge-air consumption"},"Regenerationsluftbedarf im Durchschnitt","Average purge-air consumption","Consommation moyenne d'air de régénération","Consumo medio aria di rigenerazione","Promedio consumo de aire de purga","Średnie zużycie powietrza na regeneracje"]
[null,null,18,{"$f":"HLOOKUP($D$2,Language!$E$3:M66,C20)","v":"Order Number/Catalogue Number"},"Bestellnummer/Katalognummer","Order Number/Catalogue Number","Réf catalogue","Numero ordine/Numero catalogo","Número de pedido/Número de catálogo","Numer zamówieniowy / Numer katalogowy"]
[null,null,19,{"$f":"HLOOKUP($D$2,Language!$E$3:M67,C21)","v":"Average outlet flow rate"},"Austrittsvolumenstrom im Durchschnitt","Average outlet flow rate","Débit moyen UTILE","Portata media in uscita","Caudal medio de salida","Średnia wielkość strumienia na wylocie"]
[null,null,20,{"$f":"HLOOKUP($D$2,Language!$E$3:M68,C22)","v":"Following orifice is recommended"},"Folgende Düse ist empfehlenswert","Following orifice is recommended","L'orifice suivant est recommandé","Orifizio calibrato raccomandato","El siguiente orificio es recomendado","Zaleca się następującą dysze"]
[null,null,21,{"$f":"HLOOKUP($D$2,Language!$E$3:M69,C23)","v":"In addition, please order"},"Bestellen Sie dazu","In addition, please order","Ne pas oublier de commander","Prego ordinare in aggiunta","Además, por favor pedir","Dodatkowo proszę zamówić"]
[null,null,22,{"$f":"HLOOKUP($D$2,Language!$E$3:M70,C24)","v":"Standard connections\n(DIN ISO 228 or DIN 2633)"},"Anschluß im Standard\n(DIN ISO 228 bzw. DIN 2633 (BSP-P))","Standard connections\n(DIN ISO 228 or DIN 2633)","Raccordements standards\n(DIN ISO 228 ou DIN 2633)","Connessione standard\n(DIN ISO 228 o DIN 2633)","Conexiones standard\n(DIN ISO 228 o DIN 2633)","Standardowe przyłącze\n(DIN ISO 228 lub DIN 2633)"]
[null,null,23,{"$f":"HLOOKUP($D$2,Language!$E$3:M71,C25)","v":"Weight"},"Gewicht","Weight","Poids","Peso","Peso","Waga"]
[null,null,24,{"$f":"HLOOKUP($D$2,Language!$E$3:M72,C26)","v":"Dimensions (AxBxC)\n(Width) x (Height) x (Depth)"},"Dimensionen (AxBxC)\n(Breite)x(Höhe)x(Tiefe)","Dimensions (AxBxC)\n(Width) x (Height) x (Depth)","Dimensions (AxBxC)\n(Large) x (Haut) x (Prof)","Dimensioni (AxBxC)\n(Larghezza)x(altezza)x(profondità)","Dimensiones (AxBxC)\n(Ancho) x (altura) x (Profundidad)","Wymiary (AxBxC)\n(szerokość) x (wysokość) x (głębokość)"]
[null,null,25,{"$f":"HLOOKUP($D$2,Language!$E$3:M73,C27)","v":"Standard Voltage"},"Netzspannung im Standard","Standard Voltage","Voltage Standard","Tensione standard","Tensión standard","Standardowe napięcie zasilające"]
[null,null,26,{"$f":"HLOOKUP($D$2,Language!$E$3:M74,C28)","v":"IP - Protection classification"},"Schutzklasse","IP - Protection classification","Classe IP Protection","Classe di protezione IP","Clasificación de la protección IP","Stopień ochrony IP"]
[null,null,27,{"$f":"HLOOKUP($D$2,Language!$E$3:M75,C29)","v":"Alternatives possible"},"Altenativen möglich","Alternatives possible","Variantes possibles","Possibili alternative","Alternativas posibles","Alternatywnie możliwe"]
[null,null,28,{"$f":"HLOOKUP($D$2,Language!$E$3:M76,C30)","v":"Please consult Parker!"},"Im Werk anfragen!","Please consult Parker!","Merci de bien vouloir consulter Parker!","Prego consultare la Parker!","Por favor consultar a Parker!","Prosimy o kontakt z Parkerem!"]
[null,null,29,{"$f":"HLOOKUP($D$2,Language!$E$3:M77,C31)","v":"Out of range! Use 5,5 - 15,5 bar g or 80 - 225 psi g"},"Außerhalb des Bereiches von 5,5 - 15,5 bar g oder 80 - 225 psi g","Out of range! Use 5,5 - 15,5 bar g or 80 - 225 psi g","Hors Standard ! Choisir dans la plage 5,5 - 15,5 bar eff ou 80 - 225 psi g","Fuori range ! Selez. da 5,5 - 15,5 barg oppure 80 - 225 psi g","Fuera de rango! Usar 5,5 - 15,5 barg o 80 - 225 psi g","Poza zakresem! Wybierz  od 5,5 d 15,5 barg lub 80 - 225 psi g"]
[null,null,30,{"$f":"HLOOKUP($D$2,Language!$E$3:M78,C32)","v":"Out of range! Use 1,5 - 50°C or 77 - 122°F"},"Außerhalb des Bereiches von 1,5 - 50°C oder 77 - 122°F","Out of range! Use 1,5 - 50°C or 77 - 122°F","Hors  Standard ! Choisir dans la plage 1,5 - 50°C ou 77 - 122°F","Fuori range ! Selez. da 1,5 - 50 °C oppure 77 - 122 °F","Fuera de rango! Usar  1,5 - 50°C o 77 - 122 °F","Poza zakresem!  \nWybierz od 1,5 do 50°C lub 77 - 122 °F"]
[null,null,31,{"$f":"HLOOKUP($D$2,Language!$E$3:M79,C33)","v":"Out of range! Use 5 - 15 bar g or 73 - 217 psi g"},"Außerhalb des Bereiches von 5 - 15 bar g oder 73 - 217 psi g","Out of range! Use 5 - 15 bar g or 73 - 217 psi g","Hors  Standard ! Choisir dans la plage 5 - 15 bar eff ou 73 - 217 psi g","Fuori range ! Selez. da 5 - 15 barg oppure 73 - 217 psi g","Fuera de rango! Usar 5 - 15 barg o 73 - 217 psi g","Poza zakresem! Wybierz od 5 do 15 bar g lub 73 - 217 psi g"]
[null,null,32,{"$f":"HLOOKUP($D$2,Language!$E$3:M80,C34)","v":"Out of standard range! Check the inputs!"},"Außerhalb des Standards! Eingabewerte kontrollieren!","Out of standard range! Check the inputs!","Hors Standard ! ","Fuori range ! ","Fuera de rango!","Poza zakresem! "]
[null,null,33,{"$f":"HLOOKUP($D$2,Language!$E$3:M81,C35)","v":"Inputs are OK! GO!"},"Eingabewerte sind korrekt! GO!","Inputs are OK! GO!",{"$f":"F35","v":"Inputs are OK! GO!"},{"$f":"F35","v":"Inputs are OK! GO!"},{"$f":"F35","v":"Inputs are OK! GO!"},{"$f":"F35","v":"Inputs are OK! GO!"}]
[null,null,34,{"$f":"HLOOKUP($D$2,Language!$E$3:M82,C36)","v":"Dew point is not garanteed! Please reduce the inlet temperature!"},"Taupunkt kann nicht garantiert werden! Eintrittstemperatur reduzieren!","Dew point is not garanteed! Please reduce the inlet temperature!",{"$f":"F36","v":"Dew point is not garanteed! Please reduce the inlet temperature!"},{"$f":"F36","v":"Dew point is not garanteed! Please reduce the inlet temperature!"},{"$f":"F36","v":"Dew point is not garanteed! Please reduce the inlet temperature!"},{"$f":"F36","v":"Dew point is not garanteed! Please reduce the inlet temperature!"}]
[null,null,35,{"$f":"HLOOKUP($D$2,Language!$E$3:M83,C37)","v":"Alternatively ANSI B 1.20.1 (NPT-F)."},"Auch in ANSI B 1.20.1 (NPT-F) möglich.","Alternatively ANSI B 1.20.1 (NPT-F).",{"$f":"F37","v":"Alternatively ANSI B 1.20.1 (NPT-F)."},{"$f":"F37","v":"Alternatively ANSI B 1.20.1 (NPT-F)."},{"$f":"F37","v":"Alternatively ANSI B 1.20.1 (NPT-F)."},{"$f":"F37","v":"Alternatively ANSI B 1.20.1 (NPT-F)."}]
[null,null,36,{"$f":"HLOOKUP($D$2,Language!$E$3:M84,C38)","v":"Alternatively 115V and 24 VDC."},"Auch mit 115V und 24 V DC möglich.","Alternatively 115V and 24 VDC.",{"$f":"F38","v":"Alternatively 115V and 24 VDC."},{"$f":"F38","v":"Alternatively 115V and 24 VDC."},{"$f":"F38","v":"Alternatively 115V and 24 VDC."},{"$f":"F38","v":"Alternatively 115V and 24 VDC."}]
[null,null,37,{"$f":"HLOOKUP($D$2,Language!$E$3:M85,C39)","v":"cycle  - total"},"Zyklus - Gesamt","cycle  - total",{"$f":"F39","v":"cycle  - total"},{"$f":"F39","v":"cycle  - total"},{"$f":"F39","v":"cycle  - total"},{"$f":"F39","v":"cycle  - total"}]
[null,null,38,{"$f":"HLOOKUP($D$2,Language!$E$3:M86,C40)","v":"adsorption"}," - Adsorption","adsorption","adsorption","adsorption","adsorption","adsorption"]
[null,null,39,{"$f":"HLOOKUP($D$2,Language!$E$3:M87,C41)","v":"regeneration"}," - Regeneration","regeneration","regeneration","regeneration","regeneration","regeneration"]
[null,null,40,{"$f":"HLOOKUP($D$2,Language!$E$3:M88,C42)","v":"pressurization"}," - Druckaufbau","pressurization","pressurization","pressurization","pressurization","pressurization"]
[null,null,41,{"$f":"HLOOKUP($D$2,Language!$E$3:M89,C43)","v":"Standby"}," - Standby","Standby","Standby","Standby","Standby","Standby"]
[null,null,42,{"$f":"HLOOKUP($D$2,Language!$E$3:M90,C44)","v":0}]
[null,null,43,{"$f":"HLOOKUP($D$2,Language!$E$3:M91,C45)","v":0}]
[null,null,44,{"$f":"HLOOKUP($D$2,Language!$E$3:M92,C46)","v":0}]
[null,null,45,{"$f":"HLOOKUP($D$2,Language!$E$3:M93,C47)","v":0}]
[null,null,46,{"$f":"HLOOKUP($D$2,Language!$E$3:M94,C48)","v":0}]
[null,null,47,{"$f":"HLOOKUP($D$2,Language!$E$3:M95,C49)","v":0}]
[null,null,48,{"$f":"HLOOKUP($D$2,Language!$E$3:M96,C50)","v":0}]

{"sheet":"Be-Um-rechnung","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Auslegungsprogramm K-MT 1-8, K-MT 10-95 und K-MT 120-600"]
[]
[{"$f":"Input!A15","v":"Compressed air flow rate \nat 20°C and 1 bar a"},null,{"$f":"H23","v":8},"m³/h"]
[{"$f":"Input!F5","v":"Minimum inlet pressure"},null,{"$f":"F20","v":7},"bar g",null,null,null,null,null,{"$f":"IF(OR(C4<5,C4>15),0,1)","v":1}]
[{"$f":"Input!F25","v":"Maximum inlet temperature"},null,{"$f":"F14","v":35},"°C",null,null,null,null,null,{"$f":"IF(OR(C5<25,C5>50),0,1)","v":1}]
[{"$f":"Input!I25","v":"Outlet pressure dewpoint"},null,{"$f":"IF(L39=-40,-40,-70)","v":-40},"°C"]
["Temperaturdifferenz",null,{"$f":"C5-C6","v":75},"°C",null,null,null,null,null,{"$f":"IF(C7>105,0,1)","v":1}]
["Korrekturfaktor K =",null,{"$f":"Stoffdaten!G2","v":1},"-",null,null,null,null,null,{"$f":"C8","v":1}]
["Volumenstrom V_gerechnet =",null,{"$f":"IF(C8=0,-1,C3/C8)","v":8},"m³/h",null,null,null,null,null,{"$f":"C9","v":8}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J4=1,J5=1,J7=1),SUM(J4:J9),0)","v":12},"0 = not OK",">= 1 = OK"]
["Temperatur",null,"Einheit"]
[1,null,"°C"]
[2,null,"°F"]
[1,{"$f":"Input!F26","v":35},{"$f":"VLOOKUP(A14,A12:C13,3)","v":"°C"},{"$f":"IF(A14=1,Input!F26,((Input!F26-32)*5/9))","v":35},"°C",{"$f":"IF(A14=1,ROUNDUP(Input!F26*2,-1)/2,(ROUNDUP(((Input!F26-32)*5/9)*2,-1)/2))","v":35},"°C"]
[]
[]
["Druck",null,"Einheit"]
[1,null,"bar g"]
[2,null,"psi g"]
[1,{"$f":" Input!F6","v":7},{"$f":"VLOOKUP(A20,A18:C19,3)","v":"bar g"},null,null,{"$f":"IF(A20=1,Input!F6,(Input!F6*0.06894757))","v":7},"bar g"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H25:H28)","v":8}]
["Volumenstrom",null,"Einheit",null,null,{"$f":"E25","v":"L/sec"},{"$f":"E26","v":"m³/min"},{"$f":"E27","v":"m³/h"},{"$f":"E28","v":"cfm"}]
[1,null,"L/sec",null,"L/sec",{"$f":"IF(A29=1,B29,\"0\")","v":"0"},"-",{"$f":"F25*3600/1000","v":0},"-"]
[2,null,"m³/min",null,"m³/min","-",{"$f":"IF(A29=2,B29,\"0\")","v":"0"},{"$f":"G26*60","v":0},"-"]
[3,null,"m³/h",null,"m³/h","-","-",{"$f":"IF(A29=3,B29,\"0\")","v":8},"-"]
[4,null,"cfm",null,"cfm","-","-",{"$f":"I28*60/35.31467","v":0},{"$f":"IF(A29=4,B29,\"0\")","v":"0"}]
[3,{"$f":"Input!A16","v":8},{"$f":"VLOOKUP(A29,A25:C28,3)","v":"m³/h"}]
[]
[]
["DTP",null,"Einheit",null,null,"°C","°C","°C","°C","°C","°C"]
[1,"-20","-20°C",null,"-20°C",{"$f":"IF(A39=1,-40,\"0\")","v":"0"}]
[2,"-40","-40°C",null,"-40°C",null,{"$f":"IF(A39=2,-40,\"0\")","v":-40}]
[3,"-70","-70°C",null,"-70°C",null,null,{"$f":"IF(A39=3,-70,\"0\")","v":"0"}]
[4,"-4","-4°F",null,"-4°F",null,null,null,{"$f":"IF(A39=4,-40,\"0\")","v":"0"}]
[5,"-40","-40°F",null,"-40°F",null,null,null,null,{"$f":"IF(A39=5,-40,\"0\")","v":"0"}]
[6,"-94","-94°F",null,"-94°F",null,null,null,null,null,{"$f":"IF(A39=6,-70,\"0\")","v":"0"}]
[2,{"$f":"VLOOKUP(A39,A33:C38,2)","v":"-40"},{"$f":"VLOOKUP(A39,A33:C38,3)","v":"-40°C"},{"$f":"IF(A39>=4,\"°F\", \"°C\")","v":"°C"},null,{"$f":"SUM(F33:F38)","v":0},-40,0,0,0,0,{"$f":"SUM(F39:K39)","v":-40}]

{"sheet":"Düsen Blendenkit","index":7,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":true,"merged":[[11,0,26,0],[28,0,43,0],[45,0,60,0]]}
[null,"Eintrittstemperatur:","max. 35 °C"]
[null,"Drucktaupunkt:","-40°C"]
[{"$f":"'Be-Um-rechnung'!C5","v":35},{"$f":"IF('Be-Um-rechnung'!C5=35,1,0)","v":1}]
[{"$f":"'Be-Um-rechnung'!C4","v":7},{"$f":"HLOOKUP(A4,C8:G9,2)","v":2}]
["K-MT",{"$f":"Stoffdaten!N2","v":1},{"$f":"VLOOKUP(Stoffdaten!N2,'Düsen Blendenkit'!B12:M27,1)","v":1}]
[]
[null,"gerechnet für ",5,7,10,12,"13,5-15","bar ü"]
[null,"kleinster Druck",0,6,8.1,11,13]
[null,null,1,2,3,4,5]
[null,"Größe","Blende","Blende","Blende","Blende","Blende"]
[null,null,"mm","mm","mm","mm","mm"]
["mit Multitronic",1,0.7,0.7,0.5,0.5,0.5]
[null,2,1.1000000000000001,0.9,0.7,0.7,0.7]
[null,3,1.3,1.1000000000000001,1.1000000000000001,0.9,0.9]
[null,4,1.5,1.3,1.1000000000000001,1.1000000000000001,1.1000000000000001]
[null,6,1.9,1.7,1.5,1.3,1.3]
[null,7,2.1,1.9,1.7,1.5,1.5]
[null,8,2.4,2.1,1.9,1.7,1.7]
[null,10,2.8,2.2999999999999998,2.1,1.9,1.9]
[null,15,3.1,2.8,2.5,2.1,1.9]
[null,20,3.7,3.4,3.1,2.2999999999999998,2.2999999999999998]
[null,25,4.5,3.7,3.4,2.8,2.5]
[null,35,4.9000000000000004,4.0999999999999996,3.7,3.1,2.8]
[null,45,5.4,4.9000000000000004,4.0999999999999996,3.4,3.4]
[null,60,6.6,6,4.9000000000000004,4.0999999999999996,3.7]
[null,75,7.4,6.6,5.4,4.5,4.5]
[null,95,8.5,7.4,6.6,5.4,5.4,{"$f":"VLOOKUP(C5,B12:G27,B4+1)","v":0.7}]
[]
["mit Multitronic + ZHM 100",1,0.7,0.7,0.5,0.5,0.5]
[null,2,1.1000000000000001,0.9,0.7,0.7,0.7]
[null,3,1.3,1.1000000000000001,1.1000000000000001,0.9,0.9]
[null,4,1.5,1.3,1.1000000000000001,1.1000000000000001,1.1000000000000001]
[null,6,1.9,1.7,1.5,1.3,1.3]
[null,7,2.1,1.9,1.7,1.5,1.5]
[null,8,2.4,2.1,1.9,1.7,1.7]
[null,10,3.1,2.5,2.1,2.1,1.9]
[null,15,3.4,3.1,2.8,2.2999999999999998,2.1]
[null,20,3.7,3.4,3.1,2.5,2.5]
[null,25,4.5,3.7,3.4,3.1,2.8]
[null,35,4.9000000000000004,4.5,3.7,3.4,3.1]
[null,45,6,4.9000000000000004,4.0999999999999996,3.7,3.7]
[null,60,6.6,6,4.9000000000000004,4.5,4.0999999999999996]
[null,75,7.4,6.6,5.4,5.4,4.9000000000000004]
[null,95,8.5,7.4,6.6,6,5.4,{"$f":"VLOOKUP(C5,B29:G44,B4+1)","v":0.7}]
[]
["max. Volumenstrom\nm³/h",1,6,8,11,13,"14-16"]
[null,2,11,15,20,24,"27-30"]
[null,3,18,25,34,40,"45-50"]
[null,4,26,35,48,56,"63-70"]
[null,6,42,56,77,90,"101-112"]
[null,7,54,72,99,117,"130-142"]
[null,8,64,86,115,122,"132-148"]
[null,10,78,105,144,170,"190-210"]
[null,15,108,145,195,220,"240-250"]
[null,20,150,200,275,280,"320-340"]
[null,25,191,255,345,370,"410-430"]
[null,35,245,330,445,460,"550-570"]
[null,45,315,420,575,580,"650-680"]
[null,60,465,620,800,840,"900-950"]
[null,75,562,750,1030,1060,"1150-1250"]
[null,95,705,940,1280,1350,"1500-1570",{"$f":"VLOOKUP(C5,B46:G61,B4+1)","v":8}]