FIRST Robotics Event Planner


This application uses the BING mapping engine to help you match teams with events. First you load the team addresses, then the event venue addresses from CSV files which you can create using your favorite spreadsheet app. Then simply click the "Auto" button to compute the driving distance of each team to each venue and assign teams to venues in a way that minimizes driving distance while ensuring each event has a minimum number of teams and no more than a certain maximum number. The app is quite fast, it can match over 400 teams with 5 events in a split second. BING is also quite fast, it can compute 2000 individual routes in about 5 minutes.

Click the Install button to make this a desktop silverlight application so it can access your spreadsheets.

Get Microsoft Silverlight

Once installed you can launch it from your start menu. Internet Explorer can't launch it for you because it doesn't have permission. On Windows 8 your start menu will contain the following:

Note: To un-install the app later you'll find the un-install command in the right click context menu, instead of using the Add/Remove programs dialog.

Video

The following video gives a quick 5 minute run through on how to use the tool.

Spreadsheet Formats

The Team spreadsheet must contain at least the following columns:

Team Number The team number (an integer)
Team Name The name of the team
Address The street address where the team is located
City The city
State The state or province
Zip The zip code or postal code
Country The country

See sample team locations spreadsheet.

The Venue spreadsheet must contain at least the following columns:

Event Name The name of the event
Venue Name The name of the venue where the event is taking place
Address The street address of the venue
City The city
State The state or province
Zip The zip code or postal code
Country The country
Event Date 1 The first day of competition at this event
Event Date 2 The second day or empty if there is no second day
Event Date 3 The third day or empty if there is no third day
Max Capacity The maximum number of teams allowed to be scheduled for a given day at this event
Min Capacity The minimum number of teams needed to ensure a viable competition at this event

See sample venues spreadsheet.

Enjoy!

Chris Lovett