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
Application using flutter
Category : Android, App Design, Flutter, IOS Development, IPhone, Mobile App Development, PHP, Web Development Budget : $8 - $15 USD
11-May-2026 16:04 GMT
Adult Speed Typing Course Content
Category : Article Writing, Content Writing, Copywriting, ELearning, Ghostwriting, Google Docs, Instructional Design Budget : ₹750 - ₹1250 INR
11-May-2026 16:02 GMT
Tech Blog Content Creation
Category : Article Writing, Blog Writing, Content Writing, Copywriting, Ghostwriting, Java, Python, Script Writing Budget : min ₹2500 INR
11-May-2026 16:01 GMT
Animated Telegram Stickers Logo Swap
Category : 2D Animation, Photoshop, After Effects, Animated Video Development, Animation, GIF Animation, Logo Design Budget : $10 - $15 USD
11-May-2026 16:01 GMT
Diseño Interior Residencial Moderno
Category : 3D Modelling, 3D Rendering, 3D Visualization, Architectural Visualization, Concept Design, Furniture Design, Graphic Design, Home Design, Interior Design, Lighting Design Budget : €250 - €750 EUR
11-May-2026 16:00 GMT
Sistema de Membresías Full-Stack - 11/05/2026 11:45 EDT
Category : API Development, API Testing, MySQL, Node.js, PostgreSQL, React Native, Spring Boot Budget : $3000 - $5000 USD
11-May-2026 16:00 GMT
Beginner SolidWorks Modeling Tutor
Category : 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Rendering, Finite Element Analysis, Mechanical Engineering, Solidworks Budget : $250 - $750 USD
11-May-2026 16:00 GMT
Multi-Industry SaaS & Digital Signage Integration
Category : Android, Flutter, Mobile App Development, Node.js, PHP, SaaS, Software Architecture, WebRTC Budget : ₹1500 - ₹12500 INR
11-May-2026 15:59 GMT
Anime Novel Cover Art
Category : 2D Drawing, Book Cover Design, Caricature & Cartoons, Character Illustration, Concept Art, Digital Art, Graphic Design, Illustration, Photoshop Budget : $100 - $1000 USD
11-May-2026 15:59 GMT
Financial Operations & Bookkeeping Support
Category : Accounting, Bookkeeping, Finance, Financial Forecasting, Google Sheets, Intuit QuickBooks, Payroll, Xero Budget : $25 - $50 USD
11-May-2026 15:57 GMT
Create 50 Personal Gmail Accounts
Category : Account Management, Customer Support, Data Entry, Data Processing, Email Handling, Internet Research, Project Management, Security, Technical Support, Time Management Budget : ₹100 - ₹400 INR
11-May-2026 15:57 GMT
Make My Fusion360 AutoCAD Design 3D-Print Ready
Category : 3D CAD, 3D Design, 3D Modelling, 3D Printing, 3D Rendering, AutoCAD, CAD / CAM, Fusion 360, Mechanical Design, Mechanical Engineering Budget : ₹600 - ₹1000 INR
11-May-2026 15:57 GMT
Custom React Application Development
Category : AngularJS, API, Frontend Development, Git, JavaScript, Node.js, NoSQL Couch & Mongo, Web Development Budget : ₹12500 - ₹37500 INR
11-May-2026 15:55 GMT
Expert Frontend Developer Needed for Cinematic Storytelling Portfolio Website
Category : Next.js, React.js, Tailwind CSS, Three.js, Web Development, Web Design Budget : $30 - $250 USD
11-May-2026 15:55 GMT
Green Net: Phone App for My Godaddy Acct.
Category : Android, Backend Development, IOS Development, IPhone, Mobile App Development, Payment Gateway Integration, PHP, Travel Ready, UI / User Interface, User Experience Research Budget : $15 - $25 USD
11-May-2026 15:54 GMT
Browse All Projects