The server room hummed like a beehive in the dark. Leo rubbed his eyes for the third time that hour. On his screen, a frantic email from the Port Authority’s logistics director glowed:
3. Ship Chandler Associations
Some national chandler associations (e.g., ISSA – International Ship Suppliers Association) provide member-only IMPA-based Excel tools with extra columns for local supplies.
IMPA codes are grouped into logical categories. The first two digits usually represent the product class: Code Range 00 Provisions Fresh vegetables, fruits, dry goods 17 Galley utensils, plates, cups 19 Working gloves, rain suits, safety boots 21 Ropes & Hawsers Manila rope, signal halyards, wire rope 33 Safety Equipment IMO symbols, fire hoses, safety belts 47 Stationery Notebooks, files, pens, calculators 59 Pneumatic/Electric Tools Impact wrenches, grinders, portable drills 61 Hand Tools Wrenches, hammers, screwdrivers Tips for High-Quality Data Management in Excel
080101 Breathing apparatus, SCBA, 300 bar, 6.8L carbon cylinder Set 08 Safety Equipment
080102 Fire hose, rubber lined, 1.5" x 30m, with couplings Length 08 Safety Equipment
Step 1: Convert to a Table
Select the data range and press Ctrl + T. Name the table tbl_IMPA. This makes all formulas dynamic.
100101 Chain block, manual, 2 ton capacity, 5m lift Pc 10 Lifting & Rigging