Excel Spreadsheet that calculates driving distances between multiple addresses

CLOSED
Bids
18
Avg Bid (USD)
$108
Project Budget (USD)
$30 - $250

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).

Skills required:
Data Processing, Excel, Software Architecture, Visual Basic, Windows Desktop
Additional Files: Freelancer example excel file.xlsx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 93
in 1 days
$ 95
in 3 days
Hire northwolves
$ 70
in 3 days
$ 70
in 2 days
Hire javed1705
$ 74
in 3 days
$ 77
in 3 days
Hire tikumishra
$ 111
in 3 days
$ 80
in 3 days
Hire dcart
$ 77
in 3 days
$ 133
in 3 days