Excel求解常微分方程组  

Excel Solution of Ordinary Differential Equations

作　　者：金晓龙[1] 

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

出　　处：《电脑开发与应用》2010年第10期26-27,30,共3页Computer Development & Applications

摘　　要：在建立实际问题的数学模型时,常需要建立各物理量随时间变化的常微分方程组及求常微分方程组数值解,介绍借助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.

关 键 词：EXCEL 常微分方程组 数值解 龙格-库塔法 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]