Organizing data to use Graphshortestpath function

I know the concept behind Graphshortestpath Function in Matlab however I have to re-code this portion to connect the path again.

W = [44.35 45.84 41.19 23.81 59.86 68.63 29.99 24.13 47.3 30.36 500];
DG = sparse([1 2 3 4 5 6 7 8 9 10 11],[2 3 4 5 6 7 8 9 10 11 1],W);
UG = tril(DG + DG');

Is there other way that I can make my life easier?? I have a huge data that require to input into the system and my data are in Excel format. I can't possibly re-code this every single time. Really appreciate your help! Thanks :)

Answer 1

[Walter Roberson]

Perhaps I am missing what you are asking?

DG = sparse(1:length(W), [2:length(W), 1], W);

[Kim]

Hey!! thanks it somehow works!! But I won't like it to have separate joining for certain points. How can I insert the data in??

[Walter Roberson]

N1 = 1 : length(W);

N2 = circshift(N1,[0 -1]);

Then store appropriate adjustments in N2, such as N2(93) = 17;

Afterwards,

DG = sparse(N1, N2, W);

[Kim]

Not really sure how to store N2.

But can I do some adjustment to the excel data itself only by arranging the way it should be connected and separate it by a empty row in between.

I not sure whether it is feasible??