Excel Workbooks Heat Transfer Two-Dimensional, Steady-State Conduction Periodic Conduction in a Semi-Infinite Body Planck’s Law for Spectral Blackbody Emissive Power VBA Functions for Properties of Air and Water as Functions of Temperature Internal-Flow Forced Convection Correlations Iteration Demonstrations Radiation View Factors (both analytical solutions and Nusselt Unit Sphere Method) Radiosity Method for Radiative Exchange Involving Diffuse-Gray Surfaces Analytical Solution for Efficiency of Straight, Annular Fins Analytical Solution for Transient Conduction in a Plane Wall Conduction Shape Factors DC Networks for Steady-State Conduction and Simple Radiative Transport Problems Forced Convection over Flat Plate Correlations Effectiveness-NTU Relations for Heat Exchangers Forced Convection in Tube Banks Forced Convection in Rough Pipes Conduction in a Nuclear Fuel Rod Steady-Conduction in an Insulated, Volumetrically Heated Cylinder HTTSimpleFin – Extended Surface Heat Transfer View Factors for Perpendicular and Parallel Rectangles Fluid Mechanics Solution of Blasius Equation Using Shooting Advection of a Passive Scalar in One and Two Dimensions Wingtip Vortex Motion above a Runway 1976 U.S. Standard Atmosphere One-dimensional Wave Equation Velocity Triangles for Turbomachinery Projectile Motion with Air Resistance Using 4th Order Runge-Kutta Elliptic Grid Generation for Odd Geometries One-Dimensional Compressible Flows (isentropic flow with area change, normal shocks, Fanno line, Rayleigh line) Oblique Planar Shocks Vortex Panel Method for a Lifting 2D Airfoil Thermodynamics Brayton (jet engine) Cycle Template Rankine Cycle Template Otto (Spark Ignition) Cycle Template Diesel (Compression Ignition) Cycle Template Humphrey Cycle (a Variation of the Brayton Cycle) Vapor-Compression Refrigeration Cycle Mollier (Enthalpy-Entropy) Diagram Properties of Fluids Using CoolProp Excel Add-in Other Thermodynamics Applications Atkinson Cycle Template General Rankine Cycle Template Direct Solution of Linear Equations HTTdemosub: A spreadsheet demonstrating a lot of features of Excel and VBA Primer Animated, Excel/VBA Valentine for a Geeky Significant Other Solution of a Tridiagonal System of Linear Equations Home Introduction General Background Software Modules for Heat Transfer 1-D Transient Conduction 2-D Steady-State Conduction Transient Conduction in Cylinder External Flows Internal Flows Porous Media Convection Analysis of Extended Surfaces (Fins and Heat Sinks) Heat Exchanger Design and Performance Natural Convection next to a Heated, Vertical Flat Plate Fourier’s Law, Conductivity and Boundary Conditions Excel Workbooks Heat Exchanger Photos Thermal Systems Extended Surface Photos Student Projects Contact for more information