Spreadsheet: 182472d1348497647-vlookup-problem-category-summaries
Sheet: Raw data

Metals | ACCELLENT CARDIOLOGY GALWAY | Strategic | 2433585.044700001 | 81 | 3480026.613921001
Metals | ACCELLENT CARDIOLOGY/ARVADA | Strategic | 280.2449999999999 | 2 | 400.7503499999999
Metals | ACCELLENT CARDIOLOGY/SALEM | Strategic | 1278012.2117 | 34 | 1827557.462731
Metals | ACCELLENT CARDIOLOGY/TRENTON | Strategic | 0 | 3 | 0
Metals | ACCELLENT ENDOSCOPY | Strategic | 0 | 1 | 0
Other | ANGIOTECH | Site Managed | 25778.515 | 2 | 36863.27644999999
Packaging | CHESAPEAKE | Strategic | 973469.8115 | 105 | 1392061.830445
Other | ANOPOL LIMITED | Site Managed | 1933.32 | 1 | 2764.647599999999
Packaging | PERFECSEAL LIMITED | Strategic | 639759.1207999999 | 18 | 914855.5427439999
Packaging | MEADWESTVACO HEALTHCARE PACKAG | Strategic | 551668 | 29 | 788885.24
Packaging | AMCOR FLEXIBLES SLIGO LIMITED | Strategic | 432000 | 1 | 617760
Other | SCHLOTTER IRELAND | Site Managed | 207700.8 | 4 | 297012.144
 | ADVANCED POLYMERS INCORPORATED | Site Managed | 31788.5001 | 2 | 45457.555143
Plastic | ADVANT MEDICAL LTD | Strategic | 389628.3479999999 | 11 | 557168.5376399999
 | ANSAMED LIMITED | Site Managed | 245204 | 7 | 350641.72
Metals | APPLIED PLASTICS COMPANY | Site Managed | 105271.824 | 12 | 150538.7083199999
Plastic | AVICENNA TECHNOLOGY INCORPORAT | Site Managed | 627999.744 | 9 | 898039.6339199999
 | APEX MEDICAL TECHNOLOGIES | Site Managed | 160018.6 | 16 | 228826.598
 | AZELIS UK LIFE SCIENCES LIMITE | Site Managed | 55518.6 | 4 | 79391.598
Packaging | YORK TAPE & LABEL LLC | Strategic | 350056.8703485001 | 16 | 500581.3245983551
 | BAYER MATERIAL SCIENCE AG | Site Managed | 195300 | 2 | 279278.9999999999
 | BRENNAN AND COMPANY | Site Managed | 3520 | 1 | 5033.599999999999
 | BRENNTAG CHEMICALS DISTRIBUTIO | Site Managed | 107438.72 | 3 | 153637.3696
 | BURDICK AND JACKSON | Site Managed | 10342.502 | 1 | 14789.77786
Metals | CALIFORNIA FINE WIRE COMPANY | Site Managed | 1170.96 | 1 | 1674.4728
Metals | CARAGH PRECISION | Site Managed | 363673.62 | 46 | 520053.2766
Packaging | NELIPAK THERMOFORMING IRELAND | Strategic | 342057.04 | 15 | 489141.5671999999
 | CABLE ACCESSORIES LIMITED | Strategic | 54956.630776 | 10 | 78587.98200968
Packaging | STERIPACK LIMITED | Strategic | 268382.286 | 40 | 383786.66898
 | CLASSIC TECHNOLOGY LIMITED | Site Managed | 17740.8 | 1 | 25369.344
Packaging | MANGAR INDUSTRIES INCORPORATED | Strategic | 185353.25697 | 7 | 265055.1574671
 | CODICO DISTRIBUTORS LIMITED | Site Managed | 5666.8 | 3 | 8103.524
Plastic | COMPOUNDING SOLUTIONS LLC | Strategic | 534976.036 | 16 | 765015.73148
Packaging | CLONDALKIN PHARMA & HEALTHCARE | Site Managed | 181676.81271 | 10 | 259797.8421753
 | COMCO INCORPORATED | Site Managed | 43.06399999999999 | 1 | 61.58151999999999
 | CONTECH MEDICAL INCORPORATED | Strategic | 2256.8714 | 1 | 3227.326102
 | CONTROLLED POLYMERS | Site Managed | 2204.5 | 2 | 3152.435
 | CORCORAN CHEMICALS | Site Managed | 1212 | 1 | 1733.16
Packaging | CONNAUGHT PACKAGING | Site Managed | 161973.628 | 14 | 231622.28804
Metals | CREGANNA - TACTX MEDICAL | Strategic | 2647629.5 | 24 | 3786110.185000001
 | CRAFTED PLASTICS INCORPORATED | Site Managed | 5301.45 | 1 | 7581.0735
 | CREST ULTRASONICS | Site Managed | 244.99986 | 1 | 350.3497998
 | CT ELECTRIC | Site Managed | 0 | 1 | 0
