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] 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.