RUS  ENG
Full version
JOURNALS // Meždunarodnyj naučno-issledovatel'skij žurnal // Archive

Meždunar. nauč.-issled. žurn., 2021 Issue 6(108), Pages 18–24 (Mi irj614)

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.

DOI: 10.23670/IRJ.2021.108.6.004



© Steklov Math. Inst. of RAS, 2024