{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["IN Data","Feed Sep D601 without pumping","Feed Sep D601 with pumping","Thermosyphon Sep D602","AUX"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":111,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"IN Data","index":0,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"CD_QD_TD","CP_QN_TX","CP_QX_TN","CR_QN_TX","CR_QX_TN"]
["Feed","Vap Frac",null,0.224556927113544,0.23876808787940401,0.26079295284016601,0.13470489549685299,0.139033216573973]
[null,"Temp","°C",-178.898225660457,-180.819345440738,-180.01180105695201,-173.886128578376,-173.960948106476]
[null,"Press","barA",1.23,1.23,1.23,1.23,1.23]
[null,"mol Flow","Nm3/h",768.86405197661304,504.78779095950802,921.06951742784997,385.25386842597101,761.6938795694]
[]
[null,"Compo","CH4",0.70094897842137405,0.66297519606133504,0.651582825767132,0.83118869906750203,0.82297184577748494]
[null,null,"CO2",0,0,0,0,0]
[null,null,"N2",0.282184436708108,0.32103348356449102,0.320119110650879,0.16350671178984599,0.16425332938434101]
[null,null,"O2",1.51302751046889E-2,1.45633726891409E-2,2.6213400212814101E-2,5.3045891426514698E-3,1.27748248381743E-2]
[null,null,"Ar",1.7363097658288299E-3,1.4279476850330901E-3,2.08466336917436E-3,0,0]
[]
["From Condenser","Vap Frac",null,{"$f":"(D16-16.5335144275013)/D16","v":0.86181776429020895},{"$f":"(E16-16.1906039903492)/E16","v":0.80883684488936813},{"$f":"(F16-16.5075163195236)/F16","v":0.89060434454454518},{"$f":"(G16-16.9121496594592)/G16","v":0.70427038193717684},{"$f":"(H16-17.1474678468341)/H16","v":0.85659309140288542}]
[null,"Temp","°C",-171.228500687245,-174.001758633534,-172.49538709411399,-166.204984108839,-166.03081145115701]
[null,"Press","barA",1.2250000000000001,1.2250000000000001,1.2250000000000001,1.2250000000000001,1.2250000000000001]
[null,"mol Flow","Nm3/h",119.650071824173,84.695212217957007,150.89736654345799,57.187879152051899,119.57211834896999]
[]
[null,"Compo","CH4",0.31919550550918402,0.23410292537260199,0.27438885180116102,0.53460006465271503,0.54050957774558495]
[null,null,"CO2",0,0,0,0,0]
[null,null,"N2",0.60323898561987999,0.68798007151895402,0.606020538786186,0.436854601798293,0.399394193949274]
[null,null,"O2",7.0543921327748699E-2,7.1952437112991097E-2,0.111937123538233,2.8545333548991601E-2,6.0096228305140699E-2]
[null,null,"Ar",7.0215875431878603E-3,5.9645659954525301E-3,7.6534858744201802E-3,0,0]
[]
["To Reboiler","Vap Frac",null,0,0,0,0,0]
[null,"Temp","°C",-158.810040885772,-158.81023677828199,-158.810437256857,-158.80905543166801,-158.80951416046801]
[null,"Press","barA",1.25,1.25,1.25,1.25,1.25]
[null,"mol Flow","Nm3/h",647.00190053124504,419.26852755226003,734.51358615892798,365.31657032234398,707.39017421852202]
[]
[null,"Compo","CH4",0.999878987594089,0.99987642081034001,0.99987380691998595,0.99989148427114605,0.99988556642100701]
[null,null,"CO2",0,0,0,0,0]
[null,null,"N2",8.7192184223539496E-10,8.7549430404612902E-10,5.0810895757545704E-10,2.0909841439527901E-9,8.2924358855701298E-10]
[null,null,"O2",1.20371411924097E-4,1.2306150528517499E-4,1.2575987995313599E-4,1.08513637870027E-4,1.14432749749717E-4]
[null,null,"Ar",6.4012206448488E-7,5.1680888001394999E-7,4.32691952253807E-7,0,0]
[]
[]
["D-601 Feed","Vap Frac",null,{"$f":"(D2*D5+D13*D16)/D38","v":0.31037245091495996},{"$f":"(E2*E5+E13*E16)/E38","v":0.32067391738344903},{"$f":"(F2*F5+F13*F16)/F38","v":0.34944949797071956},{"$f":"(G2*G5+G13*G16)/G38","v":0.20832417393527591},{"$f":"(H2*H5+H13*H16)/H38","v":0.23639332632310953}]
[null,"Press","barA",{"$f":"D4","v":1.23},{"$f":"E4","v":1.23},{"$f":"F4","v":1.23},{"$f":"G4","v":1.23},{"$f":"H4","v":1.23}]
[null,"mol Flow","Nm3/h",{"$f":"D16+D5","v":888.51412380078602},{"$f":"E16+E5","v":589.48300317746498},{"$f":"F16+F5","v":1071.9668839713079},{"$f":"G16+G5","v":442.4417475780229},{"$f":"H16+H5","v":881.26599791836998}]
[]
[null,"Compo","CH4",{"$f":"(D$5*D7+D$16*D18)/D$38","v":0.64954086995183191},0.60135606915761319,0.59848643053459971,0.79285308748556416,0.7846467409600888]
[null,null,"CO2",0,0,0,0,0]
[null,null,"N2",0.32541863952803279,0.37375530755591524,0.36036454476056395,0.19883833722041133,0.19615776159079232]
[null,null,"O2",2.2592448831614358E-2,2.2808867409375797E-2,3.8280455915303456E-2,8.3085752940241439E-3,1.9195497449119154E-2]
[null,null,"Ar",2.44804168852081E-3,2.0797558770958751E-3,2.8685687895325029E-3,0,0]
[]
["D-601 Feed (with pumping)","Vap Frac",null,{"$f":"(D2*D5+D13*D16+D24*$K$46*D27)/D48","v":0.24036148237872521},{"$f":"(E2*E5+E13*E16+E24*$K$46*E27)/E48","v":0.24964899226835061},{"$f":"(F2*F5+F13*F16+F24*$K$46*F27)/F48","v":0.27427579574484634},{"$f":"(G2*G5+G13*G16+G24*$K$46*G27)/G48","v":0.15660255525614955},{"$f":"(H2*H5+H13*H16+H24*$K$46*H27)/H48","v":0.17893957383216322},null,"Pump flow ratio",0.4]
[null,"Press","barA",{"$f":"D4","v":1.23},{"$f":"E4","v":1.23},{"$f":"F4","v":1.23},{"$f":"G4","v":1.23},{"$f":"H4","v":1.23}]
[null,"mol Flow","Nm3/h",{"$f":"D5+D16+$K$46*D27","v":1147.314884013284},{"$f":"E5+E16+$K$46*E27","v":757.19041419836901},{"$f":"F5+F16+$K$46*F27","v":1365.772318434879},{"$f":"G5+G16+$K$46*G27","v":588.56837570696052},{"$f":"H5+H16+$K$46*H27","v":1164.2220676057789}]
[]
[null,"Compo","CH4",{"$f":"(D$5*D7+D$16*D18+$K$46*D$27*D29)/D$48","v":0.72856692673937895},0.68962292404850145,0.68483302792518397,0.84425548024776231,0.83695903926740645]
[null,null,"CO2",0,0,0,0,0]
[null,null,"N2",0.2520136900716789,0.29097357437053439,0.28284279383600996,0.14947181218356292,0.14848298324037434]
[null,null,"O2",1.7523403880827675E-2,1.7784268967878554E-2,3.0072603922565843E-2,6.272707568674621E-3,1.4557977492219536E-2]
[null,null,"Ar",1.8959793081143326E-3,1.619232613085502E-3,2.2515743162399944E-3,0,0]
[]
[]
[]
[null,null,null,153.892224308913,102.877654800119,187.98602365596801,72.101939968759694,154.03032861539199]
["Thermosyphon feed","Vap Frac",null,{"$f":"D58/D61","v":6.5771069225020407E-2},{"$f":"E58/E61","v":6.6333191710115466E-2},{"$f":"F58/F61","v":6.7081329294368192E-2},{"$f":"G58/G61","v":6.2240659898712553E-2},{"$f":"H58/H61","v":6.4133240184253454E-2},null,"Circulation ratio",11]
[null,"Press","barA",{"$f":"D26","v":1.25},{"$f":"E26","v":1.25},{"$f":"F26","v":1.25},{"$f":"G26","v":1.25},{"$f":"H26","v":1.25}]
[null,"mol Flow","Nm3/h",{"$f":"D58*$K$59+D27","v":2339.8163679292879},{"$f":"E58*$K$59+E27","v":1550.922730353569},{"$f":"F58*$K$59+F27","v":2802.3598463745761},{"$f":"G58*$K$59+G27","v":1158.4379099787006},{"$f":"H58*$K$59+H27","v":2401.7237889878338}]
[]
[null,"Compo","CH4",{"$f":"D29","v":0.999878987594089},{"$f":"E29","v":0.99987642081034001},{"$f":"F29","v":0.99987380691998595},{"$f":"G29","v":0.99989148427114605},{"$f":"H29","v":0.99988556642100701}]
[null,null,"CO2",{"$f":"D30","v":0},0,0,0,0]
[null,null,"N2",8.7192184223539496E-10,8.7549430404612902E-10,5.0810895757545704E-10,2.0909841439527901E-9,8.2924358855701298E-10]
[null,null,"O2",1.20371411924097E-4,1.2306150528517499E-4,1.2575987995313599E-4,1.08513637870027E-4,1.14432749749717E-4]
[null,null,"Ar",6.4012206448488E-7,5.1680888001394999E-7,4.32691952253807E-7,0,0]

{"sheet":"Feed Sep D601 without pumping","index":1,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,6,6,6]]}
["Calculation according \"Phase Separators\" E&C Process Design Rule A0024(b) (2004)"]
["Flow",{"$f":"INDEX('IN Data'!D38:H38,1,MATCH(_case,_cases,0))","v":1071.9668839713079},"Nm3/h",null,null,null,"Composition","methane",{"$f":"1-SUM(I3:I7)","v":0.59848643053460004},null,null,{"$f":"CONCATENATE('Feed Sep D601 without pumping'!H2,\";\",TEXT('Feed Sep D601 without pumping'!I2,\"0.000000\"))","v":"methane;0.598486"},{"$f":"L2","v":"methane;0.598486"}]
["Vapour fraction (mol)",{"$f":"INDEX('IN Data'!D36:H36,1,MATCH(_case,_cases,0))","v":0.34944949797071956},null,null,null,null,null,"nitrogen",{"$f":"INDEX('IN Data'!D42:H42,1,MATCH(_case,_cases,0))","v":0.36036454476056395},null,null,{"$f":"CONCATENATE('Feed Sep D601 without pumping'!H3,\";\",TEXT('Feed Sep D601 without pumping'!I3,\"0.000000\"))","v":"nitrogen;0.360365"},{"$f":"IF(LEFT(L3)=\";\",M2,M2&\";\"&L3)","v":"methane;0.598486;nitrogen;0.360365"}]
["Pressure",{"$f":"INDEX('IN Data'!D37:H37,1,MATCH(_case,_cases,0))","v":1.23},"barA",{"$f":"B4/10","v":0.123},"MPa",null,null,"oxygen",{"$f":"INDEX('IN Data'!D43:H43,1,MATCH(_case,_cases,0))","v":3.8280455915303456E-2},null,null,{"$f":"CONCATENATE('Feed Sep D601 without pumping'!H4,\";\",TEXT('Feed Sep D601 without pumping'!I4,\"0.000000\"))","v":"oxygen;0.038280"},{"$f":"IF(LEFT(L4)=\";\",M3,M3&\";\"&L4)","v":"methane;0.598486;nitrogen;0.360365;oxygen;0.038280"}]
[null,null,null,null,null,null,null,"argon",{"$f":"INDEX('IN Data'!D44:H44,1,MATCH(_case,_cases,0))","v":2.8685687895325029E-3},null,null,{"$f":"CONCATENATE('Feed Sep D601 without pumping'!H5,\";\",TEXT('Feed Sep D601 without pumping'!I5,\"0.000000\"))","v":"argon;0.002869"},{"$f":"IF(LEFT(L5)=\";\",M4,M4&\";\"&L5)","v":"methane;0.598486;nitrogen;0.360365;oxygen;0.038280;argon;0.002869"}]
["Entrainement factor",1.25,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Feed Sep D601 without pumping'!H6,\";\",TEXT('Feed Sep D601 without pumping'!I6,\"0.000000\"))","v":";0.000000"},{"$f":"IF(LEFT(L6)=\";\",M5,M5&\";\"&L6)","v":"methane;0.598486;nitrogen;0.360365;oxygen;0.038280;argon;0.002869"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Feed Sep D601 without pumping'!H7,\";\",TEXT('Feed Sep D601 without pumping'!I7,\"0.000000\"))","v":";0.000000"},{"$f":"IF(LEFT(L7)=\";\",M6,M6&\";\"&L7)","v":"methane;0.598486;nitrogen;0.360365;oxygen;0.038280;argon;0.002869"}]
["Vessel diameter",400,"mm"]
["Vessel height",1550,"mm",null,null,null,"Case","CP_QX_TN"]
["Vessel cross section",{"$f":"PI()/4*(_d/1000)^2","v":0.12566370614359174},"m²"]
[]
["Temperature",{"$f":"[2]!Temperature(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":90.371687929902762},"K"]
["Molar weight",{"$f":"[2]!MolarMass(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":21.035993797000003},"g/mol",{"$f":"B13/1000*44.61531","v":0.93852738441123229},"kg/Nm3"]
[]
[null,"Total","Liquid","Vapor"]
["Density",{"$f":"[2]!Density(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":13.062518820508155},{"$f":"[2]!LiquidDensity(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":527.99161940923341},{"$f":"[2]!VaporDensity(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":4.6393593905997488},"kg/m3"]
["Mass flow",{"$f":"_Qmol*_MW/3600","v":0.27946396549695846},{"$f":"(1-_y)*_Qmol*_MW/3600","v":0.18180542305313985},{"$f":"_y*_Qmol*_MW/3600","v":9.7658542443818622E-2},"kg/s"]
["Volume Flow",{"$f":"_m/_rho","v":2.1394339739300511E-2},{"$f":"_mL/_rhoL","v":3.4433391813408102E-4},{"$f":"_mV/_rhoV","v":2.1050005878331817E-2},"m3/s"]
["Viscosity",null,{"$f":"[2]!Viscosity(_RP_mix,\"PLiq\",\"SI\",_p)/1000000","v":1.7635343588594916E-4},{"$f":"[2]!Viscosity(_RP_mix,\"PVap\",\"SI\",_p)/1000000","v":6.2913509929833338E-6},"Pa.s"]
["Surface tension",null,{"$f":"[2]!SurfaceTension(_RP_mix,\"PLiq\",\"SI\",_p)/1000","v":1.6774139272628868E-2},null,"N/m"]
[]
[null,null,null,null,"min Vessel diam"]
["Critical vapor velocity",{"$f":"0.048*SQRT((_rhoL-_rhoV)/_rhoV)*_alpha","v":0.63726386615543085},"m/s","à",{"$f":"SQRT(4*_VV/(PI()*_vc))*1000","v":205.07915675411351},"mm"]
["Max liquid velocity",{"$f":"0.1*(_sigma/_rhoL)^0.25","v":7.5076376543420885E-3},"m/s","à",{"$f":"SQRT(4*_VL/(PI()*_vLiq))*1000","v":241.65362238397537},"mm"]
[]
[]
["Retention time",5,"min",{"$f":"B27*60","v":300},"sec"]
["Purged liquid volume",{"$f":"_VL*_t_ret","v":0.10330017544022431},"m3"]
["Liquid height",{"$f":"_purgeVol/_Sect","v":0.8220366771785852},"m",{"$f":"B29*1000","v":822.03667717858525},"mm",null,{"$f":"PI()/4*(_d/1000)^2*_H_Liq/1000","v":0.10330017544022432},"m3"]
[]
["Total minimum height","with eliminator",{"$f":"MAX(0.15*_d,300)+150+MAX(0.5*_d,400)+MAX(MIN(0.3*_d,500),200)+_H_Liq+50","v":1922.0366771785853},"mm"]
[null,"without eliminator",{"$f":"MAX(_d,300)+MAX(MIN(0.3*_d,500),200)+_H_Liq+50","v":1472.0366771785853},"mm"]

