Data Tracking Google Sheet for Fitness

Posted last week

Worldwide

Summary

I need someone to build a Google Sheet for tracking fitness data, including macro intake, workouts, sleep, and meals for my clients. The ideal candidate will have experience in creating organized and user-friendly spreadsheets that can efficiently manage and display data. This project requires an intermediate level of proficiency and is expected to be completed in less than a month. I'm an online fitness coach looking for an experienced Google Sheets (or Excel) expert to build a professional client management system that I can use for my coaching business. The system should be modern, intuitive, automated where possible, and easy to use without requiring advanced spreadsheet knowledge. I plan to coach 50+ clients over the next few years. I want this to be scalable and easy to duplicate as my business grows. (Long term coaching system) Main Features 1. Client Database A master dashboard containing: Client Name Start Date Goal Current Phase (Bulk / Cut / Maintenance) Status (Active / Paused / Completed) Link to each client's individual dashboard 2. Individual Client Dashboard Should include: Personal Information Age Height Starting Weight Current Weight Goal Weight Activity Level 3. Progress Tracking Weekly tracking for: Average body weight Waist measurement Other body measurements (optional) Progress photos (link or embedded) Weight trend graph 4. Nutrition Tracking Track: Calories Protein Carbs Fat Water intake Fiber (optional) Automatic calculations preferred. 5. Training Tracker Track: Exercises Sets Reps Weight RIR Personal Records Workout completion % 6. Lifestyle Tracking Weekly ratings (1–10): Sleep Energy Hunger Stress Recovery Daily step count. 7. Coach Notes Private section where I can record: Weekly observations Adjustments Action plan Important reminders 8. Automatic Features I'd like the spreadsheet to automatically: Calculate weekly average weight Calculate weight change Display progress graphs Highlight important changes Calculate adherence % Show overall client progress Conditional formatting (green/yellow/red) is a bonus. 9. User Experience The system should be: Clean Minimal Professional Mobile-friendly Easy to duplicate for new clients Easy for someone with limited spreadsheet experience Deliverables Please include: Google Sheets file Documentation or short Loom/video explaining how to use it Ability to duplicate the template for future clients Nice-to-Have Experience working with: Online fitness coaches Personal trainers Nutrition coaching Client management systems Examples of similar work are appreciated.

  • Less than 30 hrs/week
    Hourly
  • < 1 month
    Duration
  • Intermediate
    Experience Level
  • $15.00

    -

    $20.00

    Hourly
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Google Docs
Google Apps Script
Nice-to-have skills
Google Sheets
Google Spreadsheets API
Activity on this job
  • Proposals:20 to 50
  • Last viewed by client:last week
  • Interviewing:
    6
  • Invites sent:
    8
  • Unanswered invites:
    2
About the client
Member since Dec 21, 2022
  • Canada
    Longueuil3:32 AM
  • Health & Fitness
    Individual client

Explore similar jobs on Upwork

Bibliometric Analysis on Scopus DatabaseFixed-price‐ Posted 4 weeks ago
Data Analysis
Quantitative Analysis
Event Foot Traffic Data CollectionFixed-price‐ Posted 4 weeks ago
Internet Marketing
Social Media Marketing
Facebook
Marketing Strategy
Data Entry
Data Mining
Data Scraping

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo