Plan Efficient Routes for Field Personnel Using Optimized Routing & Time Windows

A traveling sales person/repair technician works for Acme HVAC. The rep both sells and repairs HVAC systems. Consolidation of the sales and repair groups is a recent company experiment. While the consolidation cut company travel expenses in half, not all repair people can sell, and not all sales people have the skills to repair HVAC systems. Still, there was a lot of overlap.

Problem: How can a traveling technician schedule appointments and plan efficient travel and while accommodating cancelations?

Wearing two distinct hats means field technicians have little time for problems in scheduling. One canceled appointment and the whole week can deteriorate. Field techs found themselves far afield when customers canceled a scheduled appointment. Such cancelations can destroy three to four hours of repair or sales time, often several times a week.

Solution: Subscribe each sales person to a business mapping software that provides optimized routing services that can help manage schedules.

The State of Online Map Routing

Business mapping tools provide many productivity enhancing features including:

  1. Efficient turn-by-turn directions across multi-stop optimized routes
  2. The ability to import and adjust routing stops by time window
  3. A view of alternative accounts and prospect locations across the entire sales and repair coverage area, so when visits get canceled technicians can more easily substitute a new appointment immediately

Mapping software routing is a common feature on cell phones and Internet mapping tools. Less common is the ability to build multi-stop optimized routes with up to one hundred stops per route. With the addition of time windows, routing becomes a full-fledged scheduling tool. Field technicians can estimate visit times by stop. So now a full week’s schedule can be planned and considered with driving time, customer visit times and even a lunch stop off.

Turn-by-turn directions are included in business map routing tool results output. Acme reps generate directions to customer locations and use the results to submit travel reimbursement reports. Route stops and directions are exportable as PDF, CSV, GPX, and popular Personal Navigation Device file formats. This means sharing maps, routes, and itineraries is easy. This comes in handy for route hand-offs on sick days or in emergency response mode.

Acme field technicians are encouraged to import customer and prospect address databases into the map application. These customer records are usually color coded and symbolized for easy viewing on the map – depending on field tech priorities:

  • Color code prospects and customers differently for fast identification
  • Color code customer locations by planned visit week, or visit day
  • Color code the coming week’s scheduled appointments Red and turn visited stops Green as completed or Yellow if further work is required

How to Import an Excel Sheet of Customer Addresses & Route

  1. Prepare an Excel sheet of customer addresses with separate columns for Address, City, ZIP, etc.
  2. Use the Plot Data button to navigate to and select your data. Process the data to the map while choosing labeling options
  3. Color Code and Symbolize customer pinpoints as required
  4. Filter Select or Polygon Search Select a subset of customer records for the day or weeks activity
  5. In the Data Window, view the search results and choose the Add All Rows to Route option
  6. Adjust stop orders and amend stay durations as necessary
  7. Alternatively, a user can incrementally select points for route stops by click the Car icon in the label or in the Data Base view
  8. Choose optimize or route in order of list. Select round trip route as required

Acme HVAC field technicians are required to have the latest customer and prospect datasets loaded in their MapBusinessOnline map view. In the event of a sudden field cancelations, traveling techs can find other customers or prospects in the area to contact. With any luck, they will have service requirements come due and another trip to the area can be avoided. The company has received several unplanned orders due to rescheduled visits.

The mapping tool also include a map sharing option, transmittable by email, the enables a fast hand-off in the event of an emergency or duration overruns. These interactive web maps even allow Acme field reps to create new routes in the field as required.

Business mapping software with routing and time windows provides a platform for field technician workflow scheduling. Affordable cloud-based services that control costs.

Learn How Our Customers are Succeeding with MapBusinessOnline

One of many international companies left hanging by Microsoft’s cancelation of MapPoint and turning to MapBusinessOnline for a MapPoint replacement. Multiple departments across the enterprise utilize business mapping for a variety of applications including claims management analysis, insurance related operational planning, and market analysis. An extremely detailed procurement and security review lead to a contract for MapBusinessOnline services. Corporate accounts use MBO for sales territory mapping, collaborative Team editing, and communicating with maps.

Top Ten Property & Casualty Insurer


"I have had the pleasure of using MapBusinessOnline for the past 5 years and it is an excellent and affordable tool for my clients. I am a franchise consultant, and many of my clients are just starting to get into franchising. The first main question many of them have is they don’t know the demographics around their current location, so they don’t know how to create territories for their franchisees. I am able to easily utilize MapBusinessOnline to draw a prototype territory around their existing location, do a deep dive into the many different demographics that MapBusinessOnline offers, and help the client determine the basics of their new territories, including mileage, population, household count, purchasing habits and age distributions. This tool has been so helpful that many of our clients obtain their own accounts as they begin to sell franchises and grow their business. Thank you, MapBusinessOnline, for providing such a helpful tool that is affordable and easy to use!"

Colette Bell
Director of Business Development
SMB Franchise Advisors


"We use MapBusinessOnline to prepare for sales meetings. The program’s territory mapping enables color-coded sales territories by zip-code helping to define sales responsibilities and keeping our focus on selling."

Christie Shedd
Operations Manager
AFTCO Bluewater

Popular MapBusinessOnline features

Build fast map visualizations of your business data

Map business data from various sources by street address, city name, ZIP code, or latitude and longitude. Plot 250,000 or more locations on a map at once. All you need to start is a spreadsheet with business data.

Plan customers visits with optimized routing

Use maps to identify customers within a radius or polygon. Optimize visits sequence and generate turn-by-turn driving directions. Reduce travel costs. Improve ROI and productivity.