Spreadsheet: 477397d1472271723-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: PM-Top Suppliers

 | [NAME] | Sum of Value of spend-FY16  (Rs Crore) | Total spend-FY 17E (Rs cr) | No. of SKUs | PM category | No. of SKUs procured by category | Total SKUs by category | No. of SKUs not procured in category |  | Value of spend procured | Total spend of category | Value of Category not procured
 | APT Packaging Limited. | 3.732211128879998 | 7.464422257759995 | 82 | Tube | 82 | 219 |  |  | #[NAME]! | #[NAME]!
 | B P Lipeds | 1.445831322 | 2.891662643999999 | 64 | MONOCARTON | 64 | 226 |  |  | #[NAME]! | #[NAME]!
 | CREATIVE GRAFIX | 0.5709958279999996 | 1.141991655999999 | 54 | Back Card | 5 | 15 |  |  | #[NAME]! | #[NAME]!
 | CREATIVE GRAFIX |  |  |  | LABEL/STKR | 8 | 531 |  |  | #[NAME]! | #[NAME]!
 | CREATIVE GRAFIX |  |  |  | LEAFLET | 2 | 46 |  |  | #[NAME]! | #[NAME]!
 | CREATIVE GRAFIX |  |  |  | MONOCARTON | 40 | 226 |  |  | #[NAME]! | #[NAME]!
 | Creative Stylo Packs Pvt. Ltd. | 3.59522072 | 7.190441440000001 | 94 | Tube | 94 | 219 |  |  | #[NAME]! | #[NAME]!
 | DIVINE | 0.4974577385440008 | 0.9949154770880015 | 30 | MISC | 3 | 21 |  |  | #[NAME]! | #[NAME]!
 | DIVINE |  |  |  | PVC Bag | 4 | 4 |  |  | #[NAME]! | #[NAME]!
 | DIVINE |  |  |  | SHRINK | 23 | 71 |  |  | #[NAME]! | #[NAME]!
 | Eon Plast Industries | 1.31635242128 | 2.632704842560001 | 21 | BOTTLE | 2 | 49 |  |  | #[NAME]! | #[NAME]!
 | Eon Plast Industries |  |  |  | CAP | 4 | 46 |  |  | #[NAME]! | #[NAME]!
 | Eon Plast Industries |  |  |  | JAR | 9 | 34 |  |  | #[NAME]! | #[NAME]!
 | Eon Plast Industries |  |  |  | [NAME] | 1 | 4 |  |  | #[NAME]! | #[NAME]!
 | Eon Plast Industries |  |  |  | Pump | 3 | 12 |  |  | #[NAME]! | #[NAME]!
 | Eon Plast Industries |  |  |  | SPOON | 2 | 5 |  |  | #[NAME]! | #[NAME]!
 | Essel Propack Limited | 1.59090900696 | 3.181818013920001 | 16 | Tube | 16 | 219 |  |  | #[NAME]! | #[NAME]!
 | Gargi Coated Papers  Pvt. Ltd. | 0.7268410676800008 | 1.453682135360002 | 121 | CFB-BOX | 121 | 255 |  |  | #[NAME]! | #[NAME]!
 | Harsh Beautycare & Packaging | 0.6355766871999992 | 1.271153374399998 | 89 | CFB-BOX | 89 | 255 |  |  | #[NAME]! | #[NAME]!
 | Innovative Group Fze | 0.6206550000000001 | 1.24131 | 14 | Container | 14 | 16 |  |  | #[NAME]! | #[NAME]!
 | [NAME]. Ltd. | 1.0350974065016 | 2.070194813003201 | 52 | LAMINATE | 52 | 59 |  |  | #[NAME]! | #[NAME]!
 | [NAME] | 0.7358774550400002 | 1.47175491008 | 105 | CFB-BOX | 105 | 255 |  |  | #[NAME]! | #[NAME]!
 | Nutech Packagings | 0.5380853099999999 | 1.07617062 | 22 | MONOCARTON | 22 | 226 |  |  | #[NAME]! | #[NAME]!
 | Parksons Packaging Ltd. | 0.7132100560000001 | 1.426420112 | 35 | MONOCARTON | 34 | 226 |  |  | #[NAME]! | #[NAME]!
 | Parksons Packaging Ltd. |  |  |  | [NAME] | 1 | 8 |  |  | #[NAME]! | #[NAME]!
 | [NAME] | 0.9553255920000004 | 1.910651184000001 | 57 | Back Card | 9 | 15 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | LABEL/STKR | 2 | 531 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | LEAFLET | 40 | 46 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | MONOCARTON | 6 | 226 |  |  | #[NAME]! | #[NAME]!
 | SSP Plastipack Pvt. Ltd. | 1.080062031079998 | 2.160124062159997 | 27 | BOTTLE | 9 | 49 |  |  | #[NAME]! | #[NAME]!
 | SSP Plastipack Pvt. Ltd. |  |  |  | CAP | 9 | 46 |  |  | #[NAME]! | #[NAME]!
 | SSP Plastipack Pvt. Ltd. |  |  |  | JAR | 4 | 34 |  |  | #[NAME]! | #[NAME]!
 | SSP Plastipack Pvt. Ltd. |  |  |  | [NAME] | 2 | 4 |  |  | #[NAME]! | #[NAME]!
 | SSP Plastipack Pvt. Ltd. |  |  |  | MISC | 3 | 21 |  |  | #[NAME]! | #[NAME]!
 | Syndicate Labels | 0.8786296520000015 | 1.757259304000003 | 181 | LABEL/STKR | 181 | 531 |  |  | #[NAME]! | #[NAME]!
 | [NAME] | 1.03313704 | 2.066274080000001 | 19 | BOTTLE | 4 | 49 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | CAP | 4 | 46 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | JAR | 6 | 34 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | [NAME] | 1 | 4 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | Pump | 3 | 12 |  |  | #[NAME]! | #[NAME]!
 | [NAME] |  |  |  | SPOON | 1 | 5 |  |  | #[NAME]! | #[NAME]!
 | Temple Packaging Pvt Ltd | 2.242295926000001 | 4.484591852000003 | 38 | LAMINATE | 1 | 59 |  |  | #[NAME]! | #[NAME]!
 | Temple Packaging Pvt Ltd |  |  |  | MONOCARTON | 37 | 226 |  |  | #[NAME]! | #[NAME]!
 | Vimal Plastics | 0.5420495199999997 | 1.084099039999999 | 22 | BOTTLE | 2 | 49 |  |  | #[NAME]! | #[NAME]!
 | Vimal Plastics |  |  |  | CAP | 9 | 46 |  |  | #[NAME]! | #[NAME]!
 | Vimal Plastics |  |  |  | JAR | 10 | 34 |  |  | #[NAME]! | #[NAME]!
 | Vimal Plastics |  |  |  | [NAME] | 1 | 4 |  |  | #[NAME]! | #[NAME]!
 | Weener Empire Plastics | 0.49018606 | 0.98037212 | 15 | BOTTLE | 8 | 49 |  |  | #[NAME]! | #[NAME]!
 | Weener Empire Plastics |  |  |  | CAP | 6 | 46 |  |  | #[NAME]! | #[NAME]!
 | Weener Empire Plastics |  |  |  | JAR | 1 | 34 |  |  | #[NAME]! | #[NAME]!