[ p_ws = 0.61094 \cdot \exp\left( \frac17.625 \cdot T_dbT_db + 243.04 \right) ] where ( T_db ) is in °C, result in kPa. 1. Humidity ratio from vapor pressure
Start with the direct formulas (T_db, RH → all outputs). Then add inverse solving via Goal Seek. Finally, if you find yourself repeatedly computing wet‑bulb or dew point, invest an afternoon in writing VBA functions—you will never need a paper chart again. Word count: approx. 1,950 psychrometric chart calculator excel
| Known 1 | Known 2 | Solve for → | Method | |---------|---------|-------------|--------| | T_db, RH | All others | Direct | | T_db, W | RH | Inverse via ( p_w = (W \cdot P)/(0.62198+W) ) then RH = 100*p_w/p_ws | | T_db, T_wb | W, RH, h, v | Iterative (solve Carrier equation) | | T_db, h | W, RH, T_wb | Quadratic from enthalpy equation | | T_dp, T_db | RH, W | RH = p_ws(T_dp)/p_ws(T_db) *100 | [ p_ws = 0
=1.006*B3 + B7*(2501 + 1.86*B3) Cell B9: Then add inverse solving via Goal Seek
[ 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.