Full Content is available to subscribers

Subscribe/Learn More  >

Computational Methods Using Excel/VBA for Engineering Applications

[+] Author Affiliations
David G. Lilley

Oklahoma State University, Stillwater, OK

Paper No. DETC2006-99172, pp. 487-490; 4 pages
  • ASME 2006 International Design Engineering Technical Conferences and Computers and Information in Engineering Conference
  • Volume 3: 26th Computers and Information in Engineering Conference
  • Philadelphia, Pennsylvania, USA, September 10–13, 2006
  • Conference Sponsors: Design Engineering Division and Computers and Information in Engineering Division
  • ISBN: 0-7918-4257-8 | eISBN: 0-7918-3784-X
  • Copyright © 2006 by ASME


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: • Linear and Nonlinear Sets of Equations; • Interpolating Polynomials; • Differentiation and Integration; • Solution of ODEs – Initial and Boundary Value Problems; • Solution of PDEs – Elliptic, Parabolic and Hyperbolic; • 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.

Copyright © 2006 by ASME



Interactive Graphics


Country-Specific Mortality and Growth Failure in Infancy and Yound Children and Association With Material Stature

Use interactive graphics and maps to view and sort country-specific infant and early dhildhood mortality and growth failure data and their association with maternal

Citing articles are presented as examples only. In non-demo SCM6 implementation, integration with CrossRef’s "Cited By" API will populate this tab (http://www.crossref.org/citedby.html).

Some tools below are only available to our subscribers or users with an online account.

Related Content

Customize your page view by dragging and repositioning the boxes below.

Related eBook Content
Topic Collections

Sorry! You do not have access to this content. For assistance or to subscribe, please contact us:

  • TELEPHONE: 1-800-843-2763 (Toll-free in the USA)
  • EMAIL: asmedigitalcollection@asme.org
Sign In