Nutrition Information

• Effects of changing an ingredient's nutrition profile
• Vitamin data in %RDI versus grams
• Exporting nutrition information
• Where did that nutrition data go?

Miscellaneous

• Product sub-formulations
• Correcting addresses on Form 7234
• Emailing a label approval application
• Creating an x% fat ground beef

Nutrition Facts Panel

• Dual panels
• Eliminating NASS statement
• Landscape format
• Export for Emailing/Other Programs

Program Utilities

• Download program / updates
• System requirements
• Saving a product record to diskette
• Creating a backup copy
• Moving EZ Form to a new computer
• Moving data to a network folder
• Switching from single to multi-users

Q: I pulled an ingredient from the In-House Ingredient database into my product formulation, then clicked the <Nutrition> button and added the nutrition data. Later, I added the same ingredient to another product formulation, and all my nutrition information was gone! What happened?

A: This is because you entered the nutrition information through the <Nutrition> button in the product formulation box; therefore, the information was added for the ingredient only for that particular product. You need to enter the nutritional information for an ingredient through the In-House Ingredient database. To do so, open the File Menu, click on <Ingredient>, highlight the ingredient of interest, and click on <Edit>. 

Q: How would I export the spreadsheet for my product's nutritional information from EZ Form into Microsoft Excel?

A: With your product record open, click <View>, <Nutrition> to access the Nutrition View. Next, click <Options>, <Display Spreadsheet> to access the nutrient data spreadsheet. Now click <Export> and then click either <Tab delimited text file> or <DBF database>. Type in the name of the file (a maximum of eight characters) followed by ".TXT" or ".DBF", respectively. If you used the first option and created a TXT file, then when you ask Excel to open the file, you'll have to indicate to Excel that the file is "delimited" by Tabs and the data format is General. On the other hand, if you created a DBF file, then Excel will open the file without questions, and the data format for all cells will be text.

Q: How would I do a dual Nutrition Facts panel for my product which is a meat loaf "as packaged" and meat loaf and gravy "as prepared?"

A: Create the NFP for the meat loaf, including the serving size information. Next, click on <NFP Format>. Answer the questions on Overall Format and Split Options, then go to the Dual Declaration Option and click on <As prepared/As consumed>. Enter the weight of the sample of the meat loaf with gravy. In the left column enter "Meat Loaf" and on the right column enter "Meat Loaf with Gravy." You now are presented with three options for entering the nutritional data of the meat loaf with gravy. Choose and complete the option desired. Then, voila, you have a dual declaration NFP.

Q: In the FDA format, how do I get rid of the "Not a significant source of"(NASS) statement at the end of the label?

A: You must make sure that 7 of the mandatory 13 nutrients have zero values, then EZ Form automatically removes the NASS statement. If data for Trans Fat is present, then 8 of the 14 mandatory nutrients must have zero values.

Q: When entering a product formula into EZ Form, how do I create a sub-formulation when I have the exact ingredient breakdown?

A: While editing the product formulation, click on <Add>, then click on <New Formulation>. Type in the description (just the name; but no ingredient list) for the sub-formulation, e.g. "spice mix 2030", then click <Close>. Next, enter the amount of the sub-formulation in the product and click <OK>. You will then return to the main formulation screen. An asterisk will appear in front of the "spice mix 2030" ingredient. To specify the first ingredient in the spice mix, click on the asterisk. The In-House ingredient database opens. Select the first ingredient in the spice mix (or, if the ingredient is not already listed, click <New> and enter the ingredient description and other available information) and then specify the amount of this first ingredient that is in the spice mix. You will then return to the main formulation screen with this first ingredient highlighted and indented below "spice mix 2030". To add additional ingredients to this sub-formulation, make sure that one of the existing ingredients in the sub-formulation is highlighted, then click <Add>. When you are done entering all the ingredients in the spice mix and want to add an ingredient to the main list of ingredients, make sure that <Spice Mix 2030> or another main ingredient is highlighted before you click <Add>.

Q: How do I change the address associated with a particular establishment number so that the correct address appears in box 10 when I select that establishment in box 4?

A: Click on the Settings menu and select Establishments. In the list of available establishment numbers, highlight the one with the address you need to change. Click "Edit Highlighted." When finished making the necessary changes, click <OK>.

Q: What procedure do I follow in order to email Prime Label a label approval application for expediting?

