(Solved) – Creating a distance matrix (Floyd’s algorithms) with VBA in Excel

  • by

I’m new to programming.

I’m trying to create a distance matrix with given dataset before applying Floyd’s algorithms by VBA.

I have used loop and nested loop to[enter image description here][1] fill area above and below diagonal areas but did not work to me.

the dataset has 5 columns: Vertex (48 vertices), Origin, Destination, Distance, Time.

I want to create a matrix where corresponding distance values to origin and destination are.

Can anyone give me some advice how to approach this problem.

Leave a Reply

Your email address will not be published. Required fields are marked *