⚽ Football Live Action Counter

📌 Overview

This project is an Excel-based tool designed to track and count live football actions during a game in real time. It allows analysts and coaches to record key actions such as shots, crosses, passes, tackles and interceptions, providing an instant visual summary through an automatically updated chart.

📥 Download the Excel Tool

---

🔍 Key Features

• 🎯 Live tracking of key football actions during a game
• 📊 Automatic chart update as actions are recorded
• ⚽ Tracks: Shots, Crosses, Passes, Tackles, Interceptions
• 🎨 Color-coded action buttons for quick and easy input
• 📈 Instant visual summary of actions per game

---

📁 Project Structure

📦 Football-Live-Action-Counter
├── 1.7.2 João Almeida.xlsm   → Excel macro-enabled action counter
└── README.md                  → Project documentation

---

🚀 How to Use

1. Download the 1.7.2 João Almeida.xlsm file
2. Open it using Microsoft Excel
3. Enable macros when prompted
4. During the game, click the colored action buttons to record each action
5. The chart updates automatically in real time

---

🛠️ Tools & Technologies

• Microsoft Excel
• VBA Macros
• Data Visualization (Excel Charts)

---

💡 Key Insights

This tool helps to:

• Track player and team actions live during a match
• Provide instant data for half-time or post-game analysis
• Support coaching decisions based on real-time statistics
• Build a simple but effective match data collection system

---

📌 Future Improvements

• Add player-specific action tracking
• Include time-stamping for each action
• Add more action categories (e.g., fouls, corners, headers)
• Export data automatically to a summary report
• Build a dashboard to compare multiple games

---

👤 Author

João Almeida — Data Analytics Portfolio LinkedIn • GitHub