Support Calculator20210816.xlsx

	A	B	C	D
1
2
3	AGA Tournament Support calculator
4
5	Note: this is an example only, and uses numbers that might apply to a small state.
6	Larger areas will get much more.
7
8		Subsidy per	Number of	Total
9		Member	Members*	Subsidy
10	Size of Tournamment	$3.00	16	$48.00
11	Current AGA members in catchment area	$2.00	41	$82.00
12	Lapsed members < 5 years in catchment area	$0.50	36	$18.00
13
14	Total Subsidy for membership & Participation			$148.00
15
16	State Championships	1	0	$200.00
17
18	Total subsidy			$348.00
19
20
21
22
23
24
25
26
27	* This will be the number of full members as of the end of the event -- signups and renewals will count.
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