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 the website (http://ronney.usc.edu/spreadsheets) 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