Option A Getting Started Guide
Option B Getting Started Guide
Page History
...
| 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. |
...
Getting Started
| Excerpt Include | ||||||
|---|---|---|---|---|---|---|
|
...
| Multiexcerpt include | ||||||
|---|---|---|---|---|---|---|
|
| Multiexcerpt include | ||||||
|---|---|---|---|---|---|---|
|
| Scroll Ignore |
|---|
More Registration Form Functions |
| Scroll office only |
|---|
More Registration Form Functions |
There are several buttons and menu items available on the Registration form that can help you prepare and submit your PRL report.
| Scroll office only | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Change Report Year
Change the Report Root
|
...
The identity fields in the header area of each form are filled with the values you entered on the Registration form. Changing the identity fields here does not update the corresponding fields on the Registration form. 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.
...
On each of the forms you can indicate that there was no reportable activity for the report year.
Excel eForms
...
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.
Overview
Content Tools