(The table will expand automatically, after you enter the date) Click in the Date column, in the first blank row.Open the Weight Tracking workbook, and go to the WeeklyWt sheet.To record your weight information on a weekly basis, follow these steps: In the pop-up list, click on Delete, to remove the selected rows from the worksheet.Īfter you've finished the initial setup for the Weight Tracker, all you have to do is enter your latest results each week, on the weight tracker sheet.
Right-click one of the selected row buttons.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.
0 kommentar(er)
