Advent of Code 2020 - BaseA Style (Day 7)

Jean-Balteryx

Discussion thread for day 7 of the Advent of Code : https://adventofcode.com/2020/day/7

Advent of Code

Accepted answers

All comments

NicoleJohnson

Golly, I do love me an iterative macro!

Spoiler

Though I'm wary of iterative macros in the world of AoC (#IntcodeNightmares), this one seemed innocent enough. For now. 😉

I've built my fair share of "parent-child" macros over the years (six degrees of Kevin Bacon, anyone?), so this was at least a familiar path. Parsed out the bag descriptions & quantities and then built simple macros for part 1 & 2 to find the inner-outer combos (or outer-inner combos). While the macros were similar, they do lookup data in different directions, so created a separate instance for each part.

For Part 1 macro, used an iterative process that found the parent of every inner bag (and then the parent of that parent in the next iteration).

For Part 2, swapped the join to find the Inner bags & quantities for each Outer bag, summarized, then called them "outer" for the next iteration, repeating the process.

Cheers!

https://github.com/AlteryxNJ/AdventOfCode_2020

2020_Day7.yxzp

T_Willins

Modified my standard/iterative inception macro set that I used for building trial balances. After finishing I see that I could have used a single standard/iterative macro set to do both a&b, but it's Sunday night and there is a drink and a dip in the hot tub waiting.

Spoiler

Workflow

7a Standard Macro

7a Iterative Macro

7b Standard Macro

7b Iterative Macro

7a&b.yxzp

Greg_Murray

Similar to @NicoleJohnson's solutions.

Spoiler

part 1 iterative macro

part 2 iterative macro

AkimasaKajitani

Day 7!

I often fall into the trap of repetitive macros...

Spoiler

Part1 Macro :

As anonymous user #1105310

philipmannering

My Solution

Spoiler

And my macros

Spoiler

peter_gb

Day 7 | iterative macros always make my head hurt but got there...

Spoiler

AoC7_pgb.yxzp

jdunkerley79

My brain was not working well enough for iterative macros this morning...

Think mine is a little different to others but same general idea

Spoiler

Macro:

Flows on GitHub: https://github.com/jdunkerley/adventofcode

cgoodman

Note to self - Must read the question. I forgot to swap the inner bag to be outer bags in the second part so wasted a lot of time doing that!

Spoiler

Macro for part A - familiar heirarchy macro

Macro for part B:

dsmdavid

Similar to others'

Spoiler

also, keeping track of the lineage...for no apparent good reason (yet, who knows what future days have in store for us...).

Spoiler

https://github.com/dsmdavid/AdventCode2020

day_07_01.yxzp

NedHarding

Similar solution to other people. Brain not working today so had to fight through an off by 1 bug (I counted the outermost bag.)

But at least my input macro worked perfectly and saved me a few seconds... https://community.alteryx.com/t5/General-Discussions/Advent-of-code-2020/m-p/676655/highlight/true#M3266

Spoiler

Find it at https://github.com/NedHarding/Advent2020

estherb47

A good iterative macro challenge to get the brain moving!

Nothing novel here, took the same building from inside out and then outside in that most did.

Spoiler

Balders

Quite happy with this, one iterative macro for both parts. Nothing earth shattering but re-use where you can!

Spoiler

AoC Day07 IanB.yxzp

Aguisande

Finally got the time to post...

Here's my approach, tried to solve both parts with the same kit of macros, until realized that I had to switch inner and outer bags for one of the parts.

So I decided to Save as.. one of the macros, modified as needed and incorporate it (easier way).

Spoiler

This is the pre-iteration macro (used for both parts):

And the two iterative ones:

(Almost identical, but with a twist in the Join Tool)

OllieClarke

Part 1 took me a few minutes. Part 2 took me hours to work out that had I just connected to data rather than a text input, everything would be golden ">😫