
Open
Posted
•
Ends in 6 days
Paid on delivery
I need a single Excel workbook that runs like a mini-app for my personal-training clients. As soon as I open it, I want to land on a clean dashboard that pulls each client’s name, their SMART goal summary, PAR-Q status, and—as selected—session notes, any adaptations I’ve logged, and automatically generated progress charts. Inside the file: • Exercise Programme – A drop-down driven sheet where I pick “Warm-up, Cardio, Strength, Cool-down or Stretching” and the exercise list instantly populates from a master exercise library you’ll set up for me. I’ll fill in or adjust weight, reps, time, or calories and the sheet should feed those numbers into calorie-burn calculations that compare against each client’s BMR and daily calorie goal. – The exercise library itself lives on its own tab so I can keep adding moves without breaking any formulas. • Nutrition – A daily layout for Breakfast, Lunch, Dinner and two Snacks, with space for calories and macros. Drop-downs should fetch meals from a food-options sheet I’ll supply. • Weight Tracking – Simple date, weight, body-fat % and notes columns that plot automatically on the dashboard. • Integrated Calendar – Each main tab (workout, nutrition, weight) needs a clickable calendar so I can jump to any date’s entry with one click. I’ll share my colour palette and any sample data once we start. Everything has to stay in vanilla Excel—no external add-ins—so it runs smoothly on both Windows and Mac versions of Office 365. Acceptance criteria 1. Workbook opens on the dashboard and no VBA errors appear. 2. Adding a new exercise or meal to the master sheets instantly updates every drop-down. 3. Calorie math and BMR look-ups match the formulas I’ll supply for spot checks. 4. Calendar links always navigate to the correct date row. 5. Charts on the dashboard refresh automatically when new data is entered. If you’re confident with dynamic named ranges, data validation, XLOOKUP/INDEX-MATCH, and light VBA for navigation, this should be right up your alley. Let me know any clarifications you need before you dive in.
Project ID: 40686052
46 proposals
Open for bidding
Remote project
Active 31 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
46 freelancers are bidding on average £22 GBP for this job

Hi There, I have strong experience building advanced Excel dashboards and mini-app style workbooks using dynamic named ranges, data validation, XLOOKUP/INDEX-MATCH, automated charts, conditional formatting, and lightweight VBA navigation. I can build the complete client dashboard, expandable exercise/meal libraries, workout and nutrition tracking, BMR/calorie calculations, weight/body-fat progress charts, and date-based navigation while keeping everything compatible with Office 365 on Windows and Mac. The workbook will remain easy to expand without breaking formulas or dropdowns, and I’ll thoroughly test the calculations and navigation before delivery. I’m ready to start immediately.
£20 GBP in 1 day
8.7
8.7

I can build your Excel mini-app with a clean dashboard, dynamic drop-downs, exercise/meal libraries, BMR and calorie calculations, weight tracking, charts, and calendar navigation. I have 10+ years of Advanced Excel experience and can make it work smoothly on Windows and Mac Office 365. I can start immediately.
£15 GBP in 1 day
6.7
6.7

Hello, I can build your personal-training Excel workbook as a clean, client-focused mini-app with the dashboard as the starting screen. I’ll create the Exercise Programme, Nutrition, Weight Tracking, master exercise/food libraries, and integrated calendar navigation, with dynamic drop-downs that automatically expand when new exercises or meals are added. Client SMART goals, PAR-Q status, notes, adaptations, BMR, calorie goals, calorie-burn calculations, and progress charts will be linked throughout the workbook. I’ll use dynamic tables/named ranges, XLOOKUP/INDEX-MATCH, data validation, and only lightweight VBA where needed for calendar navigation. The workbook will remain compatible with Office 365 on both Windows and Mac and will be thoroughly tested against your acceptance criteria. Please share your sample data, formulas, colour palette, and food-options sheet so I can begin. Best regards, Ayaz Akhtar
£20 GBP in 7 days
6.8
6.8

