Buscar

Excel para Construção diagramas de ELV com cálculos de pto de bolha


Continue navegando


Prévia do material em texto

ELV Pbolha (Tcte)
			Psat
	Clorofórmio	1	69.36
	4-Dioxano	2	15.79
		Dados Experimentais
		T [K]	P [kPa]	x1	y1
		323.15	15.79	0	0
		323.15	17.51	0.0932	0.1794
		323.15	18.15	0.1248	0.2383
		323.15	19.3	0.1757	0.3302
		323.15	19.89	0.2	0.3691
		323.15	21.37	0.2626	0.4628
		323.15	24.95	0.3615	0.6184
		323.15	29.82	475	0.7552
		323.15	34.8	0.5555	0.8378
		323.15	42.1	0.6718	0.9137
		323.15	60.38	0.878	0.986
		323.15	65.39	0.9398	0.945
		323.15	69.35	1	1
		T [K]	x1	x2	ln γ1	 γ1	ln γ2	 γ2	P [kPa]	 y1
		323.15	0	1	-0.7958811588	0.4511834954	0	1	15.79	0
			0.05	0.95	-0.745351781	0.4745673268	-0.0013068108	0.9986940427	16.6267094777	0.0989852798
			0.1	0.9	-0.6948924383	0.4991281322	-0.0054109035	0.9946037091	17.596266035	0.1967435999
			0.15	0.85	-0.6445692011	0.5248886149	-0.0126146545	0.9874645768	18.7141969662	0.2918073994
			0.2	0.8	-0.5944593797	0.5518608324	-0.0232610428	0.9770074097	19.9969710672	0.3828286515
			0.25	0.75	-0.5446536628	0.5800426389	-0.0377406115	0.9629626899	21.4618250135	0.4686432469
			0.3	0.7	-0.4952587404	0.6094132071	-0.0564999099	0.9450665696	23.1264908062	0.5483179493
			0.35	0.65	-0.4464005399	0.6399274043	-0.0800517971	0.9230685328	25.0087915524	0.6211766623
			0.4	0.6	-0.3982282472	0.6715087402	-0.1089881044	0.8967410847	27.1260635235	0.6868058268
			0.45	0.55	-0.3509193387	0.7040405404	-0.143995311	0.8658918082	29.4943507554	0.7450414328		 Λ 12	2.407
			0.5	0.5	-0.3046859271	0.7373549213	-0.1858741048	0.8303781291	32.1273039981	0.7959419399		 Λ 21	0.9175
			0.55	0.45	-0.2597828328	0.7712190511	-0.2355639984	0.7901250947	35.0346982225	0.8397521844
			0.6	0.4	-0.2165179427	0.8053180852	-0.2941745952	0.7451463811	38.2204619777	0.876863222
			0.65	0.35	-0.1752656368	0.8392340597	-0.3630256982	0.6955685584	41.6800879868	0.9077722763
			0.7	0.3	-0.1364843791	0.8724199481	-0.4436993242	0.641658323	45.3972687977	0.9330458515
			0.75	0.25	-0.1007400368	0.9041680528	-0.5381079609	0.5838518786	49.3395773957	0.9532878996
			0.8	0.2	-0.0687371928	0.9335719973	-0.6485853091	0.5227848328	53.4529974895	0.9691139023
			0.85	0.15	-0.0413617937	0.9594819326	-0.7780086526	0.4593197664	57.6551156858	0.9811309221
			0.9	0.1	-0.0197401569	0.9804534043	-0.9299665104	0.394566924	61.8268444821	0.9899231284
			0.95	0.05	-0.0053220522	0.9946920849	-1.1089924042	0.3298911907	65.8026999508	0.9960419695
			1	0	0	1	-1.3208973009	0.2668957087	69.36	1
