Automated Data Entry/Leaderboard for Sports Management Programs
This spreadsheet is designed to simplify the process of recording, processing and presenting scores and Brownlow votes for a school's Sports Management Program (SMP).
Includes:
- Week by week data entry for game results & Brownlow competition
- Automated, ranked & printable leaderboard for ongoing team & Brownlow competitions
- Dynamic list of fixtures list for each lesson (including consideration of what duty team is on that week, too)
Developed over 3 years, Mazenod College WA student Kai Lovel combined his frustration over the lack of automation for such processes, and skills in excel formulas and formatting, to create a solution that can be adapted and used by any school adopting the SMP style of program, or in fact any similar sport's program.