Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2021 Day 2 (BaseA Style) - Dive!

jdunkerley79
ACE Emeritus
ACE Emeritus

Discussion thread for day 2 of the Advent of Code - https://adventofcode.com/2021/day/2

26 REPLIES 26
joshbennett
11 - Bolide
11 - Bolide

Day 2 with Summarize and Multi-Row Formula

 

Spoiler
joshbennett_0-1638862581838.png

 

SeanAdams
17 - Castor
17 - Castor

OK - so this one was a bit wierd - why can't they separate aiming and driving.    Don't let these people on a motorbike!

 

Spoiler
Part 1:  Just summarised the directions - then cross-tabbed them and added them together.

SeanAdams_0-1639008556848.png

Part 2:

Given that the Aim drives Distance and depth - started with a multi-row for aim; then another multi-row for depth, then the distance.

SeanAdams_1-1639008651254.png

 

 

SeanAdams
17 - Castor
17 - Castor

Just to be clear @cgoodman3 and   @NicoleJohnson - what is the official tool count to quality for "Tool Golf" and is it unique tools or unique types of tools?

cgoodman3
14 - Magnetar
14 - Magnetar

Unique tools I think is how I see it (so minimise tool id tags in the xml).

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
dsmdavid
11 - Bolide
Spoiler
dsmdavid_0-1639089534952.png

 

Mchappell67
9 - Comet
Spoiler
Mchappell67_0-1639369316942.png

 

caitlynmcintyre
9 - Comet

Loved this one because it was mostly just math

Spoiler
caitlynmcintyre_0-1639625822693.png

 

Labels
Top Solution Authors