ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Purpose:
This workbook helps you create a clear, line-item budget for your SY26-27 sports program and automatically calculates cost-per-youth metrics for OAL reviewers.
2
3
4
1. Workbook Overview
5
TabWhat You Do Here
6
Instructions (this page)Read before editing any other tab.
7
Budget DetailEnter every expense line and tag the funding source.
8
SummaryReview auto-calculated totals and check cost-per-youth (no editing needed). Red highlighting on Budget Detail flags a line missing its Category or Funding Source.
9
10
2. Color-Coding Legend
11
ColorMeaningAction Needed
12
YellowApplicant inputType or select your data.
13
GreyLocked formulaDo not edit (sheet calculates for you).
14
Red fillError alertA line has a cost entered but is missing its Category or Funding Source. Fix before submitting.
15
16
17
3. Completing the Budget Detail Tab - COMPLETE ALL FIELDS FOR EACH LINE ITEM YOU USE
18
19
Category (Column A)
20
Click a cell and choose from the drop-down list:
21
Coach Stipend, Equipment, Transportation, Facility Rental, Activation Costs, Admin, Insurance, Other
22
If "Other," explain in "Description." Row 2 is a filled-in example — delete it before submitting. The tab has 60 rows ready to use; you don't need to fill every row.
23
24
Description (Column B)
25
Briefly describe the item (e.g., “Girls Volleyball game jerseys – 20 units”).
26
27
Qty (Column C)
28
Enter a whole number only.
29
30
Unit Cost $ (Column D)
31
Enter the cost per single unit in dollars.
32
33
Line Total (Column E)
34
Auto-calculates (Qty × Unit Cost). Locked.
35
36
Funding Source (Column F)
37
Choose OAL Grant, Other Confirmed, or Other Pending.
38
39
40
4. Completing the Summary Tab
41
42
Category Totals (Rows 4-10) populate automatically.
43
Total Expenses (Row 12)
44
45
Total Youth Served (Row 15, Yellow)
46
Enter the number of unique youth (grades 6–8) served by this program.
47
48
Cost per Youth (Row 16) auto-calculates.
49
50
51
5. File Naming & Submission
52
53
Make a Copy:
54
55
Go to File ➜ Make a copy and rename:
56
OrgName_OALBudgetTemplate_2026.xlsx
57
58
Protect Your Copy:
59
Grey cells are locked by real sheet protection, so formulas can't be overwritten by accident. To temporarily unlock them (e.g., to fix a typo in a formula you're troubleshooting), go to Review → Unprotect Sheet — no password is required — but re-protect before submitting.
60
61
Submit:
62
Attach this completed workbook along with your Narrative and other Required Appendices in one email to grants@oakathleticleague.org.
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