|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Excel Macro (Written in VBA) to Evaluate Simple Case of Dijkstra's Algorithm Needed
Hi there --
I'm currently looking for a programmer to do a short little job for me. Here's the thing. It needs to be in excel and run off a macro (VBA) There is a mine of width W (user inputs width into the screen). Each unit of conveyer belt is 7 feet long. So W/7 = Number of Nodes. The conveyer belt goes in a straight line. Each node has a cost associated with it. Also input by the user (Need to have the exact number of fields "light up" or something so the user knows if he's entered too many/too few costs when entering them.) OUTPUT: The Combination of Nodes that lead to the least cost produced. For example: a Sample input could be: W=35 Cost Node 1 to 2: $500 Cost Node 1 to 3: $600 Cost Node 1 to 4: $200 Cost Node 1 to 5: $1000 Cost Node 2 to 3: $200 Cost Node 2 to 4: $400 Cost Node 2 to 5: $1000 Cost Node 3 to 4: $100 Cost Node 3 to 5: $400 Cost Node 4 to 5: $25 Again, the program needs to: 1) insure that only one unit is coming in and leaving during the analysis (minimum cost requirement) 2) Output the node combination that has the minimum cost (ex. 1 to 4 to 5) 3) Be pretty user friendly This is a pretty easy program/algorithm to code, I've done it in C++ but don't have the time to do it in VBA ... pay is negotiable and will pay after completion/evaluation through paypal. email me at rmullen@mines.edu if you are interested! Thanks in advance. |
![]() |
| Viewing: Dev Shed Forums > Other > Hire A Programmer > Excel Macro (Written in VBA) to Evaluate Simple Case of Dijkstra's Algorithm Needed |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|