Asee peer logo

Biomedical Engineering Simulation Using Visual Basic Macros In Microsoft Excel

Download Paper |


2007 Annual Conference & Exposition


Honolulu, Hawaii

Publication Date

June 24, 2007

Start Date

June 24, 2007

End Date

June 27, 2007



Conference Session

Laboratories and Computer Simulation in BME

Tagged Division


Page Count


Page Numbers

12.314.1 - 12.314.13



Permanent URL

Download Count


Request a correction

Paper Authors


Lanny Griffin California Polytechnic State University

visit author page

Lanny Griffin received his Ph.D. from the University of California at Davis in Materials Science and Engineering. He also has a BS degree in Mechanical Engineering from California Polytechnic State University in San Luis Obispo. Currently, he is a Professor of Biomedical Engineering at California Polytechnic State University in San Luis Obispo. He is also on the Mechanical Engineering faculty of the US Military Academy at West Point as an Army Reserve Officer. Dr. Griffin’s research interests are in bone mechanics and biomaterials and has been the Principal Investigator of several projects from the Army, DOD, and NIH.

visit author page

author page

Robert Crockett California Polytechnic State University

Download Paper |

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract


I. Introduction

Biomedical engineering analyses are often more complex than typically found in other engineering disciplines due to the inherent variation and uncertainty associated with living systems. Attempting to find the optimum solution to complex problems almost always is done using numerical analysis techniques, such as finite element or finite difference solutions.

Educationally, distance learning classes offer unique challenges to teaching of numerical analysis for engineers. While it is very common to use programs such as MATLAB for teaching numerical analysis, licensing this type of program is expensive and therefore not always available at the distance learning site. Using more conventional programming languages such as C or FORTRAN are also not as useful for distance learning for the same reason that compliers are expensive and not generally accessible to industrial distance learning sites and freeware compilers are not always robust enough for class work where time is limited. The need for a robust programming platform for industrial partners at distance learning sites is critical to avoid unnecessary learning curves. This is where using Microsoft Excel has a distinct advantage over other programming platforms as a tool for teaching numerical analysis. First of all, Excel is familiar. Secondly, Excel is ubiquitous. Lastly, Excel is capable of programming using Visual BASIC, for which the learning curve is not excessive as long as an individual has had a structured programming course.

For a reasonably complete course in numerical analysis, topics such as the solution of linear systems, non-linear systems, curve fitting, numerical integration, and solutions to ordinary and partial differential equations are usual topics. In order to create a course that is interesting and relevant to biomedical engineering students, having projects that are based on bioengineering problems is necessary. Fortunately, there are numerous problems that can be addressed which are well-posed.

Finding a textbook can be somewhat challenging since most numerical analysis books are written for MATLAB or C. Most of the Excel textbooks are not well-suited to a formal numerical analysis class because they are written to address typical spreadsheet usage rather than customization by macros [1]. We ultimately settled on using a newly published book entitled, Numerical Analysis for Biomedical Engineers [2] even though it was written for MATLAB. In this case, MATLAB script could be treated as pseudo-code and easily ported to Visual BASIC in Excel.

II. Learning Objectives and Outcomes

The numerical engineering class was designed for juniors to first year graduate students. The class is designed to be delivered both in a distance and local classroom setting since approximately 25 percent of the class is made up of engineers obtaining their Master’s degree off-site. To pique student interest, all numerical lab exercises and homework were derived from

Griffin, L., & Crockett, R. (2007, June), Biomedical Engineering Simulation Using Visual Basic Macros In Microsoft Excel Paper presented at 2007 Annual Conference & Exposition, Honolulu, Hawaii. 10.18260/1-2--2839

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2007 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015