{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Inputs","Output Protocol_D","Output Protocol_E","Berechnung Unsicherheit","P10 Druckverlust"],"not_rendered":{"charts":4,"images":1,"macros":0,"external_links":0,"defined_names":1,"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":"Inputs","index":0,"n_rows":198,"n_cols":25,"rows_kept":198,"cut":false,"hidden":false,"merged":[[36,2,36,4],[18,2,18,4],[20,2,20,4],[13,2,13,4]]}
[null,null,"Inputs"]
[null,null,"deltaflowC2 Selector 3.07"]
[]
[null,null,"Project Details"]
[null,null,"Customer line 1"]
[null,null,"Customer line 2"]
[null,null,"Customer line 3"]
[null,null,"Serial Number"]
[null,null,"Tag Number"]
[null,null,"Comments"]
[{"$nulls":10},"Primärelement",0]
[null,null,"Primary Element",{"$nulls":9},"Nr","ID","id","Beta","C","KEPS","dpLoss Faktor","Comment",0]
[null,null,"Meter Type DFC2-","P10",{"$nulls":7},"P10",1,10000,25,null,null,null,{"$f":"0.623*N109","v":0.20941225440168168},"P10 insertion probe type for pipes >25mm",0]
[null,null,{"$f":"VLOOKUP(D13,L13:T21,9,FALSE)","v":"P10 insertion probe type for pipes >25mm"},{"$nulls":8},"V40(20mm)",{"$f":"M13+1","v":2},35,20,{"$f":"O14/N14","v":0.5714285714285714},0.94199999999999995,780,0.45540000000000003,"R 1 1/2\" male venturi type ID 35x20x35mm",0]
[null,null,"Pipe Inside Diameter",50,"[mm]",{"$nulls":6},"V25(15mm)",{"$f":"M14+1","v":3},25,15,{"$f":"O15/N15","v":0.6},0.98099999999999998,765,0.52800000000000002,"R 1\" male venturi type ID 25x15x25mm",0]
[null,null,"Neck Diameter",22.5,"[mm]",{"$nulls":6},"V20(10mm)",4,15,10,0.66666666666666663,0.94799999999999995,740,0.56100000000000005,"R 3/4\" male venturi type ID 15x10x15mm",0]
[null,null,"Probe Resistance Zeta z",2.8374799999999998,"[-]",{"$nulls":6},"V20(8mm)",5,15,8,0.53333333333333333,0.93899999999999995,631,0.71099999999999997,"R 3/4\" male venturi type ID 15x8x15mm",0]
[null,null,"Flow Coefficient C",0.97397999999999996,"[-]",{"$nulls":6},"V20(6mm)",{"$f":"M17+1","v":6},15,6,0.4,0.92849999999999999,570,0.82699999999999996,"R 3/4\" male venturi type ID 15x6x15mm",0]
[null,null,{"$f":"IF(D15<O22,\"Inside diameter too small, please check\",IF(D15>N22,\"Inside Diameter is big, please check\",\"\"))","v":""},{"$nulls":8},"V20(4mm)",7,15,4,0.26666666666666666,0.9012,581,0.877,"R 3/4\" male venturi type ID 15x4x15mm",0]
[null,null,"ImprooveIT Factor",1,"[-]",{"$nulls":6},"pitot tube",8,10000,1,null,null,null,0,"other pitot tube, design from manufacturer needed",0]
[null,null,{"$f":"IF(D20<>1,\"ImprooveIT is by standard 1,000. This is a overall calibration factor of your meter. Please check if this is correct\",\"\")","v":""},{"$nulls":8},"venturi/orifice",9,10000,1,{"$f":"D16/D15","v":0.45},{"$f":"D18","v":0.97397999999999996},null,0,"other venturi/orifice, design from manufacturer needed",0]
[{"$nulls":10},"Aktuelle Auswahl",{"$f":"VLOOKUP($D13,$L13:$S21,1,FALSE)","v":"P10"},{"$f":"VLOOKUP($D13,$L13:$S21,2,FALSE)","v":1},{"$f":"VLOOKUP($D13,$L13:$S21,3,FALSE)","v":10000},{"$f":"VLOOKUP($D13,$L13:$S21,4,FALSE)","v":25},{"$f":"VLOOKUP($D13,$L13:$S21,5,FALSE)","v":0},{"$f":"VLOOKUP($D13,$L13:$S21,6,FALSE)","v":0},{"$f":"VLOOKUP($D13,$L13:$S21,7,FALSE)","v":0},{"$f":"VLOOKUP($D13,$L13:$S21,8,FALSE)","v":0.20941225440168168}]
[null,null,"Medium","other gas",{"$f":"N44","v":"-"},{"$nulls":5},"Typ",null,{"$f":"IF(M22=1,1,IF(M22=8,1,IF(M22=9,2,3)))","v":1}]
[null,null,"Norm Density",12321,"[kg/Nm³]","0°C, 1013,25 hPa"]
[null,null,"Process Data"]
[null,null,"Design Pressure",100,"[kPa]"]
[null,null,"Design Temperature",19,"[°C]",{"$nulls":5},"Medium",0]
[null,null,"Design Flow",450,"[Nm3/h]@0°C/1013,25mbar",{"$f":"IF(D28>L122,\"Too high\",\"\")","v":"Too high"},{"$nulls":7},"Formel","Molare Masse","Schmelzpunkt","Siedepunkt","Kritische Temperatur","Protoscher drtuck","Azentrischer Faktor","Normdichte","Visk Parameter A","Visk Parameter B","Isentropencoeffizient",0]
[null,null,"Design Expansionnumber",0.95699999999999996,"[-]",{"$nulls":9},"g/mol","°C","°C","°C","bar","[-]","kg/Nm³",0]
[null,null,"Design Differential Pressure",71.052000000000007,{"$f":"E34","v":"[mbar]"},{"$nulls":6},"Air",1,"-",28.96,-200,"-194,35",-141.65,36.6,null,1.2928999999999999,150.30000000000001,123.6,1.4015]
[{"$nulls":11},"other gas",2,"-"]
[{"$nulls":11},"Ammoniak",3,"NH3",17.030999999999999,-77.72,-33.35,132.30000000000001,113,0.25,0.76900000000000002,159.00622598048378,513,1.3030999999999999]
[null,null,"Results",{"$nulls":8},"Argon",4,"Ar",39.948,-189.3,-185.87,-122.43,48.74,1E-4,1.7838000000000001,231.48,228.26,1.6855]
[null,null,"dp Design",71.052000000000007,"[mbar]",{"$nulls":6},"iso-Butane",5,"C4H10",58.12,-159.4,-11.73,134.97999999999999,37.200000000000003,0.183,2.6970000000000001,85.79,299.02,1.0713999999999999]
[null,null,"Expansion Number",0.95699999999999996,"[-]",{"$nulls":6},"Helium",6,"He",4.0026000000000002,-271.14999999999998,-268.93400000000003,-267.95,2.2749999999999999,-0.36499999999999999,0.17849999999999999,136,55,1.6674]
[null,null,"pressure Loss",{"$f":"S22","v":0.20941225440168168},{"$f":"IF(D36=0,\"unknown\",\"\")","v":""},{"$nulls":6},"Carbon Dioxide",7,"CO2",44.01,-56.56,-78.5,31,73.8,0.23899999999999999,1.9769000000000001,165.5,274,1.2898000000000001]
[null,null,{"$f":"IF(L143>20000,\"DesignFlow is too high or wrong p&T! Please select other Type or Diameter\",IF(L143<200,\"DesignFlow is too low, please select other Type or diameter!\",IF(L143<500,\"DesignFlow is low, reduced accuracy!\",\"\")))","v":"DesignFlow is too high or wrong p&T! Please select other Type or Diameter"},{"$nulls":8},"Carbon Monoxide",8,"CO",28.01,-205.1,-191.5,-140.19999999999999,35,6.6000000000000003E-2,1.2504999999999999,86.72,131.74,1.4008]
[{"$nulls":11},"Methane",9,"CH4",16.0426,-182.48,-161.49,-82.1,46.4,1.0999999999999999E-2,0.71799999999999997,88.953000000000003,125,1.306]
[null,null,"Meter options",{"$nulls":8},"Neon",10,"Ne",20.179600000000001,-248.61,-246,-228.7,27.3,null,0.89990000000000003,201,35,1.6677]
[null,null,"I/O Variant","Outputs 4..20mA and 0..10VDC (4 pin M12 Plug)",{"$f":"VLOOKUP(D40,L171:M175,2,FALSE)","v":"IO"},{"$nulls":6},"Propane",11,"C3H8",44.095999999999997,-187.69,-42.04,96.8,42.5,0.153,2.0110000000000001,107,376,1.1193]
[null,null,"Display","integrated display / keypad",{"$f":"VLOOKUP(D41,L177:M178,2,FALSE)","v":"D1"},{"$nulls":6},"Oxygene",12,"O2",31.998799999999999,-218.65,-182.96,-118.57,50.4,null,1.429,174.7,138,1.3692]
[null,null,"Accuracy","High Precision 1% o.S. 1:10 incl 5 point calibration",{"$f":"VLOOKUP(D42,L180:M181,2,FALSE)","v":"DH"},{"$nulls":6},"Nitrogene",13,"N2",28.013000000000002,-209.8,-195.81,-146.85,34,3.9E-2,1.2503,137.80000000000001,103,1.421]
[null,null,"Accessories","none",{"$f":"VLOOKUP(D43,L183:M186,2,FALSE)","v":"-"},{"$nulls":6},"Hydrogene",14,"H2",null,null,null,-239.96,13.15,-0.216,8.9899999999999994E-2,73.569999999999993,122,1.4069]
[null,null,"Typecode",{"$f":"D13&\"-\"&E40&\"-\"&E41&\"-\"&E42&\"-\"&E43","v":"P10-IO-D1-DH--"},{"$nulls":6},"Aktuelle Auswahl",{"$f":"VLOOKUP($D23,$L30:$X43,1,FALSE)","v":"other gas"},{"$f":"VLOOKUP($D23,$L30:$X43,2,FALSE)","v":2},{"$f":"VLOOKUP(D23,L30:X44,3,FALSE)","v":"-"},{"$f":"VLOOKUP($D23,$L30:$X43,4,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,5,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,6,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,7,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,8,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,9,FALSE)","v":0},{"$f":"IF(D23<>\"other gas\",VLOOKUP($D23,$L30:$X43,10,FALSE),D24)","v":12321},{"$f":"VLOOKUP($D23,$L30:$X43,11,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,12,FALSE)","v":0},{"$f":"VLOOKUP($D23,$L30:$X43,13,FALSE)","v":0}]
[{"$nulls":10},"Berechnungen","Dichte bei Designpunkt",null,null,{"$f":"U44*N57/101325*273.15/N66","v":11369.062641208842},"kg/m³"]
[null,null,"Meter Settings",{"$nulls":8},"Dichte bei Auslgungspunkt",null,null,{"$f":"U44*L102/101325*273.15/L103","v":194558.10510732789},"kg/m³"]
[null,null,"Flow Unit / Time Basis",{"$f":"L96","v":"[Nm3/h]@0°C/1013,25mbar"}]
[null,null,"Flowspan",{"$f":"L122","v":26.815766014967785},{"$nulls":6},"Druck",{"$nulls":6},"Differenzdruck",0]
[null,null,"Temp. Unit",{"$f":"E27","v":"[°C]"},{"$nulls":9},"Faktor zu Pa",{"$nulls":6},"Faktor zu Pa",0]
[null,null,"Press. Unit",{"$f":"E26","v":"[kPa]"},{"$nulls":7},"[mbar abs]",1,100,{"$nulls":4},"[mbar]",1,100]
[null,null,"T. type",{"$f":"IF(M22=1,\"Pitot\",IF(M22<8,\"Venturi\",\"PT1000/please check\"))","v":"Pitot"},{"$nulls":7},"[bar abs]",2,100000,{"$nulls":4},"[bar]",2,100000]
[null,null,"dp press. Unit",{"$f":"E34","v":"[mbar]"},{"$nulls":7},"[kPa]",3,1000,{"$nulls":4},"[kPa]",3,1000]
[null,null,"Damping","select [0..99] sek",{"$nulls":7},"[hPa]",4,100,{"$nulls":4},"[hPa]",4,100]
[null,null,"Current Out","select [Flow/dp/p/T]",{"$nulls":7},"[PSI]",5,6894.76,{"$nulls":4},"[PSI]",5,6894.76]
[null,null,"Voltage Out","select [Flow/dp/p/T]",{"$nulls":7},"[Torr]",6,133.322,{"$nulls":4},"[Torr]",6,133.322]
[null,null,"Modbus Brate","select [4800..38400]",{"$nulls":6},"Aktuelle Auswahl",{"$f":"VLOOKUP($E26,$L50:$N55,1,FALSE)","v":"[kPa]"},{"$f":"VLOOKUP($E26,$L50:$N55,2,FALSE)","v":3},{"$f":"VLOOKUP($E26,$L50:$N55,3,FALSE)","v":1000},null,null,null,"Aktuelle Auswahl",{"$f":"VLOOKUP($E34,$S50:$U55,1,FALSE)","v":"[mbar]"},{"$f":"VLOOKUP($E34,$S50:$U55,2,FALSE)","v":1},{"$f":"VLOOKUP($E34,$S50:$U55,3,FALSE)","v":100}]
[null,null,"Pulse Length","select[2, 10, 100] mS",{"$nulls":6},"Berechnungen","Designdruck in Pa",null,{"$f":"D26*N56","v":100000},"Pa",null,null,"Berechnungen","Designdp in Pa",null,{"$f":"D30*U56","v":7105.2000000000007},"Pa",0]
[null,null,"Pulse Count","select [0..9] p/unit"]
[null,null,"0-Suppression","select [0..20%] of Flowspan"]
[null,null,"KEPS",{"$f":"L134","v":2001.4916237567902},{"$nulls":6},"Temperatur",0]
[null,null,"K Analog",{"$f":"K125","v":314042.86550305795},{"$nulls":7},"[°C]",1,0,1]
[{"$nulls":11},"[K]",2,-273.14999999999998,1]
[{"$nulls":11},"[°F]",3,-32,{"$f":"5/9","v":0.55555555555555558}]
[{"$nulls":10},"Aktuelle Auswahl",{"$f":"VLOOKUP($E27,$L61:$O63,1,FALSE)","v":"[°C]"},{"$f":"VLOOKUP($E27,$L61:$O63,2,FALSE)","v":1},{"$f":"VLOOKUP($E27,$L61:$O63,3,FALSE)","v":0},{"$f":"VLOOKUP($E27,$L61:$O63,4,FALSE)","v":1}]
[{"$nulls":10},"Berechnungen","Designtemperatur in °C",null,{"$f":"(D27+N64)*O64","v":19},"°C"]
[{"$nulls":11},"Designtemperatur in K",null,{"$f":"N65+273.15","v":292.14999999999998},"K"]
[]
[{"$nulls":10},"Durchfluss",null,"Nr","ConvFactor","Vol(2) or Mass (1)",0]
[{"$nulls":11},"[kg/s] ",1,1,1]
[{"$nulls":11},"[kg/min]",2,{"$f":"1/60","v":1.6666666666666666E-2},1]
[{"$nulls":11},"[kg/h]",3,{"$f":"1/3600","v":2.7777777777777778E-4},1]
[{"$nulls":11},"[t/s]",4,1000,1]
[{"$nulls":11},"[t/min]",5,{"$f":"N72/60","v":16.666666666666668},1]
[{"$nulls":11},"[t/h]",6,{"$f":"N73/60","v":0.27777777777777779},1]
[{"$nulls":11},"[g/s]",7,1E-3,1]
[{"$nulls":11},"[g/min]",8,{"$f":"N75/60","v":1.6666666666666667E-5},1]
[{"$nulls":11},"[g/h]",9,{"$f":"N76/60","v":2.7777777777777781E-7},1]
[{"$nulls":11},"[Nm3/s]@0°C/1013,25mbar",10,1,1]
[{"$nulls":11},"[Nm3/min]@0°C/1013,25mbar",11,{"$f":"1/60","v":1.6666666666666666E-2},1]
[{"$nulls":11},"[Nm3/h]@0°C/1013,25mbar",12,{"$f":"1/3600","v":2.7777777777777778E-4},1]
[{"$nulls":11},"[Nl/s]@0°C/1013,25mbar",13,{"$f":"N78/1000","v":1E-3},1]
[{"$nulls":11},"[Nl/min]@0°C/1013,25mbar",14,{"$f":"N79/1000","v":1.6666666666666667E-5},1]
[{"$nulls":11},"[Nl/h]@0°C/1013,25mbar",15,2.7777777777777776E-7,1]
[{"$nulls":11},"[cft/s]@process p&T",16,2.83168E-2,2]
[{"$nulls":11},"[cft/min]@process p&T",17,{"$f":"N84/60","v":4.7194666666666664E-4},2]
[{"$nulls":11},"[cft/h]@process p&T",18,{"$f":"N85/60","v":7.8657777777777773E-6},2]
[{"$nulls":11},"[l/s]@process p&T",19,{"$f":"1/1000","v":1E-3},2]
[{"$nulls":11},"[l/min]@process p&T",20,{"$f":"1/60000","v":1.6666666666666667E-5},2]
[{"$nulls":11},"[l/h]@process p&T",21,{"$f":"1/3600000","v":2.7777777777777776E-7},2]
[{"$nulls":11},"[m3/s]@process p&T",22,1,2]
[{"$nulls":11},"[m3/min]@process p&T",23,{"$f":"1/60","v":1.6666666666666666E-2},2]
[{"$nulls":11},"[m3/h]@process p&T",24,{"$f":"1/3600","v":2.7777777777777778E-4},2]
[]
[]
[]
[{"$nulls":10},"Aktuelle Auswahl",{"$f":"VLOOKUP($E28,$L69:$N92,1,FALSE)","v":"[Nm3/h]@0°C/1013,25mbar"},{"$f":"VLOOKUP($E28,$L69:$N92,2,FALSE)","v":12},{"$f":"VLOOKUP($E28,$L69:$N92,3,FALSE)","v":2.7777777777777778E-4},{"$f":"VLOOKUP($E28,$L69:$O92,4,FALSE)","v":1}]
[{"$nulls":10},"Berechnungen","Durchfluss",{"$f":"IF(M96<10,D28*N96,IF(M96<16,D28*N96*U44,D28*O45*N96))","v":1540.125},"[kg/s]"]
[{"$nulls":12},4]
[]
[{"$nulls":10},"Auslegungspunkt DFC2 Elektronik",{"$f":"IF(O$96=1,P100,N100)","v":"Massflow (1)"},null,"VolFlow (2)",null,"Massflow (1)"]
[{"$nulls":10},"dp",{"$f":"IF(O$96=1,P101,N101)","v":20000},"Pa",20000,"Pa",20000]
[{"$nulls":10},"pabs",1600000,"Pa",100000,"Pa",1600000]
[{"$nulls":10},"T",273.14999999999998,"K",273.14999999999998,"K",273.14999999999998]
[{"$nulls":10},"KEPS",0,"[-]",0,"[-]",0]
[{"$nulls":10},"FLOWMAX [Digitalwert]",18714,"[-]",11249,"[-]",18714]
[]
[]
[{"$nulls":10},"Berechnungen Sonden",{"$nulls":10},"Epsilon Auslegung","dp design (Epsiolon 1) Pa","Epsilon Design","dploss"]
[{"$nulls":10},"P10",null,"Blockage",{"$f":"IF(D15<30,(24*15)/(D15^2*PI()/4),((30*12)+(D15-30)*15)/(D15^2*PI()/4))","v":0.33613523981008298},"Kwert",{"$f":"7.4939*N109^4 - 6.262*N109^3 + 0.6605*N109^2 - 0.1878*N109 + 0.6605","v":0.52984533463259775},"Zeta",{"$f":"1/P109^2","v":3.562064430311755},"KEPS",{"$f":"IF(U109>0,U109,2000-U109)","v":2001.4916237567902},{"$f":"1141.5*N109 - 385.19","v":-1.4916237567902613},{"$f":"1-U109*(L101/L102)*16000/4096^2","v":1.0000177815408324},{"$f":"M97^2*R109*8/PI()^2/(D15/1000)^4/O45","v":96382741.849014744},{"$f":"1-U109*(W109/N57)*16000/4096^2","v":2.3710669277818042}]
[{"$nulls":10},"Andere Sonden",null,null,null,"Kwert",{"$f":"1/D17^0.5","v":0.59365426937284804},"Zeta",{"$f":"D17","v":2.8374799999999998},"KEPS",{"$f":"(1-D29)*N57/U57*4096^2/16000","v":634.58830152564371},null,{"$f":"1-T110*(L101/L102)*16000/4096^2","v":0.99243511794178907},{"$f":"D$30*1000*D$29^2","v":65072.90314799999},{"$f":"D29","v":0.95699999999999996}]
[{"$nulls":10},"Andere Venturi/Blende",{"$nulls":7},"KEPS",{"$f":"(1-D29)*N57/U57*4096^2/16000","v":634.58830152564371},null,{"$f":"1-T111*(L101/L102)*16000/4096^2","v":0.99243511794178907},{"$f":"D$30*1000*D$29^2","v":65072.90314799999},{"$f":"D29","v":0.95699999999999996}]
[{"$nulls":10},"V20-V40",{"$nulls":7},"KEPS",{"$f":"R22","v":0},null,{"$f":"1-T112*(L101/L102)*16000/4096^2","v":1},{"$f":"M97^2*(1-P22^4)*8/Q22^2/PI()^2/(O22/1000)^4/O45","v":{"$error":"#DIV/0!"}},{"$f":"1-T112*(W112/N57)*16000/4096^2","v":{"$error":"#DIV/0!"}}]
[]
[]
[{"$nulls":10},"Berechnung FlowSpan","(Epsilon =1, gem HA)"]
[{"$nulls":13},"Usereinheit"]
[{"$nulls":10},"P10",{"$f":"1/R109^0.5*PI()*(D15/1000)^2/4*1*(2*L101*O46)^0.5","v":91.776959186227245},"kg/s",{"$f":"IF(M$96<10,L117/N$96,IF(M$96<16,L117/N$96/U$44,L117/N$96/O46))","v":26.815766014967785},{"$f":"L$96","v":"[Nm3/h]@0°C/1013,25mbar"}]
[{"$nulls":10},"Andere Sonde",{"$f":"1/R110^0.5*PI()*(D15/1000)^2/4*1*(2*L101*O46)^0.5","v":102.82959967693451},"kg/s",{"$f":"IF(M$96<10,L118/N$96,IF(M$96<16,L118/N$96/U$44,L118/N$96/O46))","v":30.045171563750042},{"$f":"L$96","v":"[Nm3/h]@0°C/1013,25mbar"}]
[{"$nulls":10},"Andere Venturi",{"$f":"D18/(1-(D16/D15)^4)*PI()*(D16/1000)^2/4*1*(2*L101*O46)^0.5","v":35.624094930168468},"kg/s",{"$f":"IF(M$96<10,L119/N$96,IF(M$96<16,L119/N$96/U$44,L119/N$96/O46))","v":10.408793259362591},"[Nm3/h]@0°C/1013,25mbar"]
[{"$nulls":10},"V20-V40",{"$f":"Q22/(1-P22^4)^0.5*PI()*(O22/1000)^2/4*1*(2*L101*O46)^0.5","v":0},"kg/s",{"$f":"IF(M$96<10,L120/N$96,IF(M$96<16,L120/N$96/U$44,L120/N$96/O46))","v":0},"[Nm3/h]@0°C/1013,25mbar"]
[]
[{"$nulls":10},"FlowSpan",{"$f":"IF(M22=1,N117*D20,IF(M22=8,N118,IF(M22=9,N119*D20,N120*D20)))","v":26.815766014967785},{"$f":"L96","v":"[Nm3/h]@0°C/1013,25mbar"}]
[]
[{"$nulls":10},"Berechnung K Analog",{"$f":"1/R109^0.5*PI()*(D15/1000)^2/4/N$96","v":3.7452559743463389},"K,Value"]
[{"$nulls":10},{"$f":"L105*D28/D48","v":314042.86550305795}]
[]
[{"$nulls":10},"Berechnung KEPS"]
[]
[{"$nulls":10},"P10",{"$f":"T109","v":2001.4916237567902}]
[{"$nulls":10},"Andere Sonde",{"$f":"(1-D$29)*N$57*4096^2/16000/U$57","v":634.5883015256436}]
[{"$nulls":10},"Andere Venturi",{"$f":"(1-D$29)*N$57*4096^2/16000/U$57","v":634.5883015256436}]
[{"$nulls":10},"V20-V40",{"$f":"(1-V$112)*L$102*4096^2/16000/L$101","v":0}]
[]
[{"$nulls":10},"KEPS",{"$f":"IF(M22=1,L129,IF(M22=8,L130,IF(M22=9,L131,L132)))","v":2001.4916237567902}]
[]
[{"$nulls":10},"Berechnung dp Design"]
[{"$nulls":11},"dp[Pa]","dp[Usereinheit]",null,"Expansionszahl "]
[{"$nulls":10},"P10",{"$f":"M97^2*R109*8/PI()^2/(D15/1000)^4/O45/D20^2/X109^2","v":17143979.980377719},{"$f":"L138/U$56","v":171439.79980377719},{"$f":"E30","v":"[mbar]"},{"$f":"X109","v":2.3710669277818042}]
[{"$nulls":10},"Andere Sonden",{"$f":"M97^2*R110*8/PI()^2/(D15/1000)^4/O45/D20^2/X110^2","v":83831346.062062666},{"$f":"L139/U$56","v":838313.46062062669},{"$f":"N138","v":"[mbar]"},{"$f":"X110","v":0.95699999999999996}]
[{"$nulls":10},"Andere Venturi/Blende",{"$f":"M97^2*(1-(D16/D15)^4)*8/D18^2/PI()^2/(D16/1000)^4/D20^2/O45/X111^2","v":728348573.71329856},{"$f":"L140/U$56","v":7283485.7371329851},{"$f":"N139","v":"[mbar]"},{"$f":"X111","v":0.95699999999999996}]
[{"$nulls":10},"V20-V40",{"$f":"M97^2*(1-P22^4)*8/Q22^2/PI()^2/(O22/1000)^4/O45/X112^2/D20^2","v":{"$error":"#DIV/0!"}},{"$f":"L141/U$56","v":{"$error":"#DIV/0!"}},{"$f":"N140","v":"[mbar]"},{"$f":"X112","v":{"$error":"#DIV/0!"}}]
[]
[{"$nulls":10},"dp",{"$f":"IF($M22=1,L138,IF($M22=8,L139,IF($M22=9,L140,L141)))","v":17143979.980377719},{"$f":"IF($M22=1,M138,IF($M22=8,M139,IF($M22=9,M140,M141)))","v":171439.79980377719},{"$f":"IF($M22=1,N138,IF($M22=8,N139,IF($M22=9,N140,N141)))","v":"[mbar]"},{"$f":"IF($M22=1,O138,IF($M22=8,O139,IF($M22=9,O140,O141)))","v":2.3710669277818042}]
[]
[]
[{"$nulls":10},"Berechnung Unsicherheit"]
[]
[{"$nulls":10},{"$f":"\"Flow \"&E28","v":"Flow [Nm3/h]@0°C/1013,25mbar"},"dp [Pa]","dp Fehler Nach Nullpunktabgleich","Fehler durch dp","Fehler durch Dichte und Primärelement mit Klaib","Unsicherheit abs mit Kalbirierung","Unicherheit r.M. mit Kalibrierung","dp Fehler ohne Kalibroierung","Fehler durch dp","Unsicherheit Abs ohne Kalibrierung","Unsicherheit d.M. ohne Kalibrierung"]
[{"$nulls":10},{"$f":"D28","v":450},{"$f":"L143","v":17143979.980377719},{"$f":"L149*0.005+10","v":85729.899901888595},{"$f":"(1+M149/L149)^0.5-1","v":2.4971737092969182E-3},2.5000000000000001E-3,{"$f":"O149+N149","v":4.9971737092969187E-3},{"$f":"P149*K149/K$149","v":4.9971737092969178E-3},{"$f":"L149*0.01+30","v":171469.79980377719},{"$f":"(1+R149/L149)^0.5-1","v":4.9884327122300398E-3},{"$f":"S149+0.02","v":2.498843271223004E-2},{"$f":"T149*K149/K$149","v":2.498843271223004E-2}]
[{"$nulls":10},{"$f":"K149-(0.05*K$149)","v":427.5},{"$f":"L$149*(K150/K$149)^2","v":15472441.932290891},{"$f":"L150*0.005+10","v":77372.209661454457},{"$f":"(1+M150/L150)^0.5-1","v":2.4972051384439808E-3},2.5000000000000001E-3,{"$f":"O150+N150","v":4.9972051384439813E-3},{"$f":"P150*K150/K$149","v":4.7473448815217823E-3},154754.41932290891,4.9885267659397492E-3,{"$f":"S150+0.02","v":2.498852676593975E-2},{"$f":"T150*K150/K$149","v":2.3739100427642761E-2}]
[{"$nulls":10},{"$f":"K150-(0.05*K$149)","v":405},{"$f":"L$149*(K151/K$149)^2","v":13886623.784105953},69443.118920529771,2.497241950042639E-3,2.5000000000000001E-3,4.9972419500426395E-3,4.4975177550383759E-3,138896.23784105954,4.9886369269687147E-3,2.4988636926968715E-2,2.2489773234271846E-2]
[{"$nulls":10},382.5,12386525.5358229,61942.627679114499,2.4972854471463357E-3,2.5000000000000001E-3,4.9972854471463362E-3,4.2476926300743859E-3,123895.255358229,4.9887670947827978E-3,2.4988767094782798E-2,2.1240452030565377E-2]
[{"$nulls":10},360,10972147.187441742,54870.735937208708,2.4973373523931031E-3,2.5000000000000001E-3,4.9973373523931035E-3,3.9978698819144827E-3,109751.47187441742,4.988922424477904E-3,2.4988922424477904E-2,1.9991137939582321E-2]
[{"$nulls":10},337.5,9643488.7389624678,48227.44369481234,2.4973999812252234E-3,2.5000000000000001E-3,4.9973999812252239E-3,3.7480499859189179E-3,96464.887389624681,4.9891098451515514E-3,2.4989109845151552E-2,1.8741832383863663E-2]
[{"$nulls":10},315,8400550.1903850809,42012.750951925402,2.4974765046648084E-3,2.5000000000000001E-3,4.9974765046648089E-3,3.4982335532653661E-3,84035.501903850804,4.9893388462696198E-3,2.498933884626962E-2,1.7492537192388732E-2]
[{"$nulls":10},292.5,7243331.541709587,36226.657708547937,2.4975713587465087E-3,2.5000000000000001E-3,4.9975713587465092E-3,3.248421383185231E-3,72463.315417095873,4.9896227029186946E-3,2.4989622702918695E-2,1.6243254756897151E-2]
[{"$nulls":10},270,6171832.7929359786,30869.163964679894,2.4976909022009774E-3,2.5000000000000001E-3,4.9976909022009779E-3,2.9986145413205866E-3,61748.327929359788,4.9899804439519357E-3,2.4989980443951936E-2,1.4993988266371163E-2]
[{"$nulls":10},247.5,5186053.9440642605,25940.269720321303,2.4978445105792169E-3,2.5000000000000001E-3,4.9978445105792173E-3,2.7488144808185695E-3,51890.539440642606,4.9904401262097497E-3,2.499044012620975E-2,1.3744742069415361E-2]
[{"$nulls":10},225,4285994.9950944297,21439.974975472149,2.4980464721677809E-3,2.5000000000000001E-3,4.9980464721677813E-3,2.4990232360838902E-3,42889.949950944298,4.9910445081278176E-3,2.4991044508127818E-2,1.2495522254063909E-2]
[{"$nulls":10},202.5,3471655.9460264882,17368.279730132443,2.498319434885099E-3,2.5000000000000001E-3,4.9983194348850995E-3,2.2492437456982949E-3,34746.559460264885,4.991861364710859E-3,2.4991861364710859E-2,1.1246337614119886E-2]
[{"$nulls":10},180,2743036.7968604355,13725.183984302177,2.4987010438222157E-3,2.5000000000000001E-3,4.9987010438222162E-3,1.9994804175288866E-3,27460.367968604354,4.9930033505971583E-3,2.4993003350597159E-2,9.9972013402388621E-3]
[{"$nulls":10},157.5,2100137.5475962702,10510.68773798135,2.4992576520359577E-3,2.5000000000000001E-3,4.9992576520359582E-3,1.7497401782125854E-3,21031.375475962701,4.9946690299651486E-3,2.4994669029965149E-2,8.748134160487803E-3]
[{"$nulls":10},135,1542958.1982339947,7724.7909911699735,2.5001152403822946E-3,2.5000000000000001E-3,5.0001152403822951E-3,1.5000345721146884E-3,15459.581982339947,4.9972354046248224E-3,2.4997235404624823E-2,7.499170621387447E-3]
[{"$nulls":10},112.5,1071498.7487736074,5367.4937438680372,2.5015375160533093E-3,2.5000000000000001E-3,5.0015375160533098E-3,1.2503843790133272E-3,10744.987487736074,5.0014916238443341E-3,2.5001491623844335E-2,6.2503729059610836E-3]
[{"$nulls":10},90,685759.19921510888,3438.7959960755443,2.504155790989282E-3,2.5000000000000001E-3,5.0041557909892825E-3,1.0008311581978565E-3,6887.5919921510886,5.0093268893642851E-3,2.5009326889364285E-2,5.0018653778728566E-3]
[{"$nulls":10},67.5,385739.54955849866,1938.6977477924934,2.509812534480238E-3,2.5000000000000001E-3,5.0098125344802385E-3,7.5147188017203571E-4,3887.3954955849867,5.0262547236046284E-3,2.5026254723604629E-2,3.7539382085406943E-3]
[{"$nulls":10},45,171439.79980377722,867.19899901888607,2.5259744828645125E-3,2.5000000000000001E-3,5.025974482864513E-3,5.0259744828645128E-4,1744.3979980377721,5.0746183933065847E-3,2.5074618393306585E-2,2.5074618393306583E-3]
[{"$nulls":10},22.5,42859.949950944305,224.29974975472152,2.6132445022197803E-3,2.5000000000000001E-3,5.1132445022197808E-3,2.5566222511098902E-4,458.59949950944304,5.335742005527333E-3,2.5335742005527333E-2,1.2667871002763665E-3]
[]
[]
[{"$nulls":10},"IO","Outputs 4..20mA and 0..10VDC (4 pin M12 Plug)","IO"]
[{"$nulls":10},"CAN","Can-Bus Version (VS, GND, CANHI, CANLO) (4 pin M12 Plug)","CAN"]
[{"$nulls":10},"MOD","MOD-Bus Version (VS, GND, A, B) (4 pin M12 Plug)","MOD"]
[{"$nulls":10},"IO-MOD","Outputs 4..20mA,  0..10VDC, Pulses, MOD-Bus (8 pin M12 Plug)","IO-MOD"]
[{"$nulls":10},"IO-CAN","Outputs 4..20mA,  0..10VDC, Pulses, CAN-Bus (8 pin M12 Plug)","IO-CAN"]
[]
[{"$nulls":10},"D0","no Display (settings by systec) o.R.","D0"]
[{"$nulls":10},"D1","integrated display / keypad","D1"]
[]
[{"$nulls":10},"DS","Standard 3% o.S. 1:5  ","DS"]
[{"$nulls":10},"DH","High Precision 1% o.S. 1:10 incl 5 point calibration","DH"]
[]
[{"$nulls":11},"none","-"]
[{"$nulls":10},"RSXX","Hot Tap Accessorie for pipe dimesnions 45..335mm","RSXX"]
[{"$nulls":10},"M12-4","M12 cable 1,5m 4pin","M12-4"]
[{"$nulls":10},"M12-8","M12 cable 1,5m 8pin","M12-8"]
[]
[]
[]
[{"$nulls":10},"PinBelegung",null,"IO","CAN","MOD","IO-MOD","IO-CAN"]
[{"$nulls":10},{"$f":"_xlfn.XLOOKUP(E$40,M$190:Q$190,M191:Q191)","v":"(brown) GND"},1,"(brown) GND","(brown) GND","(brown) GND","(white) GND","(white) GND"]
[{"$nulls":10},"(white) 4..20mA",2,"(white) 4..20mA","(white) CAN hi","(white) Modbus A","(brown) 4..20mA","(brown) 4..20mA"]
[{"$nulls":10},"(blue) Supply",3,"(blue) Supply","(blue) Supply","(blue) Supply","(green) Supply","(green) Supply"]
[{"$nulls":10},"(black) 0..10VDC",4,"(black) 0..10VDC","(black) CAN low","Modbus B","(yellow) 0..10VDC","(yellow) 0..10VDC"]
[{"$nulls":10},"n.a.",5,"n.a.","n.a.","n.a.","(grey) Pulse +","(grey) Pulse +"]
[{"$nulls":10},"n.a.",6,"n.a.","n.a.","n.a.","(pink) Pulse -","(pink) Pulse -"]
[{"$nulls":10},"n.a.",7,"n.a.","n.a.","n.a.","(blue) Modbus A","(blue) CAN hi"]
[{"$nulls":10},"n.a.",8,"n.a.","n.a.","n.a.","(red) Modbus B","(red) CAN low"]

{"sheet":"Output Protocol_D","index":1,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,5,2,6],[3,7,3,9],[4,7,4,8],[53,1,53,9],[11,3,12,9]]}
[]
[]
[null,"DFC2 Protokoll",null,null,null,{"$f":"TODAY()","v":"2025-12-12"}]
[null,null,"Grundtyp","Ausgänge","Display","Genauigkeit","Zubehör","thyssenkrupp Steel Europe AG\n22363-02\nDFC224260033"]
[null,"DFC2 ",{"$f":"Inputs!D13","v":"P10"},{"$f":"Inputs!E40","v":"IO"},{"$f":"Inputs!E41","v":"D1"},{"$f":"Inputs!E42","v":"DH"},{"$f":"Inputs!E43","v":"-"},"Min recommended diameter is 25mm, please use Venturi"]
[null,"Gastyp",{"$f":"Inputs!D23","v":"other gas"},{"$f":"Inputs!E23","v":"-"},null,{"$f":"Inputs!D24","v":12321},{"$f":"Inputs!E24","v":"[kg/Nm³]"},{"$f":"Inputs!F24","v":"0°C, 1013,25 hPa"}]
[null,"Prozess Druck",null,null,{"$f":"Inputs!D26","v":100},{"$f":"Inputs!E26","v":"[kPa]"},null,"Pipe ID",{"$f":"Inputs!D15","v":50},{"$f":"Inputs!E15","v":"[mm]"}]
[null,"Prozess Temperatur",null,null,{"$f":"Inputs!D27","v":19},{"$f":"Inputs!E27","v":"[°C]"}]
[null,"Prozess max Durchfluss",null,null,{"$f":"Inputs!D28","v":450},{"$f":"Inputs!E28","v":"[Nm3/h]@0°C/1013,25mbar"}]
[null,"ImprooveIT",null,null,{"$f":"Inputs!D20","v":1},"[-]"]
[]
[null,"Ergebnisse Auslegung",null,{"$f":"CELL(\"dateiname\")","v":"C:\\Users\\OliverB\\Desktop\\[deltaflowC2-SelectorV3_08.xlsx]Inputs"}]
[]
[{"$nulls":8},"Pin","IO"]
[null,"Max möglicher Durchfluss [MF]",null,null,{"$f":"Inputs!L122","v":26.815766014967785},{"$f":"F9","v":"[Nm3/h]@0°C/1013,25mbar"},null,null,1,{"$f":"Inputs!K191","v":"(brown) GND"}]
[null,"Design Durchfluss [DF]",null,null,{"$f":"E9","v":450},{"$f":"F15","v":"[Nm3/h]@0°C/1013,25mbar"},null,null,2,{"$f":"Inputs!K192","v":"(white) 4..20mA"}]
[null,"Design Druck",null,null,{"$f":"E7","v":100},"bar abs",null,null,3,{"$f":"Inputs!K193","v":"(blue) Supply"}]
[null,"Design Temperatur",null,null,{"$f":"E8","v":19},"°C",null,null,4,{"$f":"Inputs!K194","v":"(black) 0..10VDC"}]
[null,"Design Dichte",null,null,{"$f":"Inputs!O45","v":11369.062641208842},"kg/m³",null,null,5,{"$f":"Inputs!K195","v":"n.a."}]
[null,"dp am Designpunkt",null,null,{"$f":"Inputs!D34","v":71.052000000000007},{"$f":"Inputs!D52","v":"[mbar]"},null,null,6,{"$f":"Inputs!K196","v":"n.a."}]
[null,"Druckverlust am Auslgungspunkt",null,null,{"$f":"IF(E20*Inputs!D36>0,E20*Inputs!D36,\"-\")","v":14.879159499748289},{"$f":"F20","v":"[mbar]"},null,null,7,{"$f":"Inputs!K197","v":"n.a."}]
[null,"Epsilon am Designpunkt",null,null,{"$f":"Inputs!D35","v":0.95699999999999996},"[-]",null,null,8,{"$f":"Inputs!K198","v":"n.a."}]
[null,{"$f":"Inputs!C37","v":"DesignFlow is too high or wrong p&T! Please select other Type or Diameter"}]
[null,"Geräteeinstellungen (Option D1)"]
[null,{"$f":"Inputs!C47","v":"Flow Unit / Time Basis"},{"$f":"Inputs!D47","v":"[Nm3/h]@0°C/1013,25mbar"},null,{"$f":"Inputs!C53","v":"Damping"},null,{"$f":"Inputs!D53","v":"select [0..99] sek"},null,{"$f":"Inputs!C59","v":"0-Suppression"},"select [0..20%] o.S."]
[null,{"$f":"Inputs!C48","v":"Flowspan"},{"$f":"Inputs!D48","v":26.815766014967785},{"$f":"C25","v":"[Nm3/h]@0°C/1013,25mbar"},{"$f":"Inputs!C54","v":"Current Out"},null,{"$f":"Inputs!D54","v":"select [Flow/dp/p/T]"},null,{"$f":"Inputs!C60","v":"KEPS"},{"$f":"Inputs!D60","v":2001.4916237567902}]
[null,{"$f":"Inputs!C49","v":"Temp. Unit"},{"$f":"Inputs!D49","v":"[°C]"},null,{"$f":"Inputs!C55","v":"Voltage Out"},null,{"$f":"Inputs!D55","v":"select [Flow/dp/p/T]"},null,{"$f":"Inputs!C61","v":"K Analog"},{"$f":"Inputs!D61","v":314042.86550305795}]
[null,{"$f":"Inputs!C50","v":"Press. Unit"},{"$f":"Inputs!D50","v":"[kPa]"},null,{"$f":"Inputs!C56","v":"Modbus Brate"},null,{"$f":"Inputs!D56","v":"select [4800..38400]"}]
[null,{"$f":"Inputs!C51","v":"T. type"},{"$f":"Inputs!D51","v":"Pitot"},null,{"$f":"Inputs!C57","v":"Pulse Length"},null,{"$f":"Inputs!D57","v":"select[2, 10, 100] mS"}]
[null,{"$f":"Inputs!C52","v":"dp press. Unit"},{"$f":"Inputs!D52","v":"[mbar]"},null,{"$f":"Inputs!C58","v":"Pulse Count"},null,{"$f":"Inputs!D58","v":"select [0..9] p/unit"},null,null,false]
[]
[null,"Unsicherheiten (typisch)"]
{"$rows_empty":18}
[null,"* Nach Installation und im geeigneten Wartungsintervall ist ein Nullpunktabgleich durchzuführen ",{"$nulls":7},"V3.07 29.07.2024"]
[]
[null,"© systec  Controls Mess- und Regeltechnik GmbH, Lindberghstraße 4, 82178 Puchheim, Germany"]
[null,"www.systec-controls.de - Fon: +49-(0)89-809060 - Fax: +49-(0)89-80906-200 - Email: info@systec-controls.de"]

