Matriz y Metodo Teta

Embed Size (px)

DESCRIPTION

Se presentasn los pasos para hacer la matriz y el metodo teta para un sistema en excel.

Citation preview

Hoja1

PROPANOjDESCRIPCIONTbT(R)Kj(pr)Kj(b)Kj(p)0CONDENSADOR33.4552.11.6320.50.169jx0x1x2x3x4IjSumatoria XijflujoPropanoButanoPentanoFLUJOS COMPONENTES 1PLATO 143.4570.11.9890.6490.2310150-298.35000000.8516D5028.6412.351.5942.582PLATO 253.45882.380.8230.3061-100398.35-35700010.8063L110028.8038.0513.7880.633PLATO 363.36062.8041.0210.39620-100557-420.603020.9040L220032.1881.6566.96180.794VAPORIZADOR73.36243.2581.2450.501300-200620.6-488.7030.9719L320014.6583.5896.14194.374000-200538.7041.1484B501.3617.6538.4157.42-0.67-5.24-1.51-7.42F100-0.68-16.15-13.04-29.87Zpr0.30.01969690960.01954536440.01909322930.01828616810.0165889184x00.5728Zb0.30.00655115280.00982672920.00959941140.00919364910.008340331x10.2880Zp0.40.00179260720.00268891080.00536303250.00513633980.0046596051x20.1609R20.0008163740.0012245610.0024423870.00461620630.0041877483x30.0733TETA 1P(psi)100689.4757kPa0.00030309040.00045463560.00090677070.00171383190.0034110816x40.0272TETA0.49356162380.4935616238q1FUNCION OBJETIVO-0.0000169973METODO TETABUTANOZONA RECTIFICACIONZONA DE AGOTAMIENTOComponentesCorreccion, flujo D (XiD*D)Correccion, flujo B (xiB*B)Correccion, flujo internos (Xij*L1)Correccion, flujo internos (Xij*L2)Correccion, flujo internos (Xij*L3)xi,1xi,2xi,3xi,Dxi.BD50jx0x1x2x3x4IPropano29.31290258020.687097419829.475015163616.25515974467.40278760090.26674676130.11779190220.04669556870.58625825090.0137419437v1500150-97.350000Butano17.589626556912.410373443154.205320668357.408231245558.76311825320.49055424240.41600481740.37066810130.35179265070.2482073845L1001-100197.35-123.45000Pentano3.097453865736.902546134326.817782386664.335566807792.36707297430.24269899630.46620328030.582636330.06194909840.7380506718Lbarra20020-100323.45-153.15030Sumatoria Flujos49.999983002750.0000169973110.4981182186137.9989577978158.532978828411111B50300-200353.15-186.7504000-200236.750

COMPONENTEABC0.01407681720.01111522580.00823211660.00645251740.0050897893x00.2470Propano13.70971872.82-25.1011 0.01141779740.01712669610.0126843090.00994224560.0078425105x10.3805Butano13.98362292.44-27.86230.00684990360.01027485540.0136090460.01066707520.008414261x20.4083Pentano13.97782554.6-36.25290.00701156760.01051735150.0139302320.01603683250.0126499619x30.41790.00592318280.00888477420.01176788340.01354748260.0149102107x40.3530Etapa 0T burbuja300.778017082227.6280170822YPsat, pro1008.4480532429Kpro1.46263030480.8574790842PENTANOPsat, but266.0782985943Kbut0.38591396130.1357616954Psat, pent75.2257807493Kpen0.10910577520.0067590044jx0x1x2x3x4ISUMA0.9999997840150-34.650000funcion objetivo-0.0000002161-100134.65-45.900020-100245.90-59.4040Etapa 1300-200259.40-75.150T burbuja320.531001936947.3810019369Y4000-200125.150Psat, pro1588.2623904701Kpro2.30357993830.6144724879Psat, but469.0530969102Kbut0.68030402940.3337260278Psat, pent147.1612939369Kpen0.21343942060.05180153320.0085226910.00278403650.00079559270.00033924490.0002037096x00.0318SUMA1.00000004880.00803473740.01205210610.00344412440.00146859260.0008818596x10.1378funcion objetivo0.00000004880.00500235930.00750353890.00837019770.00356909590.0021431686x20.33480.00718192610.01077288920.01201715780.01230271750.0073875287x30.4807Etapa 2Y0.0114773090.01721596350.01920440730.01966075510.0197962904x40.7682T burbuja338.267871231665.1178712316Psat, pro2274.3188905618Kpro3.29862080790.3885508197Psat, but733.8424877486Kbut1.0643485880.44277414Psat, pent249.4550957685Kpen0.36180404290.1686742317SUMA0.9999991914funcion objetivo-0.0000008086

Etapa 3YT burbuja350.149659526576.9996595265Psat, pro2830.0164282552Kpro4.10459197950.1916662567Psat, but963.4965773364Kbut1.39743369830.5179840956Psat, pent343.5921670544Kpen0.49833832730.2903500141SUMA1.0000003664funcion objetivo0.0000003664

Etapa 4T burbuja361.548912923288.3989129232YPsat, pro3440.0792460031Kpro4.98941332670.0685642372Psat, but1228.5146703151Kbut1.78180996130.4422583901Psat, pent456.9824702626Kpen0.66279706490.489177819SUMA1.0000004463funcion objetivo0.0000004463

Balance de energiaCp gas (J,K)Cp liquido (J,K)abcdeabcdDH vap (J/mol)T ebullicion (K)n-propano47.2659-0.1314690.00117-0.0000016970.0000000008n-propano33.75070.746408-0.003649660.000007106718773.1231.091n-butano66.7088-0.1855230.00152844-0.00000218790.000000001n-butano51.85830.656571-0.002530790.000004498822416272.661n-pentano83.1454-0.2419250.00194653-0.00000280750.0000000001n-pentano65.49610.628628-0.00189880.000003186525937.3309.233Tref273.15hHEtapaT etapahjHjETAPA 0Cp liquidosETAPA 0Cp liquido ETAPA 0Cp vapor0300.77801708223496.688792282419969.9136839278n-propano3190.8977630835n-propano-4378.0020334n-propano4689.57923994631320.53100193699457.937499167723382.8462244195n-butano3819.8638168256n-butano-65.5224332807n-butano2661.93142475812338.267871231610100.197851150527285.2860880361n-pentano4555.3307597838n-pentano6001.2128427062n-pentano-946.50758382653350.149659526512481.760465808330685.79268969244361.548912923214962.803692441834161.5109501858ETAPA 1Cp liquidosETAPA 1Cp vaporn-propano5690.9742176899n-propano6192.60247927n-butano6713.9968468292n-butano4651.6098138517Qc-2470983.73374681n-pentano7974.629596316n-pentano1283.8889536511FlujosETAPA 2Cp liquidosETAPA 2Cp vaporCorrientesV (kmol/h)L (kmol/h)n-propano8133.4207507787n-propano7609.78921439221150n-butano9452.1038777497n-butano6523.80537875592192.809973392n-pentano11175.4383141605n-pentano3339.45035158273165.41555525084-0.4413411455ETAPA 3Cp liquidosETAPA 3Cp vaporn-propano9893.43863583n-propano8595.0883088877n-butano11371.0363711427n-butano7823.5793311531n-pentano13395.8352042731n-pentano4740.2116415926ETAPA 4Cp liquidosETAPA 4Cp vaporn-propano11688.6326991516n-propano9567.4833959376n-butano13283.5043272948n-butano9105.0182413284n-pentano15588.516796402n-pentano6098.9393462516