Edwards, R., & Lobaugh, M. (2014, June), Using Excel to Implement the Finite Difference Method for 2-D Heat Transfer in a Mechanical Engineering Technology Course  Paper presented at 2014 ASEE Annual Conference & Exposition, Indianapolis, Indiana. 10.18260/1-2--23261

\bibitem{asee_peer_23261}
  Edwards, R., \& Lobaugh, M. (2014, June), \emph{Using Excel to Implement the Finite Difference Method for 2-D Heat Transfer in a Mechanical Engineering Technology Course}
  Paper presented at 2014 ASEE Annual Conference \& Exposition, Indianapolis, Indiana.
  10.18260/1-2--23261

Robert Edwards and Michael Lobaugh.  "Using Excel to Implement the Finite Difference Method for 2-D Heat Transfer in a Mechanical Engineering Technology Course".  2014 ASEE Annual Conference & Exposition, Indianapolis, Indiana, 2014, June.  ASEE Conferences, 2014.  https://peer.asee.org/23261 Internet.  12 Dec, 2024

\bibitem{asee_peer_23261}
  Robert Edwards and Michael Lobaugh.
  "Using Excel to Implement the Finite Difference Method for 2-D Heat Transfer in a Mechanical Engineering Technology Course".
  \emph{2014 ASEE Annual Conference \& Exposition, Indianapolis, Indiana, 2014, June}.
  ASEE Conferences, 2014.
  https://peer.asee.org/23261 Internet.  12 Dec, 2024

@INPROCEEDINGS{asee_peer_23261
author = "Robert Edwards and Michael Lobaugh"
title = "Using Excel to Implement the Finite Difference Method for 2-D Heat Transfer in a Mechanical Engineering Technology Course"
booktitle = "2014 ASEE Annual Conference \& Exposition"
year = "2014"
month = "June"
address = "Indianapolis, Indiana"
publisher = "ASEE Conferences"
note = {https://peer.asee.org/23261}
number = {10.18260/1-2--23261}
}

TY  - CPAPER
AB  -     Using Excel to Implement the Finite Difference Method for 2-D Heat         Transfer in a Mechanical Engineering Technology CourseAbstract:Multi-dimensional heat transfer problems can be approached in a number of ways.Sometimes an analytical approach using the Laplace equation to describe the problem canbe used. This involves finding the solution of differential equations, which may bereasonable for Mechanical Engineering Technology (MET) students. However, thesestudents are not always particularly proficient in using this approach. Also, the analysiscan get quite complex depending on boundary conditions, often involving advancedmathematics using Bessel functions, Fourier series and other special functions. Graphicalmethods might be used, but their usefulness extends primarily to discussions about therelationships between isotherms and heat flow paths. Shape factors and otherapproximations can also be useful in certain instances. None of these seem to provide anespecially good approach for MET students.A more practical approach for these students is the use of numerical methods. The finitedifference method seems to provide a good approach for MET students. Using thismethod a student can model fairly complex two-dimensional problems with a variety ofboundary conditions using a simple spreadsheet.This paper presents information on how this method is used at XXX in a first course inheat transfer for MET students. The method is used to aid in presenting the theory, aswell as for a laboratory exercise. The basic equations for a variety of node types areincluded, as well as equation modifications that are used to account for several thermalloading and boundary conditions. The lectures are reinforced with homework practiceproblems before the more involved lab exercise. Finally, the lab exercise is included.The exercise is designed to give the students practice using the method.
AU  - Robert Edwards
AU  - Michael Lobaugh
CY  - Indianapolis, Indiana
DA  - 2014/06/15
PB  - ASEE Conferences
TI  - Using Excel to Implement the Finite Difference Method for 2-D Heat Transfer in a Mechanical Engineering Technology Course
UR  - https://peer.asee.org/23261
DO  - 10.18260/1-2--23261
ER  -