Psychrometric — Chart Calculator Excel

– requires iterative solution of the carrier equation:

This write‑up explains the science behind psychrometric calculations, the mathematical formulas required, step‑by‑step construction of an Excel calculator, practical applications, and advanced automation techniques. Before building the calculator, we must define the key properties of moist air, treating it as a mixture of dry air and water vapor.

[ W = 0.62198 \cdot \fracp_wP - p_w ] where ( P ) is total atmospheric pressure (typically 101.325 kPa at sea level). The factor 0.62198 is the ratio of molecular weights of water (18.01528) to dry air (28.9645). psychrometric chart calculator excel

[ RH = \fracp_wp_ws(T) \times 100% ]

– solved iteratively from ( p_ws(T_dp) = p_w ). – requires iterative solution of the carrier equation:

=$B$2*0.62198*B6/($B$2-B6) Wait – careful: ( W = 0.62198 * p_w / (P - p_w) ). So correct formula:

=0.61094*EXP(17.625*B3/(B3+243.04)) Cell B6: The factor 0

=0.2871*(B3+273.15)/B2 * (1+1.6078*B7) Because dew point requires solving ( p_ws(T_dp) = p_w ), use Excel’s Goal Seek or implement an inverse approximation. A decent direct approximation (for 0–60°C) is:

For (pressure in kPa, temperature in K):

[ \ln(p_ws) = \fracC_8T + C_9 + C_10 T + C_11 T^2 + C_12 T^3 + C_13 \ln(T) ]

(SI, kJ/kg dry air )