Modeling COVID-19 epidemics in an Excel spreadsheet: Democratizing the access to first-hand accurate predictions of epidemic outbreaks

Alvarez, Mario Moises; Gonzalez-Gonzalez, Everardo; Trujillo-de Santiago, Grissel

COVID-19, the first pandemic of this decade and the second in less than 15 years, has harshly taught us that viral diseases do not recognize boundaries; however, they truly do discriminate between aggressive and mediocre containment responses. We present a simple epidemiological model that is amenable to implementation in Excel spreadsheets and sufficiently accurate to reproduce observed data on the evolution of the COVID-19 pandemics in different regions (i.e., Italy, Spain, and New York City (NYC)). We also show that the model can be adapted to closely follow the evolution of COVID-19 in any large city by simply adjusting two parameters related to (a) population density and (b) aggressiveness of the response from a society/government to epidemics. Moreover, we show that this simple epidemiological simulator can be used to assess the efficacy of the response of a government/society to an outbreak.