Discussion thread for day 3 of the Advent of Code : https://adventofcode.com/2020/day/3
Day 3 - getting trickier, needed more thought
I definitely am finding myself suffering from flashbacks and asking myself "How can I build this so that it is flexible enough that I can still be using it 12 challenges later?"...
Also, per usual, was fairly pleased with my solution until I saw @jdunkerley79 10-tool variation. Sigh.
Cheers!
NJ
Day 03
I made macro, too. But my approach is putting the part 1 workflow into macro.
Macro:
@NicoleJohnson
I'll see @jdunkerley79's 10 tool solution and raise mine with 7
Used the "messy" substring() along with some modulo math to logically lengthen the rows as required. Technically I could remove the 1st filter and the following formula and cram the logic into the last filter tool, similar to what was used in Day 2 solutions, but that would just be silly 😂
Dan
This is Part1 of Day3 (I'll do part 2 when I finish a couple of meetings).
Needed help to understand the problem, thank @Niklas for your help!
Finally had the time to solve 2nd. part. Couldn't make it without Niklas and Jesse's help.! Thank you guys!
My first year of AoC (@cgoodman3 has been nagging me and anyone else who will listen! 😝)
Today was definitely a step up from day 1 and 2 but managed it in the end!
Figured I may as well start posting my solutions to these 🙂This was definitely a fun one. I brute forced a solution to get some quick stars and then went back and fixed the logic.
The macro (with formula code snippet screenshot):
Happy to say mine runs in ~0.5 seconds, and uses relatively few tools.
Great to see you taking part @Steph_Maddrell 👏
Totally brute force/copy paste
Day 3. Brute force instead of a macro.
Below is my solution utilizing an iterative macro which runs each part in under 1s individually and just at 1s together, which I felt pretty good about until I saw how fewer tools most of the other solutions have! 😂 Oh well, this one was fun to build!
Part 1:
Part 2:
Part 1 + Part 2:
Step up for day 3
Definitely took longer to wrap my head around, and my first pass through I went brute force and created all of the full repetitions of the patterns.
That looked way too ugly so I had to rethink and rework. Still not as elegant as I'd like, but it's fast, and it works.
Day 3 | MODerately pleased with this
