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

Challenge #266: Mother's Day Bouquet

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereSource: https://nymag.com/strategist/article/best-mothers-day-flowers.htmlSource: https://nymag.com/strategist/article/best-mothers-day-flowers.html

 

This week's challenge was submitted by @sara_burk  - Thanks for your submission!

 

Flora is the owner of Flora's Flower Décor and More. Each year, she systematically plans out her delivery schedule for Mother's Day deliveries and what the most efficient delivery route will be.

Considerations:
1) Flora always creates her delivery schedule on the day before Mother's Day. This year Mother's Day falls on May 9th. Any order placed on or after May 8th will be available for in-store pick up only.
2) In order to qualify for delivery, the order cost must reach $50.
3) Flora only has time to deliver flowers to the closest 30 customers to the floral shop. The rest of the customers will have to pick up their flowers from the store.

Flora will start at the flower shop, and consecutively go to the next closest location (based on distance, Miles). Create a macro that will help Flora optimize her route and then map the outcome. How many miles will Flora drive?

PhilipMannering
16 - Nebula
16 - Nebula

I must remember to... oh wait.. the UK Mother's Day was several months ago.. : /

 

Spoiler
PhilipMannering_0-1620050664793.png

 

 

 

dsmdavid
11 - Bolide

Might we worth revising that strategy, Flora...

Spoiler
least.png
going from closest point to next closest point

vs

restricting to 30 closest points to Flora's shop
30least.pngdsmdavid_0-1620053031822.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1620053406330.png

Macro : 
AkimasaKajitani_2-1620053449170.png

 



AkimasaKajitani_1-1620053422791.png

 

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Workflow:
Maskell_Rascal_0-1620056001432.png

Iterative Macro:

Maskell_Rascal_1-1620056020722.png

Map Output:

Maskell_Rascal_2-1620056110586.png


Number Miles: 

56.1356

 Cheers!

Phil

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
266-W.jpg266-M.jpg
clmc9601
13 - Pulsar
13 - Pulsar

My solution!

 

Spoiler
56 miles (no return)
63 miles (including return)

Screen Shot 2021-05-03 at 10.39.34 AM.png

48 miles (including return, using @dsmdavid's strategy. You're right-- it's still more efficient!) 

Screen Shot 2021-05-03 at 10.43.45 AM.png

Screen Shot 2021-05-03 at 10.36.30 AM.png

BeginnerMindset
8 - Asteroid

Great challenge.

 

Spoiler
BeginnerMindset_0-1620063576107.png

Iterative macro:

BeginnerMindset_1-1620063613805.png

 

phottovy
13 - Pulsar
13 - Pulsar

I built it with two options, closest to the store or closest to the previous delivery:

 

Spoiler
266.PNG

266 Macro.PNG
UI.PNG
Map1.PNGMap2.PNG

 

 

Spalders
8 - Asteroid
Spoiler
Spalders_0-1620067269380.png

A slightly different route, going to the nearest next stop and a long trip home 48.29 miles in total