Do not delete! |
Never delete entire cells, rows, or columns because this
will cause permanent damage to the software. If possible, immediately “undo”
the deletion with Ctrl Z or “Undo” in the Edit menu. See Trac Tip below. |
Clear contents, don’t delete. |
Deleting physically removes the cell, row, or column causing
permanent damage to the software. Trac sheets are protected to prevent
this from happening. The delete key on the keyboard is probably the best
way to clear contents (you can also right click on the cell or cells you
want to clear and click on “clear content”). |
Light-blue cells |
Don’t clear contents of the light-blue-shaded cells. Clear
contents of the white cells and all the related entries in the light-blue-shaded
cells also clear. |
Comment boxes |
Read helpful tips in comment boxes by moving the cursor
over the red triangle in the top right corner of some of the Trac column
heading cells. |
Drop-down lists |
Access drop-down lists by clicking on the down arrow located
directly to the right of the cell. Click on desired item in the list to
select and enter. |
Type in a cell with drop-down list |
Type data into a cell with a drop-down list
if the drop-down
list does not contain the information you want to enter. |
Faster data entry – tank mixes |
To make data entry easier, for such things as tank mixes
or harvested blocks, to repeat large sets of data use Excel’s fill in shortcuts
as described under Excel Shortcuts, page 7 of the manual. Don’t copy and paste data in
the light-blue cells. |
Unprotect sheets |
Data entry sheets (NameAddress,
SiteLists, HarvestData,
FertData, SprayData) are protected to limit what can be done to them. Individual
sheets can be unprotected using Tools, Protection, Unprotect. Protect
the sheet again, after Unprotect, to prevent inadvertent damage to the Trac software
sheet. See the top two Trac Tips. |
Password Protect |
Report sheets, the ChemTable sheet, and the EPA
Central Posting Form sheet are password protected and cannot be unprotected. |
EPA WPS Central Posting Form |
When applying a tank mix on the same day, the re-entry
time and date for each material in the mix will be calculated and displayed
on the EPA Central Posting Form sheet. To Print: Select the rows you
want to print, and hit the Print Button on the form. The latest REI among the selected
applications will calculate and post in a box at top of form. |
Sorting Data |
Sorting data on the SprayData
sheet will sort the information
on the Processor Report forms, including the EPA Central Posting Form. |
