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
Accurate Spreadsheet Data Entry
Category : Copy Typing, Data Analysis, Data Collection, Data Entry, Data Management, Data Processing, Excel, Excel Macros, Google Sheets, Inventory Management Budget : $10 - $30 USD
09 Feb 2026 17:04 GMT
Find 1M+ Instagram Meme Page
Category : Content Strategy, Data Entry, Facebook Marketing, Instagram Marketing, Internet Marketing, Market Research, Social Media Management, Social Media Marketing Budget : ₹12500 - ₹37500 INR
09 Feb 2026 17:04 GMT
Tech Blog Content Writer Needed
Category : Article Writing, Blog, Blog Writing, Content Writing, Digital Marketing, Ghostwriting, SEO, Technical Writing Budget : ₹400 - ₹750 INR
09 Feb 2026 17:04 GMT
Cinematic Car Delivery Shoot
Category : After Effects, Cinematography, Photo Editing, Photography, Photoshop, Product Photography, Video Editing, Visual Arts Budget : ₹600 - ₹1500 INR
09 Feb 2026 17:02 GMT
B2B Appointment Setting Campaign
Category : Appointment Setting, B2B Marketing, Email Marketing, Internet Marketing, Lead Generation, Marketing, Sales, Telemarketing Budget : €30 - €250 EUR
09 Feb 2026 17:02 GMT
Senior Full Stack Developers with good experience in .NET Core & Angular based application development
Category : .NET Core, Agile Development, Angular, Full Stack Development, Git, Microsoft Azure, Microsoft SQL Server, RESTful API Budget : ₹750 - ₹1250 INR
09 Feb 2026 17:02 GMT
Automated Stock Trading Software Development
Category : Data Analysis, Financial Software Development, HTML, PHP, Software Architecture, UI / User Interface, Web Development, Web Design Budget : ₹1500 - ₹12500 INR
09 Feb 2026 17:00 GMT
Family Health-Accident Insurance Customers - Lead Generation
Category : Content Marketing, Digital Marketing, Email Marketing, Lead Generation, Market Research, Sales, Social Media Marketing Budget : ₹600 - ₹1500 INR
09 Feb 2026 16:59 GMT
Commercial Data Network Installation
Category : Cisco, Electrical Engineering, Network Administration, Network Engineering, Network Monitoring, Network Security, Technical Support, Wireless Budget : $15 - $25 USD
09 Feb 2026 16:59 GMT
React & Node Full-Stack App
Category : Express JS, JavaScript, MongoDB, Node.js, NoSQL Couch & Mongo, PostgreSQL, React.js, RESTful API Budget : ₹1500 - ₹12500 INR
09 Feb 2026 16:58 GMT
Develop Reception and collab zone in 3Ds max of a college
Category : 3D Animation, 3D Modelling, 3D Rendering, 3D Visualization, 3ds Max, Architectural Visualization, Interior Design, V Ray Budget : ₹12500 - ₹37500 INR
09 Feb 2026 16:57 GMT
Advanced Physics Fact-Checker
Category : Editing, Mathematics, Physics, Physics Tutoring, Writing Budget : £20 - £250 GBP
09 Feb 2026 16:56 GMT
Simple Fantasy Miniature Sculpt
Category : 3D Art, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization Budget : €8 - €30 EUR
09 Feb 2026 16:56 GMT
Traditional Wedding Videography
Category : Audio Engineering, Cinematography, Editing, Film Production, Final Cut Pro, Post Production, Video Editing, Video Production, Video Services, Videography Budget : £1500 - £3000 GBP
09 Feb 2026 16:56 GMT
Creative Logo Design Project
Category : Adobe Creative Cloud, Adobe Illustrator, Photoshop, Creative Design, Digital Design, Graphic Design, Illustration, Logo Design, Vector Design, Visual Design Budget : $10 - $15 USD
09 Feb 2026 16:55 GMT
Browse All Projects