In this chapter we're going to focus on numerically solving ordinary differential equations using Excel.
There are many methods available for numerically solving ordinary differential equations. Solution methods for initial value problems include such standard methods as Euler's method, the improved Euler method, the Runge-Kutta method, the leap frog method, various implicit schemes, as well as various adaptive schemes. Texts on numerical methods are full of such methods.
Other classes of problems dealing with ordinary differential equations include boundary value problems and initial-boundary value problems. Methods available for boundary value problems include the shooting method and variants, the band matrix method, Richardson extrapolation, various finite difference methods, and many others.
I aim to show you a few selected methods in this chapter to show you how you might implement some of these well known methods in Excel. Numerical methods texts contain detailed descriptions of these, as well as other methods. The Excel techniques I'll show you in this chapter will allow you to implement many of the standard methods in Excel.
Getting Acquainted with Visual Basic for Applications
Collecting and Cleaning Up Data
Time Series Analysis
Curve Fitting and Regression
Numerical Integration and Differentiation
Solving Ordinary Differential Equations
Solving Partial Differential Equations
Performing Optimization Analyses in Excel
Introduction to Financial Calculations