Safety Emporium eyewashes
Safety Emporium eyewashes

Interactive Learning Paradigms, Incorporated

DCHAS-L Discussion List Archive

About This Archive  |   DCHAS-L 2013 Index   |   DCHAS-L Yearly Index   |   DCHAS-L Home Page

About This Archive

DCHAS-L 2013 Index

DCHAS-L Yearly Index

DCHAS-L Home Page

Previous by Date

Subject: [DCHAS-L] Identifying P-list and U-list materials

Date: Jun 5, 2013 03:40 UTC

Author: Ferm, Barret <fermbarreta**At_Symbol_Here**SAU.EDU>

Next by Date

Subject: Re: [DCHAS-L] Identifying P-list and U-list materials

Date: Jun 5, 2013 04:46 UTC

Author: Voehringer, Andrea <AVOEHRINGER**At_Symbol_Here**BLUEFIELDSTATE.EDU>

From: Allen Niemi <anniemi**At_Symbol_Here**MTU.EDU>

Subject: Re: [DCHAS-L] Identifying P-list and U-list materials

Date: Jun 5, 2013 04:34 UTC

Reply-To: DCHAS-L <DCHAS-L**At_Symbol_Here**MED.CORNELL.EDU>

Message-ID: <CAHoE6joJwaVzn6bGCUw7PgUibN35HHFU14ZrwOAhMWF06gCQ7w**At_Symbol_Here**mail.gmail.com>

In-Reply-To:  

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.


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