CTCL grant$-per-voter analysis

	A	B	C	D	E	F	G
1			Final grant award amount	population (Census estimates, July, 2019)	Voter reg 11/2/2020	per person spend	per voter spend
2	1	Allegheny	$2,052,251.00	1,216,045	942,857	$1.69	$2.18
3	2	Armstrong		64,735	44,829
4	3	Berks	$470,929.00	421,164	272,281	$1.12	$1.73
5	4	Centre	$863,828.00	162,385	112,127	$5.32	$7.70
6	5	Chester	$2,558,000.00	524,989	380,363	$4.87	$6.73
7	6	Dauphin	$482,164.00	278,299	197,823	$1.73	$2.44
8	7	Delaware	$2,200,000.00	566,747	425,249	$3.88	$5.17
9	8	Erie	$148,729.00	269,728	202,572	$0.55	$0.73
10	9	Juniata	$11,364.00	24,763	14,484	$0.46	$0.78
11	10	Lancaster	$474,202.00	545,724	354,224	$0.87	$1.34
12	11	Lehigh	$762,635.00	369,318	249,395	$2.06	$3.06
13	12	Luzerne	$173,236.00	317,417	220,965	$0.55	$0.78
14	13	Mercer	$54,414.00	109,424	74,935	$0.50	$0.73
15	14	Mifflin	$17,930.00	46,138	27,368	$0.39	$0.66
16	15	Monroe	$113,634.00	170,271	118,025	$0.67	$0.96
17	16	Montgomery	$1,167,000.00	830,915	609,304	$1.40	$1.92
18	17	Northumberland	$44,811.00	90,843	57,632	$0.49	$0.78
19	18	Philadelphia	$10,016,074.00	1,584,064	1,129,374	$6.32	$8.87
20	19	Somerset	$37,104.00	73,447	49,276	$0.51	$0.75
21		York	$321,600.00		311,023	#DIV/0!	$1.03
22		Pike	$26,070.00		44,669	#DIV/0!	$0.58
23		Wayne	$25,098.00		35,698	#DIV/0!	$0.70
24		Venango	$21,218.00		33,305	#DIV/0!	$0.64
25
26			$22,042,291.00
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
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