Discussion thread for day 3 of the Advent of Code : https://adventofcode.com/2020/day/3
@NicoleJohnson Still to early to think about reusing workflows. Day 8 or so we should probably start thinking along those lines. 😉
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
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: