Skip to main content
Skip table of contents

Using the Workbooks

The information on this page only applies to version 6.1 of the Reporting Software Options and related documentation.  See this page for other versions of the documentation.  The version number of the PRL software you are using can be found on the Help menu under the About item.


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. 

Form Header

Each form has one or more identification numbers in the header area appropriate to the form type.  These identification numbers are used to associate your report with the correct applicator(s) or organization.  If you are required to fill out a particular form type, you must also fill out the identification numbers and associated name field in the header area.

The business registration number is not required on Form 26, but you should submit it if you have one so that we contact you as needed.  If you have more than one business registration number, see this FAQ.

All applicators and pesticide sales businesses are required to report even if they did not make any applications or sales.  See Reporting No Applications or Sales for more information.

The forms also include a report year field in the header area.  This field is also required.  In addition, links to this documentation in three different formats are included.


Data Entry Grid

Both Option D and O contain descriptions for each column in the column heading comments.  Click in the cell and the cell comment will appear.  Option D also contains the column descriptions in small popup windows that appear when you click in a cell.

The popup windows that appear when you click on a cell in the data entry grid of Option D can be moved. Just click in the popup and drag it while holding the mouse button down.

In Option D some columns are validated.  If the data you enter does not conform to the criteria for the column, Excel will display a descriptive error message.  You will need to correct (or delete) the data in the cell before moving to the next cell.  If you need more information about a particular column, complete field descriptions can be found in the Record Layouts section or the Data Dictionary.



Report Forms

Each form is used to report a particular type of pesticide-related activity.

Form 26...

Form 26A...

Form 27...

Form 25...

Record Layouts

The columns on each form and their descriptions are:


Form 26...

Reporting Columns

For each product in each pesticide application, report these fields using Form 26.  All columns are required except for the End Date.

  1. EPA Registration Number

  2. Product Name

  3. Quantity

  4. Units of Measure

  5. Application Date

  6. End Date

  7. County Code

  8. Address

  9. Municipality

  10. Zip Code


Record Keeping Columns

     These columns are optional; you may use them to fulfill the record keeping requirements of the PRL.

    11. Dosage Rate

    12. Method of Application

    13. Target Organism(s)

    14. Place of Application


Form 27...

For each sale of restricted use pesticides or general use agricultural pesticides to certified private applicators, report these fields using Form 27.  All columns are required.

  1. EPA Registration Number

  2. Product Name

  3. Quantity

  4. Units of Measure

  5. Date Sold

  6. County Code

  7. Address

  8. Municipality

  9. Zip Code


Form 25...

For each container size of each restricted use pesticide sold to New York purchasers, report these fields using Form 25.  All columns are required.

  1. EPA Registration Number

  2. Product Name

  3. Container Size Quantity

  4. Container Size Units

  5. Containers Sold

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close