Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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