Chemical Inventory Management - Excel by lkr79746

VIEWS: 0 PAGES: 15

More Info
									                                                                 Environmental Health and Safety
                                                                 Hazardous Material Inventory Control Form




                                                               MARSHALL UNIVERSITY - CHEMICAL INVENTORY

               Primary Investigator / Faculty Responsible for Area, and Title                                                                 ,
                                     Person Completing Inventory, and Title                                                                   ,
      Date Inventory Completed and Reviewed by PI or Responsible Faculty

                                                                                                                           MSDS     Hazard
   Department          Building         Room #            Chemical Name                    CAS #             Quantity   Units                   Shelf Life
                                                                                                                          on file?    Class
                 Safety & Health cannot accept inventories that contain metic units. You must convert metrics to english standard units, see tabs across bottom for assistanc
(Example)
Chemistry         Science             401           Hydrochloric Acid (40%)        7647-01-0                    2        gal    yes    8      Not critical




                                                                                 1 of 15
                                                                 Environmental Health and Safety
                                                                 Hazardous Material Inventory Control Form




            Vendor           Catalog#   List of Hazard Classes
s bottom for assistance.                Class 1 Explosive

    J.T. Baker             123-34-56    Class 2 Flammable Gas
                                        Class 2 Nonflammable Gas
                                        Class 3 Flammable Liquid
                                        Class 4 Flammable Solid
                                        Class 5.1 Oxidizer
                                        Class 5.2 Organic Peroxide
                                        Class 6 Poison
                                        Class 7 Radioactive
                                        Class 8 Corrosive
                                        Class 9 Pyrophoric
                                        Class 9 Water Reactive
                                        Nonhazardous
                                        Cannot Be Determined - must submit MSDS to Safety




                                                                                 2 of 15
Instructions: In the "grams" column type in the amount of chemical you have and your conversion will apear in the "p

   Grams           Pounds
                            0.00
                            0.00
                            0.00
                            0.00
                            0.00
                            0.00
                            0.00
                            0.00
                            0.00
                            0.00

              1 gram = 0.002 204 622 621 8 pound                    1 gram = 100 milligrams




*For more conversions please visit:
                                http://www.onlineconversion.com/
                                http://www.convert-me.com/en/
version will apear in the "pounds" column.
Instructions: In the "liter" or "milliliter" column type in the amount of chemical you have and your conversion will appe

    Liter           Gallons                                Milliliters    Gallons
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00
                              0.00                                                       0.00

