Excel求解常微分方程组的两种方法

Two Excel Solutions of Ordinary Differential Equations

在实际应用中,常需要建立多个物理量随某一物理量(如:时间、温度等)变化的常微分方程组及对其求解,Excel广泛应用于经济、金融、工程、科研、教学等领域,用Excel求解常微分方程组具有一定的实际意义。笔者叙述2种Excel求解常微分方程组方法:用VBA编程求解、调用Matlab求解,并在实际编程环境中调试运行。

In practical applications, it often needs to establish the ordinary differential equations which physical quantities change over one quantity, such as time, temperature, etc. Excel is widely used in the fields of economy, finance, engineering, research, teaching and so on. It has some practical significance to solve the ordinary differential equations with Excel. This article describes two kinds of Excel method to solve ordinary differential equations, using VBA programming and calling Matlab. All programs run through the debugger and run well in the practical programming environment.