|
|
|
|
|
|
|
|
|
|
Sample Workbook to demonstrate the use of REFPROP in a Spreadsheet. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dr. Eric W. Lemmon |
| Dr. Mark O. McLinden |
|
| Physical and Chemical Properties Division |
| Physical and Chemical Properties Division |
|
| Theory and Modeling of Fluids Group |
| Experimental Properties of Fluids Group |
|
| 325 Broadway |
| 325 Broadway |
|
| Boulder, CO 80305, U.S.A. |
| Boulder, CO 80305, U.S.A. |
|
Phone: | +1-303-497-7939 | Phone: | +1-303-497-3580 |
|
Fax: | +1-303-497-5224 | Fax: | +1-303-497-5224 |
|
Web: | http://www.boulder.nist.gov/div838/theory.html | Web: | http://FluidProperties.NIST.Gov |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Text of user-specified values in the input cells is blue. |
|
|
|
|
|
|
|
|
|
|
|
Macros must be enabled to calculate properties |
|
|
|
|
|
|
|
|
|
|
|
See the help file in the Refprop graphical interface for additional information on calculating properties |
|
|
|
|
|
|
|
|
|
|
|
Most units shown here use SI, see the help file for other units |
|
|
|
|
|
|
|
|
|
|
|
The comments at the beginning of the Visual Basic code (press Alt-F11) tell how to change the working directories in order for REFPROP to locate the fluid files and the DLL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example: |
|
|
|
|
|
|
|
|
|
|
|
Pure Fluid Calculations |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Fluid: | argon |
|
|
|
|
|
|
|
|
|
|
T | P | r | h | s | Quality |
|
|
|
|
|
|
K | MPa | mol/L | J/mol | J/mol-K | — |
|
|
|
|
|
|
200 | 2 | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
100 | 2 | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
#VALUE! | 1 | #VALUE! | #VALUE! | 100 | #VALUE! |
|
|
|
|
|
|
#VALUE! | 1 | #VALUE! | -4000,00 | #VALUE! | #VALUE! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Two-Phase Calculations |
|
|
|
|
|
|
|
|
|
|
|
Compute properties from given temperature and density. |
|
|
|
|
|
|
|
|
|
|
|
T | P | r | u | h | s | Quality | rSL | rSV | Surf. Tens. |
|
|
K | MPa | mol/L | J/mol | J/mol | J/mol-K | — | mol/L | mol/L | mN/m |
|
|
100 | #VALUE! | 15 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calculate properties given only the saturation pressure. |
|
|
|
|
|
|
|
|
|
|
|
#VALUE! | 0,3 | #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calculate properties given only the saturation temperature. |
|
|
|
|
|
|
|
|
|
|
|
120 | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
|
|
| #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
|
Example: |
|
|
|
|
|
|
|
|
|
|
|
Unit Conversions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Unit system: | cgs |
|
|
|
|
|
|
|
|
|
|
T | P | r | u | h | s | Cv | Cp | w | h | l |
|
K | MPa | g/cm3 | J/g | J/g | J/g-K | J/g-K | J/g-K | cm/s | mPa-s | mW/m-K |
|
100 | 1 | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | #VALUE! |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example: |
|
|
|
|
|
|
|
|
|
|
|
Mixture Calculations |
|
|
|
|
|
|
|
|
|
|
|
System: | 0,6 nitrogen + 0,05 argon + 0,35 oxygen |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
nitrogen,0,6,argon,0,05,oxygen,0,35 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Components | Mole fractions |
|
|
|
|
|
|
|
|
|
|
nitrogen | 0,60 |
|
|
|
|
|
|
|
|
|
|
argon | 0,05 |
|
|
|
|
|
|
|
|
|
|
oxygen | 0,35 |
|
|
|
|
|
|
|
|
|
|
Total | 1,00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mixture properties: |
|
|
|
|
|
|
|
|
|
|
|
r (100 K, 0.1 MPa) | #VALUE! | mol/L |
|
|
|
|
|
|
|
|
|
r (100 K, 1 MPa) | #VALUE! | mol/L |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Example: |
|
|
|
|
|
|
|
|
|
|
|
Predefined Mixture: |
| R410A.MIX |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mixture properties: |
|
|
|
|
|
|
|
|
|
|
|
r (300 K, 10 MPa) | #VALUE! | mol/L |
|
|
|
|
|
|
|
|
|