Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #66: My Wine Problem

ConradW
8 - Asteroid

66 Snap.png

Spoiler
 
MarMu
8 - Asteroid

 

I had good fun with that challenge. Almost popped a bottle

I must admit that I didn't unlock the DOUBLE  BONUS.

 

The batch-macro will fail if the IDs are not numerical incl Null. That I guess is just the nature of the formula tool working with numbers. Furthermore I added a Test-tool to flag cases where Starting ID is greater than Ending ID.

 

Spoiler
challenge_66_start_file_MarMu.png
Laurap1228
11 - Bolide

I went for the Batch Macro solution

pasccout
8 - Asteroid

My solution

pasccout
8 - Asteroid

Can't add my macro... 

 

The contents of the attachment doesn't match its file type.

justynam
8 - Asteroid

My solution - main computing in iterative macro, short and simple.

Then wrapped in batch macro to calculate all 3 versions

jssandom
8 - Asteroid

First Batch Macro!

OldDogNewTricks
10 - Fireball

I've attached my solution which is a bit of a different approach.  The approach that I took was to minimize empty spaces in boxes (assuming that this would minimize our shipping costs).  For example order number 4 is 270 bottles so the passes would break down as follows:

 

Pass

1 - 2: 96 bottles in a box

3 - 8: 12 bottles in a box

9:       6 bottles in a box

 

This would be a fun one to revisit as an optimization problem if we had the shipping costs per box, packing costs per box, cost per box, etc...

jbranaum
8 - Asteroid

My Solution

 

Did the Batch Macro method to analyze all box sizes.

ipeng
8 - Asteroid

My solution attached