How to Make a Weight Watchers Points Calculator with Excel
Things You'll Need
- A computer with Microsoft Excel or a comparable spreadsheet program.
Instructions
-
-
1
Open a new excel file.
In the first column in row 5, type Calories, then in row 6 type Fat grams,
then skip a line and in row 8 type Fiber.
So you have typed "calories" in cell A5, "Fat grams" in cell A6, and "Fiber" in cell A8. -
2
In the next column, highlight the three cells that are next to the words you typed, and color block them. These are the sells where you will type in the values you want to convert to points. The color blocking will remind you where to enter the values.
-
3
In the third column, in cell C5, type the following formula: =B5/50 then enter.
In cell C6, type the following: =B6/12 then enter.
Then go back to cell C6 and type Ctrl U, or click on the underline tool on the toolbar. -
4
In cell C7, use the 'sum' function, or type =C5+C6 to total the two cells.
You can test it at this point by entering numbers in the B column. Try typing 100 in cell B5, and 6 in cell B6. Your sum should be 2.5 if your formulas are correct. -
5
In cell C8, type =B8/5
Then go back and underline that also (Ctrl + u).
Then in C9, type =ROUND(C7-C8,0)
That will round the points number for you. -
6
Name it and save it! That's it. Grab a package with a nutritional label and try it out. Be sure to enter in the highlighted boxes only. You might want to put a note somewhere on the page reminding you where you enter the values.
-
1
Weight Watchers - Related Articles
- How to Count Calories With Weight Watchers
- How to Earn Weight Watchers Points With Exercise
- How to Exercise With Weight Watchers
- How to Succeed on Weight Watchers
- How to Properly Use a Weight Watchers Points Calculator
- How to Get Exercise Points With Weight Watchers
- How to make a Free List of Weight Watcher Points