1001 Freelance Projects
Latest Projects from Freelance Marketplaces
Today is: 10-Feb-2026 19:15 GMT
View Project
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)
Last Projects / Browse Projects
  Project Started
Android WhatsApp-Style Messaging Clone
Category: Figma, UI / User Interface, UX / User Experience, Wireframes
Budget: $30 - $250 USD
10-Feb-2026
17:00 GMT
PDF Text Modification Task
Category: Adobe Acrobat, Adobe Creative Cloud, Adobe InDesign, Graphic Design, PDF, Word
Budget: $10 - $30 USD
10-Feb-2026
16:58 GMT
Please read before applying.
Category: Academic Writing, Article Writing, Business Management, Business Writing, Editing, Proofreading, Research, Research Writing
Budget: $20 - $25 USD
10-Feb-2026
16:57 GMT
Virtual Legal Admin Assistant -- 2
Category: Admin Support, Data Entry, Legal, Legal Research, Legal Writing, Local Job, Microsoft 365, Proofreading, Research, Time Management
Budget: $2 - $8 USD
10-Feb-2026
16:57 GMT
E-commerce Text & Image Scraper Needed -- 2
Category: Data Analysis, Data Extraction, PHP, Python, Scrapy, Selenium, Software Architecture, Web Scraping
Budget: $30 - $250 USD
10-Feb-2026
16:56 GMT
Fix PHP Image Loading
Category: CSS, Debugging, HTML, JavaScript, PHP, Web Design, Web Development, Web Hosting
Budget: $10 - $30 AUD
10-Feb-2026
16:55 GMT
Video Editor & Instagram Feed Designer (Long-Term Collaboration)
Category: Adobe Premiere Pro, Content Creation, Final Cut Pro, Instagram Marketing, Marketing, Marketing Strategy, Social Media Management, Video Editing, Video Production, Visual Design
Budget: $30 - $250 USD
10-Feb-2026
16:54 GMT
Traditional Composite Deck Plans
Category: AutoCAD, Building Design, CAD / CAM, Construction Engineering, Construction Management, Engineering, Graphic Design, Mechanical Engineering
Budget: $250 - $750 USD
10-Feb-2026
16:54 GMT
2D Animated Short Film
Category: 2D Animation, 2D Animation Explainer Video, 2D Game Art, 2D Layout, 3D Animation, Adobe Animate, After Effects, Animation, Illustration, Toon Boom
Budget: $1500 - $3000 USD
10-Feb-2026
16:54 GMT
Full stack developer required
Category: AngularJS, Full Stack Development, JavaScript, Node.js, NoSQL Couch & Mongo, React.js, REST API, RESTful API, Vue.js, Web Design
Budget: $30 - $250 NZD
10-Feb-2026
16:53 GMT
Comprehensive Finance Thesis Support
Category: Data Analysis, Machine Learning (ML), Research Writing, SPSS Statistics, Statistical Analysis, Statistics
Budget: $250 - $750 USD
10-Feb-2026
16:53 GMT
Virtual Legal Admin Assistant
Category: Admin Support, Data Entry, Legal, Legal Research, Legal Writing, Microsoft 365, Proofreading, Research, Tax Law, Time Management
Budget: $2 - $8 USD
10-Feb-2026
16:52 GMT
Fix Shopify Mobile Header Width
Category: CSS, Frontend Development, JavaScript, Shopify, Shopify Development, Shopify Templates, Web Design, Web Development
Budget: £10 - £20 GBP
10-Feb-2026
16:52 GMT
Modern Salla Store & Ads Launch
Category: Google Ads, Google Analytics, Graphic Design, Mobile App Development, UI / User Interface, Web Design
Budget: $30 - $250 USD
10-Feb-2026
16:52 GMT
AirPods UV Case CAD Design
Category: 3D CAD, 3D Modelling, 3D Printing, AutoCAD, CAD / CAM, Fusion 360, Mechanical Engineering, Product Design
Budget: £20 - £250 GBP
10-Feb-2026
16:51 GMT
Browse All Projects
Projects by Skills ...
Projects for 'android'
Projects for 'ajax'
Projects for 'asp'
Projects for 'aspnet'
Projects for 'cms'
Projects for 'cpp'
Projects for 'csharp'
Projects for 'css'
Projects for 'delphi'
Projects for 'design'
Projects for 'drupal'
Projects for 'excel'
Projects for 'facebook'
Projects for 'flash'
Projects for 'html'
Projects for 'java'
Projects for 'javascript'
Projects for 'joomla'
Projects for 'iphone'
Projects for 'mysql'
Projects for 'photoshop'
Projects for 'php'
Projects for 'python'
Projects for 'ruby'
Projects for 'seo'
Projects for 'sql'
Projects for 'sysadm'
Projects for 'translate'
Projects for 'typing'
Projects for 'twitter'
Projects for 'vbnet'
Projects for 'xml'
Projects for 'wordpress'
Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android'
RSS feed for 'ajax'
RSS feed for 'asp'
RSS feed for 'aspnet'
RSS feed for 'cms'
RSS feed for 'cpp'
RSS feed for 'csharp'
RSS feed for 'css'
RSS feed for 'delphi'
RSS feed for 'design'
RSS feed for 'drupal'
RSS feed for 'excel'
RSS feed for 'facebook'
RSS feed for 'flash'
RSS feed for 'html'
RSS feed for 'java'
RSS feed for 'javascript'
RSS feed for 'joomla'
RSS feed for 'iphone'
RSS feed for 'mysql'
RSS feed for 'photoshop'
RSS feed for 'php'
RSS feed for 'python'
RSS feed for 'ruby'
RSS feed for 'seo'
RSS feed for 'sql'
RSS feed for 'sysadm'
RSS feed for 'translate'
RSS feed for 'typing'
RSS feed for 'twitter'
RSS feed for 'vbnet'
RSS feed for 'xml'
RSS feed for 'wordpress'
RSS feed for 'writing'
New!
Проекты на русском
(Projects in Russian)

Short URL:
1001fp.com
Mobile version:
m.1001freelanceprojects.com
Copyright © 2005-2025 1001 Freelance Projects