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
Comète

Reposting under my new user ID.

binuacs
Arcturus

solution attached

Tough challenge this one!

aiahwieder
Astéroïde

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

mmontgomery
Bolide

Challenge #66

CHarrison
Astéroïde

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

JesusER
Astéroïde

My solution:

Révélation
JesusER_0-1655473299732.pngJesusER_1-1655473317025.png

 

 

ddiesel
13 - Pulsar
13 - Pulsar

SUPER fun challenge!

 

My solution:

Révélation

 

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
Castor

My solution to #66.

 

Révélation
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
Pulsar
Révélation
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!