Do not use both methods for a single line item.ĩ. The Calories, Fat grams, and Fiber grams should be entered for the individual serving size.8. Or, enter the calories, fat, and fiber values from the package in columns D, E, & F.7. The spreadsheet does not calculate this column for you.6. You must enter the appropriate point value for the number of servings you consumed. If you know the point value of an item enter it in column H. Example: If the food serving size is ½ cup, and you consumed 1 cup, the quantity should be entered as 2.ĥ. The quantity is the number of the serving sizes you consumed. The serving size is as listed on the package. Complete columns A, B, & C for each food item eaten at each meal.Ĥ. Enter any bonus points earned in the space provided.3. Do not change any data found in the shaded area.2. The spreadsheet will track the points used (Points Used) each day, the cumulative points used for the week (Total), the cumulative points allowed for the week (Allowed), and the points you have in reserve (Balance).ġ. This does not affect the Data Worksheet.ĥ. It will also reset any bonus points earned throughout the week to zero. Caution: Only do this when you wish to clear all the menu data you have entered throughout the week. At the start of a new week click on the “Reset Menu Data” button. Space is also provided to track your weight loss.Ĥ. Enter your name, daily point allowance (a single number, 27, not a range, 24-27), and your target weight in the spaces provided.3. Do not change any data found in the shaded area.Ģ. Journal & Points Calculator Instructions:MS Excel Versionġ. Enter your weight (Lbs.) and the duration of exercise and the appropriat intensity level. Simply and paste them into the daily menu areas as needed. Use the data worksheet to store frequently used food items. The spreadsheet will calculate and tally your daily points used by and give you a total for the day and any points remaining. Do not use both methods for a single line item. enter the appropriate point value for the number of servings you consume The spreadsheet does not calculate this column for you. Example: If the food serving size is cup, and you consumed 1 cup, the quantity should be entered as 2. The quantity is the n of the serving sizes you consumed. Complete columns A, B, & C for each food item eaten at each meal. Enter any bonus points earned in the space provided. Do not change any data found in the shaded area. The spreadsheet will track the points used (Points Used) each day, cumulative points used for the week (Total), the cumulative points allow for the week (Allowed), and the points you have in reserve (Balance). Space is also provided to track your weight loss. Enter your name, daily point allowance (a single number, 27, not a range, 24-27), and your target weight in the spaces provided. Journal & Points Calculator Instructions: MS Excel Version Summary Worksheet Daily Worksheets Data Worksheet Servings Worksheet Bonus Points Worksheet 1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |