Use the Food View to enter your daily food intake.
|Enter||Edit the currently selected cell (either Food or Quantity)|
|Arrow keys||Move around the spreadsheet (use with Shift to multi-select lines)|
||Cut the currently selected line(s) to the clipboard|
||Copy the currently selected line(s) to the clipboard|
||Paste lines from the clipboard to the current position|
|Ctrl W||Paste lines from the clipboard to the end of the meals from which they were copied|
||Undo the last editing action|
||Redo the last undo|
||Hide/Show the Food Finder panel|
||Hide/Show the Quick Summary panel|
||Insert a new line at the current position|
||Delete the selected line(s)|
||Move the selected line(s) up|
||Move the selected line(s) down|
||Edit/view the currently selected food log entry|
||Edit/view the currently selected food definition|
||Show the Quantity selector dialog for the current line|
|Esc (Escape)||Cancel editing and revert to previous value (only valid while editing a cell)|
|Ctrl A||Select all the lines|
The Food View is an editable spreadsheet showing a days food intake subtotaled by meal.
Move around the spreadsheet using the arrow keys, insert, delete, cut, copy, paste and move lines as needed.
The currently selected cell is indicated by a white rectangle:
To edit the current cell press Enter, or simply start typing to replace its contents. You can also start editing by double clicking on a specific cell.
- The Header and Subtotal lines cannot be edited, starting to type while on one of these lines will open a new food line.
- The nutrient columns and the spreadsheet colors can be customized in the Options dialog ( toolbar button).
- You can copy food lines between days by copying to the clipboard, moving to the new date (using ) and pasting.
- To copy a whole day, keeping the meal breakdown, do the following: Select all lines (Ctrl A), copy to the clipboard (Ctrl C), move to the new date and paste merge (Ctrl W).
- You can copy lines for use in other applications.
- The subtotals and total may not exactly add up because the values are stored internally to many decimal places while the values shown are rounded to the number of decimals specified in the Options dialog, hence the values 0.3, 0.4, 0.4 would show as all zeros when rounded to 0 decimal places but still the total figure 1.1 would show as 1.
- The application comes with a food database of approximately 6000 foods (derived from the USDA database, minus babyfoods).
There are two ways of entering food/quantity information onto the spreadsheet:
- Directly entering the values into cells on the spreadsheet
- Using the Food Finder panel to find the food and the Quantity selector to enter the quantity.
Entering Foods Directly onto the Spreadsheet
When you edit a food cell a dropdown list of possible foods is displayed:
The foods shown in this dropdown vary as follows:
- When you start editing the dropdown will show the list of your top 30 favorite foods (i.e. those you have used the most).
- As you type the first character the list will be subsetted to show foods from your favorites that match.
- As you type subsequent characters and words the list will show all matching foods from the food database, with your favorites at the top
The list of matching foods is updated as you type.
The search looks for words beginning with the characters you type, multiple words can be entered, the order of the words does not matter..
|To Find||You could Type|
|2% fat milk||milk 2|
|Kellogs corn flakes||corn fl kel|
|Orange juice||or ju|
After entering a few days worth of data you will find that many of the foods you are looking for will be selected after typing just one or two characters (since your favorites are shown at the top of the list).
Once your have found the food you are looking for, select it by using the up/down arrow keys and press Enter or Tab.
If you cannot find the food in the database select the '---Quick Entry---' to manually type the calorie and nutrient values (without creating a new food definition) or select the '---New Food ---' entry to create a new food definition.
For foods chosen from the database the nutrient values will be calculated for you from the quantity entered. The nutrient values can however be overridden by manually editing the relevant fields. Note that any changes to the quantity will recalculate the nutrients, overwriting any manual change to the nutrients.
For foods used frequently we recommend you create new Food definitions, this way the nutrients will be calculated for you each time you log an entry.
'Quick Entries' are highlighted with a * symbol in the leftmost column:
Create 'Menus' of commonly used foods to speed entry. Add the foods to the log in the usual way then multi-select the lines and right click to show the context menu, choose the 'Make Menu from selected...' item to open the Menu Dialog:
Menus can be added to the log by selecting from the Food finder panel (Menus tab), or right clicking and selecting the Insert Menu... option.
- The full description of the currently selected food is shown in the status bar and its calorie breakdown is shown in the Quick Summary panel.
- The food names in the dropdown list are appended with a '+' character if they have been user added and a '*' character if they have been user modified.
Entering Quantities Directly onto the Spreadsheet:
When you edit a Quantity cell a dropdown list of possible units is displayed:
Type the numeric quantity in the field and select the units using the up/down arrow keys or by typing the first character of the unit name.
For example: to enter 12 ounces type '12' followed by the character 'o' or simple type '12' and press the down arrow to select ounces.
Once you have entered the quantity press Enter or Tab to save the value and recalculate the totals.
- The default units (i.e. those selected when you start to edit a new quantity cell) for both weight and volume measurements can be selected in the Options dialog.
- The full unit name is shown in the status bar
Using the Food Finder Panel
The food finder panel allows you to select foods from you favorites, from foods matching a search condition or from the foods you've used on previous days.
The Search tab acts like the dropdown food list as described above, except that it is always visible and multiple selections are possible.
The Previous tab shows foods from a previous date, usually the previous day. You can change the date shown using the calendar buttons at the top of the panel .
To add a food from either of these tabs first select it and then press Enter or click the Add button (you can also double click it).
The Menus tab shows the list of menus you have defined, click Add to insert all the lines from the menu into the log.
If the check box is ticked then the Quantity Selector dialog will be invoked, otherwise the selected food(s) will be added to the spreadsheet at the current cursor location with zero quantities.
The Quantity Selector Dialog shows the previous value entered for the given food and allows you to enter a new value, using basic arithmetic calculations if required.
The Quick Summary is divided into three panels:
|Today's Calories||Shows the Net (Remaining) calories after taking into account your metabolism, exercise, diet plan and food intake.|
|Calorie Breakdown||Shows the calorie breakdown by Carbohydrate/Protein/Fat/Alcohol of the selected Food, the current days Foods and your Goal values as specified in the User Dialog.|
|Nutrition Totals||Shows today's totals for all Nutrients, the Goal% and RDA%|
- If a Metabolic Rate has not been entered in the User Dialog then ??? will be shown for this value and the Net calories.
- Move the mouse pointer over the Calorie Breakdown bar charts to see the %values.
- The Goal% column in the Nutrition totals panel shows the % of your goal value (as defined in the User Dialog). Values under 100% are shown as bars in Green, those between 100% and 110% are shown in Orange and those over 110% are shown in Red.
- You can hide the Quick summary panel by pressing the button.
- You can Hide/Show the Quick summary panel by pressing the button .