In this ever expanding universe, so is my belt. I need to drop more than a few pounds.
Now I can use an Excel Dashboard Template and Chart file to track my weight and plot it against my target weight range and my BMI target weight range (Body Mass Index). And you can too. Below is the Free Template Download for this Excel Dashboard for Weight Loss.
The Dashboard was setup using Excel 2007 and you can track your weight by date and a graph of your progress will automatically be created as you enter new data. That makes this a Dynamic Dashboard.
Also, you can enter in your target Weight Range and a band for this target will be plotted on the chart along with your weight. Finally, you can put in your height and it calculates your target BMI Weight Range and plots that on the Dashboard Chart as well. Presently this chart displays weight in Pounds but it could be modified for the Metric Weight System as well.
What is BMI?
As per Wikipedia – “The body mass index (BMI), or Quetelet index, is a heuristic proxy for human body fat based on an individual’s weight and height. BMI does not actually measure the percentage of body fat. It was invented between 1830 and 1850 by the Belgian polymath Adolphe Quetelet during the course of developing “social physics”. Body mass index is defined as the individual’s body weight divided by the square of his or her height.”
Won’t you join me in getting more fit and healthy as well as seeing you accomplishing your goals with a really cool Personal Excel Dashboard?
Please let me know what you think about this download in the comments and let me know if you want me to build a similar template for Excel 2003. Also let me know if I can make any improvements for this Dynamic Dashboard Template.
Demonstration and how to use the Free 2007 Excel Template:
Free Sample File Download
Here is the 2007 Excel BMI Target Weight Loss Tracking file: http://www.exceldashboardtemplates.com/BMI_Weight_Tracker2007
Here is the 2003 Excel BMI Target Weight Loss Tracking file: http://www.exceldashboardtemplates.com/BMI_Weight_Tracker_2003
Good Luck to us both!