Engineers-Excel.com

     
Engineering using Spreadsheets

First Order ODE Solver

Description
How it works








This tool solves 1st order Ordinary Differential Equation (ODE) of the form:

y' + a(x)y = b(x)

Download

.xls file (82 KB) or .zip file (16 KB)

How to use the tool

Enter the functions a(x) and b(x) into the cells B6 and B7, with the equal to sign.(Similar to keying in the function f(x) in the Function Calculus Tool). Key in the range into cells B11 and B12 and the initial condition into the cell B15.

This example screenshot shows the entries to be made for solving the equation

y' = cos(x) - ysin(x),

from x = 0 to   x = 6 with the initial condition y(0) = 0. Here,

a(x) = sin(x) and

b(x) = cos(x)