Challenge #129: US Grand Prix Lap 3 - Where to Host an Event

[JimmyG]

And now on to the final lap! We've completed a lap on data prep, one on predictive, and we round out the Grand Prix with a lap involving spatial.

This one was a nail-bitter in Anaheim, with two drivers finishing in the final seconds and @NicoleJohnson taking home the cup! 

If you're headed to Inspire Europe and want to give a shot at qualifying for the Grand Prix, check out this article explaining all the rules and how to register.

Enjoy!

[patrick_digan]

Spoiler

[JoBen]

This was a fun one. Thanks for posting!

[JoBen]

Sorry, here's my solution!

[DavidP]

Just a minor comment. The answer states that the Capacity of location 4 is 250, but it's actually 300.

Thanks for a great challenge!

[danilang]

Nice quick finishing lap

Spoiler

Location 4 with 178 attendees and 4440 total cost

Dan

[ggruccio]

Fun challenge!  

I'm with @DavidP on the Capacity.  Mine says 300 as well (in the start file).

Spoiler

My initial thought was to go to the optimization tool, but quickly realized it could be solved using spatial tools and summarize.

[Wouter]

Fun challenge @JimmyG! here's my solution:

Spoiler

[JimmyG]

Good catch, @DavidP. To peel back the curtain a bit, we do a significant amount of testing of these workflows and one of the things we test is to see if someone could stumble across the right answer in a way we did not intend. One of our testers found something that had me change the capacity, but looks like I posted an earlier version than the one with the "final" output.

[JimmyG]

Sure thing, @JoBen! Thanks for solving!