topic Re: Advent of Code 2020 - BaseA Style (Day 7) in General Discussions

Advent of Code 2020 - BaseA Style (Day 7)

Jean-Balteryx — Mon, 07 Dec 2020 00:06:19 GMT

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

Re: Advent of Code 2020 - BaseA Style (Day 7)

NicoleJohnson — Mon, 07 Dec 2020 06:17:05 GMT

Golly, I do love me an iterative macro!

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

Re: Advent of Code 2020 - BaseA Style (Day 7)

T_Willins — Mon, 07 Dec 2020 06:49:42 GMT

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.

Workflow

7a Standard Macro7a Iterative Macro

7b Standard Macro7b Iterative Macro

Re: Advent of Code 2020 - BaseA Style (Day 7)

Greg_Murray — Mon, 07 Dec 2020 06:57:15 GMT

Similar to @NicoleJohnson's solutions.

part 1 iterative macro

part 2 iterative macro

Re: Advent of Code 2020 - BaseA Style (Day 7)

AkimasaKajitani — Mon, 07 Dec 2020 07:39:03 GMT

Day 7!

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

Part1 Macro :

As anonymous user #1105310

Re: Advent of Code 2020 - BaseA Style (Day 7)

philipmannering — Mon, 07 Dec 2020 08:20:58 GMT

My Solution

And my macros

Re: Advent of Code 2020 - BaseA Style (Day 7)

peter_gb — Mon, 07 Dec 2020 08:30:42 GMT

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

Re: Advent of Code 2020 - BaseA Style (Day 7)

jdunkerley79 — Mon, 07 Dec 2020 08:47:18 GMT

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

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

Macro:

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

Re: Advent of Code 2020 - BaseA Style (Day 7)

cgoodman — Mon, 07 Dec 2020 09:57:22 GMT

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!

Macro for part A - familiar heirarchy macro

Macro for part B:

Re: Advent of Code 2020 - BaseA Style (Day 7)

dsmdavid — Mon, 07 Dec 2020 10:04:07 GMT

Similar to others'

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

https://github.com/dsmdavid/AdventCode2020

Re: Advent of Code 2020 - BaseA Style (Day 7)

NedHarding — Mon, 07 Dec 2020 14:41:50 GMT

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

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

Re: Advent of Code 2020 - BaseA Style (Day 7)

danilang — Mon, 07 Dec 2020 15:14:17 GMT

That's quite a lot of bags. Exactly how thick at the walls of these bags...and how big are the planes

Dan

Re: Advent of Code 2020 - BaseA Style (Day 7)

estherb47 — Mon, 07 Dec 2020 18:45:16 GMT

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.

Re: Advent of Code 2020 - BaseA Style (Day 7)

Balders — Mon, 07 Dec 2020 21:47:21 GMT

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

Re: Advent of Code 2020 - BaseA Style (Day 7)

Aguisande — Mon, 07 Dec 2020 23:22:48 GMT

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

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)

Re: Advent of Code 2020 - BaseA Style (Day 7)

OllieClarke — Mon, 07 Dec 2020 23:55:57 GMT

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 😫

Workflow
Part 1Part 2

Re: Advent of Code 2020 - BaseA Style (Day 7)

joshbennett — Tue, 08 Dec 2020 04:58:33 GMT

This one hurt my brain a little - used an iterative macro, similar to others.

Part 1:

Macro:

Part 2:

Slightly modified macro from part 1: