This index page is arranged in sections: Permanent and Transitory items.
- Permanent Items
- Pesticide Statistics, Trends, Miscellaneous
- Access: Visual Tutorials
[Finding Pending Registrations Applications]
Look for the 
and 
flags to find recent updates or additions.
Pesticides Regulatory Authorities
Australia.
Canada. (Product search page.)
United Kingdom. {Also has simplest place to find European Union links.}
United States of America.
U.S. Federal and State Pesticide Product Registrations. NPIRS at Purdue University offers free-of-charge searches. Links tab leads to useful sites for more information.
Compendium of Pesticide Common Names
The definitive source for names, structures, use types, and more. Courtesy of Alan Wood.
U.S. Pesticide Product Labels
Greenbook. Industry sponsored searchable site. Also has news about the industry.
US-EPA. Environmental Protection Agrncy's searchable site.
Pesticide Registration/Regulatory Affairs
Consultants
Information, supplied by the principals, about
individuals and companies conducting registration and regulatory affairs
consulting services on a contract basis.
Pesticide Formulation Devlopment Labs &
Consultants
Information about individuals and facilities
offering their services for development and/or evaluation of pesticide
product formulations (added: Focus Formulation and Consulting).
Pesticide Process Chemistry/Engineering.
Consultants
Need help with pesticide AI production, or related?
Here are consultants I've found. Know of others(?), send them my way for a
free listing.
Pesticide Chemical Usage and Crop Statistics
Links to federal and state sites containing reports about
amounts of pesticides used in the United States, and about other crop
statistics.
Pesticide Contract Formulators/Packagers On The
WWW
Companies I've found with Internet sites.
Resistance Action Committees
RACs do more than track
developing resistance to insecticides, herbicides, and fungicides. One of
their services is classification of pesticidal actives by chemical type and
mode of action. {In the event you're worried: RACs are sponsored and
promoted by major pesticide registrants.}
PPLS. New and Amended Labels: 17 May 2012
Using PPLS Report of 17 May 2012.
HTML file ppls1209.htm has for first and amended labels: Registrant, EPA Reg. No. (as link to PPLS), Product Name,
Active Ingredients.
1st Labels. [1] in the list indicates first posting of an image for the EPA Reg. No., according to my PPLS database
(76562 EPA Reg. No.)...(May 17)
New (Sub)Registration Approvals: 14 May 2012
Using PPIS files of 14 May 2012.
Original Registrations. Excel file appr1209.xls has: AIs and Pcts, Registrant, Product Name, EPA Reg. No.
Transferred Registrations. Excel file xfer1209.xls
SubRegistrations. Excel file sub1209.xls has: AIs and Pct, To Whom, From Whom, Product Name, EPA Reg. No...
(May 17)
PPLS: Labels for Products Registered in Y2012
Using PPLS Report of 26 April 2012.
HTML file ppls2012.htm has for products first registered in Y2012: Registrant, EPA Reg. No. (as link to PPLS), Product Name,
Active Ingredients...(April 26)
PPLS. New and Amended Labels: 26 April 2012
Using PPLS Report of 26 April 2012.
HTML file ppls1208.htm has for first and amended labels: Registrant, EPA Reg. No. (as link to PPLS), Product Name,
Active Ingredients.
1st Labels. [1] in the list indicates first posting of an image for the EPA Reg. No., according to my PPLS database
(76562 EPA Reg. No.)...(April 26)
Y2012 Registration Approvals: Summary
Using PPIS files of 23 April 2012.
Excel file y12_coai.xls has for registration approvals to date: Registrant, All AIs and Percentage,
EPA Reg. No.
Excel file y12_aico.xls has: All AIs and Percentage, Registrant, EPA Reg. No...(April 25)
New (Sub)Registration Approvals: 23 April 2012
Using PPIS files of 23 April 2012.
Original Registrations. Excel file appr1208.xls has: AIs and Pcts, Registrant, Product Name, EPA Reg. No.
Transferred Registrations. Excel file xfer1208.xls
SubRegistrations. Excel file sub_1208.xls has: AIs and Pct, To Whom, From Whom, Product Name, EPA Reg. No...
(April 25)
(Neo)Nicotinoids: 615 U.S. Registrations
Excel file nicotins.xls has: All AIs and Percentage, Registration, EPA Reg. No., Year of 1st Approval.
AIs: clothianidin, dinotefuran, imidacloprid, thiamethoxam, acetamiprid, thiacloprid. (My thanks to Alan Wood for his invaluable web site, wherein
tis easy to find AIs by Classification. Well, EPA is also a major thanker for Alan's work!)...(April 16)
PDSL Summary Index
Using the Pesticide Data Submitter List output.txt file of 4 April 2012.
Excel file pdsdlname.xls has: PC Code, PDSL Name, Other Name (mine), Submitter Name and Company Number.
Excel file pdsltask.xls is an extract of the above file where the Submitter Name is like Task Force or
Joint Venture or JV...(April 16)
Access (All Versions): Visual Tutorials
Finding Pending Registration Applications. Let NPIRS-PDMS Do The Initial Drudge Work
The Idea. NPIRS-PDMS has a clicky-clicky method to find EPA Reg. No. for Pending Registration Applications. Rather than clicking to Run many Access Queries
(I suspect this can be frightening to those not conversant with Access) to find, let the NPIRS database do that initial work.
The Trade-Off. In return for having NPIRS do the drudge work you (your company) will pay NPIRS for you (your company) to find out "What is in the Registration
Applications?". Cost effectiveness? You (your company) must decide. Since I know of no one offering the finding service you're stuck.
NPIRS-PDMS: Date Range Searching Application Submissions. NPIRS-PDMS is not, can't possibly be, "up to the minute" for Submissions. Today's submission (for anything)
might appear in PDMS with a Received-by-EPA date 2 weeks or 2 months ago. Safety Factor. Searches ought, in my experience, cover old ground (dates already searched).
You'll have to decide on a comfort factor: What is my Company willing to miss. My Safety Factor is 4 months prior to the date of the NPIRS-PDMS current post. Example:
Retrive Pending EPA Reg. No. in the 1 August 2011 NPIRS-PDMS posting, searching for Submissions from 1 April to 1 August. Wait until 1 September posting, or nearest,
then search for 1 May to 1 September submissions with a Pending EPA Reg. No.
Compare EPA Reg. No. from the 2 Date Range searches to find NEW in the 1 September posting.
Step 1. NPIRS-PDMS. Finding EPA Reg. No. For Pending Registrations
NPIRS-PDMS search page:
1. Option #14: Submission Dates. Choose your beginning and final dates. Then after NPIRS returns "Found this many".
2. Option P (Pending Registrations will be highlighted). NPIRS has returned How Many of the Submittal Documents contain a Pending EPA Reg. No.
Clicking on Option P brings up a list: Number of Citations and the Pending EPA Reg. No. {Note: The number of Pending citations will be MUCH FEWER than all the citations.}
Save The Pending EPA Reg. No. List. Your browser (right mouse click): Save Page As/Save As. Choose to save to your hard drive as HTM/HTML format.
Next section,WHY save as HTML/HTM? NPIRS format of the list will only be easy to use in HTM/HTML format (until of course NPIRS changes the format!).
{NOTE: If your search returns more than 5000 citations the Option P WILL NOT be available due to an NPIRS retriction. Narrow your range of Submission Dates.}
Word and Access. Finding Newest Pending EPA Reg. No.
Why Save NPIRS-PDMS List As HTM/HTML? Simple, good reason:
i. The NPIRS-PDMS list saved in Text (*.txt format) and Opened in Word. snag_01.pdf. Ugly, inscrutable? Mostly.
ii. The NPIRS-PDMS list saved in HTM/HTML (*.htm) format), and Opened in Word. snag_02.pdf. Isn't that neater?
iii. Why The HTM/HTML File Format. Only, I expect, for those interested in details. Your browser. View Page Source, or as I do, your HTML editor.
snag_03.pdf. Yah-de-yah. See the line above Date Search. Last is "pre" between angle brackets. An Instruction to your browser: "Show the following
Exactly as written". Way down at the bottom is "/pre", telling your browser to move on. ANYWAY, you need not be concerned with
details of this Interlude, other than to know: SAVE AS HTM/HTML. {snag... is shorthand for screen capture using the SNAGIT program.}
Formatting NPIRS-PDMS Pending HTM/HTML File With Word (trivial!!)
Open the HTM/HTML file. I've clicked on Word's paragraph symbol, just because.
Delete Before The List Begins. Just the usual highlighting/blocking to select What-to-Delete.
Deleted. Need A Push. Line 1 beginning spaces are gone. Hit the Space Bar to realign.
Realigned.
Block End-of-File. Then do a Delete. Left is only the list of Citations and Pending EPA Reg No.
Save As Text (*.txt). Access importing (and Excel should you wish) uses, in my examples, a Text file (lowest common denominator
understood by all computer programs).
Access Database. RTU Example and Infinitely Reusable
Zip files: pend2002.zip, extracts to the Access 2002 database pendtemp.mdb. pend2007.zip extracts to the Access
2007 database pend2007.accdb.
Later Access versions. Open pend2002 or pend2007 with your version. After looking/trying out Save As your Access version.
Importing a New Pending Set. You will Append your new set to the Pending_New Dump table. If you're not familiar with Importing/Appending ask me How-To.
For my ready-to-use example I've done the Importing. Database has an Import Specification (Spec) for the Fixed-width text file. Hardly needed as there are only
2 fields in the NPIRS-PDMS file.
Ready-to-Use Example. When NPIRS updated PDMS on 1 August 2011 I asked for Pending EPA Reg. No. with submissions from 1 April 2011 to 1 August 2011. When NPIRS
updated PDMS on 15 August 2011 I asked for Pending EPA Reg. No. with submissions from 1 April 2011 to 15 August 2011. I kept the 1 April start date only for simplicity.
Choose your range. Note that if the All Citations returned are more than 5000 NPIRS will not let you ask for Pending.
In the Example and Infinitely Reusable Database. Below are screen shots. In brief: (i) Table of Known Pending EPA Reg. No. (here these are from my 1 August
dump). (ii) Table of New Dump EPA Reg. No. Here they're from my 15 August search. (iii) 3 Queries, ready-to-use. 1st finds Newest Pending EPA Reg. No. 2nd and 3rd are
to clean up the database so its ready for your next New Dump.
Finding New Pending EPA Reg. No.
pend_008.pdf is the database screen showing Tables.
pend_009.pdf shows the entries in the Known EPA Reg. No. table. I.e., these which have been found in a previous search. Used for
eliminating old, previously found, EPA Reg. No.
pend_010.pdf shows the entries in the New Dump EPA Reg. No. table. Notice that Known and New look the same. 2 fields: Citation Count and
EPA Reg. No. Nothing tricky.
pend_011.pdf shows the 3 Queries you'll be using.
pend_012.pdf shows what happens when you Run the 1st Query. Access has found Newest Pending EPA Reg. No. Since there is an existing Table
(see again the Tables screen shot) Access asks "Delete the existing one before Making a new one?" Fine, yes. Old one is of no longer of any interest.
pend_013.pdf. Access found newest Pendings and made you a Table. Alas for this example the number of New Pendings is pitifully
small. On average searches separated by one month will return more.
What Is In Pendings?. Go back into NPIRS-PDMS. Do a Registration Number search, using the Newest Pending EPA Reg. No., and let NPIRS give you a nicely formatted
report.
pend_014.pdf. When you do another search using an updated New Dump set you don't want to see Known EPA Reg. No. (well you might for
your own reason but that is up to you). This Query appends the Newest EPA Reg. No. to the Table of Known EPA Reg. No. Known is now updated, and presumable up-to-date.
pend_015.pdf. The next time you want to find (Management is screaming/begging for) Newest Pending submission you DON'T want the New
Dump table cluttered with old Citation Counts and EPA Reg. No. This, 3rd, Query deletes all the entries in the New Dump table. It now sits (empty) there waiting for YOU to give
it a new data set.
Who Can Find Newest Pending Submissions? the pend2002/pend2007 database is even simpler than most others. It can be treated as a Black Box: Import/Get entries for
New Dump, then click on Queries, in order (qry01, qry02, qry_03). Look at Newest then go ask NPIRS-PDMS "What is in these?" Any moderately competent Secretary or
Technician or Intern or... can do it with no problem. Happy Hunting!!!
Reusing the Access Database. When you're ready to use the database to FIND NEW PENDING on your own... Run (double-click) qry03. This Query deletes entries in the Pending_New Dump table, so it is ready to receive a new set of entries.
For further information, or to discuss a specific project, contact Bruce
McKay:
e-mail your request to bmckay@ix.netcom.com (that's
bmckay@ix.netcom.com).
All original materials are copyright © 1996 - 2011 by Bruce M. McKay, and all rights are reserved.
The URL for this page is http://www.bmckay.com