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
High-Tech Aero-dynamic Concept Spaceship/Jet (2D/3D) in Hypercar Style
Category : 2D Drawing, 2D Game Art, 3D Design, 3D Graphic Design, 3D Modelling, Automotive, Blender, Concept Art, Concept Design, Illustration Budget : €250 - €750 EUR
01-May-2026 10:03 GMT
need support from PHP developer to restore a website based on the available backup
Category : API Development, CRM, Data Management, Database Design, HTML, MySQL, PHP, WordPress Budget : $15 - $25 USD
01-May-2026 10:02 GMT
Results-Based Shopify SEO Campaign
Category : Analytics, Digital Marketing, Google Adwords, Internet Marketing, Keyword Research, Link Building, Search Engine Marketing (SEM), SEO, Shopify, Website Optimization Budget : ₹12500 - ₹37500 INR
01-May-2026 10:02 GMT
Premium Minimal Webflow Website
Category : CMS, CSS, Graphic Design, HTML, SEO, Typography, Web Design, Web Development, Webflow Budget : ₹1500 - ₹12500 INR
01-May-2026 10:01 GMT
Minimalist Blue Tech Logo -- 2
Category : Adobe Illustrator, Branding, Corporate Identity, Creative Design, Digital Design, Graphic Design, Illustration, Logo Design, Photoshop, Visual Design Budget : ₹12500 - ₹37500 INR
01-May-2026 10:01 GMT
Taboola Account Setup & Pixel Configuration
Category : Account Management, Ad Planning & Buying, Advertising, Analytics, Conversion Rate Optimization, Digital Marketing, ECommerce, Google Adwords, Internet Marketing, Website Optimization Budget : €8 - €30 EUR
01-May-2026 10:00 GMT
Secure Popcorn Retail Chain Deals
Category : Account Management, Business Development, Market Research, Product Marketing, Retail Sales, Sales, Sales Management, Sales Promotion Budget : ₹1500 - ₹12500 INR
01-May-2026 09:59 GMT
Build BigQuery Data Pipelines
Category : BigQuery, Data Warehousing, Google Cloud Platform, Hadoop, MySQL, PostgreSQL, PySpark, SQL Budget : ₹400 - ₹750 INR
01-May-2026 09:59 GMT
Professional Engineer for Parking Design and Permitting
Category : AutoCAD, Building Architecture, Civil Engineering, Construction Management, Project Management, Risk Assessment, Structural Engineering Budget : $250 - $750 USD
01-May-2026 09:59 GMT
Zoho CRM Lead Setup
Category : API Integration, CRM, Facebook Marketing, Lead Generation, PHP, Salesforce.com, Zoho, Zoho CRM Budget : ₹750 - ₹1250 INR
01-May-2026 09:59 GMT
Arabic Calligraphy Wedding Frame
Category : Adobe Illustrator, Photoshop, Calligraphy, Digital Art, Graphic Design, Illustration Budget : $10 - $30 USD
01-May-2026 09:58 GMT
SEO Linkbuilding y Tráfico Orgánico
Category : Content Marketing, Digital Marketing, Internet Marketing, Link Building, Marketing, SEO, SEO Auditing, Social Media Marketing Budget : $2 - $8 USD
01-May-2026 09:58 GMT
Print & Courier Medicine TAC
Category : Admin Support, Courier, Customer Service, Logistics, PDF Budget : $10 - $30 USD
01-May-2026 09:57 GMT
Customer Chat & Upload Produk - 28/04/2026 22:56 EDT
Category : Chatbot, Content Writing, Customer Service, Data Entry, Data Processing, Excel, Product Management Budget : ₹12500 - ₹37500 INR
01-May-2026 09:56 GMT
Bold Construction Van Wrap Design
Category : Advertisement Design, Banner Design, Branding, Creative Design, Graphic Design, Logo Design, Photoshop, Print Design Budget : $250 - $750 USD
01-May-2026 09:56 GMT
Browse All Projects