soconfused365
New Member
- Joined
- May 16, 2022
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I have a matrix of distance from all UK postcodes to all other UK postcodes which gives me the distance between them. (All postcodes in column A in a list and then all postcodes in row 1 with the cell populated with the distance between the 2 eg D7 reads 8.6 as that is the distance between the postcodes in D1 and A7)
What I am therefore theorising is that somehow I can use this matrix to create a way to route postcodes into the shortest distance order. If I put in the start location and then 30 random postcodes it will calculate the closest postcode to the start postcode and then the next closest until they are all in order and give a total mileage readout?
I am thinking it would need to look up the distances between every postcode and every other postcode to work out which is the closest and then rank all the options removing the previous postcode from the options as it continues until none are left. Even better if I could somehow set a distance limit eg 150 miles and then it would start a new route with the remaining available postcodes.
Is this even possible before I start trying to work out how to even start creating it? Or is there already an add on somewhere out there that would do this for me?
What I am therefore theorising is that somehow I can use this matrix to create a way to route postcodes into the shortest distance order. If I put in the start location and then 30 random postcodes it will calculate the closest postcode to the start postcode and then the next closest until they are all in order and give a total mileage readout?
I am thinking it would need to look up the distances between every postcode and every other postcode to work out which is the closest and then rank all the options removing the previous postcode from the options as it continues until none are left. Even better if I could somehow set a distance limit eg 150 miles and then it would start a new route with the remaining available postcodes.
Is this even possible before I start trying to work out how to even start creating it? Or is there already an add on somewhere out there that would do this for me?
