Advent of Code 2020 - BaseA Style (Day 3)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Discussion thread for day 3 of the Advent of Code : https://adventofcode.com/2020/day/3
- Labels:
- Advent of Code
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NicoleJohnson Still to early to think about reusing workflows. Day 8 or so we should probably start thinking along those lines. 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
I used a macro because I also figured this might come up again in the future.
The macro (with formula code snippet screenshot):
Happy to say mine runs in ~0.5 seconds, and uses relatively few tools.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great to see you taking part @Steph_Maddrell 👏
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Totally brute force/copy paste
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Day 3. Brute force instead of a macro.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
