Spreadsheet: 182465d1348496393-vlookup-problem-category-summaries
Sheet: Raw data

Vendor name | Category | Management | Sum EUR | # of parts | @1.43FX rate
ACCELLENT CARDIOLOGY GALWAY | Metals | Strategic | 2433585.044700001 | 81
ACCELLENT CARDIOLOGY/ARVADA | Metals | Strategic | 280.2449999999999 | 2
ACCELLENT CARDIOLOGY/SALEM | Metals | Strategic | 1278012.2117 | 34
ACCELLENT CARDIOLOGY/TRENTON | Metals | Strategic | 0 | 3
ACCELLENT ENDOSCOPY | Metals | Strategic | 0 | 1
ANGIOTECH | Other | Site Managed | 25778.515 | 2
CHESAPEAKE | Packaging | Strategic | 973469.8115 | 105
ANOPOL LIMITED | Other | Site Managed | 1933.32 | 1
PERFECSEAL LIMITED | Packaging | Strategic | 639759.1207999999 | 18
MEADWESTVACO HEALTHCARE PACKAG | Packaging | Strategic | 551668 | 29
AMCOR FLEXIBLES SLIGO LIMITED | Packaging | Strategic | 432000 | 1
SCHLOTTER IRELAND | Other | Site Managed | 207700.8 | 4
ADVANCED POLYMERS INCORPORATED |  | Site Managed | 31788.5001 | 2
ADVANT MEDICAL LTD | Plastic | Strategic | 389628.3479999999 | 11
ANSAMED LIMITED |  | Site Managed | 245204 | 7
APPLIED PLASTICS COMPANY | Metals | Site Managed | 105271.824 | 12
AVICENNA TECHNOLOGY INCORPORAT | Plastic | Site Managed | 627999.744 | 9
APEX MEDICAL TECHNOLOGIES |  | Site Managed | 160018.6 | 16
AZELIS UK LIFE SCIENCES LIMITE |  | Site Managed | 55518.6 | 4
YORK TAPE & LABEL LLC | Packaging | Strategic | 350056.8703485001 | 16
BAYER MATERIAL SCIENCE AG |  | Site Managed | 195300 | 2
BRENNAN AND COMPANY |  | Site Managed | 3520 | 1
BRENNTAG CHEMICALS DISTRIBUTIO |  | Site Managed | 107438.72 | 3
BURDICK AND JACKSON |  | Site Managed | 10342.502 | 1
CALIFORNIA FINE WIRE COMPANY | Metals | Site Managed | 1170.96 | 1
CARAGH PRECISION | Metals | Site Managed | 363673.62 | 46
NELIPAK THERMOFORMING IRELAND | Packaging | Strategic | 342057.04 | 15
CABLE ACCESSORIES LIMITED |  | Strategic | 54956.630776 | 10
STERIPACK LIMITED | Packaging | Strategic | 268382.286 | 40
CLASSIC TECHNOLOGY LIMITED |  | Site Managed | 17740.8 | 1
MANGAR INDUSTRIES INCORPORATED | Packaging | Strategic | 185353.25697 | 7
CODICO DISTRIBUTORS LIMITED |  | Site Managed | 5666.8 | 3
COMPOUNDING SOLUTIONS LLC | Plastic | Strategic | 534976.036 | 16
CLONDALKIN PHARMA & HEALTHCARE | Packaging | Site Managed | 181676.81271 | 10
COMCO INCORPORATED |  | Site Managed | 43.06399999999999 | 1
CONTECH MEDICAL INCORPORATED |  | Strategic | 2256.8714 | 1
CONTROLLED POLYMERS |  | Site Managed | 2204.5 | 2
CORCORAN CHEMICALS |  | Site Managed | 1212 | 1
CONNAUGHT PACKAGING | Packaging | Site Managed | 161973.628 | 14
CREGANNA - TACTX MEDICAL | Metals | Strategic | 2647629.5 | 24
CRAFTED PLASTICS INCORPORATED |  | Site Managed | 5301.45 | 1
CREST ULTRASONICS |  | Site Managed | 244.99986 | 1
CT ELECTRIC |  | Site Managed | 0 | 1
DONATELLE PLASTICS INCORPORATE | Plastic | Site Managed | 84140 | 10
DIVERSIFIED INSTRUMENTS |  | Site Managed | 7588.875 | 1
DOW CORNING |  | Site Managed | 435.4427 | 1
DSM BIOMEDICAL INC |  | Site Managed | 6230 | 1
ECT |  | Site Managed | 19633.7682627 | 10
ELECTRICAL MECHANICAL CONTROLS |  | Site Managed | 4325 | 1
EVONIK INDUSTRIES AG |  | Site Managed | 108480 | 1
FANNIN HEALTHCARE LTD (EX LIP) | Other | Site Managed | 18007.5 | 1
FORT WAYNE METALS IRELAND LTD | Metals | Strategic | 3028623.51443736 | 4
FORT WAYNE METALS RESEARCH PRO | Metals | Strategic | 249281.6272099999 | 14
FOSTER CORPORATION | Plastic | Strategic | 548749.3774 | 26
PRENT CORPORATION | Packaging | Strategic | 115302.11336 | 4
FISHER SCIENTIFIC |  | Site Managed | 78516.384 | 4
HERAEUS MATERIALS | Metals | Strategic | 106352.6 | 1
HENKEL ELECTRONIC MATERIALS |  | Site Managed | 7831.440000000001 | 1
HETEROCHEM |  | Site Managed | 1323.994 | 1
HUDSON POLY BAG INCORPORATED | Other | Site Managed | 412.02 | 1
MALLINCKRODT INC | Packaging | Site Managed | 95919.593 | 2
IEPCO AG |  | Site Managed | 34409.9628 | 1
INDENA |  | Site Managed | 0 | 1
[NAME] MATTHEY | Metals | Strategic | 95179.07699999999 | 8
INNOVIZE SOLUTIONS |  | Site Managed | 4336.499999999999 | 2
LAKE REGION MEDICAL | Metals | Strategic | 199982.319 | 15
LAKE REGION MEDICAL INC USA | Metals | Strategic | 116158 | 2
LAMB KNITTING MACHINE COMPANY | Metals | Site Managed | 18839.52 | 1
Colorman (Ireland) Limited | Packaging | Site Managed | 80408 | 6
KUBO FORM AG |  | Site Managed | 14509.98341982 | 2
IMAGINE PRINT SOLUTIONS INC | Packaging | Strategic | 70442.4 | 1
LENNOX LABORATORIES |  | Site Managed | 164560.1344 | 49
LUMA METALL AB | Metals | Site Managed | 9644.890355099998 | 2
BEACON CONVERTERS INCORPORATED | Packaging | Site Managed | 46361.28000000001 | 1
MOORE WALLACE | Packaging | Strategic | 36001.43574999999 | 15
LAMINATED FILMS & PACKAGING | Packaging | Site Managed | 30041.46726 | 9
M&G POLYMERS US ALLC |  | Site Managed | 1445.664 | 1
MARKEM CONTINENTAL EUROPE BV |  | Site Managed | 1948.5342 | 1
LIMMATDRUCK AG | Packaging | Site Managed | 29157.516773616 | 2
MEDELEC MINIMECA SA | Metals | Site Managed | 18608.609337094 | 2
CORPORATE EXPRESS GLEN C | Packaging | Site Managed | 22958.4 | 2
MARTECH MEDICAL MDI |  | Site Managed | 1058.4 | 1
MICROLUMEN INCORPORATED |  | Strategic | 112964.74 | 3
[NAME] | Packaging | Site Managed | 12210.24 | 1
MINNESOTA RUBBER AND PLASTICS |  | Site Managed | 15481.5731 | 3
NAA |  | Site Managed | 37329.2 | 2
AMPAC FLEXIBLES | Packaging | Site Managed | 11812.32 | 2
NATIONAL CHEMICAL COMPANY |  | Site Managed | 160409.2755 | 18
OPTINOVA AB | Plastic | Strategic | 521068.4100000002 | 66
GOOD PRINTER INCORPORATED | Packaging | Site Managed | 8996.917999999998 | 1
NOVARTIS PHARMA AG BASEL |  | Site Managed | 500 | 1
PHILLIPS AND JOHNSTON INCORPOR |  | Site Managed | 2681 | 4
PK CHEMICALS LIMITED |  | Site Managed | 991 | 1
POLYMER SYSTEMS TECHNOLOGY LIM |  | Site Managed | 500319.0549987237 | 3
PRECISION WIRE COMPONENTS | Metals | Site Managed | 2058 | 1
W-S PACKAGING GROUP INC | Packaging | Strategic | 7635.00444 | 9
PRO TEK | Plastic | Site Managed | 2250857.408 | 59
[NAME] INCORPORATED |  | Site Managed | 25068.75 | 1
PROPPER MANUFACTURING COMPANY |  | Site Managed | 923.39856 | 1
PUTNAM PLASTICS CORPORATION |  | Site Managed | 40381.17999999999 | 3
RAYS EXTRUSION DIES AND TUBING |  | Site Managed | 26582.5 | 1
RESOURCE PLASTICS INCORPORATE |  | Site Managed | 25562.082 | 2
RICHMAN CHEMICAL INCORPORATED |  | Site Managed | 0 | 1
SAMAPLAST AG |  | Site Managed | 11723.064 | 3
SIGMA ALDRICH |  | Site Managed | 22633.797 | 2
SMC PNEUMATICS IRELAND LIMITED |  | Site Managed | 10295 | 2
SPECIALTY COATING SYSTEMS | Metals | Site Managed | 122086.692 | 15
MEDIPACK AG | Packaging | Site Managed | 5871.274104864 | 1
SVS INDUSTRIAL SUPPLIES LTD |  | Site Managed | 2361279.382819999 | 218
SVS USD ACCOUNT |  | Site Managed | 103725 | 5
T E LABORATORIES LTD |  | Site Managed | 140 | 1
TCL PLASTICS LTD |  | Site Managed | 21806 | 6
TECHNICAL INDUSTRIES INCORPORA |  | Site Managed | 41774.292 | 1
TEEL PLASTICS COMPANY INCORPOR |  | Site Managed | 32601.8 | 1
Tegra Medical |  | Site Managed | 7049.7 | 10
TELEFLEX MEDICAL |  | Strategic | 169224.634 | 3
TELEFLEX MEDICAL CV EVOLUTIONS |  | Strategic | 10096.57404 | 1
TFX MEDICAL WIRE PRODUCTS INC |  | Strategic | 745122 | 3
THE DOW CHEMICAL COMPANY |  | Strategic | 21973.28 | 3
THOMAS MEDICAL PRODUCTS |  | Site Managed | 6359.359999999999 | 2
TOOL & PLASTIC CO LTD |  | Site Managed | 43936.92 | 34
ULTRA POLYMERS IRELAND |  | Site Managed | 0 | 1
VELOX GMBH |  | Site Managed | 2247.41 | 3
VESTA |  | Site Managed | 134046.778376 | 5
VWR INTERNATIONAL LTD |  | Strategic | 385425.61196 | 20
WIPAK OY | Packaging | Site Managed | 3267 | 1
AMCOR FLEXIBLES INC | Packaging | Strategic | 2759.652 | 1
ADVANCED WEB TECHNOLOGIES LLC | Packaging | Site Managed | 1708.56 | 1
ZEUS INDUSTRIAL PRODUCTS | Plastic | Strategic | 387001.9510000001 | 75
ZEUS LETTERKENNY | Plastic | Strategic | 597199.74 | 36