Advent of Code 2022 Day 8 (BaseA Style)

[AlteryxCommunityTeam]

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

[grossal]

Part 1 was pretty straightforward, and Part 2 was in my mind as well. Took a lot of debugging to find my mistake. Anyhow. Finally securing a Part 2 win :-)

Révélation

[bflick]

Brute force or bust for part 2. Tracking down bugs in large conditional if statements will always be the bain of my existence

Révélation

[AkimasaKajitani]

I went to brute force approach.

Révélation

Part 1 macro:

Part 2 macro:

[clmc9601]

This one didn't click for me. Struggled for a long time before coming up with a clunky solution. As I cleaned it to post here, turns out half of it was unnecessary 😣😂 

Révélation

Part 1: sorting the coordinates four times so all directional calculations are executed from the top down

 

Part 2: appending each tree to the rest to calculate the tree's scenic distance in all four directions. The macro only iterates 99 times, thankfully.

 

[DawnDuong]

I overcomplicated things for part 2 and that costed a lot of times.

Révélation

Part 1 is relatively straightforward, I used a lot of Multirow tools to make it easier to debug.

Part 2 is, upon hindsight, not that complicated had I not overcomplicated things.

Used a "brute force" macro, similar to what others had posted earlier.

[Jean-Balteryx]

Day 8 done ! ✔️

Here is my monster ! Not sure it's worth explaining as it should have a disclaimer "Don't do that at home, it has been performed by professionals." !

Révélation

[balders-ie]

Happy with this one today, quite clean and concise for the challenge. For both parts 1 & 2, each data stream is a different cardinal direction.

I've added my golf today, but happier with my first solution as it was more computationally efficient. It had more tools but ran faster due to paring down the data properly with filters!

Révélation

 Golf:

 

[ApekshaSharma]

Hi All, this was my solution for Day8. :)

Révélation

 

 

 

[patrick_digan]

Definitely not competing for tool golf today, but I didn't have too much trouble

Révélation

I just defined each cell as a specific row/column, and then just sorted it 4 times and checked each direction independently.