0	0.05	0.1	0.15	0.2	0.25	0.3	0.35	0.4	0.45	0.	5	0.55000000000000004	0.6	0.65	0.7	0.75	0.8	0.85	0.9	0.95	1	15.79	16.626709477669703	17.596266034989139	18.714196966243275	19.996971067164964	21.46182501349994	23.12649080623893	25.008791552399437	27.126063523484071	29.494350755390236	32.127303998125498	35.03469822250414	38.220461977741174	41.680087986813959	45.397268797692419	49.33957739566511	53.452997489464046	57.655115685796936	61.826844482146662	65.802699950757997	69.36	0	9.8985279776644342E-2	0.19674359992058685	0.29180739942577838	0.3828286514827885	0.46864324687554704	0.54831794925964783	0.6211766623380417	0.68680582683227354	0.74504143282510582	0.79594193993775841	0.83975218440486765	0.87686322196490074	0.90777227631618096	0.93304585151485131	0.9532878996461428	0.96911390231483863	0.98113092214287789	0.98992312840344587	0.99604196947517432	1	15.79	16.626709477669703	17.596266034989139	18.714196966243275	19.996971067164964	21.46182501349994	23.12649080623893	25.008791552399437	27.126063523484071	29.494350755390236	32.127303998125498	35.03469822250414	38.220461977741174	41.680087986813	959	45.397268797692419	49.33957739566511	53.452997489464046	57.655115685796936	61.826844482146662	65.802699950757997	69.36	
ELV Tbolha (Pcte)
						A	B	C
	P	1	atm	Comp 1	acetona	4.42448	1312.253	-32.445	P em bar	T em K
		1.01325	bar	Comp 2	methanol	5.20409	1581.341	-33.5	P em bar	T em K
		Experimental 
	T de partida: dados experimentais	T (ºC)	x1	y1
	337.67	64.52	0	0
		62.86	0.05	0.108
		61.52	0.1	0.193
		59.44	0.2	0.327
		57.94	0.3	0.435
		56.94	0.4	0.516
		56.17	0.5	0.592
		55.37	0.7	0.728
		55.26	0.8	0.798
		55.5	0.9	0.888
		55.76	0.95	0.941
		56.09	1	100
	P	101.325	kPa
					Lei de Raould Modificada								erro
	T (ºC) 	T(K)	x1	x2	ln γ1	 γ1	ln γ2	 γ2	P1sat	P2sat	P(kPa)	y1	(P-101,325)²
	64.5488614019	337.6988614019	0	1	0.623974765	1.8663315479	0	1	133.5331991635	101.3236698221	101.3236698221	0	0.0000017694
	62.8737087633	336.0237087633	0.05	0.95	0.5627984723	1.7555785703	0.001566951	1.0015681793	126.4351707337	94.8257160581	101.3240426062	0.1095331723	0.0000009166
	61.5023132428	334.6523132428	0.1	0.9	0.5050888032	1.6571326725	0.0062446687	1.0062642073	120.8515402437	89.7682029395	101.3241802017	0.1976497964	0.0000006721
	60.36886503	333.51886503	0.15	0.85	0.4507491215	1.5694874821	0.014006282	1.0141048296	116.3871599188	85.7600014442	101.3244154865	0.270420791	0.0000003417
	59.4240983257	332.5740983257	0.2	0.8	0.3996943205	1.4913687471	0.0248351605	1.025146122	112.767733907	82.5342964415	101.323425952	0.3319632601	0.0000024776
	58.6317763519	331.7817763519	0.25	0.75	0.3518502909	1.421695667	0.0387247362	1.0394843119	109.8023705441	79.9078516454	101.3236072425	0.3851658036	0.0000019398
	57.9636974969	331.1136974969	0.3	0.7	0.3071534857	1.3595496235	0.0556784108	1.0572576264	107.3508863075	77.7479101536	101.3243567828	0.4321237115	0.0000004137
	57.3981656407	330.5481656407	0.35	0.65	0.2655505738	1.3041488083	0.0757095469	1.0786492316	105.310188404	75.9578850779	101.3247991892	0.4744056266	0.0000000403
	56.9186804342	330.0686804342	0.4	0.6	0.2269981789	1.2548275828	0.0988415427	1.103891366	103.6044842725	74.4673548914	101.3246278934	0.5132247402	0.0000001385
	56.5128698317	329.6628698317	0.45	0.55	0.1914627024	1.2110196642	0.1251079915	1.1332708301	102.1782651069	73.2250544151	101.3240497435	0.5495531404	0.000000903		 Λ 12	0.732
	56.171714369	329.321714369	0.5	0.5	0.1589202265	1.1722444289	0.1545529283	1.167136051	100.9915165305	72.1941523952	101.3235702742	0.5842013971	0.0000020441		 Λ 21	0.688
	55.8889839739	329.0389839739	0.55	0.45	0.1293564987	1.1380957816	0.1872311671	1.2059060186	100.0164211569	71.3490361118	101.3236512838	0.6178769326	0.000001819
	55.6608450967	328.8108450967	0.6	0.4	0.1027669994	1.10823316	0.223208734	1.2500814811	99.2351324113	70.6731565925	101.3242803332	0.6512298771	0.0000005179
	55.4857047385	328.6357047385	0.65	0.35	0.0791570931	1.0823743423	0.2625634045	1.3002589079	98.6386784506	70.1579363461	101.324802154	0.6848923668	0.0000000391
	55.3644105609	328.5144105609	0.7	0.3	0.0585422691	1.0602898023	0.3053853511	1.3571478807	98.227293613	69.8029660618	101.3244626449	0.7195160626	0.0000002888
	55.3008068062	328.4508068062	0.75	0.25	0.0409484763	1.0417984268	0.3517779148	1.4215927739	98.012125294	69.6174304773	101.3235674833	0.7558128909	0.0000020521
	55.3023244941	328.4523244941	0.8	0.2	0.0264125588	1.0267644618	0.4018585115	1.494599849	98.0172551386	69.6218528369	101.3238695222	0.7946055333	0.000001278
	55.3800426064	328.5300426064	0.85	0.15	0.0149828027	1.0150956075	0.4557596913	1.5773712432	98.2802341387	69.8486289572	101.3258416887	0.836896664	0.0000007084
	55.5488207907	328.6988207907	0.9	0.1	0.0067196046	1.0067422318	0.5136303674	1.6713478011	98.8532919225	70.3432444456	101.3246080463	0.88396893	0.0000001536
	55.8336448702	328.9836448702	0.95	0.05	0.0016962758	1.0016977153	0.5756372401	1.7782633467	99.8264532277	71.1845942915	101.3253813577	0.9375354165	0.0000001454
	56.2682277677	329.4182277677	1	0	0	1	0.641966441	1.9002138663	101.32612027	72.4845553994	101.32612027	1	0.000001255
												Somatório	0.0000199142