Hello I am highly experienced with advanced Excel and can build your interactive personal-training workbook with dashboard, dynamic drop-downs, BMR/calorie calculations, calendar navigation, automated charts, and Windows/Mac Office 365 compatibility. Regards Muhammad
£15 GBP in 1 day
5.9
5.9

Hello, You want this workbook to feel like a small training app, not a spreadsheet, and that is exactly the right approach for reliable daily use. I can build the dashboard-led structure with dynamic dropdowns, lookup-driven client views, automatic charts, and clean navigation so the file stays fast and stable in Excel on both Windows and Mac. I have solid experience with advanced Excel formulas, dynamic named ranges, data validation, XLOOKUP/INDEX-MATCH, and light VBA navigation. I’ll structure the exercise, nutrition, and weight sheets so new library items update every dropdown automatically, while the dashboard pulls client status, notes, and progress metrics without breaking formulas. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. Could you confirm whether each client should live on separate tabs or within one master table with filtered views? Could you confirm whether you want each client stored on separate tabs or within one master table with filtered views, and should the calendar jump to a single selected date row or to a full day detail panel? I can start by mapping the workbook flow and formulas first, then move into the dashboard and navigation logic so everything is tested before handoff. Looking forward to your reply so we can finalize the exact plan. Best regards, Asad
£20 GBP in 11 days
5.5
5.5

Hello, I’ve read your details and clearly understand that you are looking for a vanilla Excel 365 mini-app with a dashboard, dynamic exercise/meal libraries, automatic calorie and BMR calculations, and date-based navigation across workout, nutrition, and weight tracking. This is absolutely doable for me, let's chat and take this forward. My approach is to build the workbook around Excel Tables, dynamic named ranges, XLOOKUP/INDEX-MATCH, data validation, and light VBA for reliable calendar navigation. I’ll make every dropdown expand automatically when new exercises or meals are added, connect workout inputs to your supplied calorie/BMR formulas, and drive dashboard charts directly from the underlying client data. I’ll also structure the VBA carefully for Windows and Mac Office 365 compatibility and test date navigation against actual entries. As final deliverables you will receive the complete dashboard-driven workbook, exercise and food libraries, programme/nutrition/weight sheets, integrated clickable calendars, automatic calculations and charts, sample data, and a clean structure ready for your colour palette and client data. One thing I'd like to confirm before we start: will the PAR-Q, SMART goals, BMR and calorie formulas be supplied as fixed formulas, or should I build the underlying client profile calculations as well? Let's have a quick chat and I can map the workbook structure before building it. Best Regards, Imran
£50 GBP in 1 day
4.7
4.7

Hello, The key part of this project is **turning several linked training logs into one clean Excel workbook that opens on a dashboard and stays stable on Windows and Mac**. I can help you handle this accurately and efficiently without overcomplicating the process. I have hands-on experience with **Excel Macros, Data Visualization, and Excel**, including building dashboard-style workbooks with dynamic updates and formula-driven navigation. For your project, I would focus on **setting up the master sheets and drop-downs**, **building the dashboard charts and client summary view**, and **wiring the clickable calendar navigation**, while making sure the final result is **fast, reliable, and easy to extend**. I can start immediately and expect to complete this within 7 days. One detail I'd like to confirm before starting: **should the workbook use VBA only for navigation, or do you also want it to auto-create new dated entries when a day is selected?** Best regards, Miguel
£100 GBP in 7 days
4.1
4.1

Hi, With over 7 years of experience in Excel and Google Sheets, I have the expertise and skills to create the automated personal training tracker you need. Throughout my career, I have developed countless excel workbooks that run like mini-applications. I am well versed in using dynamic named ranges, data validation, XLOOKUP/INDEX-MATCH as well as light VBA for navigation amongst others—making me the best fit for this job. Thanks
£15 GBP in 1 day
4.3
4.3