A: First, create a complete product record in EZ Form so that you are at the point that you could print out everything that would be needed to obtain a label approval. That is, fill in all the information in Form 7234 View, complete Nutrition View at least to the point that an NFP can be displayed, then go to Sketch View and design your label sketch. Then proceed as follows:

1. Click on <File> then on <Open>, hightlight the product whose label approval is to be expedited, and click <Select>
2. Click on <File> then on <Export>
3. In the box captioned "Path to which export files are to be written" type   C:\EZFORM\
4. Place a check mark in the box in front of "Export complete product record"
5. Remove any check mark from the other two boxes
6. Click <OK>
7. If you are advised that "Export files already exist ...", click <Yes>
8. If you are asked "Would you like to email someone ...", click <No>
9. Click on <File> then on <Cover Sheet: Add to Export>
10. The "Path to which export files have been written:" box should already show C:\EZFORM\, so just click <OK>
11. The exported product record(s) (you can export multiple rather than just one) are listed on the left. Complete the cover sheet information requested on the right. (What you enter becomes the default for the next time you access the cover sheet, making future cover sheet completion go quickly.)
12. With the cover sheet completed, click <OK>
13. If EZ Form knows where the Outlook executable resides on your computer, you'll be asked "... Do you wish to email Prime Label?". If you are presented with this question and you use Outlook as your emailing program, click <Yes> and then send the email that EZ Form generates
14. Otherwise, manually create a new email message
15. Address it to          service@primelabel.com
16. Make the subject    Labels for Expediting
17. Attach the file         C:\EZFORM\EZFEXP01.DDD
18. Send the email

Q: Handbook 8 has entries for ground beef containing 5%, 10%, 15%, 20%, 25%, and 30% fat. How do I create a ground beef containing 18% fat? 40% fat?

A: In the big picture, you add to your product formulation a new sub-formulation that consists of two ingredients. To achieve 18% fat, the two ingredients are most naturally the 15% fat ground beef and the 20% fat ground beef, but you can use other choices of ground beef as long as one has a higher %fat than your target (18%) and the other a lower %fat than your target. To achieve 40% fat, one ingredient is any of the existing ground beefs (all with %fat below the target), while the other ingredient is 100% fat beef tallow. Below are the details for the case of putting 120 lbs of 40% fat ground beef in a formulation:

First, create a sub-formula with the appropriate two ingredients:


1. With the product formulation edit screen open, click the “Add” menu item
2. Click “New Formulation”
3. Type in the desired ingredient description. For this example, use “Ground beef 60% lean”
4. Click <Close>
5. Type in the amount of ingredient (120 in this example)
6. Click <OK>
7. The new ingredient appears in the formulation. Click the * (asterisk) at the far left to start the process of adding ingredients to the sub-formulation
8. Open the “DataSource” menu and choose “USDA Handbook 8”
9. Type “Beef, ground”
10. Click on the entry “Beef, ground, 70% lean meat / 30% fat, raw”
11. Press <Enter>
12. If your advised that this ingredient is already in your In-house database, click <Yes>
13. For the quantity of this ingredient, type 50, choose % as the unit
14. Click <OK>
15. Click the “Add” menu item to start adding the second ingredient in the sub-formulation
16. Open the “DataSource” menu and choose “USDA Handbook 8”
17. Type “Fat, beef tallow”
18. Press <Enter>
19. If your advised that this ingredient is already in your In-house database, click <Yes>
20. For the quantity of this ingredient, type 50
21. Click <OK>
    
    Next, “select” these two ingredients:
    
    
22. Click at the far left (between the two vertical lines) in front of the first ingredient so that yellow appears in front of that ingredient
23. Click at the far left (between the two vertical lines) in front of the second ingredient so that yellow appears in front of both of the ingredients in the new sub-formulation
    
    Now, direct EZ Form to adjust the weights of these two ingredients so that the %fat for the two combined ingredients is our target of 40%:
    
    
24. Open the Edit-Selected menu and choose “Adjust Weights to Achieve Nutrient Target”
25. “Total Fat” is highlighted by default, so just click <OK>
26. Leave the first box showing “100.000” and change the second box to our target of 40 (40 grams of fat per 100 grams is the same as 40% fat)
27. Click <OK>. Note how the weights of the two ingredients are adjusted
    
    Finally, this sub-formula is needed for nutrition purposes, but not for the ingredient statement or even an inspector, so “hide” it:
    
    
28. Click on the parent ingredient for the sub-formula (i.e., click on “Ground beef 60% lean”)
29. Open the “Edit-Ingredient” menu and choose “Adjust Status”
30. Click on the third option, “have any sub-formula ignored”
31. Click <OK>

