Bubble Point and Dew Point Calculations

The bubble point of a system is the temperature at which a liquid mixture begins to vaporize.  The dew point is the temperature at which liquid begins to condense out of the vapor. If there is enough volume in the fluid, the bulk fluid concentration will remain unchanged after the first small bubble or drop of liquid is formed.  This calculation is important for vapor liquid equilibrium processes such as distillation, adsorption and stripping. The program uses empirical data of vapor liquid equilibrium as a function of temperature and iteratively finds temperature with the Newton Raphson method.  There is also a version using the Excel goal seek to demonstrate a easier way to program this.

Notations

T - Temperature (OK)
i - Subscript for each component i
n- Subscript for each iteration
K - vapor liquid equilibrium constant
x - mole Fraction in liquid phase
y - mole fraction in vapor phase
F(T) - Newton Raphson function

Also there is a PDF, which we found in google search and thought it might be useful for all readers out here. So, you can read this PDF below:

Bubble and Dew Point Calculations in Multicomponent and Multireactive Mixtures

So, in case if you might like to get above given spreadsheet, you can get it from here. And for the above embedded PDF, you can get it from this Google search result. Just make sure, you don't have dropbox blocked at your work place.

Also you might be interested in getting following stuff:

• Flange Rating Calculator (NPS 0.5 to 24) Workbook Spreadsheet
• Flange Rating Calculator (NPS 26 to 60) Workbook Spreadsheet
• Metric Piping Weight Calculation Spreadsheet Workbook
• Steel Pipe Vessel Data and Dimensions Spreadsheet
• Imperial Piping Weight/Load Calculation Spreadsheet Workbook
• Download Free MaxANSI Piping Handbook for Piping Engineers
• Download Piping Joints HandBook

Get Notified for new Tutorials: *Check your email to confirm your subscription*