Hire A Programmer
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsOtherHire A Programmer

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old December 28th, 2004, 12:25 PM
estrellas estrellas is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Posts: 8 estrellas User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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.

Reply With Quote
Reply

Viewing: Dev Shed ForumsOtherHire A Programmer > Excel Macro (Written in VBA) to Evaluate Simple Case of Dijkstra's Algorithm Needed


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.

 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.

 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.

 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.

 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.

 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT