Advent of Code 2024 Day 11 (BaseA Style)

[AlteryxCommunityTeam]

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

[Yoshiro_Fujimori]

It tool a while to find an overflow with Int32 in Part2.

As the difference is only the number of blinking, I put it to the parameter in the macro.😉

Spoiler

Workflow

Macro

 

[DaisukeTsuchiya]

Day11 is easier.

Spoiler

WF runs in 2.5 sec. I modified macro a bit for P2.

[mmontgomery]

Day 11. More in spoiler

Spoiler

P1: Built it brute force as the problem explained
P2: It took a while to figure out an approach, and I tried to simplify the brute force approach. I realized that order didn't matter; the key was to group by key numbers and sum up their appearances to speed up the macro.

The same macro works on P1 and P2, just changed the iteration number to output

Run time 2.8  seconds

[BransonJamesFarley]

Cool!

[leozhang2work]

Spoiler

Part 1 macroPart 2 macroWorkflow

[Sebastian_Chaieb2]

First part was really quickly, but second.... 🙄 I guess after 7 versions I have something that was working fast 😅

Spoiler

 
First Iterative macro

Second Iterative macro

 

[Hub119]

Applied some quick simple logic for an iterative macro to get solution to part 1... then tried running this for part 2 and memory quickly became an issue after 30+ blinks and slowed WAY down... so I went back to the drawing board and realized the question had fooled me into thinking overall sequence mattered when really it only matters for the individual stone/number splits.  Made a quick tweak to group by numbers as they will always be treated the same, and BAM whole thing runs in about a second.  11 down, 14 to go...

Spoiler

[Blake_E]

Spoiler

WorkflowIterative macro

[Goddenra]

Got my hopes up when I saw the short question for the second star. Should have known! Tricks noted above in terms of realising you need to know the number of scenarios, not perform same task on each row, is key.

Good opportunity for me to brush up on iterative macros as I simply don't use them on a daily basis. 

[binuacs]

Spoiler