Three hub template
Sheet1
|
|
|
|
Distances from |
|
|
Assignment |
|
X |
Y |
hub 1 |
hub2 |
hub 3 |
hub1 |
Hub2 |
Hub3 |
total |
distnce |
| Panama |
1 |
14 |
3.2008176749 |
11.3539504922 |
18.3550915948 |
1 |
0 |
0 |
1 |
3.2008176749 |
| Tallahassee |
6.1 |
15 |
2.2545176519 |
7.0055864112 |
15.0836315098 |
1 |
0 |
0 |
1 |
2.2545176519 |
| Jacksonville |
13 |
15 |
9.1280979924 |
3.8810743906 |
11.5635550133 |
0 |
1 |
0 |
1 |
3.8810743906 |
| Ocala |
12 |
11 |
9.2330350402 |
0.2464790763 |
8.2982938333 |
0 |
1 |
0 |
1 |
0.2464790763 |
| Orlando |
13.5 |
9 |
11.5516398088 |
2.6926181936 |
5.8134476536 |
0 |
1 |
0 |
1 |
2.6926181936 |
| Tampa |
11 |
7.5 |
10.6315556114 |
3.881074159 |
6.4285379246 |
0 |
1 |
0 |
1 |
3.881074159 |
| FtPrc |
17 |
6 |
16.1369557854 |
7.236858795 |
2.1691323525 |
0 |
0 |
1 |
1 |
2.1691323525 |
| Ft Myer |
12.5 |
3.5 |
14.6902797336 |
7.7612043328 |
3.8712297393 |
0 |
0 |
1 |
1 |
3.8712297393 |
| West Palm |
17.5 |
4 |
17.7582024963 |
9.0879782678 |
1.1549245433 |
0 |
0 |
1 |
1 |
1.1549245433 |
| Miami |
17 |
1 |
19.4771298272 |
11.3944027217 |
3.0032818854 |
0 |
0 |
1 |
1 |
3.0032818854 |
|
|
|
|
|
|
2 |
4 |
4 |
|
26.3551496668 |
3.8810743906 |
|
Loc 1 |
Loc 2 |
Loc 3 |
|
|
|
|
|
|
Total |
maximum |
| X |
3.8804838321 |
12.0148914883 |
16.3471112302 |
| Y |
15.3957244287 |
11.2460288166 |
3.9314566921 |
