Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scroll office ignore

Multiexcerpt include
nopaneltrue
MultiExcerptNameVersion 6.0
PageWithExcerptTemplate Page Includes

Table of Contents

Overview

Pesticide Reporting Software Option D is a set of four formatted Microsoft Excel workbooks designed to assist you in electronically recording Pesticide Reporting Law (PRL) information and reporting it to the NYS Department of Environmental Conservation.  This option is recommended only for users who have expertise with Excel but cannot use any of the other Options (e.g., users who cannot run Windows-based programs or Excel workbooks with VBA Macros).  These workbooks provide little assistance to the user except for formatting the PRL spreadsheets and Excel-based validation. There is no built-in assistance for uploading a PRL report to the NYSDEC.

...

Neither option requires installation; just download the Option D or Option O workbooks you require.  Note that the workbook workbooks for each form type must be downloaded separately.

If you need further assistance, contact the Pesticide Reporting Service Bureau.

 

Using the Workbooks

Include Page
PSBD:Decide Which Forms to Use
PSBD:Decide Which Forms to UseForm TypesForm Types

 

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.

 

Note

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  you click in a cell.

 

Tip

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. 

Scroll office ignore
Expand
titleForm 26...

Image Modified

Expand
titleForm 26A...

Image Modified

Expand
titleForm 27...

Image Modified

Expand
titleForm 25...

Image Modified

Scroll office only
Scroll office title
titleForm 26

Scroll office title
titleForm 26A

Scroll office title
titleForm 27

Scroll office title
titleForm 25

\

...

Scroll office ignore

Record Layouts

The columns on each form and their descriptions are

multiexcerpt-include
nopaneltrue
MultiExcerptNameWordDoc26
PageWithExcerpt_FormColumns

Multiexcerpt include
nopaneltrue
MultiExcerptName_FormColumnsWordDoc26A-OptB
PageWithExcerpt_FormColumns

Multiexcerpt include
nopaneltrue
MultiExcerptNameWordDoc2725
PageWithExcerpt_FormColumns

Multiexcerpt include
nopaneltrue
MultiExcerptNameWebSite26
PageWithExcerpt_FormColumns

Multiexcerpt include
nopaneltrue
MultiExcerptNameWebSite26A-OptB
PageWithExcerpt_FormColumns

Multiexcerpt include
nopaneltrue
MultiExcerptNameWebSite2725
PageWithExcerpt_FormColumns