Challenge #369: Formula 1 Grand Prix (In)efficiency

[balajilolla2]

Spoiler

Solution Attached

[acarter881]

Here's my solution. It seems like there may be something wrong with the way the Find Nearest tool works in certain scenarios. The others who are getting a smaller result for the second output (i.e., minimizing distance) are going about it differently than simply using an iterative macro with the Find Nearest tool. I tested it, and for some reason the result from Las Vegas Strip Street Circuit to Autódromo José Carlos Pace is taken by Find Nearest when Suzuka Circuit is available and is closer. This is easily tested, and I'm not sure why the Find Nearest tool has this issue. My answer reflects following the instructions, so I match the output. However, for accuracy, it would be better to manually calculate the distances since the Find Nearest tool is giving erroneous results.

Spoiler

Workflow:

Macro:

[Clifford_Coon]

This was a fun one. My Solution:

Spoiler

Workflow

 
Macro:

 

 I used integer values, so total distances off by 1-2 km. 

[opoleleyeva]

solution

Spoiler

[Luke_C]

Spoiler

[TurboToad]

Fun challenge! Didn't use the Find Nearest tool so my answer for #2 was a shorter distance. 

Spoiler

[Flo_P]

Spoiler

Interesting challenge and learned quite a bit from other members solutions

[Christina_H]

Agree with others that the route is shorter than the provided answer.

Spoiler

[ferg_smith]

Spoiler

[CeliaC_Silje]

I saw the reply that using FindNearest tool will take the result with longer distance while there is an available option with shorter distance.

So I tested using both FindNearest tool and Distance tool, and both macros actually gave me the same result (but still smaller than the suggested answer).

Not sure what is the reason behind tho ...

Spoiler

Workflow


Macro (Use FindNearest)


Macro (Use Distance)