Advent of Code 2024 Day 8 (BaseA Style)

[AlteryxCommunityTeam]

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

[Hub119]

Either Day 8 was just WAY easier (once you decipher what is being asked) than the last few problems OR I am quickly acknowledging the benefits of doing these in the middle of the day on a good night's rest 😀.

Spoiler

So nice when solutions can run in under a second...

[leozhang2work]

Spoiler

Almost went for macro again, turns out no need, just need a correct join does the job.

[geoff_zath]

Workflow

Part 1

Spoiler

Part 2 

Spoiler

Batch Macro

Spoiler

[peter_gb]

Struggle with the logic for this at first but it wasn't so horrendous in the end! Very glad to get the second star. Solved the entire day 8 whilst my day 9 part two was running...!

Spoiler

 

 

[Tokimatsu]

Done without macro. 

Spoiler

 

[ntakeda]

My solution.

Spoiler

 

[PangHC]

not sure why it is working. but it worked 😆

Spoiler

use generate rows to have multiple to guess the limit, (about 50 for my input, lazy to put in macro to dynamic the multiple)

[Carolyn]

Solved! I went with brute force for Part 2 since I needed that square for the bingo game

Spoiler

For Part 2, I tried to remember my linear algebra and come up with a proper line formula but after playing with pen and paper without luck, I said "screw it" and just generated all 50 x 50 points and saw which ones were on the same line as my antennae pairs.

[aiahwieder]

Whee!

[Spainey]

I originally skipped this one as I didn't have enough time at the weekend, but came back to it today and was able to figure out how to approach the question. 

Spoiler

 
The first part was quite simple, only requiring 1 antinode each at the positive and negative end of the antenna pairing. 
For Part 2, I used Generate rows within the bounds of 1 and max_row to ensure that new antinodes were generated within a restricted range (which was filtered further to remove erroneous antinodes once column positions were calculated also). Wasn't entirely sure it would work so was pleasantly surprised when the answer was correct :)