Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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