1001 Freelance Projects -- Coach Excellency Live Logger in Excel

Latest Projects from
Freelance Marketplaces

View this project in detail (Note: you will be redirected to external marketplace)
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:

View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
Upload 2,000 Product Manuals Category: Content Management System (CMS), Data Entry, Data Management, Data Processing, Product Descriptions, Product Management, Web Design, Web Development, Website Management Budget: $30 - $250 USD	29 Mar 2026 22:04 GMT
Traditional Single-Family Home Architecture Category: Architectural Engineering, Architecture, AutoCAD, Building Architecture, Building Design, Building Information Modeling, Home Design, Interior Design, Revit, Structural Engineering Budget: $2000 - $5000 USD	29 Mar 2026 22:03 GMT
Davranışsal Psikanaliz Raporu -- 2 Category: Academic Writing, Data Analysis, Psychology, Qualitative Research, Report Writing, Research Writing, Statistical Analysis Budget: $8 - $15 USD	29 Mar 2026 22:02 GMT
New logo for our SaaS POS sytem Category: Graphic Design, Logo Animation, Logo Design, Mobile App Development, Payment Processing, Web Design Budget: €8 - €10 EUR	29 Mar 2026 21:53 GMT
Children’s Flap Book Finalisation Category: Adobe Illustrator, Adobe InDesign, Photoshop, Book Cover Design, Graphic Design, Illustration, Print Design Budget: £20 - £250 GBP	29 Mar 2026 21:53 GMT
Modern Writing Portfolio Website Category: CMS, HTML, PHP, UI / User Interface, Web Design, Web Development, WordPress Budget: $30 - $250 USD	29 Mar 2026 21:53 GMT
Creative Writing Portfolio Website Category: Content Management System (CMS), Creative Writing, CSS, HTML, SEO, Web Design, Web Development, WordPress Budget: $30 - $250 USD	29 Mar 2026 21:51 GMT
Excel Sales Data Forecasting Category: Data Analysis, Data Analytics, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Statistics Budget: $30 - $250 USD	29 Mar 2026 21:51 GMT
Eco-Activism Website Development Category: Blog Writing, Graphic Design, HTML, PHP, Web Design, Web Development Budget: $250 - $750 USD	29 Mar 2026 21:51 GMT
Academic Research Writing Support Category: Academic Research, Academic Writing, Content Writing, Drafting, Editing, Ghostwriting, Research, Research Writing Budget: £250 - £750 GBP	29 Mar 2026 21:46 GMT
editorial collage animation botanical brand storytelling Category: 2D Animation, 3D Animation, After Effects, Animation, Caricature & Cartoons, Digital Art, Graphic Design, Illustration, Motion Graphics, Procreate Budget: $250 - $750 USD	29 Mar 2026 21:42 GMT
Premium Brand PowerPoint Deck Design Category: Graphic Design, Infographics, Powerpoint, Visual Design Budget: ₹600 - ₹1500 INR	29 Mar 2026 21:42 GMT
Social Media Visual Creator Needed Category: Adobe Illustrator, Photoshop, Branding, Canva, Facebook Marketing, Graphic Design, Social Media Marketing, Video Editing Budget: $750 - $1500 USD	29 Mar 2026 21:42 GMT
Chinese Drone Export License holder Category: Cargo Freight, Custom Duties Tax, Customs And Global Trade Services, Drone Photography, Import / Export, International Shipping, Legal, Logistics, Simplified Chinese Translator, Traditional Chinese (Hong Kong) Budget: $30 - $250 USD	29 Mar 2026 21:41 GMT
Informative Copywriting for Students Category: Academic Writing, Article Writing, Blog Writing, Content Writing, Copywriting, Ghostwriting, Report Writing, Research Writing, Technical Writing, Travel Writing Budget: $15 - $25 USD	29 Mar 2026 21:40 GMT

Browse All Projects

New!
Проекты на русском (Projects in Russian)