4 replies to this topic

Hello all, I need excel formula for...

1) Using VDW and RK EOS to find the volume in m3
2) The work required to isothermally compress a gas is calculated by integrating over the pressure with respect to volume

For more details please see the attachment and help me....

Attached Files

•  HW%20week%203.pdf   106.16KB   21 downloads

Edited by ilyaskazi, 08 February 2010 - 06:15 AM.

[joerd]

Looking at how the assignment is phrased, it seems like you should already have a spreadsheet with the EOS. Anyway, you can also find one on this site: http://www.cheresources.com/srk.xls
The second question is intriguing: what is XX bar and YY bar?

Hi Joerd, thanks for ur reply.

I am attaching here the excel-sheet... but it seems to me almost crap.
Could you please check and solve for me.

Also can you convert that equation shown in pdf file to excel formula.

Ty,
Ilyas

Attached Files

•  Gas EOS calculator.xls   22KB   29 downloads

[breizh]

Hi ,
let you try these spread sheets .
Hope it helps
Breizh

[rxd]

Hi ,
let you try these spread sheets .
Hope it helps
Breizh

Nice spreadsheet for comparison between the different methods. But what am I to make of the different answers, especially SRK method. Are any of these methods good for custody measurement purposes.