Example 4: l-i SEIR-Vaccination model - Effect of Vaccination on COVID-19 Spread in the United States

In examples 1 to 3, we have demonstrated how to use Excel to calculate variables Sn, En, In, Rn, yn in l-i SEIR (Susceptible-Exposed-Infectious-Recovered) model, to determine the time-dependent kn, and to find the number of actual total infections in the absence of vaccination and breakthrough infections. In the l-i SEIR model, l is the time length of latent period, i is the time length of infectious period, and yn is the number of daily-confirmed cases of infections. In this section (Example 4), we will extend l-i SEIR model to l-i SEIR-vaccination model for examining the effect of vaccination on COVID-19 transmission. Two files (one Word file and one Excel files) are attached. In the Word file, the author described how to build the l-i SEIR-vaccination model and how to calculate the number of daily confirmed cases of COVID-19 infections, yn, in Excel. The calculated yn and the reported yn have been compared to each other and displayed graphically in the Excel file