{"sheet":"Output Protocol_E","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,1,53,9],[2,1,2,4],[2,5,2,6],[3,7,3,9],[4,7,4,8],[11,3,12,9]]}
[]
[]
[null,"DFC2 Protocoll",null,null,null,{"$f":"TODAY()","v":"2025-12-12"}]
[null,null,"Basic Type","I/O_Variant","Display","Accuracy","Accessories","Test"]
[null,"DFC2 ",{"$f":"Inputs!D13","v":"P10"},{"$f":"Inputs!E40","v":"IO"},{"$f":"Inputs!E41","v":"D1"},{"$f":"Inputs!E42","v":"DH"},{"$f":"Inputs!E43","v":"-"},"Min recommended diameter is 25mm, please use Venturi"]
[null,"Gas type",{"$f":"Inputs!D23","v":"other gas"},{"$f":"Inputs!E23","v":"-"},null,{"$f":"Inputs!D24","v":12321},{"$f":"Inputs!E24","v":"[kg/Nm³]"},{"$f":"Inputs!F24","v":"0°C, 1013,25 hPa"}]
[null,"Process Pressure",null,null,{"$f":"Inputs!D26","v":100},{"$f":"Inputs!E26","v":"[kPa]"},null,{"$f":"'Output Protocol_D'!H7","v":"Pipe ID"},{"$f":"'Output Protocol_D'!I7","v":50},{"$f":"'Output Protocol_D'!J7","v":"[mm]"}]
[null,"Process Temperature",null,null,{"$f":"Inputs!D27","v":19},{"$f":"Inputs!E27","v":"[°C]"}]
[null,"Process max flow",null,null,{"$f":"Inputs!D28","v":450},{"$f":"Inputs!E28","v":"[Nm3/h]@0°C/1013,25mbar"}]
[null,"ImprooveIT",null,null,{"$f":"Inputs!D20","v":1},"[-]"]
[]
[null,"Calculated Results",null,{"$f":"CELL(\"dateiname\")","v":"C:\\Users\\OliverB\\Desktop\\[deltaflowC2-SelectorV3_08.xlsx]Inputs"}]
[]
[{"$nulls":8},"Pin","IO"]
[null,"Maximum Flow [MF]",null,null,{"$f":"Inputs!L122","v":26.815766014967785},{"$f":"F9","v":"[Nm3/h]@0°C/1013,25mbar"},null,null,1,{"$f":"Inputs!K191","v":"(brown) GND"}]
[null,"Design Flow [DF]",null,null,{"$f":"E9","v":450},{"$f":"F15","v":"[Nm3/h]@0°C/1013,25mbar"},null,null,2,{"$f":"Inputs!K192","v":"(white) 4..20mA"}]
[null,"Design Pressure",null,null,{"$f":"E7","v":100},"bar abs",null,null,3,{"$f":"Inputs!K193","v":"(blue) Supply"}]
[null,"Design Temperature",null,null,{"$f":"E8","v":19},"°C",null,null,4,{"$f":"Inputs!K194","v":"(black) 0..10VDC"}]
[null,"Design Density",null,null,{"$f":"Inputs!O45","v":11369.062641208842},"kg/m³",null,null,5,{"$f":"Inputs!K195","v":"n.a."}]
[null,"dp at Operational Flow",null,null,{"$f":"Inputs!D34","v":71.052000000000007},{"$f":"Inputs!D52","v":"[mbar]"},null,null,6,{"$f":"Inputs!K196","v":"n.a."}]
[null,"presser loss at maxflow",null,null,{"$f":"IF(E20*Inputs!D36>0,E20*Inputs!D36,\"-\")","v":14.879159499748289},{"$f":"F20","v":"[mbar]"},null,null,7,{"$f":"Inputs!K197","v":"n.a."}]
[null,"Epsilon Expansionnumber",null,null,{"$f":"Inputs!D35","v":0.95699999999999996},"[-]",null,null,8,{"$f":"Inputs!K198","v":"n.a."}]
[null,{"$f":"Inputs!C37","v":"DesignFlow is too high or wrong p&T! Please select other Type or Diameter"}]
[null,"Display Settings (Option D1)"]
[null,{"$f":"Inputs!C47","v":"Flow Unit / Time Basis"},{"$f":"Inputs!D47","v":"[Nm3/h]@0°C/1013,25mbar"},null,{"$f":"Inputs!C53","v":"Damping"},null,{"$f":"Inputs!D53","v":"select [0..99] sek"},null,{"$f":"Inputs!C59","v":"0-Suppression"},"select [0..20%] o.S."]
[null,{"$f":"Inputs!C48","v":"Flowspan"},{"$f":"Inputs!D48","v":26.815766014967785},{"$f":"C25","v":"[Nm3/h]@0°C/1013,25mbar"},{"$f":"Inputs!C54","v":"Current Out"},null,{"$f":"Inputs!D54","v":"select [Flow/dp/p/T]"},null,{"$f":"Inputs!C60","v":"KEPS"},{"$f":"Inputs!D60","v":2001.4916237567902}]
[null,{"$f":"Inputs!C49","v":"Temp. Unit"},{"$f":"Inputs!D49","v":"[°C]"},null,{"$f":"Inputs!C55","v":"Voltage Out"},null,{"$f":"Inputs!D55","v":"select [Flow/dp/p/T]"},null,{"$f":"Inputs!C61","v":"K Analog"},{"$f":"Inputs!D61","v":314042.86550305795}]
[null,{"$f":"Inputs!C50","v":"Press. Unit"},{"$f":"Inputs!D50","v":"[kPa]"},null,{"$f":"Inputs!C56","v":"Modbus Brate"},null,{"$f":"Inputs!D56","v":"select [4800..38400]"}]
[null,{"$f":"Inputs!C51","v":"T. type"},{"$f":"Inputs!D51","v":"Pitot"},null,{"$f":"Inputs!C57","v":"Pulse Length"},null,{"$f":"Inputs!D57","v":"select[2, 10, 100] mS"}]
[null,{"$f":"Inputs!C52","v":"dp press. Unit"},{"$f":"Inputs!D52","v":"[mbar]"},null,{"$f":"Inputs!C58","v":"Pulse Count"},null,{"$f":"Inputs!D58","v":"select [0..9] p/unit"},null,null,false]
[]
[null,"Uncertaincy (typical)"]
{"$rows_empty":18}
[null,"* Please proceed zero offset after installation and in an adequate service intaervall ",{"$nulls":7},{"$f":"'Output Protocol_D'!J51","v":"V3.07 29.07.2024"}]
[]
[null,"© systec  Controls Mess- und Regeltechnik GmbH, Lindberghstraße 4, 82178 Puchheim, Germany"]
[null,"www.systec-controls.de - Fon: +49-(0)89-809060 - Fax: +49-(0)89-80906-200 - Email: info@systec-controls.de"]

{"sheet":"Berechnung Unsicherheit","index":3,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Berechnung Unsicherheit"]
[]
[null,"Messbereich max",null,{"$f":"Inputs!D48","v":26.815766014967785},{"$f":"Inputs!D47","v":"[Nm3/h]@0°C/1013,25mbar"}]
[null,"Messbereich kunde",null,{"$f":"Inputs!D28","v":450},{"$f":"Inputs!E28","v":"[Nm3/h]@0°C/1013,25mbar"},{"$f":"IF(D5>0.25*D4,D5,0.25*D4)","v":450}]
[null,"dp Kunde",null,{"$f":"'Output Protocol_E'!$E$20","v":71.052000000000007},{"$f":"Inputs!E34","v":"[mbar]"}]
[null,"p Design",null,{"$f":"Inputs!N57/100000","v":1},"[bara]"]
[null,"T Design",null,{"$f":"Inputs!N66","v":292.14999999999998},"[K]"]
[null,"dp Nullpunkt",null,0.1,"[mbar]"]
[]
[null,{"$f":"\"Flow \"&E5","v":"Flow [Nm3/h]@0°C/1013,25mbar"},"dp [mbar]","Uncertaincy o.V. Std","Uncertaincy o.S. Std","Uvertainca o.V. HP",null,null,"Unsicherhiet dp d.M.","Unsicherheit Dichte","Uncertaincy absolute","Uncertaincy o.S. [DF]","Uncertaincy o.S. [MF]"]
[null,{"$f":"D5","v":450},{"$f":"(B12/D$5)^2*D$6","v":71.052000000000007},{"$f":"0.03*F$5/B12","v":0.03},null,{"$f":"D12/2","v":1.4999999999999999E-2},null,null,{"$f":"(1+(D$9+0.01*C12)/C12)^0.5-1","v":5.6875359264461078E-3},{"$f":"((1+0.015/D7)*(1+1/D8))^0.5-1","v":9.1948487202819784E-3},{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I12^2+J12^2)^0.5,(I12^2+J12^2)^0.5+0.02)","v":1.0811720857638081E-2},{"$f":"K12*B12/D$5","v":1.0811720857638079E-2},{"$f":"I12*B12/D$4","v":9.5443522496137925E-2}]
[null,{"$f":"B12-0.05*D$5","v":427.5},{"$f":"(B13/D$5)^2*D$6","v":64.124430000000004},3.1578947368421054E-2,null,1.5789473684210527E-2,null,null,{"$f":"(1+(D$9+0.01*C13)/C13)^0.5-1","v":5.7631272088729535E-3},{"$f":"J12","v":9.1948487202819784E-3},{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I13^2+J13^2)^0.5,(I13^2+J13^2)^0.5+0.02)","v":1.0851676285925732E-2},{"$f":"K13*B13/D$5","v":1.0309092471629446E-2},{"$f":"I13*B13/D$4","v":9.1876431216546303E-2}]
[null,{"$f":"B13-0.05*D$5","v":405},57.552120000000009,3.3333333333333333E-2,null,1.6666666666666666E-2,null,null,5.8516567834854261E-3,{"$f":"J13","v":9.1948487202819784E-3},{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I14^2+J14^2)^0.5,(I14^2+J14^2)^0.5+0.02)","v":1.089895087155558E-2},9.8090557844000212E-3,8.8377896644413437E-2]
[null,382.5,51.335070000000002,3.5294117647058823E-2,null,1.7647058823529412E-2,null,null,5.9562545386391275E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I15^2+J15^2)^0.5,(I15^2+J15^2)^0.5+0.02)","v":1.0955464897389355E-2},9.3121451627809528E-3,8.4959995539855296E-2]
[null,360,45.47328000000001,3.7499999999999999E-2,null,1.8749999999999999E-2,null,null,6.081057182557803E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I16^2+J16^2)^0.5,(I16^2+J16^2)^0.5+0.02)","v":1.1023815103965096E-2},8.8190520831720777E-3,8.163781651804658E-2]
[null,337.5,39.966750000000005,0.04,null,0.02,null,null,6.2316233620758332E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I17^2+J17^2)^0.5,(I17^2+J17^2)^0.5+0.02)","v":1.1107581767227306E-2},8.3306863254204791E-3,7.8430460779179798E-2]
[null,315,34.815480000000001,4.2857142857142858E-2,null,2.1428571428571429E-2,null,null,6.4155630486564252E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I18^2+J18^2)^0.5,(I18^2+J18^2)^0.5+0.02)","v":1.1211810389948488E-2},7.8482672729639422E-3,7.5362469943941371E-2]
[null,292.5,30.019470000000005,4.6153846153846156E-2,null,2.3076923076923078E-2,null,null,6.6435175389014667E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I19^2+J19^2)^0.5,(I19^2+J19^2)^0.5+0.02)","v":1.1343789855183431E-2},7.37346340586923E-3,7.2465909757865016E-2]
[null,270,25.578720000000001,0.05,null,2.5000000000000001E-2,null,null,6.930732360317382E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I20^2+J20^2)^0.5,(I20^2+J20^2)^0.5+0.02)","v":1.151435165518327E-2},6.9086109931099622E-3,6.9783489915640998E-2]
[null,247.5,21.493230000000004,5.4545454545454543E-2,null,2.7272727272727271E-2,null,null,7.2996713130903945E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I21^2+J21^2)^0.5,(I21^2+J21^2)^0.5+0.02)","v":1.1740121135151289E-2},6.4570666243332093E-3,6.7373374640181546E-2]
[null,225,17.763000000000002,0.06,null,0.03,null,null,7.784540301758458E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I22^2+J22^2)^0.5,(I22^2+J22^2)^0.5+0.02)","v":1.2047585264216759E-2},6.0237926321083796E-3,6.5316857512778284E-2]
[null,202.5,14.388030000000002,6.6666666666666666E-2,null,3.3333333333333333E-2,null,null,8.4394983420321701E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I23^2+J23^2)^0.5,(I23^2+J23^2)^0.5+0.02)","v":1.2480800264968384E-2},5.6163601192357731E-3,6.3731105548415101E-2]
[null,180,11.368320000000002,7.4999999999999997E-2,null,3.7499999999999999E-2,null,null,9.3544345205462953E-3,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I24^2+J24^2)^0.5,(I24^2+J24^2)^0.5+0.02)","v":1.3116809375303864E-2},5.2467237501215456E-3,6.2791352399125408E-2]
[null,157.5,8.7038700000000002,8.5714285714285715E-2,null,4.2857142857142858E-2,null,null,1.0687460190427434E-2,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I25^2+J25^2)^0.5,(I25^2+J25^2)^0.5+0.02)","v":1.4098476808181879E-2},4.9344668828636574E-3,6.2771840232077103E-2]
[null,135,6.3946800000000001,0.1,null,0.05,null,null,1.2737872841112274E-2,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I26^2+J26^2)^0.5,(I26^2+J26^2)^0.5+0.02)","v":1.5709826463243214E-2},4.7129479389729648E-3,6.4126933110555895E-2]
[null,112.5,4.4407500000000004,0.12,null,0.06,null,null,1.6129282466019079E-2,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I27^2+J27^2)^0.5,(I27^2+J27^2)^0.5+0.02)","v":1.8566071093731751E-2},4.641517773432937E-3,6.7667068560126914E-2]
[null,90,2.8420800000000006,0.15,null,7.4999999999999997E-2,null,null,2.234314099776058E-2,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I28^2+J28^2)^0.5,(I28^2+J28^2)^0.5+0.02)","v":2.4161150482431101E-2},4.8322300964862199E-3,7.4988821452127666E-2]
[null,67.5,1.59867,0.2,null,0.1,null,null,3.5640862629011671E-2,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I29^2+J29^2)^0.5,(I29^2+J29^2)^0.5+0.02)","v":3.680782976390963E-2},5.5211744645864442E-3,8.9714320527538277E-2]
[null,45,0.71052000000000015,0.3,null,0.15,null,null,7.2726429142429438E-2,9.1948487202819784E-3,{"$f":"IF('Output Protocol_E'!F$5=\"DH\",(I30^2+J30^2)^0.5,(I30^2+J30^2)^0.5+0.02)","v":7.3305380012640822E-2},7.3305380012640827E-3,0.12204347657205109]
[null,22.5,0.17763000000000004,0.6,null,0.3,null,null,0.25418019722951724,9.1948487202819784E-3,{"$f":"(I31^2+J31^2)^0.5","v":0.25434645251433163},1.2717322625716581E-2,0.21327208905656198]

