+ Reply to Thread
Results 1 to 1 of 1

Need help understanding TSP based on a guide/article "almost step-by-step"

  1. #1
    Registered User
    Join Date
    08-24-2014
    Location
    Romania
    MS-Off Ver
    2013
    Posts
    18

    Need help understanding TSP based on a guide/article "almost step-by-step"

    Hi,

    I have a problem that I am facing at the moment and I don't know to solve it.
    I have to create an automated excel file in which I have to add or remove locations (cities) for my "imaginary" trucks to deliver goods.
    I stumbled across this method, Traveling Salesman Problem, and I think this is the method I need for making my problem work however I am short on understanding completely on how to create the file.

    The article that I am referring is this one: http://www.economicsnetwork.ac.uk/ir.../rasmussen.pdf

    I tried making the the "normal approach" however, this is not the best solution because the truck will have to pass throuw every town and at the end of the trip, the truck maybe has made 10.000km and delivered only 1package/town so this is not the best decision.

    So after I read the entire article, I believe that the best option for me is making the excel using the "tips" presented in section :

    15. Non‐complete graphs requiring multiple visits
    So, as a visual representation (not the ideal one, is just to get a better idea) is to get a result like the one presented in the photo attached to this post.

    My problems constraints are:
    1. A truck can deliver a max payload of 80 packages/run.
    2. A truck must leave and return from the warehouse.



    Please help.
    Thank you.
    Attached Images Attached Images
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. ~ Need Step-by-step Guide on How To Create A Chart ~
    By exceltoohard in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2013, 01:04 AM
  2. [SOLVED] im looking for a step by step guide to writing vba.. something simple
    By ttad6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2013, 02:46 PM
  3. Excel Userform - can't step into VBA code. Hitting "F8" just pops up the form
    By RAMguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2013, 10:51 AM
  4. [SOLVED] For step loop, need step size to change based on reference cell in row
    By Telperion in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 03:41 PM
  5. [SOLVED] shortcut key to see a macro running "step by step"
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-10-2005, 06:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1