Advent of Code 2023 Day 5 (BaseA Style)

[AlteryxCommunityTeam]

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

[SeanAdams]

Finally got this done (took a few days to clear out the brain fog).

And built a good few AOC reusable macros in the process!

Spoiler

The recipe for part 2 is as follows:
- Do the prep and break stuff down.
- Create a loop for each block of translation
      - For each iteration - split the seed ranges based on overlaps with the mapping ranges.     There's a trick here - you take the mapping ranges and break them into break points, and then iteratively break up each of the seed ranges
      - For each of the newly subdivided ranges - look to see if there's a hit on the mappings and then update the ranges
      - Finally compress the ranges to get rid of overlaps


 

[DaisukeTsuchiya]

I post again with solution in yxdb.

Spoiler

[Shelbey]

Well, my solution to part 1 isn't pretty, and I realize that it could be a macro instead of the mess that I have, but hey, it works and my brain hurts so I'm going to leave it as is. 

As for part 2, let's just accept defeat and move on to Day 6...

Spoiler