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**>

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.