Hello, I'm Jordan from Tequlia. I understand you need a professional Excel workbook that works like a simple mini-app for managing personal-training clients, with a clean dashboard and automated tracking. I can help you: Build a clean dashboard with client details, goals, PAR-Q status, notes, and progress charts Create a master exercise library with dynamic drop-down lists Build workout tracking with automatic calorie calculations and BMR comparisons Create a nutrition sheet with meals, calories, and macros Add a master food-options sheet that updates all drop-downs automatically Build weight and body-fat tracking with automatic dashboard charts Add clickable date navigation/calendar functionality Use XLOOKUP, INDEX-MATCH, dynamic ranges, and data validation Keep the workbook compatible with Excel 365 on both Windows and Mac Test formulas, drop-downs, navigation, and charts against your acceptance criteria I can keep the workbook clean and easy to maintain, so adding new exercises or meals will not break existing formulas. I can start immediately and build the workbook around your sample data, colour palette, and formulas. Best Regards, Jordan
£15 GBP in 7 days
3.2
3.2

Thank you for considering my proposal. I have gone through the requirements in detail. I can build your Excel-based personal-training workbook as a clean mini-app with an intuitive dashboard, automated calculations, dynamic drop-downs and progress visualization. I’ll create the dashboard with client details, SMART goals, PAR-Q status, notes/adaptations and automatically updating progress charts. The workout module will use a maintainable exercise library with dynamic drop-downs, XLOOKUP/INDEX-MATCH and automated calorie/BMR calculations. I’ll also build the nutrition and weight-tracking tabs with dynamic meal selections, macros and dashboard-linked charts. For navigation, I can implement clickable date-based calendars and ensure everything works in vanilla Excel/Office 365 on both Windows and Mac, using VBA only where appropriate and avoiding external add-ins. I’ll thoroughly test formulas, data validation, dynamic ranges, navigation and refresh behavior against your acceptance criteria. I have uploaded samples of similar Excel dashboards, automation and data-visualization projects completed by me earlier in my profile. I have 10+ years of experience in Excel, financial analysis, reporting and automation and am a Chartered Accountant (ICAI) and CPA. I’m ready to build a robust, user-friendly workbook that is easy to maintain and ready for daily client management.
£20 GBP in 1 day
3.6
3.6

Hi, I am confident I can build your automated Personal Training Tracker as a clean, interactive Excel mini app that works smoothly on both Windows and Mac Office 365. I have strong experience in advanced Excel formulas, dynamic named ranges, data validation, XLOOKUP/INDEX-MATCH, VBA, interactive dashboards, charts, and automated data-entry systems. I can structure the workbook so it is easy to maintain and expand without breaking formulas or drop downs. I will build: • Interactive dashboard with client goals, PAR-Q, notes, adaptations, and progress charts. • Dynamic exercise library with category based drop downs. • Automated BMR, calorie burn, and daily calorie goal calculations. • Nutrition tracker for meals, calories, and macros. • Weight and body fat tracking with automatic charts. • Clickable calendar/date navigation across key sheets. • Auto expanding exercise and meal drop downs. • Clean, error free workbook opening directly on the dashboard. I will keep the solution in vanilla Excel with no external add ins and will test the formulas, navigation, drop downs, calculations, and charts against your acceptance criteria. I can also provide brief documentation explaining how to add exercises, meals, clients, and maintain the workbook. I’m ready to start and can build this into a professional, use -friendly training management tool. Regards,
£19 GBP in 4 days
3.3
3.3