Plastic | DONATELLE PLASTICS INCORPORATE | Site Managed | 84140 | 10 | 120320.2
 | DIVERSIFIED INSTRUMENTS | Site Managed | 7588.875 | 1 | 10852.09125
 | DOW CORNING | Site Managed | 435.4427 | 1 | 622.683061
 | DSM BIOMEDICAL INC | Site Managed | 6230 | 1 | 8908.9
 | ECT | Site Managed | 19633.7682627 | 10 | 28076.28861566099
 | ELECTRICAL MECHANICAL CONTROLS | Site Managed | 4325 | 1 | 6184.75
 | EVONIK INDUSTRIES AG | Site Managed | 108480 | 1 | 155126.4
Other | FANNIN HEALTHCARE LTD (EX LIP) | Site Managed | 18007.5 | 1 | 25750.725
Metals | FORT WAYNE METALS IRELAND LTD | Strategic | 3028623.51443736 | 4 | 4330931.625645424
Metals | FORT WAYNE METALS RESEARCH PRO | Strategic | 249281.6272099999 | 14 | 356472.7269102999
Plastic | FOSTER CORPORATION | Strategic | 548749.3774 | 26 | 784711.609682
Packaging | PRENT CORPORATION | Strategic | 115302.11336 | 4 | 164882.0221048
 | FISHER SCIENTIFIC | Site Managed | 78516.384 | 4 | 112278.42912
Metals | HERAEUS MATERIALS | Strategic | 106352.6 | 1 | 152084.218
 | HENKEL ELECTRONIC MATERIALS | Site Managed | 7831.440000000001 | 1 | 11198.9592
 | HETEROCHEM | Site Managed | 1323.994 | 1 | 1893.31142
Other | HUDSON POLY BAG INCORPORATED | Site Managed | 412.02 | 1 | 589.1886
Packaging | MALLINCKRODT INC | Site Managed | 95919.593 | 2 | 137165.01799
 | IEPCO AG | Site Managed | 34409.9628 | 1 | 49206.246804
 | INDENA | Site Managed | 0 | 1 | 0
Metals | [NAME] MATTHEY | Strategic | 95179.07699999999 | 8 | 136106.08011
 | INNOVIZE SOLUTIONS | Site Managed | 4336.499999999999 | 2 | 6201.194999999999
Metals | LAKE REGION MEDICAL | Strategic | 199982.319 | 15 | 285974.71617
Metals | LAKE REGION MEDICAL INC USA | Strategic | 116158 | 2 | 166105.94
Metals | LAMB KNITTING MACHINE COMPANY | Site Managed | 18839.52 | 1 | 26940.5136
Packaging | Colorman (Ireland) Limited | Site Managed | 80408 | 6 | 114983.44
 | KUBO FORM AG | Site Managed | 14509.98341982 | 2 | 20749.2762903426
Packaging | IMAGINE PRINT SOLUTIONS INC | Strategic | 70442.4 | 1 | 100732.632
 | LENNOX LABORATORIES | Site Managed | 164560.1344 | 49 | 235320.992192
Metals | LUMA METALL AB | Site Managed | 9644.890355099998 | 2 | 13792.193207793
Packaging | BEACON CONVERTERS INCORPORATED | Site Managed | 46361.28000000001 | 1 | 66296.63040000001
Packaging | MOORE WALLACE | Strategic | 36001.43574999999 | 15 | 51482.05312249998
Packaging | LAMINATED FILMS & PACKAGING | Site Managed | 30041.46726 | 9 | 42959.2981818
 | M&G POLYMERS US ALLC | Site Managed | 1445.664 | 1 | 2067.29952
 | MARKEM CONTINENTAL EUROPE BV | Site Managed | 1948.5342 | 1 | 2786.403906
Packaging | LIMMATDRUCK AG | Site Managed | 29157.516773616 | 2 | 41695.24898627088
Metals | MEDELEC MINIMECA SA | Site Managed | 18608.609337094 | 2 | 26610.31135204442
Packaging | CORPORATE EXPRESS GLEN C | Site Managed | 22958.4 | 2 | 32830.512
 | MARTECH MEDICAL MDI | Site Managed | 1058.4 | 1 | 1513.512
 | MICROLUMEN INCORPORATED | Strategic | 112964.74 | 3 | 161539.5782
Packaging | [NAME] | Site Managed | 12210.24 | 1 | 17460.64319999999
 | MINNESOTA RUBBER AND PLASTICS | Site Managed | 15481.5731 | 3 | 22138.649533
 | NAA | Site Managed | 37329.2 | 2 | 53380.75599999999
