Challenge #66: My Wine Problem

[ConradW]

Spoiler

[MarMu]

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

[Laurap1228]

I went for the Batch Macro solution

[pasccout]

My solution

[pasccout]

Can't add my macro... 

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

[justynam]

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

Then wrapped in batch macro to calculate all 3 versions

[jssandom]

First Batch Macro!

[OldDogNewTricks]

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]

My Solution

Did the Batch Macro method to analyze all box sizes.

[ipeng]

My solution attached