Excel求解常微分方程组.pdfVIP

26 ( 786) Ex cel 20 10 : 1003-5850( 2010) 10-0026-03 Excel Excel Solution of Ordinary Dif ferenti al Equations 金晓龙 ( 广东女子职业技术学院　广州　511450) 在建立实际问题的数学模型时, 常需要建立各物理量随时间变化的常微分方程组及求常微分方程组数 解, 介绍借助Excel 的工作表和自定义宏函数, 用经典的四阶龙格-库塔法求常微分方程组初 问题的数 解。 Ex cel, 常微分方程组, 数值解, 龙格-库塔法 : TP 311 : A ABSTRACTIn establishin t he the mathematical m odel of practical problems, it ofen need t o establish the ordinary differential equations w hich phy sical quantities chan e over time , solve the ordinary different ial equations for the numerical solutions. This article describes how t o solve the ordinary differential equat ions for the numerical solutions of initial values problems, with Ex cel w orksheet and custom macro functions, usin the classical Run e-Kut ta method. KEYWORDSEx cel, ordinary differential equations, numerical solution, Run e-Kutta m ethod , 1 , , , , , , , ; : , , , , , , - , Excel - i i 1 2 N y = f (x , y , y , , y ) , ( i= 1, 2, , N ) Excel , 0 y i (x 0) = y i , ( i= 1, 2, , N ) , T 0 : y = ( y 1 , y 2 , , y N ) , y = Ex cel 0 0 0 T T (y 1 , y 2, , y N ) ,f = (f 1 ,f 2 , ,f N ) ,