General Discussions

Jean-Balteryx · ‎12-11-2020

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

jdunkerley79 · ‎12-11-2020

I probably should have gone spatial but kept it simple

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

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 · ‎12-11-2020

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.

Révélation

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 :

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 · ‎12-12-2020

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

Révélation

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

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 toolwith the use of these helpers to do find/replace like a mad man

patrick_digan · ‎12-12-2020

Révélation

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:

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 · ‎12-12-2020

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:

Révélation

Part B:

Révélation

Part B iterative macro:

Révélation

Balders · ‎12-12-2020

my submission to the golf overlords

Révélation

refactoring the instructions to turn "W" into "E", "S" into "N", "L" into "R" made the multi-rows easier to handle.

They'd also look a lot neater in a language with implicit type conversion, there are ToString() and ToNumber(GetWord()) functions everywhere.

Screenshot 2020-12-12 135959.png

Edit: Oh I could definitely smush the two multi-rows in part 2 into 1 multi-row as they're both of the same Switch([instr],...) function and use a coord format "wx wy bx by dir dist" but I'll leave that as an exercise to the reader.

refactoring the instructions to turn "W" into "E", "S" into "N", "L" into "R" made the multi-rows easier to handle.They'd also look a lot neater in a language with implicit type conversion, there are ToString() and ToNumber(GetWord()) functions everywhere.Edit: Oh I could definitely smush the two multi-rows in part 2 into 1 multi-row as they're both of the same Switch([instr],...) function and use a coord format "wx wy bx by dir dist" but I'll leave that as an exercise to the reader.