A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|

1 | |||||||||||||||||||||||||||

2 | Instructions: CLICK HERE TO MAKE A COPY OF THE SHEET... then change the "user inputs" in yellow. | https://docs.google.com/spreadsheets/u/0/d/1LBZWHEk2Jo-IFvZK_smrwYoOTOykB7H-oHb0qYjg2ys/copy | |||||||||||||||||||||||||

3 | |||||||||||||||||||||||||||

4 | WARNING: THIS IS GUESSWORK DONE BY A NON-EXPERT AND MAY BE WRONG - USE AT YOUR OWN RISK | ||||||||||||||||||||||||||

5 | WARNING: THESE ARE MIDPOINTS OF AN ESTIMATE AND DO NOT DISPLAY THE RELEVANT MARGINS OF ERROR / UNCERTAINTY - RISK MAY BE HIGHER | ||||||||||||||||||||||||||

6 | WARNING: THESE CALCULATIONS DO NOT TAKE INTO ACCOUNT CHANCE OF HARMING OTHERS - TOTAL HARM WILL BE HIGHER | ||||||||||||||||||||||||||

7 | WARNING: THESE CALCULATIONS DO NOT TAKE INTO ACCOUNT OTHER POSSIBLE SOURCES OF INCREASED RISK (e.g., poor ventilation, people singing) SO BE CAREFUL TO CONSIDER YOUR SPECIFIC SCENARIO. | ||||||||||||||||||||||||||

8 | UPDATE 6 AUG - Refined mask estimates and infection fatality rate with updated sourcing. Also updated state case data. | ||||||||||||||||||||||||||

9 | |||||||||||||||||||||||||||

10 | I. BASIC RISKS | ||||||||||||||||||||||||||

11 | Source | ||||||||||||||||||||||||||

12 | How much do you value your life? | $10,000,000 | User input (consider that the statistical value of life in the US is $5-10M. A typical working lifetime at $60/hr is $4.8M in earnings.) | ||||||||||||||||||||||||

13 | |||||||||||||||||||||||||||

14 | If you drive for 30 miles, your chance of death is 1 in | 2,220,000 | 1.5 killed per 100 million miles (Wikipedia) | ||||||||||||||||||||||||

15 | This means driving 30 minutes has an expected loss of... | $4.50 | Calculation | ||||||||||||||||||||||||

16 | |||||||||||||||||||||||||||

17 | If you fly SF to Boston roundtrip, your chance of death is 1 in | 9,250,000 | 0.2 deaths per 10 billion passenger-miles (Wikipedia), 2704mi from SF to Boston (Source), roundtrip is double that distance | ||||||||||||||||||||||||

18 | This means an SF-Boston round trip has an expected loss of... | $1.08 | Calculation | ||||||||||||||||||||||||

19 | That's X times more dangerous than driving 30 miles... | 0.2 | Calculation | ||||||||||||||||||||||||

20 | |||||||||||||||||||||||||||

21 | If you ride a motorcycle without a helmet for 30 miles, your chance of death is 1 in | 60,000.00 | 212 killed per billion miles (Source). Helmets reduce risk of death by 37% (Source). | ||||||||||||||||||||||||

22 | That means riding a motorcycle without a helmet for 30 miles is an expected loss of... | $166.67 | Calculation | ||||||||||||||||||||||||

23 | That's X times more dangerous than driving 30 miles... | 37 | Calculation | ||||||||||||||||||||||||

24 | |||||||||||||||||||||||||||

25 | |||||||||||||||||||||||||||

26 | II. COST OF COVID | ||||||||||||||||||||||||||

27 | Your age? | 29 | User input | ||||||||||||||||||||||||

28 | Gender? | Male | User input | ||||||||||||||||||||||||

29 | Do you have chronic obstructive pulmonary disease (COPD)? | No | User input | ||||||||||||||||||||||||

30 | Are you immune compromised? | No | User input | ||||||||||||||||||||||||

31 | Are you diabetic? | No | User input | ||||||||||||||||||||||||

