In Progress

Find shortest path and calculate value


Good day! This is my first project here. I would to have a vba in excel that will find the shortest distance and calculate the respect value associate with my table.

I would like to find the shortest path from start point (Col NE) going to the specified/proposed end point (Col Prop_EndPt), and indicate all points from Col M to Col F (Shortest Path) . Also add all load (Col Load1, Load2, then Shared Value) mentioned on the col shortest path.

The path matrix is indicated in the col L to O. The distance for NE and FE is on Col O (LoadCap).


Skills: Visual Basic for Apps

See more: vba calculate shortest path, find in vba, excel 2013 vba, VBA and excel, Value, excel distance, 2013 visual basic applications excel, 2013 excel visual basic, excel 2013 visual, visual basic excel 2013, distance calculate, excel 2013 visual basic applications, excel 2013 visual basic, applications excel, visual basic applications 2013, visual basic applications excel 2013, path vba, distance table, shortest distance, value table, calculate value, visual basic excel find, vba project day, vba find, find path excel vba

About the Employer:
( 6 reviews ) City, Philippines

Project ID: #4449626

Awarded to:


Hello, I can do this function.

₱1417 PHP in 3 days
(6 Reviews)

8 freelancers are bidding on average ₱1812 for this job


I have already done the functions... (Screenshot with test values: [url removed, login to view], copy and paste this in your browser). However, I need a little clarification (If you accept me as worker)...

₱2000 PHP in 3 days
(24 Reviews)

Hello, I'm interested to take your project. Thanx.

₱2220 PHP in 4 days
(1 Review)

very interested in this project, but sorry I work in hourly base my rate is 20$/hr so if you can meet this let me know I am in programming/VBA since 2001, you can read more about me at [url removed, login to view] Regar More

₱1820 PHP in 3 days
(5 Reviews)

Hi We are Expert in Excel Macro/VBA Please see our PORTFOLIO for Current and Past Projects

₱2130 PHP in 5 days
(1 Review)

Hi, welcome to [url removed, login to view]! I'm VBA macro coder, I can do what you are looking for, I can create a free demo for you, if you are interested in. Thanks.

₱1420 PHP in 2 days
(1 Review)

I am intrested to take up this project. Please let me know more details

₱1720 PHP in 1 day
(0 Reviews)

Dear friend, I can do this job because I have a great deal of experience in this area. I made some programs in Excel 2010 and successfully sold them. I know the insights. I hope to start this work as soon as possible. More

₱1770 PHP in 3 days
(0 Reviews)