You have chosen to sponsor your bid up to a maximum amount of .
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).