Modifying Formula ID, Name, Notes and Attachments

To edit the formula name, identification number, notes or attach a file to this formula:

Click the View button and select Name, Notes and ID.

You can also click the Edit button just above the formula name in the spreadsheet.

Adding Ingredients to a Formula

If you wish to add an ingredient as a sub-ingredient for an ingredient already in your formula, click on that ingredient. If you wish to add a primary ingredient to the formula (not as a sub-ingredient) , click the formula name cell.

In the Ingredient Declaration section, press the Add button which is found in the row of buttons at the top.

The Add Ingredients window appears (see figure below). Here is a quick introduction to the add ingredients window. You can search for an ingredient or reference number by selecting the appropriate option, entering search text, and pressing the Search button. Clicking any of the column heading buttons (Ingredient Name, Ref #, and Source buttons) will sort that column in descending alphabetical order. The Copy List button (B) will copy all the ingredient information shown in the window. This allows the user to easily copy the information to another document. The View button (C) displays information for the selected ingredient. If an ingredient has an especially long name, press the Complete Name button (D) to display the entire name. The Delete Ingr button (E) deletes the selected ingredient. The Look In button (F) allows the user to select a different ingredient file.

To add an ingredient to the formula select the ingredient and press the Add button (A). To add an ingredient not in the ingredient file, press the Add Ingredient Not in Database button (G) and fill out the necessary information. Note – this does not add the ingredient to the ingredient file.

Close the window when finished.

View Ingredient Amounts

To view ingredient amounts for a formula in the Ingredient Declaration section:

Click the View button and select Ingredient Amounts.

To cancel View Ingredient Amounts:
Click the View button and select Formula.

View Declaration

To view the ingredient declaration for a formula in the Ingredient Declaration section:

Click the View button and select Declaration.

You can also press the View Dec button which is found in the row of buttons at the top of the spreadsheet.

Delete an Ingredient

The user should be in the Ingredient Declaration section.

Select the ingredient to delete.

Press the Delete button which is found in the row of buttons at the top.

Delete All Ingredients

The user should be in the Ingredient Declaration section.

Click the Ingredient button and select Delete All from the Ingredients group.

Update Ingredient Declaration Information with Ingredient File Values

The user should be in the Ingredient Declaration section.

Click the Ingredients button and select Update Dec Information.

Exclude an Ingredient from the Declaration

The user should be in the Ingredient Declaration section.

Select the ingredient to be excluded.

Press the Exclude button which is found in the row of buttons at the top. The excluded ingredient will be grayed out and not included in the ingredient declaration.

Include an Ingredient in the Declaration

The user should be in the Ingredient Declaration section.

Select the ingredient to be included. This would be an ingredient that was previously excluded.

Press the Include button which is found in the row of buttons at the top. The included ingredient will no longer be grayed out and will not be excluded from the ingredient declaration.

Clear All Ingredient Declaration Information

The user should be in the Ingredient Declaration section.

Press the Clear Formula button which is found in the row of buttons at the top.

Edit an Ingredient’s Declaration in a Formula

The user should be in the Ingredient Declaration section.

Select the ingredient declaration to edit.

Press the Edit Dec button which is found in the row of buttons at the top of the spreadsheet.

Retrieve a Formula

To retrieve a formula, you need to be in the Ingredient Declaration section.

Click the File button and select Open Formula.

You can also click on .

The Retrieve Formula window appears. Select the formula and click the Open button.

If prompted to update ingredient declarations, select yes to update your values from the ingredient file.

Note: If you do not wish to be prompted to update composition and prices contact technical support (help@owlsoft.com).

Search All Formula Files and Retrieve a Formula

The feature provides for reviewing all formula files and all formulas in a filtered spreadsheet. The user can retrieve a selected formula from the list. The feature is available in the Formula Development, Labeling, and Declaration sections.

Click the File button and select Search All Files and Open Formula or click the Look Up Formula in the Retrieve Formula window.

The Look Up and Retrieve spreadsheet appears.

There a several buttons at the top of the spreadsheet.

Return (A) – returns the user to the section from which they accessed the feature.
Find (B) – simple search.
Retrieve Selected Formula (C) – retrieves the formula without changing the user’s default formula file.
Clear Filters (D) – this clears an filters set in the column dropdowns (E).
Ingredient-declaration-common-tasks-img11.png (pixel 1250 x )
(F) – returns the user to the section from which they accessed the feature.

In this example, the spreadsheet is filtered to show only formula in the file, TWz Example Formulas. The formula, Process Cheese Example, is selected. When the user clicks the Retrieve Selected Formula, this formula is retrieved in the section that accessed the feature.

Save a Formula

To save a formula, you need to be in the Ingredient Declaration section and have formula information entered.
Click the File button and select Save Formula.

You can also click on .

Save a Formula As

To save a formula with a new name, you need to be in the Ingredient Declaration section and have formula information entered.

Click the File button and select Save Formula As.

Enter a new file name when prompted.