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

Two Excel Solutions of Ordinary Differential Equations

作　　者：金晓龙[1] 

机构地区：[1]广东女子职业技术学院应用设计系,广州511450

出　　处：《兵工自动化》2012年第10期90-92,96,共4页Ordnance Industry Automation

摘　　要：在实际应用中,常需要建立多个物理量随某一物理量(如:时间、温度等)变化的常微分方程组及对其求解,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.

关 键 词：EXCEL 常微分方程组 数值解 MATLAB 

分 类 号：TP301.6[自动化与计算机技术—计算机系统结构]