Loading...
Please wait, while we are loading the content...
Similar Documents
Using Excel's Goal Seek and Solver Functions as Effective Computational Tools in Solving Heat Transfer Problems
| Content Provider | Semantic Scholar |
|---|---|
| Author | Karimi, Amir |
| Copyright Year | 2009 |
| Abstract | An introductory course in heat transfer coves basic modes of heat transfer, namely conduction, convection and radiation. The analytical solutions to heat transfer problems are typically limited to steady-state one-dimensional heat conduction, simple cases of one dimensional transient conduction, two-dimensional conduction, and calculation of radiation view factors for objects displaying simple geometries. Chart or graph are provided in textbooks to aid students in solving more complex transient or multi-dimensional heat conduction problems. Empirical formulas are usually used for solving heat convection problems. The heat transfer application includes fin design and heat exchanger analysis involving simple flow patterns. Integration of a computational tool in the course is an effective way to aid students in solving more complex problems. Excel which is usually available on almost all desktop or laptop computers, can serve as an effective and inexpensive computational tool in a heat transfer course. In recent publication of papers in the proceeding of the conferences we described how Excel can be used in solving fin and heat exchanger problems. Others have demonstrated the use of Excel in solving boundary layer equations and transient heat conduction problems. This paper focuses on the application of “Solver” and “Goal Seek” functions of Excel to solve heat transfer problems requiring iteration solution process. It presents a summary of several papers previously presented on this topic and provides several examples demonstrating the application of Excel in solving heat transfer problems. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | http://aseegsw.com/past%20Proceedings/FA4-1.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