Greetings, I’m a Business Analytics Specialist with 15+ years of experience in data analysis, Excel, reporting, and dashboard development. I’m comfortable building structured Excel workbooks that automate calculations, dropdowns, data validation, and visual reporting. For your Personal Training Tracker, I can: 1. Build the client dashboard with SMART goals, PAR-Q status, session/adaptation notes, and automatic progress charts. 2. Create expandable exercise and food master libraries with dynamic dropdowns, BMR/calorie calculations, and nutrition/weight tracking. 3. Add date-based navigation/calendar links and thoroughly test formulas, dropdowns, charts, and Office 365 compatibility. I’ll keep the workbook clean, user-friendly, and easy to maintain when you add new exercises, meals, or client data. I can deliver the completed and tested workbook within 3–5 days after receiving your formulas, sample data, and colour palette. I’m ready to start immediately. Best regards, Andhika
£12 GBP in 5 days
2.6
2.6

Hi client, I can build this as a single vanilla Excel workbook —a dashboard pulling client goals, PAR-Q status, and auto-generated progress charts, with drop-down-driven exercise and nutrition sheets feeding into BMR-based calorie calculations. I work with dynamic named ranges, XLOOKUP/INDEX-MATCH, and light VBA regularly, so I'd structure this to keep the master sheets scalable without breaking formulas. What I'll deliver: 1. A clean dashboard auto-updating from exercise, nutrition, and weight-tracking tabs 2. Drop-down-driven sheets pulling from your master exercise and food-options tabs 3. Clickable calendar navigation and auto-refreshing charts, tested on Windows and Mac Office 365 Happy to align on your color palette and sample data before I start building. Best regards, Anirban
£15 GBP in 2 days
2.1
2.1

Hi, Your workbook needs to feel like a small app, not just a collection of sheets. I understand the goal: one clean dashboard that shows client status, pulls training and nutrition data from linked tabs, and updates charts and navigation without breaking in Excel for Windows or Mac. I’ve built similar Excel systems using dynamic named ranges, data validation, XLOOKUP/INDEX-MATCH, and lightweight VBA for jump links and dashboard navigation. I’d structure the file around stable master sheets for exercises and meals, then connect the workout, nutrition, and weight tabs so new entries flow through automatically. I’d also keep the formulas clear and maintainable so your calorie calculations, BMR lookups, and dashboard charts remain easy to verify and expand later. If you’d like, I can map the workbook structure and start from your palette and sample data. Best regards, Gabriel
£10 GBP in 11 days
1.8
1.8

Hi, I have 4+ years of experience with Excel and have previously built automated tracking systems and dashboards. I can create your personal training tracker with dynamic dropdowns, formulas, progress charts, calorie/BMR calculations, and calendar navigation. I’m confident I can deliver a clean, reliable, and user-friendly workbook that meets your requirements.
£19 GBP in 2 days
0.9
0.9

Hi, I can build your complete Personal Training Excel Mini-App in Office 365 with a clean dashboard, client profiles, SMART goals, PAR-Q status, workout programming, nutrition tracking, weight/body-fat tracking, dynamic exercise & food libraries, automatic calorie/BMR calculations, progress charts, and date-based calendar navigation. I’ll use dynamic named ranges, Data Validation, XLOOKUP/INDEX-MATCH, Excel Tables, and lightweight VBA for navigation. The workbook will be fully vanilla Excel with no add-ins and designed for both Windows and Mac. I’ll also ensure new exercises/meals automatically appear in dropdowns, formulas remain stable, and charts refresh as new data is entered. I’m ready to work with your colour palette, sample data, and formulas to deliver a polished, user-friendly workbook.
£10 GBP in 1 day
0.6
0.6

Hi, I can build your Excel workbook as a clean, easy-to-use mini-app with the dashboard as the starting point and all data connected dynamically. I’ll set up the exercise and food libraries, dynamic dropdowns, workout/nutrition tracking, BMR and calorie calculations, weight tracking, automatic progress charts, and date-based navigation across the main sheets. I’ll use Excel Tables, dynamic named ranges, XLOOKUP/INDEX-MATCH, data validation, and lightweight VBA only where needed, keeping the workbook compatible with Office 365 on both Windows and Mac. I’ll also test the acceptance criteria thoroughly so new exercises/meals and data automatically flow through the workbook. Let’s connect and discuss your sample data and formulas.
£15 GBP in 3 days
0.0
0.0

