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

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!

challenge_129_start_file.yxmd

Join

Spatial Analysis

Preparation

Predictive Analysis

Advanced

Intermediate

Data Preparation

Transform

Predictive

Spatial

Accepted answers

All comments

patrick_digan

Spoiler

challenge_129_start_file.yxmd

JoBen

This was a fun one. Thanks for posting!

JoBen

Sorry, here's my solution!

challenge_129_JoBen_Solution.yxmd

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!

challenge_129_DavidP.yxmd

danilang

Nice quick finishing lap

Spoiler

Location 4 with 178 attendees and 4440 total cost

Solution 129.png

Dan

challenge_129_solution_DL.yxmd

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.

challenge_129_gg_finish.yxmd

Wouter

Fun challenge @JimmyG! here's my solution:

Spoiler

challenge_129_solution_WK.yxmd

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!

JimmyG

Glad you enjoyed it, @Wouter!

neilgallen

Fun exercise once I wrapped my head around the requirements.

Once again, congrats to @NicoleJohnson. I can't imagine attempting this with several thousand people watching me.

challenge_129_NGA Solution.yxmd

jamielaird

Solution attached. Manually updated the capacity for location 4 to make the figures work.

Spoiler

challenge_129_JL.yxmd

Juanito70

Continue to learn to use new tools. Thanks for the challenge!

Spoiler

challenge_129_start_file._JUANGROLONyxmd.yxmd

mpennington

Solution attached. Great exercise, thanks for these.

Spoiler

challenge_129_MP.yxmd

Sami

My solution!!

Spoiler

challenge_129_Solution_HS.yxmd

danrh

Spent way too much time banging my head against the wall trying to figure out why my answer didn't match.

Spoiler

Finally realized there are multiple people per customer

solution.yxmd

dtokarz312

Happy Monday! Here is my solution.

Spoiler

Spoiler Alert

challenge_129_DT.yxmd

kat

Spoiler

congratulations @NicoleJohnson!

Challenge #129.yxmd

PeterF

here you go :-)

challenge_107_start_filePF.yxmd

TylerNa

Hope location 4 is tasty!

Spoiler

WC129 LunchHosting.yxmd

OldDogNewTricks

Solution attached.

Too slow...

challenge_129_completed.yxmd

jasperlch

A very nice exercise on Spatial tools. Thanks!

challenge_129_JL.yxmd

ZacPhan

Finished! Fun while it lasted

challenge_129_zacp.yxmd

Kudrnac

I attach my solution, thanks for this challenge. I had a different capacity in the Text Input Tool than in the control solution, but it did not influence the result.