Q: If I go the the In-house Ingredient database and change the nutritional profile of an existing ingredient, will that change be automatically applied to all products containing that ingredient?

A: No it will not. So that you have historical records of how things were when a product record was created (and information sent to the USDA), each product has a local copy of the nutritional profile of each ingredient, and these local profiles are not changed when the In-house Ingredient database is changed. However, you are presented with a list of all product records in which the revised ingredient is used. In addition, if you go to edit the formulation for one of these product records (or, more appropriately, a copy), you will see displayed in red each ingredient whose nutritional profile no longer matches values in the In-house Ingredient database. You may then update the nutritional profile of one or all ingredients in the formulation by clicking <Edit-Ingredient> and then <Update Nutrient Profile>

Q: Can I print the Nutrition Facts Panel in a Landscape format instead of a Portrait format?

A: Yes, by making this the default print orientation for your printer. In most cases, you can make this change by opening Windows' Printer folder, highlighting your current printer, clicking on <File> and then <Properties>, clicking on the <Paper> tab, and then clicking <Landscape>. For some printers, you may have to make this change using the printer's physical control panel.

Q: How do I export my NFP so I can email it or load it into another program?

A: Most often an NFP is emailed as a PDF file. A PDF file can be created from EZ Form in one of two ways: Via the “Acrobat PDFWriter” or via GhostScript. GhostScript also allows EZ Form to create BMP or other graphic files containing an NFP.

Acrobat PDFWriter: If your company has made Acrobat PDFWriter available to you as a printer choice, then you can create a PDF of an NFP as follows:

1. Go to the Windows’ Printer screen and make Acrobat PDFWriter your default printer
2. In EZ Form, select the product whose NFP is to be produced
3. Open the File menu and choose Printer Current Product Record
4. Put a check mark in front of just Nutrition Facts Panel
5. Make sure the Output Destination/Type shows “Printer”
6. If you do not wish to have headers and footers included in the PDF file, adjust the Selected Options associated with the NFP to read “1/page” as follows:
   1. Click on the button to the right of “Nutrition Facts Panel”
   2. Click on “Multiple” in the “NFPs per page” item
   3. Set “Number of Columns” and “Number of Rows” each to 1. You also will probably want the “Left Margin” and “Top Margin” to be zero.
   4. Click <Close> then <OK>
7. Click <OK> to begin the printing
8. After a few seconds, the Acrobat PDFWriter print driver will ask you to enter a name for the file be created. Complete this screen as you desire, then click <OK>

GhostScript: If you do not have Acrobat PDFWriter available or you wish to create a file type other than PDF, then proceed as follows (step 1 only needs to be completed once):

1. Print out and follow these directions to install the GhostScript program and set up the “Apple LaserWriter 16/600 PS” print-to-file printer on your computer. (These same directions are available in EZ Form: Open the Settings menu, choose Auxiliary Program Locations, and then click "Obtaining and Installing Ghostscript")
2. Select the product whose NFP is to be placed in a PDF or similar file
3. Open the File menu and choose Printer Current Product Record
4. Put a check mark in front of just Nutrition Facts Panel
5. Change the Output Destination/Type to the file type to be created (e.g., PDF File)
6. If you do not wish to have headers and footers on the page placed in this file, place a check mark in the box in front of “Suppress Headings/Footers”
7. If desired, change the “Output folder” and/or the default ”NFP” “Output file name” associated with the “Nutrition Facts Panel” item
8. Click <OK> to begin the printing
9. After a few seconds, a “Print” window will appear along with a gray box giving instructions. As directed, change the printer being used to the Apple LaserWriter, then click <OK>
10. After a few more seconds, a “Print To File” window will appear asking for the name of the file to be created. EZ Form has stuffed the clipboard with the necessary response, so just hold the Ctrl key down and press V to paste in the clipboard information, then click <OK>
11. Shortly, a black window titled GSWIN32C will appear. In a few more seconds, it will disappear and a message box will be presented indicating the name and location of the file that has been created. Click <OK> to close the message box and resume using EZ Form.

Q: I want to save the application I entered today on a diskette. How do I do this?

A: Use the Export function. First give your application a name by clicking on <File>, then <Title>. Then, also from <File>, choose <Export>. You'll now be asked to designate where the product record should be saved. To save it to a diskette, the path will be A:. Next, make sure a check mark appears in front of "Export complete product record..." and not in front of the other two options. Put your diskette in drive A:, and then click on <OK>.

