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

Stock Inventory Count Sheet (Main & Front Yard)
Date: |  | At: | Hrs
Performed By: | Production Manager
 |  |  | Storage |  | Actual Inventory
Waste Material | Description | Category | Area | Units | Qty | [NAME] | [NAME] | [NAME] | Total (kg's) | ρ | Total (Litres) | Qty as of 1600 hrs |  |  |  | Storage Locations |  |  | Lanes |  | Status |  | Class |  | Category |  | Units
Ammonia | Ammonia holding tank | Corrosive | ST04 | Tank |  |  |  |  |  |  | 72000 |  |  |  |  |  | DS01 |  | 1 |  | Pre-Production |  | 1 |  | Explosives |  | IBC's
Ammonium Chloride | AMS Feedstock | Corrosive | IS04 | IBC's | 63 | 5 | 9 |  |  |  | 60000 |  |  |  |  |  | DS02 |  | 2 |  | Released |  | 2 |  | Gases |  | Tank
Ammonium Nitrate | AMS Feedstock | Corrosive | IS04 | IBC's | 52 | 3 | 6 |  |  |  | 52000 |  |  |  |  |  | DS03 |  | 3 |  | Obsolete |  | 3 |  | Flammable Gas |  | Drums
Ammonium Sulfate (Global) | AMS Feedstock | Corrosive | IS04 | IBC's | 20 |  |  |  |  |  | 20000 |  |  |  |  |  | DS04A |  | 4 |  | Product |  | 4 |  | Flammable Solid |  | Cans
Ammonium Sulfate (Chemviron) | AMS Feedstock | Corrosive | IS04 | IBC's | 35 | 7 | 10 |  |  |  | 16000 |  |  |  |  |  | DS04B |  | 5 |  | Not In Use |  | 5 |  | Oxidising |  | Cages
Effluent | Ex Photo / Ready to go | Non-hazardous | IS01 | IBC's | 32 | 1 | 2 |  |  |  | 34000 |  |  |  |  |  | DS05 |  | 6 |  | Storage |  | 6 |  | Poison |  | [NAME]
Effluent | Ex Photo / Ready to go | Non-hazardous | ST18 (ISO) | Tank |  |  |  |  |  |  | 6000 |  |  |  |  |  | DS06 |  | 7 |  | Upkeep |  | 7 |  | Radioactive |  | Crates
Fertiliser (Product) | Fertiliser / Ready to go | Non-hazardous | ST01 | Tank |  |  |  |  |  |  | 123000 |  |  |  |  |  | DS07A |  | 8 |  | Recovery |  | 8 |  | Corrosive |  | Bins
Fertiliser (Product) | Fertiliser / Ready to go | Non-hazardous | ST02 | Tank |  |  |  |  |  |  | 0 |  |  |  |  |  | [NAME] |  | 9 |  | Site Bulking |  | 9 |  | Non-hazardous |  | Boxes
Fixer / Developer | Bulked | Non-hazardous | IS2A | IBC's | 74 | 1 | 2 | 3 |  |  | 77000 |  |  |  |  |  | W1 |  | 10 |  | Quarantined |  | N/A |  | Quarantined
Nitric Acid c/w Co |  | Corrosive | IS01 | IBC's | 17 | 1 |  |  |  |  | 16300 |  |  |  |  |  | ST01 |  |  |  | Raw Material |  |  |  | Reception
Nitric Acid Filter Press Water | Top 900 L | Misc / Environment | IS01 | IBC's | 20 | 1 | 2 |  |  |  | 20000 |  |  |  |  |  | ST02 |  |  |  | Intermediate |  |  |  | Toxic
Nitric Acid Sediment | Bottom 100 L | Misc / Environment | IS01 | IBC's | 7 | 1 |  |  |  |  | 7000 |  |  |  |  |  | IS04 |  |  |  |  |  |  |  | Carcinogenic
Raw AMS | Settling Tank | Non-hazardous | ST13 | Tank |  |  |  |  |  |  | 50000 |  |  |  |  |  | ST04 |  |  |  |  |  |  |  | Misc / Environment
Raw AMS | Settling Tank | Non-hazardous | ST19 | Tank |  |  |  |  |  |  | 0 |  |  |  |  |  | ST22 |  |  |  |  |  |  |  | Flammable Liquid
Sludge settling tank | Slurry for Filter Pressing (Iron) | Non-hazardous | ST22 | Tank |  |  |  |  |  |  |  |  |  |  |  |  | ST13 |  |  |  |  |  |  |  | N/A
Sulphuric acid | Acid holding tank | Corrosive | ST08 | Tank |  |  |  |  |  |  | 40000 |  |  |  |  |  | ST17
Sulphuric acid | Acid holding tank | Corrosive | ST20 | Tank |  |  |  |  |  |  | 0 |  |  |  |  |  | BT09
Sulphuric acid | EPC-UK 80% | Corrosive | IS04 | IBC's | 8 | 1 | 2 |  |  |  | 8500 |  |  |  |  |  | ST08
Surface Water Tank | Grey water | Non-hazardous | WT01 | Tank |  |  |  |  |  |  | 120000 |  |  |  |  |  | ST20
Treated Photo | Awaiting Polymer treatment | Non-hazardous | IS2B | IBC's | 7 |  |  |  |  |  | 7000 |  |  |  |  |  | ST19
Treated Photo | To be [NAME] ([NAME]) | Non-hazardous | ST15 | Tank |  |  |  |  |  |  | 9500 |  |  |  |  |  | ST24
Treated Photo | To be [NAME] ([NAME]) | Non-hazardous | ST16 | Tank |  |  |  |  |  |  | 0 |  |  |  |  |  | TT04
Treated Photo | To be [NAME] ([NAME]) | Non-hazardous | ST1B | Tank |  |  |  |  |  |  | 9500 |  |  |  |  |  | TT0
Treated Photo | Treated with Polymer | Non-hazardous | TT13 | Tank |  |  |  |  |  |  | 7000 |  |  |  |  |  | TT03
Treated Photo | Treated with Polymer | Non-hazardous | TT1A | Tank |  |  |  |  |  |  | 10000 |  |  |  |  |  | TT13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TT1A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST1B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ST18 (ISO)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WT01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IS01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IS2A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IS03
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IS05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IS2B