Your territory has 25 schools that needs to be visited and you have all these multiple addresses written in Excel file.
|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:
- Click Import File and select the file you wish to upload to MyRouteOnline.
- Select the sheet which contains your data.
- Check Ignore the first row if it contains the column header.
- 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).
- Select the right header for each column (Address/Title/Service Time/Filter-in/Filter-out/Ignore).
- Review the import result and click Import Now.
B. Now that your list was imported, you should set all the needed routes parameters:
- Check the Return box, to make sure your routes start and end at the office.
- Departure time is 9:00.
- Service time is the time the leaflet distributors spend at each stop (school).
- 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.
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.
Your email will include a map and the original parameters you set in the route planner:
And below you will find the route plans themselves with a link to get driving directions: