Challenge #166: I'm Gonna Be (500 Miles) - at Inspire

[Christina_H]

My solution

Spoiler

[geoff_zath]

Workflow

Spoiler

 

Map

Spoiler

[asultanov]

Spoiler

[Rob-Silk]

Solution attached below:

Spoiler

[lynnesonney]

I loved the mix of spatial and reporting here! helped me learn some of the cool feature of the report map tool as well 

[Bren_Spill]

Spoiler

[Erin]

I took a different (shorter) route to calculate the closest node per participant. 

Spoiler

I did a running total of the distance between nodes, and stacked that with the sum of participant miles. Then I used a multi-row formula to bring back the route node from the previous row (closest node but not farther than sum miles)

[Erin]

Woops, forgot something!

Spoiler

Pesky participant 5 forgot to walk/run/bike, and I forgot to include him/her! My bad! Updated workflow attached.

[Bobbyt23]

Great challenge. Loads of tools to use. Had to get a bit of help with the report map as never really used that much before.

[lwolfie]

Another missed turning in.