Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
General Discussions
Discuss any topics that are not product-specific here.
This was a nice change for Day 2 after a rough Day 1!
Spoiler
Part 1: Mostly just a parsing exercise. Probably could have done this in fewer tools with RegEx, but it was faster to use Text to Columns repeatedly since RegEx makes my head hurt.
Part 2: Just had to take the max number of cubes for each color used in each game and multiply them together. No big twists made me paranoid I was missing something, but I guess Eric decided to give us a nice Part 2 after yesterday. I'm guessing this just means tomorrow will be even trickier!
Part 2: Just had to take the max number of cubes for each color used in each game and multiply them together. No big twists made me paranoid I was missing something, but I guess Eric decided to give us a nice Part 2 after yesterday. I'm guessing this just means tomorrow will be even trickier!
It's been a good, good day... because I got to use a new feature from 23.2 Designer release (with the Custom Workflow Template I saved earlier today to use as my quick starting point every day for Advent of Code with a data download macro & input switcher)... AND then I also found a way to use not one, not two, but THREE new functions available in the 23.2 release as well! It feels like Christmas already!! 😁
Spoiler
Annotated the cleaned up/tool golf version with notes. I went for speed, not beauty, for the stars... and then went back to clean it up because 4 Text to Columns tools just felt a little ridiculous. 🤣
