Column G is the coefficient of for each term in the series i.e. in equation 3. Column J is the coefficient of for each term in the series i.e. in equation 7. The data display of roots and coefficients is added to help the student understand the process. The data can be moved off screen if the instructor wishes to hide it. Information on laboratory exercises for heat capacity and thermal conductivity available on request.
Students can make changes to observe how a change in the variables effect the result.
It also gives the student experience in using Excel to solve engineering calculations and exposure to Visual Basic capabilities existing within Excel. Numerical Methods Prentice-Hall, Inc. 1966. Kakac, S. and Y. Yener. Heat Conduction, 2nd ed. Hemisphere Publishing Corporation 1985.