6:54 I love the The lookup table with &" with wine added" . That is simply clever and making everything more straightforward and efficient.

Really nice to see the many different and creative ways a problem can be solved (I would never think in solving problem 4 like that). I confess that I am really curious about the problem 5 solution, it's definitely out of my league. Would be really really nice if you could make one extra video showing the logic and trick you mentioned using iterative calc. It doesn't hurt to ask 😁 Thanks for the great work you guys are doing!

Thanks for using the case and kind words. I think this shows how you do have more time than you think. you did 4 levels at a relatively slow pace with reading all the questions and still have 4 minutes leftover. My plan for this year is to set aside the first 3 minutes just to read. Unless of course they are eliminating Someone every 5 minutes

Great to see a video on my favourite E-sport case. Even though it wasn't that succesfull on the day. Regarding 16:04 Do you know if this will bring you definetly points in this years Road to Las Vegas? Because in last years battles it was just the first three and all (based on the sum)

Thanks Dim, appreciate all the content will definitely review all these before I start this years FMWC.

Very clear as always🔥🔥

Thank you for the case and for the way to attack it. I admire the people who dealt with this problem in half an hour. It took me over 2 hours and I haven't finished yet. Reading the instructions is important, but given the time constraint, it's tempting to skim over them. Level 1, 2, 3: at first, I missed the fixed costs of a basket (the basket itself, picnic blanket, , napkins, etc.). Then, I thought that a bear only brought back one basket and not all the baskets (why? It seemed logical to me but it's not written anywhere). This wasted my time. Level 4: knowing whether a tourist is in a bear's territory took me a long time, with the transformation of references according to bear "ranges". A specific function had to be written. Level 5: that was the last straw! I don't see how a function can solve this problem, especially as the possible paths are very subtle. The case of position N7 is an interesting one. Two things had to be considered: - You need to maximize diagonal passages. - You need to see that you could "cut" into bear territory via N7>M7>L8 and then F14>G15 (25 mins, West path). The eastern route is longer. Following Diarmuid's advice in the video, we could also see that there were easy positions (D29,J29,K29,U28,U27,W27,G23,J20,I18,J16) which could earn easy 120 points. In short, I found the exercise exciting but incredibly difficult. Congratulations to those who managed to get through it in the allotted time. As for me, I'm far from being in that category.

I just had a try before coming to this video, ended up at 550. Your wine solution was nice, I made the mistake of just rushing into question 1 then 2 and so on without reading them first so had to go back and make a profit table. Ended up substituting " with wine added" for blanks in my lookups then having an if for wine add 40. Not very elegant. Also got tripped up for a good couple of minutes with the baskets costs. I think if I allowed more time I was on the way to question 4, did the same thing altering the map but didn't get to the indirect part. I should probably name the ranges too as scrolling up all the time for my lookups started to get annoying. Going to give it a go in this first round just for fun.

I've noticed that Excel 365 doesn't like handling emojis as well as regular excel. I was trying everything to get 365 to substitute the emoji, which it would outside of a dynamic array, but once inside an array, it started acting weird. My solution, copy the map into my regular excel and manipulate it there.