CDC Flu Testing Archives Auto-Fill

	A	B	C	D	E	F	G	H	I	J	L	M	N	O	P	Q	R	S	T	U	V
1	CDC Flu View Year-to-Date Comparison for Weeks 40 to 18 (Source: CDC Flu View Archives)											CDC Flu View Comparison for Week Number 18 (Source: CDC Flu View Archives)
2	18
3		Public Health Labs			Clinical Labs			Total					Public Health Labs			Clinical Labs			Total
4		Positives	Tests	% Pos	Positives	Tests	% Pos	Positives	Tests	% Pos			Positives	Tests	% Pos	Positives	Tests	% Pos	Positives	Tests	% Pos
5	2015-2016	0	0	#DIV/0!	0	0	#DIV/0!	0	0	#DIV/0!		201618	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
6	2016-2017	0	0	#DIV/0!	118,342	824,838	14.35%	118,342	824,838	14.35%		201718	#N/A	#N/A	#N/A	713	10,645	6.70%	#N/A	#N/A	#N/A
7	2017-2018	0	0	#DIV/0!	0	0	#DIV/0!	0	0	#DIV/0!		201818	#N/A	#N/A	#N/A	713	10,645	6.70%	#N/A	#N/A	#N/A
8	2018-2019	0	77,361	0.00%	175,020	1,102,844	15.87%	175,020	1,180,205	14.83%		201918	49	339	14.45%	686	14,666	4.68%	735	15,005	4.90%
9	2019-2020	45,366	91,968	49.33%	248,486	1,373,230	18.10%	293,852	1,465,198	20.06%		202018	25	617	4.05%	21	7,467	0.28%	46	8,084	0.57%
10	Weeks 40 to 18 Average	9,073	33,866	26.79%	108,370	660,182	#DIV/0!	117,443	694,048	#DIV/0!		Week 18 Average 2016 to 2020	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
11	2020-2021	249	477368	0.05%	1848	1027277	0.18%	2097	1,504,645	0.14%		202118	1	9,537	0.01%	22	22,487	0.10%	23	32,024	0.07%
12	2021-2022	20,386	797873	2.56%	99,526	2359786	4.22%	119,912	3,157,659	3.80%		202218	406	12,803	3.17%	5,017	58,131	8.63%	5,423	70,934	7.65%
13	2022-2023	29,109	241,869	12.04%	351,710	3,311,991	10.62%	380,819	3,553,860	10.72%		202318	35	3,553	0.99%	390	41,964	0.93%	425	45,517	0.93%
14	2023-2024	35,291	106,220	33.22%	342,306	3,164,228	10.82%	377,597	3,270,448	11.55%		202418	241	1,046	23.04%	1,831	56,676	3.23%	2,072	57,722	3.59%
15
16	2015-2016	Public Health Labs										Clinical Labs
17		#N/A										#N/A							Total Pos
18											0								0
19											0								0
20											0								0
21											0								0
22											0								0
23											0								0
24											0								0
25											0								0
26											0								0
27											0								0
28											0								0
29											0								0
30											0								0
31											0								0
32											0								0
33											0								0
34											0								0
35											0								0
36											0								0
37											0								0
38											0								0
39											0								0
40											0								0
41											0								0
42											0								0
43											0								0
44											0								0
45											0								0
46											0								0
47											0								0
48											0								0
49											0								0
50											0								0
51											0								0
52											0								0
53											0								0
54											0								0
55											0								0
56											0								0
57											0								0
58											0								0
59											0								0
60											0								0
61											0								0
62											0								0
63											0								0
64											0								0
65											0								0
66											0								0
67											0								0
68											0								0
69											0								0
70											0								0
71											0								0
72	2016-2017	Public Health Labs									0	Clinical Labs							0
73		#N/A									0	Week	Total A	Total B	Percent Positive A	Percent Positive B	Total # Tested	% Positive	#VALUE!
74											0	201640	131	97	0.96	0.71	13,576	1.67	228
75											0	201641	107	83	0.77	0.6	13,814	1.37	190
76											0	201642	115	96	0.79	0.66	14,587	1.44	211
77											0	201643	139	84	0.94	0.56	14,794	1.5	223
78											0	201644	192	114	1.2	0.71	16,051	1.9	306
79											0	201645	261	121	1.52	0.7	17,172	2.22	382
80											0	201646	334	141	1.83	0.77	18,260	2.6	475
81											0	201647	437	165	2.47	0.93	17,677	3.4	602
82											0	201648	500	174	2.43	0.84	20,599	3.27	674
83											0	201649	672	179	3.42	0.91	19,624	4.33	851
84											0	201650	1,312	200	5.84	0.89	22,459	6.73	1,512
85											0	201651	2,368	321	9.28	1.26	25,488	10.55	2,689
86											0	201652	3,824	370	12.34	1.19	30,978	13.53	4,194
87											0	201701	4,027	365	12.09	1.1	33,313	13.18	4,392
88											0	201702	4,492	432	13.51	1.3	33,238	14.81	4,924
89											0	201703	5,393	598	15.83	1.76	34,062	17.58	5,991
90											0	201704	5,720	746	15.9	2.06	35,966	17.97	6,466
91											0	201705	7,060	989	18.53	2.6	38,108	21.12	8,049
92											0	201706	8,879	1,745	19.82	3.9	44,792	23.71	10,624
93											0	201707	8,866	2,411	18.98	5.16	46,690	24.15	11,277
94											0	201708	8,073	2,767	18.05	6.19	44,689	24.25	10,840
95											0	201709	5,080	2,252	13.28	5.89	38,251	19.16	7,332
96											0	201710	4,079	2,636	11.42	7.38	35,728	18.79	6,715
97											0	201711	3,240	2,982	9.61	8.84	33,717	18.45	6,222
98											0	201712	3,033	3,538	9.24	10.78	32,832	20.01	6,571
99											0	201713	2,145	3,397	7.11	11.27	30,153	18.37	5,542
100											0	201714	1,310	2,774	4.87	10.31	26,901	15.18	4,084