Summary of Current System and Vision
We currently have an Excel-based scoring system containing 50 to 60 macros that handle score entry, leaderboard generation, and competition workflows. It works but is limited by dependence on Excel and the absence of a centralized database.
Our vision is to modernize this workflow into a custom web application that tournament coordinators can use on iPads to enter scores in real time with instant leaderboard updates. The long-term vision includes AI computer vision so players can record practice sessions at home and have the system automatically score their performance.
Core Pain Points We Need to Solve
- Excel and macros are difficult to scale and maintain
- Current process requires manual score entry and refreshes
- System needs to work smoothly on iPads and touch devices
- A real-time database is required for instant leaderboard updates
- User accounts, event management, and player profiles must be included
- The platform must support both individual and team competitions with flexible team sizes
- Integration with the existing Shopify e-commerce system is required
What the Final Product Will Look Like
Tournament Coordinator Interface (iPad-friendly)
- Simple touch interface for entering scores
- Instant real-time score submission
- Team selection and player lookup
- Option to upload players in bulk
Player and Event Portal
- User registration and login
- Player profiles with past performance and achievements
- Event browsing and registration
- Video uploads for each competition entry
Admin Dashboard
- Create and manage events
- Configure scoring rules
- Upload players using a standardized spreadsheet template or via a web form
Leaderboard System
- Real-time updates with no refresh needed
- Filters by age group, event, and location
Future Vision
- Computer vision scoring for uploaded videos or live practice
- Automated scoring for at-home training
- AI analysis similar to PB Vision