Tutorial for the Spreadsheet / Tracker
Tutorial for the Spreadsheet / Tracker
In order to understand how to use the Tracker, please work through this short tutorial,
as opposed to just reading through it.
Use File | Print to print this page containing the Tutorial.
, you may have both this web site page and the Tracker file open at the same time.
Launch Excel or Star Office.
Open the Spreadsheet / Tracker file. (File | Open) or
use a Desktop Icon. (From Desktop Icon, click Back to Tracker Tutorial to come back here.)
Switch between this website page and the Tracker, by clicking on the rectangles for them, down at the bottom of your screen.
Star Office or Open Office users:
Click Tools | Auto Correct | Options | be sure that "Use Replacement Table" is UNchecked | OK.
On the Tracker, use File | Save As and save it to another file name like Practice. Scroll Down to Continue . . .
Pictures below are an illustration only.
Do not click on these pictures.
Instead, click in the Tracker itself.
Notice the little tabs down at the very bottom of the screen (in the Tracker).
You should now see a tab that says HErecipes. Click on that tab. 
Do you see Accidental Fudge? (If not, use [CTRL] [HOME], that is, hold down CTRL key while you hit HOME key.)
Notice that Accidental Fudge is on Row number 3. The *Row # is the reference number for the recipe.
See Row Number Illustration. (From Row Number Illustration, click Tutorial to come back here.)
Now we're going to pretend that you're going to have Accidental Fudge for breakfast on Sunday -- an unlikely event, but bear with me. :o)
In the Breakfast Menu, click the *Row # column for Item#1 (cell C6).
Type in a 3, which is its row number from the HErecipes sheet. Hit [ENTER].
Now, click the Quantity column (Qty) for Item#1 (cell B6).
Because the Quantity is 1 serving, type in a 1. Hit [ENTER].
Click on cell A6. It probably shows "pieces- Dec 97-p. 4".
Excel users: Click Format | Row | Autofit.
Star Office or Open Office users: Click Format | Row | Optimal Height | OK.
You should now see your exchanges, calories, and nutrient info for your Fudge breakfast.
Basically that's it!
Now try out some other recipes, for Item#2, Item#3, etc.
Scroll down and notice that it is doing subtotals and totals for you.
Other HINTS:
Don't delete out anything in column A as it contains a formula. Also, don't type over any of the Item#s in column A.
If you change your mind about what you're having on a certain menu
(maybe, for example, you decided not to have Accidental Fudge for breakfast after all),
use the Delete key (DEL) to delete out the Row# and the Qty:
Click in the cell you want to delete, then hit the [DEL] key.
Star Office or Open Office users:
then, use the default settings (that is, leave all the check marks as they are) and click OK.
Don't delete out anything in column A as it contains a formula. Also, don't type over any of the Item#s in column A.
(This differs slightly from the ideas in The Detailed Hints, but I'm trying to give you an easier method.)
Back to Top or, Continue Scrolling Down . . .
When you want to type in recipe information of your own
Click on the tab down at the bottom for HErecipes (the last one on the far right.)
Scroll all the way down to the 1st blank row.
Type your recipe information. If you need to type in any fractions, use decimals (like .75 for 3/4).
After typing in the Optional Calories in column N, be sure to scroll to the right to finish typing in the rest of the information, such as calories, grams fat, etc., on through milligrams calcium in column V.
Notice the Row #.
Click on your tab for the day-of-the-week sheet. Enter that Row# in the Row# column.
Enter the number of servings you ate in the Qty column. Format the Row Height.
Back to Top or, Continue Scrolling Down . . .
In order to re-use your spreadsheet
At the beginning of the second week, in order to re-use your spreadsheet . . .
(Again, this differs from the instructions given in The Detailed Hints, but I'm trying to give you an easier method.)
Use the Delete key (DEL) to delete out all the Row#'s and Qty's that you've entered in your day-of-the-week sheets.
Star Office or Open Office users: accept the default values, that is leave the checkmarks as they are, and click OK.
Don't delete out anything in column A.
You should be set for the 2nd week.
Back to Top or, Continue Scrolling Down . . .
How can I find out the decimal for a fraction?
Suppose you ate 1 1/2 servings of something. You would type in 1.5 in the Qty column of your day-of-the-week sheet.
Anytime you need to enter a fraction, use decimals to do it.
Start | Programs | Accessories | Calculator will pull up the computer's calculator.
example: [7] [/] [8] [=] will show you the decimal for 7/8, which is 0.875
Back to Top or, Continue Scrolling Down . . .
How do you find a recipe, without scrolling through all of them?
It is really easy just using the built-in search function :
On the HErecipes sheet, the very last sheet, on the right, use [CTRL] F
(This means that you hold down [CTRL] while you hit F.)
or, you can use Edit | Find, which does the same thing.
Then, just type in the Recipe Name, or one or two words (words that are next to each other) in the name. Hit [ENTER].
If it finds one that isn't the right one, hit [ENTER] again, etc.
How do you get to a particular location quickly?
On the HErecipes sheet, the very last sheet, on the right, just use [F5] and then type in the cell address.
· Cell address for the beginning of the list is A1.
· Cell address for the end of the list is A and whatever row you last entered data on.
Back to Top or, Continue Scrolling Down . . .
For More Info . . .
After awhile using it this way, you may want to look at the Detailed Hints beginning down at the bottom of
the first page of the Spreadsheet / Tracker, to see what else it will do.
See also Copying and Pasting New Recipe Info.
New Recipe Info files can be found by clicking here, or use
Files | Recipe Info in Yahoo Groups for Healthy Exchanges.
Files in Yahoo Groups will require a Yahoo ID for access. For more info on this see: File and Chat Access.
|
