Challenge #66: My Wine Problem

[Alteralex]

Spoiler

[peterlaw0912]

Need to get a drink after the challenge!

[Bobbyt23]

Really struggled with this challenge, just couldn't get my head round it, so I used @BenMoss solution as a walkthrough. Really slick solution.

[beatriz_alteryx06]

Bonus question, just not batch.

[mshishido]

hi

[DaisukeTsuchiya]

Spoiler

[BransonJamesFarley]

Solution (thank you other for reference to help)

Spoiler

 

[GDickinson]

Batch macro solution

[agomoll]

Here is a solution that takes in the order and then provides the number of boxes needed. Although, it does not provide the bottle to box mapping, it does include the input error testing and appends the order to a master order sheet.

[fluteman]

I did mine with a twist. It has the interface and tells you based on the quantity determine the batches where you are not using a 96 bottle batch for 50 bottles. some work could be done to customize this into three flows and it could tell, you 1 x 96 with 1 x 6 for say 98 bottles. But the ask was to spit out # of batches by bottle qty size. :-)