Football Production Tracker Excel Tool

I'm looking for an Excel-based tool to track American football offensive production at the high school level. This tool should assist coaches in decision-making with real-time data visualizations.

Key Requirements:
- Track formations, play results, and key metrics
- Include:
- Yardage gained
- Downs and distances
- Player statistics
- Defensive alignment
- Average gain on specific plays
- Real-time data visualizations
- User-friendly interface for coaches

Ideal Skills and Experience:
- Excel proficiency
- Experience with data visualization
- Understanding of American football statistics and dynamics
- Background in sports analytics is a plus