Inventory Sheet (Blank) - Excel by HD623H

VIEWS: 3,043 PAGES: 5

									                      School _____________________________________Teacher ___________________________


Quantity Units_size   Description                                 ChemGrp Room Location Staff_responsible Duration_checkout
This spreadsheet contains a blank inventory sheet that can be printed and reproduced. You may use it to have students take y
preparation for entering the items into the system. If you enter chemicals it is suggested that you organize your chemicals by th
system found in Flynn catalogs. This system organizes chemicals by compatible storage categories. Identifying the categories
will be helpful in organizing chemicals and in insuring safety of storage. Below are the descriptors for each column in the inven

Quantity               Enter a number only representing the number of units. (Doesn't matter here what the units are.)
Units_size             Enter numbers and abbreviations representing the size of the units. I. e. 5 lb bag, 1 oz bottle, 500g bottl
Description            Enter a description using terms that would help someone find it in an electronic search.
ChemGrp                If the item is a chemical, enter a Flinn Compatible Chemical Family Code (I.e. O1 through 09, or I1 throu
Room                   Enter the room number of the classroom or nearest classroom
Location               Enter a brief (one or two word) description of the location in the room. (I.e. storage room, shelves, displa
Staff_Responsible      Enter the First and Last name of the teacher responsible for checking out the item.
Duration_Checkout      Enter the time that another teacher or staff member may keep the item when borrowing it.



Flinn Chemical Compatibility Codes

Organic Chemicals                                                                             Inorganic Chemicals
O1       Acids, Amino Acids, Anhydrides Peracides                                             I1
O2       Alcohols, Glcols, Sugars, Amines, Amides, Imines, Imides                             I2
O3       Hydrocarbons, Esters, Aldehydes, Oils                                                I3
O4       Ethers, Ketones, Ketenes, Halogenated Hydrocarbons, Ethylene Oxide                   I4
O5       Epoxy compounds, Isocyanates                                                         I5
O6       Peroxides, Hydroperoxides, Azides                                                    I6
O7       Sulfides, Polysulfides, Sufoxides, Nitriles                                          I7
O8       Phenols, Cresols                                                                     I8
O9       Dyes, Stains, Indicators                                                             I9
OM       Miscellaneous Organics                                                               I10
                                                                                              IM
ou may use it to have students take your inventory in
hat you organize your chemicals by the recommended
categories. Identifying the categories on the inventory
 criptors for each column in the inventory sheet.

atter here what the units are.)
  I. e. 5 lb bag, 1 oz bottle, 500g bottle
 n electronic search.
 Code (I.e. O1 through 09, or I1 through I10 (see below or Flinn Catalog)

m. (I.e. storage room, shelves, display case, back room, drawer 3, etc.)
ng out the item.
 em when borrowing it.




  Inorganic Chemicals
            Metals, Hydrides
            Acetates, Halides, Iodides, Sulfates, Sulfites, Thiosulfates, Phosphates, Halogens
            Amides, Nitrates (except Ammonium Nitrate), Nitrites, Azides
            Hydroxides, Oxides, Silicates, Carbonates, Carbon
            Sulfides, Selenides, Phophides, Carbides, Nitrides
            Chlorates, Bromates, Iodates, Chlorites, Hypochlorites, Perchlorates, Perchloric Acid, Peroxides, Hydrogen peroxide
            Arsenates, Cyanides, Cyanates
            Borates, Chromates, Manganates, Permanganates
            Acids (except Nitric acid which is always isolated and stored by itself)
            Sulfur, Phosphorus, Arsenic, Phosphorous Penoxide
            Miscellaneous Inorganics
oxides, Hydrogen peroxide
                                                                          Teacher
                          School _______Wyandotte High School (Example)____________________John Doe_________


Quantity Units_size       Description                                  ChemGrp Room Location Staff_responsible Duration_checkout

       1 500 g            Sodium Chloride (Reagent grade)              I2           200 Drawer 1   John Doe    2 weeks
       3                  Electronic balance (300g max, .1g)                        200 Backroom John Doe      1 week
      50                  Small plastic handlens                                    200 Drawer 2   John Doe    As needed
       4 box 100          Dissection pins                                           200 Closet     John Doe    1 month
       2 2 liter bottle   Ethanol (ethyl alcohol) 95% denatured        O2                        John
                                                                                    200 Chem Shelving Doe      As needed
       1 500 g bottle     Sulfur (powdered)                            I10                       John
                                                                                    200 Chem Shelving Doe      As needed
       6 500 ml bottle    Hydrogen peroxide 3%                         I6                        John
                                                                                    200 Chem Shelving Doe      As needed

								
To top