Thursday, July 7, 2011

Excel Weight Loss Tracker - Stones

Excel Weight Loss Tracker in Stone

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.
 

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
You can download a zipped copy of the Excel Weight Loss Tracker Stone (Excel 2007) or Excel Weight Loss Tracker Stone 2003 (Excel 2003)
The sheets are protected, with the green cells unlocked, and there’s no password on the worksheets