Important notice: All Credly Certification exam badges that have been unclaimed for 30 or more days will expire on August 28, 2024. To keep your badges active, log in to your Credly account and claim your badge before the deadline. (Don’t worry, this does not affect your Community badges!)

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 #246: Rectangle Tangle

AYXAcademy
Alteryx
Alteryx
A solution to last week's challenge can be found hererectangles.png
 
This week you are given 4 centroids which you can turn into a rectangle. Once you have created your rectangle, find the midpoints of the lines that connect those centroids, then make another rectangle from those points. Keep doing this until the area of the rectangle is less than 5 square miles.
Aaron_Harter
Bolide

I designed an iterative macro to solve this challenge:

Révélation
246.0.PNG

246.macro.PNG
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 246 is done!

 

Workflow:

Révélation
Jonathan-Sherman_0-1607954847432.png

 

Iterative Macro:

Révélation
Jonathan-Sherman_0-1607955358795.png

 


 

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Révélation

Workflow:
AkimasaKajitani_1-1607955209202.png
Iterative Macro:
AkimasaKajitani_0-1607955195268.png

 

Kenda
16 - Nebula
16 - Nebula
Révélation
An iterative macro made the most sense to me here (in vertical, of course)

Kenda_0-1607956314676.png

Kenda_1-1607956345974.png

 

 

dsmdavid
Bolide

Also iterative

Révélation
dsmdavid_0-1607956350455.png
dsmdavid_1-1607956460730.png

 

dsmdavid_2-1607956483769.pngdsmdavid_3-1607956611648.png

 

 

 

RolandSchubert
16 - Nebula
16 - Nebula

My solution - used an iterative macro

 

Révélation
246.png
PhilipMannering
16 - Nebula
16 - Nebula

First time doing a spatial calc in the multirow,

Révélation
MacroMacro

Challenge 246 - Snip.png
phottovy
13 - Pulsar
13 - Pulsar

So many rectangles:

 

Révélation
246.PNG

246_Macro.PNG
Greg_Murray
Quasar

This was a fun one. I took an iterative approach, outputting all of the iterations and only keep the last one. 

 

Workflow

Révélation
Greg_Murray_0-1607973240433.png



Iterative macro

Révélation
Greg_Murray_1-1607973351076.png

 

Bonus Rectangles! 

Révélation
Greg_Murray_2-1607973465882.png