topic Advent of Code 2021 Day 11 (BaseA Style) in General Discussions

Advent of Code 2021 Day 11 (BaseA Style)

jdunkerley79 — Mon, 13 Dec 2021 14:09:02 GMT

Discussion thread for day 11 of the Advent of Code - https://adventofcode.com/2021/day/11

Re: Advent of Code 2021 Day 11 (BaseA Style)

bflick — Sat, 11 Dec 2021 06:30:52 GMT

Iterative macros are back with a vengeance.

Definitely an interesting one. I went with a double iterative macro. The first looping through each step and the second looping through the flashes. I gave each cord the status of "", "Flash", or "burnt." Burnts had already flashed so they were taken out of the inner loop. If a point flashed it modified the 8 squares around it using 8 formula tools to update the X,Y and modify.

Workflow

Outer Macro

Inner Macro

Re: Advent of Code 2021 Day 11 (BaseA Style)

clmc9601 — Sat, 11 Dec 2021 07:16:55 GMT

Agreed, @bflick, back with a vengeance indeed

I also used a double iterative macro. The inner portion adds energy for the multiple flashes within each step, and the outer macro ensures there are enough steps taken. I put all my neighboring coordinates in a single formula tool and separated them into rows with a delimiter rather than doing each in a separate stream.
Outer macroWorkflowInner macro

Re: Advent of Code 2021 Day 11 (BaseA Style)

patrick_digan — Sat, 11 Dec 2021 12:43:25 GMT

It was super slow (5 minutes for step 2) but I was happy with my macro.

I was inspired by @Aguisande to use my multi-field-row macro and it worked great (albeit slowly).
Workflow:

Iterative Macro. The magic is the first multi-field-row tool which checks all 8 surrounding cells to see how much energy the cell needs to increase by. It's not very performant with 5+ minute run time, but I could probably clean up a few things to get a little speed back

Re: Advent of Code 2021 Day 11 (BaseA Style)

AkimasaKajitani — Sat, 11 Dec 2021 13:44:28 GMT

It is difficult to understand the flashing mechanism, so it took the long time.

In any case, today is iterative macro day.

Macro for star1

Macro for Star 2

Spread Energy Macro :

After increment, this macro repeats until finishing the spreading energy.

Git Hub

https://github.com/AkimasaKajitani/AdventOfCode/tree/main/2021

Re: Advent of Code 2021 Day 11 (BaseA Style)

dsmdavid — Sat, 11 Dec 2021 16:10:00 GMT

I'm learning a lot of marine biology. And continuously surprised with the number of diverse sensors available in the submarine.

Didn't feel like modifying the macro for part 2, so just ran it for longer. Luckily it worked.
Main workflow calls an iterative macro to go through n number of steps.
Inside there's another iterative that resolves the flashes.

https://github.com/dsmdavid/AdventCode2021

Re: Advent of Code 2021 Day 11 (BaseA Style)

leozhang2work — Sun, 12 Dec 2021 02:34:31 GMT

Level 1Level 2Level 3workflow

This exercise is constantly pushing my limit on the macro. Great when it works.

Level 1: standard macro, for each cell, find the adjacent cells, then do 1 iteration of cascade on the energy if current cell is 10 energy.

Level 2: iterate macro, for each step, iterate level 1 until stable state (i.e. no more cell has 10 energy)

Level 3: iterate macro, repeat run for 100 iterations, at each step count number of flashes.

For part 2, just increase the iteration limit, turns out it's much less than I expected. Done within 500 iterations.

Re: Advent of Code 2021 Day 11 (BaseA Style)

SeanAdams — Tue, 14 Dec 2021 01:02:20 GMT

I used two macros that are not as well known in Alteryx - the disco-ball macro and the Flash macro. Instead of "Preparation" or "Spatial" - look under the "strange marine" section in the tools. Used a batch macro with an iterative inside

Here's the logic:
- First clean up the input data into rows and columns with each one knowing its neighbours
- then pass this into a batch macro that adds one to each cell; doing the flash; and resetting cells

... there's the disco ball macro.

The Disco-ball & Flash Macro
This is relatively simple:
- create a queue of cells that need to execute a flash
- For each cell that creates a flash - apply this to the board and see what else goes above 10 - and add these to the queue
- Repeat until all the flashes have been done.

the only complexity here is being able to pass the updated board; and ALSO the updated queue through each iteration of the macro

Re: Advent of Code 2021 Day 11 (BaseA Style)

AncientPandaman — Wed, 15 Dec 2021 07:50:35 GMT

using the pattern in previous day.

like

xy	Move	adjacent	Value
2,2	up	2,1	9
2,2	down	2,3	8

only link to the 1 layer macro

in 1st layer macro
add 1 and link to 2nd layer macro for flash
only then filter out o and count for day and flash.

in 2nd macro,
check the value if is 10. and count the value will add to adjacent.
sum it and add to value
repeat until nothing to add.

workflow:

1st layer macro

2nd layer macro

Re: Advent of Code 2021 Day 11 (BaseA Style)

caitlynmcintyre — Tue, 21 Dec 2021 03:29:21 GMT

Iterations within Iterations, could have used way less tools but I'm so far behind I'm doing for completion rather than finesse

Macro for Part 1:

Macro for Part 2:

and Part B of both: