At the left side of the worksheet, drag down over the row number buttons, to select the unused rows in the table.To delete any unused rows, follow these steps: That row contains the formulas, which are automatically entered in the rows below. Warning: Do NOT delete the first data row in the Weekly Weight table, directly below the table headings. This step is optional - you can delete the unused rows in the Weekly Weight table, or leave them there, to fill later. In the first Wt cell, type the start weight that you entered on the Goals sheet.In the first Date cell, type the start date that you entered on the Goals sheet.Warning: Do NOT clear the Tgt Wt or Wt Change columns - they contain formulas. On your keyboard, press the Delete key, to clear those cells.Select the green cells, where the sample dates and weights were entered.Note: This sheet also calculates your weekly weight change.Go to the WeeklyWt sheet, where weekly weights are entered.There is sample data in the workbook, so follow the steps below, to clear that data out, and replace it with your own data. There are formulas in the grey cells, to calculate the total weight change, and the target date when you will reach your goal.Īfter your goals are entered, you can start tracking Lbs/kg per week: The weight change you want to achieve each week.Target weight: The weight that you want to reach (set targets with help from your doctor).Start weight: Your initial weight on the start date.Start date: The date you will start tracking your weight.Consult your doctor for recommended target NOTE: You can get the Stone weight tracker, if you prefer that measurement system This workbook does not containĪny qualified medical advice - it is a tracking tool only. Warning: Consult your doctor for recommended target In the top green cell, choose the measurement system you want to use.Go to the WeightGoals worksheet in the Excel Weight Tracker file.The first step in using the Excel weight tracker is to enter your personal data and weight goal information. At the end of the day, you can highlight all your calorie inputs and your total will be calculated at the bottom right of the spreadsheet. One option would be to have the horizontal axis separated into meal and snack categories, with the vertical axis used to represent each day and the calories of each eating time. From there, you can break it down to be as micro as you please. For your diet, your spreadsheet can be as simple as logging your total calories each day. Your fitness-related Google Sheets game can center around your diet, your workouts or both. Read next: A Runner’s Guide to All the Signs That You Need to See a Doctor.So why not just do it yourself, make it exactly what you want and not pay anything with Google Sheets instead? Excel, if you’re fancy.
But the free ones are shoddy, and the paid ones are… not free. Sure, there are probably hundreds of apps out there that could somewhat adequately track your gym routine or your calories. Whatever camp you fall into, though, you might benefit from treating your fitness goals a liiiiittle bit more like your job - specifically, by using Google Sheets.
Some people have some kind of instinctual drive to eat right and be active without much thought, and some people actually have to put a ton of damn effort into it. I prefer to make my workouts feel as little like work as possible, but, y’know, work is right there in the name.