|title||Modifying Option D Spreadsheets|
Do not modify the format or layout of any of the Option D spreadsheets. Modifying the spreadsheets will prevent us from processing the files and may lead us to reject your submission.
The form will open up with the header area pre-filled with data from the Registration form.
If you opened up the List of Applicators and Technicians, the applicator you entered on the Registration form will be pre-filled on the first row of the form. On all the forms the name and ID(s) appropriate to the form type will be pre-filled in the header area.
To add a new row on any of the forms, just click in the first empty row and start typing. As you are entering data right-clicking the mouse will display a pop-up menu of options to insert, duplicate and delete rows and options to cut, copy and paste one or more cells. If you did not make applications (Form 26) or sell any pesticides (Form 25 or 27), use the check box in the header area to tell us that.
The EPA Registration Number List makes it easy to enter the same product repeatedly.
At any time you can validate the data you have entered by clicking the Validate menu item. Cells which do not pass validation will be displayed with a pink background so that you can find and correct them.
When you are done, save the file by clicking the Save item on the File menu. By default the file is saved in the C:\PRLyyyy (where yyyy is the report year). You can change the file location to wherever you want, but it is simpler when you are ready to upload the files if you save them in the default location.