Challenge #66: My Wine Problem

[jasperlch]

Solution attached.

[jamielaird]

I went for a fairly simple approach. First time I've used the Test tool and I can see this coming in handy in future.

Spoiler

[katelynhweber]

My solution, which uses the batch macro approach mentioned in the bonus.

[JosephSerpis]

Challenge Completed

[daniel_ferreira]

Follow my solution package attached...

I solved it using a batch macro and some message tools to avoid data input erros, but for me the best thing was to listen to UB40 during this exercise. It was really amazing!!!

Spoiler

WorkflowBatch Macro

[dsmdavid]

Built as an app with a batch macro inside...

Spoiler

Catching errors:
Catching errors

Main macro

Workflow of the app (+ checking results)

[tcroberts]

Here's my solution:

Spoiler

The stuff outside the macro isn't particularly exciting, but this should allow the user to specify the box size and will output correct results for each.

Heavy use of the Multi-Row formula tool to allocate boxes and correctly identify the BottleIDs in each box. RunningTotal was invaluable in preventing box overflows as well.

Did anyone find a way to do this without just appending box size to every observation? My only thought would've been to set a global constant to BoxSize, but I was unsure how to go about that with a user-specified input value.

Really enjoyed this challenge, it was a tough problem with some quirks to make it feel a little more like a real-world problem.

[danilang]

No bonus for me either.  But on the other hand...Yay  1st Macro built from scratch!  Cute little icon and everything

Spoiler

Dan

[kat]

Spoiler

[JoBen]

Cheers!