Numerical solution of ordinary differential equations using an MS Excel© spreadsheet

Vol:

9

Num:

3

Abstract:

This paper shows how a VBA (Visual Basic for Applications) implementation of a numerical integration technique can be incorporated in an MS Excel© spreadsheet, enabling any number of simultaneous first order differential equations to be solved numerically, without the need for installing other packages….

Filename:

9334_hood_d_excelode.pdf

Keywords:

Minitab, ordinary differential equations, ODE, calculus, differentiation, spreadsheet, Excel, software, modelling, model, Kermack-McKendrick model, VBA, visual basic, epidemic model, Matlab, MSOR Connections Aug 2009 Vol 9 No 3

Numerical solution of ordinary differential equations using an MS Excel© spreadsheet

© Maths, Stats & OR Network 2011