Excel spreadsheet models for thermal/fluid problems
I've created a number of Excel spreadsheets in recent years for various engineering problems in the classes I teach or for my research, so I just thought I'd make these available to anyone who finds them useful. Just a few conditions on their use:
OK, on with the show:
Radiation heat transfer:
Gas radiation: transmissivities, emissivities, spectral absorption coefficients, total emission and Planck mean absorption coefficients for CO2, H2O and CO based on the Malkmus Statistical Narrow Band model
Gas radiation: emissivities, absorptivities, Planck mean absorption coefficients and net emission from H2O and CO2 radiation according to the Planck mean model (for optically thin radiation) and the Hottel/Leckner model (for non-optically thin radiation)-
Surface radiation: radiation between 4 (or fewer) gray diffusely or specularly reflecting surfaces surfaces with any combination of specified temperature, specified radiative flux, or specified convection heat transfer coefficient and fluid temperature on each surface. Note: this program has a macro needed for solving iteratively when there is a convection surface condition - don't worry, it's not a macro virus. To be extra safe, you could open the sheet with macros disabled unless you need the convection boundary condition feature.
Conduction heat transfer: