Data Tracking Google Sheet for Fitness
Worldwide
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/weekHourly
- < 1 monthDuration
- IntermediateExperience Level
$15.00
-
$20.00
Hourly- Remote Job
- One-time projectProject Type
Skills and Expertise
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
- CanadaLongueuil3:32 AM
- Health & FitnessIndividual client
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers 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