{"sheet":"Feed Sep D601 with pumping","index":2,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,6,6,6]]}
["Calculation according \"Phase Separators\" E&C Process Design Rule A0024(b) (2004)"]
["Flow",{"$f":"INDEX('IN Data'!D48:H48,1,MATCH(_case,_cases,0))","v":1365.772318434879},"Nm3/h",null,null,null,"Composition","methane",{"$f":"1-SUM(I3:I7)","v":0.68483302792518419},null,null,{"$f":"CONCATENATE('Feed Sep D601 with pumping'!H2,\";\",TEXT('Feed Sep D601 with pumping'!I2,\"0.000000\"))","v":"methane;0.684833"},{"$f":"L2","v":"methane;0.684833"}]
["Vapour fraction (mol)",{"$f":"INDEX('IN Data'!D46:H46,1,MATCH(_case,_cases,0))","v":0.27427579574484634},null,null,null,null,null,"nitrogen",{"$f":"INDEX('IN Data'!D52:H52,1,MATCH(_case,_cases,0))","v":0.28284279383600996},null,null,{"$f":"CONCATENATE('Feed Sep D601 with pumping'!H3,\";\",TEXT('Feed Sep D601 with pumping'!I3,\"0.000000\"))","v":"nitrogen;0.282843"},{"$f":"IF(LEFT(L3)=\";\",M2,M2&\";\"&L3)","v":"methane;0.684833;nitrogen;0.282843"}]
["Pressure",{"$f":"INDEX('IN Data'!D47:H47,1,MATCH(_case,_cases,0))","v":1.23},"barA",{"$f":"B4/10","v":0.123},"MPa",null,null,"oxygen",{"$f":"INDEX('IN Data'!D53:H53,1,MATCH(_case,_cases,0))","v":3.0072603922565843E-2},null,null,{"$f":"CONCATENATE('Feed Sep D601 with pumping'!H4,\";\",TEXT('Feed Sep D601 with pumping'!I4,\"0.000000\"))","v":"oxygen;0.030073"},{"$f":"IF(LEFT(L4)=\";\",M3,M3&\";\"&L4)","v":"methane;0.684833;nitrogen;0.282843;oxygen;0.030073"}]
[null,null,null,null,null,null,null,"argon",{"$f":"INDEX('IN Data'!D54:H54,1,MATCH(_case,_cases,0))","v":2.2515743162399944E-3},null,null,{"$f":"CONCATENATE('Feed Sep D601 with pumping'!H5,\";\",TEXT('Feed Sep D601 with pumping'!I5,\"0.000000\"))","v":"argon;0.002252"},{"$f":"IF(LEFT(L5)=\";\",M4,M4&\";\"&L5)","v":"methane;0.684833;nitrogen;0.282843;oxygen;0.030073;argon;0.002252"}]
["Entrainement factor",1.25,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Feed Sep D601 with pumping'!H6,\";\",TEXT('Feed Sep D601 with pumping'!I6,\"0.000000\"))","v":";0.000000"},{"$f":"IF(LEFT(L6)=\";\",M5,M5&\";\"&L6)","v":"methane;0.684833;nitrogen;0.282843;oxygen;0.030073;argon;0.002252"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Feed Sep D601 with pumping'!H7,\";\",TEXT('Feed Sep D601 with pumping'!I7,\"0.000000\"))","v":";0.000000"},{"$f":"IF(LEFT(L7)=\";\",M6,M6&\";\"&L7)","v":"methane;0.684833;nitrogen;0.282843;oxygen;0.030073;argon;0.002252"}]
["Vessel diameter",400,"mm"]
["Vessel height",1900,"mm",null,null,null,"Case","CP_QX_TN"]
["Vessel cross section",{"$f":"PI()/4*(_d/1000)^2","v":0.12566370614359174},"m²"]
[]
["Temperature",{"$f":"[2]!Temperature(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":92.234260001580736},"K"]
["Molar weight",{"$f":"[2]!MolarMass(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":19.962298422141579},"g/mol",{"$f":"B13/1000*44.61531","v":0.89062413241635741},"kg/Nm3"]
[]
[null,"Total","Liquid","Vapor"]
["Density",{"$f":"[2]!Density(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":15.991008293102208},{"$f":"[2]!LiquidDensity(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":509.01010738757367},{"$f":"[2]!VaporDensity(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":4.4882759677248245},"kg/m3"]
["Mass flow",{"$f":"_Qmol*_MW/3600","v":0.33788605171787256},{"$f":"(1-_y)*_Qmol*_MW/3600","v":0.24521208601186878},{"$f":"_y*_Qmol*_MW/3600","v":9.2673965706003794E-2},"kg/s"]
["Volume Flow",{"$f":"_m/_rho","v":2.1129752766348146E-2},{"$f":"_mL/_rhoL","v":4.8174305864059761E-4},{"$f":"_mV/_rhoV","v":2.0648009697358614E-2},"m3/s"]
["Viscosity",null,{"$f":"[2]!Viscosity(_RP_mix,\"PLiq\",\"SI\",_p)/1000000","v":1.76699075524957E-4},{"$f":"[2]!Viscosity(_RP_mix,\"PVap\",\"SI\",_p)/1000000","v":6.0358779242319863E-6},"Pa.s"]
["Surface tension",null,{"$f":"[2]!SurfaceTension(_RP_mix,\"PLiq\",\"SI\",_p)/1000","v":1.7137523166196874E-2},null,"N/m"]
[]
[null,null,null,null,"min Vessel diam"]
["Critical vapor velocity",{"$f":"0.048*SQRT((_rhoL-_rhoV)/_rhoV)*_alpha","v":0.63613817123112426},"m/s","à",{"$f":"SQRT(4*_VV/(PI()*_vc))*1000","v":203.29112959705117},"mm"]
["Max liquid velocity",{"$f":"0.1*(_sigma/_rhoL)^0.25","v":7.6173763317186607E-3},"m/s","à",{"$f":"SQRT(4*_VL/(PI()*_vLiq))*1000","v":283.76582209024525},"mm"]
[]
[]
["Retention time",5,"min",{"$f":"B27*60","v":300},"sec"]
["Purged liquid volume",{"$f":"_VL*_t_ret","v":0.14452291759217928},"m3"]
["Liquid height",{"$f":"_purgeVol/_Sect","v":1.1500768362428986},"m",{"$f":"B29*1000","v":1150.0768362428985},"mm",null,{"$f":"PI()/4*(_d/1000)^2*_H_Liq/1000","v":0.14452291759217925},"m3"]
[]
["Total minimum height","with eliminator",{"$f":"MAX(0.15*_d,300)+150+MAX(0.5*_d,400)+MAX(MIN(0.3*_d,500),200)+_H_Liq+50","v":2250.0768362428985},"mm"]
[null,"without eliminator",{"$f":"MAX(_d,300)+MAX(MIN(0.3*_d,500),200)+_H_Liq+50","v":1800.0768362428985},"mm"]

