Excel spreadsheet models for thermal/fluid problems

 

Paul D. Ronney

Department of Aerospace and Mechanical Engineering

University of Southern California, Los Angeles, CA 90089-1453

http://ronney.usc.edu; ronney@usc.edu

 

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 (preferred gas radiation spreadsheet)

 

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)-(also usable, but not recommended; the SNB model is much more physical)

 

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 Otto-cycle engines, including P-V and T-s diagrams (Note:  this program has a macro needed for solving iteratively when exhaust gas residual is present - 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 exhaust gas residual feature.)

 

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

 

Ideal and non-ideal performance of steady-flow hypersonic propulsion engines (with constant P, T or A heat addition) including P-V and T-s diagrams

 

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

 

You are visitor number 38775 since this counter was installed on 7/7/05.