The following explains how to accomplish common tasks in the application.

Modifying Formula ID, Name, Notes and Attachments

If you are not already in the Formula Development section, Click the Goto button and select Formula Dev.
Click the View button and select Name, Notes and ID.
Or you can also click the Formula Name & ID box.

Adding Ingredients to a Formula

In the Formula Development section, press the Add Ingredients button.

The Add Ingredients window appears (see figure below). To add an ingredient to the formula select the ingredient and press the Add button (A) or double-click the ingredient.

If you would like to review an ingredient’s composition before adding it, press the View button (B). If the ingredient you require is not in the source list then try the USDA Ingredients list (C). When an ingredient is added from the USDA ingredient list, it is added to the current ingredient file and to the formula. You need only select a particular ingredient from the USDA list once. If more than one copy of the ingredient is needed then select Disable Add Once Only (D).

An ingredient not in the ingredient database can be added to this formula by pressing the Add Ingredient Not in Database button (E). The ingredient composition will have to be provided. This will not add the ingredient to the ingredient database. IN MOST CASES IT IS BETTER TO ADD THE INGREDIENT TO THE INGREDIENT DATABASE FIRST, refer to Adding Ingredients to an Ingredient File.

If the wrong ingredient is selected and added to the formula, select the ingredient in the Current formula list and click the Delete Selected button (F) to remove it. When finished adding ingredients, close the form.

The user can search for a particular ingredient name or reference number using the search feature (G). Ingredients can be selected from the source ingredient file or from the larger list of USDA ingredients. The ingredient file can be changed by pressing the Look In: button (H). The list of ingredients can be sorted by ingredient name (I), by reference number (J), or by source (K) by pressing the appropriate button. The user can also press the Show Complete Name button (L) or the View button (B) to view ingredient names that are too long to view in the list box. To copy a list of ingredients from the ingredient file, click the Copy List button (M). The list can then be pasted into another program such as Notepad, Excel, Word, etc. The ingredients in the current formula can be sorted by clicking the Sort button (N). The Sort Ingredients window appears. Follow the instructions found in the Sort window. To enter recipe amounts for the formula, click the Edit Recipe button (O). Instructions for this feature are detailed in the section Entering Recipe Amounts in a Formula. When adding ingredients from the USDA Ingredients list, use the Category drop-down to focus on the ingredient type of interest (P).

Entering Recipe Amounts in a Formula

The necessary ingredients should already be in the formula in the Formula Development section before setting recipe amounts. If you need help adding ingredients to the formula then refer to Adding Ingredients to a Formula.

Open the Recipe Entry Window by clicking the Formula button and select Enter Recipe.

The Recipe Entry window appears.

Select an ingredient from the list (C). Next enter the amount and units (D). To enter the new ingredient amount, press the Update button (F) or press Enter on your keyboard. Select the units for the overall batch (E). To cancel the changes to the formula, press the Cancel button (G). To update the formula, click OK.

Adding Data Properties to a Formula

In the Formula Development section, press the Add Properties button.

The Add Properties window appears (shown below). The Data Property tab is selected. To add a property from the list, select it and press the Add button (A) or double-click the property.

One can add a property to a formula that is not in the ingredient database by pressing the Add Property Not in Ingr. button (B). The ingredient composition will have to be provided. In most cases it is better to add the property to the ingredient database first, refer to Adding Properties to the Ingredient File.

If the wrong property is selected and added to the formula, select the property in the Current formula list and click the Delete Selected button (C) to remove it. When finished adding properties, close the form.

The user can search for a particular property name using the search feature (D).

Adding Complex Properties to a Formula

In the Formula Development section, press the Add Properties button.

The Add Properties window appears. Select the Complex Properties tab (A). To add a property from the list, select it and press the Add button (B) or double-click the property.

If the wrong property is selected and added to the formula, select the property in the Current formula list and click the Delete Selected button (C) to remove it. When finished adding properties, close the form.

The user can search for a property name using the search feature (D). To learn how to create or edit a Complex Property refer to Complex Properties.

Update Ingredient Composition

The feature updates the composition information for each ingredient in a formula with values found in the ingredient file. The user should be in the Formula Development section to use this procedure.

Click the Formula button, select Ingredients, and click Update Composition.

Sorting Ingredients in a Formula

In the Formula Development section, click the Sort button

The Sort window appears. Follow the instructions provided in the Sort window.

Delete an Ingredient

The user should be in the Formula Development section to use this procedure.

Select the ingredient to delete from the formula (this does not delete the ingredient from the ingredient file). Click the Delete button found in the ingredient column.

Delete All Ingredients

The user should be in the Formula Development section to use this procedure. Click the Remove All button found in the ingredient column.

Delete a Property

The user should be in the Formula Development section to use this procedure.
Select the property to delete from the formula (this does not delete the property from the ingredient file).
Click the Delete button found in the property column.

Delete All Properties

The user should be in the Formula Development section to use this procedure.
Click the Remove All button found in the property column.

Clear All Information

The user should be in the Formula Development section to use this procedure.

Click the Formula button and select Clear All.

The user can also press the Clear Formula button found in the Formula Development section.

Update Ingredient Prices

The feature updates the composition information for each ingredient in a formula with values found in the ingredient file. The user should be in the Formula Development section to use this procedure.

Click the Formula button, select Ingredients, and click Update Prices.

Normalize (Make Total Amount 100%)

The normalize feature has the following characteristics:
• If the amount in the % column is blank for one or more ingredients, the procedure will add an amount to make the total of all ingredients equal 100%.
• If none of the amounts in the % column are blank, it will determine the amount of each ingredient necessary to make the total of all ingredients equal 100%.

To normalize the current formula, Click the Formula button and select Normalize.

Reset Ingredient Minimum and Maximum Values

The user should be in the Formula Development section to use this procedure.

Click the Reset button found in the ingredient min column.

Reset Property Minimum and Maximum Values

The user should be in the Formula Development section to use this procedure. Click the Reset button found in the property min column.

Modifying Formula Density

Please refer to Formula Density.

Set Property Maximum Values Equal to Minimum Values

The user should be in the Formula Development section to use this procedure. Enter the appropriate amounts in the property min column.

Click the Set to Min button found in the property max column.