The CSAW simulation
Needs no more validation
Tho I’m so nigh certain
Next’s show’s final curtain
Please seek neat explanation
8 September 2020
We provide an explanation of the CSAW (COVID-19 Sampling Analysis Worksheets) model (“SeeSaw” model). Please also see:
COVID Odyssey: CSAW simulation ~ formulation verification
First we randomly simulate an outbreak of COVID-19. Once we have generated one outbreak (sample), we generate 39 more (40 outbreaks altogether) and provide the mean number infected for Days 11 – 13 (individually and overall) for each outbreak (sample) and overall statistics for the 40 outbreaks (samples).
We look at over 16,000 cases and randomly determine when each case (on Day 11-13) was infected and when this is done for all the cases, we count up the number of people (directly) infected by each case.
- r denote the effective Reproduction rate of COVID-19 for one day
- Ro denote the Reproduction rate without any quarantine or isolation
- Re denote the effective Reproduction rate of COVID-19
(Re assumes isolation/quarantine is happening)
We use a daily rate of increase of r = 1.4 (40% increase per day) and adopt a 10-day infectious period (when a case can infect others).
Below there are two tables (combined) that we use to generate each case/outbreak:
Each case can infect other people for the next 10 days.
We start our generation on Day 12 (Cases 290-404). This allows us to provide statistics for Day 11 later.
We also create stats for Day 13. This means we need to look at the next 10 days (to Day 23) to see how many are infected from Day 13 cases.
We see on Day 23 we are up to almost 16,400 cases. Starting from Case#290 this means we need to look at over 16,100 cases.
First we look at Case#290. We randomly select a day (from 1-10) days ago when Case#290 was infected.
We use a random number (from 0 to 1) to determine which day Case#290 was itself infected.
Look at the Cumulative column in the left table above. We see there is an almost 30% chance (0.2959456) of Case#290 being infected “one day” ago. Note that the incubation period is already built in to the actual case numbers.
From the table on the right we see the total number of cases for the selected day and randomly select one of the cases to infect Case#290. For example we have 83 cases on Day 11. If Case#290 ends up being infected one day ago (on Day 11) we choose one of these cases to infect Case#290, say Case#270.
The case number is recorded (alongside Case#290).
We repeat this process for the next approximately 16,100 cases (until the end of Day 23) so that we know which case infected each of these cases.
We count up the number of cases infected by Case#290 and each of the other cases.
Below is part of a run (reduced later to 4 columns):
We see that 6 others have been infected by Case#290.
Below is part of another run (the headings are the same as above).
We see on Day 13, Case#560 infected Case#16372.
We calculate the mean number of people infected by each case on Day 11, 12, and 13 for the first outbreak and for the other 39 outbreaks simulated.
The results for the mean are similar to the values obtained for r = 1.4 in the formula for Ro:
where we obtained (using r = 1.4), Ro = 4.143238436
The results look like this in CSAW v2:
Maximum Infected means the number of people directly infected by 1 case (i.e. not by another person).
You may also like to look at:
COVID Odyssey by Alan Grace: New Year Fare ~ Contents
We end with a sample runs of the CSAW v3 Excel simulation:
10-day period of infectivity; r = 1.4 and the daily rate of decay in infectivity is P = 1/1.4 i.e. 1/r:
|Alan Grace||14||(by 1 case)|
|Copyright © Alan Grace June 2020|
I share my posts at: