Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #66: My Wine Problem

TonyAndriani
9 - Comet

Reposting under my new user ID.

binuacs
20 - Arcturus

solution attached

thano_thayalan
5 - Atom

Tough challenge this one!

aiahwieder
8 - Asteroid

A macro felt like overkill to me . . . good ol' Append!

mmontgomery
11 - Bolide

Challenge #66

CHarrison
8 - Asteroid

The best part about making a macro is decorating it with a nice icon ;)

JesusER
8 - Asteroid

My solution:

Spoiler
JesusER_0-1655473299732.pngJesusER_1-1655473317025.png

 

 

ddiesel
13 - Pulsar
13 - Pulsar

SUPER fun challenge!

 

My solution:

Spoiler

 

I built a macro to solve the challenge, but my brain went to analytic app with option to choose a custom box size. I had to stop myself from customizing the app further, but I imagine check boxes for each standard box size plus an optional input for custom box size.



I built a standard macro to solve for all 3 box sizes. The solution seemed simple enough without a batch macro.
Capture2.JPG


App with custom box size selection:

Capture.JPG


P.S. For the DOUBLE BONUS... I did indeed listen to Red Red Wine while drinking a glass of red wine. Happy Friday!

DataNath
17 - Castor

My solution to #66.

 

Spoiler
DataNath_0-1656234889498.png


Macro:

DataNath_1-1656234978405.png


End < Start error:

DataNath_3-1656236166366.png

 



The way it's set up doesn't allow non-numeric input and defaults to 50 if left blank/null.

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1656434155135.pngJamesCharnley_1-1656434165716.png

 

 

Fancied looking for some macros practise with this one. I did get said macro practise, but it was comfortably the easiest part of this challenge!