Great job with the solve! I really like how you used ABS to determine cells within a certain distance, and you have a pretty solid grasp on both LAMBDAs and VBA.
Nice walkthrough! Hope you found working out level 7 programtically fun! I wanted to write a case more about these kinds of flows but I couldn't think of a way to write it at a good difficulty level that would be fair to the different participants with their differing backgrounds
Indeed, level 7 was an interesting problem to work on, and while my solution scales nicely, I'm upset at myself for not recognizing the limited number of paths available and how much faster it would be to solve semi-manually.
I loved your L7 solution - totally different from mine (and any other I’ve seen so far), and very nicely explained. By the way, you can use ISNUMBER instead of NOT / ISNA for something like MATCH / SEARCH / FIND that will return a number or an error - it might save you a few seconds. Impressive to get this done in the time! (I don’t think I really did, since I did a lot of work on L7 from the intro video before time started.) (Sorry if this comes up as a double post… YT seems to have eaten my original comment!)
Thanks! I was nervous about whether my explanation would be intelligible or not. I definitely slowed down to make an effort on that front. As for time, prep time is legitimate. I'm envious you found a way to make good use of it. I spun myself in circles and ended up with nothing tangible of value by the time it was time to start.
@ That’s relatable. I’ve definitely had times where the prep time made me worse off - I didn’t just not add much, but I also wound myself up so I was less ready to go! On the other hand, once in a while it pays off big! : )
Great job with the solve! I really like how you used ABS to determine cells within a certain distance, and you have a pretty solid grasp on both LAMBDAs and VBA.
Great video!! 🎉🎉
Thank you!
Level 7 was awesome!
Nice walkthrough! Hope you found working out level 7 programtically fun! I wanted to write a case more about these kinds of flows but I couldn't think of a way to write it at a good difficulty level that would be fair to the different participants with their differing backgrounds
Indeed, level 7 was an interesting problem to work on, and while my solution scales nicely, I'm upset at myself for not recognizing the limited number of paths available and how much faster it would be to solve semi-manually.
I loved your L7 solution - totally different from mine (and any other I’ve seen so far), and very nicely explained.
By the way, you can use ISNUMBER instead of NOT / ISNA for something like MATCH / SEARCH / FIND that will return a number or an error - it might save you a few seconds.
Impressive to get this done in the time! (I don’t think I really did, since I did a lot of work on L7 from the intro video before time started.)
(Sorry if this comes up as a double post… YT seems to have eaten my original comment!)
Thanks! I was nervous about whether my explanation would be intelligible or not. I definitely slowed down to make an effort on that front.
As for time, prep time is legitimate. I'm envious you found a way to make good use of it. I spun myself in circles and ended up with nothing tangible of value by the time it was time to start.
@ That’s relatable. I’ve definitely had times where the prep time made me worse off - I didn’t just not add much, but I also wound myself up so I was less ready to go!
On the other hand, once in a while it pays off big! : )