Psychrometric Chart Calculator Excel [TOP]

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

=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: psychrometric chart calculator excel

=1.006*B3 + B7*(2501 + 1.86*B3) Cell B9: psychrometric chart calculator excel

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

[ v = \frac0.2871 \cdot (T_db + 273.15)P \cdot (1 + 1.6078 \cdot W) ] where 0.2871 = gas constant for dry air (kJ/kg·K), ( P ) in kPa.

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