{"sheet":"Thermosyphon Sep D602","index":3,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,6,6,6]]}
["Calculation according \"Phase Separators\" E&C Process Design Rule A0024(b) (2004)"]
["Flow",{"$f":"INDEX('IN Data'!D61:H61,1,MATCH(_case,_cases,0))","v":2802.3598463745761},"Nm3/h",null,null,null,"Composition","methane",{"$f":"1-SUM(I3:I7)","v":0.99987380691998562},null,null,{"$f":"CONCATENATE('Thermosyphon Sep D602'!H2,\";\",TEXT('Thermosyphon Sep D602'!I2,\"0.000000\"))","v":"methane;0.999874"},{"$f":"L2","v":"methane;0.999874"}]
["Vapour fraction (mol)",{"$f":"INDEX('IN Data'!D59:H59,1,MATCH(_case,_cases,0))","v":6.7081329294368192E-2},null,null,null,null,null,"nitrogen",{"$f":"INDEX('IN Data'!D65:H65,1,MATCH(_case,_cases,0))","v":5.0810895757545704E-10},null,null,{"$f":"CONCATENATE('Thermosyphon Sep D602'!H3,\";\",TEXT('Thermosyphon Sep D602'!I3,\"0.000000\"))","v":"nitrogen;0.000000"},{"$f":"IF(LEFT(L3)=\";\",M2,M2&\";\"&L3)","v":"methane;0.999874;nitrogen;0.000000"}]
["Pressure",{"$f":"INDEX('IN Data'!D60:H60,1,MATCH(_case,_cases,0))","v":1.25},"barA",{"$f":"B4/10","v":0.125},"MPa",null,null,"oxygen",{"$f":"INDEX('IN Data'!D66:H66,1,MATCH(_case,_cases,0))","v":1.2575987995313599E-4},null,null,{"$f":"CONCATENATE('Thermosyphon Sep D602'!H4,\";\",TEXT('Thermosyphon Sep D602'!I4,\"0.000000\"))","v":"oxygen;0.000126"},{"$f":"IF(LEFT(L4)=\";\",M3,M3&\";\"&L4)","v":"methane;0.999874;nitrogen;0.000000;oxygen;0.000126"}]
[null,null,null,null,null,null,null,"argon",{"$f":"INDEX('IN Data'!D67:H67,1,MATCH(_case,_cases,0))","v":4.32691952253807E-7},null,null,{"$f":"CONCATENATE('Thermosyphon Sep D602'!H5,\";\",TEXT('Thermosyphon Sep D602'!I5,\"0.000000\"))","v":"argon;0.000000"},{"$f":"IF(LEFT(L5)=\";\",M4,M4&\";\"&L5)","v":"methane;0.999874;nitrogen;0.000000;oxygen;0.000126;argon;0.000000"}]
["Entrainement factor",1.25,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Thermosyphon Sep D602'!H6,\";\",TEXT('Thermosyphon Sep D602'!I6,\"0.000000\"))","v":";0.000000"},{"$f":"IF(LEFT(L6)=\";\",M5,M5&\";\"&L6)","v":"methane;0.999874;nitrogen;0.000000;oxygen;0.000126;argon;0.000000"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Thermosyphon Sep D602'!H7,\";\",TEXT('Thermosyphon Sep D602'!I7,\"0.000000\"))","v":";0.000000"},{"$f":"IF(LEFT(L7)=\";\",M6,M6&\";\"&L7)","v":"methane;0.999874;nitrogen;0.000000;oxygen;0.000126;argon;0.000000"}]
["Vessel diameter",470,"mm"]
["Vessel height",2100,"mm",null,null,null,"Case","CP_QX_TN"]
["Vessel cross section",{"$f":"PI()/4*(_d/1000)^2","v":0.17349445429449631},"m²"]
[]
["Temperature",{"$f":"[2]!Temperature(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":114.26974082070086},"K"]
["Molar weight",{"$f":"[2]!MolarMass(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":16.044810456},"g/mol",{"$f":"B13/1000*44.61531","v":0.71584419238568142},"kg/Nm3"]
[]
[null,"Total","Liquid","Vapor"]
["Density",{"$f":"[2]!Density(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":30.622580523279687},{"$f":"[2]!LiquidDensity(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":418.56739192269515},{"$f":"[2]!VaporDensity(_RP_mix,\"PQ\",\"SI\",_p,_y)","v":2.204677261921292},"kg/m3"]
["Mass flow",{"$f":"_Qmol*_MW/3600","v":0.55723695027835296},{"$f":"(1-_y)*_Qmol*_MW/3600","v":0.51985675492174133},{"$f":"_y*_Qmol*_MW/3600","v":3.7380195356611676E-2},"kg/s"]
["Volume Flow",{"$f":"_m/_rho","v":1.8196929871887646E-2},{"$f":"_mL/_rhoL","v":1.2419905729726629E-3},{"$f":"_mV/_rhoV","v":1.6954951185932886E-2},"m3/s"]
["Viscosity",null,{"$f":"[2]!Viscosity(_RP_mix,\"PLiq\",\"SI\",_p)/1000000","v":1.107025345567841E-4},{"$f":"[2]!Viscosity(_RP_mix,\"PVap\",\"SI\",_p)/1000000","v":4.4610029444771436E-6},"Pa.s"]
["Surface tension",null,{"$f":"[2]!SurfaceTension(_RP_mix,\"PLiq\",\"SI\",_p)/1000","v":1.2415298056560485E-2},null,"N/m"]
[]
[null,null,null,null,"min Vessel diam"]
["Critical vapor velocity",{"$f":"0.048*SQRT((_rhoL-_rhoV)/_rhoV)*_alpha","v":0.82454555461335632},"m/s","à",{"$f":"SQRT(4*_VV/(PI()*_vc))*1000","v":161.80651491517645},"mm"]
["Max liquid velocity",{"$f":"0.1*(_sigma/_rhoL)^0.25","v":7.3798568809218881E-3},"m/s","à",{"$f":"SQRT(4*_VL/(PI()*_vLiq))*1000","v":462.90325994962416},"mm"]
[]
[]
["Retention time",3,"min",{"$f":"B27*60","v":180},"sec"]
["Purged liquid volume",{"$f":"_VL*_t_ret","v":0.22355830313507932},"m3"]
["Liquid height",{"$f":"_purgeVol/_Sect","v":1.2885616663896511},"m",{"$f":"B29*1000","v":1288.561666389651},"mm",null,{"$f":"PI()/4*(_d/1000)^2*_H_Liq/1000","v":0.22355830313507932},"m3"]
[null,null,null,null,null,"FIVES : Liquid height >760mm for thermosyphon"]
["Total minimum height","with eliminator",{"$f":"MAX(0.15*_d,300)+150+MAX(0.5*_d,400)+MAX(MIN(0.3*_d,500),200)+_H_Liq+50","v":2388.5616663896508},"mm"]
[null,"without eliminator",{"$f":"MAX(_d,300)+MAX(MIN(0.3*_d,500),200)+_H_Liq+50","v":2008.561666389651},"mm"]
[]
["The entire liquid inventary is collected in this drum -> needs to be big enough"]
["Available volume",{"$f":"PI()/4*(_d/1000)^2*_h/1000","v":0.36433835401844228},"m3"]
[]
["Additional liquid from","Distributor",{"$f":"10/1000","v":0.01},"m3","AL4"]
[null,"AST",{"$f":"7/1000","v":7.0000000000000001E-3},"m3","AL4"]
[null,"D-601",{"$f":"'Feed Sep D601 without pumping'!G29","v":0.10330017544022432},"m3"]
[null,"Sum incl safety",{"$f":"(C39+C38+C37)*(F40+1)","v":0.13233019298424678},"m3","Safety margin",0.1]
[]
["Void volume after column stop",null,{"$f":"B35-C40-G29","v":8.4498578991161755E-3},"m3"]

