Advent of Code 2022 Day 6 (BaseA Style)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Discussion thread for day 6 of the Advent of Code - https://adventofcode.com/2022/day/6
- Labels:
- Advent of Code
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I used a hard-coded multi-row formula that wouldn't work for tons of letters for part one, then got stuck for a bit on part 2 until I used the multi-row formula tool more like a running total and assigned points based on where letters matched in the previous sequence. Not the simplest, but it made sense in my head!
2nd multi-row formula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's my stab at this. Wasted a load of time faffing around with an enormous Multi-Row Formula to try and chop out a couple tools but eventually gave up in the hopes of slipping in another hour of sleep.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Old Style!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If it went more than 14, that'd be a lotta lines on the 'IF'.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Finally joining in too.
I probably made it overly complicated with a batch macro in an iterative macro.
Edit: Omg - is my solution overly complicated :D
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Day 6 done ! ✔️
I feel like it was too easy compared to yesterady. A bit worried about tomorrow ...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Probably could have minimised the number of tools, I tend to always want to unique ID everything along the way but I suppose it's good practice!
Felt a little manual when I was copy and pasting in the multi-row but that seems to have been most people's approach today.