Excel求解常微分方程组

Excel Solution of Ordinary Differential Equations

在建立实际问题的数学模型时,常需要建立各物理量随时间变化的常微分方程组及求常微分方程组数值解,介绍借助Excel的工作表和自定义宏函数,用经典的四阶龙格-库塔法求常微分方程组初值问题的数值解。

In establishing the the mathematical model of practical problems, it ofen need to establish the ordinary differential equations which physical quantities change over time, solve the ordinary differential equations for the numerical solutions. This article describes how to solve the ordinary differential equations for the numerical solutions of initial values problems, with Excel worksheet and custom macro functions, using the classical Runge-Kutta method.