Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Note
titleOption B Discontinued

Option B is no longer available for download.  This guide is for existing users only.  The Option D with Control Center software provides an Excel-based alternative to Option B.

Scroll office ignore

Multiexcerpt include
MultiExcerptNameVersion 6.1
nopaneltrue
PageWithExcerptLIB61:Template Page Includes


Table of Contents

Overview

...

After you download the Option B installation file, see the PRL Software Installation Guide to help you install the software on your computer.

 


Anchor
Enable Macros
Enable Macros

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 Control Center.

...


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

Getting Started

Excerpt Include
LIB61:Option D with Control Center User Guide
LIB61:Option D with Control Center User GuideGetting Started Guide - Option BGetting Started Guide - Option B
nopaneltrue

A message box saying something like “Data directory created called 'C:\PRL2011'.” may appear. This is normal. The data directory is the location to which your data files will be written.  The Registration form Control Center then opens. 


Scroll office title
titleRegistration FormControl Center

Image Modified

Multiexcerpt include
MultiExcerptNamecontactinfo
nopaneltrueMultiExcerptNamecontactinfo
PageWithExcerptLIB61:_RegistrationFormControlCenter

Multiexcerpt include
nopaneltrue
MultiExcerptNamemultipleapps_forms
nopaneltrue
PageWithExcerptLIB61:_RegistrationFormControlCenter

Scroll Ignore

More Registration Form Functions

...

More Control Center Functions

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

Scroll office only

Change Report Year

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


Change the Report Root

Excerpt Include
nopanel
LIB61:Change Report Root
LIB61:Change Report Roottrue

 


Excerpt Include
LIB61:More Registration Form Control Center FunctionsLIB61:
More Registration Form Control Center 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.

 
Scroll Ignore



 

Expand
titleForm 26...

Image Modified

Scroll Ignore
Expand
titleForm 26A...

Image Modified

Scroll Ignore
Expand
titleForm 27...

Image Modified

Scroll Ignore
Expand
titleForm 25...

Image Modified

Scroll office only
Scroll office title
titleForm 26
Image Modified

 

 

 




Scroll office only
Scroll office title
titleForm 26A
Image Modified
Scroll office only
Scroll office title
titleForm 27
Image Modified
Scroll office only
Scroll office title
titleForm 25
Image Modified

...


Identity Fields

The identity fields in the header area of each form are filled with the values you entered on the Registration form Control Center.  Changing the identity fields here does not update the corresponding fields on the Registration form Control Center.  While the certification number and applicator name are editable, there are better methods for reporting for multiple applicators.  The commercial permit number field is editable so that you can report for multiple commercial permittees  in one report submission. 

...

For your convenience, if you hover over the header cell with your mouse, the column headers show a “tool tip” with a data description for that column. In addition, most of the data entry cells show a descriptive prompt when the cell is selected.  If a prompt needs to be moved, simply drag it out of the way.  Additional information about the fields in each form is available from the Data Dictionary.

You can use standard Excel methods for moving around the spreadsheet from one cell to another.

 


Note

Excel has a few surprising behaviors. If you use arrow keys or Tab to move more than one row past the part of the spreadsheet containing data, the input focus will automatically move back to the top of the worksheet instead of to the next row.

 


Many of the standard editing features of an Excel spreadsheet are available for your use during data entry. For example, Copy, Cut, Paste, and Clear Contents can be used to edit individual cells.  Since the eForms do not have selectable row numbers, we have provided two buttons for copying or deleting an entire row

Values entered into cells are checked against a simple set of validation rules.  See Validation for more information. 


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.

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

Report Form Menus and Controls

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

Record Layouts

scroll-office-ignore

eForm Menus and Controls

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

...

only

See the Data Dictionary in the Appendix for more information.


Multiexcerpt include
MultiExcerptNameWordDoc26
nopaneltrueMultiExcerptNameWordDoc26
PageWithExcerptLIB61:_FormColumns

nopanel
Multiexcerpt include
trueMultiExcerptNameWordDoc26A-OptB
nopaneltrue
PageWithExcerptLIB61:_FormColumns

Multiexcerpt include
MultiExcerptName
MultiExcerptNameWordDoc2725
nopaneltrueWordDoc2725
PageWithExcerptLIB61:_FormColumns

Multiexcerpt include
MultiExcerptNameWebSite26
nopaneltrueMultiExcerptNameWebSite26
PageWithExcerptLIB61:_FormColumns

Multiexcerpt include
nopaneltrue
MultiExcerptNameWebSite26A-OptB
nopaneltrue
PageWithExcerptLIB61:_FormColumns

Multiexcerpt include
MultiExcerptNameWebSite2725
nopaneltrue
MultiExcerptNameWebSite2725
PageWithExcerptLIB61:_FormColumns