This tool solves 2nd order Ordinary Differential Equation (ODE) of the form:

y" + ay' + by = f(x)

where a and b are constants.

Download

.xls file (92 KB) or .zip file (17 KB)

How to use the tool

The use of this tool is quite similar to the Function Calculus Tool. The function is to be keyed in into the cells B4 with an equal sign and the constants a and b into cells B6 and B7 respectively. The range is keyed in into the cells B11 and B12 and initial conditions into cells B15 and B16.

For example, to solve the equation y" = -y over the range 0 to 10, with the initial conditions y = 1 and y' = 0, the screen would look like this if the entries are made correctly. Note that this equation can be written as y" + y = 0, hence a = 0 and b =1.

Also See:

First order ODE Solver

Coupled ODE Solver

Linear Equation Solver

Simultaneous Non-linear Equation Solver