Q: I have nutritional data for my product from a lab analysis. EZ Form computed the serving size for this product to be 60 grams. The lab analysis said Vitamin A was present at 10% in 100 grams of product, but when I enter 10 for Vitamin A in EZ Form and then look at the Nutrition Facts Panel, Vitamin A shows as 0% rather than 6%. What’s wrong?

A: By default, EZ Form expects the nutrient data for vitamins and minerals to be entered in units of weight rather than as % RDI. Since the lab gave you values as % RDI, you must tell EZ Form that you will be entering % RDIs. You do this on the "Editing Nutrients" screen by clicking on the "%RDI" button located at the bottom-left of the screen.

Q: How do I create a backup of my entire EZ Form directory, for example when installing an upgrade?

A: The following assumes that EZ Form is installed in the C:EZFORM folder. Revise as needed if EZ Form was installed elsewhere.

1. Double Click on "My Computer"
2. Double Click on the "C:" drive
3. Double Click on the EZ Form folder
4. Click on "Edit" in the menu bar of the EZ Form folder window
5. Click on "Select All"
6. Click on "Edit" in the menu bar
7. Click on "Copy"
8. Click on "File" in the menu bar
9. Click on "Close"
10. Click on "File" in the menu bar of the C: window
11. Click on "New"
12. Click on "Folder"
13. Enter a folder name (e.g., "EZ Form Backup")
14. Double Click on the new folder
15. Click on "Edit" in the menu bar of the EZ Form Backup folder window
16. Click on "Paste"
17. Click on "File" in the menu bar
18. Click on "Close"
19. Click on "File" in the menu bar of the C: drive window
20. Click on "Close"
21. Click on "File" in the menu bar of the My Computer window
22. Click on "Close"

Q: I'm getting a new computer. How do I go about moving EZ Form with all my data to this new computer?

A: The answer to this questions depends upon whether or not your old and new computer can, at least temporarily, both be attached to a network.

Networked Computers: On your old computer, run EZ Form, proceed to the main screen and click on <Help> and then <About>. Make note of the folder that is reported as the "Data Location" (usually C:\EZFORM\DATA). Exit from EZ Form. Invoke Windows Explorer. Copy the EZ Form data folder identified above to a folder on the network which can be accessed from your new computer. Using your latest CD or download, run Setup to install EZ Form on the new computer. Now invoke EZ Form on the new computer. On the "Path to Existing Program Data" window that opens, click on "Data files for this program already exist for a PRIOR version...". At the bottom of the screen, for the "Location of existing program data files", enter the path to the copy on the network of the EZ Form data folder. Click <Continue> The "New Data Path" window now opens. It is recommended that you leave your data out on the network so it is backed-up on regular basis. However, if you wish to have the data reside on your new computer, then enter the desired location for the EZ Form data (usually C:\EZFORM\DATA) and click <OK>. EZ Form will now proceed to transfer, update, and re-index your data as needed.

