Planilha Problema Flash - Termo II 2015/2

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Flash
	Pressão abs (bar)	3.04	Temperatura (K)	380.15	107	°C	Constantes de Antoine
	R (cm³.bar/mol.K)	83.14	R (cal/mol.K)	1.9871	DECHEMA - Modelo de Wilson - A linha,coluna
	Componente	Número	Tc (K)	Pc (bar)	ω	Zc	Vc (cm³/mol)	A	B	C	Parâmetros	1	2	3	4	5
	Água	1	647.1	220.55	0.345	0.229	55.9	8.07131	1730.63	233.426	1	-	522.9396	1085.9103	1270.2305	1466.3521
	Metanol	2	512.6	80.97	0.564	0.224	118	8.08097	1582.271	239.726	2	134.0301	-	-346.0143	272.431	587.8058
	Etanol	3	513.9	61.48	0.645	0.240	167	8.1122	1592.864	226.184	3	365.7687	824.0969	-	379.7182	502.8977
	Propanol-1	4	536.8	51.75	0.622	0.254	219	7.74416	1437.686	198.463	4	1618.7879	-207.7119	-332.4656	-	-277.7831
	Propanona	5	508.2	47.01	0.307	0.233	209	7.6313	1566.69	273.419	5	314.2039	-168.3138	-42.2222	667.6711	-
	Número	bi	Tr	mi	αi	aci	ai	VL (cm³/mol)	Λ lin,col	1	2	3	4	5
	1	18.9781534944	0.5875	0.8746	1.2042	6000673.4550378295	8702267.279429132	17.8	1	1	1.2009	0.8436	0.8734	0.6311
	2	40.9490734741	0.7416	1.1586	1.1609	10256455.990294093	13821368.023842992	42.7	2	0.3490	1	2.3402	1.3637	0.8414
	3	54.0672618543	0.7397	1.2571	1.1759	13576494.029503604	18772634.033176757	63.2	3	0.1735	0.2269	1	0.7993	0.6361
	4	67.0952491903	0.7082	1.2295	1.1948	17598632.268892262	25124332.049036935	83.5	4	0.0250	0.6731	1.1752	1	1.3531
	5	69.9252498277	0.7480	0.8227	1.1112	17363742.097182274	21438321.985171452	78.2	5	0.6597	0.6820	0.8543	0.4411	1
	Legenda das cores ao final das iterações
	1ª iteração
	Calculados
	#	zi	xi	yi	Psat i (mmHg)	Ki	V	F(V)	dF/dV	Dif %	xi	yi	amix	Z	δi	ln φi	φi	ln ϒi	ϒi
	1	0.2	-	-	971.832	0.4262	1	-0.3785821314	-0.6383750693	-	0.1711	0.0729	17482657.331825588	0.950	1.4110502564630329	-1.987978074439168E-2	0.980	0.57021766440837984	1.769
	2	0.2	-	-	3292.364	1.4439	0.4070	-0.1461359895	-0.2555348968	145.7	0.2301	0.3322	bmix	F(Z)	1.7782867337369714	-3.797707576978479E-2	0.963	-8.6972106048250897E-3	0.991
	3	0.2	-	-	2145.192	0.9408	-0.1649	-0.0245696753	-0.1902881369	-346.8	0.1966	0.1849	53.4175643176	-0.000000009	2.0724729933819512	-5.2955716969389041E-2	0.948	0.11375384225697793	1.120
	4	0.2	-	-	1090.386	0.4782	-0.2940	-0.0000597104	-0.1901120324	-43.9	0.1734	0.0829	A	h	2.3975823633760136	-6.9666552822603853E-2	0.933	9.1363105330915184E-2	1.096
	5	0.2	-	-	3258.161	1.4289	-0.2944	0.0000000008	-0.1901170855	-0.1	0.2289	0.3271	0.0532048225	0.0054082202	2.2147344836019549	-5.9177535844238897E-2	0.943	0.21503524490703319	1.240
	-0.2944	0	-0.1901170854	0.0	x	y	B
	-0.2944	0	-0.1901170854	0	1	1	0.0051379828
	2ª iteração
	#	zi	xi	yi	Psat i (bar)	A	B	Z	F(Z)	h	ln φisat	φisat	Ki	V	F(V)	dF/dV	Dif %	xi	yi	amix	Z	δi	ln φi	φi	ln ϒi	ϒi
	1	0.2	0.1711	0.0729	1.296	1.1287273749763438E-2	7.7799285765236051E-4	0.989	-0.0000005626	7.8633108469080225E-4	-1.0556024395137397E-2	0.989	0.7609	1	-0.0786431934	-0.213930534	-	0.2318	0.1763	16983472.92324321	0.951	1.431637128772459	-2.0364119714011364E-2	0.980	0.58524030537458605	1.795
	2	0.2	0.2301	0.3322	4.389	6.073291004499904E-2	5.6869859408416462E-3	0.942	-0.0000002378	6.0346304940164467E-3	-5.6281584601756141E-2	0.945	1.4054	0.6324	-0.009960583	-0.1692712455	58.1	0.1623	0.2281	bmix	F(Z)	1.8042314949170268	-3.8152146268059003E-2	0.963	-5.2891952022141586E-2	0.948
	3	0.2	0.1966	0.1849	2.860	5.3747308384774997E-2	4.8925007092069017E-3	0.949	-0.0000002193	5.1547237599820356E-3	-4.9831000463039433E-2	0.951	1.0574	0.5735	-0.0000812258	-0.1666770027	10.3	0.1936	0.2047	50.668906000646103	-0.0000001746	2.1027098589252349	-5.2881491094081363E-2	0.948	0.10937660024978335	1.116
	4	0.2	0.1734	0.0829	1.454	3.6562842516720422E-2	3.0860447014854509E-3	0.966	-0.0000000891	3.1960523821014794E-3	-3.3938322572915583E-2	0.967	0.5430	0.5731	-0.0000000042	-0.1666596449	0.1	0.2710	0.1471	A	h	2.4325624937718491	-6.9316318916395808E-2	0.933	0.11411591612154215	1.121
	5	0.2	0.2289	0.3271	4.344	9.3224194851824177E-2	9.6102988595199983E-3	0.910	-0.0000004808	1.0556445422586082E-2	-8.6453430010901181E-2	0.917	1.7240	0.5731	0	-0.166659644	0.0	0.1414	0.2437	5.1685658860923349E-2	5.1227153967311435E-3	2.2470469089066949	-5.8986040313272668E-2	0.943	0.22243176159022404	1.249
	0.5731	0	-0.166659644	0.0	x	y	B
	δV (%)	-151.3657289712	1	1	4.8736024064151067E-3
	3ª iteração
	#	zi	xi	yi	Psat i (bar)	φisat	Ki	V	F(V)	dF/dV	Dif %	xi	yi	amix	Z	δi	ln φi	φi	ln ϒi	ϒi
	1	0.2	0.2318	0.1763	1.296	0.989	0.7728	1	-0.0728539622	-0.195192908	-	0.2299	0.1776	16997822.827013984	0.951	1.431032692752719	-2.0350146191815778E-2	0.980	0.58526178806308415	1.795
	2	0.2	0.1623	0.2281	4.389	0.945	1.3449	0.6268	-0.0086069582	-0.1574543722	59.6	0.1671	0.2247	bmix	F(Z)	1.8034697498619709	-3.8147314260517533E-2	0.963	-5.197540911534082E-2	0.949
	3	0.2	0.1936	0.2047	2.860	0.951	1.0527	0.5721	-0.0000539123	-0.1556102541	9.6	0.1941	0.2044	50.702778226345828	-0.0000001758	2.1018220965500816	-5.28840271324372E-2	0.948	0.10801284611614759	1.114
	4	0.2	0.2710	0.1471	1.454	0.967	0.5553	0.5717	-0.0000000016	-0.1556010042	0.1	0.2682	0.1489	A	h	2.4315354678852232	-6.9327012218448322E-2	0.933	0.11339126023440427	1.120
	5	0.2	0.1414	0.2437	4.344	0.917	1.7365	0.5717	0	-0.1556010039	0.0	0.1407	0.2444	5.1729329801156555E-2	5.1263761309889386E-3	2.2460982075476066	-5.89920439511206E-2	0.943	0.22458618708501832	1.252
	0.5717	0	-0.1556010039	0	x	y	B
	δV (%)	0.22882914469891424	1	1	4.8768604155909655E-3
	4ª iteração
	#	zi	xi	yi	Psat i (bar)	φisat	Ki	V	F(V)	dF/dV	Dif %	xi	yi	amix	Z	δi	ln φi	φi	ln ϒi	ϒi
	1	0.2	0.2299	0.1776	1.296	0.989	0.7728	1	-0.0729839589	-0.1958592643	-	0.2299	0.1777	16997480.489353355	0.951	1.4310471035331276	-2.0350480851604708E-2	0.980	0.58544157351724668	1.796
	2	0.2	0.1671	0.2247	4.389	0.945	1.3461	0.6274	-0.0086053973	-0.1580877169	59.4	0.1669	0.2247	bmix	F(Z)	1.803487911156727	-3.814743014743012E-2	0.963	-5.2118803744760189E-2	0.949
	3	0.2	0.1941	0.2044	2.860	0.951	1.0513	0.5729	-0.0000532783	-0.1562586143	9.5	0.1943	0.2043	50.702147227597244	-0.0000001759	2.1018432623115939	-5.2883966676518138E-2	0.948	0.10788829815178724	1.114
	4	0.2	0.2682	0.1489	1.454	0.967	0.5549	0.5726	-0.0000000015	-0.1562495673	0.1	0.2684	0.1489	A	h	2.4315599539251722	-6.9326756526994382E-2	0.933	0.11336176614951499	1.120
	5	0.2	0.1407	0.2444	4.344	0.917	1.7402	0.5726	0	-0.156249567	0.0	0.1405	0.2444	5.1728287967862364E-2	5.1263065851362604E-3	2.246120826197906	-5.8991900529392086E-2	0.943	0.22469085987254678	1.252
	0.5726	0	-0.156249567	0	x	y	B
	δV (%)	-0.14678698458165623	1	1	4.8767997228059369E-3
	5ª iteração
	#	zi	xi	yi	Psat i (bar)	φisat	Ki	V	F(V)	dF/dV	Dif %	xi	yi
	1	0.2	0.2299	0.1777	1.296	0.989	0.7729	1	-0.0729810521	-0.1958460266	-	0.2299	0.1777
	2	0.2	0.1669	0.2247	4.389	0.945	1.3459	0.6274	-0.0086059199	-0.1580749878	59.4	0.1669	0.2247
	3	0.2	0.1943	0.2043	2.860	0.951	1.0512	0.5729	-0.0000532654	-0.1562466984	9.5	0.1943	0.2042
	4	0.2	0.2684	0.1489	1.454	0.967	0.5549	0.5726	-0.0000000015	-0.1562376604	0.1	0.2684	0.1489
	5	0.2	0.1405	0.2444	4.344	0.917	1.7404	0.5726	0	-0.1562376601	0.0	0.1405	0.2444
	0.5726	0	-0.1562376601	0	x	y
	δV (%)	3.1398851456620747E-3	1	1
	LEGENDA
	Variáveis
	Necessita o Solver
	Atenção!
	Frações resposta