Excel Advanced Solver for Partial Differential Equations

By Chahid Ghaddar

ExcelWorks

Published on

Abstract

We offer an illustration of PDASOLVE() an Excel Advanced Solver for Partial Differential Equations by Chahid Ghaddar of ExcelWorks (This email address is being protected from spambots. You need JavaScript enabled to view it. ) along with two articles concerning use of the software. ExcelWorks is in the greater Boston MA USA area and one may read about the author at https://excel-works.com/About/Author.htm .

The following are the citations for the two articles (one with a best paper award) provide a more readable narrative on the technique with simple examples including the traditional heat and wave equations.  Both articles are open access and free to download.

Ghaddar, C. K. (2016) "Unlocking the Spreadsheet Utility for Calculus: A Pure Worksheet Solver for Differential Equations", Spreadsheets in Education Vol. 9: Iss. 1,
Download at: http://epublications.bond.edu.au/ejsie/vol9/iss1/5

Ghaddar, C. K. (2016), "Unconventional Calculus Spreadsheet Functions ", International Journal of Mathematical, Computational, Physical, Electrical and Computer Engineering, 10(4).    Download at: http://waset.org/publications/10004374

Empowering Excel with the unique solvers and running the examples, requires downloading and installing a light add-in from excel-works.com which is free to download and try for all. Although the site lists a small nominal fee for academic licenses to help offset my cost of development and distribution, the author is willing to work with any professor interested in using the technique as a teaching aid including offering to waive the nominal fee.  This has taken many years of relentless effort and offers a powerful yet simpler alternative to more complex tools and it is the author’s hope to see it utilized in education to help students learn and study differential equations.  

The author has requested SIMIODE to bring awareness to the new spreadsheet technique for modeling differential equations. The material presents an example of how to model and investigate a system of PDEs with advanced features in Excel at far less effort and skill than would be required with other standard tools. Modeling such a system in Excel was unthinkable before the advent of this new technique yet the example demonstrates how easily it can be done without any programming skill.

Cite this work

Researchers should cite this work as follows:

  • Chahid Ghaddar (2017), "Excel Advanced Solver for Partial Differential Equations," https://simiode.org/resources/3582.

    BibTex | EndNote

Tags