Advent of Code 2022 Day 8 (BaseA Style)

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

Accepted answers

All comments

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 :-)

Spoiler

bflick

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

Spoiler

AkimasaKajitani

I went to brute force approach.

Spoiler

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 😣😂

Spoiler

Part 1: sorting the coordinates four times so all directional calculations are executed from the top down
Screen Shot 2022-12-07 at 11.54.16 PM.png

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.

Screen Shot 2022-12-07 at 11.56.50 PM.png

Screen Shot 2022-12-07 at 11.56.50 PM.png

DawnDuong

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

Spoiler

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." !

Spoiler

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!

Spoiler

Golf:

AoC Day8.yxmd

AoC Day8_golf.yxmd

ApekshaSharma

Hi All, this was my solution for Day8.

Spoiler

patrick_digan

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

Spoiler

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

Day 8.yxmd

peter_gb

I have a habit of using A LOT of tools it would appear but I really like seeing each step of the way and being certain the logic is working the way I'm visualising the problem in my head. Need to dig into some other solutions to see how they've possibly been done more efficiently than my works of art 🤣 🎅

Spoiler

A closer look :

Spoiler

AoC_8.yxmd

mmontgomery

Focused on creating categories for each point (left, right, up, down) with help of generate rows. For P1, I created a boundary with values of -1 to count those. For P2, took me a while, but had to bucket each category. Got values greater than no problem, just had to do running total and first record on current point then union.

Spoiler

Jean-Balteryx

Tool golf version : 9 tools !

Spoiler

AoC_2022_Day_8.yxmd

JamesCharnley

Spoiler

Part 1 Macro:

Part 2 Macro:

Workflow:

Another day, another unnecessary and hideous macro. I'm having fun nobody can stop me

Day 8 Packaged.yxzp

OllieClarke

That felt inelegant

Spoiler

DataNath

Finally got today's done! Spent 2.5 hours trying to debug my macros only to realise I was leaving my RecordID field in my 'left' count...

Spoiler

Column movement checker:

Row movement checker:

Day 8.yxzp

JarekSkudrzyk

I am totally proud of myself for solving today's challenge:)

Spoiler

leozhang2work

Spoiler

Workflow

Got into a rabbit hole of doing iterative, should have done a batch

So bad, I don't event want to annotate it, brute forced

Scraping by now, just want the answer, not care about the efficiency anymore 😅

AncientPandaman

Spoiler

part 1:

1. split to x,y coordination. create for list x and y.
2. use left for top, left. and right for down, right
3. use regex_countmatches to count more than 1
4. merge with edge and count record.