{"sheet":"AUX","index":4,"n_rows":85,"n_cols":4,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[84,null,80,8.4900000000000003E-2]
["acetone",null,100,0.11]
["ammonia",null,125,0.13569999999999999]
["argon",null,150,0.1643]
["benzene",null,200,0.21329999999999999]
["butane",null,250,0.26700000000000002]
["butene",null,300,0.31780000000000003]
["carbon dioxide",null,350,0.34960000000000002]
["carbon monoxide",null,400,0.40039999999999998]
["carbonyl sulfide",null,450,0.45119999999999999]
["cis-butene"]
["cyclohexane"]
["cyclopropane"]
["decane"]
["deuterium"]
["dimethylether"]
["dodecane"]
["ethane"]
["ethanol"]
["ethylene"]
["fluorine"]
["heavy water"]
["helium"]
["heptane"]
["hexane"]
["hydrogen"]
["hydrogen sulfide"]
["isobutane"]
["isobutene"]
["isohexane"]
["isopentane"]
["krypton"]
["methane"]
["methanol"]
["neon"]
["neopentane"]
["nitrogen"]
["nitrogen triflouride"]
["nitrous oxide"]
["nonane"]
["octane"]
["oxygen"]
["parahydrogen"]
["pentane"]
["perfluorobutane"]
["perfluoropentane"]
["propane"]
["propylene"]
["propyne"]
["sulfur dioxide"]
["sulfur hexafluoride"]
["toluene"]
["trans-butene"]
["trifluoroiodomethane"]
["water"]
["xenon"]
["R11"]
["R12"]
["R13"]
["R14"]
["R21"]
["R22"]
["R23"]
["R32"]
["R41"]
["R113"]
["R114"]
["R115"]
["R116"]
["R123"]
["R124"]
["R125"]
["R134a"]
["R141b"]
["R142b"]
["R143a"]
["R152a"]
["R218"]
["R227ea"]
["R236ea"]
["R236fa"]
["R245ca"]
["R245fa"]
["R365mfc"]
["RC318"]