Discussion thread for day 24 of the Advent of Code - https://adventofcode.com/2021/day/24
I just used google sheets, but it was basically a pen and paper solve trying to figure out the pattern. After I figured out the solution, I could have used alteryx to process and verify that z indeed comes out 0 (but I didn't bother).
pen and paper. and some information from Reddit.
here the workflow. it take 7-10mins to output.
update: workflow within 10 seconds.
1. generate 1 to 9 as usual.
2. for type 1, [z]*26+[y]
for type 2, if mod([z],26)+[x])=[w] then floor([z]/26 else remove.
3. iteration until id = 14 and [z] = 0
the 14 line.
macro:
I didn't get this to be as simple as @Pang_Hee_Choy , but close.
The trick for this one is reading the code provided by the challenge to find the pattern in it.