A fourth-order Runge-Kutta (RK4) Spreadsheet Calculator For Solving A System of Two First-Order Ordinary Differential Equations Using Visual Basic (VBA) Programming

Abstract

A fourth-order Runge-Kutta (RK4) Spreadsheet Calculator For Solving A System of Two First-Order Ordinary Differential Equations Using Visual Basic (VBA) Programming Motivated by the work of a spreadsheet solution of a system of ordinary differential equations (ODEs) using the fourth-order Runge-Kutta (RK4) method, a RK4 spreadsheet calculator for solving a system of two first-order ODEs was developed using VBA programming. The main feature of this spreadsheet calculator is to provide a user-friendly interface input form for users to insert the required information instead of the standard cells in Excel. Users are prompted step by step to give relevant information beginning from providing independent and dependent variables used in the system of ODEs. Secondly, they are required to give the interval for the independent variable, initial values for the dependent variables, a step size h and desired accuracy for computation. Thirdly, they have to enter the system of two first-order ODEs and the exact