General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2020 - BaseA Style (Day 3)

Jean-Balteryx
16 - Nebula
16 - Nebula

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

22 REPLIES 22
Galouzis
7 - Meteor

My solution was similar to @jdunkerley79, but then again not quite.

 

Spoiler
Galouzis_3-1607006026289.png

 


 


 


 

Galouzis
7 - Meteor

@NicoleJohnson Still to early to think about reusing workflows. Day 8 or so we should probably start thinking along those lines. 😉

danilang
19 - Altair
19 - Altair

@NicoleJohnson 

 

I'll see @jdunkerley79's 10 tool solution and raise mine with 7

 

Spoiler
danilang_0-1607007943461.png

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 

Aguisande
15 - Aurora
15 - Aurora

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!

Spoiler
aguisande_0-1607009110147.png

 

Finally had the time to solve 2nd. part. Couldn't make it without Niklas and Jesse's help.! Thank you guys!

Spoiler
aguisande_0-1607033225357.png

 

 

 

Steph_Maddrell
8 - Asteroid

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!

 

Spoiler
stephM_1-1607012644805.png

 

CassC
Alteryx Alumni (Retired)

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.

 

Spoiler

I used a macro because I also figured this might come up again in the future.

JesseC_0-1607017374230.png


The macro (with formula code snippet screenshot):

JesseC_1-1607017559067.png

 
Happy to say mine runs in ~0.5 seconds, and uses relatively few tools.

cgoodman3
14 - Magnetar
14 - Magnetar

Great to see you taking part @Steph_Maddrell 👏

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
patrick_digan
17 - Castor
17 - Castor

Totally brute force/copy paste

Spoiler
patrick_digan_0-1607108581726.png

 

T_Willins
14 - Magnetar
14 - Magnetar

Day 3.  Brute force instead of a macro.

Spoiler
AOC 20.3.jpg

 

joshbennett
11 - Bolide
11 - Bolide

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:

Spoiler
joshbennett_0-1607220382741.png

 

 

Part 2:

Spoiler
joshbennett_1-1607220398617.png

 

 

Part 1 + Part 2:

Spoiler
joshbennett_0-1607220834371.png

 

Labels