I went with the u, d, l, r approach when I tried this case myself, but spent a long time trying to figure out how to get it not to go back the cell it just came from (or I spent a long time figuring out that was the problem in the first place). So glad you tried this way too and also provided a solution on how to solve it. Great use of filter :)
@@tzeshengyeo7268 awesome. Yes it's a strange one as you have to look for errors when normally it's the other way around. Quite counter intuitive. I learned it from one of the Lana cases in the qualification round as you couldn't pick up a banana you already got. Similar situation with that one!
Thanks, I tried really hard to make the circular way work but the problem is I could get a specific path be populated with 1s and filter for it but as soon as you data table it puts a 1 into all paths that start with a location in the data table. So I would have to reset or circuit break it for every individual question. I'm sure there is a cleaner solution that uses a similar method to me here but is cleaned up a lot. This felt quite slow. There have also not been many cases where indirect slows excel this much but for this one it is a bit of an issue. Perhaps I will swap to the lambda versions of it that aren't volatile.
@@ExcelFinance-j2p If you use 1000*row + column as the basis instead of 1s you can get unique numbers for the different paths and then use that to look up the locations
@@Harryjackgross Ah that's a great idea, now you mention it I think I have seen that method before somewhere. So I could say if cell is a start flag do that, then take the max of everything around a cell for non brick and idol cells so that each path is populated with the unique flag numbers? Then I could indirect a start location and filter the map for the number of that flag? I might try that later!
@@Harryjackgross I tried the method quickly and it seems frustratingly faster! I would need some way to pull out the ending cells for level 7 but that should be doable!
Great solution! It takes a lot of confidence to delete the pathfinding setup 😅
I went with the u, d, l, r approach when I tried this case myself, but spent a long time trying to figure out how to get it not to go back the cell it just came from (or I spent a long time figuring out that was the problem in the first place). So glad you tried this way too and also provided a solution on how to solve it. Great use of filter :)
@@tzeshengyeo7268 awesome. Yes it's a strange one as you have to look for errors when normally it's the other way around. Quite counter intuitive. I learned it from one of the Lana cases in the qualification round as you couldn't pick up a banana you already got. Similar situation with that one!
I think this is the first maze question solve I've seen that doesn't use the circularities trick - nice!
Thanks, I tried really hard to make the circular way work but the problem is I could get a specific path be populated with 1s and filter for it but as soon as you data table it puts a 1 into all paths that start with a location in the data table. So I would have to reset or circuit break it for every individual question. I'm sure there is a cleaner solution that uses a similar method to me here but is cleaned up a lot. This felt quite slow. There have also not been many cases where indirect slows excel this much but for this one it is a bit of an issue. Perhaps I will swap to the lambda versions of it that aren't volatile.
@@ExcelFinance-j2p If you use 1000*row + column as the basis instead of 1s you can get unique numbers for the different paths and then use that to look up the locations
@@Harryjackgross Ah that's a great idea, now you mention it I think I have seen that method before somewhere. So I could say if cell is a start flag do that, then take the max of everything around a cell for non brick and idol cells so that each path is populated with the unique flag numbers? Then I could indirect a start location and filter the map for the number of that flag? I might try that later!
@@Harryjackgross I tried the method quickly and it seems frustratingly faster! I would need some way to pull out the ending cells for level 7 but that should be doable!
@ Nice!
This seems like it was a super hard one
Next I might have to tackle your Lana case, going to be even harder than this!
@ Good luck!