COMPUTATIONAL METHODS USING EXCELA/BA FOR ENGINEERING APPLICATIONS

摘要

The focus is that Excel/VBA provides a useful platform for engineering calculations in energy engineering. It includes computational methods in the simulation and solution of engineering problems that may or may not have analytical exact mathematical solutions. Emphasis is on the methods and applications, using Excel as the interface for data input and output, tables and figures, and Visual Basic for Applications VBA as the programming language for computations. Fundamental topics of 1. Linear and Nonlinear Sets of Equations 2. Interpolating Polynomials 3. Differentiation and Integration 4. Solution of ODEs -Initial and Boundary Value Problems 5. Solution of PDEs -Elliptic, Parabolic and Hyperbolic 6. Graphics, including Plotting and Data Presentation, and Curve Fitting Connections are made between each topic and a variety of engineering problems and applications. In this approach, it is emphasized how to develop and apply numerical techniques to solve engineering problems.