Challenge #66: My Wine Problem

[cplewis90]

Fun challenge! I was able to create a macro that boxed all the different sizes. 

Spoiler

[TonyA]

Didn't go for the bonus. I had a lot of struggles trying to figure out how to manage compares when the types of the columns might be different from one run to the next. Finally sorted it out.

Spoiler

Two things I learned: First, ToString() can accept a string parameter and not throw a type error. Similarly ToNumber() can accept a number parameter. Second, Int16: Forced can be very handy.

[archietao]

my solution:

[archietao]

used two macros to solve this. 

[acrahen]

Going for the double-secret bonus.  Used a chunk macro I already built for another purpose.

Spoiler

[bkclaw113]

As a few people mentioned I found how this was worded to be very confusing as well.  They kind of missed the point of having numbered bottles . . . they need to be unique.

However, for this challenge to work you need to assume that the order number and the bottle number make up the composite unique key, so OrderID1 can have BottleID 1, and the completely seperate OrderID 2 can also have a bottle with BottleID1.  Think of it more like 1.1 and 2.1.

Anyway I did end up with a batch macro handling the box size, calling an iterative macro sorting the bottles into the boxes.

[Eleonora]

My first batch macro. Took a while

Spoiler

[Thableaus]

Challenge #66, done.

Spoiler

Cheers,

[msicak]

agree with @MarqueeCrew that batch is not needed for this scenario, went for it for practice.

Spoiler

[T_Willins]

Fun batch macro practice.  I did this during breaks during the Advanced Macro class at #Inspire19

Spoiler

Spoiler