{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Gases","Steam or Water","other Liquids"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":10,"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":"Gases","index":0,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This Excel-Sheet is to calculate the SYS-MMF Settings for Gas-Flow only!"]
[null,"Depending if you are using a ISO5167 primary Element or a pitot tube, please use the left or the right Box"]
[null,"Enter your design data in the blue marked fields, the specific seetings for the SYS-MMF can be found on the bottom of the box"]
[]
[]
[null,"Orifice/Venturi/Nozzle",{"$nulls":5},"Pitot tube"]
[null,"C",0.66500000000000004,"[-]",null,null,null,"K",0.56816999999999995,"[-]"]
[null,"D(warm)",205.3,"[mm]",null,null,null,"D(warm)",107.3,"[mm]",{"$nulls":4},"Calculations",null,null,"Calculations"]
[null,"d(warm)",107.55,"[mm]",{"$nulls":10},"A",{"$f":"PI()*(Durchmesser/1000)^2/4","v":9.0847025195136908E-3},"[m²]","A",{"$f":"PI()*(I9/1000)^2/4","v":9.042516820662207E-3},"[m²]"]
[null,"RhoN",0.745,"[kg/Nm³]",null,null,null,"RhoN",1.2928999999999999,"[kg/Nm³]",{"$nulls":4},"beta",{"$f":"Durchmesser/beta","v":0.52386751095957129},"[-]"]
[{"$nulls":14},"K",{"$f":"Durchflusskoeff/(1-P11^4)^0.5","v":0.69155212057536963},"[-]"]
[null,"Prozess Data",{"$nulls":5},"Prozess Data",{"$nulls":6},"q0",{"$f":"P12*P10*C18*SQRT(2*273.15/(101.325*RhoN))*3600*100/C16+10.8240562","v":11.31030063929809},null,"q0",{"$f":"I8*S10*I18*SQRT(2*273.15/(101.325*I11))*3600*100/I16+10.8240562","v":29.708967767350657}]
[null,"Design p",225,"[kPa]",null,null,null,"Design p",100,"[kPa]",{"$nulls":4},"q1",{"$f":"IF(P13>1000,P13/10,IF(P13>10000,P13/100,P13))","v":11.31030063929809},null,"q1",{"$f":"IF(S13>1000,S13/10,IF(S13>10000,S13/100,S13))","v":29.708967767350657}]
[null,"Design T",55,"[°C]",null,null,null,"Design T",20,"[°C]",{"$nulls":4},"Last Bit",{"$f":"IF(P13>1000,1,IF(P13>10000,2,0))","v":0},null,"Last Bit",{"$f":"IF(S13>1000,1,IF(S13>10000,2,0))","v":0}]
[null,"Design Flow",12000,"[Nm³/h]",null,null,null,"Design Flow",200,"[Nm³/h]",{"$nulls":4},"Buildt",{"$f":"TEXT(P14,\"000,00000\")&P15&\"0\"","v":"011,3103000"},null,"Buildt",{"$f":"TEXT(S14,\"000,00000\")&S15&\"0\"","v":"029,7089700"}]
[null,"Design dp",288.5,"[mbar]",null,null,null,"Design dp",14.99,"[mbar]",{"$nulls":4},"Keps",{"$f":"(1-C18)*DesignP/(C17/10)","v":0.31975736568457569},null,"Keps",{"$f":"(1-I18)*I14/(I17/10)","v":0}]
[null,"Design e",0.95899999999999996,"[-]",null,null,null,"Design e",1,"[-]"]
[]
[]
[null,"Settings for SYS MMF",{"$nulls":5},"Settings for SYS MMF"]
[]
[null,"Medium","Gas",{"$nulls":4},"Medium","Gas"]
[null,"Flow Rate",{"$f":"C16","v":12000},{"$f":"D16","v":"[Nm³/h]"},null,null,null,"Flow Rate",{"$f":"I16","v":200},{"$f":"J16","v":"[Nm³/h]"}]
[null,"Flow Coeff",{"$f":"P16","v":"011,3103000"},{"$nulls":4},"Flow Coeff",{"$f":"S16","v":"029,7089700"}]
[null,"KEPS",{"$f":"TEXT(P17,\"000,0000000\")","v":"000,3197574"},{"$nulls":4},"KEPS",{"$f":"TEXT(S17,\"000,0000000\")","v":"000,0000000"}]

{"sheet":"Steam or Water","index":1,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This Excel-Sheet is to calculate the SYS-MMF Settings for Steam or Water -Flow only!"]
[null,"Depending if you are using a ISO5167 primary Element or a pitot tube, please use the left or the right Box"]
[null,"Enter your design data in the blue marked fields, the specific seetings for the SYS-MMF can be found on the bottom of the box"]
[]
[null,"Orifice/Venturi/Nozzle",{"$nulls":5},"Pitot tube"]
[null,"C",0.60182000000000002,"[-]",null,null,null,"K",0.62339,"[-]"]
[null,"D(warm)",500.18,{"$nulls":4},"D(warm)",500.18,"[mm]",{"$nulls":4},"Calculations",null,null,"Calculations"]
[null,"d(warm)",250.09,"[mm]",{"$nulls":10},"A",{"$f":"PI()*(C9/1000)^2/4","v":4.9122734491418518E-2},"[m²]","A",{"$f":"PI()*(I8/1000)^2/4","v":0.19649093796567407},"[m²]"]
[null,"Fluid",{"$nulls":5},"Fluid",{"$nulls":6},"beta",{"$f":"C9/C8","v":0.5},"[-]"]
[{"$nulls":14},"K",{"$f":"C7/(1-P10^4)^0.5","v":0.62155702331054608},"[-]"]
[null,"Prozess Data",{"$nulls":5},"Prozess Data",{"$nulls":6},"Massenfluss",{"$f":"IF(Q23=3,C16*C15,C16)","v":380},"[kg/h]","Massenfluss",{"$f":"IF(Q23=3,I16*I15,I16)","v":380},"[kg/h]"]
[null,"Design p",2700,"[kPa]",null,null,null,"Design p",2700,"[kPa]",{"$nulls":4},"q0",{"$f":"SQRT(2)*P11*C18*P9*3600","v":155.44652262286709},null,"q0",{"$f":"SQRT(2)*I7*I18*S9*3600","v":622.37250321648798}]
[null,"Design T",50,"[°C]",null,null,null,"Design T",50,"[°C]",{"$nulls":4},"q1",{"$f":"IF(P13>1000,P13/10,IF(P13>10000,P13/100,P13))","v":155.44652262286709},null,"q1",{"$f":"IF(S13>1000,S13/10,IF(S13>10000,S13/100,S13))","v":622.37250321648798}]
[null,"Design Desnity",989.17470000000003,"[kg/m³]",null,null,null,"Design Desnity",989.17470000000003,"[kg/m³]",{"$nulls":4},"Last Bit kg",{"$f":"IF(P11>1000,1,IF(P11>10000,2,0))","v":0},null,"Last Bit kg",{"$f":"IF(S11>1000,1,IF(S11>10000,2,0))","v":0}]
[null,"Design Flow",380,{"$f":"IF(Q23=3,\"[m³/h]\",\"[kg/h]\")","v":"[kg/h]"},null,null,null,"Design Flow",380,{"$f":"IF(Q23=3,\"[m³/h]\",\"[kg/h]\")","v":"[kg/h]"},{"$nulls":4},"Last Bit usereinheit",{"$f":"IF(Q23=3,P15,P15)","v":0},null,"Last Bit usereinheit",{"$f":"IF(Q23=3,S15,S15)","v":0}]
[null,"Design dp",59.115000000000002,"[mbar]",null,null,null,"Design dp",3.673,"[mbar]",{"$nulls":4},"Buildt",{"$f":"TEXT(P14,\"000,00000\")&P16&\"0\"","v":"155,4465200"},null,"Buildt",{"$f":"TEXT(S14,\"000,00000\")&S16&\"0\"","v":"622,3725000"}]
[null,"Design e",1,"[-]",null,null,null,"Design e",0.998,"[-]",{"$nulls":4},"Keps",{"$f":"(1-C18)*C13/(C17/10)","v":0},null,"Keps",{"$f":"(1-I18)*I13/(I17/10)","v":14.701878573373277}]
[]
[]
[null,"Settings for SYS MMF",{"$nulls":5},"Settings for SYS MMF"]
[]
[null,"Medium",{"$f":"IF(Q23=1,\"Suph_Steam\",IF(Q23=2,\"Sat_Steam\",\"Water\"))","v":"Suph_Steam"},{"$nulls":4},"Medium",{"$f":"IF(Q23=1,\"Suph_Steam\",IF(Q23=2,\"Sat_Steam\",\"Water\"))","v":"Suph_Steam"},{"$nulls":5},"Superheated Steam",null,1]
[null,"Flow Rate",{"$f":"C16","v":380},{"$f":"D16","v":"[kg/h]"},null,null,null,"Flow Rate",{"$f":"I16","v":380},{"$f":"J16","v":"[kg/h]"},{"$nulls":4},"Saturated Steam"]
[null,"Flow Coeff",{"$f":"P17","v":"155,4465200"},{"$nulls":4},"Flow Coeff",{"$f":"S17","v":"622,3725000"},{"$nulls":5},"Water"]
[null,"KEPS",{"$f":"TEXT(P18,\"000,0000000\")","v":"000,0000000"},{"$nulls":4},"KEPS",{"$f":"TEXT(S18,\"000,0000000\")","v":"014,7018786"}]

{"sheet":"other Liquids","index":2,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This Excel-Sheet is to calculate the SYS-MMF Settings for Liquids-Flow only!"]
[null,"Depending if you are using a ISO5167 primary Element or a pitot tube, please use the left or the right Box"]
[null,"Enter your design data in the blue marked fields, the specific seetings for the SYS-MMF can be found on the bottom of the box"]
[]
[null,"Orifice/Venturi/Nozzle",{"$nulls":5},"Pitot tube"]
[null,"C",0.60182000000000002,"[-]",null,null,null,"K",0.66808999999999996,"[-]"]
[null,"D(warm)",500.18,{"$nulls":4},"D(warm)",500.18,"[mm]",{"$nulls":4},"Calculations",null,null,"Calculations"]
[null,"d(warm)",250.09,"[mm]",{"$nulls":10},"A",{"$f":"PI()*(C9/1000)^2/4","v":4.9122734491418518E-2},"[m²]","A",{"$f":"PI()*(I8/1000)^2/4","v":0.19649093796567407},"[m²]"]
[{"$nulls":14},"beta",{"$f":"C9/C8","v":0.5},"[-]"]
[{"$nulls":14},"K",{"$f":"C7/(1-P10^4)^0.5","v":0.62155702331054608},"[-]"]
[null,"Prozess Data",{"$nulls":5},"Prozess Data",{"$nulls":6},"Massenfluss",{"$f":"C16*C15","v":375886.386},"[kg/h]","Massenfluss",{"$f":"I16*I15","v":375886.386},"[kg/h]"]
[null,"Design p",2700,"[kPa]",null,null,null,"Design p",2700,"[kPa]",{"$nulls":4},"q0",{"$f":"SQRT(2)*P11*P9*3600","v":155.44652262286709},null,"q0",{"$f":"SQRT(2)*I7*S9*3600","v":668.33621633601251}]
[null,"Design T",50,"[°C]",null,null,null,"Design T",50,"[°C]",{"$nulls":4},"q1",{"$f":"IF(P13>1000,P13/10,IF(P13>10000,P13/100,P13))","v":155.44652262286709},null,"q1",{"$f":"IF(S13>1000,S13/10,IF(S13>10000,S13/100,S13))","v":668.33621633601251}]
[null,"Design Desnity",989.17470000000003,"[kg/m³]",null,null,null,"Design Desnity",989.17470000000003,"[kg/m³]",{"$nulls":4},"Last Bit kg",{"$f":"IF(P11>1000,1,IF(P11>10000,2,0))","v":0},null,"Last Bit kg",{"$f":"IF(S11>1000,1,IF(S11>10000,2,0))","v":0}]
[null,"Design Flow",380,{"$f":"IF(Q23=3,\"[m³/h]\",\"[kg/h]\")","v":"[kg/h]"},null,null,null,"Design Flow",380,{"$f":"IF(Q23=3,\"[m³/h]\",\"[kg/h]\")","v":"[kg/h]"},{"$nulls":4},"Last Bit usereinheit",{"$f":"IF(Q23=3,P15,P15)","v":0},null,"Last Bit usereinheit",{"$f":"IF(Q23=3,S15,S15)","v":0}]
[null,"Design dp",59.115000000000002,"[mbar]",null,null,null,"Design dp",3.673,"[mbar]",{"$nulls":4},"Buildt",{"$f":"TEXT(P14,\"000,00000\")&P16&\"0\"","v":"155,4465200"},null,"Buildt",{"$f":"TEXT(S14,\"000,00000\")&S16&\"0\"","v":"668,3362200"}]
[{"$nulls":14},"Keps",0,null,"Keps",0]
[]
[]
[null,"Settings for SYS MMF",{"$nulls":5},"Settings for SYS MMF"]
[]
[null,"Medium","Liquid",{"$nulls":4},"Medium","Liquid"]
[null,"Density",{"$f":"C15","v":989.17470000000003},"[kg/m³]",null,null,null,"Denstity",{"$f":"I15","v":989.17470000000003},"[kg/m³]"]
[null,"Flow Rate",{"$f":"C16","v":380},{"$f":"D16","v":"[kg/h]"},null,null,null,"Flow Rate",{"$f":"I16","v":380},{"$f":"J16","v":"[kg/h]"}]
[null,"Flow Coeff",{"$f":"P17","v":"155,4465200"},"[-]",null,null,null,"Flow Coeff",{"$f":"S17","v":"668,3362200"},"[-]"]