Spreadsheet: 475007d1471015271-index-match-formula-based-on-4-criterias-indexmatch-issue
Sheet: Overview FCST-Sales per Brand

 |  |  | date | (Multiple Items)
 |  |  | Rf | (All)
 |  |  | Usage | (Multiple Items) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actuals | FCST | Actuals | FCST | Actuals | FCST | Actuals | FCST | Actuals | FCST | Actuals | FCST
 |  |  | ACTUALS |  |  |  |  |  |  |  |  |  |  |  | FCST
 |  |  | Sum of Volumes |  |  | Week# |  |  |  |  |  |  |  |  |  |  |  | Values
 |  |  | Brand | Bottle type | Format | 31 | 32 | 33 | 34 | 35 | Grand Total |  |  |  | Brand | Bottle type | Format | Sum of W32.2016 | Sum of W33.2016 | Sum of W34.2016 | Sum of W35.2016
 |  |  | [NAME] | PET | 0.5 | 48 | 24.47999999999999 | 3.6 | 20.88 | 83.52 | 180.48 |  |  |  | [NAME] | PET | 0.33 | 4.336 | 3.128000000000001 | 26.669 | 1.197
 |  |  | [NAME] | PET | 0.75 | 1.485 | 1.98 |  |  |  | 3.465 |  |  |  | [NAME] | PET | 0.5 | 13.801 | 13.327 | 70.88799999999999 | 5.948000000000002
 |  |  | [NAME] | PET | 1 | 130.2000000000001 | 183.7200000000001 | 51.24000000000001 | 28.56 | 1.68 | 395.4000000000001 |  |  |  | [NAME] | PET | 1 | 66.577 | 80.33 | 70.62899999999999 | 58.126
 |  |  | [NAME] | VC | 0.5 | 2.4 |  |  |  |  | 2.4 |  |  |  | [NAME] | PET | 1.5 | 0 | 0 | 0 | 0
 |  |  | [NAME] | VC | 1 | 1.8 | 5.399999999999999 |  |  |  | 7.199999999999999 |  |  |  | [NAME] | VC | 0.5 | 1.362 | 1.092 | 1.362 | 0.8200000000000001
 |  |  | [NAME] | VP | 0.33 | 1.386 | 2.772 |  |  |  | 4.158 |  |  |  | [NAME] | VC | 1 | 2.726 | 2.182 | 2.726 | 1.638
 |  |  | [NAME] | VP | 0.75 | 1.98 | 0.99 |  |  |  | 2.97 |  |  |  | [NAME] | VP | 0.33 | 1.697 | 1.358 | 1.697 | 1.018
 |  |  | Eclat | PET | 0.33 | 83.54015999999999 | 52.16112 | 55.36079999999999 | 58.06944 |  | 249.13152 |  |  |  | [NAME] | VP | 0.75 | 3.159 | 2.527 | 3.159 | 1.896
 |  |  | Eclat | PET | 0.5 | 201.2519999999999 | 181.842 | 78.60600000000001 | 16.578 | 4.725 | 483.0029999999999 |  |  |  | [NAME] | VP | 1 | 0 | 0 | 0 | 0
 |  |  | Eclat | PET | 0.75 | 79.938 | 49.914 | 10.89 | 4.86 |  | 145.602 |  |  |  | Eclat | PET | 0.2 | 0 | 0 | 0 | 0
 |  |  | Eclat | PET | 1 | 608.8800000000001 | 382.3199999999999 | 87.36000000000003 | 3.36 |  | 1081.92 |  |  |  | Eclat | PET | 0.33 | 96.10400000000001 | 94.77700000000002 | 67.36399999999998 | 40.54000000000001
 |  |  | Eclat | PET | 1.25 | 23.04 | 81.48 |  |  |  | 104.52 |  |  |  | Eclat | PET | 0.37 | 0 | 0 | 0 | 0
 |  |  | Eclat | PET | 1.5 | 541.296 | 406.134 | 57.45599999999999 | 16.128 | 4.032 | 1025.046 |  |  |  | Eclat | PET | 0.5 | 211.663 | 188.274 | 267.0059999999999 | 125.502
 |  |  | Eclat | PET | 2 | 270.336 | 224.928 | 277.728 |  |  | 772.992 |  |  |  | Eclat | PET | 0.75 | 60.75399999999999 | 53.869 | 71.286 | 35.702
 |  |  | Eclat | VC | 1 | 19.2 | 52.8 |  |  |  | 72 |  |  |  | Eclat | PET | 1 | 382.1830000000001 | 270.234 | 506.7570000000001 | 218.779
 |  |  | Eclat | VP | 0.33 | 2.541 | 2.0328 |  |  |  | 4.5738 |  |  |  | Eclat | PET | 1.25 | 39.909 | 9.481 | 10.659 | 85.09600000000002
 |  |  | Eclat | VP | 0.75 | 1.98 | 6.930000000000001 |  |  |  | 8.91 |  |  |  | Eclat | PET | 1.5 | 553.617 | 435.375 | 1124.652 | 305.016
 |  |  | Vulcain | PET | 1.5 | 38.592 | 91.8 | 24.192 | 3.024 | 2.016 | 159.624 |  |  |  | Eclat | PET | 2 | 293.182 | 190.548 | 238.182 | 152.505
 |  |  | Vulcain | PET | 8 | 18.768 | 42.432 | 2.448 | 0.816 | 0.816 | 65.28 |  |  |  | Eclat | VC | 0.5 | 1.363 | 1.091 | 1.363 | 0.8200000000000001
 |  |  | Grand Total |  |  | 2076.61416 | 1794.11592 | 648.8807999999999 | 152.27544 | 96.789 | 4768.67532 |  |  |  | Eclat | VC | 1 | 36.815 | 29.454 | 36.817 | 22.094
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eclat | VP | 0.33 | 1.382 | 1.106 | 1.382 | 0.83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Eclat | VP | 0.75 | 4.738 | 3.791 | 4.739 | 2.843
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vulcain | PET | 0.5 | 0.454 | 0.364 | 0.454 | 0.273
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vulcain | PET | 1.5 | 23.33699999999999 | 21.44100000000001 | 26.71799999999999 | 83.49700000000003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vulcain | PET | 8 | 19.468 | 15.343 | 19.75 | 10.935
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | 1818.627 | 1419.092 | 2554.259 | 1155.075