Excel in ME

1
Excel in ME

• 1-D Transient Heat Conduction Add-in

2
Loading an Add-in

• Download Heat Transfer.xla from
  www.me.ua.edu/excelinme
• Possible to open as a file
• It runs slower
• Need to set Tools?Macros ?Security to Medium or
  Low
• Load as an Add-in
• Faster
• No security problems

3
Loading an Add-in

• Click Browse button to find and load Heat
  Transfer.xla

4
Functions

• Functions return the dimensionless temperature,
  q
• Tslab(xstar, Fo, Bi)
• Tcyl(rstar, Fo, Bi)
• Tsph(rstar, Fo, Bi)
• Function Wizard User Defined

5
Inputs

• Dimensionless length, rstar or xstar
• rstar r / R
• xstar x / L
• Fourier Number - Fo at / L2
• Biot Number - Bi hL / k

L R
6
Semi-Infinite Solid

• TsemiInf(BCtype, x, alpha, t, k, BC)
• BCtype - Boundary condition type
• 1 - Constant Surface Temperature, returns
• 2 - Constant Surface Heat Flux, returns
• 3 - Surface Convection, returns
• x - distance from surface
• alpha - a k / rc m2/s
• t - time
• k - conduction coefficient W/m-K
• Only necessary for BCtype 2 3
• BC - Boundary condition value
• Only necessary for BCtype 2 3
• BCtype 2 - BC q"0, surface heat flux W/m2
• BCtype 3 - BC h, convection coefficient
  W/m2-K