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:

1. If you use results from these spreadsheets in a class or an archival publication, please acknowledge the source, either myself or this website or both.
2. Don’t remove the header information in the sheets
3. While I think the sheets are bug-free, they come with no guarantees.  If you find what you think are bugs, let me know and I’ll look into it.
4. If you add features to a sheet, please email me a copy
5. These are works in progress, use at your own risk!

OK, on with the show:

Chemical reactions:

Modeling of propane oxidation using the 4-step model by Hautman et al. (Combustion Science and Technology, vol. 25, pp. 219-235 (1981).

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:

Unsteady 2D conduction heat transfer including heat generation, convection or temperature boundary conditions

Propulsion and energy:

Ideal and non-ideal performance of turbojet, turbofan and ramjet engines

Ideal and non-ideal performance of Otto-cycle engines, including P-V and T-s diagrams

Ideal and non-ideal performance of steady-flow propulsion engines (turbojets, afterburning turbojets, turbofans, ramjets), including P-V and T-s diagrams

1D compressible flows: Rayleigh and other diabatic processes, isentropic, Fanno, and normal shocks