Coach Excellency Live Logger in Excel

Project Overview

We want to build an Excel-based Coach Excellency Tracker for live football coaching sessions. The tool should:

Track the total session time with a live timer.

Record different activity types (Ball Rolling, Intervention, Transition) with live start/stop buttons.

Capture the duration of each activity and accumulate it over the session.

Display the proportion of each activity as a live pie chart (percentage of total session time).

Allow multiple coaches to be logged optionally.

This tool is intended for real-time use during coaching sessions.


Functional Requirements
1. Session Timer

A live timer cell showing the overall session duration.

Start/Stop buttons to control the session timer.

2. Activity Logging

Buttons for Ball Rolling, Intervention, and Transition.

Each activity button starts a timer for that activity.

A Stop Activity button logs the duration of the current activity.

Durations are cumulative, so multiple interventions or ball rolling periods sum automatically.

Optional dropdown to select Coach Name for multi-coach sessions.

3. Data Capture

Sheet called DATA or Capture stores:
| Timestamp | Coach | Event Type | Activity Name | Duration (seconds) |

Each Stop Activity records:

Timestamp of end

Coach (from dropdown or fixed cell)

Event type

Activity name

Duration of the activity

4. Live Dashboard

Cells showing total time spent for each activity:

Ball Rolling

Intervention

Transition

Pie Chart updating live as activities are logged, showing percentage of total session for each activity.

Optional: Bar chart for cumulative time per activity.

5. Buttons

Start Session → starts total session timer

Stop Session → stops total session timer

Ball Rolling → starts Ball Rolling activity

Intervention → starts Intervention activity

Transition → starts Transition activity

Stop Activity → stops current activity and logs duration

Technical Requirements

Must be built in Excel (.xlsm) with VBA.

Timers must use Timer function or equivalent for live tracking.

Pie chart must update automatically as activity durations change.

All macros and buttons should be user-friendly and clearly labeled.

Optional: Clear instructions on how to start/stop sessions and activities.

Deliverables

Excel workbook (.xlsm) with:

Live session timer

Activity buttons

Cumulative activity tracking

Auto-updating pie chart

DATA sheet logging all activity events

Brief user instructions sheet on how to use the logger.

Skills Required

Excel VBA / Macros

PivotTables and Charts

Experience with live timers in Excel

Estimated Effort

3–5 hours for a competent VBA developer.

Should be delivered fully functional and tested.