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
Build a Platform to Connect with Clients Interested in Cryptocurrency and Fiat Exchange
Category : Graphic Design, HTML, PHP, Software Architecture, Web Design Budget : $45 - $90 USD
23 Apr 2026 17:27 GMT
English-to-Brazilian Portuguese Academic Translation
Category : Academic Writing, Editing, English (US) Translator, English Translation, Marketing, Portuguese (Brazil) Translator, Proofreading, Translation Budget : $10 - $30 USD
23 Apr 2026 16:02 GMT
Convert Excel VBA App Online
Category : Excel, Frontend Development, JavaScript, Node.js, Python, Svelte, Visual Basic, Web Development Budget : $30 - $250 USD
23 Apr 2026 16:01 GMT
Michigan Commercial Owners Lead Generation
Category : Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, Excel, Lead Generation, Web Search Budget : $30 - $250 USD
23 Apr 2026 16:01 GMT
Bet/Bahis Sitesi İçin Canlı Destek Uzmanı
Category : Call Center, Copy Typing, Excel, Web Search, Word Budget : $2 - $8 USD
23 Apr 2026 16:01 GMT
Accurate Copy-Paste Data Entry
Category : Copy Typing, Data Entry, Editing, Excel, Microsoft Office, Proofreading, Typing, Word Budget : ₹750 - ₹1250 INR
23 Apr 2026 16:01 GMT
Full-Stack Engineer Needed
Category : Agile Development, CI / CD, Full Stack Development, Git, Java, JavaScript, MySQL, Node.js, PHP, React.js Budget : $25 - $50 USD
23 Apr 2026 16:01 GMT
Bring Paying Web-Dev Clients
Category : AI Development, Internet Marketing, Lead Generation, Marketing, Mobile App Development, Sales, SEO, Social Media Marketing Budget : $250 - $750 USD
23 Apr 2026 16:00 GMT
Custom Journal Posting System Development
Category : Database Management, Frontend Development, HTML, MySQL, PHP, Web Development, WordPress Budget : ₹600 - ₹1500 INR
23 Apr 2026 15:57 GMT
Incident Logging Tool Development
Category : Automation, Bubble Developer, Data Analysis, Data Visualization, Database Design, Database Management, Documentation, Software Architecture, UI / User Interface, Web Application Budget : $25 - $50 USD
23 Apr 2026 15:57 GMT
Bilingual Latino Survey Deployment Phase 2
Category : Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, Email Marketing, Excel, Spanish Translator, Survey Research, Translation Budget : $30 - $250 USD
23 Apr 2026 15:57 GMT
WhatsApp Resume-Collection Chatbot
Category : API Integration, Chatbot, Google App Engine, Google Sheets, JavaScript, PHP, Software Architecture, Twilio Budget : ₹1500 - ₹12500 INR
23 Apr 2026 15:57 GMT
Buyer-Seller Chat Integration for plot
Category : Android, API Development, Database Design, Frontend Development, JavaScript, Laravel, Mobile App Development, Node.js, PHP, Web Development Budget : ₹1500 - ₹12500 INR
23 Apr 2026 15:55 GMT
Overlay Property Survey on Aerials
Category : Photoshop, Digital Art, Graphic Design, Illustration, Image Analysis, Image Processing, Photo Editing Budget : $30 - $250 USD
23 Apr 2026 15:54 GMT
Website User Experience Overhaul
Category : Adobe Illustrator, Figma, Graphic Design, Interaction Design, UI / User Interface, User Experience Research, User Interface / IA, UX / User Experience, Web Design Budget : $30 - $250 USD
23 Apr 2026 15:54 GMT
Browse All Projects