Skip to main content
link to IPM tools section
->Home > trac > tracfaqs

Trac FAQ Archive

Obtain Trac Software for Fruit
Obtain Trac Software for Turf
Trac FAQs
Trac Bug Sheet
Trac Tips
Excel Shortcuts
About Trac Software
Trac Software Manual (200k pdf)

Below are FAQ’s for previous versions of Trac software.

FAQ-2. When saving the Trac file with my data entries, why does the following message appear?

“Cannot save the file ‘TracApple04.xls’. The file exists and is marked Read-Only. Save the file with another file name or to another location.” when using TracApple04.

OR

“Cannot save the file ‘TracGrape04.xls’. The file exists and is marked Read-Only. Save the file with another file name or to another location.” when using TracGrape04.

The message “TracApple04.xls is read only” or “TracGrape04.xls is read only” will appear when saving the file for the first time after opening the program file. The “read only” feature is a property of the Trac program file because it originates from a read only CD. This property protects the blank file from being accidentally overwritten or erased. Follow the instructions in the “read only” box and use Save As to save your file with a different name to a convenient location or folder on your computer. Do not save your farm’s Trac record file with the program file name (ex. TracApple04.xls). Instead save the file containing your data with a new name (ex. TracBrookside04.xls).

FAQ-4. What are TracApple 2004’s new features?

New Reports automatically generated from your data, include:

EPA Worker Protection Standard Central Posting Form

EUREPGAP-compliant Pesticide Report Form

Knouse Foods Processor Form

Improved SprayData worksheet includes earliest harvestable date calculation, easier spray rate calculations, and optional weather tracking column.

Improved and accessible ChemTable worksheet includes space for up to ten additional user-defined chemicals and columns for chemical costs so Trac will automatically calculate spray cost for each chemical applied.

Improved Bloom and Harvest worksheet includes a harvest Tracking Number column.

A new FertData worksheet generates a EUREPGAP-compliant fertilization report.

FAQ-6. In TracApple2003, can the Variety Sprayed drop-down list on the SprayData worksheet reference my Varieties list on the FarmData worksheet?

The Variety Sprayed drop-down list on the SprayData worksheet can reference your Varieties list from the FarmData worksheet rather than Trac’s pre-defined list.

Click on the SprayData worksheet tab to open the SprayData worksheet. Click on the cell beneath the column heading Variety Sprayed. On the main menu click on Tools then Protection then Unprotect Sheet. On the main menu click on Data then Validation then Settings.

The Settings tab window will show the following:

Allow:  This should read List. Do not change.

Data:  This will be gray, cannot change.

Source:  This will read =Varieties_Apples.

Select =Varieties_Apples. Press the Backspace key to clear the entry. On the main menu click on Insert then Name then Paste… The Paste Name window will appear. In this window, select Varieties from the list (near bottom of list) in the white box and hit OK. On the main menu click on Tools then Protection then Protect Worksheet.

Your variety list from the FarmData worksheet should now be active in the Varieties Sprayed drop-down list on the SprayData worksheet.

FAQ-15. Is there an easy way to enter spray mixes that were previously entered on the SprayData worksheet?

If you are using the same spray mix repeatedly on different locations or at different times of the year, you can avoid re-entering all the information by copying and pasting it. If just the chemicals in the spray mix are the same, select the Pesticide Trade Name cells containing the chemicals in the mix. Click on Edit then Copy on the main menu. Click on the topmost cell in the Pesticide Trade Name column where you want to paste the copied spray mix list. On the main menu, click on Edit then Paste to paste in the spray mix. Follow the instructions in FAQ-14 to fill in the rest of the information.

Alternatively, you can copy and paste the entire set of SprayData information for the spray mix, from the Date Spray Applied column (A) to the Comments column (AE in TracApple and AF in TracGrape). Select the entire set of data by clicking on one corner cell and then holding the Shift key down while clicking on the opposite corner cell. Click on Edit then Copy on the main menu. Click on the top left cell of the location where you need to put the data set. On the main menu click on Edit then Paste and hit OK, to paste just the copied data into the cells without overwriting any formulas. Then in the top row change any information that is not correct, such as Date Spray Applied, Weather Conditions, etc., and copy into the other rows as described in FAQ-14.

Manage your spray mix records with any combination of copying and pasting sets of data using the methods described in FAQ-14.

FAQ-25-archive. Can the report forms be printed showing just the grower’s data to avoid printing any blank formatted sheets?

This includes the following forms

TracApple report forms (Generic, Mott’s and Yonder, Birds Eye, Beechnut, Knouse, EUREPGAP)

TracGrape report forms (Canandaigua Wine, Carriage House, Cliffstar & Westfield Maid, Growers Coop, Meier’s, Mogen David, Generic)

To print just the portion of the report forms worksheets (Generic, Mott’s and Yonder, Birds Eye, Beechnut, Knouse, and EUREPGAP in TracApple; and Canandaigua Wine, Carriage House, Cliffstar & Westfield Maid, Growers Coop, Meier’s, Mogen David, and Generic in TracGrape) that contains your data and avoid printing any blank formatted sheets, first select the entire set of entered data and then print the selection, as outlined below.

Open the report form worksheet from which you want to print by clicking on the appropriate tab. Select all cells with data by doing either of the following:

Click on the top left cell of the worksheet form (cell A1), scroll down to the last row of entries, press and hold the Shift key while clicking on the bottom right cell of entries.

Or

Scroll down to the last row of entries on the worksheet form, click on the bottom right cell that contains data and, while holding the mouse button down, drag the mouse to the top left corner cell of the worksheet form (cell A1) and then release the mouse button.

Click on File then Print from the main menu. In the Print window under Print What, click on the button to choose Selection and hit OK. If desired, click on the Preview button to verify what will print before clicking on Print in the Preview window.

FAQ-27. When opening TracApple2005 why does the following message appear?

“Excel encountered an error and had to remove some formatting to avoid corrupting the workbook.  Please recheck your formatting carefully.”

If this message appears when opening TracApple 2005, click on “OK” in the framed box directly beneath the error message. TracApple 2005 will open and be ready for use. 

This message only appears when opening TracApple2005 for the first time with Microsoft Excel 2002.  It will not appear if using Microsoft Excel 97, Microsoft Excel 98, Microsoft Excel 2000 or Microsoft Excel 2003.

Before releasing TracApple 2005, this message was thoroughly examined by the programming staff.  All formatting and program functions appear to be in place and working correctly.  The message could be triggered by a minor formatting incompatibility in Microsoft Excel 2002 that has no effect on the use of the program.

This error message does not appear on TracBerry, TracGrape, TracPear, or TracStoneFruit. We will make every effort to eliminate this message in TracApple 2006.