Excel Spreadsheet that calculates driving distances between multiple addresses

This project received 18 bids from talented freelancers with an average bid price of $108 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $250 USD
Total Bids
Project Description

I need an excel file that can calculate the driving distance between multiple addresses.

Please have a look at the attached excel file.

There are 2 sheets:

1 - shop list - addresses of the shops the sales reps need to visit
2 - sales rep - addresses of the sales reps

The first sheet has two empty columns. The name of the sales rep with the shortest driving distance shougld be filled in the REP NAME column and the driving distance in the REP DISTANCE column.

It should be possible to specify how many shops each sales rep gets (in absolut figures and in %). So it should be possible that all sales reps have the same number of shops or any other number assigned that I specify.

Please specify in your offer how you are going to solve this problem with 1-2 sentences (eg. Google Maps API, Bing Maps API, or whatever).

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online