MEWC
FMWC
TAC
EEO
TASK
Somehow you got a job as a sommelier, a well trained and extremely knowledgeable wine professional, at the most popular spreadsheet themed wine bar in the world, the Excellar Wine Bar! Sadly, you know nothing about wine but are very good with Excel. To assist in your new job, you have created a list of the most frequent customers and their desired wine attributes (found on the “Customers” tab) as well as the most popular wines and their attributes (found on the “Wines” tab).
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
This video was recorded when Diarmuid competed this case as part of the Road to Las Vegas battle.
Note that he used some pre-written macros and LAMBDAs, as well as some pretty advanced techniques… so this won’t be easiest solve to follow.
He wrote a few simple LAMBDAs in the time between getting access to the video and needing to start the case.
Those were:
- cust (given a customer, returns either all their attributes, or the given attribute (optional second argument): =LAMBDA(cust,[att],INDEX(catt,XMATCH(cust,cNm),IF(ISOMITTED(att),SEQUENCE(,COLUMNS(attNm)),XMATCH(att,attNm))))
- wine (basically the same, but for wines instead of customers): =LAMBDA(wine,[att],INDEX(watt,XMATCH(wine,wNm),IF(ISOMITTED(att),SEQUENCE(,COLUMNS(attNm)),XMATCH(att,attNm))))
- winePr (return the prices of a given range of wines – he didn’t end up using this one) =LAMBDA(wine,XLOOKUP(wine,wNm,wpr))
These relied on creating a few named ranges: cNm / wNm / attNm for the names of the customers / wines / attributes, catt / watt for the grids of customer and wine attributes, and wpr for the wine price.
WALKTHROUGH VIDEO PROVIDED BY ANDREW NGAI
Andrew attempted this after the actual battle, and while he tried to do it under “live” conditions, he couldn’t avoid seeing some information via social media.
WALKTHROUGH VIDEO PROVIDED BY LORENZO FOTI
LIVE BATTLE WITH FOUR PARTICIPANTS
The same case was featured in MEWC Road to Las Vegas 2024 Battle II. Here is a recording of live battle where four participants were working on solving this case:
- Sergio Trifletti (Italy)
- Katelyn Stenen (USA)
- Jason Webber (South Africa)
- Anders Richter Lindén (Denmark)
The game was hosted by Patrick Chatain and Jordan Goldmeier.