I am hiring an Excel Expert for a simple Workout Log Tracker Project

เสร็จสมบูรณ์ โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

I am a personal trainer and I am building a Workout Log Tracker to track the workouts of my personal training clients. I have ALREADY BUILT most of it but I cannot get the formulas and macros to work because I am terrible at Excel. It probably won't take a good expert more than 30 minutes to finish it for me though. I have attached a copy of the Workout Log Tracker so you can see what it looks like. You can see I already managed to create a few very easy formulas by myself like the formula which automatically calculates how much weight the client should be able to lift at 70% and 85% of their maximum strength. But I can't be anything more advanced than that, I tried to do it and I failed miserably at it. This is what I need the Workout Log Tracker to be able to do.

PLEASE LET ME KNOW IF YOU CAN HELP ME???

1) The name of the exercise the client is doing gets entered under the activity column (such as Barbell Back Squats or Flat Benchpress Barbell) but I don't want to always manually type the name of all the exercise into the cells in order to save time. Please create a macro which feeds the names of every exercise into a dropdown list from the backend where I can't see them so I can simply pick the exercise the client is doing from the dropdown list (I can provide the names of all the different exercises if you need them to make it easier on you).

2) Sort the exercise names in alphabetically order too or create a dependent dropdown list so they are organized by body-part so it's easier to find the exercise I'm looking for, just so I'm not scrolling through a list of 600 exercises to find the right one.

3) Enter a formula that automatically computes the average number of calories the client has burned, average minutes of cardio the client has done, just simple average calculations...

4) Create a formula so the cells can be left BLANK but the formula still stays active in that cell. There doesn't need to be numbers/data in any cell for the formula to stay there. In other words the cells can be left blank with nothing in them, but the formula will still be active in that cell. The formula is waiting for data to be entered into the cell to compute the data. If I delete all the numbers or data in a cell (because maybe I entered the wrong numbers or data) it will not delete the formula attached to that cell, because that would render that cell useless for future use and screw everything up for me.

5) Data from the spreadsheet should be fed into a Line Chart (looks like a Stock Market Chart) so I can see and analyze what trends they are hitting by glancing at the chart. For example, as the client gets better they will be able to lift heavier and heavier weights or run at faster speeds for longer periods of time, so if I looked at the Line Chart it would show a line that fluctuates up and down over time but the general trend will be a line that gradually goes upwards. Just like a stock price, the line will keep fluctuating up and down as the stock price goes up and down, but the general trend should ideally be moving upwards.

6) Every new workout will have to be entire into a new worksheet or workbook (whatever it's called in Excel) so all of the sheets or books for the same client will have to be connected to each other and feed all of their data into each other (feed their data into the same Line Chart). So if the client does a good workout today, I'll be able to compare the workout they did today to the workout they did 6 months ago. Like a stock market chart, you can see what the companies stock price was 6 months ago and what it's currently at today. So that way you can analyze how their price has performed over a period of time such as a 6 or 9-month period, except in this case I am analyzing workouts. All their data is connected and it all flows into the same place or the same chart.

คีย์ข้อมูล การประมวลผลข้อมูล Excel Visual Basic Visual Basic สำหรับแอป

หมายเลขโปรเจค: #18883886

เกี่ยวกับโปรเจกต์

18 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( เพิ่มเติม

$50 CAD ใน 1 วัน
(680 รีวิว)
8.4

freelancer 18 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $25

daniyal3214

I can definitely help you with this. I am a professional Excel expert holding years of experience in utilize advance level tools and functions of Excel to develop highly dynamic and automated dashboards for tracking, d เพิ่มเติม

$30 CAD ใน 1 วัน
(47 รีวิว)
5.4
Masudhasan008

I have checked your attached file and i can complete this project according to your project specification. let's talk more about the job in chat.

$23 CAD ใน 1 วัน
(10 รีวิว)
4.0
ielucerotrad1

I can do the job! Sound like a straight forward task :) I'm an engineer with advanced working knowledge and experience in Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access เพิ่มเติม

$15 CAD ใน 2 วัน
(3 รีวิว)
1.7
RCMservices

Dear employer, I have read your requirement and it does not required Macro. We can create it with formulas. I can create a good spreadsheet with protected formulas so that they wont get deleted. I am really happy to wo เพิ่มเติม

$20 CAD ใน 2 วัน
(4 รีวิว)
1.1
gomathy24121988

hi im expert in excel. i shall help you with your requirement. kindly get back to me. i can provide you apermanent solution

$10 CAD ใน 1 วัน
(1 รีวิว)
0.4
Orshanavid

Dear sir , At first take my sincere respect .I have done through your project description . After that i am able to understand that i have the enough skills to do the project . Here is some information about why i a เพิ่มเติม

$25 CAD ใน 1 วัน
(0 รีวิว)
0.0
ThinagaranArul

hello sir iam glad to work with you sir , iam here to rectify yours problem and able to work with whole heartiness

$20 CAD ใน 1 วัน
(0 รีวิว)
0.0
umiamaumiama188

I am best candidate for this proposal. I have 6 years experience. I will try that provide 100% result.

$25 CAD ใน 1 วัน
(0 รีวิว)
0.0
sonu78146ss

after my work u will happily give me next project i will show u my finger magic.

$25 CAD ใน 1 วัน
(0 รีวิว)
0.0
safdarbodla

Hey! Hope you are doing well. I have read your project thoroughly. I have bundle of questions in my mind regarding this project. I have multiple ideas in my mind to bring some improvements in your project. I can provi เพิ่มเติม

$17 CAD ใน 1 วัน
(0 รีวิว)
0.0
medhatadly76

i am excellent in ms word and excel. If you need a sample before the project starting I am ready. i am planning engineer. I have research papers in Christian studies that have not been published yet. and research pa เพิ่มเติม

$10 CAD ใน 1 วัน
(0 รีวิว)
0.0
vvvmanna

Your file will be will maintained and well looked. with free upgradation/ change asper requirement after payment within 7 days.

$15 CAD ใน 1 วัน
(0 รีวิว)
0.0
ahmadrteil

I am a financial advisor currently working with one of the biggest 4 financial service companies in world. Holding a dimploma in international financial reporting and ACCA. Professional user of excel Relevant Skills a เพิ่มเติม

$25 CAD ใน 1 วัน
(0 รีวิว)
0.0