Use of spreadsheet program to solve parabolic partial differential equations using Crank‐Nicolson method

DOI10.1080/0020739960270212MaRDI QIDQ4359993zbMATH OpenOpenAlexFDO

Authors Abdelwahab Kharab

Publication date 25 November 1997

Published in International Journal of Mathematical Education in Science and Technology (Search for Journal in Brave)

Full work available at URL https://doi.org/10.1080/0020739960270212

zbMATH Keywords

Crank-Nicolson methodfinite differencesparabolic initial-boundary value problemspreadsheet program

Mathematics Subject Classification ID

Initial value problems for second-order parabolic equations (35K15) Finite difference methods for initial value and initial-boundary value problems involving PDEs (65M06)

Review text

Spreadsheet techniques commonly used in data bank systems can also be applied to create simple scientific codes based on macros. The author develops such a spreadsheet program for solving a simple spatially one-dimensional, parabolic initial-boundary value problem discretized by means of the Crank-Nicolson method in time and finite differences in space. He states that this programming technique is very simple and convenient, especially for educational purposes because it is very easy to incorporate graphical facilities and to play with the data. The code presented and discussed in detail in the paper was run on a PC using Lotus 123 version 3.4 under DOS.

Recommendations

• Use of a spreadsheet program in a two-dimensional heat conduction problem
• Computer spreadsheets for numerical analysis
• Spreadsheet simulation of the moving boundary of the one-phase Stefan problem
• The boundary element method on a spreadsheet
• An advanced macro spreadsheet program for the simplex method

Cites work

• Solving dynamic optimization problems on a personal computer using an electronic spreadsheet

Cited in

(4)

• Use of multiple sheets for the solution of a three-dimensional transient heat conduction problem
• Use of a spreadsheet program in a two-dimensional heat conduction problem
• Graphing parametric curves using spreadsheets
• scientific article; zbMATH DE number 1079156 (Why is no real title available?)

Describes a project that uses

Uses Software

• Lotus 1-2-3

This page was built for publication: Use of spreadsheet program to solve parabolic partial differential equations using Crank‐Nicolson method

Report a bug (only for logged in users!)Click here to report a bug for this page (MaRDI item Q4359993)