+ Reply to Thread
Results 1 to 5 of 5

find all path between any two nodes in a loop graph

  1. #1
    Registered User
    Join Date
    12-14-2017
    Location
    INDIA
    MS-Off Ver
    2017
    Posts
    5

    find all path between any two nodes in a loop graph

    requesting for the vba program for finding all possible paths between any two nodes in a bi-directional route map. inpit is given in sheet 1 as a=from; B=to; C=distance, d= time; e= fare.
    output is given in sheet 2 as
    A1=from ....;
    B1= to ....;
    A2= possible path1; B2 = DISTANCE C2= TIME TAKEN D2 = TOTAL FARE
    A3 = possible path 2; B3 = DISTANCE C3= TIME TAKEN D3 = TOTAL FARE
    A4=possible path 3; B4 = DISTANCE C4= TIME TAKEN D4 = TOTAL FARE
    A5=possible path 4; B5 = DISTANCE C5= TIME TAKEN D5 = TOTAL FARE
    A6=possible path 5; B6 = DISTANCE C6= TIME TAKEN D6 = TOTAL FARE


    AS




    A B C
    D
    G E
    F


    IN PUT
    A-B = 200, 00:02:30, 10/-
    B-C = 195, 00:02:00, 10/-
    C-D = 210, 00:02:30, 12/-
    D-E = 180, 00:02:10, 10/-
    E-F = 210, 00:02:40, 14/-
    F-G = 230, 00:02:45, 15/-
    C-G = 200, 00:02:30, 10/-




    OUTPUT

    FROM B - TO F

    1 - B-C-D-E-F
    2 - B-C-G-F

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: find all path between any two nodes in a loop graph

    Cross-posted at:
    https://www.mrexcel.com/forum/excel-...route-map.html
    http://www.vbaexpress.com/forum/show...ighlight=nodes

    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    12-14-2017
    Location
    INDIA
    MS-Off Ver
    2017
    Posts
    5

    Re: find all path between any two nodes in a loop graph

    sorry for that, but on one reply on that so i posted the same

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

    Re: find all path between any two nodes in a loop graph

    This is similar to something else I did recently. I'll post something later this week.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    12-14-2017
    Location
    INDIA
    MS-Off Ver
    2017
    Posts
    5
    Quote Originally Posted by shg View Post
    This is similar to something else I did recently. I'll post something later this week.
    Is any update

+ 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. Finding Values in Nodes and Child Nodes in XML SOAP POST
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2018, 11:33 AM
  2. Capturing 3 inputs for a glide path, graph.
    By MattUK in forum Excel General
    Replies: 5
    Last Post: 11-08-2017, 07:56 PM
  3. VBA Loop through nodes
    By devatu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2015, 06:47 AM
  4. How to loop through multiple XML nodes in VBA?
    By mockions in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2015, 01:35 PM
  5. File path as hyperlink loop
    By Macro1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2010, 10:24 PM
  6. x-axis dates dont match up with the nodes on the line graph
    By changetires in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2006, 08:50 AM

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