ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Weekly League Financial Recap Spreadsheet
2
3
League Data
4
5
Lineage->$11.00
per bowler per week
6
Weekly Fee->$15.00
per bowler per week
7
USBC Card->$21.00
per bowler per season
8
9
Prize Fund->$14.80
per team per week
10
Sec Fee->$1.20
per team per week
11
12
No. of Bowlers->4per team
13
Starting Date->08/25/21
(Note: If any dates are skipped, enter corrected date on
14
Master sheet and rest of dates should adjust automatically.)
15
Instructions
16
17
Worksheets for up to 20 teams.
18
Less than 20 teams-remove number of bowlers from extra sheets.
19
More than 20 teams will require additional worksheets and modification of Master formulas.
20
21
Beginning of the year
22
Enter the values in the gray cells above for your league.
23
Enter team names on sheets, if desired.
24
Delete the number of bowlers per team for all extra sheets or delete extra sheets.
25
26
Weekly (on each team worksheet)
27
Enter the money collected each week
28
Edit the number of bowlers as needed
29
Enter number of pre-pay games (Pre-pay is money for last week or two of the league, not paying for members that pay ahead.)
30
Enter the number of cards purchased
31
Totals are displayed on Master worksheet
32
33
Handy hint: Use some cells to right of Master grid to add money by denomination.
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