Advent of Code 2023 Day 11 (BaseA Style)

[AlteryxCommunityTeam]

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

[DataNath]

Day 11 completed! Despite claiming that I would brute force part 2 at any cost in the WhatsApp group, about 90 minutes into generating over 2billion rows, I realised that this could actually be done in a much simpler way and decided to implement that instead... smart, eh?

Spoiler

[patrick_digan]

Spoiler

Part 1 I used Generate Rows, but part 2 I used a multi-row formula. I started to brute force part 2 but 5M x 8M was going to be a bit large...

[SuguruYoshinaga]

Day 11 finished.

Spoiler

WF

[phottovy]

My solution:

Spoiler

[mmontgomery]

No macro/generate rows! 0.9 sec for p1/p2

Spoiler

[Carolyn]

Solved!! Time to head back to D10

 

Spoiler

Part 2 took way longer than it should have, first because I was doing the "10x larger" to mean "add 10 in ADDITION to the 1 already there". And then I ran into 2 PEBKAC problems

[Yoshiro_Fujimori]

My Solution

Spoiler

Part 1 can be solved by setting "expansion ratio = 2".
It took 2.0 seconds to run.

[caitlynmcintyre]

I liked this one, Part 1 and Part 2 just need to adjust the multiplier in the circled tool

Spoiler

[alisonpitt]

It's so hard to resist the urge to go back and "fix" part 1 when you find a better solution in part 2!

Spoiler

[Pang_Hee_Choy]

no macro day is a happy day.