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.
Luis P. Barthel-Rosa, Ph.D.
Manager, Chemical Management Services
Environmental Health and Safety Department
University of Nevada, Reno
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**sau.edu> wrote:
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?
St. Ambrose University
Allen Niemi, PhD
Occupational Safety and Health Services
Room 322 Lakeshore Center
Michigan Technological University
Previous post | Top of Page | Next post