Hello, I can build this as a polished Excel mini-app for personal training management, fully compatible with Office 365 on Windows and Mac. I’m experienced with dynamic named ranges, XLOOKUP/INDEX-MATCH, data validation, automated charts, calorie/BMR calculations, dashboards, and VBA navigation. Exercises and meals will remain expandable without breaking dropdowns or formulas. I’ll create the dashboard, exercise programme, nutrition tracker, weight tracking, calendar navigation, master libraries, and automatically updating progress charts based on your palette and formulas. I can start as soon as you provide the sample data and calculation requirements. Thanks.
£15 GBP in 7 days
0.0
0.0

I can build a professional Excel-based personal training management system that works like a mini-app while remaining fully compatible with Office 365 on both Windows and Mac. I understand that the goal is not just tracking data, but creating an interactive client management workbook with automated calculations, dashboards, and easy-to-maintain master libraries. I can develop: • A dashboard-driven client overview with SMART goals, PAR-Q status, notes, adaptations, and progress charts • A dynamic exercise programme with dropdown selections connected to a master exercise library • Automated calorie calculations with BMR and daily calorie goal comparisons • A nutrition tracker with meal dropdowns linked to a food database • Weight tracking with automatic progress visualization • Calendar navigation for workout, nutrition, and weight records • Dynamic ranges, XLOOKUP/INDEX-MATCH formulas, and clean automation without external add-ins I will ensure: • New exercises and meals automatically update dropdown lists • Formulas remain stable when new data is added • Dashboard charts refresh automatically • Workbook opens cleanly without VBA errors Before starting, I would like to review your sample data, color palette, and the BMR/calorie formulas you want used so I can build the workbook exactly according to your requirements. Best regards, Mubarak
£15 GBP in 7 days
0.0
0.0

I’m confident I can build this Excel-based personal-training client management workbook to match your requirements. I’ll create a clean dashboard as the landing page, with client selection, SMART goals, PAR-Q status, session notes/adaptations, and automatically refreshed progress charts. The Exercise Programme will use a scalable exercise library with category-driven dropdowns and dynamic lists, while workout inputs will feed into calorie-burn calculations and BMR/daily calorie comparisons using your supplied formulas. I’ll also build: • Nutrition tracking for meals, calories and macros with dynamic food-option dropdowns • Weight/body-fat tracking with automatic dashboard charts • Clickable date navigation across Workout, Nutrition and Weight sheets • Dynamic named ranges/data validation so new exercises and meals immediately appear in dropdowns • XLOOKUP/INDEX-MATCH-based lookups and clean, maintainable formulas • Light VBA only where useful for navigation, with no external add-ins • Mac/Windows Office 365 compatibility and thorough testing against your acceptance criteria I’ll keep the workbook user-friendly, scalable and easy for you to maintain. Once you provide the colour palette, sample data, food options and your exact calorie/BMR formulas, I can incorporate them and ensure the spot-check calculations match precisely. I’d be happy to start by reviewing your sample data and defining the workbook structure before development.
£10 GBP in 7 days
0.0
0.0

Sunderland, United Kingdom
Payment method verified
Member since Feb 24, 2026
£20-250 GBP
£20-250 GBP
£10-20 GBP
£10-20 GBP
$250-750 USD
$10-30 USD
₹1500-12500 INR
₹1500-12500 INR
$30-250 USD
£250-750 GBP
₹12500-37500 INR
$15-25 USD / hour
₹100-400 INR / hour
$10-30 USD
$101 USD
$750-1500 USD
$10-30 USD
$30-250 USD
$30-250 USD
$10-30 USD
₹100-400 INR / hour
$250-750 USD
$15-25 USD / hour
₹12500-37500 INR