Weight loss chart

I've been wanting to set up an Microsoft Excel chart to keep track of my weight and hopeful weight loss.  I went to Excel and started.  I know that I'm Ecel challenged so I knew I would have trouble figuring out how to make my chart automatically subtract (or sadly add) my weight each week.  I tried but quickly gave up.  Then I asked myself why am I trying to reinvent the proverbial wheel so I went to trusty 'ole Google and did a search for an Excel weight loss template and found one at blog.contextures.com/.  I decided to try it out.  I downloaded the 2003 version (my computer is old) and it downloaded just fine.  The data that you will see when you open the downloaded file are dates and weights preset by contextures.com so I had to change the dates to make it current and then added my own information and it worked.  I did have to unlock the password protection in order to change the dates.  There is a link page in this download that I didn't want so I deleted it in my final copy.  Then when I saved it to my own folder I clicked "Save As" and now it's my own with my own individual information. 


I went ahead and cut and paste the information from contextures.com website and here it is. I left out the actual sample pictures since I don't think they would transfer from her site to this one.  Thanks goes to Debra the owner of contextures.com. 
**************************************************

From contextures.com

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!