Solution of Seird Mathematical Model for the Covid-19 Transmission Using Microsoft Excel

Mathematical modeling in the epidemiology study can be applied to describe the current transmission of viruses, one of which is compartments. However, this simulation model is rigorous to understand, especially in interpreting the parameter values in influencing the solution. Therefore, it is necessary to present a coherent mathematical model solution. This study aims to determine the SEIRD model solution in the COVID-19 transmission using Microsoft Excel with three conditions (normal, new normal, and lockdown) to facilitate the interpretation of data. The SEIRD model used in this study considers natural population growth, namely natural births and deaths. Three stages to evaluate the model solution in this study are constructing a mathematical model, deciding the parameter intervals, and creating an applet in Microsoft Excel. The system of differential equations is converted into a system of difference equations to obtain numerical model solutions. The results showed that the differences in the infection rates for old normal, new normal, and lockdown conditions were 24%, 4%, and 3%, respectively.

Authors:
D.P.W. Putra, Marcellinus Andy Rudhito, Digdo Sudigyo, Teddy Suparyanto, and Bens Pardamean

2021 International Conference on Biospheric Harmony Advanced Research

Read Full Article