From: Luis Barthel-Rosa <luisbr**At_Symbol_Here**UNR.EDU>
Subject: Re: [DCHAS-L] Identifying P-list and U-list materials
Date: June 5, 2013 8:16:27 PM EDT
Reply-To: DCHAS-L <DCHAS-L**At_Symbol_Here**MED.CORNELL.EDU>
Message-ID: <CAN0bzO5ne+feXw-uXAMV0UZhrcpisXVji6geir8jcrWNk-KDTg**At_Symbol_Here**>

Hmmm..only 2,100 items..we have some individual rooms that have about that many items in them!


Does your excel spreadsheet have the Chemical Abstract Service (CAS) number associated with each chemical? I assume you are familiar with CAS numbers but if not:


Note that for some bizarre reason, MS excel wants to do a mathematical operation on certain CAS numbers and automatically turns them into dates.  The only way to prevent it is to manually put brackets [ ], or something around the CAS number in each individual cell so it does not treat it like a number.  Yes I tried re-formatting the cell types to a non-number, it doesn’t help.


If your inventory has CAS numbers with the chemicals, then you could copy and paste the CAS numbers into a “find” search box on the web page below.  You’d have to look one-by-one.


Are you trying to identify every single individual container (for future waste disposal labeling), or just which chemical names are on the EPA lists?  My guess is that of your 2,100 items there will be duplicate chemicals (depends how you recorded your inventory).  If you don’t need every container identified, you could try to remove duplicate chemical names using excel which might shorten the list of chemicals (CAS numbers) you need to search.


If your excel inventory not have CAS numbers associated with each item, then you may need to spend the time looking each one up and adding the information.


FYI – we use inventory software that identifies the RCRA-P listed items and we place a special sticker on the container on those items.


Good luck!


Luis P. Barthel-Rosa, Ph.D.

Manager, Chemical Management Services

Environmental Health and Safety Department

University of Nevada, Reno


775-327-2270 office




From: DCHAS-L Discussion List [mailto:dchas-l**At_Symbol_Here**MED.CORNELL.EDU] On Behalf Of Allen Niemi
Sent: Wednesday, June 05, 2013 1:35 PM
Subject: Re: [DCHAS-L] Identifying P-list and U-list materials


You could import the P- and U-lists into Excel and spend a bunch of time writing If-Then logic or using pivot tables but that would just pare the list down a little. A little better if you have CAS numbers in your inventory. Two or three days of undergrad chemistry student time should get you a complete job for very little cost by searching manually. That would be my first choice.


On Wed, Jun 5, 2013 at 3:40 PM, Ferm, Barret <fermbarreta**At_Symbol_Here**> wrote:

Dear Colleagues,

I have a list of our chemical inventory (2,150 items) in an Excel file. I want to identify which of these are P-listed and U-listed. Any suggestions on how to go about it efficiently?
Many thanks.


St. Ambrose University

Davenport, Iowa


Allen Niemi, PhD
Occupational Safety and Health Services
Room 322 Lakeshore Center
Michigan Technological University
Phone: 906-487-2118
Fax:     906-487-3048

Previous post   |  Top of Page   |   Next post

The content of this page reflects the personal opinion(s) of the author(s) only, not the American Chemical Society, ILPI, Safety Emporium, or any other party. Use of any information on this page is at the reader's own risk. Unauthorized reproduction of these materials is prohibited. Send questions/comments about the archive to
The maintenance and hosting of the DCHAS-L archive is provided through the generous support of Safety Emporium.