v>EF¥\
United States
Environmental Protection
Agency
Instruction Manual for the
FIFRA Work Plan and
Report T emplate
3/17/2016
-------
Table of Contents
I. Introduction 3
II. Software Needs 4
III. Contact Information 4
IV. Contents of the Template 4
V. General Worksheet Information 6
A. Protecting Worksheets 6
B. Filters 6
VI. Using the Start Worksheet 6
A. Information Required in Top Panel 7
B. Worksheets & Reporting Links 8
C. References 9
VII. Using the Narrative Worksheet 9
VIII. Using the Budget Worksheet 9
IX. Using the Work Plan Worksheet 10
A. Cell Formatting 10
B. Red Triangles in Upper Right Hand Corner of Cells 11
C. Column Information and Entering Data 11
D. Adding rows 13
X. Using the Outcomes Worksheet 14
XI. Using the 5700 Forms (Projections and Accomplishments) 14
XII. Using the Endangered Species Inspections Report 21
XIII. Using the Performance Measures Form 21
XIV. Using the Template for Multi-Year Agreements 21
XV. File Naming Convention 22
XVI. Printing 22
A. For the START page: 22
B. For the Work Plan worksheet: 23
C. For the Performance Measures worksheet: 24
XVII. Creating Your Own Reports 25
XVIII. Frequently Asked Questions 25
XIX. Abbreviations and Glossary 27
2
-------
I. Introduction
The FIFRA Work Plan and Report Template is a new format for the FIFRA grantee work plan,
grantee progress reports as well as the year-end evaluation from the EPA regional offices. This
template has not yet been approved under the Paperwork Reduction Act1.
The template includes proposed work activities from the national FY15-17 FIFRA cooperative
agreement guidance, space for proposed and negotiated grantee work activities, space for grantee
progress reports on the negotiated work activities, and space for EPA comments and
recommendations. The template, a result of a collaborative effort involving staff from EPA
regional offices, the Office of Pesticide Programs, the Office of Compliance and several FIFRA
state lead agencies, was created in order to:
1) streamline the cooperative agreement process for grantees and EPA regional offices;
2) promote national consistency in grantee work plans, grantee progress reports and EPA year-
end evaluation reports;
3) more easily allow for the compilation of data, both regionally and nationally; and
4) assist in the design of a new national data system.
While the template is a change in the format of work plans and reports, it does not change the
type of information reported or the processes used by regional offices and grantees in submitting
cooperative agreement applications, negotiating work plan commitments, and reporting on the
progress of those commitments. This template is not intended to change the normal workflow
process between the grantee and the EPA project officer.
With any new tool, there will be a period of learning and adjustment. This instruction manual
focuses solely on explaining how to use the template within the Excel environment. If you are
not familiar with Excel, there are a number of excellent resources available online you can use to
1 PR A Notice: According to the Paperwork Reduction Act (PRA) (44 USC 3501 et sea.), and the implementing
regulations (5 CFR 1320 et sea.), a Federal agency may not conduct or sponsor, and a person is not required to
respond to, certain collections of information involving identical questions to 10 or more persons unless the agency
has obtained approval from the Office of Management and Budget (OMB). For each such collection activity, the
agency is required to "inform" the respondent that they are not required to respond to the collection of information
unless it displays a valid OMB control number. Failure to display a valid OMB control number permits a
respondent to raise the affirmative legal defense provided by the "public protection" provision in section 3512 of the
PRA (see also 5 CFR 1320.6).
FIFRA Cooperative Agreement reporting is currently approved by OMB under OMB Control No. 2030-0020.
However, the Agency has not yet obtained approval from OMB for this reporting template. Until such approval is
obtained, the reporting template is solely intended to provide respondents with an alternate method of providing
information to the Agency that is already required under the terms of the cooperative agreement. Until OMB
approves the reporting template under the PR A. the PRA's "public protection" provision will prevent the Agency
from treating the failure to utilize the reporting template as grounds for withholding benefits or imposing
penalties. Instead the agency must permit respondents to prove or satisfy the legal conditions in any other
reasonable manner.
3
-------
learn the program. Your IT department may have further resources to recommend. Getting to
know Excel will help you in using the template. You can refer to this website for help:
Microsoft Excel Help and How-to. Another resource is the Help function in Excel. Look for the
'*3 icon in the upper right corner of the screen. You can type questions in the prompt box after
clicking on the question mark.
II. Software Needs
The template was designed using Microsoft Office's Excel 2007, and updated using Excel 2013.
Functionality of the template might be hampered with Excel versions older than 2007.
III. Contact Information
If you discover issues or think of better/easier ways that will improve this template, we would
appreciate hearing from you.
For technical questions about Excel, you can call/email Allen Demorest of EPA Region 9
(demorest.allen@epa.gov. 415-947-4214) and for general questions about the Template
you can call/email Dea Zimmerman of OPP (zimmerman.dea@epa.gov. 312-353-6344).
IV. Contents of the Template
The template is comprised of several worksheets, that all appear at the bottom of the screen once
you open the Excel file.
To open a worksheet, you can either click on the name of the worksheet in the Worksheets
section of the Start page,
Worksheets Included Below:
Narrative
Budget
Work Plan/Report
Outcomes
\
5700 Main
57CC Worker Protection
5700 Container Containment
Endangered Species
Performance Measures
or you can click on the "tab" at the bottom of the template to open a worksheet.
4
-------
Start
Narrative
Budget
Woi± Plan
Outcomes
5700 Main
5700 WPS
5700 CC |
To return to the Start worksheet from another tab, select the "Back" button at the top of a
worksheet or simply click on Start from the tabs at the base of the document. If the Start
icon is not visible, select the M icon to page through all the worksheet tabs and then click the
Start icon.
Worksheets
Start Narrative Budget Work Plan Outcomes
5700 Main I 5700 WPS I 5700 CC I ES I Pert Meas
In order of appearance from left to right, the worksheets contained in the template are:
Start: This is the "cover" page or landing page for the template. This is where the grantee
should begin work by answering the questions numbered 1-8 in the top half of the Start page.
See page 6 for more detailed information.
Narrative: This is the Narrative worksheet where you can add additional narrative descriptions
that don't fit anywhere else in the template. See page 9 for more detailed information.
Budget: This worksheet is a placeholder for you to either insert your budget sheet into the white
space or embed a separate document into this tab. See page 9 for more detailed information.
Work Plan: This worksheet contains all of the "required" and "pick-list" activities in the
national FY15-17 FIFRA cooperative agreement guidance, contains space for the grantee to
enter in work plan activities and progress reports, and space for EPA to add comments and
recommendations. See page 10 for more detailed information.
Outcomes: This worksheet contains a chart that links program areas, outcomes and the EPA's
Strategic Plan goals, helping grantees to comply with Grants Policy Issuance 11-03. See page 14
for more detailed information.
Inspection and Enforcement Action/ Projections and Accomplishments Forms
5700 Main: This is the standard 5700-33H form to be filled out by the grantee to project
inspections and samples and report inspection and enforcement accomplishments on a schedule
negotiated with the regional office, annually at a minimum.
5700 WPS: This is the form to report worker protection inspections, samples and enforcement
actions, on a schedule negotiated with the regional office, annually at a minimum.
-------
5700 CC: This is the form to report container/containment inspections, samples and enforcement
actions, on a schedule negotiated with the regional office, annually at a minimum.
ES (Endangered Species Inspections Report): This is the form used to collect information during
use or misuse inspections on whether applicators are following ES Bulletins, on a schedule
negotiated with the regional office, annually at a minimum.
Perf Meas (Performance Measures): ! This is the form to report the new enforcement
performance measures. Reporting in the form will be mandatory once the template receives an
ICR number from the Office of Management and Budget.
See pages 14-21 for more detailed information on all the 5700 forms and the ES and
Performance Measures forms.
V. General Worksheet Information
A. Protecting Worksheets
Excel has the ability to "protect" a worksheet to prevent users from accidently changing or
deleting important data, formulas, etc. There are six worksheets in the template that are currently
"protected": Start, Outcomes, 5700 Main, 5700 WPS, 5700 CC and ES. You can enter data into
any of these protected sheets. If you have a need to unprotect a worksheet, go to
Review>(Changes) and select Unprotect Sheet. When done, you may protect the sheet again to
prevent accidental deletion of information. No password is required to protect the sheet, just
select OK. The data entry cells of worksheets remain editable when a sheet is protected.
B. Filters
Filters and drop down options are included to easily sort through the items in that particular
column. For example, at the top of the Work Plan in each of the column headings, you will see a
drop down arrow. Use this to select subsets of information you want to display in that column of
the Work Plan. Make sure to review each arrow as you go through the Work Plan. Don't forget
to go back and "select all", otherwise you might think you are missing some of your data!
Activity ft
.t
'15 - '17 Grant Guidance Activity
Activity
T\
©
Work Plan Activity Description (Outputs)
Due Data* ^
©
VI. Using the Start Worksheet
The grantee should initially complete work in the Start worksheet.
6
-------
NOT YET APPROVED UNDER THE PAPERWORK REDUCTION ACT
FIFRA Cooperative Agreement Work Plan and Report
Alabama Department of Agriculture and Industries
Data entry in white boxes only. Asterik denotes a required field.
Grantee Information:
*Name: 1)
"Grantee- Alabama Department of 2)
' Agriculture and Industries
Cooperative Agreement Information:
•Agreement Type: Consolidated 3)
*Number of Years: 4 4)
ADAI
{EPA Region 4)
"Project Period:
Budget Period #1
Budget Period #2
Budget Period #3
Budget Period #4
*Work Plan and Report Applies to:
EPA Grant #:
Start
10/1/2016 5)
10/1/2016
10/1/2017
10/1/2018
10/1/2019
Budget Period #1 6)
Start 10/1/2016
End 9/30/2017
End Extended to:
9/30/2020
9/30/2017
9/30/2018
9/30/2019
9/30/2020
Work Plan/Report Status: Date:
7) 8)
Worksheets Included Below:
Narrative
Budget
Work Plan/Report
Outcomes
I
5700 Main
5700 Worker Protection
5700 Container Containment
Endangered Species
Performance Measures
Reporting Links:
Certification and Training-CPARD
Pesticides in Water-POINTS
References:
EPA Grant Forms List
Template Instructions/Help
FY 15-17 Grant Guidance
A. Information Required in Top Panel
The grantee should complete fields 1-8 in the top panel. Some of the responses in these fields
(Grantee and Project Period) autofill other fields within the template (e.g. 5700 forms, ES and
Performance Measures forms) and create unique identifiers to aid in data compilation.
Many of the fields have drop down selections that you can choose from. Simply position your
cursor in the white area and click. If there are response choices, a drop down arrow will appear
to the right of the white area. Click on the arrow and the response choices will appear. Select
your response by clicking on it, and it will appear in the white box. To clear contents in a cell,
click in the cell and hit the delete key.
Grantee Information
1) Name: Enter the name of the individual primarily responsible for completing the template.
The name does not have to match the name that appears on the SF-424 form.
2) Grantee: Grantee will select the agency name from the drop down list. Once selected, the
agency name will also appear at the top of the Start worksheet, and on other worksheets. The
EPA regional office associated with the selected agency will also appear below the Grantee
box.
7
-------
Cooperative Agreement Information
3) Agreement Type: Select from the drop down list the type of Cooperative Agreement
appropriate for your agency: "Consolidated" or "PPG" (Performance Partnership Grant).
4) # Years: Select the number of years (i.e. project period) covered by this cooperative
agreement: 1, 2, 3, or 4 years.
5) Project Period: Select the beginning date of the project period from the drop down list.
Once selected, the end date for the project period along with the supporting budget periods
will autofill on the Start page, and on other forms in the template.
Extended to: This box is only to be filled out if there is a no-cost extension associated
with the cooperative agreement.
6) Work Plan and Report Applies to: Select from the dropdown list the appropriate budget
period to which the work plan applies.
7) Work Plan/Report Status: Select from the drop down list what the current document
represents (i.e. either work plan or report) and its status (choices are: "Work Plan Draft,
Work Plan Final, Work Plan Final Amended, Report Draft, Report Final, Report Final
Amended"). Make sure to save a unique template file for each type and stage of document.
8) Date: Enter the date in mm/dd/yyyy format that corresponds to the type of document in the
Work Plan/Report Status field.
B. Worksheets & Reporting Links
Worksheets Included Below:
Narrative
Budget
Work Plan/Report
Outcomes
5700 Main
5700 Worker Protection
5700 Container Containment
Endangered Species
Performance Measures
Reporting Links:
Certification and Training-CPARD
Pesticides in Water-POINTS
The yellow section in this panel relates mainly to non-inspection related information, while the
blue section relates mainly to inspection related information. You can click on any of the titles,
and this will open the selected worksheet.
Links to the external databases, CPARD and POINTS, are provided under "Reporting Links"
only as a convenience. ! You do not need to report information entered into these databases
again in the template.
8
-------
C. References
References:
EPA Grant Forms List
Template Instructions/Help
FY 15-17 Grant Guidance
This panel provides access to the various documents that support template users.
EPA Grant Forms List: This link will take you to the EPA Grants and Debarment grant forms
page.
Template Instructions/Help: This link takes you to this document if you need to refer to it as
you complete the template.
FY 15-17 Grant Guidance: This link takes you to the FY15-17 national FIFRA cooperative
agreement guidance.
VII. Using the Narrative Worksheet
The Narrative worksheet is where you can add additional narrative descriptions that don't fit
anywhere else in the template. The Grantee can append documents in the top half of the tab (e.g.
authority to accept the cooperative agreement, legislative changes, neutral administrative
inspection schemes, emerging/significant issues, etc.) The roles and responsibilities of the
Grantee and EPA is already appended there. Regional PO/TCs can append documents in the
bottom half of the document (e.g. case review results or an executive summary of the midyear or
yearend report). There is a suggested outline for an executive summary included in the Narrative
tab.
The recommended method for appending documents here is by using the menu ribbon: 1) Go to
Insert>Text>Object>Create from File>Browse. 2) Once you have selected the file you want to
insert (Word, PPT, PDF, JPG, etc.), click on Insert> Display as Icon>Change Icon>rename the
file with a short descriptive title, such as "Authority" or "Legislative Changes", etc. and click on
"OK" twice. Your document will appear. You can drag and move it under the Grantee or EPA
banner as appropriate. The alternate method is to double click on the Microsoft Office Word
Document icon below, and add content.
VIII. Using the Budget Worksheet
This worksheet is a placeholder for you to either enter budget information directly into the white
space or embed a separate document into this tab. To embed a document, go to the menu and
9
-------
click on "Insert">Text, then click on "Object". Here you can choose to create a new file or
choose an existing file (Word, PPT, PDF, etc.) by selecting "Create from File", Browse to find
your file, and finally choose either "Link to File" or "Display as Icon".
This budget worksheet is also where you can provide your thoughts on your financial draw down
strategy as described in Grants Policy Issuance 12-06.
IX. Using the Work Plan Worksheet
A. Cell Formatting
Each cell is formatted so that text wraps within each cell, the cell should expand so that all text is
visible, and the text is aligned left and at the top of the cell. However, within the Excel
environment, if you copy and paste text from another source (i.e. another excel file, word
document etc.) the formatting from that source will override these defaults. If you notice that the
format to a particular cell is not following these rules after you've added information to a cell,
you can navigate to the "Alignment" section of the Home ribbon in excel and adjust the
formatting of the cell there. \
a - p1
•Ta?. ,
— Home 1 Insert
Table Tools Master FIFRA Cooperative Agreement Workplan-Report Template 3-2-14 - Microsoft Excel -OX
Page Layout Formulas Data Review View Developer Design (g) _ O X
p * Cut
—' '-in Copy
Paste
Times New Rom* 14 * A* A*
-Jill ijSj -.Ja
a- ? ® a
Insert Delete Format Sort St Find &
<2 Clear' Fj|te, select-
B I U A, •
in.** a •
S % * |Td8i!8|
Conditional Format Cell
Formatting" as Table - Styles"
Clipboard
Font .•?
Alignment
Number
Styles
Cells Editing
K2
* ¦* t- J
li
To expand the row height, click on the cell or highlight the row, go to "Cells", then "Format",
then select "Autofit Row ITeight". V
^ J *> •
Table Tools Master RFRA Cooperative Agreement Workplan-
Report Teirclate 3-2-14 -
Microsoft Excel - °
X
aj
—' Home Insert Page Layout Formulas Data Review View Developer Design
# -
a x
rd
1
p,
24 jt Cut
—' Copy
ste .
J Format Painter
Times New Rom * 14 "A* a'
= = = 3^-- | =jj Wrap Text
General
a m ^
Conditional Format Cell
Formatting - as Table • Styles *
gzi cpm 1
BP Jlr -
at
Z AutoSum - A
B I u Hj * • ,A •
1=1 m ^illF IF, A
$ - % ' Too
Insert Delete
Form
Sort &
-2 Clear - Filter -
Find &
Select'
Clipboard
Font !»
Alignment ^
Number '»
Styles
Cells
Cel
id
ri
Vis
Org
Pro
jj
Siz
R
A
w Height...
K2 * f*\
*
E F G 1 J
K
toFit Row Height
-
1
Program Area
NPM
Activity U
i7l
'15- '17 Grant Guidance Activity
Activity
Type —
Work Plan Activity Description (Outputs)
Column Width..,
AutoFrt Column Width
Default Width...
Descri
j
nclude any is:
2
3
4
5
Basic Pesticide
Program
OPP &
OECA
01.00.01.0
Complete administrative/management, fiduciary and
reporting requirements associated with this cooperative
aqreement.
Required
bility
Hide & Unhide ~
Basic Pesticide
Program
OPP &
OECA
01.00.02.0
Build or maintain staff and management expertise on
pesticide program issues and enforcement (e.g. attend
training opportunities through PREP, PIRT, in-service
traininq. etc. or other appropriate activities).
Required
anize Sheets
Rename Sheet
Move or Copy Sheet...
Tab Color ~
tection
Protect Sheet...
Lock Cell
Format Cells...
Basic Pesticide
Proqram
OPP
OECA
01.00.03.0
Respond to pesticide inquiries, concerns, tips, and
complaints from the public.
Required
Basic Pesticide
Program
OPP
01.01.01.0
Provide outreach, communication, and training as
appropriate as a result of new emerging issues, rules,
regulations, and registration and registration review
decisions.
Required
Basic Pesticide
Prnnrom
OPP
m ni no ft
Report information on all known or suspected pesticide
inr-iHontc inunlutnn nr>llinot/>rc tn ODD /hoolrill(f?>ona nns,\
Required
1 1
10
-------
B. Red Triangles in Upper Right Hand Corner of Cells
Instructions within the Work Plan worksheet are indicated by a red triangle in the corner of the
cell. Place your cursor over the triangle for the instructions to appear.
Activity tt
.1
'15- '17 Grant Guidance Activity
Q
vtivity
Type
Work Plan Activity Description (Outputs)
Q
ts) Due Date
K
L
M
N J
O
P
1
Work Plan Activity Description (Outputs)
Due Date
Status
Describe Work Plan Activity m
A ccomplishmen t
(include any issues or innovations, ifappropriate^r
Provide concise and descriptive
information on the status of the
activity; include numeric
information and any significant
IP/
'6/30/2018
None
C. Column Information and Entering Data
In general, the white areas in the body of any worksheet are meant for data entry.
Program Area (Column E): This listing is taken directly from the national FY15-17
FIFRA cooperative agreement guidance. Information in this column should not be
changed.
NPM (Column F): Describes which National Program Manager the grant funding for a
particular work activity comes from: OPP or OECA. Information in this column should
not be changed.
Activity # (Column G): ! This number is unique for each row and matches the activity
number from the national guidance. Do not change the "Activity Number" listed in these
cells. If a row needs to be added, see the instructions below for "adding rows."
' 15 - ' 17 Grant Guidance Activity (Column I): ! All of the proposed work activities
listed in column H, FY 15-17 Grant Guidance Activity, are taken directly from the
national cooperative agreement guidance. Do not change anything in this column.
Activity Type (Column J): Describes if the activity is required or pick-list. For all the
pick list activities, the grantee will need to open the drop down list and choose either
"Selected" or "Not Selected" to indicate if the grantee will be doing any work in those
program areas.
If there are supplemental activities or regional specific activities, they are considered
optional until selected or not selected. Those are found at the end of the worksheet.
11
-------
Work Plan Activity Description (Outputs) (Column K): The grantee will use this cell to
briefly and succinctly describe the Work Plan activity the grantee will be conducting that
corresponds to the grant guidance activity listed in Column I. Please be as specific as
possible, especially if the activity involves any metrics, locations, etc.
Due Date (Column L): This column auto-fills with the ending date of the budget period
selected from the Start worksheet. If the date is different, the grantee will need to enter
the correct date. Multiple dates may be entered if separated by a comma.
Status (Column M): When reporting results on the activities that you committed to
(according to the schedule you have arranged with your PO), select the current status for
the corresponding activity.
Options in the drop down menu:
- Complete
- Partially complete
-Not started
- Ongoing/ As Needed
Describe Work Plan Activity Accomplishments (Column N): Use this cell to briefly and
succinctly describe the activity accomplishment/status listed in Column K, as well as the
reasons for partially complete/not complete/ongoing/as needed responses in Column M,
particularly if projections are exceeded or not met, and the reason. Please be as specific
as possible, especially if the activity involves any significant issues or innovations,
metrics, locations, etc.
Significant Issues/Innovations (Column O): This column will be used as a means to flag
activities that the grantee feels are either nationally significant issues or activities that
used an innovative approach. There are four options in the drop down menu: "None"
"Innovative," "Significant Issue," or "Both". If anything other than "None" is selected,
please explain the innovation or significant issue, or both, in column N.
EPA Review of Status (Column P): This column is completed by the EPA project
officer/technical contact and indicates the Region's concurrence or disagreement with the
status reported by the grantee in Columns M and N.
EPA Comment (Column 0): This column is completed by the EPA project
officer/technical contact and provides space for any further details the Region wants to
add regarding a particular activity or item in Columns N or O. The PO/TC should
particularly provide explanation for any deficiencies in meeting negotiated work plan
activities or inspection projections.
EPA Recommendation (Column R): This column is completed by the EPA project
officer/technical contact and provides space for any recommendations the Region wants
to offer.
12
-------
Additional Columns: Additional columns can be added at the end of the table to add
additional information.
Hidden Columns: These columns are used for creating unique identifiers for the reports
function of the template.
Entity (Column A)
WPStart (Column B)
WPEnd (Column C)
Prog # (Column H): The grant guidance activity number.
D. Adding rows
Each guidance activity is initially only given one row in the template, but it is likely that
grantees will have several activities to carry out the guidance and will need additional
rows.
To add rows:
Select the row number where you want to add a new row (circled in red), right-click, and
select "Insert."
Ensure a minimum of one employee obtains and
maintains an EPA inspector's credential. Conduct FIFRA
inspections with EPA credentials, according to EPA
procedures and guidances
, q Refer all inspections conducted with federal credentials to Required
Ithe region.
Required
The new row will appear with some cells in orange or yellow. The colors are highlighting
that a cell is either empty or a duplicate.
01.02.07.0
Ensure a minimum of one employee obtains and
maintains an EPA inspector's credential. Conduct FIFRA
inspections with EPA credentials, according to EPA
procedures and guidances.
Required
To complete the data in those two cells, you will select the cell directly above the blank
cell and drag the data down using the small square icon in the bottom right-hand corner
of the cell.
I I in:
The new row will look like the surrounding cells, however the Activity Code will be
unique.
13
-------
01.02.07.0
Ensure a minimum of one employee obtains and
maintains an EPA inspector's credential. Conduct FIFRA
inspections with EPA credentials, according to EPA
procedures and quidances.
Required
01.02.07.1
Ensure a minimum of one employee obtains and
maintains an EPA inspector's credential. Conduct FIFRA
inspections with EPA credentials, according to EPA
procedures and quidances.
X. Using the Outcomes Worksheet
This chart includes all the program areas listed in the national FY15-17 cooperative agreement
guidance, and links them to the potential outcomes from work done in each program area, and to
the appropriate goal in EPA's Strategic Plan. The grantee should adjust the outcomes as
necessary to match work contained in the grantee's Work Plan. This chart, along with the Work
Plan, assists the grantee to comply with Grants Policy Issuance 11-03, which requires all Work
Plans and progress reports to prominently display work commitments, a timeframe to complete
the commitments and a link to EPA's strategic goal and objective.
XI. Using the 5700 Forms (Projections and Accomplishments)
Guidance for what data to enter into these forms can be found in Appendices 9-11 of the national
FY 15-17 FIFRA cooperative agreement guidance. See below for how these forms function in
the template.
The template includes three different 5700 forms:
5700 Main: This is the standard 5700-33H form to be filled out by the grantee to project
inspections and samples and report inspection and enforcement accomplishments.
5700 WPS: This is the form to report worker protection inspections, samples and enforcement
actions.
5700 CC: This is the form to report container/containment inspections, samples and enforcement
actions.
Each of the 5700 forms contains a cell in the upper right hand corner of the form for the grantee
to indicate whether the grantee is reporting "Work Plan Accomplishments" or "Total Program
Accomplishments". Just click in the cell for the drop down arrow to appear, then click on the
appropriate selection.
rton, DC 20460
Back
shment Summary Report
Work Plan Accomplishments
-------
Each of these three forms has a main summary form and 4 quarterly forms appended below the
summary. All of the quarterly forms for each 5700 area currently "expanded", leaving them
visible at the bottom of each summary form in sequential order. If you will not use all the
quarters or want to "collapse" them, you will first need to "unprotect" the worksheet. To do this,
go to Review>(Changes) and select Unprotect Sheet. To collapse (or expand) a particular
quarter, click on the minus (or plus) sign to the left of the quarterly forms.
Screen shot of 5700 Main with Ql visible:
Tlaste^JERA Cooperative Agreement Workplan-Report Template 3-5-14 - Microsoft Excel
l/iew Developer
C!n ^
Home Insert Page Layout Formulas Data I
ii U a&
J
J
j Research Thesaurus Translate
Proofing
: Previous Next
Comments
Show All Comment:
Share Send
Now by IM
Share
0
Ql
License/Certificate Revocation
0
0
0
0
0
0
0
0
0
0
0
0
License/Certificate Conditioning or Modification
0
0
0
0
0
0
0
0
0
0
0
0
Number of Warnings Issued
0
0
0
0
0
0
0
0
0
0
0
0
Stop-Sale, Seizure, Quarntine or Embargo
0
0
0
0
0
0
0
0
0
0
0
0
Cases Forwarded to EPA for Action
0
0
0
0
0
0
0
0
0
0
0
0
Other Enforcement Actions
0
0
0
0
0
0
0
0
0
0
0
0
Number of Cases Assessed Fines
0
0
0
0
0
0
0
0
0
0
0
0
—ctal Number cf Actions
0
0
0
0
0
0
0
0
0
0
0
0
% of Inspections Resultinc in Actions
Percent cf Total Actions
< Summary (Projections and Accomplishments for )
State/Tribe:
IN/A
Period:
Work Plan Accomplishments
Enforcement Accomplishments This
Reporting Year
Agricultural
Nonagricultural
Experimental
Use Permit
Producing
Establishm
ent
Market-
place
Imports
Exports
Certified
Applicator
Records
Restricted
Use Pesticide
Dealers
TOTAL
Use | For Cause
Use |For Cause
Pesticide E
nforcement Cooperative Agreement Output Summary
::e:
0
Federal Facilities
Physical
Samples Collected
Documentary
Civil Complaints Issued
Criminal Actions Referred
¦ ¦
License/Certificate Suspension
License7Certificate Revocation
- 1
Stop-Sale. Seizure, Quarantine or Embargo
¦l.ises F: ¦ arce: ¦; EP- 'a Action
¦¦ » :
Number of Cases Assessed Fines
< Q1 (No Inspections)
State/Tribe:
Reporting #N/A #N(A
Work Plan Accomplishments
When done, you may protect the sheet again to prevent accidental deletion of information. No
password is required to protect the sheet, just select OK. The data entry cells of worksheets
remain editable when a sheet is protected.
Any numbers entered in the quarterly report forms will automatically tabulate data in the main
form, regardless of the number of quarterly forms used.
15
-------
Screen shot of the 5700 Main summary form and Quarter 1:
United States Environmental Protection Agency Washington, DC 20460
Pesticides Enforcement Cooperative Agreement Projections & Accomplishment Summary Report
State/Tribe:
Reporting
Period:
Work Plan Accomplishments
Enforcement Projections &
Accomplishments
Agricultural
Nonagricultural
EUP
PEI
Market-
Imports
Exports
Certified
Applicator
Records
Restricted
Use Pesticide
Dealers
TOTAL
Use
For Cause
Use
For Cause
Projected:
Inspections
0
Samples
0
Accomplished: 0 0 0 0 i
Inspections: ( )
0
0
0
0
0
0
0
0
0
0
0
0
Federal Facilities
0
0
0
0
0
0
0
0
0
0
0
0
Physica
Samples = 0
Documentary
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
(Accomplished) - (Projected)
Inspections
0
0 | 0 I 0 I 0 | 0 j 0 | 0 I 0
0
0
0
0
Samples
0
iter data in the
0
0
0
Pesticide Enforcement Actions Taken
Ft
Civil Complaints Issued
0
A-jL
0
0
0
0
Criminal Actions Referred
0
0
0
0
0
Administrative Hearings Conducted
0
m
u) ecu on rows 01
III
0
0
0
0
License/Certificate Suspension
0
0
0
0
0
License/Certificate Revocation
0
til
e quarterly forms
0
0
0
0
License/Certificate Conditioning or Modification
0
III
a
0
0
0
Number of Warnings Issued
0
0
0
0
0
Stop-Sale. Seizure, Quarntine or Embargo
0
on v
0
0
0
0
Cases Forwarded to EPA for Action
0
0
0
0
0
Other Enforcement Actions
0
0
0
0
0
Number of Cases Assessed Fines
0
0
0
0
0
0
0
0
0
0
Total Number of Actions
0
M 0
0
0
0
0
0
0
0
0
0
0
% of Insoections Resuttino in ActioM^^^
< Summaryi^ijections and Accomplishofrents for )
State/Tribe: W
-------
Screen shot of the 5700 WPS summary form and Quarters 1 and 2:
Back
United States
Environmental Protection Agency
Washington, DC 20460
Pesticides Enforcement Cooperative Agreement Accomplishment Report (WPS)
State/Tribe: Year ^Period- Work Plan Accomplishments
Enforcement Accomplishments This
Reporting Year
WPS Tier I
Use For Cause
WPS Tier II
Use For Cause
Total
Inspections at
Facilities
Claiming
Violations During WPS Inspections violations
Total Inspections Conducted
0
0
0
0
0
0
Physical
Samples Collected
Documentary
0
0
0
0
0
1 Pesticide Safety Training
2 Central Posting
3 Notice of Application
4 Entry Restrictions
5 Personal Protective Equipment
6 Mix,/Loading, Application Equip & Applications
7 Decontamination
8 Emergency Assistance
9 Information Exchange
10 Retaliation
0
0
0
0
0
0
0
Civil Complaints Issued
0
0
0
0
0
0
Criminal Actions Referred
0
0
0
0
0
0
Administrative Hearings Conducted
0
0
0
0
0
0
License/Certificate Suspension
0
0
0
0
0
0
License/Certificate Revocation
0
0
0
0
0
0
License/Certificate Conditioning or
Modification
0
0
0
0
0
0
Number of Warnings Issued
0
0
0
0
0
0
Stop-Sale, Seizure, Quarantine or
Emabargo
0
0
0
0
0
0
Cases Forwarded to EPA for Action
0
0
0
0
0
Total Violations
0
Other Enforcement Actions
0
0
0
0
0
Number of Cases Assessed Fines
0
0
0
0
0
*This column is a subset of the WPS Tier 1 and WPS Tier II Columns combined to collect data on inspections conducted at facilities claiming the Immediate Family Exemption
< Summary
s^te/Tribe: Year ^Period* #N/A Work Plan Accomplishments
&porcement Accomplishments This
Reputing Year
WPS Tier I
Use For Cause
WPS Tier II
Use For Cause
Total
Inspections at
Facilities
Claiming
Violations During WPS Inspections violations
Total Insertions Conducted
0
, ^ 3k., Physical
Samples ColIeCTki
Documentary
0
1 Pesticide Safety Training
2 Central Posting
3 Notice of Application
0
Civil Complaints lssu£!^
_d_,
¦ ;¦
Enter data in the
quarterly forms only
Personal Protective Equipment
Mix/Loading, Application Equip & Applications
Decontamination
Emergency Assistance
Information Exchange
Retaliation
License Certificate Suspension
! ' V ¦¦ - . -.! * i 0
License Certificate Conditioning or
Number of Warnings Issued
Stop-Sale, Seizure, Quarantine or
Cases Forwarded to EPA for Action
Total Violations
0
Other Enforcement Actions
Number of ( sedF£iai00
-------
Screen shot of the 5700 CC summary form and Quarters 1 and 2:
United States
Environmental Protection Agency
Washington, DC 20460
Pesticides Enforcement Cooperative Agreement Accomplishment Report (Container/Containment)
Reporting
Period:
Work Plan Accomplishments
Enforcement Accomplishments This
Reporting Year
Total Inspections Conducted
Samples Collected
Physical
Documentary
Civil Complaints Issued
Criminal Actions Referred
Administrative Hearings Conducted
License/Certificate Suspension
License/Certificate Revocation
License/Certificate Conditioning or
Modification
Number of Warnings Issued
Stop-Sale, Seizure, Quarantine or
Emabargo
Cases Forwarded to EPA for Action
PEI
With
Containment
Non-PEI
Containment
Container/Containment Violations
Refillable Containers
1. Deficient labeling
(i.e. cleaning and disposal instructions)
2. Deficient container design (valves, openings)
3. Producing establishment registration
violations
4. No contract manufacturing agreement,
residue removal,instructions, list of acceptable
5. Deficient management procedures &
operation
6. Record keeping
Containment
7. Secondary containment & pads -
capacity/design
8. Secondary containment & pads - site
management
9. Secondary containment & pads - record
keeping
Total Violations
Other Enforcement Actions
Number of Cases Assessed Fines
< Summary
Reporting
Period:
Work Plan Accomplishments
Container/Containment Violations
Refillable Containers
1 Defiripntlnhelinp
Enter data in the
quarterly forms only
posal instructions)
r design (valves, openings)
hment registration
scturing agreement,
ructions, list of acceptable
nent procedures &
Luiiidihiiieni
7. Secondary containment & pads -
capacity/design
8. Secondary containment & pads - site
management
9. Secondary containment &. pads - record
keeping
Total Violations
Reporting
Period:
Enforcement Accomplishments This
Reporting Year
PEI
With
Containment
Non-PEI
Containment
Total
Total Inspections Conducted
_ „ Physical
Samples Collected
Documentary
Crvil Complaints Issued
Work Plan Accomplishments
Container/Containment Violations
Refillable Containers
1. Deficient labeling
(i.e. cleaning and disposal instructions)
2. Deficient container design (valves, openings)
3. Producing establishment registration
Ready
Start , Narrative Budget Work Plan Outcomes S7on cc M-.r.-w Qtefeua*
18
-------
Screen shot of 5700 CC summary form with Ql-4 collapsed:
Bask
United States
Environmental Protection Agency
Washington, DC 20460
Pesticides Enforcement Cooperative Agreement Accomplishment Report (Container/Containment)
State/T ribe: ADEC Yean
FFY17
Reporting
Period:
10/1/2016
9/30/2017
Work Plan Accomplishments
Enforcement Accomplishments This
Reporting Year
PEI
With
Containment
Non-PEI
Containment
Total
Container/Containment Violations
Total Inspections Conducted
0
0
Refillable Containers
Physical
Samples Collected
Documentary
0
0
1. Deficient labeling
[i.e. cleaning and disposal instructions)
0
0
2. Deficient container design (valves, openings)
Civil Complaints issued
0
0
3. Producing establishment registration
violations
Criminal Actions Referred
0
0
4. No contract manufacturing agreement,
residue removal,instructions, list of acceptable
Administrative Hearings Conducted
0
0
5. Deficient management procedures &
operation
License/Certificate Suspension
0
0
6. Record keeping
License/Certificate Revocation
0
0
Containment
License/Certificate Conditioning or
Modification
0
0
7. Secondary containment & pads -
capacity/design
Number of Warnings Issued
0
0
8. Secondary containment & pads - site
management
Stop-Sale, Seizure, Quarantine or
Emabargo
0
0
9. Secondary containment & pads - record
keeping
Cases Forwarded to EPA for Action
0
0
Total Violations
Other Enforcement Actions
0
0
!romD?WPl*|£sAssessed Fines
0
0
< Summary
< Q1 \
-------
Example of what a 5700 Main Projections Form might look like as part of the work plan:
United States Environmental Protection Agency Washington, DC 20460
Pesticides Enforcement Cooperative Agreement Projections & Accomplishment Summary Report
State/Tribe:
VDACS
FFY 16
Reporting 10/1/2015 9/30/2016
Period:
Work Plan Accomplishments
(PTE)
1.35
Enforcement Projections &
Accomplishments
Agricultural
Nonagricultural
EUP
PEI
Market-
place
Imports
Exports
Certified
Applicator
Records
Restricted
Use Pesticide
Dealers
TOTAL
Use
For Cause
Use
For Cause
Projected:
(Hrs) 400 400 300 400 300 300 100 200 200 100 100 2800
Inspections
20
20
20
20
20
20
20
20
20
20
20
220
Samples
5
5
5
5
5
5
5
5
5
5
5
55
Accomplished:
00 0 00000 0 0
Inspections: ( )
0
0
0
0
0
0
0
0
0
0
0
0
Federal Facilities
0
0
0
0
0
0
0
0
0
0
0
0
Samples = 0
Physical
Documentary
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
(Accomplished) - (Projected)
Inspections
(20)
(20)
(20)
(20)
(20)
(20)
(20)
(20)
(20)
(20)
(20)
(220)
(55)
Samples
(5}
(5)
(5)
(5)
(5)
(5)
(5)
(5)
(5)
(5)
(5)
Pesticide Enforcement Actions Taken
Civil Complaints Issued
0
0
0
0
0
0
0
0
0
0
0
0
Criminal Actions Referred
0
0
0
0
0
0
0
0
0
0
0
0
Administrative Hearings Conducted
0
0
0
0
0
0
0
0
0
0
0
0
License/Certificate Suspension
0
0
0
0
0
0
0
0
0
0
0
0
License/Certificate Revocation
0
0
0
0
0
0
0
0
0
0
0
0
License/Certificate Conditioning or Modification
0
0
0
0
0
0
0
0
0
0
0
0
Number of Warnings Issued
0
0
0
0
0
0
0
0
0
0
0
0
Stop-Sale, Seizure, Quarntine or Embargo
0
0
0
0
0
0
0
0
0
0
0
0
Cases Forwarded to EPA for Action
0
0
0
0
0
0
0
0
0
0
0
0
Other Enforcement Actions
0
0
0
0
0
0
0
0
0
0
0
0
Number of Cases Assessed Fines
0
0
0
0
0
0
0
0
0
0
0
0
Total Number of Actions
0
0
0
0
0
0
0
0
0
0
0
0
% of Inspections Resultina in Actions
Start Narrative Budget Work Plan . Outcomes 5700 Main " Status Proo Area Sia Act Type Rec )
Ready i**il
The two rows immediately above the enforcement action rows will tabulate the difference
between projected inspections and samples, and accomplished projection and samples. If the
accomplished number is higher than projected, the difference shows up in black font. If the
accomplished number is lower than projected, the difference shows up in red font. See example
below:
VDACS
FFY 16
Reporting W1/2015 9(30(2016
Period:
Work Plan Accomplishments
Enforcement Projections &
Accomplishments
Agricultural
Nonagricultural
Imports
Exports
Certified
Applicator
Records
Restricted
Use Pesticide
Dealers
Projected:
Inspections
Samples
Accomplished:
Inspections: ( )
Federal Facilities
Samples = 45
20
-------
Grantees should report inspection and enforcement accomplishment numbers following an
agreed upon schedule between the grantee and the region, but at a minimum, reporting is
required annually.
• Quarterly accomplishments are entered into each of the four quarterly forms appended at
the bottom left of each main page.
• Midyear accomplishments are reported in each of the second quarter (Q2) 5700 forms.
• Annual accomplishments are reported in each of the fourth quarter (Q4) 5700 forms.
XII. Using the Endangered Species Inspections Report
The ES (Endangered Species Inspections Report) tab: This is the form used to collect
information during use or misuse inspections on whether applicators are following ES Bulletins.
This information is required for all grantees whether or not Endangered Species is selected from
the pick-list. For inspections where the applicator is alleged to be in violation of ES labeling
requirements or the Bulletin, please provide the name of the pesticide product involved and the
provision of the ES Bulletin or label violated in the comment field of the form. This information
will help OPP assess the effectiveness of endangered species risk mitigation requirements and
Endangered Species bulletins.
XIII. Using the Performance Measure tn
This is the form to report the new enforcement performance measures. Reporting in the form
will be mandatory once the template receives an ICR number from the Office of Management
and Budget.
XIV. Using the Template for Multi-Year Agreements
The template functions as a Work Plan and Reports for a one year period. For multi-year
agreements you will need to prepare and save the entire workbook for each fiscal year in the
project period. At the beginning of a multi-year agreement, the grantee may prepare the work
plan for the first year, save that file as a Work Plan by indicating it as a Work Plan in box 7 on
the START page and saving it according to the naming convention below. The grantee can then
use that file as the starting point for preparing the subsequent work plans for the remaining years.
For example, a grantee with a 3 year agreement will submit 3 Work Plans, one for each year of
the agreement, to the regional office.
Once the grantee begins reporting accomplishments on work plan activities for the first year
project period, that file is then saved as a report by indicating it as a report in box 7 on the
START page and saving it according to the naming convention below. Reports are submitted to
the regional office according to an agreed upon schedule between the grantee and the region.
This pattern repeats itself for all years in the project period.
21
-------
XV. File Naming Convention
Use of a consistent naming convention will assist with national data compilation. Please follow
the suggested file naming conventions below.
For Work Plans:
For States
Fiscal year-Two letter state abbreviation-workplan-draft/final-current date
Example: FY13-AL-workplan-draft-020614
For Tribes
Fiscal year-Tribal name abbreviation-workplan-draft/final-current date
Exampl e: FY 13 - AC IC -workpl an-final -03 0414
For Reports:
For States
Fiscal year-Two letter state abbreviation-report-midyear/yearend-current date
Example: FY13-VT-report-yearend-l 10514
For Tribes
Fiscal year-Tribal name abbreviation-report-midyear/yearend-current date
Example: FY13-CRST-report-midyear-043014
For Regional Year End Reports:
Fiscal year-Grantee Abbreviation-EPAreport-yearend-current date
Example: FY 13-NYSDEC-EPAreport-yearend-021614
XVI. Printing
Should the need arise to print the individual worksheets, here are some tips:
The easiest method for printing the START
page is to click on the drop down arrow in the
top left hand corner of the START page, right
under the menu ribbon. Then click on
"Print Start", go to File>Print, and under
"Settings" choose "Print Selection" and
"Print". This will print the START page in its
entirety on one 8V2" x 11" landscape page.
A. For the START page:
a *5- <*- -
PAGE LAYOUT
"IV*
ID B
_# 'n I
Themes jll! Margins Orientation Size Print Breaks Back
T Effects- . . . Area. .
f*
Print_Area
Print Measure I
Print Start
NOT YET APPRO
Start
tbIMeasures
Recipients
WorkPlan
Outcomes
Exp5700Main
Table6
operative Agreement Work F
Department of Agriculture and
entry in white boxes only. Asterik denott
rantee Information: Coop<
1) *Agreen
22
-------
B. For the Work Plan worksheet:
m b *5- <*- --
HOME INSERT PAGE LAYOUT FORM
ga *Cut
' ii| Copy -
Paste
T -<5* Format Painter
r.
Arial
T .10 -
A
B I U » | |ti » <5*-^
Font
E
) IE fi
Build or mainl
G
Print_Measur€
Print_Start
F
Print_Titles
Start
tbIMeasures
Recipients
I WorkPlan I
Area
NPM
Activity#
le
OPP &
OECA
01.00.01.0
Comf
reporl
aqree
Outcomes
Exp57O0Main
Tables
ie
OPP &
OECA
01.00.02.0
Build
pesti(
trainir
trainir
Basic Pesticide
OPP &
Reso
The Work Plan worksheets within the
template have been formatted to fit on an
8 W' x 11" landscape sheet of paper. Columns
E through O will print on one page, with
columns P through R on separate pages.
The easiest method for printing the Work
Plan page is to click on the drop down arrow
in the top left hand corner of the Work Plan
page, right under the menu ribbon. Then
click on "WorkPlan", go to File>Print. This
will give you a preview of what will print.
You can scroll through the pages and make
any adjustments prior to printing. The Work
Plan worksheet is formatted so that the
column headings will print at the top of each
printed page.
If you want to make changes to which columns will print, you will need to change that using the
"Page Setup" option in the menu bar in the Work Plan worksheet.
I 0 *)• c1
I HOME
[a| Ec°'°re~
^ "" ^ 1X1 Fonts -
Themes
\Oj Effects -
Themes
K4 H :
Program Area
PAGE LAYOUT
[Q ID B
M
Margins Orientation Size Print Breaks Background Print
~ ~ » Area' ~
Page Setup
/*
o
Q Width:
I D Height
ffl Scale:
TABLE TOOLS FIFRA Cooperative Agres
»S DESIGN
Gridlines Headings
~ View 0 View
Bring Send
I—I ^r,nt ® Pr'n* Forward * Backward *
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
OPP &
OECA
OPP &
OECA
OPP &
OECA
OPP
OECA
Activity ft
01.00.01.0
01.00.03.0
01.01.01.0
01.01.02.0
01.02.01.0
Page Setup
_Pag;
e | Margins J Header/Fool
Print area:
Print titles
Rows to repeat at top: | Sl:3
Columns to repeat at left:
Print
O Gridlines
[F~] Black and white
|rl Draft quality
[V] Row and column headings
Page order
<§) Down, then over
0 Over, then down
Comments: (None)
Cell errors as: displayed
m n? no n [Maintain adequate pesticide laws, rules, and associated [Required
PTE
I
zs
yDes
Click on the down arrow under "Page Setup". Click on "Sheet" and then "Print Area". Highlight
the columns you want to print. You can click on "Print Preview" from this box. Make sure you
select "Print Active Sheet" under "Settings" for your selection to print.
23
-------
You can adjust the Page, Margins, Header/Footer in this box as well.
a *3- c*
B id B
Irientatio
# v-
Area
Page Setup
REVIEW VIEW ESRI MAPS DESIGN
^ Width:
^ 10 Height
Print
Titles SScale
Scale t
Automatic '
Automatic "
55% :
0 Fit ^
Gridlines Headings
i View View
~ Print lid Print
Sheet Options r;
TABLE TOOLS FIFRA Cooperative Agreement
m ~"
Bring Send Selec
Program Area
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
Basic Pesticide
Program
F
NPM
OPP &
OECA
OPP &
OECA
OPP &
OECA
OPP
OECA
Activity it
01.00.01.0
01.00.02.0
01.00.03.0
01.01.01.0
01.01.02.0
01.02.01.0
Scaling
Adjust to: 55 f#j| % normal size
0 Fit to: |l fcj page(s) wide by |l tall
Paper size:
Letter (8.5'xllT
Print Quality:
600 dpi
First page number: Auto
[ Print... ] [ Print Preview ] [ Options..,
Basic Pesticide
8 | Program
OECA
01.02.02.0
Maintain adequate pesticide laws, rules, and associated
implementation procedures.
Required
C. For the Performance Measures worksheet:
PAGE LAYOUT
[q ID IS
#
m
Margins Orientation Size Print Breaks Background
* Area * *
^GActivitigfir
PrintArea
| Print_Measur€|
PrintStart
United States Environmenta
Start
PESTICIDE ENFORCEMENT PE
tblMeasures
March 2015
Recipients
/Tribe:
WorkPlan
Outcomes
Year:
Exp5700Main
rting Period:
Table6
STRATEGIC GOAL 1: PROTECTION OF HUMAN HEALTH - OCCUPA"
The easiest method for printing
the Performance Measures page
is to click on the drop down
arrow in the top left hand corner
of the Perf Meas page, right
under the menu ribbon. Then
click on "Print Measures", go to
File>Print and "Print". This will
print the START page in its
entirety on 8V2" x 11" portait
oriented pages.
24
-------
For additional printing resources in Excel, look for the '¦* icon in the upper right corner of the
screen. You can type Print in the prompt box after clicking on the question mark and several
informative links will provide detailed printing information.
XVII, Creating Your Own Reports
Helpful Information:
It is recommended that you print a Report (using the pivot table function) with the
information needed. Then, from the report, go to View/Workbook Views and select a
view to configure your report. The options that are provided are "page layout" and "page
break preview".
A report will be generated once data is filled into the Work Plan.
To create an individualized report, see: http://office.microsoft.com/en-us/excel-help/create-or-
delete-a-pivottable-or-pivotchart-report-HPO 103423 75. aspx? CTT=5&ori gin=HPO 10342752
XVIII. Frequently Asked Questions
1) I have discovered an error in or issue with the template. Whom do I contact?
For technical questions about Excel, you can call/email either Allen Demorest of EPA Region 9
(demorest.allen@epa.gov. 415-947-4214).
For policy/process questions that impact more broadly than just a single grantee/project officer
relationship, you can call/email Dea Zimmerman of OPP (zimmerman.dea@epa.gov. 312-353-
6344).
2) Something is really missing from this instructions document. Whom do I contact?
See answer to question 2 above.
3) I am confused by some of the language/abbreviations/acronyms used in the template. Where
can I go for more information?
Check out the Glossary in this document, and if we missed something, let us know so we can add
it.
4) What do I do with the template once it is completed? Is it automatically submitted to
EPA? Who do I submit it to?
You should follow whatever established cooperative agreement application and reporting
procedures you already have in place. If you are unsure of a process, contact your project
officer/technical contact.
25
-------
5) How do I submit amendments to my Work Plan? What if my Work Plan changes after it is
approved? Do I make revisions or does the Region?
You should follow whatever established procedures you already have in place for amending your
Work Plan. Discuss the process with your project officer/technical contact. Any amendments to
the grantee's Work Plan must be made by grantees and then approved by the Region. Make
sure you note any amendments in the Work Plan/ Report Status field (box 7) located on the right
hand side of the top panel on the Start worksheet.
6) Can I attach other documents to the template? How and where do I attach the documents? Is
there a specific format or program attached documents have to be in?
You can paste the content of your narrative document into the "Narrative" worksheet using two
different methods. 1) To cut and paste narrative: Open the Narrative worksheet and double click
on the box labeled "Microsoft Word Document" to open up Word, and then paste the narrative in
that Word document, and close the document when you are done. 2) You can embed a document
into the Narrative worksheet. Go to Insert> Text>Object>. You can create a new document and
make changes there OR you can select an existing file (Word, PPT, PDF, etc.) and embed that
into the Narrative worksheet.
For those forms and documents not included within the template, you should submit them with
the template following your established procedures.
7) Will I need to submit the template with the other grant forms (SF424, SF 424A,B, SF LLL,
etc.) for a new agreement?
Yes, you will need to submit the template as part of your application package. You should
follow whatever established procedures you already have in place. The template incorporates
your Work Plan and progress reports and does not replace the need for required grant forms.
8) Where do I obtain the 424 and other grant forms?
See the Office of Grants and Debarment website for grant forms:
http://www.epa.gov/ogd/forms/forms.htm.
9) Do I have to separately send in the 5700 and other reporting forms?
No, all the required 5700 forms are included in the template and do not need to be submitted
separately.
10) Which 5700-33H worksheet should the grantees use to report the mid-year and year-end
numbers?
Grantees should report mid-year numbers using the Q2 5700 worksheet, and report year-end
numbers using the Q4 5700 worksheet. If a grantee reports inspection and enforcement action
numbers in all four quarters, they will use all four quarterly 5700 worksheets, Q1-Q4.
26
-------
11) What if I completed additional activities not listed in the template but I want to include them
in my EOY?
If these additional activities used discretionary funds, they can be included in the
Supplemental/Special Project activity row at the end of the Work Plan worksheet. If these
additional activities fit within one of the program areas, use the "Add a Row" function under the
appropriate program area in the Work Plan worksheet to describe the activity. If the activity fits
neither of these parameters, describe the work in the Narrative worksheet.
12) I cannot get Excel to do what I need it to do. Help?
You can refer to this website for help: Microsoft Excel Help and How-to
&!
Another resource is the Help function in Excel. Look for the icon in the upper right corner
of the screen. You can type questions in the prompt box after clicking on the question mark.
13) The template print is too small/large to be useable. How to I make the template larger?
Select the Zoom button in the bottom right of your screen. It should look something like the
following; either click the percentage or use the scrolling bar to enlarge or shrink your screen's
zoom level. ¦'
14) I am trying to print my Work Plan as a report. How do I do that?
From the report (either standard or created), go to View/Workbook Views and select a view to
configure your page as you like.
XIX. Abbreviations and Glossary
CA - Cooperative Agreement
Consolidated - A cooperative agreement having two or more different programs in one
agreement (e.g. enforcement, C&T, program implementation)
CPARD - Certification Plan and Reporting Database
FIFRA - Federal Insecticide Fungicide and Rodenticide Act
ICR - Information Collection Request
NPM - National Program Manager (For example, OPP or OECA)
OECA - Office of Enforcement and Compliance Assurance
OMB - Office of Management and Budget
OPP - Office of Pesticide Programs
PO/TC - Project Officer/Technical Contact
PPG - Performance Partnership Grant
POINTS - Pesticides of Interest Tracking System
27
------- |