Psych: An Open Source Psychrometric Plug-in for Microsoft Excel by Kevin Brown
- Minute-by-minute psychrometric calculations
- Open Source/Public Domain
- Find Wet Bulb depression, absolute humidity, Enthalpy (measure of internal energy), water vapor pressure, specific volume, moist air density
Psych is an Excel-Plugin or function that will calculate properties of moist air. Properties include wet bulb, dew point, RH, humidity ratio, vapor pressure, degree of saturation, enthalpy, specific volume of dry air, or moist air density based upon pressure, temperature, and one other parameter. This other parameter can be wet bulb, dew point, RH, humidity ratio or enthalpy.
Psych uses only equations from the ASHRAE 2005 Fundamentals Handbook, chapter 6. Please check the code for in-line documentation. Once installed, access the code by clicking on the “Developer Tab” then click “Visual Basic” in the “Code” group [for Excel 2007 and 2010].
Compatible with Microsoft Excel 2007 and 2012
(Right Click and select “Save As”. 3MB Zip file. 4 documents: psych.xlam, ASHRAE2005Ch6_Fair Use.pdf, Psych as raw text.txt, PsychManual.pdf)
(Right Click and select “Save As”. 14.2MB xlsm file.)
R22 Calc: An Open Source LabView subVI to Calculate Saturation Temperature by Kevin Brown
The purpose of this LabView subVI is to calculate saturation temperature given absolute pressure of R-22. There are many equations availible for saturation pressure given temperature. This simply solves a simple one from DuPont for the Temperature using Newton-Ralphson method. Saturation temperature is needed to calculate superheat and subcooling. There is more documentation on the front panel.
R-22 is a pure substance, and is not a mixture. The saturation temperature is the same for boiling and condensing refrigerant
(Right Click and select “Save As”. 112KB Zip file. 1 document: R22_Sat_Temp.vi)
(Right Click and select “Save As”. 3.5MB PDF file.)