Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2023 Day 6 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

Discussion thread for day 6 of the Advent of Code - https://adventofcode.com/2023/day/6

47 REPLIES 47
caltang
17 - Castor
17 - Castor

Did some prep work on the input as well since I was too lazy to copy each record one by one....

 

Spoiler
image.png
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
PangHC
12 - Quasar

with one tool change for part 2. time to use detour. haha.

Spoiler
Screenshot 2023-12-06 160750.png

 

DataNath
17 - Castor
17 - Castor

Day 6 done to give a nice little serotonin boost after yesterday's part 2 breakdown! Not winning tool golf with this one but 2 stars = 2 stars.

 

Spoiler
Day6.png
mark-spain
8 - Asteroid

Not a pretty solution, but a simple one

Spoiler
 
Day 6.png

 

SeanAdams
17 - Castor
17 - Castor

started out thinking to solve this using a quadratic formula like @CoG - but it turns out that the brue-force method runs in just a few seconds anyway, so rather spend extra time finishing Day 5...

I will go back and take a look at how others have solve this thought - just for learning.

 

Spoiler
the basic process:
- Parse the data into a table like this
Screenshot 2023-12-06 050725.png
- then use Generate Rows to generate valid combinations of hold times - here I could use math to limit the population
- Then just filter the valid ones

The only difference between part 1 and part 2 - is that in part 2 I also cleaned out the whitespace so there is only one race in this set.

Screenshot 2023-12-06 050914.png



DavidP
17 - Castor
17 - Castor

Nice easy one. Thankfully!

 

Spoiler
aoc d6.png
mmontgomery
11 - Bolide
11 - Bolide

Team brute force! 17 seconds to generate 60m records

Spoiler
Day6.png
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
 

image.png

Kenda
16 - Nebula
16 - Nebula
Spoiler
Used the ol' transpose + cross tab trick @patrick_digan 

image.png
Labels
Top Solution Authors