Spreadsheet: 539723d1506349070-defined-names-formula-from-sheet-1-to-sheet2-testdefinenames1
Sheet: NODEFINES NAMES 

Tariff No | Description | Origin | Qty_1 | Litres | Sugar | Amount | Count
20087000 | PEACHES IN SYRUP | ZA |  |  |  | 13.8 | Unique
20089700 | MIXED FRUITS | ZA |  |  |  | 13.6 | Unique
20092900 | RUBY/GRAPE JUICE | ZA | 120 | 120 | 11400 | 129.6 | Unique
20096990 | JUICES | ZA | 48 | 9.600000000000001 | 1296 | 14.88 | Unique
20098900 | FRUIT JUICE | ZA | 72 | 72 | 7559.999999999999 | 64.8 | Unique
20098900 | FRUIT JUICE | ZA | 48 | 9.600000000000001 | 1171.2 | 14.88 | Unique
20098900 | FRUIT JUICE | ZA | 216 | 43.2 | 4579.200000000001 | 66.96 | Unique
20098900 | FRUIT JUICE | ZA | 24 | 4.800000000000001 | 518.4000000000001 | 7.44 | Unique
20099000 | FRUIT JUICE MIXTURES | ZA | 12 | 12 | 1596 | 12.96 | Unique
21041000 | SOUPS PREPARATIONS | ZA |  |  |  | 43.2 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 76.80000000000001 | 4.44 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 80.4 | 4.44 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 75.6 | 4.44 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 74.4 | 4.44 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 80.4 | 4.44 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 76.80000000000001 | 4.44 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 10 | 50 | 64 | 14.9 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 6 | 30 | 39 | 8.94 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 4 | 20 | 26.8 | 5.96 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 15 | 186 | 8.52 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 15 | 337.2 | 8.52 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 15 | 201.6 | 8.52 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 15 | 200.4 | 8.52 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 15 | 198 | 8.52 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 6 | 7.5 | 92.99999999999999 | 4.26 | Unique
21069070 | JUICE  CONCENTRATE | ZA | 12 | 12 | 80.4 | 4.44 | Dupl
21069070 | NECTAR | ZA | 10 | 50 | 64 | 14.9 | Unique
21069070 | NECTAR | ZA | 12 | 12 | 206.4 | 8.04 | Unique
21069070 | NECTAR | ZA | 12 | 12 | 200.4 | 8.04 | Unique
21069070 | NECTAR | ZA | 12 | 12 | 186 | 8.04 | Unique
21069070 | NECTAR | ZA | 12 | 12 | 198 | 8.04 | Unique
21069070 | NECTAR | ZA | 12 | 12 | 186 | 8.04 | Unique
21069070 | NECTAR | ZA | 12 | 12 | 80.4 | 4.44 | Unique
17041090 | SUGAR FREE GUMS | ZA |  |  |  | 17.5 | Unique
17041090 | SUGAR FREE GUMS | ZA |  |  |  | 18.24 | Unique
21069090 | JELLY PREPARATIONS | ZA |  |  |  | 8.64 | Unique
21069090 | JELLY PREPARATIONS | ZA |  |  |  | 8.64 | Unique
21069090 | JELLY PREPARATIONS | ZA |  |  |  | 8.64 | Unique
21069090 | JELLY PREPARATIONS | ZA |  |  |  | 8.64 | Unique
21069090 | JELLY PREPARATIONS | ZA |  |  |  | 8.64 | Unique
21069090 | JELLY PREPARATIONS | ZA |  |  |  | 8.64 | Unique
21069090 | SWEETENERS | ZA |  |  |  | 15.24 | Unique
22021010 | AERATED WATER | ZA | 168 | 33.6 | 1646.4 | 36.96 | Unique
22021010 | AERATED WATER | ZA | 144 | 28.8 | 547.1999999999999 | 31.68 | Unique
22021010 | AERRATED DRINKS | ZA | 6 | 12 | 13.09090909090908 | 3.24 | Unique
22021010 | ALOE VERA JUICES | TW | 48 | 24 | 5376 | 23.52 | Unique
22021010 | ENERGY DRINKS | ZA | 16 | 8 | 816 | 14.24 | Unique
22021010 | ENERGY DRINKS | ZA | 12 | 12 | 1224 | 17.4 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 20.34 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 17.22 | Unique
22042190 | WINES | ZA | 12 | 9 |  | 42.24 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 13.14 | Unique
22021020 | CANNED  DRINKS | ZA | 24 | 7.92 | 298.8 | 5.52 | Unique
22021020 | CANNED  DRINKS | ZA | 24 | 7.92 | 298.8 | 5.52 | Unique
22021020 | CANNED  DRINKS | ZA | 72 | 23.76 | 896.4000000000001 | 16.56 | Unique
22021020 | CANNED  DRINKS | ZA | 72 | 14.4 | 28.08 | 15.84 | Unique
22021020 | [NAME] | ZA | 120 | 24 | 1122 | 26.4 | Unique
22029910 | SOYA MILK | ZA | 24 | 24 | 648 | 22.08 | Unique
22029930 | FRUITS DRINKS | ZA | 8 | 40 | 1280 | 17.2 | Unique
22029930 | FRUITS DRINKS | ZA | 14 | 70 | 2240 | 30.1 | Unique
22029930 | FRUITS DRINKS | ZA | 6 | 30 | 960 | 12.9 | Unique
22029970 | MILK BEVERAGES | ZA | 48 | 9.600000000000001 | 960.0000000000002 | 15.36 | Unique
22042190 | WINES | PT | 12 | 9 |  | 24.12 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 10.74 | Unique
22042190 | WINES | ZA | 24 | 18 |  | 61.92 | Unique
22042190 | WINES | ZA | 12 | 9 |  | 28.68 | Unique
22042190 | WINES | ZA | 60 | 90 |  | 165 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 13.5 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 20.82 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 36.18 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 59.04 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 10.8 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 22.26 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 12.48 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 12.48 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 12.42 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 20.82 | Unique
22042190 | WINES | ZA | 12 | 9 |  | 22.56 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 15.78 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 13.38 | Unique
22042190 | WINES | ZA | 12 | 12 |  | 17.28 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 15.78 | Unique
22042190 | WINES | ZA | 6 | 4.5 |  | 12.6 | Unique
22090010 | VINEGAR | ZA | 12 | 6 |  | 17.76 | Unique
25010011 | SALT PREPARATION | ZA |  |  |  | 7 | Unique
25010011 | SALT PREPARATION | ZA |  |  |  | 39.36 | Unique
30051000 | ADHESIVE PLASTER | ZA |  |  |  | 7.8 | Unique
30051000 | ADHESIVE PLASTER | ZA |  |  |  | 13.92 | Unique
30051000 | ADHESIVE PLASTER | ZA |  |  |  | 7.8 | Dupl
30051000 | ADHESIVE PLASTER | ZA |  |  |  | 16 | Unique
33079010 | BABY WIPES SCENTED | ZA |  |  |  | 139.04 | Unique