Haha - that's the advantage of not having changed much in a year. The disadvantage is that it still has a lot of the big gaps that it had back then! The run up to Vegas is definitely development season...
Thanks Eric - and nice work on the live stream! Your maze macro looked pretty cool. There's something very satisfying about seeing it populate before your eyes : )
Thanks for the mention! The way you handled that time format was really impressive. I was also thinking about the percom lambda but I didn't save it. Might be one I add for next time. I think everything above the bottom locations was obvious from looking at the map so really you would only need to do the combinations of those bottom ones. I got to the step of having the grid with values of distance from every cell to every other cell but then just decided manually is easier! Just missed that taking the top one of the bottom set early was the way to go so that when you come up you just skirt around the edges of the wall. Makes so much sense now seeing the optimal order!
It’s a tough call with this kind of case - doing it rigorously is hard work, and tricky enough that you can’t be sure you’ll get it right (or done on time)… but if you do it on intuition, it’s easy to end up slightly off.
on the livestream I randomly guessed 150, 151, 100, and 101. But no luck... (bonus points on the livestream update manually so you can't put in guesses too quickly)
That was extraordinary to watch! You are so fluent with your lambda collection, it’s so cool to watch!
Haha - that's the advantage of not having changed much in a year. The disadvantage is that it still has a lot of the big gaps that it had back then! The run up to Vegas is definitely development season...
Very helpful as always! Thanks for sharing the other Excel Esports RUclipsrs too!
Thanks Eric - and nice work on the live stream! Your maze macro looked pretty cool. There's something very satisfying about seeing it populate before your eyes : )
42:19 that's incredibly impressive 😮
Thanks Ny!
Thanks for the mention! The way you handled that time format was really impressive. I was also thinking about the percom lambda but I didn't save it. Might be one I add for next time. I think everything above the bottom locations was obvious from looking at the map so really you would only need to do the combinations of those bottom ones. I got to the step of having the grid with values of distance from every cell to every other cell but then just decided manually is easier! Just missed that taking the top one of the bottom set early was the way to go so that when you come up you just skirt around the edges of the wall. Makes so much sense now seeing the optimal order!
It’s a tough call with this kind of case - doing it rigorously is hard work, and tricky enough that you can’t be sure you’ll get it right (or done on time)… but if you do it on intuition, it’s easy to end up slightly off.
Awesome content
always so fascinating, I wonder how you manage to delete spreadsheets using keyboard shortcuts because I've really searched but can't find it
I think it’s alt + EL (there’s probably a modern equivalent, but that’s a pre-ribbon shortcut I still use!)
The correct answer to BQ5 is indeed 113. Unfortunately, nobody managed to solve this bonus question within 30min.
I can't say I'm surprised, it was definitely a tough one!
on the livestream I randomly guessed 150, 151, 100, and 101. But no luck... (bonus points on the livestream update manually so you can't put in guesses too quickly)
Great case Emils!
Hello my friend 👋😄 📊📉💻
👋🏻