Closed

Excel Spreadsheet that calculates driving distances between multiple addresses

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: Data Processing, Excel, Software Architecture, Visual Basic, Windows Desktop

See more: excel multiple distances, calculate driving distance addresses excel, it sales rep, google sheets api, google excel spreadsheet, spreadsheet API, i need sales reps, i need a sales rep, driving distance, excel list addresses, google distance excel, google sales maps, excel distance, spreadsheet columns, spreadsheet sales, google excel multiple columns column, sheet excel visual basic, 2013 excel visual basic, excel 2013 visual, excel sheets need filled, google spreadsheet sheet, excel file columns, google maps api multiple maps, visual basic excel 2013, distance calculate

About the Employer:
( 19 reviews ) Dausenau, Germany

Project ID: #4821530

17 freelancers are bidding on average $108 for this job

Dhruvika111

Dear,johnmar! Yes its possible.....Please refer to your PM once and iam sure you will assign the job to N-Office Solutions. Thanks. Dhruvika N-Office team.

$93 USD in 1 day
(87 Reviews)
6.8
seaanddream

Hello; I've just seen your project. I am expert in excel and vba coding. I am ready to help you, pls get back to me if you wish to proceed with a top-rated expert here...regards,

$95 USD in 3 days
(38 Reviews)
5.2
northwolves

I can help you,see PMB please.

$70 USD in 3 days
(57 Reviews)
5.2
aaravsoft

Hello, Please check personal message box. Regards,

$70 USD in 2 days
(31 Reviews)
4.9
javed1705

excel expert here, ready to do this job for you

$74 USD in 3 days
(23 Reviews)
4.9
jaylancer43

Excel VBA Expert. Please check PM for details. Thanks.

$77 USD in 3 days
(19 Reviews)
3.9
tikumishra

I can do this using Google MAP API and [url removed, login to view]

$111 USD in 3 days
(5 Reviews)
3.7
logoDS761

I am very experienced in this field

$80 USD in 3 days
(2 Reviews)
1.7
dcart

Hi I can do this. I will provide you with the map sketch of each shop location plus the shortest distance from the address of your sales rep.

$77 USD in 3 days
(1 Review)
1.5
sanskar

I am experienced software developer.I can give you best quality application as per your requirements.I have gone through your requirements ,I assure the project to be completed on time with good Quality. looking forwa More

$133 USD in 3 days
(1 Review)
1.4
spaul1107

Hello, I can do this. Please check PM for details

$66 USD in 3 days
(1 Review)
1.0
insideworld

I have seen your sample and I am ready to take this project. Waiting for your reply.

$206 USD in 3 days
(0 Reviews)
0.0
JrMarsh90

I have some code which uses the Google Maps API, I will then use a simple formula to allocate the closest sales REP. I can send an example spreadsheet from a previous project should you need an example of the work More

$166 USD in 3 days
(0 Reviews)
0.0
faysal07

I have experience with your project requirements , check pm.

$102 USD in 3 days
(0 Reviews)
0.0
Yeniextrudeworks

We are small agency from Indonesia ready to help your works. We have great team with the best skills in their field to complete your project design. extrudeworks

$66 USD in 3 days
(0 Reviews)
0.0
MattMK

I understand all the requirements and I am ready to start right now.

$80 USD in 3 days
(0 Reviews)
0.0
Midlander

John, Sending you a sample excel 2010 spreadsheet that does what you want using a graphic routeplanner and formulae. Happy to do this under Confidentiality and Non-Disclosure Agreement, starting as soon as you pa More

$93 USD in 2 days
(1 Review)
1.4
metizsoft

Hi, I have reviewed your job post and we are interested in your project. We are able to deliver your work with your satisfaction. Please find more detail on your pm.

$277 USD in 20 days
(0 Reviews)
0.0