Advent of Code 2020 - BaseA Style (Day 12)

Jean-Balteryx

Discussion thread for day 12 of the Advent of Code : https://adventofcode.com/2020/day/12

Advent of Code

Accepted answers

All comments

jdunkerley79

I probably should have gone spatial but kept it simple

Spoiler

Lots of multi-row tools...
- Worked out and normalised the facing angle (so 0 for East, 90 for South, etc...)
- Tracked X and Y separately as easiest
- For WP should have treated as spatial but kept as string instead

AkimasaKajitani

Day12!

Part 1 is simple. I mainly use the Multi-row formula at both part.

But I think it was a mild problem compared to the last few days.

Spoiler

At part 2 I must rotate the x,y. So I have needed to use Iterative macro because of having to use previous record of x,y.

Part 2 Iterative Macro :

AS anonymous user #1105310

dsmdavid

First foray into "let's use multirow tools instead of macro" world. It was fun, although maybe a bit out of control for part II

Spoiler

I'm not capable of thinking like that, so I needed to build a macro first. Then translate the logic into the multirow, then go for the single tool

with the use of these helpers to do find/replace like a mad man

day_12_01.yxzp

patrick_digan

Spoiler

Simple multi-row for part 1 (which I found out in part 2 wouldn't fit all cases but worked for part 1 thankfully. Part 2 I moved to an iterative macro.

Macro for part 2:

Steph_Maddrell

It's seriously ugly (10 multi-row formula tools, a nested IF with 20 conditions and an iterative macro for good measure) but at least it runs in 3 seconds which is an improvement on the 2 hours from yesterday!

Part A:

Spoiler

Part B:

Spoiler

Part B iterative macro:

Spoiler

peter_gb

Got in a right pickle with that but had a nice solution in the end.

Trusty iterative! Tried multirow but it gives me a headache 😄

Spoiler

It didn't begin well...

Spoiler

Had fun with animating the routes though!

Spoiler

https://public.tableau.com/profile/petergb#!/vizhome/12_2_16077851001790/Route2

AoC12_pgb.yxzp

peter_gb

A simple solution after getting into a bit of a mess on this one...

Spoiler

I'm also enjoying animating the results!

Spoiler

https://public.tableau.com/profile/petergb#!/vizhome/12_2_16077851001790/Route2

AoC12_pgb.yxzp

NedHarding

I question their navigation computer! Here is the path:

Spoiler

So obviously went spatial on part 2. Unless you want to go the macro route, you need to fuse X & Y - so you might as well use spatial.

Still some tricks left though - The multi-row formula always produces a NULL spatial object, there isn't the equivalent of 0. So I injected the 1st record in via a union, which also allowed me to set the initial waypoint. But then you have to remember to detect that initial condition in the expression. With a more complicated expression you could avoid injecting the record.

I could have re-written part 1 using spatial and eliminated a tool, but I didn't...

Workflow on github: https://github.com/NedHarding/Advent2020