will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.
Excel Weight Loss Tracker
Uh-oh! I finally remembered where all the Christmas cookies went, and maybe some of the chocolates. And it’s not pretty. Apparently, when you sit at your keyboard for hours, with the occasional cookie break, it puts the “spread” in “spreadsheet.”
Time to get things under control, and I’ll use an Excel weight loss tracker. It can store weekly weight records, calculate the weight loss, and show the progress in a weight loss chart.
With some fancy programming, it could probably create some healthy menus, and zap me if I reach for a cookie, but I’ll work on those features later.
There’s a link at the end of this post, where you can download the Excel Weight Loss Tracker sample file. I’m not a trained medical professional, so use the Excel Weight Loss Tracker at your own risk, and for entertainment purposes only, etc.
Weight Loss Goals
On the first worksheet in the Excel Weight Loss Tracker file, there are cells where you can enter your personal data and goals.
In the Excel Weight Loss Tracker sample file, I’ve entered the data for my daughter’s favourite Toronto Blue Jays baseball player. He probably had a few extra cookies over the holidays too, and needs to get in shape before the baseball season starts.
Data is entered in the green cells, and calculations, such as Target Date, are in the white cells.
This shows the good news for the Blue Jays. If this player can work off about 3.5 pounds per week, he’ll be ready!
BMI Calculations
The first sheet in the Excel Weight Loss Tracker also has information on Body Mass Index (BMI) from the Center for Disease Control and Prevention. It calculates your current BMI, and target BMI, and shows the ideal weight range for your height.
The BMI table is used as a lookup table for the ratings for the current BMI and Target BMI. The Minimum and Maximum ideal weight range is calculated from your height, and the Normal range in the BMI table.
Weight Tracking
The second sheet is the Weight Tracker sheet, where weekly weights are entered. It also calculates the weekly weight change. Just enter your weight in column B each week, and the change is automatically calculated.
Weight Loss Dashboard
The final sheet is the Dashboard, with a simple line chart to show the recorded weights, and a summary of the weight loss. It calculates the total weight change, and shows how many weeks are left until you reach the target end date.
Download the Excel Weight Loss Tracker
You can download a zipped copy of the Excel Weight Loss Tracker (Excel 2007) or Excel Weight Loss Tracker 2003 (Excel 2003), and try it for yourself. The sheets are protected, with the green cells unlocked, and there’s no password on the worksheets.
And stay away from the cookies!
______________________
January 4th, 2010 at 1:12 am
The file link doesn't work.
January 4th, 2010 at 9:34 am
Thanks Gregory -- it's fixed now.
January 4th, 2010 at 10:07 am
[...] is the original: Contextures Blog » Excel Weight Loss Tracker Share and [...]
January 4th, 2010 at 10:10 am
I downloaded the file, but I'm still fat.
January 4th, 2010 at 12:35 pm
Sorry Dick, I guess you have to stare at the file for a couple of days before it works.
January 4th, 2010 at 2:03 pm
that weight loss tracker would be awesome for people to use with the new XM3 body in balance caps, that helped me lose 9.8lbs so far,we all need to help each other out in our goals, kool kool
January 4th, 2010 at 2:11 pm
i cant get it to open up for me?dang, oh well
January 4th, 2010 at 3:32 pm
Sandy, I've added an Excel 2003 version of the file, so if you're using Excel 2003 or an earlier version, you should be able to open that.
January 4th, 2010 at 4:20 pm
If you manage to get the Cookie Zapper sorted, I'd be very grateful ha ha
January 4th, 2010 at 5:14 pm
oh thats the problem i dont either one at this time oh well thks for trying
January 5th, 2010 at 1:15 am
Tony, I'll let you know as soon as the Cookie Zapper is ready.
January 6th, 2010 at 12:04 am
[...] Excel Weight Loss Tracker [...]
January 10th, 2010 at 5:37 pm
Is there a metric version.
January 13th, 2010 at 2:04 pm
what a fantastic resource!!!! What is the chance for a metric and a stone version?
January 13th, 2010 at 9:06 pm
Thanks Clint and Anjohleen, if I create a metric or stone version I'll announce it here.
January 15th, 2010 at 1:20 am
[...] To keep track of your weight loss download the Excel Weight Loss Tracker on the Contextures [...]
January 18th, 2010 at 12:01 am
[...] we created a Body Mass Index formula a couple of weeks ago, I added that to the player stats too. Then a VLOOKUP formula pulled the BMI [...]
February 1st, 2010 at 12:25 am
[...] I don’t believe that you’ll fail to lose weight if you use Excel – that’s why I created the Excel Weight Loss Tracker [...]
April 14th, 2010 at 5:11 am
Amazing file, Debra! Can I give it to my friends in future? Thank you!
May 3rd, 2010 at 12:08 am
[...] Excel Weight Loss Tracker [...]
May 3rd, 2010 at 5:35 am
Great little Excel Weight Loss Tracker program , I'm well impressed .
It would be great if there was stones and Pounds bit in the weightTracker bit ..
May 3rd, 2010 at 7:02 am
I was trying this formula in the weight Tracker bit ,
=INT(B2/14) & " St " & MOD(B2,14)&" Lbs"
this puts the stones and pounds in the D column.
but i don't know how to link it to any other pages ..
May 3rd, 2010 at 4:03 pm
Thanks Roger, glad you like it! I'm working on a stone/pound version, and will post it here on Wednesday.
May 5th, 2010 at 12:03 am
[...] January, you read about the Excel Weight Loss Tracker in which you could enter your current height and weight, and record your weekly weight loss. That [...]
May 5th, 2010 at 7:39 am
Animating instrument! would have been nice to have this in "metric system" and KG;
May 17th, 2010 at 7:46 am
+1 KG verstion would be great.
July 5th, 2010 at 12:03 am
[...] Excel Weight Loss Tracker [...]
August 7th, 2010 at 1:54 am
How do I add extra lines to the spreadsheet that will be automatically added to my total calories? I'm unfortunately not very Excel savvy...
Thanks!