Advent of Code 2023 Day 6 (BaseA Style)

[AlteryxCommunityTeam]

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

[kelsey_kincaid]

I needed this.

Spoiler

Thought about using math to solve this and ended up using brute force instead.

[EmilyVA]

Day 6:  I was lazy and solved Part 1 with generate rows... but Part 2 demanded that I reach into the dark recesses of my memory and resurrect the quadratic formula song I learned in 8th grade algebra.   (Was much easier than yesterday, at least for me!)

[AkimasaKajitani]

My Designer Cloud solution. I solved it using a quadratic equation for Designer Cloud.

But Designer Cloud version has some problems.

 - No SQRT function

 - When the New Column Names changes at Cross Tab tool, we need to reset manually.

For SQRT function, I make the matching table between Pre SQRT and after SQRT which I made them in Designer Desktop.

Spoiler

 

[LiuZhang]

Spoiler

Holiday feel compare to day 5.

[StevenP]

My solution:

Spoiler

[BS_THE_ANALYST]

I decided to go for the iterative solution on part 1 and then formed and solved a quadratic equation with inequalities for part 2. I formed and solved the equation of one of the examples, I'll attach some workings out for anyone trying to do something similar:

Spoiler

  
I did try to iterate part 2 out of laziness. It was like 2trillion iterations at max, this exceeded the maximum number allowed in Alteryx apparently 

[Watermark]

Just realized I hadn't posted the D6 fluffy bunny  (as opposed to Cerberus from day 5)

Spoiler

 

[SuguruYoshinaga]

Spoiler

[Gem]

Compared to the previous (spicy) days, I'm all a-boat this one! 

 

Spoiler

[lwolfie]

Done!