ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Good for Summer/Fall/early Winter (June-Jan)
2
Membership -BWVEnter Values for these fields
3
Points given on June 1
(Bank by Jan 31)		Points avail on June 1current point availabilityBanked availUse by May 31
(Banked + Borrowed)		Orphan PointsUnused points
(Bank to next year)		Total points usedBorrowedCalculation triggerNOTES:
4
2022100100000100100x
5
June 1 2023 - May 31 20241502501601001001015090x
6
June 1 2024 - May 31 2025150300300150150150150x
7
June 1 2025 - May 31 20261500
8
June 1 2026 - May 31 20271500
9
10
Good for Winter/Spring/early Summer (Dec-July)
11
Membership -VGFEnter Values for these fields
12
Points given on Dec 1
(Bank by July 31)		Points avail on Dec 1current point availabilityBanked availUse by May 31
(Banked + Borrowed)		Orphan PointsUnused points
(Bank to next year)		Total points usedBorrowedCalculation triggerNOTES:
13
202220000000x
14
Dec 1 2023 - Nov 30 202420020020000200x
15
Dec 1 2024 - Nov 30 20252000
16
Dec 1 2025 - Nov 30 20262000
17
Dec 1 2026 - Nov 30 20272000
18
19
20
21
22
Column formulasPoints avail on xxx
(calc: (new points-borrowed points for previous year) +
(Banked points+Borrowed from next year)		current point availability
(calc: points avail on xxx - points used)		Banked avail
(calc: pulled from previous year)		Use by xxx of following year
(calc: banked avail + borrowed)		Banked points
Current year used points
(value needs to be entered)		Borrowed
(value needs to be entered)		Place any character to do line calculations for that UY
23
24
25
26
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