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.To be honest, the songs are simple enough that you should test yourself and try working them out by ear, even if you cheat a little and use the tabs as a starting point, like getting your bearings for what chord you start the song on. 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. 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. 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. This step is optional - you can delete the unused rows in the Weekly Weight table, or leave them there, to fill later. Warning: Do NOT delete the first data row in the Weekly Weight table, directly below the table headings. That row contains the formulas, which are automatically entered in the rows below. To delete any unused rows, follow these steps: At the left side of the worksheet, drag down over the row number buttons, to select the unused rows in the table.Right-click one of the selected row buttons.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.To record your weight information on a weekly basis, follow these steps: Open the Weight Tracking workbook, and go to the WeeklyWt sheet.Click in the Date column, in the first blank row.(The table will expand automatically, after you enter the date) Type the date that you recorded your weight, then press the Tab key.TIP: To enter the current date, use the keyboard shortcut: Ctrl +.Type your current weight, then press the Enter keyĪfter you enter the date and weight, the Wt Change column calculates the weight change for that week, based on the previous week's weight and the latest weight.The dashboard shows the following information: Are things going in the right direction? Have you hit any plateaus? To see how things are going, check your progress in the workbook's Dashboard sheet and weight loss goal chart. Your current weight and your target weight.How much weight remains until you reach your goal.Weight chart has lines that show weekly recorded weight, and your target weight.One version of the Excel Weight Loss Tracker also has a Body Mass Index calculator (BMI calculator). It calculates your current BMI, and target BMI, and shows the healthy weight range for your height. The BMI chart is used as a lookup table for the ratings for the current BMI and Target BMI. The Minimum and Maximum ideal weight range is calculated from your height, and the Normal range in the BMI table. Learn more about Adult BMI from the Center for Disease Control and Prevention website. "BMI can be a screening tool, but it does not diagnose the body fatness or health of an individual.
To determine if BMI is a health risk, a healthcare provider performs further assessments." You don't need to read this "How It Works" section, unless you're interested in what's happening in the background of the weight tracker. If you'd like to know more about the formulas in the workbook, see the explanations and screen shots below. Everything is done with formulas - there are NO macros in the workbook. Here are the four main worksheets, and the details for each sheet are shown below.
0 kommentar(er)
