Trac^© FAQ’s #21

Why are the Re-entry Date or Re-entry Time cells blank in the Safe Entry columns on the CentralPosting worksheet?

Empty Safe Re-entry Date or Safe Re-entry Time cells on the Central Posting form indicate that data for the pesticide application on the SprayData worksheet is either missing or in an incorrect format. Check each of the items outlined below, make corrections as required, and then see if the change corrected the problem on the Central Posting Form.

On the SprayData worksheet check the following:

Date Spray Applied column — a date must be entered.

Time Finish Spray column — a time must be entered in the correct format and Trac then converts it to a standard 24-hour format. For time format information, refer to FAQ #19 or access the Comment Box from the red triangle in the upper right hand corner of either the Time Start Spray or Time Finish Spray cells.

REI column — REI must be in hours and contain only numbers, no words. If the REI has words in addition to a number, the Safe Re-Entry date and time will not calculate. In Trac there are a few chemicals this applies to because the REI on the pesticide label may vary depending on its usage. Therefore, you must determine the appropriate REI for the pesticide based on your use pattern and the pesticide label. Simply enter the appropriate value in the REI cell.

The REI cell may be empty because the formula that looks up the REI was inadvertently deleted from the cell. To re-enter the formula, copy an empty, unused cell in the REI column and paste it into the empty REI cell where the formula was deleted.

On the ChemTable worksheet check the following:

Make certain that the REI for all the user-defined chemicals (bottom of list) has been entered. If any are missing, enter them as per the pesticide label. Always enter the REI in units of hours.

If, after checking all of the above, the REI is still missing simply type the appropriate REI from the pesticide label into the cell.