Search

Close

Start Free Trial

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

A solution to last week's challenge can be found here.

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.

I designed an iterative macro to solve this challenge:

Challenge 246 is done!

Workflow:

Iterative Macro:

My solution.

Workflow:

Iterative Macro:

An iterative macro made the most sense to me here (in vertical, of course)

Also iterative

My solution - used an iterative macro

First time doing a spatial calc in the multirow,

Macro

Macro

Challenge 246 - Snip.png

So many rectangles:

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

Workflow

Iterative macro

Bonus Rectangles!