In 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 version was in pounds. A couple of people asked about a stone/pound version, so I've finally created one -- just in time for swimsuit season!
Please consult your doctor about weight loss targets, and BMI measurements. I'm not a medical professional, and the workbook is designed for tracking your weight loss, as per your doctor's advice.
Update: There is a new version of the Excel Weight Loss Tracker in Stone, so the worksheets are slightly different from the screen shots below.
Enter Your Weight Loss Goals
The new stone/pound version works the same as the previous version, but you'll enter your start and target weights with stone weight in one column and pounds in another. The workbook then calculates the stone weight as a decimal value.
Enter your target weight loss per week, in pounds, in cell D10.
BMI Calculations
The Weight Goals sheet in the Excel Weight Loss Tracker also has Body Mass Index (BMI) information from the Center for Disease Control and Prevention. Your current BMI, and target BMI, are calculated, and you can see the ideal weight range for your height. A VLookup formula shows your weight status, based on the BMI table.
Track Your Weekly Weight
On the Weight Tracker sheet, you can enter your weekly weights, with stone in one column, and pounds in another. Your weekly weight change is also calculated, in decimal stone, along with your current BMI.
Weight Loss Dashboard
The Dashboard sheet shows your progress, with a simple line chart to show your recorded weights, and a summary of your weight loss. It calculates the total weight change, in stone and pounds, and shows how many weeks are left until you reach the target end date.
Download the Excel Weight Loss Tracker – Stone
Download the Excel Weight Loss Tracker – Stone, and try it for yourself. There are versions for Excel 2007/Excel 2010, and Excel 2003 on the Contextures website: Excel Weight Loss Tracker
___________
this is just Perfect , many thanks
Can i unlock the cells in the weight tracker tab to change the dates? I want the dates to start now and work their way through this year.
Ta, Rob
@Rob, it's easier to enter the dates in the latest version of this Excel weight loss tracker. You can download the new version from the link at the end of this article.
Can you tell me what the Pivot Table is for and how it works?
Thank you