Packaging | AMPAC FLEXIBLES | Site Managed | 11812.32 | 2 | 16891.6176
 | NATIONAL CHEMICAL COMPANY | Site Managed | 160409.2755 | 18 | 229385.263965
Plastic | OPTINOVA AB | Strategic | 521068.4100000002 | 66 | 745127.8263000003
Packaging | GOOD PRINTER INCORPORATED | Site Managed | 8996.917999999998 | 1 | 12865.59274
 | NOVARTIS PHARMA AG BASEL | Site Managed | 500 | 1 | 715
 | PHILLIPS AND JOHNSTON INCORPOR | Site Managed | 2681 | 4 | 3833.83
 | PK CHEMICALS LIMITED | Site Managed | 991 | 1 | 1417.13
 | POLYMER SYSTEMS TECHNOLOGY LIM | Site Managed | 500319.0549987237 | 3 | 715456.2486481748
Metals | PRECISION WIRE COMPONENTS | Site Managed | 2058 | 1 | 2942.94
Packaging | W-S PACKAGING GROUP INC | Strategic | 7635.00444 | 9 | 10918.0563492
Plastic | PRO TEK | Site Managed | 2250857.408 | 59 | 3218726.09344
 | [NAME] INCORPORATED | Site Managed | 25068.75 | 1 | 35848.3125
 | PROPPER MANUFACTURING COMPANY | Site Managed | 923.39856 | 1 | 1320.4599408
 | PUTNAM PLASTICS CORPORATION | Site Managed | 40381.17999999999 | 3 | 57745.08739999999
 | RAYS EXTRUSION DIES AND TUBING | Site Managed | 26582.5 | 1 | 38012.975
 | RESOURCE PLASTICS INCORPORATE | Site Managed | 25562.082 | 2 | 36553.77726
 | RICHMAN CHEMICAL INCORPORATED | Site Managed | 0 | 1 | 0
 | SAMAPLAST AG | Site Managed | 11723.064 | 3 | 16763.98152
 | SIGMA ALDRICH | Site Managed | 22633.797 | 2 | 32366.32971
 | SMC PNEUMATICS IRELAND LIMITED | Site Managed | 10295 | 2 | 14721.85
Metals | SPECIALTY COATING SYSTEMS | Site Managed | 122086.692 | 15 | 174583.96956
Packaging | MEDIPACK AG | Site Managed | 5871.274104864 | 1 | 8395.92196995552
 | SVS INDUSTRIAL SUPPLIES LTD | Site Managed | 2361279.382819999 | 218 | 3376629.517432599
 | SVS USD ACCOUNT | Site Managed | 103725 | 5 | 148326.75
 | T E LABORATORIES LTD | Site Managed | 140 | 1 | 200.2
 | TCL PLASTICS LTD | Site Managed | 21806 | 6 | 31182.58
 | TECHNICAL INDUSTRIES INCORPORA | Site Managed | 41774.292 | 1 | 59737.23756
 | TEEL PLASTICS COMPANY INCORPOR | Site Managed | 32601.8 | 1 | 46620.574
 | Tegra Medical | Site Managed | 7049.7 | 10 | 10081.071
 | TELEFLEX MEDICAL | Strategic | 169224.634 | 3 | 241991.22662
 | TELEFLEX MEDICAL CV EVOLUTIONS | Strategic | 10096.57404 | 1 | 14438.1008772
 | TFX MEDICAL WIRE PRODUCTS INC | Strategic | 745122 | 3 | 1065524.46
 | THE DOW CHEMICAL COMPANY | Strategic | 21973.28 | 3 | 31421.7904
 | THOMAS MEDICAL PRODUCTS | Site Managed | 6359.359999999999 | 2 | 9093.884799999998
 | TOOL & PLASTIC CO LTD | Site Managed | 43936.92 | 34 | 62829.7956
 | ULTRA POLYMERS IRELAND | Site Managed | 0 | 1 | 0
 | VELOX GMBH | Site Managed | 2247.41 | 3 | 3213.7963
 | VESTA | Site Managed | 134046.778376 | 5 | 191686.8930776799
 | VWR INTERNATIONAL LTD | Strategic | 385425.61196 | 20 | 551158.6251027999
Packaging | WIPAK OY | Site Managed | 3267 | 1 | 4671.809999999999
Packaging | AMCOR FLEXIBLES INC | Strategic | 2759.652 | 1 | 3946.30236
Packaging | ADVANCED WEB TECHNOLOGIES LLC | Site Managed | 1708.56 | 1 | 2443.2408
Plastic | ZEUS INDUSTRIAL PRODUCTS | Strategic | 387001.9510000001 | 75 | 553412.7899300001
Plastic | ZEUS LETTERKENNY | Strategic | 597199.74 | 36 | 853995.6281999999