COVID-19 Aerosol Transmission Estimator File --> Make a Copy OR Download to Excel (Click GREEN links below if don't see option)
Developed by: Prof. Jose L Jimenez, Dept. of Chem. and CIRES, Univ. of Colorado-Boulder Shortcut: https://tinyurl.com/covid-estimator
Short description of this tool: https://cires.colorado.edu/news/covid-19-airborne-transmission-tool-available Direct copy in Google Drive (as Google Sheet)
5 min. read on aerosol evidence: Patterns of transmission Additional Threads Direct download into Excel
Recorded webinar on this tool: 1. Description & Tour (watch first) 2. Q&A session Come back for new versions
Informacion en espanol / castellano: 1. Descripcion y demonstracion 2. Entrevista PF 3. Entrevista HA
Subscribing to email list for tool: https://groups.google.com/forum/#!forum/covid-estimator
Using input or feedback from (But any mistakes are my own): Linsey Marr, Shelly Miller, Giorgio Buonnano, Lidia Morawska, Don Milton, Julian Tang, Jarek Kurnitski, Xavier Querol, Matthew McQueen, Charles Stanier, Joel Eaves, Alfred Trukenmueller, Ty Newell, Greg Blonder, Andrew Maynard, Nathan Skinner, Clark Vangilder, Roger Olsen, Alex Mikszewski, Prasad Kasibhatla, Joe Bruce, Paul Dabisch, Yumi Roth, Andrew Persily, Susan Masten, Sebastien Tixier, Amber Kraver, Howard Chong, John Fay, Dustin Poppendieck, Jim Bagrowski, Gary Chaulklin, Richard Meehan, Jarrell Wenger, Alex Huffman (only listing the most important here, many others have contributed feedback as well over email and Twitter. Thanks a lot to everyone!)
Version & date 3.4.2 31-Jul-20
What we are trying to estimate
The propagation of COVID-19 by aerosol transmission ONLY
The model is based on a standard model of aerosol disease transmission, the Wells-Riley model. It is calibrated to COVID-19 per recent literature on quanta emission rate
This is NOT an epidemiological model, rather can take input from such models for the average rate of infection for a given location and time period. Or it could possibly be used as a sub-component of an epi-model, to estimate aerosol transmission as a function of various parameters
This model does NOT include droplet or contact / fomite transmission, and assumes that 6 ft / 2 m social distancing is respected. Otherwise higher transmission will result
This model does NOT include transmission to the people present, when they are in locations other than the one analyzed here
The model can easily be adapted to other situations, such as offices, shops etc.
Simplicity and uncertainties - IMPORTANT, PLEASE READ
The model is kept simple so that it can be understood and changed easily. The goal is to get the order-of-magnitude of the effects quickly, and to explore the trends.
Several parameters are uncertain, and have been estimated based on current knowledge. Alternative estimates can be entered to explore their effect in the results.
More complex and realistic models can be built, however the parametric uncertainty may still dominate the total uncertainty
Parameters based on new research can be incorporated as they become available. Pls send them my way
Disclaimer: this model is our best scientific estimate, based on the information currently available. It is provided in the hope that it will be useful to others, based on us
receiving a large number of requests for this type of information. We trust most the relative risk estimates (when changing parameters such as wearing a
mask or not) of two runs of the model. We also trust the order-of-magnitude of the risk estimates, if the inputs are correct. The exact numerical results
for a given case have more uncertainty. For example if you obtain a 1% chance of infection, in reality it could be 0.2% or 5%. But it won't be 0.001% or 100%.
Results also have to be interpreted statistically, i.e. the result is the average number of transmission cases, across many realizations of a given event. I.e. if
1000 similar events were conducted, this would be the average probability. Any one event may have much fewer or many more transmission cases.
How to use the estimator
This online version will be kept up-to-date. We can't allow people to make changes to the online version, as otherwise people would overwrite each other's changes
People interested in using the model should download an Excel version from File --> Download or make a G Sheets copy with File --> Make a copy
Or you can download an Excel version with the direct link above
The online model will continue to be updated, so you may want to re-download the file later on, if you continue to use it, to get the latest updates
See the version log at the bottom of this sheet for a brief description of the updates
Inputs and Outputs
Most important inputs are colored in orange
Inputs are colored in yellow. These are the cells you should change to explore different cases.
Descriptions and intermediate calculations are not colored. Do not overwrite the calculations or you will break the estimator.
Outputs are colored in blue. These are the final results of the model for each case. Do not overwrite them or you will break the estimator.
Note that in some cases, the case in a sheet assumes that an infected person is present (e.g. in the classroom). While in other cases we use the prevalence of the disease in the population as
an input on the calculations. They can be converted easily, but pay attention to what each specific sheet is doing.
All sheets are self-contained, except for the University case
For the University case
Approximately scaled for a large University in the Western US for the Fall 2020 semester
First, results are calculated for a typical classroom ("Classroom Sheet"), assuming either one student or the professor are infected
Assumes enhanced social distancing and masks in place
Classroom size does not matter much, since students will scale with it
Then, results are scaled to the whole campus ("Campus Sheet"), taking into account the probability of infection in the population
Suggestions and improvements
Please email me for any suggestions for improvements, additional input data etc. [email protected]
The model combines two submodels: (1) a standard atmospheric "box model", which assumes that the emissions are completely mixed across a control volume quickly (such as an indoor room or other space). See for example Chapter 3 of the Jacob Atmos. Chem. textbook, and Chapter 21 of the Cooper and Alley Air Pollution Control Engineering Textbook for indoor applications. This is an approximation that allows easy calculation, is approximately correct as long as near-field effects are avoided by social distancing, and is commonly used in air quality modeling. (2) a standard aerosol infection model (Wells-Riley model), as formulated in Miller et al. 2020, and references therein
Miller et al. Skagit Choir Outbreak https://www.medrxiv.org/content/10.1101/2020.06.15.20132027v1
Original Wells-Riley model: https://academic.oup.com/aje/article-abstract/107/5/421/58522
Buonnano et al. (2020a) https://www.sciencedirect.com/science/article/pii/S0160412020312800
Buonnano et al. (2020b) https://www.medrxiv.org/content/10.1101/2020.06.01.20118984v1
Key parameters, sources, and uncertainties
The most uncertain parameter is the quanta emission rates for SARS-CoV-2
See FAQ sheet for the definition of quanta
970 q / h This is from the Miller et al. choir superspreading case https://www.medrxiv.org/content/10.1101/2020.06.15.20132027v1
This value is at the high end of the Buonnano et al. values provided below, consistent with this being a superspreading event
which was likely influenced by a very high emission rate of quanta from the specific index case
We do not think that this very high value should be applied to all situations, as that would overestimate the infection risk.
Buonnano et al. (2020a, b) provides a range of estimates. Recommended values by the author are: Paper 1 Paper 2
IMPORTANT: The uncertainty of these values is high, probably at factor of 5 or 10. We just don't know enough about this disease yet. Also there are likely superspreaders which are less frequent but may have higher emissions (as in the choir case). Thus don't take abs. probabilities of infection at face value, just look at the order-of-magnitude (i.e. it is of the order of 0.001% or 0.01% or 0.1% or 1% or 10% or approaching 100%?. It is the relative effect of control measures, disease prevalence etc. that is most useful from this estimator, given the current state of knowledge.
For a professor delivering a lecture:4.4, 21, and 134 for oral breathing, speaking and aloud speaking (or singing)
For a student sitting on a lecture: 4, 16, 97 for oral breathing, speaking and aloud speaking (or singing)
For a more general set of activities, provided by the same author, based on their 2nd paper:
Resting – Oral breathing = 2.0 quanta/h
Resting – Speaking = 9.4 quanta/h
Resting – Loudly speaking = 60.5 quanta/h
Standing – Oral breathing = 2.3 quanta/h
Standing – Speaking = 11.4 quanta/h
Standing – Loudly speaking = 65.1 quanta/h
Light exercise – Oral breathing = 5.6 quanta/h
Light exercise – Speaking = 26.3 quanta/h
Light exercise – Loudly speaking = 170 quanta/h