![]() I find that if I eat around 1,600 calories per day on a weekly rolling average, I will probably maintain my weight. Either way, actively counting and measuring helps you figure out where to create a deficit. Admittedly, for me, it has certainly been a bit more difficult to consistently lose weight without actively counting, so I may go back to counting again this week. Since Christmas, I've stopped tracking my food intake so aggressively because I'm trying to build up habits without having to log everything down. In the beginning, losing weight was incredibly easy, but as you can see from the chart, it dropped down a bit over time as my body got more used to the new diet plan, and the (fairly minimal) exercise I was doing.Įxcel has seen me steadily and gradually lose weight over the course of a year, to a point where I'm almost below 300 pounds for the first time in decades. The first time I was able to weigh myself was when I'd already dropped to 415 pounds (and when the scales stopped returning an error message for being too heavy). There are 3 versions of the weight loss/gain tracker, so choose the one that will work best for what you need.I also have a line graph at the top where I log my weight every Saturday for the past year, which offers an overview of my progress as soon as I open up the spreadsheet. Go to the Weight Loss Tracker page, and scroll down to the Downloads section. Weight Loss Dashboard Get the Excel Weight Loss Tracker – Stoneĭownload the Excel Weight Loss Tracker – Stone, and try it for yourself. It calculates the total weight change, in stone and pounds, and shows how many weeks are left until you reach the target end date. ![]() The Dashboard sheet shows your progress, with a simple line chart to show your recorded weights, and a summary of your weight loss. Your weekly weight change is also calculated, in decimal stone, along with your current BMI. ![]() On the Weight Tracker sheet, you can enter your weekly weights, with stone in one column, and pounds in another. Body Mass Index (BMI) information Track Your Weekly Weight Your current BMI, and target BMI, are calculated, and you can see the ideal weight range for your height.Ī VLookup formula shows your weight status, based on the BMI table. 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. Weight Loss Tracker in Stone BMI Calculations The workbook then calculates the stone weight as a decimal value.Įnter your target weight loss per week, in pounds, in cell D10. 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. 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. I’m not a medical professional, and the workbook is designed for tracking your weight loss, as per your doctor’s advice. Please consult your doctor about weight loss targets, and BMI measurements. That version was in pounds.Ī couple of people asked about a stone/pound version, so I’ve finally created one - just in time for swimsuit season! 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |