From: Allen Niemi <anniemi**At_Symbol_Here**MTU.EDU>
Subject: Re: [DCHAS-L] Identifying P-list and U-list materials
Date: June 5, 2013 4:34:44 PM EDT
Reply-To: DCHAS-L <DCHAS-L**At_Symbol_Here**MED.CORNELL.EDU>
Message-ID: <CAHoE6joJwaVzn6bGCUw7PgUibN35HHFU14ZrwOAhMWF06gCQ7w**At_Symbol_Here**mail.gmail.com>
Demystify:
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.
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.
Barry
St. Ambrose University
Davenport, Iowa
-- Allen Niemi, PhD Director Occupational Safety and Health Services Room 322 Lakeshore Center Michigan Technological University Phone: 906-487-2118 Fax: 906-487-3048
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 secretary**At_Symbol_Here**dchas.org. The maintenance and hosting of the DCHAS-L archive is provided through the generous support of Safety Emporium.
