Challenge #66: My Wine Problem

[estherb47]

I might have had a little too much fun with this one....

First assumption that I made was that the first macro would divide up one order at a time, and allow the user to put in the first and last bottle they want through an interface.

Went with a tiled solution instead of the multi-row formula method.

And, naturally, added some graphics for custom buttons.

Spoiler

Spoiler - one at a time with user input

Spoiler

Batch macro solution. Outputs all 4 box sizes at once (6,12,96,120)

[SeanAdams]

I love the little wine themed icons Esther :-) Did you come up with a good icon for your wine-box packing company (thinking of a stick figure, some boxes and wine and lots of question marks)

😁

[LordNeilLord]

I avoided this one for a while but it was actually easier than I thought it would be!

Spoiler

[patrick_digan]

Spoiler

[patrick_digan]

Inspired by @Joe_Mako, I was able to get the macro down to 6 tools

Spoiler

I just packed a bunch of info into the generate rows tool and then deconstructed it with a formula tool :) It's obviously not very easy on the eyes or straightforward...

[samN]

Fun challenge. Used a batch macro and will await my bonus points :)

Spoiler

I just filtered by the conditions in my macro and if they didn't fulfill them it did not try to complete those orders. No errors are ever thrown if this happens.
I also left some of the filtering outside of the macro because i felt like it would be easier to change in case we get additional box sizes. I like my macros to be more than just one time uses and work around them instead of constantly changing them. Granted not sure ill ever use this one again, but you get my point, reader. 

[ggruccio]

Did the challenge and the bonus.

[LandonG]

Solution attached. Great success!

[PhilipMannering]

I want the bonus points - give them to me now. Solution attached.

Spoiler

This is my workflowThis is my macro