Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more 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
SOLVED

Challenge #135: Locker Problem

afv2688
16 - Nebula
16 - Nebula

Nice one!

 

Spoiler
Untitled2.png
T_Willins
14 - Magnetar
14 - Magnetar

My solution   ...as John Bender runs down the hall, closing lockers, singing, "I wanna be an Airborne Ranger..."

 

Spoiler
Macro 135.JPG

 

Workflow 135.JPG

 

abassett
6 - Meteoroid

There is an intuition to this solution rather than relying on macros as I have done.

 

Spoiler
Locks that will be open are those with an odd number of factors (numbers that divide it).

As factors come in pairs, the only way a number can have odd number of factors is if one factor pairs with itself, ie the number is a (perfect) square.

Then it just all the squares upto N.

Generate rows upto SQRT(N) then square each number.

But that's too much maths and Alteryx is more fun!
dsmdavid
11 - Bolide

Finally able to attach files.

sgrabish1
8 - Asteroid

Thanks for practice exercise; mod is useful indeed!

Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1574723567283.png
KMiller
8 - Asteroid

Solution attached.

Spoiler
20-12-2019 08-23-18.png20-12-2019 08-23-13.png
AV8
8 - Asteroid

Getting good practice with iterative macros.

Spoiler
Spoiler:135_workflow.JPG
Spoiler
Spoiler:135_Macro.JPG
nini
8 - Asteroid

My Solution:

my solution