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:
- 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.
- Don't remove the header
information in the sheets
- 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.
- If you add features to a sheet,
please email me a copy
- 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