This project is an embellishment of the common textbook problem of approximating a runner as a cylinder in cross-flow.
We estimate both the sensible and latent heat transfer from the runner as a function of the runner’s speed relative to the wind, ambient air temperature and relative humidity. We will use the Churchill-Bernstein correlation to find appropriate convective heat and mass transfer coefficients. VBA functions for the needed properties of air and water makes it simple to test a wide range of parameters without having to look up all the needed properties (some 11 of them) manually.
Excel Template including VBA functions