Guest
Guest
Guests
Hi everybody.
Can anyone help me with a simple greedy/nearest neighbour heuristic in VBA?
I have a distance matrix of 36x36 where 1 is the "starting point". I need to go from index 1 to the nearest point (column) in the matrix. I need to update an array called used() to make sure that I don't revisit any indexes where I have already been.
Finally, I need to print the visiting sequence in a row.
I have been stuck with this for quite a while, and I figured that somebody in might be able for come up with some code for this quickly.
In advance, thank you so much!
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1942
SunnyKow: 1432
Anders Sehlstedt: 935
Purfleet: 415
Hans Hallebeek: 361
Frans Visser: 349
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Masha Sekerin
Fran Cammock
Reham Musaed
Johann Plattner
Rob R
Rick Peterson
Sean McPoland
Brian Sutera
Naveed Naveed
Gary Horswell
Forum Stats:
Groups: 3
Forums: 25
Topics: 7110
Posts: 31166
Member Stats:
Guest Posters: 50
Members: 34570
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —