+ Reply to Thread
Results 1 to 2 of 2

Excel Combination Solver for Determining Shortest Route

  1. #1
    Registered User
    Join Date
    09-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    6

    Excel Combination Solver for Determining Shortest Route

    Hello!

    I am trying to determine the shortest flow path for a list of routings, the flow has to go through all six each time. I am trying to determine a way to calculate/display all 6! (720 combinations) of the route. The different stages are 1-2-3-4-5-6. There are fixed distances between each step, (the space between first and second block is 100, second and third is 75, third and fourth is 75, fourth and fifth is 25, and fifth and sixth is 25.) I have different routes that have to run down the path and have to optimize the output.

    I need a way for excel to display all possible combinations (134562,154362,etc) and then run macros to determine if the new combination is smaller than the original.

    Is there a way to do this?

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Excel Combination Solver for Determining Shortest Route

    Duplicate post: https://www.excelforum.com/excel-gen...ml#post4743109

    Please don't do that.
    Entia non sunt multiplicanda sine necessitate

+ 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. Shortest path problem with excel solver
    By halatehini in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-11-2016, 12:51 PM
  2. Extreme Challenge : Solver to optimize a perfect combination/blend of supplier
    By chris1089 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2015, 03:23 PM
  3. Replies: 0
    Last Post: 02-20-2012, 07:11 PM
  4. What is the Shortest way to refer the filtered records in an excel table?
    By prabha_friend in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2011, 11:06 PM
  5. Replies: 1
    Last Post: 01-17-2010, 02:49 PM
  6. Replies: 7
    Last Post: 02-15-2009, 02:05 AM
  7. Determining if a Solution was Found Using VB & Solver
    By MArmstrong in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2005, 11:05 PM

Tags for this Thread

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