deusextra
08-02-2013, 03:31 AM
Hello forum,
I have the following problem:
I have a list of co-ordinates for the start and end point of various roads and what I need to know is which pairs of roads pass over the same co-ordinates at some point.
E.g.
Consider the following 4 road sections:
Road A: Start Point: 25000, End Point: 25200
Road B: Start Point: 25150, End Point: 25250
Road C: Start Point: 25140, End Point: 25340
Road D: Start Point: 25300, End Point: 25400
From these 4 given roads we can see that the following roads can be considered as pairs:
Road A & Road B
Road A & Road C
Road B & Road C
Road C & Road D
The problem is that I have thousands of road co-ordinates that I need to find the pairs for and manually this would take forever. I was hoping some VBA guru out there would be able to find an automated process for finding the pairs.
I have posted an excel sample file below that you can work off if you find this easier.
Any suggestions would be greatly appreciated!
10357
I have the following problem:
I have a list of co-ordinates for the start and end point of various roads and what I need to know is which pairs of roads pass over the same co-ordinates at some point.
E.g.
Consider the following 4 road sections:
Road A: Start Point: 25000, End Point: 25200
Road B: Start Point: 25150, End Point: 25250
Road C: Start Point: 25140, End Point: 25340
Road D: Start Point: 25300, End Point: 25400
From these 4 given roads we can see that the following roads can be considered as pairs:
Road A & Road B
Road A & Road C
Road B & Road C
Road C & Road D
The problem is that I have thousands of road co-ordinates that I need to find the pairs for and manually this would take forever. I was hoping some VBA guru out there would be able to find an automated process for finding the pairs.
I have posted an excel sample file below that you can work off if you find this easier.
Any suggestions would be greatly appreciated!
10357