Challenge #266: Mother's Day Bouquet

[FilipR]

This one was harder than expected! But it was fun nevertheless.

[lynnesonneyrsm]

overthinker x10

I knew it was iterative but somehow complicated the loop - got there in the end

[Bobbyt23]

Really great challenge, clever macro in this one mixed with practising spatial and report tools.

[westlakecjw]

Spoiler

Solved with a macro:

Spoiler

[Deborah_Simmonds]

Great EMEA session by @FilipR Unfortunately version 2023.2.1.7 restricts Find Nearest to only 20 points maximum...so this is what my solution shows.

[Leyla7777]

Thanks to @FilipR, well explained with macros!

[Bren_Spill]

Spoiler

Workflow: 

Macro:

Output:

 

 

 

[Bobbyt23]

Good challenge

[Christina_H]

As some others did, I originally took the 30 orders where each was closest to the order before.  Limiting to the 30 orders closest to the shop gives a longer route.

[griffinwelsh]

My solution. This is the first time I have used an iterative macro with spatial objects. I noticed that at least in my version spatial objects cannot be copied into a macro input which is really annoying in this use case.