1 liter = 0.264 172 052 36 gallon [US, liquid]                            1 milliliter = 0.000 264 172 052 36 gallon [US




*For more conversions please visit:
                                 http://www.onlineconversion.com/
                                 http://www.convert-me.com/en/
d your conversion will appear in the "gallon" column.




264 172 052 36 gallon [US, liquid]
Unfortunately there is not an easy way to convert PSI of a tank into capacity remaining.

However, for the purpose of the chemical inventory it will be sufficient to simply list the capacity of the tank in Cubic F

You may have to contact the distributor to get this information as it is not stamped on the tank itself.

Contact Safety and Health with any questions - safety@marshall.edu, 696-3461
acity of the tank in Cubic Feet.
List of Hazard Classes

Class 1        Explosive
Class 2        Flammable Gas
Class 2        Nonflammable Gas
Class 3        Flammable Liquid
Class 4        Flammable Solid
Class 5.1      Oxidizer
Class 5.2      Organic Peroxide
Class 6        Poison
Class 7        Radioactive
Class 8        Corrosive
Class 9        Pyrophoric
Class 9        Water Reactive

Nonhazardous

Cannot Be Determined - must submit MSDS to Safety
CHEMICAL INVENTORY INSTRUCTIONS

Below are the instructions for completion of the Chemical Inventory Form. If you have any questions, please call 696

Step 1: Save the blank Chemical Inventory Form to your computer. It is in Microsoft Excel.

Step 2: Review the chemicals that you have. If you haven't used a chemical in 3 years and don't have any pending r
or disposing of it by submitting a request for Unwanted Chemical Pickup through Safety & Health.

 Chemicals that must be included in the inventory:
      all of the items from the list above;
      all chemicals and materials used in University laboratories, art studios and other facilities for which a Ma
      all compressed gases;
      any flammable paints, solvents, glues, fuels and other petroleum products;
      materials that would create an explosive or toxic vapor hazard to unprotected personnel during fire eme

Step 3: Complete the columns on the form as outlined below:

      Column A - *REQUIRED FIELD* DEPARTMENT: Indicate the name of the University department or office t

      Column B - *REQUIRED FIELD* BUILDING: Indicate the building where material is located.

      Column C - *REQUIRED FIELD* ROOM: Indicate the room number where material is located. Do not put a
      not S-106.

             Note: The three preceding fields can be copy/pasted for the whole inventory.

      Column D - *REQUIRED FIELD* CHEMICAL NAME: Indicate the proper chemical name of the substance an
      concentration listed or if the substance is anhydrous, please indicate in this column. Example: Formaldehy

             Be sure to include any prefixes, (i.e., n-butanol). DO NOT USE abbreviations or chemical formulas.

      Column E - *REQUIRED FIELD* CAS No.: The Chemical Abstracts Service (CAS) Registry Number may be
      material safety data sheets (MSDSs) or at online search sites, available below. This information is critical
      chemical mixtures do not have unique CAS numbers. Please include dashes in the number. Example: 776

      Column F - *REQUIRED FIELD* QUANTITY: Indicate the total amount of the chemical using a numerical v
      would be recorded as 2.1134 in the QUANTITY column and gallons in the UNITS column.

      Column G - *REQUIRED FIELD* UNITS: Indicate liquid chemicals in gallons, solid chemicals in pounds, an

             Safety & Health cannot accept inventories that contain metric units. You must convert metrics to e
             on tabs at the bottom of the Inventory Form. If you have rotating stock of chemicals, report the av
             the remaining quantity.

      Column H - *REQUIRED FIELD* MSDS On File: Check your MSDS file and ensure that you have an MSDS
      from the chemical manufacturer or distributor. Safety & Health does not maintain MSDS for departments.
      Resources link below. Note: MSDS sheets for chemicals no longer in use must be retained for 30 years, in
      the sheet in a "No Longer In Use" folder.

      Column I - *REQUIRED FIELD* SHELF LIFE: Indicate the expiration date of the chemical by month and/or
      chemicals that are not time sensitive. More information is available below regarding time sensitive chemic
      disposed of before they become shock sensitive or explosive.
       Column J - *REQUIRED FIELD* HAZARD CLASS: Review the label on the container and the MSDS. From t
       appropriate hazard class(es). If you cannot determine the correct class, choose “Cannot Be Determined” a
       inventory. Hazard classification provides information concerning adverse reactions of the chemical and pr
       class is available, see below.

       Column K - *SUGGESTED FIELD* VENDOR: Indicate the name of the vendor or company that manufactur

       Column L - *SUGGESTED FIELD* CATALOG NUMBER: Indicate the catalog number for the chemical listed.
       chemicals they sale.

Step 4: Save the newly updated file and e-mail it to safety@marshall.edu. Your file will be inserted into the Universit
contacted by Safety & Health if substances you work with are extremely hazardous or strictly regulated. Keep a copy
reporting requirement.



RESOURCES AND INFORMATION:

Forms:

 Chemical Inventory Form

 SAMPLE Chemical Inventory Form

 Unwanted Chemical Pickup Request Form



CAS Lookup Sites:

 Search the manufacturer's web site for MSDS frequently provides the CAS number

 http://www.dep.state.pa.us/physicalproperties/CASNUM_Search.htm

 http://www.chemindustry.com/apps/chemicals

 http://www.cdpr.ca.gov/docs/chemical/monster2.htm

 http://www.commonchemistry.org/



MSDS Information and Lookup Sites:

 http://www.marshall.edu/safety/chemical/msds.asp



Chemical Storage and Hazard Class Information:

 http://www.marshall.edu/safety/chemical/storage.asp



Time Sensitive Chemicals
http://www.marshall.edu/safety/Chemical/Management_of_Peroxide-Forming_Chemicals.pdf
ave any questions, please call 696-3461, or email safety@marshall.edu




years and don't have any pending research that requires it, consider donating to a colleague
Safety & Health.



 and other facilities for which a Material Safety Data Sheet (MSDS) exists;



otected personnel during fire emergencies (lead, mercury, magnesium, etc.).




 University department or office that controls the hazardous material inventory.

material is located.

e material is located. Do not put a dash (-) between numbers or letters. Example: S106,




hemical name of the substance and/or any common name listed on label. If there is a
 his column. Example: Formaldehyde, 10%.

breviations or chemical formulas.

e (CAS) Registry Number may be found for specific chemicals on the chemical container,
below. This information is critical to the effectiveness of the database. Paints and some
hes in the number. Example: 7768-77-0

 the chemical using a numerical value ONLY. Example: 2 four liter containers of toluene
  UNITS column.

 ns, solid chemicals in pounds, and gases in cubic feet.

 s. You must convert metrics to english standard units. There are conversion calculators
 stock of chemicals, report the average amount on hand. For partial containers, estimate


d ensure that you have an MSDS for each chemical that you use. MSDS can be obtained
 maintain MSDS for departments. If you have difficulty finding an MSDS, see the MSDS
 must be retained for 30 years, indicate the date the item's use was ceased and place



 of the chemical by month and/or year for time sensitive chemicals. Leave blank for
w regarding time sensitive chemicals. It is very important that hazardous chemicals are
 container and the MSDS. From the choices listed on the spreadsheet, choose the
choose “Cannot Be Determined” and submit an MSDS for this chemical with your
 reactions of the chemical and proper storage. Additional information on the hazardous



ndor or company that manufactures or sales the chemical listed.

g number for the chemical listed. Vendors often have unique numbers assigned to the


e will be inserted into the University inventory and reviewed by a staff member. You may be
s or strictly regulated. Keep a copy of your inventory for future use as this is an annual
hemicals.pdf

								
To top