32 | Your chance of dying from COVID is 1 in | 5,746 | Calculation based on equation from https://twitter.com/DFisman/status/1273266048570138625 adjusted for CFR->IFR using age-based weights derived from https://www.medrxiv.org/content/10.1101/2020.07.23.20160895v2 | ||||||||||||||||||||||||

33 | This risk from death is an expected loss of X if you have COVID... | $1,740 | Calculation | ||||||||||||||||||||||||

34 | |||||||||||||||||||||||||||

35 | Your chance of getting bad flu symptoms from COVID is | 30% | https://www.advisory.com/daily-briefing/2020/06/01/asymptomatic-patients (NOTE: This chance is not adjusted for age/gender/comorbidities) | ||||||||||||||||||||||||

36 | COVID flu symptoms last X days on average | 14 | https://covid.joinzoe.com/post/covid-long-term | ||||||||||||||||||||||||

37 | How much would you pay to avert a day of bad flu symptoms? | $500 | User input (Working one day for eight hours at $60/hr is $480) | ||||||||||||||||||||||||

38 | The risk of sickness is an expected loss of X if you have COVID... | $2,100 | Calculation | ||||||||||||||||||||||||

39 | |||||||||||||||||||||||||||

40 | The total cost of getting COVID to you is... | $3,840 | Calculation | ||||||||||||||||||||||||

41 | WARNING: ACTUAL COST IS HIGHER - THIS DOES NOT TAKE INTO ACCOUNT RISK TO YOU INFECTING OTHERS, MEDICAL COSTS, OR CHANCE OF LONG-TERM CHRONIC CONDITIONS. THIS IS A MIDPOINT ESTIMATE WITH UNCERTAINTY. ALSO THE MODEL COULD BE WRONG FOR OTHER REASONS. USE AT YOUR OWN RISK. | ||||||||||||||||||||||||||

42 | |||||||||||||||||||||||||||

43 | |||||||||||||||||||||||||||

44 | III. COVID PREVALENCE | ||||||||||||||||||||||||||

45 | Your state? | OH | User input (...US only, sorry ...users in other countries could manually edit the below cells) | ||||||||||||||||||||||||

46 | New COVID cases per day | 1166 | COVID Tracking Data (CSV as of 6 Aug - to update, download /api/v1/states/daily.csv and put it in "COVID State Case Data") | ||||||||||||||||||||||||

47 | Estimated total active cases in state... | 69,960 | Calculation assuming daily case increase is linear and cases last for 15 days (Source, Source), that there are ~4 additional unknown cases for every known case (Source, Source), and that 20% of cases are isolated (e.g., self-isolation, slaughterhouse, hospital, nursing home, jail/prison) (TODO citation needed). | ||||||||||||||||||||||||

48 | Population of state | 11,570,808 | CSV from GitHub (2013 data) | ||||||||||||||||||||||||

49 | Case prevalence in state is 1 in | 165 | Calculation | ||||||||||||||||||||||||

50 | |||||||||||||||||||||||||||

51 | |||||||||||||||||||||||||||

52 | IV. COVID RISK OF EVENT | ||||||||||||||||||||||||||

53 | Number of other people within 6ft for 5+min? | 3 | User input | ||||||||||||||||||||||||

54 | Average length of contact (minutes)? | 10 | User input | ||||||||||||||||||||||||

55 | Are you wearing a mask? | No | User input | ||||||||||||||||||||||||

56 | Are you outside? | No | User input | ||||||||||||||||||||||||

57 | Percent of other people wearing masks? | 0% | User input (70% is a pretty good baseline for an urban area based on the available data) | ||||||||||||||||||||||||

58 | Your chance of COVID infection is 1 in | 7,860 | Calculation, assuming fixed 1 in 143 chance of getting COVID from an infected person per 10 minutes (Source, Source, see also) up to a maximum of 30% (Source, Source). Assume you wearing mask reduces risk by 25% (Source), and other people wearing a mask makes things 45% safer (Source), with a linear adjustment for mask adherence. Assume outside makes things 5x safer (very wide range of estimates here, this is one weak source for example). Also uses case prevalence in your state (see section III). Note that getting COVID from touching surfaces is rare enough I don't factor it in (Source). | ||||||||||||||||||||||||

