Excel Forum

Greedy heuristic in VBA

Guest

Guests

June 13, 2022 - 8:59 pm

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!

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1807

Member Since:
November 8, 2013

Offline

June 16, 2022 - 12:55 am

Hi Endros,

Can you come with a more detailed description?
Hard to imagine what you're after without a sample and a proper description.

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Philip Treacy, Ngoc Tinh, Riny van Eekelen, Alexandra Radu, Monique Roussouw, michael serna

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

michael serna

mashal sana

Tiffany Kang

Leah Gillmore

Sopi Yuniarti

LAFONSO HERNANDEZ

Hayden Hao

Angela chen

Sean Moore

John Chisholm

Forum Stats:

Groups: 3

Forums: 24

Topics: 6215

Posts: 27248

Member Stats:

Guest Posters: 49

Members: 31897

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen