Spreadsheet: 269496d1381174200-amateur-excel-help-with-multiple-if-functions-conditional-formatting-if-poss-inventory-control-v3-1-
Sheet: Count Sheet - Drumstore

Stock Inventory Count Sheet
Company:
Date:
Performed By: | Site Chemist
Item Information |  |  |  |  |  |  | Storage | Purchase Information |  | Actual Inventory
TN | Waste Material | Physical Form | Class | Category | R/D | Job Status | Area | Supplier | Units | Qty | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Total (kg's) | ρ | Total (Litres) |  |  |  | Storage Locations |  |  | Lanes |  | Status |  | Class |  | Category |  | Units | R/D
39408 | [NAME] | Liquid | 8 | Corrosive | [NAME] | Site Bulking | DS03 |  | IBC's | 5 | 3 |  |  | 2013-04-08 00:00:00 |  |  |  | 5000 |  |  |  |  | DS01 |  | 1 |  | Pre-Production |  | 1 |  | Explosives |  | IBC's | R1
39516 | [NAME] | [NAME] | 8 | Corrosive | R05 | Site Bulking | DS02 |  | IBC's | 6 | 2 |  |  | 2013-04-11 00:00:00 |  |  |  | 6000 |  |  |  |  | DS02 |  | 2 |  | Released |  | 2 |  | Gases |  | Tank | R2
37993 | [NAME] | [NAME] | 8 | Corrosive | [NAME] | Recovery | DS03 |  | IBC's | 17 | 5 | 6 |  | 2013-07-20 00:00:00 |  | 18957 | 1.14 |  |  |  |  |  | DS03 |  | 3 |  | Obsolete |  | 3 |  | Flammable Gas |  | Drums | R3
 | Bentonite | Powder | 9 | Non-hazardous |  | Not In Use | DS01 |  | [NAME] | 2 | 5 |  |  |  |  | 2000 |  |  |  |  |  |  | DS04A |  | 4 |  | Product |  | 4 |  | Flammable Solid |  | Cans | R4
 | Calcium Carbonate | Powder | 9 | Misc / Environment |  | Raw Material | [NAME] |  | Drums | 1 | 2 |  |  |  |  | 60 |  |  |  |  |  |  | DS04B |  | 5 |  | Not In Use |  | 5 |  | Oxidising |  | Cages | R5
 | Cobalt Hydroxide | Cake | 9 | Misc / Environment |  | Product | DS04A |  | [NAME] | 5 | 1 | 2 |  |  |  | 5180 |  |  |  |  |  |  | DS05 |  | 6 |  | Storage |  | 6 |  | Poison |  | [NAME] | R6
 | Cobalt Hydroxide | Cake | 9 | Non-hazardous |  | Product | DS04B |  | [NAME] | 7 | 1 | 2 |  |  |  | 7133 |  |  |  |  |  |  | DS06 |  | 7 |  | Upkeep |  | 7 |  | Radioactive |  | Crates | R7
 | Cobalt Residues | Powder | 4 | Flammable Solid |  | Intermediate | DS02 |  | IBC's | 2 | 1 |  |  |  |  |  |  | 2000 |  |  |  |  | DS07A |  | 8 |  | Recovery |  | 8 |  | Corrosive |  | Bins | R8
 | Cobalt Residues | Powder | 4 | Flammable Solid |  | Intermediate | DS05 |  | Drums | 37 | 5 |  |  |  |  | 7400 |  |  |  |  |  |  | [NAME] |  |  |  | Site Bulking |  | 9 |  | Non-hazardous |  | Boxes | R9
 | Cobalt Sludge | Sludge | 9 | Misc / Environment |  | Product | DS05 |  | Drums | 3 | 6 |  |  |  |  | 600 |  |  |  |  |  |  | W1 |  |  |  | Quarantined |  | N/A |  | Quarantined |  |  | R10
 | Copper Cement | Cake | 9 | Misc / Environment |  | Recovery | DS04B |  | [NAME] | 3 | 1 |  |  |  |  | 6000 |  |  |  |  |  |  | ST01 |  |  |  | Raw Material |  |  |  | Reception |  |  | R11
 | Copper Slurry | Sludge | 9 | Non-hazardous |  | Recovery | DS02 |  | IBC's | 4 | 3 | 5 |  |  |  |  |  | 2500 |  |  |  |  | ST02 |  |  |  | Intermediate |  |  |  | Toxic |  |  | R12
 | Copper Sulfide | Cake | 9 | Non-hazardous |  | Product | DS05 |  | [NAME] | 2 | 6 |  |  |  |  | 4000 |  |  |  |  |  |  | IS04 |  |  |  |  |  |  |  | Carcinogenic |  |  | R13
 | Cupric Chloride | [NAME] | 8 | Corrosive |  | Recovery | DS02 |  | IBC's | 2 | 1 | 3 |  |  |  |  |  | 2000 |  |  |  |  | ST04 |  |  |  |  |  |  |  | Misc / Environment |  |  | R14
40648 | Dental Amalgam | Solid | 6 | Toxic | [NAME] | Site Bulking | DS01 |  | Bins | 1 | 2 |  |  | 2013-09-27 00:00:00 |  | 50 |  |  |  |  |  |  | ST22 |  |  |  |  |  |  |  | Flammable Liquid |  |  | R15
40655 | Dental Amalgam | Solid | 6 | Toxic | [NAME] | Site Bulking | DS01 |  | IBC's | 3 | 2 |  |  | 2013-09-27 00:00:00 |  | 250 |  |  |  |  |  |  | ST13 |  |  |  |  |  |  |  | N/A
 | Dental Amalgam | Solid | 6 | Toxic |  | Site Bulking | DS05 |  | IBC's | 19 | 3 | 4 |  |  |  | 3310 |  |  |  |  |  |  | ST17
 | Dental Amalgam | Solid | 6 | Toxic |  | Site Bulking | DS05 |  | Drums | 2 | 2 |  |  |  |  | 70 |  |  |  |  |  |  | BT09
 | Dental Amalgam | Solid | 6 | Toxic |  | Site Bulking | DS06 |  | Drums | 2 | 6 |  |  |  |  | 100 |  |  |  |  |  |  | ST08
 | Empty Bags | New For Product | N/A | N/A |  | Raw Material | DS04A |  | [NAME] | 100 | 1 |  |  |  |  | 10 |  |  |  |  |  |  | ST20
 | Empty Cans | Inside Bags | 3 | N/A |  | Site Bulking | DS07A |  | IBC's | 2 | 1 |  |  |  |  | 30 |  |  |  |  |  |  | ST19
 | Empty Drum's | Empty | N/A | N/A |  | Storage | DS01 |  | Drums | 4 | 5 |  |  |  |  | 120 |  |  |  |  |  |  | ST24
 | Empty Drum's | Empty | N/A | N/A |  | Storage | DS05 |  | Drums | 4 | 2 |  |  |  |  | 240 |  |  |  |  |  |  | TT04
 | Empty IBC's | Cut-Open / Dirty | N/A | N/A |  | Storage | DS01 |  | IBC's | 1 | 5 |  |  |  |  | 80 |  |  |  |  |  |  | TT0
 | Empty IBC's | Cut-Open / 500 L |  | N/A |  |  | DS05 |  | IBC's | 1 | 1 |  |  |  |  | 500 |  |  |  |  |  |  | TT03
 | Empty IBC's | Cut-Open / Dirty | N/A | N/A |  | Storage | DS05 |  | IBC's | 1 | 1 |  |  |  |  | 80 |  |  |  |  |  |  | TT1A
 | Empty IBC's | Dirty | N/A | N/A |  | Not In Use | DS05 |  | IBC's | 1 | 2 |  |  |  |  | 80 |  |  |  |  |  |  | ST13
 | Empty IBC's | Cut-Open / Dirty | N/A | N/A |  | Storage | DS06 |  | IBC's | 1 | 6 |  |  |  |  | 60 |  |  |  |  |  |  | ST14
40572 | Gold scrap metallics | Solid | 9 | Non-hazardous | [NAME] | Recovery | DS06 |  | Boxes | 3 | 5 |  |  | 2013-09-27 00:00:00 |  | 32 |  |  |  |  |  |  | ST15
40572 | Gold scrap metallics | Solid | 9 | Non-hazardous | [NAME] | Recovery | DS06 |  | Drums | 3 | 5 |  |  | 2013-09-27 00:00:00 |  | 72 |  |  |  |  |  |  | ST16
 | Harborlite | Powder | 9 | Non-hazardous |  | Raw Material | DS06 |  | [NAME] | 13 | 6 |  |  |  |  | 169 |  |  |  |  |  |  | TT1B
40580 | HPLC waste | Liquid | 9 | Misc / Environment | D09 | Site Bulking | DS01 |  | Cans | 3 | 3 |  |  | 2013-09-27 00:00:00 |  |  |  | 60 |  |  |  |  | ST18
 | Hyd Peroxide 35% | Liquid | 5 | Oxidising |  | Raw Material | DS04A |  | Cans | 46 | 2 |  |  |  |  |  |  | 1150 |  |  |  |  | WT01
 | Hydraulic Oil | Liquid | 3 | Flammable Liquid |  | Raw Material | DS06 |  | Drums | 2 | 6 |  |  |  |  |  |  | 416 |  |  |  |  | IS01
 | [NAME] | Cake | 9 | Non-hazardous |  | Product | DS01 |  | [NAME] | 1 | 5 |  |  |  |  | 1000 |  |  |  |  |  |  | IS2A
 | [NAME] | Cake | 9 | Non-hazardous |  | Product | DS04B |  | [NAME] | 1 | 1 |  |  |  |  | 1000 |  |  |  |  |  |  | IS03
 | [NAME] | Cake | 9 | Non-hazardous |  | Product | DS05 |  | [NAME] | 5 | 2 | 6 |  |  |  | 5000 |  |  |  |  |  |  | IS05
 | Lead Foil | Solid | 9 | Non-hazardous |  | Site Bulking | DS05 |  | Drums | 3 | 3 |  |  |  |  | 50 |  |  |  |  |  |  | IS2B
 | Lead Foil | Solid | 9 | Non-hazardous |  | Site Bulking | DS05 |  | IBC's | 1 | 1 |  |  |  |  | 80
 | Lead Residues | Powder | 4 | Flammable Solid |  | Intermediate | DS05 |  | Drums | 3 | 6 |  |  |  |  | 600
 | Metal Cleaner | Liquid | 8 | Corrosive |  | Raw Material | [NAME] |  | Crates | 1 | 2 |  |  |  |  | 30
 | Nickel Hydroxide | [NAME] | 9 | Non-hazardous |  | Product | DS04B |  | [NAME] | 4 | 3 |  |  |  |  | 3300
 | Nickel Sulfamate | [NAME] | 8 | Corrosive |  | Recovery | DS02 |  | IBC's | 1 | 3 |  |  |  |  |  |  | 300
 | NiOH / NiS | [NAME] | 9 | Non-hazardous |  | Product | DS04B |  | [NAME] | 2 | 1 | 3 |  |  |  | 2183
 | Oil Water | Oil Usage | 3 | Flammable Liquid |  | Site Bulking | DS07A |  | IBC's | 1 | 1 |  |  |  |  |  |  | 800
 | Polymer Solution | Liquid | 9 | Non-hazardous |  | Raw Material | [NAME] |  | Crates | 1 | 2 |  |  |  |  |  |  | 350
 | Sample Bottles | Inside Drums | N/A | N/A |  | Raw Material | DS06 |  | Drums | 3 | 1 |  |  |  |  | 30
 | Silver Sulfide | [NAME] | 9 | Non-hazardous |  | Product | DS04B |  | [NAME] | 1 | 3 |  |  |  |  | 1000
 | Silver Sulfide | [NAME] | 9 | Misc / Environment |  | Product | DS05 |  | [NAME] | 1 | 2 |  |  |  |  |  |  | 1076
 | Silver Sulfide | [NAME] | 9 | Non-hazardous |  | Product | DS01 |  | [NAME] | 1 | 1 |  |  |  |  | 1027
40660 | [NAME] | [NAME] | 8 | Corrosive | R01 | Raw Material | DS03 |  | IBC's | 16 | 2 | 4 |  | 2013-10-01 00:00:00 |  | 23172.5 | 1.495 | 15100
 | [NAME] | [NAME] | 8 | Corrosive |  | Raw Material | DS03 |  | [NAME] | 56 | 1 |  |  |  |  | 1400
 | [NAME] | [NAME] | 8 | Corrosive |  | Raw Material | DS03 |  | IBC's | 1 | 1 |  |  |  |  |  |  | 750
 | Spent Acid | Sample Cans | 8 | Corrosive |  |  | [NAME] |  | Cans | 6 | 2 |  |  |  |  |  |  | 15
 | [NAME] | [NAME] | 9 | Non-hazardous |  | Site Bulking | DS02 |  | IBC's | 2 | 2 | 6 |  |  |  |  |  | 2000
 | [NAME] | [NAME] | 9 | Non-hazardous |  | Product | DS05 |  | [NAME] | 1 | 1 |  |  |  |  | 400
 | Treated Ferric Acid | [NAME] | 8 | Corrosive |  | Site Bulking | DS02 |  | IBC's | 9 | 4 | 6 |  |  |  |  |  | 9000
 | Used Rags | Oil Usage | 3 | Flammable Liquid |  | Site Bulking | DS07A |  | IBC's | 2 | 1 |  |  |  |  | 30
 | Zinc Residues | [NAME] | 4 | Flammable Solid |  | Intermediate | DS05 |  | Drums | 4 | 6 |  |  |  |  | 800
 | Zinc Residues | [NAME] | 4 | Flammable Solid |  | Intermediate | DS07A |  | Drums | 2 | 1 |  |  |  |  | 400
Inventory Control Spreadsheet © 2013 Edelchemie (UK) Limited