Attachment_F_Pesticide_Use_Report_Form.xlsx
XLSX spreadsheet 57 KB Posted
- Attached to
- Landscaping and Grounds Maintenance Services
- Solicitation number
- 2026-RFP-00070
- Issued by
- San Mateo County, California
About this file
The document is an Excel-based Pesticide Use Report Form developed by the San Mateo County Watershed Pollution Prevention Program (SMCWPPP), serving as a comprehensive tracking and reporting tool for pesticide applications. The spreadsheet contains multiple tabs for tracking pesticide product applications, maintaining a product list, generating summaries, and managing lookup lists for applicators, locations, and targeted pests. The form is designed to support detailed record-keeping of pesticide usage, with specific guidance for populating tabs including product registration numbers, active ingredients, application details, and tracking of Municipal Regional Permit (MRP) pesticides of concern. The spreadsheet has been regularly updated, with the most recent modification on 8/6/24, and provides step-by-step instructions for proper data entry and reporting.
The document is closely aligned with the related landscaping and grounds maintenance contract opportunity for San Mateo County, which emphasizes sustainable pest management practices. The form supports the county's Integrated Pest Management policy by enabling precise tracking of pesticide applications, including identification of active ingredients and application locations. It serves as a critical tool for contractors to document and report pesticide usage, ensuring compliance with environmental regulations and supporting the county's commitment to reduced pesticide usage. The spreadsheet includes features to automatically calculate total product usage, track MRP pesticides of concern, and provide a standardized approach to pesticide application reporting across different municipal applications.
View the file
Other files
Show all 25
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Metadata
| SMCWPPP Pesticide Product Application Tracking Sheet | |
| Tab | Description |
| Tracking | Data entry sheet for pesticide applicators |
| ProductList | List of all pesticide products currently applied by City staff and contractors |
| Subset of the DPR list copied and pasted by City Staff | |
| Automatically calculates the total amount of product used from the Tracking tab | |
| Summary | Summary table for Annual Reporting - Total amount of each pesticide (active ingredient) used by units |
| The MRP pesticides of concern are listed. Add additional active ingredients to the list as needed. | |
| LookupLists | Add agency specific values to the drop down lists for applicator, location, targeted pests and IPM tactics. |
| These drop down lists appear on the Tracking tab. | |
| DPR_LookupList | Complete list of active products registered with DPR or that expired less than 2 years ago |
| DO NOT resort the table. Sorting may change variables on other sheets | |
| The DPR product database is available at | |
| http://www.cdpr.ca.gov/docs/label/m4.htm | |
| ***While there is no SMCWPPP list of approved pesticides, staff/contractors may use this list to determine which products to avoid (i.e., those with pesticides of concern). Column H indicates whether a product is mentioned as a pesticide of concern within the Municipal Regional Permit. To find a product, press Ctrl+F and type the product name. | |
| DuplicateNames | List of product names associated with more than one EPA registration number |
| Notes | |
| Column headings in gray on the Tracking, ProductList, and Summary tabs indicate these fields will be autopopulated and contain formulas |
| Step 1 |
| From the DPR_LookupList, find the name(s) of the products that are used in your municipality by staff or contractors. |
| Confirm each product's EPA registration number in the table with the number on the product's packaging |
| Check for duplicate product names on the DuplicateNames sheet |
| Copy each Product Name and EPA Registration Number (from Columns A and B of the DPR_LookupList) |
| Paste each Product Name and EPA Registration Number into Columns A and B of the ProductList |
| Up to three active ingredients will autopopulate the table. |
| If a product contains an MRP tracked pesticide, it will appear as the first active ingredient |
| Active ingredients that are not tracked by the MRP are ordered by their percentage (largest % first) |
| ***Note - alternatively, users can copy their ProductList from the previous FY's workbook into this sheet and then add new products |
| Step 2 |
| Add applicable values to the LookupLists sheet. |
| Lists are for City Staff/Contractor (applicator) name, Application Location, Targeted Pest(s), and IPM tactics utilized |
| Step 3 |
| Fill in applicable fields on the Tracking sheet |
| The EPA registration number will autopopulate and does not need to be completed |
| Several fields are pull-down lists ensure consistency: |
| The Name of Product Applied is a pull-down list from the ProductList tab |
| The Applicator, Application Location, Targeted Pest(s), and IPM tactics are pull-down lists from the LookupLists tab |
| The amount of product used may be entered as fluid ounces, ounces, gallons, milligrams, or pounds |
| If packets are used, multiply the weight/volume on the package by the number of packages used |
| If the applicator diluted the product for application, only enter the amount of product used, not the diluted amount |
| Step 4 |
| The ProductList sheet will automatically calculate the total amount of each product used |
| The Summary sheet will automatically calculate the total amount of each pesticide used for the listed MRP pesticides of concern |
| To track active ingredients that are not MRP pesticides of concern |
| Copy the names of the active ingredients from the ProductList tab |
| Paste the names on the Summary sheet in the Active Ingredients column |
| Last Updated | |
| 7/3/17 | Updated DPR_LookupList & DuplicateNames |
| 7/26/17 | Fixed ProductList Formulas |
| 7/9/18 | Removed Dilution Tab; Updated DPR_LookupList & DuplicateNames to include new products (as of 7/1/18) and removed those that expired before 7/1/16 |
| 8/14/18 | Added Pentra-Bark |
| 7/16/19 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/17 |
| 7/2/20 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/18 |
| 8/5/20 | Fixed ProductList Formulas & references to DPR_LookupList |
| 7/7/21 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/19. |
Changed "MRP tracked pesticide category" to "Pesticide of Concern"
| 6/2/22 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/20. Added the three neonicotinoids referenced in MRP to the list of pollutants of concern on Summary tab. |
| 6/26/23 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/21. |
| 6/5/24 | Updated DPR_LookupList & DuplicateNames to include new products and removed those that expired before 7/1/22. |
8/6/24 Corrected error which resulted in missing products from DPR_LookupList http://www.cdpr.ca.gov/docs/label/m4.htm Tracking
| City of | |
| Pesticide Products Tracking Sheet | *Only report the amount of product actually used NOT the amount of diluted product* |
| Date of Application | Applicator | Location of | Area (Acres or units) | Name of Product Applied | EPA Registration # | Total Product Used | Target | IPM | Comments | ||||
| (City Staff/Contractor) | Application | Treated | fl oz | oz | gal | mg | lbs | Pest(s) | Strategies |
to add more rows, copy the row above and insert above this row
ProductList
| County of San Mateo |
| Landscaping Contractor |
| List of Pesticide Products |
| Total Product Used | Active Ingredient 1 | Active Ingredient 2 | Active Ingredient 3 | ||||||||||||||||||||||||
| Product Name | EPA Registration # | fl oz | oz | gal | mg | lbs | Name | % | fl oz | oz | gal | mg | lbs | Name | % | fl oz | oz | gal | mg | lbs | Name | % | fl oz | oz | gal | mg | lbs |
to add more rows, copy the row above and insert above this row
File details come from the government source that posted it. Updated .