Covid Herd Tracker

	A	B	C	D	E	G	I	K	L	M	N	O	P	Q	R	S	T	V	W
1	N,S,A,B,C,F,V,M,T,X,W,O	Other		IsBlank	Date	Cases per Day	Lost Cases	adj Cases	450,183	100,340	550,523	Herd_Vax	Herd_Case	Herd	Future	Goal		Pre-Omi.1	Post-Omi.1
2				FALSE	4/20/2021	377	172	205	462,695	100,230	562,925	0.235	0.051	0.286	0.000	0.000		0.00000	0.00000

3	Region Boosted is	0.669		FALSE	4/21/2021	358	175	183	475,312	100,076	575,388	0.241	0.051	0.292	0.000	0.000	10/29/2021	0.00000	0.00000
4	Region	SV	Uses	FALSE	4/22/2021	337	178	159	489,643	99,987	589,630	0.249	0.051	0.299	0.000	0.000	1st booster	0.00000	0.00000
5		Fail		FALSE	4/23/2021	320	180	140	504,036	99,906	603,942	0.256	0.051	0.307	0.000	0.000	Approved	0.00000	0.00000
6	Rank (1 worst,57best)	56	Daily	FALSE	4/24/2021	304	183	121	514,759	99,775	614,534	0.261	0.051	0.312	0.000	0.000		0.00000	0.00000
7	%Worst than Best	3.9%		FALSE	4/25/2021	290	185	105	522,696	99,703	622,399	0.265	0.051	0.316	0.000	0.000	11/5/2021	0.00000	0.00000
8			Boost	FALSE	4/26/2021	283	186	97	531,900	99,646	631,546	0.270	0.051	0.321	0.000	0.000	Vaccine	0.00000	0.00000
9				FALSE	4/27/2021	279	187	92	540,447	99,527	639,974	0.274	0.051	0.325	0.000	0.000	Approved	0.00000	0.00000
10	Eff 1st Shots	1,125	Rate	FALSE	4/28/2021	269	189	80	551,947	99,371	651,318	0.280	0.050	0.331	0.000	0.000	for ages	0.00000	0.00000
11	F. Vax Per day	354		FALSE	4/29/2021	254	191	63	563,013	99,261	662,274	0.286	0.050	0.336	0.000	0.000	5+	0.00000	0.00000
12	Cases per day	786	from	FALSE	4/30/2021	242	192	50	574,809	99,165	673,974	0.292	0.050	0.342	0.000	0.000		0.00000	0.00000
13	% Boosted	0.669		FALSE	5/1/2021	233	194	39	582,185	99,083	681,268	0.296	0.050	0.346	0.000	0.000	11/26/2021	0.00000	0.00000
14			FVxPDy	FALSE	5/2/2021	224	195	29	588,997	98,986	687,983	0.299	0.050	0.349	0.000	0.000	Omicron	0.00000	0.00000
15	Chart Start	4/20/2021		FALSE	5/3/2021	220	196	24	601,334	98,895	700,229	0.305	0.050	0.355	0.000	0.000	detected	0.00000	0.00000
16	Current	7/29/2022	Sheet	FALSE	5/4/2021	217	197	20	616,811	98,771	715,582	0.313	0.050	0.363	0.000	0.000		0.00000	0.00000
17	Last Day on Chart	7/30/2022		FALSE	5/5/2021	207	198	9	630,732	98,650	729,382	0.320	0.050	0.370	0.000	0.000	1st	0.00000	0.00000
18	Days Since 1st Vax	466		FALSE	5/6/2021	199	199	-	651,655	98,598	750,253	0.331	0.050	0.381	0.000	0.000	Future	0.00000	0.00000
19				FALSE	5/7/2021	194	200	(6)	669,990	98,547	768,537	0.340	0.050	0.390	0.000	0.000	marker	0.00000	0.00000
20	Herd Goal	0.9300		FALSE	5/8/2021	190	201	(11)	679,903	98,447	778,350	0.345	0.050	0.395	0.000	0.000	is	0.00000	0.00000
21	Min Protected	0.5490		FALSE	5/9/2021	184	201	(17)	685,135	98,347	783,482	0.348	0.050	0.398	0.000	0.000	current	0.00000	0.00000
22	Max Protected	0.8842		FALSE	5/10/2021	180	202	(22)	700,685	98,226	798,911	0.356	0.050	0.406	0.000	0.000	data.	0.00000	0.00000
23	CycleDays	100		FALSE	5/11/2021	177	203	(26)	717,118	98,089	815,207	0.364	0.050	0.414	0.000	0.000		0.00000	0.00000
24	Vax Booster Days	135		FALSE	5/12/2021	168	204	(36)	733,297	97,974	831,271	0.372	0.050	0.422	0.000	0.000		0.00000	0.00000
25				FALSE	5/13/2021	163	205	(42)	749,615	97,867	847,482	0.381	0.050	0.430	0.000	0.000		0.00000	0.00000
26	Protected Guesses	0.676, 0.6965 , 0.738		FALSE	5/14/2021	156	205	(49)	764,235	97,778	862,013	0.388	0.050	0.438	0.000	0.000		0.00000	0.00000
27				FALSE	5/15/2021	153	206	(53)	777,039	97,686	874,725	0.394	0.050	0.444	0.000	0.000		0.00000	0.00000
28		%/100 Boosted		FALSE	5/16/2021	149	206	(57)	785,218	97,590	882,808	0.399	0.050	0.448	0.000	0.000		0.00000	0.00000
29				FALSE	5/17/2021	147	206	(59)	803,318	97,477	900,795	0.408	0.049	0.457	0.000	0.000		0.00000	0.00000
30	(N)ation	0.559		FALSE	5/18/2021	146	207	(61)	829,021	97,386	926,407	0.421	0.049	0.470	0.000	0.000		0.00000	0.00000
31	(S)tate	0.533		FALSE	5/19/2021	142	207	(65)	857,031	97,247	954,278	0.435	0.049	0.484	0.000	0.000		0.00000	0.00000
32	(A)rea	0.576		FALSE	5/20/2021	138	207	(69)	888,594	97,151	985,745	0.451	0.049	0.500	0.000	0.000		0.00000	0.00000
33	Area(B)	0.554		FALSE	5/21/2021	135	207	(72)	917,186	97,042	1,014,228	0.466	0.049	0.515	0.000	0.000		0.00000	0.00000
34	(C)anada	0.708		FALSE	5/22/2021	133	207	(74)	931,390	96,951	1,028,341	0.473	0.049	0.522	0.000	0.000		0.00000	0.00000
35	(F)lorida	0.408		FALSE	5/23/2021	130	207	(77)	940,023	96,867	1,036,890	0.477	0.049	0.526	0.000	0.000		0.00000	0.00000
36	(V)ermont	0.611		FALSE	5/24/2021	129	207	(78)	958,916	96,765	1,055,681	0.487	0.049	0.536	0.000	0.000		0.00000	0.00000
37	(M)ass	0.518		FALSE	5/25/2021	128	207	(79)	978,327	96,672	1,074,999	0.497	0.049	0.546	0.000	0.000		0.00000	0.00000
38	(T)enn	0.445		FALSE	5/26/2021	126	207	(81)	996,093	96,568	1,092,661	0.506	0.049	0.555	0.000	0.000		0.00000	0.00000
39	Silic(O)n Valley	0.669		FALSE	5/27/2021	124	207	(83)	1,013,540	96,464	1,110,004	0.514	0.049	0.563	0.000	0.000		0.00000	0.00000
40	Te(X)as	0.387		FALSE	5/28/2021	121	207	(86)	1,032,346	96,342	1,128,688	0.524	0.049	0.573	0.000	0.000		0.00000	0.00000
41	(W)y	0.433		FALSE	5/29/2021	119	206	(87)	1,045,634	96,247	1,141,881	0.531	0.049	0.580	0.000	0.000		0.00000	0.00000
42				FALSE	5/30/2021	117	206	(89)	1,056,795	96,130	1,152,925	0.536	0.049	0.585	0.000	0.000		0.00000	0.00000
43	inUse	sv		FALSE	5/31/2021	115	206	(91)	1,070,643	96,011	1,166,654	0.543	0.049	0.592	0.000	0.000		0.00000	0.00000
44	Pop	1,970,000		FALSE	6/1/2021	114	205	(91)	1,090,105	95,894	1,185,999	0.553	0.049	0.602	0.000	0.000		0.00000	0.00000
45	VaxPerDay	354		FALSE	6/2/2021	111	205	(94)	1,107,674	95,791	1,203,465	0.562	0.049	0.611	0.000	0.000		0.00000	0.00000
46	CasePerDay	786		FALSE	6/3/2021	109	205	(96)	1,120,312	95,704	1,216,016	0.569	0.049	0.617	0.000	0.000		0.00000	0.00000
47	First Date	4/20/2021		FALSE	6/4/2021	108	204	(96)	1,135,011	95,612	1,230,623	0.576	0.049	0.625	0.000	0.000		0.00000	0.00000
48	Future Start	7/29/2022		FALSE	6/5/2021	107	203	(96)	1,141,398	95,548	1,236,946	0.579	0.049	0.628	0.000	0.000		0.00000	0.00000
49	Future End	10/29/2022		FALSE	6/6/2021	106	202	(96)	1,144,407	95,467	1,239,874	0.581	0.048	0.629	0.000	0.000		0.00000	0.00000
50	Days To Boost	135		FALSE	6/7/2021	105	201	(96)	1,150,093	95,381	1,245,474	0.584	0.048	0.632	0.000	0.000		0.00000	0.00000
51	Last Date	8/1/2022		FALSE	6/8/2021	104	200	(96)	1,156,184	95,284	1,251,468	0.587	0.048	0.635	0.000	0.000		0.00000	0.00000
52	End Date	7/31/2022		FALSE	6/9/2021	102	199	(97)	1,160,189	95,188	1,255,377	0.589	0.048	0.637	0.000	0.000		0.00000	0.00000
53	Start Date	5/2/2022		FALSE	6/10/2021	101	199	(98)	1,163,815	95,106	1,258,921	0.591	0.048	0.639	0.000	0.000		0.00000	0.00000
54	vSheet	svFVxPDy!		FALSE	6/11/2021	99	197	(98)	1,168,107	95,017	1,263,124	0.593	0.048	0.641	0.000	0.000		0.00000	0.00000
55	cSheet	svCases!		FALSE	6/12/2021	98	196	(98)	1,170,102	94,938	1,265,040	0.594	0.048	0.642	0.000	0.000		0.00000	0.00000
56	Region	O		FALSE	6/13/2021	97	194	(97)	1,170,799	94,882	1,265,681	0.594	0.048	0.642	0.000	0.000		0.00000	0.00000
57	vStart	2		FALSE	6/14/2021	97	193	(96)	1,170,643	94,786	1,265,429	0.594	0.048	0.642	0.000	0.000		0.00000	0.00000
58	cStart	351		FALSE	6/15/2021	96	192	(96)	1,176,394	94,679	1,271,073	0.597	0.048	0.645	0.000	0.000		0.00000	0.00000
59	vEnd	379		FALSE	6/16/2021	95	191	(96)	1,180,717	94,588	1,275,305	0.599	0.048	0.647	0.000	0.000		0.00000	0.00000
60	cEnd	728		FALSE	6/17/2021	94	189	(95)	1,188,690	94,532	1,283,222	0.603	0.048	0.651	0.000	0.000		0.00000	0.00000
61	pWk	7.023888462		FALSE	6/18/2021	94	186	(92)	1,197,660	94,476	1,292,136	0.608	0.048	0.656	0.000	0.000		0.00000	0.00000
62	NFRatio	0.2593		FALSE	6/19/2021	93	183	(90)	1,204,854	94,399	1,299,253	0.612	0.048	0.660	0.000	0.000		0.00000	0.00000
63	Percent Boosted	0.669		FALSE	6/20/2021	93	180	(87)	1,210,012	94,351	1,304,363	0.614	0.048	0.662	0.000	0.000		0.00000	0.00000
64	Past Days	467		FALSE	6/21/2021	92	178	(86)	1,216,848	94,279	1,311,127	0.618	0.048	0.666	0.000	0.000		0.00000	0.00000
65	Starting Vaxxed	102		FALSE	6/22/2021	91	175	(84)	1,223,345	94,185	1,317,530	0.621	0.048	0.669	0.000	0.000		0.00000	0.00000
66	Starting Cases	457		FALSE	6/23/2021	91	173	(82)	1,228,709	94,125	1,322,834	0.624	0.048	0.671	0.000	0.000		0.00000	0.00000
67	vDateCol	a		FALSE	6/24/2021	90	171	(81)	1,232,809	94,065	1,326,874	0.626	0.048	0.674	0.000	0.000		0.00000	0.00000
68	vAvg	d		FALSE	6/25/2021	89	168	(79)	1,238,733	94,007	1,332,740	0.629	0.048	0.677	0.000	0.000		0.00000	0.00000
69	cAvg	e		FALSE	6/26/2021	88	165	(77)	1,242,314	93,962	1,336,276	0.631	0.048	0.678	0.000	0.000		0.00000	0.00000
70	cRMS	j		FALSE	6/27/2021	88	162	(74)	1,242,962	93,895	1,336,857	0.631	0.048	0.679	0.000	0.000		0.00000	0.00000
71	cEffCases	k		FALSE	6/28/2021	87	159	(72)	1,245,904	93,830	1,339,734	0.632	0.048	0.680	0.000	0.000		0.00000	0.00000
72	trendSlopeCol	CM		FALSE	6/29/2021	86	156	(70)	1,250,752	93,768	1,344,520	0.635	0.048	0.682	0.000	0.000		0.00000	0.00000
73	trendIntercptCol	CN		FALSE	6/30/2021	86	154	(68)	1,253,480	93,738	1,347,218	0.636	0.048	0.684	0.000	0.000		0.00000	0.00000
74	Trend-m	201.8		FALSE	7/1/2021	85	152	(67)	1,255,106	93,698	1,348,804	0.637	0.048	0.685	0.000	0.000		0.00000	0.00000
75	Trend-b	118,712		FALSE	7/2/2021	85	148	(63)	1,256,536	93,660	1,350,196	0.638	0.048	0.685	0.000	0.000		0.00000	0.00000
76	Trend Start	11/17/2021		FALSE	7/3/2021	84	145	(61)	1,257,483	93,658	1,351,141	0.638	0.048	0.686	0.000	0.000		0.00000	0.00000
77	Show Trend	FALSE		FALSE	7/4/2021	84	141	(57)	1,255,422	93,616	1,349,038	0.637	0.048	0.685	0.000	0.000		0.00000	0.00000
78	BoostRow	44		FALSE	7/5/2021	83	138	(55)	1,256,216	93,625	1,349,841	0.638	0.048	0.685	0.000	0.000		0.00000	0.00000
79	ColOffSetStart	ae		FALSE	7/6/2021	83	136	(53)	1,259,245	93,652	1,352,897	0.639	0.048	0.687	0.000	0.000		0.00000	0.00000
80	Post-trend-m	116.1		FALSE	7/7/2021	83	134	(51)	1,259,408	93,695	1,353,103	0.639	0.048	0.687	0.000	0.000		0.00000	0.00000
81	Post-trend-b	275,488		FALSE	7/8/2021	83	132	(49)	1,258,708	93,719	1,352,427	0.639	0.048	0.687	0.000	0.000		0.00000	0.00000
82	Post-trend-start	4/6/2022		FALSE	7/9/2021	83	128	(45)	1,256,229	93,737	1,349,966	0.638	0.048	0.685	0.000	0.000		0.00000	0.00000
83	StartBoostOn	44		FALSE	7/10/2021	83	126	(43)	1,252,511	93,765	1,346,276	0.636	0.048	0.683	0.000	0.000		0.00000	0.00000
84				FALSE	7/11/2021	82	123	(41)	1,246,083	93,797	1,339,880	0.633	0.048	0.680	0.000	0.000		0.00000	0.00000
85				FALSE	7/12/2021	83	121	(38)	1,244,663	93,878	1,338,541	0.632	0.048	0.679	0.000	0.000		0.00000	0.00000
86				FALSE	7/13/2021	84	120	(36)	1,244,112	93,971	1,338,083	0.632	0.048	0.679	0.000	0.000		0.00000	0.00000
87				FALSE	7/14/2021	85	117	(32)	1,242,855	94,050	1,336,905	0.631	0.048	0.679	0.000	0.000		0.00000	0.00000
88				FALSE	7/15/2021	85	114	(29)	1,238,080	94,124	1,332,204	0.628	0.048	0.676	0.000	0.000		0.00000	0.00000
89				FALSE	7/16/2021	84	111	(27)	1,233,479	94,177	1,327,656	0.626	0.048	0.674	0.000	0.000		0.00000	0.00000
90				FALSE	7/17/2021	84	107	(23)	1,227,708	94,246	1,321,954	0.623	0.048	0.671	0.000	0.000		0.00000	0.00000
91				FALSE	7/18/2021	83	104	(21)	1,221,395	94,334	1,315,729	0.620	0.048	0.668	0.000	0.000		0.00000	0.00000
92				FALSE	7/19/2021	82	101	(19)	1,219,518	94,481	1,313,999	0.619	0.048	0.667	0.000	0.000		0.00000	0.00000
93				FALSE	7/20/2021	85	99	(14)	1,220,228	94,680	1,314,908	0.619	0.048	0.667	0.000	0.000		0.00000	0.00000
94				FALSE	7/21/2021	88	96	(8)	1,216,736	94,877	1,311,613	0.618	0.048	0.666	0.000	0.000		0.00000	0.00000
95				FALSE	7/22/2021	90	94	(4)	1,212,849	95,027	1,307,876	0.616	0.048	0.664	0.000	0.000		0.00000	0.00000
96				FALSE	7/23/2021	92	90	2	1,208,802	95,212	1,304,014	0.614	0.048	0.662	0.000	0.000		0.00000	0.00000
97				FALSE	7/24/2021	94	86	8	1,202,801	95,380	1,298,181	0.611	0.048	0.659	0.000	0.000		0.00000	0.00000
98				FALSE	7/25/2021	96	82	14	1,196,279	95,529	1,291,808	0.607	0.048	0.656	0.000	0.000		0.00000	0.00000
99				FALSE	7/26/2021	100	79	21	1,194,543	95,808	1,290,351	0.606	0.049	0.655	0.000	0.000		0.00000	0.00000
100				FALSE	7/27/2021	104	76	28	1,193,447	96,068	1,289,515	0.606	0.049	0.655	0.000	0.000		0.00000	0.00000