Login [ Register ]. Username: Password: Autologin: Don't have an account?
Register now to chat, post, use our tools, and much more. KermMartian Site Admin Posts: This one is pretty straightforward; I found out how to do this while helping someone double-check an assignment.
Calculating bubble point and dew point can be extremely tricky by hand if you are given a fixed total pressure P instead of a fixed temperature T, as iterative methods must be used. Luckily, Excel can rapidly perform iterative analysis using the Goal Seek function.
Monday, October 1, 2012
The other key is numeric equations for vapor pressure at a given temperature for a wide variety of substances, which can be found on wikipedia and, this person informs me, are derived from solutions and refinements to Antoine's Equation.
Simply search "substance data page " on Google, and the appropriate Wikipedia page should be the first result. For example, "Benzene data page " leads appropriately to Benzene data page. I suppose you could simply search Wikipedia, but I'm not quite up to the task. Anyway, in order to do this, you'll need to know three sets of information: 1 The constant pressure P of the mixture 2 The mole percent composition x i or y i of each component i of the mixture.
These should sum to 1. If not, something is wrong. Note that in my spreadsheet below, I called it P sat , the saturated pressure.
Same thing. Check out the image below for how I laid out my spreadsheet.
I'll explain how it works in a second. The P sat column the sets of equations from Wikipedia, with the T in deg-C plugged in; it returns a value in mmHg.
I got it woiking. Have your own thoughts to add to this or any other topic?
Free Pipe Marketing Guide
Want to ask a question, offer a suggestion, share your own programs and projects, upload a file to the file archives, get help with calculator and computer programming, or simply chat with like-minded coders and tech and calculator enthusiasts via the site-wide AJAX SAX widget?
Registration for a free Cemetech account only takes a minute.
Page 1 of 1. You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum.
Online Users. There are users online: 10 members and guests. You must log in to view SAX chat widget.