Đã hoàn thành

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

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Visual Basic, Visual Basic cho Ứng dụng

Xem nhiều hơn: excel spreadsheet templates for tracking, excel training database template, excel training log template, training plan template excel download, employee training log template word, staff training spreadsheet, training tracker excel templates, employee training tracker excel spreadsheet, toronto excel expert job, excel expert simple plugin excel hide page number watermark page break preview , excel expert need simple solution, excel simple expert simple, i need a good excel expert in singapore, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, i need an excel expert, i need an expert on whmcs to make a very simple job, i need excel expert, i want an excel expert who works on my excel sheet according to my requirements, i want to hire an excel expert in the leesburg va area

Về Bên Thuê:
( 1 Nhận xét ) Edmonton, Canada

ID dự án: #18883886

Được trao cho:

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 ( Thêm

$50 CAD trong 1 ngày
(680 Đánh Giá)
8.4

18 freelancer đang chào giá trung bình $25 cho công việc này

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 Thêm

$30 CAD trong 1 ngày
(47 Nhận xét)
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 trong 1 ngày
(10 Nhận xét)
4.0
haleem0786

i can do this. i have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please review my profile and inbox [login to view URL]

$70 CAD trong 1 ngày
(16 Nhận xét)
3.6
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 Thêm

$15 CAD trong 2 ngày
(3 Nhận xét)
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 Thêm

$20 CAD trong 2 ngày
(4 Nhận xét)
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 trong 1 ngày
(1 Nhận xét)
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 Thêm

$25 CAD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$10 CAD trong 1 ngày
(0 Nhận xét)
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 Thêm

$17 CAD trong 1 ngày
(0 Nhận xét)
0.0
$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
ankasky

Hi, I can do that & i am interested in doing your project. I am a web developer & designer. My priority is to provide you quality work in time & in reasonable budget. Relevant Skills and Experience Following are ou Thêm

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
sonu78146ss

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

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
umiamaumiama188

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

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
$25 CAD trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 Thêm

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0