Non-networked Computers: With a supply of formatted, blank 1.44MB diskettes on hand, invoke EZ Form on your old computer. Proceed to the main screen, then click <File> and then <Transfer>. Proceed as directed, labeling your disks so you know what is disk 1, disk 2, etc. Take these transfer disks to your new computer. Using your latest CD or download, run Setup to install EZ Form on the new computer. Now invoke EZ Form on the new computer. On the "Path to Existing Program Data" window that opens, leave the dot in front of "This is a NEW installation of this program..." and click <Continue> at the bottom of the screen. The "New Data Path" window now opens. If you wish to have the data reside on your new computer, then simply click <OK>. However, it is recommended that you place your data out on a network so that the data is backed-up on regular basis. To do this, enter the desired location for the EZ Form data (e.g., H:\EZFDATA) and click <OK>. EZ Form will now proceed to set up and index empty data files. Proceed to the main screen. (You'll be advised that you are working in Demo mode. This is what you want.) At the main screen, click <File> and then <Transfer>. Follow the directions for transferring in your EZ Form data from the transfer disks.

A: System requirements are:

• Windows 7, Windows Vista, Windows XP, Windows Server 2003, Windows 2000 Service Pack 3 or later, Windows Me, or Windows 98 operating system
• 256 MB RAM (memory)
• 200 MB+ available hard disk space
• Windows compatible printer

A: Follow the basic instructions below or click on the highlighted text for more detail:

1. If you have ever downloaded a copy of EZ Form in the past, check for the folder C:EZFTemp on your computer and remove it if it exists.
2. Click on the download button above.
3. Click <Open> or select "Run this program from its current location" and click <OK>.
4. When the Winzip Self-Extractor window appears, click <Unzip>.    Once the file is unzipped, click <OK> and <Close>.
5. Run C:EZFTempSETUP.EXE.    Follow the prompts to complete Setup.    You may now delete the C:EZFTemp folder and all its contents.
6. Run EZ Form®.    Follow the prompts to complete the EZ Form® installation.
7. Please don't hesitate to call us at (202) 546-3333 (9am to 4pm Eastern Time) if you have any problems.

Detailed Instruction:

Locate and remove C:EZFTemp -- Run Windows Explorer. By default, you'll be looking at the contents of your C: drive. Look for an EZFTemp folder among the folders and files shown in the right-half of the screen. (To arrange the folders in alphabetical order, click on "View" in the menu, then on "Arrange Icons", and finally on "by Name".) Single-click on the EZFTemp folder to highlight it, then press the "Delete" key. Click on <Yes> in response to the deletion confirmation.

Run Setup -- Run Windows Explorer. In the list of folders and files in the right-half of the screen, double-click on the EZFTemp folder to open it. Look through the contents of the EZFTemp folder for the file "SETUP.EXE". (If the files in the EZFTemp folder are not listed in alphabetical order, click on "View" in the menu, then on "Arrange Icons", and finally on "by Name".) Double-click on the entry for "SETUP.EXE". Note: The .EXE extension may not be displayed. With the files displayed in alphabetical order, SETUP.EXE will be the first SETUP file listed. To verify this, right-click on the entry in question, then click on "Properties". The "Type" should be Application and the MS-DOS name" should be SETUP.EXE.

Complete Setup -- Read the opening screen, then click on <Continue>. For "Name", enter your name or the tile of your position (e.g., QA Manager). For "Organization", enter your company's name. Click on <OK>. Click on <OK> again to confirm the information. Setup proposes installing EZ Form® in the folder C:EZFORM. We recommend that you accept this default and simply click on <OK>. (Note: If you are running Setup to install an upgrade to an existing EZ Form installation, and that installation is not in C:EZFORM, you must click on "Change Folder" and select the folder which currently contains the EZ Form program; i.e., the folder containing EZF.EXE.) On the next screen, click on the large icon which displays a computer. Leave the Program Group as EzForm and click on <Continue>. After Setup completes copying files, click on <OK>.

Run EZ Form® -- Go to your Windows desktop, display the Taskbar, click on <Start>, then click on "(All) Programs". In the list displayed, click on "EZ Form" and then on the "EZ Form" tab which appears.

Complete EZ Form® Installation -- The first time EZ Form® is run after completing Setup, a secondary installation is performed:

The first screen allows you to specify the path to any existing data. In general, you should not need to change anything on this screen. However, if this is a new installation of EZ Form® but your company has EZ Form® data residing on a network, then click on "Data files for this program already exist for a PRIOR version ...", and then click on <Browse> locate the file EZF_MAX.DBF on the network, and double-click on it so that you are brought back to the "Path to Existing Program Data" screen with the network path now displayed. Click on <Continue>.

The "New Data Path" screen now opens, allowing you to specify where the EZ Form® data should reside once secondary installation is complete. If you have existing data, this gives you an opportunity to move the data to a new location. The default location for the EZ Form® data is C:\EZFORM\DATA. However, if your computer is attached to a network, we recommend placing your EZ Form® data in a folder on the network so that it is backed-up by your network administrator on a regular basis. If desired, change the location in which the EZ Form® data is to be stored. Click on <OK>.

If the location of previous EZ Form® data was not specified, then you will now be asked to enter your company's name and mailing address. Do so and click on <OK>. If the location of previous EZ Form® data was specified, then you'll be advised that EZ Form® is either updating from version x to version y, or that version z is being reinstalled. Click on <OK>.

EZ Form® databases will now be created, updated, and re-indexed. When you are informed that EZ Form® installation is complete, click on <Continue>. Read and respond to additional screens as appropriate until you come to the EZ Form® main screen which displays a menu, toolbar, and numbered boxes. To view/print a tutorial on using EZ Form®, click on "Help" and then on "Tutorial".

© 2010 Prime Label Consultants, Inc. (202) 546-3333. All Rights Reserved.