This template handles the structure problem — you still need to fill in the dates and times, but the matchup matrix, standings table, and printable format are all pre-built.
Download it, enter your team names in one spot, and the rest of the workbook updates automatically.
What's in the Template
The Excel file has four tabs:
1. Team Setup Enter your 8 team names here. Every other tab references this list. Change a name once and it updates everywhere.
2. Schedule All 28 games in round order, with columns for:
- Round number
- Home team / Away team
- Date (enter manually)
- Time (enter manually)
- Location/rink
- Score fields (fill in after games)
3. Standings Auto-calculates from the scores you enter in the Schedule tab:
- Games Played
- Wins / Losses / OT Losses
- Goals For / Goals Against
- Points
Sort by points to see the current standings at any point in the season.
4. Printable Game Sheet A clean one-page layout showing the week's games — formatted for printing or sharing as a PDF. Update the week number to show different rounds.
How to Fill It In
- Enter your 8 team names in the Team Setup tab (cells B2–B9)
- Add game dates and times in the Schedule tab, column by column
- Enter scores after each game in the Score columns
- Share the Standings tab link with team captains (or screenshot it weekly)
The formula logic uses simple COUNTIFS and SUMIFS — no macros, no external dependencies. It works in Excel 2016+, Excel 365, and Google Sheets.
Important Limitations
This is a static template, not a scheduling engine. It does not:
- Suggest ice slot assignments — you fill in dates/times based on your ice inventory
- Flag conflicts — if you enter the same team twice in one round, it won't warn you automatically (add a COUNTIFS check manually if needed)
- Handle reschedules — if a game moves, you update the date/time manually and it doesn't cascade to anything else
- Enforce rest rules — no automatic check for back-to-back games
For leagues where the constraint-solving matters, these are real limitations. A 10-team, multi-facility schedule with meaningful team preferences needs a tool that can reason about the full constraint space simultaneously.
PDF Version
The PDF download is a blank printable version — teams fill in game results by hand. It's useful for:
- Posting at the rink
- Distributing to team captains who don't use spreadsheets
- Record-keeping if you run a paper-based league
It won't calculate standings automatically. That's the Excel version's job.
Frequently Asked Questions
Does this work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All the COUNTIFS and SUMIFS formulas are compatible. Formatting may shift slightly on the Printable Game Sheet tab.
Can I add more teams?
Not without rebuilding the matchup matrix. 8-team round-robin is a specific mathematical structure. For different team counts, download the appropriate template.
What if I'm running a double round-robin?
A double round-robin doubles each matchup — 56 games total. We don't have a pre-built template for this yet. Reach out and we can build one for your specific league.
Can I protect the formula cells?
Yes. In Excel: Review → Protect Sheet → select "Protect worksheet" and check "Select unlocked cells." Unlock only the input cells (team names, dates, times, scores) before protecting.