Facebook Pixel EXCEL SIR Model | Western Kentucky University Skip to main content

EXCEL SIR Model


 

This is a simple SIR model, implemented in Excel (download from this link). Please experiment with the parameters at the top to see the effect on outcomes.

- Can you push the shape of the Predicted (Cumulative) Deaths curve around?
- What are the tradeoffs you can make?
- Can you make it rise sooner or later, rise faster or slower, etc?
- Can you make it asymmetrical or will it always be symmetrical?

 

in the Excel example, the Beta and Gamma rates are currently constant, which means that the R0 value will be constant. 

Here are some explanations to how the parameters were used in Excel

  * Beta is Infectious rate per day

  Gamma is the Recovery rate (inverse of number of days infectious)

  R0 ("R naught") is Beta / Gamma: the number of people infected, on average while infectious

  Lambda is the rate of movement from exposed to infectious per day

  Delta is the rate of death for those who enter an infectious state

  * Euler Method: bound error wikipedia page

 

You could add a Beta column to the right of the I -> R column, below, and have a different Beta for each day, effectively changing R0.

You'd want to start by copying the same Beta value to all rows, then change the formulas to use these cells and make sure you can reproduce
the same results. Then try having one value for a certain number of days and a second value for the rest of the days, as if behavior suddenly changed.

You could also ramp the value from one value to another to reflect a more realistic change. (I will post something similar with a more sophisticated model in R.)

This model is strictly deterministic. Think about the following questions:

- What points in the calculation should actually have uncertainty associated with them?
- How might you reflect multiple uncertainties in this model?

 

General SIR Parameters are listed bellow:

 

* Beta      How often contact between a Susceptible individual and an Infectious individual results in infection, also known as the transmission rate.


* Lambda The rate at which Exposed individuals become Infectious.


* Gamma  The rate at which Infectious individuals recover and become Removed.


* Delta      The percentage of infections that result in Death.


* Mu         The percentage of those who do not follow the lockdown who mix with those who do.

 

The key parameter that you read about in the news is R0 ("R naught"), the number of susceptible individuals infected by one infectious individual, on average. This value is simply `beta / gamma`.

Ex. if on average people are Infectious for 7 days, the recovery rate, Gamma, is 1/7: one seventh of the infectious population moves to Recovered each day.

 

 

In the real world, differential equations and their solvers would be used and you're free to explore that if you wish. Enjoy and let's talk about this online!

 

SIR Model

 

 

SIR Model

Play around. Code this up in R or use Tableau. More information to be added soon under the R section. 


Some of the links on this page may require additional software to view.

 Last Modified 8/11/20