Question: Hello, I have a thermodynamics II final project using the VBA program in excel to find the dew temperature and liquid compositon then , make

Hello, I have a thermodynamics II final project using the VBA program in excel to find the dew temperature and liquid compositon then , make the txy diagram with resulted data on excel.

I desperately need you guys help..

Quesiton. I want to know the VBA code in excel to calculate the DEW T and x(liquid) composition and I have to make the Txy block diagram in excel.

Here is given information/condition below.

  • pressure : 760mmHg
  • y(vapor) composition : 0.4
  • binary-component: (1) 2-Methyl-1-Propanol , (2) 2-Chloroethanol
  • use the modified Raoult's law formation
  • use NRTL equation as GE model (for binary composition)

Hello, I have a thermodynamics II final project using the VBA programin excel to find the dew temperature and liquid compositon then ,

ln1=x22(21(x1+x2G21G21)2+(x2+x1G12)2G1212)ln2=x12(12(x2+x1G12G12)2+(x1+x2G21)2G2121)12=RTb1221=RTb21G12=exp(12)G21=exp(21) Data sheet log10Pisat[mmHg]=AT[C]+CBR=1.98721cal/molK

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!