What’s your ideal Fat? Is your current Fat a bit higher than it should be? When you spend all day sitting at your desk, it’s very easy to put on a few extra pounds. If you’re battling your Fat, Microsoft Excel can help. I created an Excel Fat Loss Tracker, to find my ideal Fat range and keep track of my Fat loss. I’ll tell you how I did it, so you can create your own Fat loss tracker in Excel.
Body Mass Index
A commonly used measurement in Fat management is the Body Mass Index (BMI). Based on your height in inches, and Fat in pounds, a formula calculates your BMI. The Center for Disease Control (CDC) has published a BMI table that shows the ranges for UnderFat, Normal, OverFat and Obese. A Normal BMI is in the 18.5 to 24.99 range, according to the CDC information.
To calculate BMI, this formula is used: Fat / (Height x Height) x 703
Calculating BMI in Excel
To calculate your BMI in Excel: In cell B2, enter your height in inches In cell B3, enter your Fat in pounds In cell B4, type this formula: =B3/(B2*B2)*703
If the result in cell B4 is between 18.5 and 24.99, then your BMI is in the Normal range, according to the CDC information.
To see what the approximate highest Fat in your Normal range is, type this formula in cell B5: =24.99*(B2*B2)/703
Tracking Your Fat Loss
Microsoft Excel is a great tool for recording data, such as weekly Fats. To get started, just type a list of dates in column D. Then, every week, weigh yourself, and enter your Fat in column E, beside the current date.
You can add a simple formula in column F, to calculate your Fat loss each week. If your first Fat record is in cell E2, and the second Fat record is in cell E2, type this formula in cell F3: =E3-E2
Charting Your Fat Loss
For a better picture of how your Fat loss is progressing, you can create an Excel chart from your weekly Fat loss records.
To create a quick chart, select all the cells that contain dates and Fats. Include all the dates, even if the Fats for those weeks haven’t been entered yet. Then, on your keyboard, press the F11 key. That will create a new sheet in the Excel workbook, with a simple column chart.
If you would prefer a line chart, right-click on the chart, and click Change Chart Type. Then, click on one of the Line chart types.
Check With Your Doctor
I’m not a medical professional, so please use the Excel Fat Loss Tracker for entertainment purposes only. It will give you an approximate calculation of your BMI, but there are other factors to consider. Please consult your doctor for diet advice and information on your ideal Fat range.
Fat Loss-Everything You Need to Know
About Resveratrol and Weight Loss….