Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Scroll Office Ignore

Multiexcerpt include
nopaneltrue
MultiExcerptNameVersion 6.0
PageWithExcerptLIB60:Template Page Includes

Table of Contents

Overview

...

Warning

After you install Option B, you must change the macro security setting in Excel.  If you do not change the security setting and enable macros, many of the features in the spreadsheets will not function correctly.  Depending on your macro security setting and version of Excel, Excel may ask if you want to enable Macros when you open these forms.  ALWAYS  enable macros when using this software.

If Macros have not been enabled, the spreadsheets should show a prominent warning in the header area. (Note: the “Macros Disabled” warning may be briefly visible when you open a form and while you are saving a form; this is normal.) 

The instructions for enabling macros are also available from the Help menu (Macro Security Setting item) on the Registration form.

Warning
titleImportant Note for Excel 2010 Users

When an Option B workbook is opened, a macro runs that reads some identity information from the Registration form and hides the red “Macros are disabled” warning in the header area of the spreadsheet. In Excel 2010 only (not in earlier versions of Excel), this macro runs only if Excel is already running when you open the workbook.

Therefore for Excel 2010, we strongly recommend that you start Excel 2010 before opening an Option B workbook.

 

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

...

Multiexcerpt include
nopaneltrue
MultiExcerptNamemultipleapps_forms
PageWithExcerptLIB60:_RegistrationForm

...

More Registration Form Functions

Scroll Office Only

More Registration Form Functions

There are several buttons and menu items available on the the Registration form that can help you prepare and submit your PRL report.

Scroll Office Only

Change Report Year

Excerpt Include
LIB60:Changing the Report Year
LIB60:Changing the Report Year
nopaneltrue

 

Change the Report Root

Excerpt Include
LIB60:Change Report Root
LIB60:Change Report Root
nopaneltrue

 

Excerpt Include
LIB60:More Registration Form FunctionsLIB60:
More Registration Form Functions
nopaneltrue

 

 

Report Forms

The PRL report forms are where you will enter the data that you need to report to the NYSDEC. Each form is used to report a particular type of pesticide-related activity.

 

Warning
titleIMPORTANT

The Excel eForms rely on the use of VBA Macros. ALWAYS enable macros when using this software.

...

Warning

Ditto marks or use of the words "ditto", "same", or similar entries are not accepted by the Pesticide Reporting Service Bureau. Instead, you can use the EPA Reg Number List. or copy and paste as a convenient way to enter the same information repeatedly.

 

The columns on each form and their descriptions are

eForm Menus and Controls

The eForms have a set of menus and controls designed to assist you in creating your PRL report.

Scroll Office Only

Excerpt Include
Report Form Menus and Controls
Report Form Menus and Controls
nopaneltrue

Record Layouts

Scroll Office Only

See the Data Dictionary in the Appendix for more information.

 

Multiexcerpt include
nopaneltrue
MultiExcerptNameWordDoc26
PageWithExcerptLIB60:_FormColumns

...

Multiexcerpt include
nopaneltrue
MultiExcerptNameWebSite2725
PageWithExcerptLIB60:_FormColumns

eForm Menus and Controls

The eForms have a set of menus and controls designed to assist you in creating your PRL report.