Tag Archives: multiple addresses

Leaflet distribution to schools in Chicago – Learn how to use our Route Planner

Your territory has 25 schools that needs to be visited and you have all these multiple addresses written in Excel file.

# School Name Address Address
1 Office 64 Washington Blvd, Oak Park, IL 60302 Chicago, IL 60602
2 Bell Elementary School 3730 N Oakley Ave Chicago, IL 60618
3 Decatur Classical Elementary School 7030 N Sacramento Av Chicago, IL 60645
4 Young Magnet High School 211 S Laflin St Chicago, IL 60607
5 Edgebrook Elementary School 6525 N Hiawatha Ave Chicago, IL 60646
6 Hawthorne Elementary Scholastic Academy 3319 N Clifton Ave Chicago, IL 60657
7 Keller Elementary Gifted Magnet School 3020 W 108th St Chicago, IL 60655
8 Jackson A Elementary Language Academy 1340 W Harrison St Chicago, IL 60607
9 McDade Elementary Classical School 8801 S Indiana Ave Chicago, IL 60619
10 Skinner Elementary School 1443 N Ogden Av Chicago, IL 60610
11 Edison Regional Gifted Center 4929 North Sawyer St Chicago, IL 60625
12 Lenart Elementary Regional Gifted Center 8101 S La Salle St Chicago, IL 60620
13 Blaine Elementary School 1420 W Grace St Chicago, IL 60613
14 Franklin Elementary Fine Arts Center 225 W Evergreen Ave Chicago, IL 60610
15 Lasalle Elementary Language Academy 1734 N Orleans St Chicago, IL 60614
16 Courtenay Elementary Language Arts Center 1726 W Berteau Ave Chicago, IL 60613
17 Lincoln Elementary School 615 W Kemper Pl Chicago, IL 60614
18 Norwood Park Elementary School 5900 N Nina Ave Chicago, IL 60631
19 Oriole Park Elementary School 5424 N Oketo Ave Chicago, IL 60656
20 Audubon Elementary School 3500 N Hoyne Ave Chicago, IL 60618
21 Burley Elementary School 1630 W Barry Ave Chicago, IL 60657
22 Canty Elementary School 3740 N Panama Ave Chicago, IL 60634
23 Coonley Elementary School 4046 N Leavitt St Chicago, IL 60618
24 Chopin Elementary School 2450 W Rice St Chicago, IL 60622
25 Disney Elementary Magnet School 4140 N Marine Dr Chicago, IL 60613
26 Dore Elementary School 6108 S Natoma Ave Chicago, IL 60638

You have two leaflet distributors doing these routes and you need them back as soon as possible for their next route. So you need this list separated into two different routes, both start from your office at 9:00.
You can Type the Start address in the first row, or add it to the list of addresses you have in Excel (in this example, the office is written in the excel, at the top).

A. You can import this file to the Route Planner:

  1. Click Import File and select the file you wish to upload to MyRouteOnline.
  2. Select the sheet which contains your data.
  3. Check Ignore the first row if it contains the column header.
  4. Check First/Last address if you have any (in this example you have a start address and we will make this a ‘return’ trip in the next step).
  5. Select the right header for each column (Address/Title/Service Time/Filter-in/Filter-out/Ignore).
  6. Review the import result and click Import Now.

Route planner import wizard 

B. Now that your list was imported, you should set all the needed routes parameters:

  1. Check the Return box, to make sure your routes start and end at the office.
  2. Departure time is 9:00.
  3. Service time is the time the leaflet distributors spend at each stop (school).
  4. Number of routes is 2 since you have two leaflet distributors. This may change according to your personnel or vehicles etc.

C. You can also set Multi-Route parameters (Max. Route Duration or Max Stops per route) but this is usually used when there are more addresses to visit.

D. Select your Goal:

    Minimize Distance will reorder your multiple addresses to receive the shortest route.

    Minimize Time will reorder your multiple addresses to receive the fastest route.

    Balance Time and Distance will reorder your multiple addresses to receive the most efficient route considering Time and Distance.

    Keep Order As Is will keep the order of your list of addresses but will give you a route plan connecting them.

E. Click Plan My Route – You will receive the best route for your selected Goal. In this example it was Minimize Distance.

Route plan Chicago 

F. After planning your route, click Send to my Email. In case you planned more than 1 route, you may choose to send 1 route or all routes to your email.

In the Email to section, your email address will appear as default but you can change it or send it to both your distributors at once, using a comma to separate their email addresses.

If you need this route plan to be used with your GPS device, change the GPS Files section to include the format you need.

Add a name for the route or any other message under Free Text and click Send Email.

 Email route plan

Your email will include a map and the original parameters you set in the route planner:

Emailed route plan 

And below you will find the route plans themselves with a link to get driving directions:

Route 1 Chicago 

Route 2 Chicago