{"sheet":"P10 Druckverlust","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ID[mm]","Blockage","ploss[%]DF12","Ploss DFC"]
[null,25,{"$f":"IF(B3<30,(24*15)/(B3^2*PI()/4),((30*12)+(B3-30)*15)/(B3^2*PI()/4))","v":0.73338597776745373},32,{"$f":"D3*0.015","v":0.48}]
[null,30,{"$f":"IF(B4<30,(24*15)/(B4^2*PI()/4),((30*12)+(B4-30)*15)/(B4^2*PI()/4))","v":0.50929581789406508},21.1,{"$f":"D4*0.015","v":0.3165}]
[null,35,0.45212996078350676,18.399999999999999,0.27599999999999997]
[null,40,0.40584510488433312,16.3,0.2445]
[null,50,0.33613523981008298,13.4,0.20099999999999998]
[null,60,0.28647889756541162,11.4,0.17099999999999999]
[null,70,0.24945101284607271,10,0.15]
[null,80,0.22082748354000478,8.9,0.13350000000000001]
[null,100,0.17952677580765794,7.4,0.111]
[null,150,0.12223099629457561,{"$f":"D11/B12*B$11","v":4.9333333333333336},7.3999999999999996E-2]
[null,200,9.262817687948309E-2,{"$f":"D12/B13*B$11","v":2.4666666666666668},3.6999999999999998E-2]
[null,500,3.7738820105950227E-2,{"$f":"D13/B14*B$11","v":0.4933333333333334},7.4000000000000003E-3]
[null,5000,3.8151349718444421E-3,{"$f":"D14/B15*B$11","v":9.8666666666666677E-3},1.4800000000000002E-4]