Random probability generation

[sach_83]

Hi All,

I want to generate a random probability distribution for 100 items using VBA and also i need to simulate this process 30 times..
Please suggest how to proceed..

[watersev]

this code will produce numbers from 0 to 1 randomly:

Please Login or Register  to view this content.

[sach_83]

Hi All,

I want to calculate distance between two cities in a locality. I have the initial road distance matrix generated by Map point in an excel sheet

As per my understanding, if i want to calculate the distance between city 1 and city 4 then i should look at row 4 and column 1 or Column 4 and row 1. But in my case, these values are slightly different from each other. Please suggest how should i tackle this problem.

Thanks in advance

[watersev]

it would be helpful to see the file with data table