0	0.05	0.1	0.15	0.2	0.25	0.3	0.35	0.4	0.45	0.5	0.55000000000000004	0.6	0.65	0.7	0.75	0.8	0.85	0.9	0.95	1	64.548861401869999	62.873708763260993	61.502313242831235	60.368865030007214	59.424098325659259	58.631776351942676	57.963697496883469	57.39816564072072	56.918680434215844	56.512869831682622	56.171714368995708	55.88898397391506	55.66084509670884	55.48570	4738531524	55.364410560913427	55.300806806189087	55.302324494052755	55.380042606368647	55.548820790680907	55.833644870241926	56.2682277677211	0	0.10953317226983128	0.197649796390802850.27042079102089517	0.33196326012347788	0.3851658036046578	0.43212371151362799	0.47440562657176572	0.51322474018925157	0.54955314039983461	0.58420139706044993	0.61787693258646181	0.65122987708937563	0.68489236679246535	0.71951606259632372	0.75581289091594683	0.79460553326766825	0.83689666398863605	0.8839689299	6565224	0.9375354165056653	1	64.548861401869999	62.873708763260993	61.502313242831235	60.368865030007214	59.424098325659259	58.631776351942676	57.963697496883469	57.39816564072072	56.918680434215844	56.512869831682622	56.171714368995708	55.88898397391506	55.66084509670884	55.485704738531524	55.364410560913427	55.300806806189087	55.302324494052755	55.380042606368647	55.548820790680907	55.833644870241926	56.2682277677211