Safety Emporium eyewashes
Safety Emporium eyewashes

Interactive Learning Paradigms, Incorporated

DCHAS-L Discussion List Archive

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>


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:
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.
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

Previous post   |  Top of Page   |   Next post