Ending Covid.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	FL Last Update was 3/23, IA 3/29 not 5/5/2023 for other regions.
2	Data Date		5/5/2023		Acc Date		4/3/2023		End of Wk		5/1/2023		From	today	972
3	As more people get vaccinated or boosted or more cases happen, the LESS 1st shots per day are needed to reach the herd goal.
4	As fewer people get vaccinated or boosted or fewer cases happen, the MORE 1st shots per day are needed to reach the herd goal.																		1,670,000
5
6	Needs	Stable	Stable	Stable	Stable	Stable	Stable	Stable	Stable	Stable	More	Stable	Stable	Less	Stable	Less	More	Less	Ranks
7		USA	CA	OC	SV	LA	N Mexico	Florida	Mass	Tenn	Vermont	Texas	Wy	Ks	Iowa	ND	WV	Shots	CasesVsVax
8		Nation	State	Area	sv	AreaB	Nm	Florida	Mass	Tenn	Vermont	Texas	Wy	Ks	Iowa	ND	WV	Needed	Info
9	End Row	N	S	A	O	B	C	F	M	T	V	X	W	K	I	D	G	This wk	Blog
10	42	+-1	+-1/12	+-1/36	+-1/36	+-1/36	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	+-1/12	Than Last
11			If % change is between -11% to 11% we're relatively flat. If %change is greater than 11% then cases are increasing, if less than 11%, cases are decreasing.
12	Case wk Change	no point	no point	no point	no point	no point	-29.3%	no point	no point	no point	no point	no point	no point	no point	no point	no point	no point	=(Wk Ending cases)/(previous week cases)
13	Cases/100k	1.9	4.1	1.6	3.3	1.5	6.3	0.1	2.4	3.7	3.8	3.1	4.2	2.3	0.8	3.4	2.5	<10 Grn, <15 Yllw, <20 Orng, 20>=Spike/Surge & %Chng is +
14	Cases wk end	42,497	10,445	383	453	1,067	838	161	1,080	1,644	161	5,953	161	426	161	170	303	=Red>=0.5, Org 0.34>=,Ylw 10*Min Avg of region peak.
15	Min Avg Cases	11,367	1,829	67	76	225	155	25	200	314	25	1,207	24	83	25	35	72	=8th lowest avg daily cases in past 2 cycles.
16	Peak Cases	809,500	132,500	8,215	5,115	44,150	5,475	58,850	22,050	17,050	1,705	64,250	1,325	8,425	6,355	2,255	5,145	=Most cases in a day	0.01404200124
17	Peak 1sts	3,950,000	586,000	51,000	37,400	140,000	33,200	324,000	120,000	72,400	12,100	361,000	9,980	45,100	54,700	14,800	41,300	=Most 1st shots given in a day
18	Current 1sts	27,308	1,046	192	85	637	246	1,348	1,107	279	86	1,963	29	275	218	72	85	=Week ending 1st shots
19	Population	339,000,000	40,130,000	3,235,000	1,980,000	10,100,000	2,110,000	22,150,000	7,140,000	7,050,000	650,000	30,150,000	590,000	3,000,000	3,250,000	810,000	1,800,000
20
21	Doing 1st/Wk	13,657	(536)	39	13	146	(4)	(48)	(82)	(9)	1	-	-	34	-	-	(29)	=Weekly Rate based on start to current 'End of Wk' need
22	Wks to end	82	844	126	138	123	93	213	63	338	53	204	271	114	150	142	433
23	End of Wk	Nation	State	Area	sv	AreaB	Nm	Florida	Mass	Tenn	Vermont	Texas	Wy	Ks	Iowa	ND	WV	Trend	Data Date	Lag Days	Days used	Days
24	12/8/2022	1,950,000	204,000	15,300	7,030	50,800	11,100	137,000	30,300	45,300	2,320	200,000	3,910	18,300	16,300	5,070	11,500		12/30/2022	22	148	Later
25	12/16/2022	1,860,000	201,000	15,200	8,400	50,300	10,800	137,000	30,200	45,300	2,320	200,000	3,890	18,300	16,300	5,310	11,600	-57.3%	1/6/2023	21		8
26	12/24/2022	1,860,000	201,000	15,100	8,410	50,100	10,800	137,000	32,000	45,300	2,300	201,000	3,910	18,200	16,300	5,280	12,000	2.7%	1/13/2023	20	Avg End	8
27	1/1/2023	1,860,000	199,000	15,100	6,800	49,600	10,800	137,000	31,900	45,200	2,290	201,000	3,740	18,200	16,200	5,060	12,000	-30.7%	1/20/2023	19	1/14/2026	8
28	1/9/2023	1,860,000	217,000	14,900	6,710	49,100	10,800	137,000	32,000	45,300	2,290	197,000	3,910	17,500	16,200	5,300	12,000	16.0%	1/27/2023	18		8
29	1/17/2023	1,850,000	216,000	14,800	6,720	48,700	10,800	137,000	31,900	45,300	2,280	198,000	3,730	18,200	16,200	5,040	11,600	-73.3%	2/3/2023	17	Low End	8
30	1/25/2023	1,860,000	216,000	14,700	6,720	48,400	10,800	137,000	31,800	45,300	2,280	202,000	3,910	18,300	16,300	5,300	12,000	57.3%	2/10/2023	16	9/27/2024	8
31	2/2/2023	1,670,000	216,000	14,600	6,730	48,300	10,800	137,000	31,700	45,300	2,260	202,000	3,890	17,500	16,200	5,060	11,600	-77.3%	2/17/2023	15		8
32	2/10/2023	1,670,000	215,000	14,600	6,730	48,000	10,800	137,000	31,700	45,300	2,270	198,000	3,720	17,500	16,200	5,050	11,600	-5.3%	2/24/2023	14	Worst End	8
33	2/18/2023	1,670,000	215,000	14,600	6,740	48,100	10,800	137,000	31,700	45,300	2,270	199,000	3,910	17,500	16,200	5,050	12,000	14.7%	3/3/2023	13	8/16/2035	8
34	2/26/2023	1,670,000	215,000	14,500	6,660	48,000	10,800	138,000	31,700	45,300	2,260	202,000	3,900	17,500	16,200	5,280	11,600	-4.0%	3/10/2023	12		8
35	3/6/2023	1,670,000	215,000	14,500	6,420	47,900	10,800	138,000	32,000	45,500	2,300	199,000	3,750	19,000	16,300	5,060	12,000	17.3%	3/17/2023	11	Wks used	8
36	3/14/2023	1,670,000	215,000	14,500	6,420	47,900	10,800	138,000	31,900	45,400	2,290	203,000	3,750	18,100	16,300	5,070	12,000	-16.0%	3/24/2023	10	21.1	8
37	3/22/2023	1,670,000	215,000	14,500	6,740	47,800	10,800	138,000	32,000	45,500	2,300	203,000	3,930	18,300	16,300	5,070	12,000	20.0%	3/31/2023	9		8
38	3/30/2023	1,670,000	211,000	14,400	6,830	47,600	11,200	138,000	31,900	45,500	2,270	200,000	3,920	17,500	16,300	5,320	12,000	-17.3%	4/7/2023	8		8
39	4/7/2023	1,670,000	215,000	14,500	6,750	47,900	10,800	138,000	31,900	45,500	2,280	204,000	3,920	17,500	16,300	5,300	12,000	5.3%	4/14/2023	7		8
40	4/15/2023	1,670,000	215,000	14,500	6,750	47,900	10,800	138,000	32,000	45,500	2,280	200,000	3,750	18,100	16,300	5,330	12,000	12.0%	4/21/2023	6		8
41	4/23/2023	1,670,000	215,000	14,500	6,750	47,800	11,200	138,000	32,000	45,500	2,270	200,000	3,920	18,900	16,300	5,100	12,000	2.7%	4/28/2023	5		8
42	5/1/2023	1,670,000	215,000	14,500	6,750	47,800	11,200	138,000	32,000	45,500	2,280	200,000	3,920	17,600	16,300	5,080	12,100	0.0%	5/5/2023	4		8
43	5/9/2023																	-100.0%	5/12/2023	3		8
44	5/17/2023																	0.0%	5/19/2023	2		8
45	5/25/2023																	0.0%	5/26/2023	1		8
46	6/2/2023																	0.0%	6/2/2023	0		8
47	6/10/2023																	0.0%	6/9/2023	-1		8
48	6/18/2023																	0.0%	6/16/2023	-2		8
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100