Planilha para simulação para determinação de colunas de destilação fracionárias, pelo método McCabe-Thiele.
Citation preview
Sheet1TEMP.EtanolguaALFAlinha de operaoTELA DE ENTRADA DE
DADOSCPvxyPvxy2.274xy78.400760.0471.0001.000332.9160.0000.0002.2830.0000.000EtanolCONTANTES
DE ANTOINE
*80.800836.8860.8360.921366.9830.1640.0792.2801.0001.000DENSIDADE000.785g/cmABC83.200920.2100.6900.835403.9270.3100.1652.278linha
de cargaTEMP.
EBULIO078.400CEtanol19.85354323.64-24.5085.6001010.4510.5580.742443.9360.4420.2582.276xyCALOR
ESPECF.001.000cal/gC88.0001108.0630.4390.641487.2060.5610.3592.2740.0500.050CALOR
LATENTE540.000cal/ggua18.30363816.44-46.1390.4001213.5200.3330.531533.9420.6670.4692.2730.0500.10792.8001327.3160.2360.413584.3570.7640.5872.271linha
de
esgotamentoEtanol95.2001449.9670.1500.285638.6740.8500.7152.270xyguaTOPO095.00%97.6001582.0130.0710.148697.1230.9290.8522.2690.0100.010DENSIDADE000.997g/cmCARGA005.00%100.0001724.0130.0000.000759.9431.0001.0002.2690.0500.088TEMP.
EBULIO100.000CFUNDO001.00%linha de enriquecimentoCALOR
ESPECF.000.580cal/gCDENSIDADE DAS FRAESFRAES MOLARESTEMPERATURA DOS
PRATOSxyCALOR LATENTE205.000cal/gPRESSO
ABSOLUTA760.00mmHgxy0.9500.950RAZO DE
REFLUXO022.70TOPO0.793g/cmTOPO0.950000.97737TOPO79.103C0.0500.088PRODUO
DE TOPO:004.00L/hPERCENTUAL RR
mn.025.00%CARGA0.984g/cmCARGA0.050000.10687CARGA98.336Clinha de RR
mnimoFUNDO0.994g/cmFUNDO0.010000.02245FUNDO99.708C0.9500.950*
LN(Pv) = A - B/(C + t); Pv = mmHg, t =
K.0.0500.107VAZOTOPO4.000L/h3.174kg/hTELA DE DETERMINAO NO NMERO DE
PRATOS
TERICOSCARGA75.818L/h74.583kg/hFUNDO71.818L/h71.409kg/hREFLUXO90.800L/h72.044kg/h760.0mmHgVn75.218kg/h79CVm75.218kg/h4.0L/hLm146.627kg/h1PRATOS
TERICOSCOMPOSIO PRATOSPRATOS#CARGATERICOSxyCARGA010q
=190.8L/h0.950000.95000TOTAL0140010.893130.95000alfa
=2.2740.893130.895530020.893130.89553100.893130.8955375.8L/h0030.790370.8955398C0.790370.797110040.633430.797110.633430.646790050.446110.646790.446110.46737140060.278480.467370.278480.306810070.162950.306810.162950.1961671.8L/h0080.096930.19616100C0.096930.132930090.063170.132930.063170.100590100100.046890.100590.046890.081900110.037760.081900.037760.064110120.029250.064110.029250.047520130.021470.047520.021470.032370140.014500.032370.014500.018770150150.008340.018770.008340.006770160.002990.006770.00299-0.00367017-0.00161-0.00367-0.00161-0.01263018-0.00552-0.01263-0.00552-0.02025019-0.00881-0.02025-0.00881-0.02666020-0.01155-0.02666-0.01155-0.03202021-0.01383-0.03202-0.01383-0.03646022-0.01572-0.03646-0.01572-0.04013023-0.01726-0.04013-0.01726-0.04315024-0.01853-0.04315-0.01853-0.04561025-0.01956-0.04561-0.01956-0.04763026-0.02041-0.04763-0.02041-0.04927027-0.02109-0.04927-0.02109-0.05060028-0.02164-0.05060-0.02164-0.05169029-0.02209-0.05169-0.02209-0.05256030-0.02246-0.05256-0.02246-0.05327031-0.02275-0.05327-0.02275-0.05385032-0.02299-0.05385-0.02299-0.05431033-0.02318-0.05431-0.02318-0.05469034-0.02334-0.05469-0.02334-0.05499035-0.02346-0.05499-0.02346-0.05523036-0.02356-0.05523-0.02356-0.05543037-0.02365-0.05543-0.02365-0.05559038-0.02371-0.05559-0.02371-0.05572039-0.02377-0.05572-0.02377-0.05582040-0.02381-0.05582-0.02381-0.05590041-0.02384-0.05590-0.02384-0.05597042-0.02387-0.05597-0.02387-0.05603043-0.02389-0.05603-0.02389-0.05607044-0.02391-0.05607-0.02391-0.05610045-0.02393-0.05610-0.02393-0.05613046-0.02394-0.05613-0.02394-0.05616047-0.02395-0.05616-0.02395-0.05617048-0.02395-0.05617-0.02395-0.05619049-0.02396-0.05619-0.02396-0.05620050-0.02396-0.05620-0.02396-0.05621051-0.02397-0.05621-0.02397-0.05622052-0.02397-0.05622-0.02397-0.05622053-0.02397-0.05622-0.02397-0.05623054-0.02398-0.05623-0.02398-0.05623055-0.02398-0.05623-0.02398-0.05624056-0.02398-0.05624-0.02398-0.05624057-0.02398-0.05624-0.02398-0.05624058-0.02398-0.05624-0.02398-0.05624059-0.02398-0.05624-0.02398-0.05624060-0.02398-0.05624-0.02398-0.05625061-0.02398-0.05625-0.02398-0.05625062-0.02398-0.05625-0.02398-0.05625063-0.02398-0.05625-0.02398-0.05625064-0.02398-0.05625-0.02398-0.05625065-0.02398-0.05625-0.02398-0.05625066-0.02398-0.05625-0.02398-0.05625067-0.02398-0.05625-0.02398-0.05625068-0.02399-0.05625-0.02399-0.05625069-0.02399-0.05625-0.02399-0.05625070-0.02399-0.05625-0.02399-0.05625071-0.02399-0.05625-0.02399-0.05625072-0.02399-0.05625-0.02399-0.05625073-0.02399-0.05625-0.02399-0.05625074-0.02399-0.05625-0.02399-0.05625075-0.02399-0.05625-0.02399-0.05625076-0.02399-0.05625-0.02399-0.05625077-0.02399-0.05625-0.02399-0.05625078-0.02399-0.05625-0.02399-0.05625079-0.02399-0.05625-0.02399-0.05625080-0.02399-0.05625-0.02399-0.05625081-0.02399-0.05625-0.02399-0.05625082-0.02399-0.05625-0.02399-0.05625083-0.02399-0.05625-0.02399-0.05625084-0.02399-0.05625-0.02399-0.05625085-0.02399-0.05625-0.02399-0.05625086-0.02399-0.05625-0.02399-0.05625087-0.02399-0.05625-0.02399-0.05625088-0.02399-0.05625-0.02399-0.05625089-0.02399-0.05625-0.02399-0.05625090-0.02399-0.05625-0.02399-0.05625091-0.02399-0.05625-0.02399-0.05625092-0.02399-0.05625-0.02399-0.05625093-0.02399-0.05625-0.02399-0.05625094-0.02399-0.05625-0.02399-0.05625095-0.02399-0.05625-0.02399-0.05625096-0.02399-0.05625-0.02399-0.05625097-0.02399-0.05625-0.02399-0.05625098-0.02399-0.05625-0.02399-0.05625099-0.02399-0.05625-0.02399-0.05625100-0.02399-0.05625
