Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the Brand sheet and dataset provided, vlookup the Brand column into the Test Dataset sheet (column W). Please leave the live formula in the
- Using the Brand sheet and dataset provided, vlookup the Brand column into the Test Dataset sheet (column W). Please leave the live formula in the column.
 StoreID TradeChannel Region Date Product ID Product Description Product Category PackSize PackType Unit Price Facings_Cold Facings_Warm TotalFacings_Shop OpeningStock Stock_FridgeUnits TotalStock_Fridge Stock_FrontShopUnits Stock_StoreroomUnits TotalStock_Shop PurchaseUnits SalesVolume Sales Units Brand 335202 On Premise North Apr-21 463554 Guinness Smooth 500ml RGB Beer 500 RGB 700 4 0 4 108 20 20 18 0 38 60 65 130
335202 On Premise North Apr-21 463555 Guinness FES 650ml RGB Beer 650 RGB 1200 4 0 4 84 20 20 24 0 44 96 88.4 136
335202 On Premise North Apr-21 463556 Guinness FES 330ml RGB Beer 330 RGB 650 12 0 12 106 84 84 48 0 132 120 31.02 94
335202 On Premise North Apr-21 463557 Harp Premium Lager 600ml RGB Beer 600 RGB 700 3 0 3 96 15 15 24 0 39 111 100.8 168
335202 On Premise North Apr-21 463558 Orijin HAB 600ml RGB RTD 600 RGB 700 4 0 4 96 20 20 24 0 44 72 74.4 124
335202 On Premise North Apr-21 463559 Smirnoff Ice Double Black 330ml RGB RTD 330 RGB 650 3 0 3 60 18 18 36 0 54 48 17.82 54
335202 On Premise North Apr-21 463560 Smirnoff Ice Pineapple Punch 330ml RGB RTD 330 RGB 650 4 0 4 60 22 22 48 0 70 48 12.54 38
335202 On Premise North Apr-21 463592 Malta Guinness 330ml RGB CSD 330 RGB 500 0 0 0 48 24 24 24 0 48 48 15.84 48
335202 On Premise North Apr-21 463601 33 Export 500ml Can Beer 500 Can 700 0 0 0 60 10 10 18 0 28 36 34 68
335202 On Premise North Apr-21 463603 33 Export 650ml RGB Beer 650 RGB 650 4 0 4 72 24 24 18 0 42 60 58.5 90
335202 On Premise North Apr-21 463634 Bullet 250ml Can RTD 250 Can 900 2 0 2 48 8 8 0 0 8 48 22 88
335202 On Premise North Apr-21 463639 Castel 650ml RGB Beer 650 RGB 658 3 0 3 60 15 15 18 0 33 96 79.95 123
335202 On Premise North Apr-21 463648 Doppel 650ml RGB Beer 650 RGB 650 4 0 4 72 24 24 18 0 42 60 58.5 90
335202 On Premise North Apr-21 463663 Heineken 500ml Can Beer 500 Can 1000 1 0 1 48 5 5 0 0 5 48 45.5 91
335202 On Premise North Apr-21 463665 Heineken 330ml NRGB Beer 330 NRGB 800 0 0 0 48 6 6 0 0 6 24 21.78 66
335202 On Premise North Apr-21 463672 Isenbeck Pilsener 500ml Can Beer 500 Can 800 0 0 0 0 0 0 48 0 48 48 0 0
335202 On Premise North Apr-21 463673 Isenbeck Pilsener 650ml RGB Beer 650 RGB 750 5 0 5 96 25 25 28 0 53 96 90.35 139
335202 On Premise North Apr-21 463675 K44 500ml RGB Beer 500 RGB 500 2 0 2 96 12 12 16 0 28 48 58 116
335202 On Premise North Apr-21 463677 Kadji 650ml RGB Beer 650 RGB 650 6 0 6 96 35 35 48 0 83 216 148.85 229
335202 On Premise North Apr-21 463685 Manyan 650ml RGB Beer 650 RGB 500 5 0 5 120 26 26 36 0 62 132 123.5 190
335202 On Premise North Apr-21 463690 Mutzig 650ml RGB Beer 650 RGB 650 4 0
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
StoreID | TradeChannel | Region | Date | Product ID | Product Description | Product Category | PackSize | PackType | Unit Price | Facings_Cold | Facings_Warm | TotalFacings_Shop | OpeningStock | Stock_FridgeUnits | TotalStock_Fridge | Stock_FrontShopUnits | Stock_StoreroomUnits | TotalStock_Shop | PurchaseUnits | SalesVolume | Sales Units | Brand |
335202 | On Premise | North | Apr-21 | 463554 | Guinness Smooth 500ml RGB | Beer | 500 | RGB | 700 | 4 | 0 | 4 | 108 | 20 | 20 | 18 | 0 | 38 | 60 | 65 | 130 | |
335202 | On Premise | North | Apr-21 | 463555 | Guinness FES 650ml RGB | Beer | 650 | RGB | 1200 | 4 | 0 | 4 | 84 | 20 | 20 | 24 | 0 | 44 | 96 | 88.4 | 136 | |
335202 | On Premise | North | Apr-21 | 463556 | Guinness FES 330ml RGB | Beer | 330 | RGB | 650 | 12 | 0 | 12 | 106 | 84 | 84 | 48 | 0 | 132 | 120 | 31.02 | 94 | |
335202 | On Premise | North | Apr-21 | 463557 | Harp Premium Lager 600ml RGB | Beer | 600 | RGB | 700 | 3 | 0 | 3 | 96 | 15 | 15 | 24 | 0 | 39 | 111 | 100.8 | 168 | |
335202 | On Premise | North | Apr-21 | 463558 | Orijin HAB 600ml RGB | RTD | 600 | RGB | 700 | 4 | 0 | 4 | 96 | 20 | 20 | 24 | 0 | 44 | 72 | 74.4 | 124 | |
335202 | On Premise | North | Apr-21 | 463559 | Smirnoff Ice Double Black 330ml RGB | RTD | 330 | RGB | 650 | 3 | 0 | 3 | 60 | 18 | 18 | 36 | 0 | 54 | 48 | 17.82 | 54 | |
335202 | On Premise | North | Apr-21 | 463560 | Smirnoff Ice Pineapple Punch 330ml RGB | RTD | 330 | RGB | 650 | 4 | 0 | 4 | 60 | 22 | 22 | 48 | 0 | 70 | 48 | 12.54 | 38 | |
335202 | On Premise | North | Apr-21 | 463592 | Malta Guinness 330ml RGB | CSD | 330 | RGB | 500 | 0 | 0 | 0 | 48 | 24 | 24 | 24 | 0 | 48 | 48 | 15.84 | 48 | |
335202 | On Premise | North | Apr-21 | 463601 | 33 Export 500ml Can | Beer | 500 | Can | 700 | 0 | 0 | 0 | 60 | 10 | 10 | 18 | 0 | 28 | 36 | 34 | 68 | |
335202 | On Premise | North | Apr-21 | 463603 | 33 Export 650ml RGB | Beer | 650 | RGB | 650 | 4 | 0 | 4 | 72 | 24 | 24 | 18 | 0 | 42 | 60 | 58.5 | 90 | |
335202 | On Premise | North | Apr-21 | 463634 | Bullet 250ml Can | RTD | 250 | Can | 900 | 2 | 0 | 2 | 48 | 8 | 8 | 0 | 0 | 8 | 48 | 22 | 88 | |
335202 | On Premise | North | Apr-21 | 463639 | Castel 650ml RGB | Beer | 650 | RGB | 658 | 3 | 0 | 3 | 60 | 15 | 15 | 18 | 0 | 33 | 96 | 79.95 | 123 | |
335202 | On Premise | North | Apr-21 | 463648 | Doppel 650ml RGB | Beer | 650 | RGB | 650 | 4 | 0 | 4 | 72 | 24 | 24 | 18 | 0 | 42 | 60 | 58.5 | 90 | |
335202 | On Premise | North | Apr-21 | 463663 | Heineken 500ml Can | Beer | 500 | Can | 1000 | 1 | 0 | 1 | 48 | 5 | 5 | 0 | 0 | 5 | 48 | 45.5 | 91 | |
335202 | On Premise | North | Apr-21 | 463665 | Heineken 330ml NRGB | Beer | 330 | NRGB | 800 | 0 | 0 | 0 | 48 | 6 | 6 | 0 | 0 | 6 | 24 | 21.78 | 66 | |
335202 | On Premise | North | Apr-21 | 463672 | Isenbeck Pilsener 500ml Can | Beer | 500 | Can | 800 | 0 | 0 | 0 | 0 | 0 | 0 | 48 | 0 | 48 | 48 | 0 | 0 | |
335202 | On Premise | North | Apr-21 | 463673 | Isenbeck Pilsener 650ml RGB | Beer | 650 | RGB | 750 | 5 | 0 | 5 | 96 | 25 | 25 | 28 | 0 | 53 | 96 | 90.35 | 139 | |
335202 | On Premise | North | Apr-21 | 463675 | K44 500ml RGB | Beer | 500 | RGB | 500 | 2 | 0 | 2 | 96 | 12 | 12 | 16 | 0 | 28 | 48 | 58 | 116 | |
335202 | On Premise | North | Apr-21 | 463677 | Kadji 650ml RGB | Beer | 650 | RGB | 650 | 6 | 0 | 6 | 96 | 35 | 35 | 48 | 0 | 83 | 216 | 148.85 | 229 | |
335202 | On Premise | North | Apr-21 | 463685 | Manyan 650ml RGB | Beer | 650 | RGB | 500 | 5 | 0 | 5 | 120 | 26 | 26 | 36 | 0 | 62 | 132 | 123.5 | 190 | |
335202 | On Premise | North | Apr-21 | 463690 | Mutzig 650ml RGB | Beer | 650 | RGB | 650 | 4 | 0 |
Step by Step SolutionThere are 3 Steps involved in it Step: 1Get Instant Access with AI-Powered SolutionsSee step-by-step solutions with expert insights and AI powered tools for academic success Step: 2Step: 3Ace Your Homework with AIGet the answers you need in no time with our AI-driven, step-by-step assistance Get Started |