ABCDEF
1
To use this spreadsheet, make a copy or download it as an Excel file.
2
Positive Case Ratio - Your State/ProvinceYour State/Province - 7 day increase in cases?
3
Input the daily number of cases in your state/province starting the day before and going back 14 total days.This data will autofill from Column C.
4
Visit the CDC's website to get your state's case data. For Canada, visit the CBC website.Total Cases - Previous Week
5
Copy data from other tabs 0
6
Your State or ProvinceFloridaTotal Cases - Week Before Last
7
Max Number of New Cases Allowed per 14 days - 50 in 100k ratio10,7690
8
Max Number of New Cases Allowed per 14 days - 20 in 100k ratio4,308Increase Between Weeks
9
#DIV/0!
10
DayDateTotal Number of CasesIf this number is greater or equal to 50%, then your team must wait another 7 days before moving up a stage.
11
Day 14
12
Day 13
13
Day 12
14
Day 11
15
Day 10
16
Day 9
17
Day 8
18
Day 7
19
Day 6
20
Day 5
21
Day 4
22
Day 3
23
Day 2
24
Day 1
25
Total Cases0
26
If the value in C25 is greater than what's in B7, then your team may not proceed to Stages 3 or 4. If the value is greater than what's in B8, then your team may not proceed to Stages 5-7.
27
28
29
Positive Case Ratio - State/Province Your Team is Traveling ToState/Province You're Traveling To - 7 day increase in cases?
30
Input the daily number of cases in the state/province you're team is traveling to starting the day before and going back 14 total days.This data will autofill from Column C.
31
Visit the CDC's website to get your state's case data. For Canada, visit the CBC website.Total Cases - Previous Week
32
Copy data from other tabs 0
33
State or Province Your Team is Traveling ToTotal Cases - Week Before Last
34
Max Number of New Cases Allowed per 14 days - 50 in 100k ratio#N/A0
35
Max Number of New Cases Allowed per 14 days - 20 in 100k ratio#N/AIncrease Between Weeks
36
#DIV/0!
37
DayDateTotal Number of CasesIf this number is greater or equal to 50%, then your team must wait another 7 days before moving up a stage.
38
Day 14
39
Day 13
40
Day 12
41
Day 11
42
Day 10
43
Day 9
44
Day 8
45
Day 7
46
Day 6
47
Day 5
48
Day 4
49
Day 3
50
Day 2
51
Day 1
52
Total Cases0
53
If the value in C52 is greater than what's in B34, then your team may not proceed to Stages 3 or 4. If the value is greater than what's in B35, then your team may not proceed to Stages 5-7.