General Discussions
Discuss any topics that are not product-specific here.
Golly, I do love me an iterative macro!
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!
NJ
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 Macro
7a Iterative Macro
7b Standard Macro
7b Iterative Macro
Day 7!
I often fall into the trap of repetitive macros...
Part1 Macro :
Part1 Macro :
As anonymous user #1105310
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
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
