Project title:
Coach Excellency Live Logger in Excel
Posted by:
External project from PeoplePerHour
Started:
09-Feb-2026 13:59 GMT
Description:
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.
Project ID:
3469278
Project category:
Project budget:
Project
Started
YouTube Shorts Editor for Current Events
Category : After Effects, Video Editing, Video Production, Video Services, Videography Budget : min ₹600 INR
12-Feb-2026 08:34 GMT
WordPress Migration to Hostinger Hosting
Category : Database Management, HTML, MySQL, PHP, Web Design, Web Development, Web Hosting, WordPress Budget : €30 - €250 EUR
12-Feb-2026 05:03 GMT
Remote VBS Batch Number Prefixer
Category : AutoHotkey, Automation, Scripting, Shell Script, Software Architecture, System Administration, VBScript, Windows Desktop Budget : $10 - $30 USD
12-Feb-2026 05:03 GMT
YouTube Motion Graphics Video Editor
Category : Adobe Premiere Pro, After Effects, Animation, Color Grading, Video Editing, Video Post Editing, Video Production, Video Services Budget : ₹600 - ₹1500 INR
12-Feb-2026 05:02 GMT
Automation-First Sales System Lead Handling MVP
Category : API Development, Automation, CI / CD, Database Management, JavaScript, Node.js, NoSQL Couch & Mongo, PostgreSQL, Software Development, Software Testing Budget : ₹250000 - ₹500000 INR
12-Feb-2026 05:01 GMT
Kit de Autoestudo para Viagens
Category : Content Creation, Educational Research, Graphic Design, Instructional Design, Language Tutoring, Logo Design, Photoshop, Video Services Budget : $250 - $750 USD
12-Feb-2026 05:00 GMT
Python Developer: Inventory Tracking & Sales Analytics Bot for MercadoLibre (MLV) Venezuela
Category : Data Analysis, Data Analytics, FastAPI, Flask, MySQL, PHP, PostgreSQL, Python, Software Architecture, SQLite Budget : $30 - $250 USD
12-Feb-2026 04:58 GMT
SocialBee Expert for Sports Brand Management
Category : Article Writing, Content Creation, Content Writing, Copywriting, HTML, Instagram, Social Media Management, Social Media Marketing Budget : ₹750 - ₹1250 INR
12-Feb-2026 04:58 GMT
Luxury One-Piece Swimwear Design
Category : Fashion Consulting, Fashion Design, Fashion Modeling, Fashion Writing, Graphic Design, Pattern Making, Product Design, Textile Engineering Budget : $1500 - $3000 USD
12-Feb-2026 04:57 GMT
deploy and configure the open-source Signal Private Messenger server
Category : Database Administration, J2EE, Java, Linux, Node.js, PostgreSQL, Redis Budget : ₹1500 - ₹12500 INR
12-Feb-2026 04:57 GMT
Commercial Lease Review and Negotiation
Category : Contract Management, Contracts, Legal, Legal Consultation, Legal Research, Legal Writing, Real Estate, Real Estate Management Budget : $30 - $250 CAD
12-Feb-2026 04:57 GMT
Vibrant Logo & Gift Box Design with 3D model for perfume brand
Category : 3D Design, Adobe Creative Suite, Adobe Illustrator, Photoshop, Graphic Design, Illustration, Logo Design, Packaging Design, Print Design Budget : ₹600 - ₹1500 INR
12-Feb-2026 04:56 GMT
Lead Generation Specialist Needed – Find High-End Companies
12-Feb-2026 04:53 GMT
Need Expert to Fix Large MP4 Video File Not Playing Anywhere
12-Feb-2026 04:53 GMT
DigitalOcean Discourse Forum Update
12-Feb-2026 04:53 GMT
Browse All Projects