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
Rediseño de sitio WordPress para consulta terapéutica
Category : CSS, HTML, PHP, Web Design, WordPress Budget : $150 - $300 USD
04-Mar-2026 23:05 GMT
Research writing/Biology/Physiology
Category : Academic Writing, Biology, Medical Writing, Report Writing, Research, Research Writing, Scientific Research, Scientific Writing Budget : $10 - $30 AUD
04-Mar-2026 23:04 GMT
Grow My Social Media Following
Category : Analytics, Content Marketing, Digital Marketing, Facebook Marketing, Instagram Marketing, Internet Marketing, Social Media Marketing, Twitter Budget : $250 - $750 USD
04-Mar-2026 23:04 GMT
Tekla 2025 to STEP Conversion
Category : 3D CAD, 3D Design, 3D Drafting, 3D Modelling, 3D Printing, 3D Rendering, 3D Visualization, AutoCAD, CAD / CAM, Solidworks Budget : $30 - $250 AUD
04-Mar-2026 23:02 GMT
Optimizar envío SRI en Java
Category : API Development, Java, JavaScript, Performance Tuning, PHP, REST API, Software Architecture, Technical Documentation Budget : $30 - $250 USD
04-Mar-2026 23:01 GMT
Bold Supplement Jar Design - 04/03/2026 17:39 EST
Category : AI Design, AI Graphic Design, Banner Design, Creative Design, Graphic Design, Invitation Design, Logo Design, Poster Design, Product Descriptions, Product Design Budget : ₹37500 - ₹75000 INR
04-Mar-2026 23:01 GMT
Google Maps Domination Strategy
Category : Analytics, Content Marketing, Conversion Rate Optimization, Data Analysis, Google Ads, Internet Marketing, Keyword Research, Link Building, Search Engine Marketing (SEM), SEO Budget : $30 - $250 USD
04-Mar-2026 22:57 GMT
B2B/B2C Travel Booking App
Category : Android, API Integration, Flutter, IOS Development, IPhone, Mobile App Development, PHP, React Native Budget : ₹12500 - ₹37500 INR
04-Mar-2026 22:56 GMT
ADU Interior Space Review & Stamping
Category : AutoCAD, Building Architecture, CAD / CAM, Civil Engineering, Electrical Engineering, Engineering, Plumbing, Structural Engineering Budget : $250 - $750 USD
04-Mar-2026 22:53 GMT
to do NOW IMMEDIATLY : 3 small requests on a Wordpress website
Category : PHP, WordPress Budget : $10 - $30 USD
04-Mar-2026 22:49 GMT
Idaho Fraudulent Instrument Research
Category : Business Writing, Research, Research Writing Budget : $30 - $250 USD
04-Mar-2026 22:49 GMT
Laravel + QuickBooks Developer Needed to Build QuickBooks Online App Integration (OAuth + Financial Analysis)
Category : API Development, Cloud Computing, Data Extraction, Data Integration, Database Design, Financial Analysis, Laravel, OAuth, Security, Web Development Budget : $1500 - $3000 CAD
04-Mar-2026 22:49 GMT
Modern Neutral Combination Logo Design
Category : Adobe Illustrator, Branding, Graphic Design, Logo Design, Photoshop, Vector Design, Visual Design Budget : $250 - $750 USD
04-Mar-2026 22:48 GMT
Virtual Fashion E-commerce Image Generation -- 4
Category : ChatGPT, Gemini Budget : €2 - €6 EUR
04-Mar-2026 22:45 GMT
Azure Copilot Plugin Development
Category : Amazon Web Services, Azure, Azure OpenAI, C#, Programming, Cloud Computing, Documentation, GPT 4, Natural Language Processing, REST API, Terraform Budget : $250 - $750 USD
04-Mar-2026 22:45 GMT
Browse All Projects