The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found 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. 🤣
