## Microsoft Excel Based Numerical Solution Of Linear, Homogeneous 1 D Transient Partial Differential Equations

Conference

2003 Annual Conference

Location

Nashville, Tennessee

Publication Date

June 22, 2003

Start Date

June 22, 2003

End Date

June 25, 2003

ISSN

2153-5965

Conference Session

Computed Simulation and Animation

Page Count

10

Page Numbers

8.851.1 - 8.851.10

DOI

10.18260/1-2--12441

Permanent URL

https://peer.asee.org/12441

3227

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

Session 2320

MICROSOFT EXCEL-BASED NUMERICAL SOLUTION OF LINEAR, HOMOGENEOUS 1D TRANSIENT PARTIAL DIFFERENTIAL EQUATIONS

Mohan A. Ketkar Gopal B. Reddy Prairie View A&M University University of Houston Prairie View, TX 77446 Houston, TX 77204

ABSTRACT

Many transient phenomenons are mathematically described and simulated by the homogeneous, parabolic partial differential equations. Irregular and non-linear boundary conditions pose formidable difficulties to engineers to obtain closed form (exact) solutions.

In this paper, a procedure is outlined to make use of Microsoft Excel software to solve these differential equations by converting them into finite difference equations employing explicit and implicit techniques.

The advantages of this study are to apply universally available Microsoft Excel to solve fairly complex engineering problems. The method lends itself as a powerful tool to Engineering students to design and perform parametric analysis by employing simple, quick techniques without having to acquire specialized and sometimes expensive software packages.

A case study is presented where the time history of temperature in a one-dimensional heat transfer problem is analyzed. Finite difference techniques are used to solve the differential equations. Initially the equations are solved using an explicit method and the same problem is also solved using an implicit method. Step by step procedure to generate Excel worksheet is described.

Results obtained with the two numerical methods are compared with analytical results. Effects of grid size and time interval on the accuracy of the results are graphically presented.

INTRODUCTION

Exact analytical solutions of the partial differential equations describing various transient systems and processes are cumbersome and sometimes complex, and time consuming. The difficulty is compounded, if not impossible, when shapes of irregular and non-linear boundaries are encountered. Due to these complex procedures and solutions, the Engineering students, do not take full advantage of parametric study in the design and analysis of the engineering systems. Numerical solution of some such differential equations and the tools to generate these solutions

“Proceedings of the 2003 American Society for Engineering Education Annual Conference & Exposition Copyright © 2003, American Society for Engineering Education”

Ketkar, M., & Reddy, G. (2003, June), Microsoft Excel Based Numerical Solution Of Linear, Homogeneous 1 D Transient Partial Differential Equations Paper presented at 2003 Annual Conference, Nashville, Tennessee. 10.18260/1-2--12441

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: © 2003 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