Develop a spreadsheet that computes the values of the compressibility factor as a function of reduced pressure

Question:

Develop a spreadsheet that computes the values of the compressibility factor as a function of reduced pressure for several isotherms of reduced temperature using the Lee-Kesler (1975) equation of state (AIChE J., 21:510). A tedious but straightforward way to do this is to tabulate reduced densities from 0.01 to 10 in the top row and reduced temperatures in the first column. Then, enter the Lee-Kesler equation for the compressibility factor of the simple fluid in one of the central cells and copy the contents of that cell to all other cells in the table. Next, copy that entire table to a location several rows lower. Replace the contents of the new cells by the relation Pr = Z · ρ· Tr. You now have a set of reduced pressures corresponding to a set of compressibility factors for each isotherm, and these can be plotted to reproduce the chart in the chapter, if you like. Copy this spreadsheet to a new one, and change the values of the B, C, D, and E parameters to correspond to the reference fluid. Finally, copy the simple fluid worksheet to a new worksheet, and replace the contents of the compressibility factor cells by the formula: Z = Z0 + ω(Zref  - Z0)/ωref, where the Zref and Z0 refer to numbers in the cells of the other worksheets.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: