I have a several rows of addresses in one column followed by lat/long in the next columns.
a 416 Snider Avenue SE, Olympa, WA 47.0354605 -122.9030842
b 1315 10th Street, Sacramento, CA 38.576927 -121.4949038
c 900 Court Street Northeast, Salem, Oregon 44.9390127 -123.0300577
d 700 W Jefferson St, Boise, Idaho 43.617729 -116.199671
e 500 E Capitol Ave., Pierre, SD 44.3670868 -100.3463526
I can to find the distance between each address.
a b 588.743116389392
a c 144.978695243899
a d 402.00802354729
a e 1099.99623703835
b c 446.617373142927
b d 444.000790201019
b e 1161.62065386293
c d 349.877894143379
c e 1111.99612338077
d e 788.49920907168
I want to then sort the results so that I find the shortest routes between each address, first and then route a tour of all addresses. "a" would be the starting point.
drivingrouteplanner.com sorts it this way
a 416 Snider Avenue SE, Olympa, WA
c 900 Court Street Northeast, Salem, Oregon
b 1315 10th Street Sacramento, CA
d 700 W Jefferson St, Boise, Idaho
e 500 E Capitol Ave., Pierre, SD
and drivingrouteplanner.com also says this route is shortest
a 416 Snider Avenue SE, Olympa, WA
e 500 E Capitol Ave., Pierre, SD
d 700 W Jefferson St, Boise, Idaho
b 1315 10th Street Sacramento, CA
c 900 Court Street Northeast, Salem, Oregon
What loop do you think would sort logically, finding the shortest route?
a 416 Snider Avenue SE, Olympa, WA 47.0354605 -122.9030842
b 1315 10th Street, Sacramento, CA 38.576927 -121.4949038
c 900 Court Street Northeast, Salem, Oregon 44.9390127 -123.0300577
d 700 W Jefferson St, Boise, Idaho 43.617729 -116.199671
e 500 E Capitol Ave., Pierre, SD 44.3670868 -100.3463526
I can to find the distance between each address.
a b 588.743116389392
a c 144.978695243899
a d 402.00802354729
a e 1099.99623703835
b c 446.617373142927
b d 444.000790201019
b e 1161.62065386293
c d 349.877894143379
c e 1111.99612338077
d e 788.49920907168
I want to then sort the results so that I find the shortest routes between each address, first and then route a tour of all addresses. "a" would be the starting point.
drivingrouteplanner.com sorts it this way
a 416 Snider Avenue SE, Olympa, WA
c 900 Court Street Northeast, Salem, Oregon
b 1315 10th Street Sacramento, CA
d 700 W Jefferson St, Boise, Idaho
e 500 E Capitol Ave., Pierre, SD
and drivingrouteplanner.com also says this route is shortest
a 416 Snider Avenue SE, Olympa, WA
e 500 E Capitol Ave., Pierre, SD
d 700 W Jefferson St, Boise, Idaho
b 1315 10th Street Sacramento, CA
c 900 Court Street Northeast, Salem, Oregon
What loop do you think would sort logically, finding the shortest route?