General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 10 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Discussion thread for day 10 of the Advent of Code - https://adventofcode.com/2022/day/10
19 REPLIES 19
Jean-Balteryx
16 - Nebula
16 - Nebula

Day 10 done ! 

 

That part 2 description was a pain to understand but was easier than expected !

 

Spoiler
Capture d’écran 2022-12-10 à 18.08.33.png
mmontgomery
10 - Fireball

Took a bit to understand the question but most of time was slightly tweaking process to results. Mod function ftw on p2

 

Spoiler
mmontgomery_0-1670692654782.png

 

JarekSkudrzyk
11 - Bolide

Hi, my solution attached - a bit of relief for the brain after yesterday's challenge:)

JarekSkudrzyk_0-1670709105850.png

 

DaisukeTsuchiya
13 - Pulsar
Spoiler
DaisukeTsuchiya_0-1670711342513.png

 

DataNath
17 - Castor

Day 10 finished! Trying to wrap my head around part 2 was bloody awful but otherwise fairly painless today. Opted for spatial to show my letters! :)

 

Spoiler
DataNath_1-1670712161656.png
Pang_Hee_Choy
12 - Quasar
Spoiler
Part1: easy
Part2:
use padleft and padright to product the sprite 
and substring to get value

Pang_Hee_Choy_0-1670825413333.png

 

SeanAdams
17 - Castor
17 - Castor

Day 10 done - this was much easier than day 9.    Only tip to give to everyone openly - is to use a fixed-width font (I used Courier New) to make it easier to read, otherwise spaces don't line up with # characters in regular old fonts.

 

Dirty solution below:

 

 

Spoiler
Here's the full thing:

Part 1 is a macro that does the tougher work.   Part 2 is really just reporting tools

SeanAdams_0-1670850073933.png


Here's the macro:

SeanAdams_1-1670850112227.png

As you can see I've hardcoded 2 things that could be parameterized - the timings for instructions; and the milestones which are important (40/80/120 est)
Other than that it's really just a few formulas and not much else


Yoshiro_Fujimori
15 - Aurora

My solution.

Formulas may be redundant (for my understanding of the problem).

 

Spoiler
Yoshiro_Fujimori_0-1670916381047.png

 

patrick_digan
17 - Castor
17 - Castor

It took a long time to understand what the second part was asking.

Spoiler
patrick_digan_0-1672834539983.png

 

caitlynmcintyre
9 - Comet

only 1 year and 2 days late on this 

 

Spoiler
10.png

Labels