Create excel spreadsheet with formulas and enter data

Completed Posted Apr 13, 2014 Paid on delivery
Completed Paid on delivery

I need an excel spreadsheet created with formulas that will give differences between clients body measurements, bodyfat, weight, %bodyfat, lean muscle changes, body fat pounds differences. I am attaching the word document from the last group of clients where I had to manually figure out each clients differences so you can see what I am looking for. I will also attach the sheet I get the numbers for weight, body fat lbs, lean muscle pounds, and %body fat. The differences can be + or - they are mostly minus. I want the formulas to calculate between each measurement/weigh in and from the first measurement to the most recent. so a grand total lbs lost sine the start. Client measurements and weigh ins are 3 times beginning middle (4 week mark) and end (8week mark). Some clients have done the program twice so their totals will keep going every 4 weeks and keep calculating the differences since the beginning. Prior data will need to be entered. I will enter future data. Please see attached docs. The first doc is from the #1 group. The second doc is from the #2 group. with some new participants and all of the previous. we run 5 8 week sessions during a year. some people will repeat and some will not. I will need to be able to keep the repeats and add new clients too. Let me know what questions you have. The 3rd doc is the sheet I get the weight , pounds of bodyfat, pounds of lean muscle, and % of body fat. I circled each number I need the differences calculated for.

Data Entry Excel

Project ID: #5801742

About the project

18 proposals Remote project Active Apr 14, 2014

Awarded to:

ElaineTeo

Please check my portfolio. I'm expert in excel formula. In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data V More

$35 USD in 2 days
(1 Review)
1.0

18 freelancers are bidding on average $160 for this job

zExcel

Hi, I can help you create a spreadsheet with formulas for tracking body measurements. Please feel free to message me in order to clarify the procedure

$222 USD in 2 days
(62 Reviews)
5.9
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$200 USD in 7 days
(86 Reviews)
5.6
jayjossef132

I can start working this project. Let me handle this project. I can accurately sort all information needed. Proven skills and experience similar to my previous work. I am looking forward for your response to get starte More

$150 USD in 5 days
(44 Reviews)
4.9
vater

Dear Sir, We would deliver this task promptly and cater your requirements. We have a dedicated team of data research experts and would provide solutions with class. We also offer you in - depth QC process and woul More

$188 USD in 3 days
(1 Review)
1.2
nacm

Hi I am attempting to make a sample for you. Please reply to this message so I can send it to you once I finish. Thanks

$155 USD in 3 days
(0 Reviews)
0.0
bbradle7

I am a consultant with a history of producing robust Excel models and tools, using a vast array of analytical techniques, Excel functions and formulas, and VBA programming when necessary. This particular project will More

$155 USD in 3 days
(0 Reviews)
0.0
newtonmondal

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
manzoor3226

Hi, I can perform this task in one day with quality. No compromise on quality from me. Thanks Have a good day!

$205 USD in 1 day
(0 Reviews)
0.0
aracelibc20

I understand what you require, I have much experience with decision formulas in excel and I'm sure you'll do an excellent job.

$133 USD in 3 days
(0 Reviews)
0.0
joanalmonte

I am a certified public accountant and has been working on reports creation for 5 years. May it be a simple spreadsheet or crystal reports using SAP Business One.

$166 USD in 3 days
(0 Reviews)
0.0
STLCards33

I have substantial professional experience creating these types of databases. I'm able to put it together so that you can easily add future data when you have it available. I could have the finished product back to yo More

$133 USD in 2 days
(0 Reviews)
0.0
mermaidiris

Hi there! I'm good with excel file processing and I've reviewed your files. I can do it but I'll need you to provide me the formula with which you have come up with the highlighted figures with the given figures and mo More

$133 USD in 3 days
(0 Reviews)
0.0
seemabangera

I have worked extensively on excel and do the assignment with precision. I am suitable to work on this.

$222 USD in 3 days
(0 Reviews)
0.0
arsal2000

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0