|
PHYSICS AND MATHEMATICS
Excel VBA functions for numerical solution of a Cauchy problem of the first-order ODE system
O. A. Sdvizhkov Russian State University of Tourism and Service
Abstract:
The current study presents program codes of custom VBA Excel functions that implement numerical methods for solving the Cauchy problem for a system of 1st order ordinary differential equations using the Euler and Runge-Kutta 4th order methods. The parameters of the functions are the initial and final values of the independent variable, an array of initial values of the dependent variables, and the number of steps. Program codes use dynamic arrays. Custom functions can be applied to the Cauchy problem and one of the 1st order differential equations. All of the custom functions have descriptions that explain their purpose. The article demonstrates the use of custom functions using specific examples of numerical solutions to the Cauchy problem of 1st order differential equations system and individual 1st-order differential equations.
Keywords:
system of differential equations, Cauchy problem, numerical methods, code, dialog box.
Citation:
O. A. Sdvizhkov, “Excel VBA functions for numerical solution of a Cauchy problem of the first-order ODE system”, Meždunar. nauč.-issled. žurn., 2021, no. 6(108), 18–24
Linking options:
https://www.mathnet.ru/eng/irj614 https://www.mathnet.ru/eng/irj/v108/i6/p18
|
Statistics & downloads: |
Abstract page: | 238 | Full-text PDF : | 260 | References: | 45 |
|