59 | That means an expected loss via COVID risk of... | $0.49 | Calculation (based on the risk above and your values from sections I and II) | ||||||||||||||||||||||||

60 | This is X times riskier than driving 30 miles... | 0.11 | Calculation | ||||||||||||||||||||||||

61 | This is X times riskier than an SF-Boston roundtrip flight... | 0.45 | Calculation | ||||||||||||||||||||||||

62 | This is X times riskier than motorcycling for 30 miles without a helmet... | 0.003 | Calculation | ||||||||||||||||||||||||

63 | WARNING: ACTUAL RISK IS HIGHER - THIS DOES NOT TAKE INTO ACCOUNT RISK TO YOU INFECTING OTHERS. ALSO THIS IS A MIDPOINT ESTIMATE WITH UNCERTAINTY. ALSO THE MODEL COULD BE WRONG. USE AT YOUR OWN RISK. | ||||||||||||||||||||||||||

64 | WARNING: THESE CALCULATIONS DO NOT TAKE INTO ACCOUNT OTHER POSSIBLE SOURCES OF INCREASED RISK (e.g., poor ventilation, people singing) SO BE CAREFUL TO CONSIDER YOUR SPECIFIC SCENARIO. | ||||||||||||||||||||||||||

65 | |||||||||||||||||||||||||||

66 | |||||||||||||||||||||||||||

67 | V. COVID RISK OF REPEATED EVENTS | ||||||||||||||||||||||||||

68 | How many times will you repeat the above event in IV? | 24 | User input | ||||||||||||||||||||||||

69 | Your chance of COVID infection is 1 in | 328 | Calculation | ||||||||||||||||||||||||

70 | That means an expected loss via COVID risk of... | $11.73 | Calculation | ||||||||||||||||||||||||

71 | This is X times riskier than driving 30 miles... | 2.60 | Calculation | ||||||||||||||||||||||||

72 | This is X times riskier than an SF-Boston roundtrip flight... | 10.85 | Calculation | ||||||||||||||||||||||||

73 | This is X times riskier than motorcycling for 30 miles without a helmet... | 0.070 | Calculation | ||||||||||||||||||||||||

74 | |||||||||||||||||||||||||||

75 | |||||||||||||||||||||||||||

76 | VI. CREDITS | ||||||||||||||||||||||||||

77 | Calculator made by Peter Hurford - all errors are my own! | ||||||||||||||||||||||||||

78 | Thanks to Derek Foster, Jason Schukraft, Neil Dullaghan, Ben Hurford, Dr. William Hurford, Luisa Rodriguez, Linchuan Zhang, and Ozzie Gooen for feedback. Feedback does not imply agreement or endorsement. | ||||||||||||||||||||||||||

79 | |||||||||||||||||||||||||||

80 | |||||||||||||||||||||||||||

81 | |||||||||||||||||||||||||||

82 | |||||||||||||||||||||||||||

83 | |||||||||||||||||||||||||||

84 | |||||||||||||||||||||||||||

85 | |||||||||||||||||||||||||||

86 | |||||||||||||||||||||||||||

87 | |||||||||||||||||||||||||||

88 | |||||||||||||||||||||||||||

89 | |||||||||||||||||||||||||||

90 | |||||||||||||||||||||||||||

91 | |||||||||||||||||||||||||||

92 | |||||||||||||||||||||||||||

93 | |||||||||||||||||||||||||||

94 | |||||||||||||||||||||||||||

95 | |||||||||||||||||||||||||||

96 | |||||||||||||||||||||||||||

97 | |||||||||||||||||||||||||||

98 | |||||||||||||||||||||||||||

99 | |||||||||||||||||||||||||||

100 |