Like Lorenzo, I'm first going to do it without a clock, then check out this video. So happy that within 40 seconds you made the inventory a table (so did I, can't understand why someone wouldn't).
Wow! great solve!! When I was testing the case to make sure it can be done in under thirty minutes. I think my best time was 23 minutes and I wrote the case Congrats on the win!!
I didn't watch the video yet because I want to run a genuine walkthrough of this case on my own, but just the fact that this is 26 minutes long is nuts! I will be back shortly!
Haha - all the work that actually scored me any points is actually in the first ~17 mins. The rest of the video is explaining how I got all the bonuses wrong! (and how to get them right) I'm looking forward to seeing your version!
@@DimEarly Ok I have seen this now. The lean and organized way you created for lvl5 is top level! I also feel quite dumb to have overcomplicated level 4 item-taking logic vs time left ahaha, you'll see! And also my nested sortby+index is quite useless, today I have learned something new too!
Thanks Lorenzo! And don’t worry about feeling dumb when you see a better approach. It happens to me plenty too - like when I watched your clock solitaire solution, for example : )
wow ... level 4 n 5 ..speed of simplification in live attempt was superb ...hats off.. one small tip ...it seems u might have missed and i m sure u would figure out eventually ..textsplit, textafter, textbefore ... have a 4th parameter which can be set as 1 for case insensitive match
Thanks for the tip! I had no idea until I went to debug this case that they were even case sensitive - now that I do, I’m glad to hear that you can turn it off. : )
just curious to know... what did u do in the prep file ...i could see some grid of 11 columns ..what was it... did it have anything to do with how fast you got the 32-14 logic in level 3?
@@excelling6955 Haha - no, like probably more than half of the prep I do, it didn't help at all! I was anticipating a question about picking the best set of aisles to go down, so that table was all possible subsets of the 11 aisles with an odd total number (since you have to go down an odd number of aisles to end up at the bottom).
Thanks for the videos. I was wondering if you’ve ever combined by row with scan. I’m running simulated paths so scan works great as an accumulator but I can’t seem to get it to work on a row by row basis?
BYROW will (sadly!) only return a single value per row - it doesn’t want to output an array of arrays (even in cases where this would make sense!). There are a couple of possible workarounds: - combine the SCAN outputs into one value (e.g. with TEXTJOIN) and then split them after - use REDUCE to iterate through a whole column at a time, and HSTACK to accumulate all the results I have my fingers crossed for dynamic arrays getting more comfortable with arrays of arrays in a future release (and I know I’m not alone in that!)
Even after watching i can't figure out how you did to have the level 4 completed in this manner, how did the results of all your data is being pulled off in the table without having it showcased on the screen or at any point ? I'm sounding so noob haha, amazing to see a master at work !
I’m not 100% sure this is answering the question you’re asking, but I used a data table to run all the different scenarios at once - it’s basically a way of asking Excel ‘what would the value in cell A become if I changed the value in cell B to each of these other values?’.
@@DimEarly So yeah i'm seeing the first table, but mu head can't figure out on how all the other results are being pulled out, from my understanding it's just one example from the 1st line that you are testing, then to transform from 1 result to the 20 needed is what i can't wrap my head around The links made to transform 1 result into 20 is tough to have a grasp on It's the part from 9:21 to 9:58 from where you set up one data set for the 1st result to transform into a table with all the results
That level 5 was so clean and built so fast I almost couldn't keep up with it! Hahahaha Absolutely stunning!!
Wow. Incredible live performance! with exceptional Level 5 model. I salute you three times. 🙌🙌🙌🙌
Thanks Bo! It was nice to finish on a high note (I was glad I didn’t end up using this round to experiment with Python! 😂)
Amazing work! I was really wondering how is it possible to score 1000 points in 20 minutes, and it looks so easy when you do it. Congrats!
Just one word: Excellent!!
Hoo boy, this was a tough case. Great solve as always.
Like Lorenzo, I'm first going to do it without a clock, then check out this video. So happy that within 40 seconds you made the inventory a table (so did I, can't understand why someone wouldn't).
Yes - data tables for the win! Preferably with a nice short name : )
Wow! great solve!! When I was testing the case to make sure it can be done in under thirty minutes. I think my best time was 23 minutes and I wrote the case
Congrats on the win!!
Thanks Harry - and congrats on another very nice case! I hope you keep writing them…
I didn't watch the video yet because I want to run a genuine walkthrough of this case on my own, but just the fact that this is 26 minutes long is nuts!
I will be back shortly!
Haha - all the work that actually scored me any points is actually in the first ~17 mins. The rest of the video is explaining how I got all the bonuses wrong! (and how to get them right)
I'm looking forward to seeing your version!
@@DimEarly Ok I have seen this now. The lean and organized way you created for lvl5 is top level!
I also feel quite dumb to have overcomplicated level 4 item-taking logic vs time left ahaha, you'll see! And also my nested sortby+index is quite useless, today I have learned something new too!
Thanks Lorenzo! And don’t worry about feeling dumb when you see a better approach. It happens to me plenty too - like when I watched your clock solitaire solution, for example : )
wow ... level 4 n 5 ..speed of simplification in live attempt was superb ...hats off..
one small tip ...it seems u might have missed and i m sure u would figure out eventually ..textsplit, textafter, textbefore ... have a 4th parameter which can be set as 1 for case insensitive match
Thanks for the tip! I had no idea until I went to debug this case that they were even case sensitive - now that I do, I’m glad to hear that you can turn it off. : )
just curious to know... what did u do in the prep file ...i could see some grid of 11 columns ..what was it... did it have anything to do with how fast you got the 32-14 logic in level 3?
@@excelling6955 Haha - no, like probably more than half of the prep I do, it didn't help at all!
I was anticipating a question about picking the best set of aisles to go down, so that table was all possible subsets of the 11 aisles with an odd total number (since you have to go down an odd number of aisles to end up at the bottom).
Thanks for the videos. I was wondering if you’ve ever combined by row with scan. I’m running simulated paths so scan works great as an accumulator but I can’t seem to get it to work on a row by row basis?
BYROW will (sadly!) only return a single value per row - it doesn’t want to output an array of arrays (even in cases where this would make sense!). There are a couple of possible workarounds:
- combine the SCAN outputs into one value (e.g. with TEXTJOIN) and then split them after
- use REDUCE to iterate through a whole column at a time, and HSTACK to accumulate all the results
I have my fingers crossed for dynamic arrays getting more comfortable with arrays of arrays in a future release (and I know I’m not alone in that!)
Even after watching i can't figure out how you did to have the level 4 completed in this manner, how did the results of all your data is being pulled off in the table without having it showcased on the screen or at any point ?
I'm sounding so noob haha, amazing to see a master at work !
I’m not 100% sure this is answering the question you’re asking, but I used a data table to run all the different scenarios at once - it’s basically a way of asking Excel ‘what would the value in cell A become if I changed the value in cell B to each of these other values?’.
@@DimEarly So yeah i'm seeing the first table, but mu head can't figure out on how all the other results are being pulled out, from my understanding it's just one example from the 1st line that you are testing, then to transform from 1 result to the 20 needed is what i can't wrap my head around
The links made to transform 1 result into 20 is tough to have a grasp on
It's the part from 9:21 to 9:58 from where you set up one data set for the 1st result to transform into a table with all the results