Spreadsheet: 165372d1341206520-frequency-table-example-demand-1
Sheet: Sheet1

 | Stop to stop [NAME] 1:
 | TO STOP
FROM STOP | 1 | 2 | 3 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
1 |  |  | 23 |  | 11 |  | 4 | 6 |  |  | 7 |  | 9 |  |  |  | 0 |  |  | 98.70786885245901 | 0 | 0 | 0 | 0 |  |  | 0 | 14.95573770491803
2 |  |  |  | 18 |  | 4 |  | 12 |  | 5 |  |  |  |  |  |  | 12.80064587973274 |  |  | 45.71659242761692 | 4.876436525612472 | 0 | 1.828663697104677 | 26.82040089086859 |  |  | 1.219109131403118 | 10.97198218262806
3 |  |  |  |  |  | 5 | 10 | 6 | 11 |  |  | 20 |  |  |  |  | 20 |  | 30 | 0 | 50 | 30 | 60 | 50 | 50 | 50 | 30 | 0
6 |  |  |  | 0 |  |  |  | 20 |  |  |  | 17 |  | 9 |  |  | 12.22222222222222 |  | 18.33333333333333 | 0 | 30.55555555555556 | 18.33333333333333 | 36.66666666666666 | 30.55555555555556 | 30.55555555555556 | 30.55555555555556 | 18.33333333333333 | 0
7 |  |  |  | 0 | 0 |  |  |  |  | 6 |  |  | 9 |  |  |  | 0 |  | 0 | 0 | 6.866774193548388 | 0 | 145.5756129032258 | 38.45393548387097 | 0 | 0 | 0 | 12.3601935483871
8 |  |  |  | 0 | 0 |  |  |  |  |  | 7 |  |  |  | 9 |  | 7.111111111111111 |  | 10.66666666666667 | 0 | 17.77777777777778 | 10.66666666666667 | 21.33333333333333 | 17.77777777777778 | 17.77777777777778 | 17.77777777777778 | 10.66666666666667 | 0
9 |  |  |  | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  | 39.09857142857143 |  | 0 | 26.06571428571429 | 0 | 0 | 21.72142857142857 | 17.37714285714286 | 0 | 0 | 0 | 4.344285714285714
10 |  |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  | 45.2613953488372 |  | 0 | 71.66387596899224 | 9.429457364341083 | 0 | 77.32155038759689 | 177.2737984496124 | 0 | 0 | 1.885891472868217 | 30.17426356589147
11 |  |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  |  | 86.88571428571427 |  | 0 | 122.4298701298701 | 23.6961038961039 | 0 | 296.2012987012987 | 185.6194805194805 | 80 | 0 | 0 | 19.74675324675324
12 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 12.84929577464789 |  | 0 | 0 | 0 | 0 | 295.5338028169014 | 218.4380281690141 | 0 | 0 | 0 | 38.54788732394366
13 |  |  |  | 0 |  |  | 0 | 0 |  | 0 |  |  |  |  |  |  | 12.92792270531401 |  | 0 | 3.525797101449275 | 2.938164251207729 | 0 | 94.02125603864734 | 2.938164251207729 | 0 | 0 | 0 | 4.701062801932367
14 |  |  |  | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  |  |  |  | 63.96614312516751 |  | 0 | 64.84641114982578 | 2.836419190565532 | 0 | 67.58502278209595 | 75.80085767890645 | 0 | 0 | 0.8802680246582685 | 28.55980702224604
15 |  |  |  | 20 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 95.7915 |  | 0 | 82.107 | 40 | 0 | 54.738 | 70 | 35 | 0 | 0 | 0
16 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 7.546030261348006 |  | 0 | 65.17026134800551 | 2.744011004126548 | 0 | 246.2749876203577 | 87.80835213204952 | 0 | 0 | 2.744011004126548 | 43.21817331499312
17 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1.932519944979368 |  | 0 | 16.68994497936727 | 0.7027345254470426 | 0 | 63.07042365887208 | 22.48750481430536 | 0 | 0 | 0.7027345254470426 | 11.06806877579092
18
19 |  |  |  | 0 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0
20
21
22 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 7 | 23 |  |  | 4 | 3
23 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 2 |  |  | 1 | 7
24 |  |  | 5 | 0 | 0 |  | 0 | 2.678761869978086 | 1.589398709520331 | 2.678761869978086 | 1.25008887265644 | 15.52702702702703 | 0.8929206233260288 | 1.607257121986852 | 1.035787923058193 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 11
25 |  |  | 10 | 0 | 0 |  | 0 | 0.8929206233260286 | 0.5297995698401103 | 0.8929206233260286 | 0.4166962908854801 | 5.175675675675675 | 0.2976402077753429 | 0.5357523739956173 | 0.3452626410193978 |  | 0 |  |  | 8 | 0 | 0 | 0 | 0 |  |  | 24 | 67
26 |  |  |  | 0 | 0 |  | 0 | 1.547729080431783 | 0.9183192543895246 | 1.547729080431783 | 0.7222735708681656 | 8.971171171171171 | 0.5159096934772611 | 0.9286374482590698 | 0.5984552444336229 |  | 1 |  |  | 0 | 0 | 2 | 0 | 0 |  |  | 0 | 4
27 |  |  |  | 0 | 0 |  | 0 | 0.2976402077753428 | 0.1765998566133701 | 0.2976402077753428 | 0.1388987636284933 | 1.725225225225225 | 0.09921340259178096 | 0.1785841246652057 | 0.1150875470064659 |  | 0 |  |  | 1 | 0 | 0 | 0 | 0 |  |  | 2 | 9
28 |  |  |  | 0 | 0 |  | 0 | 0.1785841246652057 | 0.1059599139680221 | 0.1785841246652057 | 0.08333925817709602 | 1.035135135135135 | 0.05952804155506859 | 0.1071504747991234 | 0.06905252820387955 |  | 0 |  |  | 0 | 0 | 6 | 0 | 0 |  |  | 0 | 10
29 |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 16
30 |  |  |  | 0 | 0 |  | 0 | 2.381121662202743 | 1.412798852906961 | 2.381121662202743 | 1.111190109027947 | 13.8018018018018 | 0.7937072207342477 | 1.428672997321646 | 0.9207003760517274 |  | 0 |  |  | 0 | 0 | 11 | 0 | 0 |  |  | 2 | 0
31
 | Distances between stops
 | TO STOP
FROM STOP | 1 | 2 | 3 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
1 | 0 | 1.065 | 1.845 | 2.755 | 3.485 | 4.585 | 5.295 | 6.005 | 6.725 | 7.675 | 8.075 | 8.535 | 8.835 | 10.315 | 10.955 | 11.555 | 12.545 | 13.765 | 14.875 | 15.825 | 16.805 | 18.265 | 18.905 | 19.245 | 19.945 | 20.365 | 21.385 | 22.155
2 | 1.065 | 0 | 0.78 | 1.69 | 2.42 | 3.52 | 4.23 | 4.94 | 5.66 | 6.61 | 7.010000000000001 | 7.470000000000001 | 7.77 | 9.25 | 9.89 | 10.49 | 11.48 | 12.7 | 13.81 | 14.76 | 15.74 | 17.2 | 17.84 | 18.18 | 18.88 | 19.3 | 20.32 | 21.09
3 | 1.845 | 0.78 | 0 | 0.91 | 1.64 | 2.74 | 3.45 | 4.16 | 4.88 | 5.83 | 6.23 | 6.69 | 6.99 | 8.47 | 9.110000000000001 | 9.71 | 10.7 | 11.92 | 13.03 | 13.98 | 14.96 | 16.42 | 17.06 | 17.4 | 18.1 | 18.52 | 19.54 | 20.31
6 | 2.755 | 1.69 | 0.9099999999999999 | 0 | 0.73 | 1.83 | 2.54 | 3.25 | 3.97 | 4.92 | 5.32 | 5.78 | 6.08 | 7.56 | 8.200000000000001 | 8.8 | 9.790000000000001 | 11.01 | 12.12 | 13.07 | 14.05 | 15.51 | 16.15 | 16.49 | 17.19 | 17.61 | 18.63 | 19.4
7 | 3.485 | 2.42 | 1.64 | 0.7299999999999999 | 0 | 1.1 | 1.81 | 2.52 | 3.24 | 4.19 | 4.590000000000001 | 5.050000000000001 | 5.350000000000001 | 6.83 | 7.47 | 8.07 | 9.06 | 10.28 | 11.39 | 12.34 | 13.32 | 14.78 | 15.42 | 15.76 | 16.46 | 16.88 | 17.9 | 18.67
8 | 4.585 | 3.52 | 2.74 | 1.83 | 1.1 | 0 | 0.71 | 1.42 | 2.14 | 3.09 | 3.49 | 3.95 | 4.25 | 5.73 | 6.37 | 6.97 | 7.96 | 9.18 | 10.29 | 11.24 | 12.22 | 13.68 | 14.32 | 14.66 | 15.36 | 15.78 | 16.8 | 17.57
9 | 5.295 | 4.23 | 3.45 | 2.54 | 1.81 | 0.71 | 0 | 0.71 | 1.43 | 2.38 | 2.78 | 3.24 | 3.54 | 5.02 | 5.659999999999999 | 6.259999999999999 | 7.249999999999999 | 8.469999999999999 | 9.579999999999998 | 10.53 | 11.51 | 12.97 | 13.61 | 13.95 | 14.65 | 15.07 | 16.09 | 16.86
10 | 6.005 | 4.94 | 4.159999999999999 | 3.249999999999999 | 2.519999999999999 | 1.419999999999999 | 0.7099999999999991 | 0 | 0.72 | 1.67 | 2.07 | 2.53 | 2.83 | 4.31 | 4.949999999999999 | 5.549999999999999 | 6.539999999999999 | 7.759999999999999 | 8.87 | 9.819999999999999 | 10.8 | 12.26 | 12.9 | 13.24 | 13.94 | 14.36 | 15.38 | 16.15
11 | 6.725 | 5.66 | 4.88 | 3.97 | 3.24 | 2.14 | 1.43 | 0.7199999999999998 | 0 | 0.95 | 1.35 | 1.81 | 2.11 | 3.59 | 4.23 | 4.829999999999999 | 5.819999999999999 | 7.039999999999999 | 8.149999999999999 | 9.099999999999998 | 10.08 | 11.54 | 12.18 | 12.52 | 13.22 | 13.64 | 14.66 | 15.43
12 | 7.675 | 6.609999999999999 | 5.829999999999999 | 4.919999999999999 | 4.19 | 3.089999999999999 | 2.379999999999999 | 1.669999999999999 | 0.9499999999999995 | 0 | 0.4 | 0.8600000000000001 | 1.16 | 2.64 | 3.28 | 3.88 | 4.87 | 6.09 | 7.2 | 8.15 | 9.13 | 10.59 | 11.23 | 11.57 | 12.27 | 12.69 | 13.71 | 14.48
13 | 8.075 | 7.01 | 6.23 | 5.319999999999999 | 4.59 | 3.49 | 2.78 | 2.07 | 1.35 | 0.3999999999999999 | 0 | 0.46 | 0.76 | 2.24 | 2.88 | 3.48 | 4.470000000000001 | 5.69 | 6.800000000000001 | 7.750000000000001 | 8.73 | 10.19 | 10.83 | 11.17 | 11.87 | 12.29 | 13.31 | 14.08
14 | 8.535 | 7.470000000000001 | 6.69 | 5.78 | 5.050000000000001 | 3.950000000000001 | 3.240000000000001 | 2.530000000000001 | 1.810000000000001 | 0.8600000000000008 | 0.4600000000000007 | 0 | 0.3 | 1.78 | 2.42 | 3.02 | 4.01 | 5.23 | 6.34 | 7.29 | 8.27 | 9.73 | 10.37 | 10.71 | 11.41 | 11.83 | 12.85 | 13.62
15 | 8.835 | 7.770000000000001 | 6.990000000000001 | 6.080000000000001 | 5.350000000000001 | 4.250000000000002 | 3.540000000000002 | 2.830000000000002 | 2.110000000000002 | 1.160000000000002 | 0.7600000000000021 | 0.3000000000000021 | 0 | 1.48 | 2.12 | 2.72 | 3.71 | 4.93 | 6.04 | 6.99 | 7.970000000000001 | 9.43 | 10.07 | 10.41 | 11.11 | 11.53 | 12.55 | 13.32
16 | 10.315 | 9.250000000000002 | 8.470000000000002 | 7.560000000000002 | 6.830000000000002 | 5.730000000000002 | 5.020000000000002 | 4.310000000000002 | 3.590000000000003 | 2.640000000000002 | 2.240000000000002 | 1.780000000000002 | 1.480000000000002 | 0 | 0.64 | 1.24 | 2.23 | 3.45 | 4.56 | 5.510000000000001 | 6.49 | 7.95 | 8.59 | 8.93 | 9.629999999999999 | 10.05 | 11.07 | 11.84
17 | 10.955 | 9.890000000000002 | 9.110000000000003 | 8.200000000000003 | 7.470000000000002 | 6.370000000000003 | 5.660000000000003 | 4.950000000000003 | 4.230000000000003 | 3.280000000000003 | 2.880000000000003 | 2.420000000000003 | 2.120000000000003 | 0.6400000000000032 | 0 | 0.6 | 1.59 | 2.81 | 3.92 | 4.87 | 5.85 | 7.31 | 7.949999999999999 | 8.29 | 8.989999999999998 | 9.409999999999998 | 10.43 | 11.2
18 | 11.555 | 10.49 | 9.710000000000003 | 8.800000000000002 | 8.070000000000002 | 6.970000000000002 | 6.260000000000002 | 5.550000000000002 | 4.830000000000003 | 3.880000000000003 | 3.480000000000003 | 3.020000000000003 | 2.720000000000003 | 1.240000000000003 | 0.6000000000000029 | 0 | 0.99 | 2.21 | 3.32 | 4.27 | 5.25 | 6.71 | 7.35 | 7.69 | 8.389999999999999 | 8.809999999999999 | 9.829999999999998 | 10.6
19 | 12.545 | 11.48 | 10.7 | 9.790000000000003 | 9.060000000000002 | 7.960000000000003 | 7.250000000000003 | 6.540000000000003 | 5.820000000000003 | 4.870000000000003 | 4.470000000000002 | 4.010000000000002 | 3.710000000000003 | 2.230000000000003 | 1.590000000000003 | 0.9900000000000025 | 0 | 1.22 | 2.33 | 3.28 | 4.26 | 5.72 | 6.359999999999999 | 6.699999999999999 | 7.399999999999999 | 7.819999999999999 | 8.84 | 9.61
20 | 13.765 | 12.7 | 11.92 | 11.01 | 10.28 | 9.180000000000003 | 8.470000000000002 | 7.760000000000002 | 7.040000000000003 | 6.090000000000003 | 5.690000000000002 | 5.230000000000002 | 4.930000000000002 | 3.450000000000002 | 2.810000000000002 | 2.210000000000002 | 1.220000000000002 | 0 | 1.11 | 2.06 | 3.04 | 4.5 | 5.14 | 5.48 | 6.18 | 6.6 | 7.619999999999999 | 8.389999999999999
21 | 14.875 | 13.81 | 13.03 | 12.12 | 11.39 | 10.29 | 9.580000000000002 | 8.870000000000001 | 8.15 | 7.2 | 6.8 | 6.34 | 6.04 | 4.56 | 3.92 | 3.32 | 2.33 | 1.11 | 0 | 0.95 | 1.93 | 3.39 | 4.029999999999999 | 4.369999999999999 | 5.069999999999999 | 5.489999999999999 | 6.51 | 7.279999999999999
22 | 15.825 | 14.76 | 13.98 | 13.07 | 12.34 | 11.24 | 10.53 | 9.82 | 9.1 | 8.15 | 7.75 | 7.29 | 6.99 | 5.51 | 4.87 | 4.27 | 3.28 | 2.06 | 0.9500000000000004 | 0 | 0.98 | 2.44 | 3.08 | 3.42 | 4.12 | 4.54 | 5.56 | 6.33
23 | 16.805 | 15.74 | 14.96 | 14.05 | 13.32 | 12.22 | 11.51 | 10.8 | 10.08 | 9.13 | 8.73 | 8.27 | 7.97 | 6.49 | 5.850000000000001 | 5.250000000000001 | 4.260000000000001 | 3.040000000000001 | 1.930000000000001 | 0.9800000000000009 | 0 | 1.46 | 2.1 | 2.44 | 3.14 | 3.56 | 4.58 | 5.35
24 | 18.265 | 17.2 | 16.42 | 15.51 | 14.78 | 13.68 | 12.97 | 12.26 | 11.54 | 10.59 | 10.19 | 9.729999999999997 | 9.429999999999996 | 7.949999999999996 | 7.309999999999996 | 6.709999999999996 | 5.719999999999996 | 4.499999999999996 | 3.389999999999996 | 2.439999999999996 | 1.459999999999996 | 0 | 0.64 | 0.98 | 1.68 | 2.1 | 3.12 | 3.89
25 | 18.905 | 17.84 | 17.06 | 16.15 | 15.42 | 14.32 | 13.61 | 12.9 | 12.18 | 11.23 | 10.83 | 10.37 | 10.07 | 8.589999999999996 | 7.949999999999997 | 7.349999999999997 | 6.359999999999997 | 5.139999999999997 | 4.029999999999997 | 3.079999999999997 | 2.099999999999997 | 0.6399999999999966 | 0 | 0.34 | 1.04 | 1.46 | 2.48 | 3.25
26 | 19.245 | 18.18 | 17.4 | 16.49 | 15.76 | 14.66 | 13.95 | 13.24 | 12.52 | 11.57 | 11.17 | 10.71 | 10.41 | 8.929999999999996 | 8.289999999999996 | 7.689999999999996 | 6.699999999999996 | 5.479999999999996 | 4.369999999999996 | 3.419999999999995 | 2.439999999999996 | 0.9799999999999955 | 0.3399999999999955 | 0 | 0.7 | 1.12 | 2.14 | 2.91
27 | 19.945 | 18.88 | 18.1 | 17.19 | 16.46 | 15.36 | 14.65 | 13.94 | 13.22 | 12.27 | 11.87 | 11.41 | 11.11 | 9.629999999999995 | 8.989999999999995 | 8.389999999999995 | 7.399999999999995 | 6.179999999999995 | 5.069999999999995 | 4.119999999999995 | 3.139999999999995 | 1.679999999999995 | 1.039999999999995 | 0.6999999999999946 | 0 | 0.42 | 1.44 | 2.21
28 | 20.365 | 19.3 | 18.52 | 17.61 | 16.88 | 15.78 | 15.07 | 14.36 | 13.64 | 12.69 | 12.29 | 11.83 | 11.53 | 10.05 | 9.409999999999997 | 8.809999999999997 | 7.819999999999997 | 6.599999999999997 | 5.489999999999997 | 4.539999999999996 | 3.559999999999997 | 2.099999999999997 | 1.459999999999996 | 1.119999999999996 | 0.4199999999999964 | 0 | 1.02 | 1.79
29 | 21.385 | 20.32 | 19.54 | 18.63 | 17.9 | 16.8 | 16.09 | 15.38 | 14.65999999999999 | 13.71 | 13.31 | 12.84999999999999 | 12.54999999999999 | 11.06999999999999 | 10.42999999999999 | 9.829999999999993 | 8.839999999999993 | 7.619999999999993 | 6.509999999999993 | 5.559999999999993 | 4.579999999999993 | 3.119999999999993 | 2.479999999999993 | 2.139999999999993 | 1.439999999999993 | 1.019999999999993 | 0 | 0.77
30 | 22.155 | 21.09 | 20.31 | 19.4 | 18.67 | 17.57 | 16.86 | 16.15 | 15.42999999999999 | 14.48 | 14.07999999999999 | 13.61999999999999 | 13.31999999999999 | 11.83999999999999 | 11.19999999999999 | 10.59999999999999 | 9.609999999999992 | 8.389999999999992 | 7.279999999999991 | 6.329999999999991 | 5.349999999999991 | 3.889999999999991 | 3.249999999999991 | 2.909999999999991 | 2.209999999999991 | 1.789999999999991 | 0.7699999999999911 | 0
 |  |  | RESULT TABLE
 |  |  | DISTANCE |  |  |  | PASSENGERS
 |  |  | 0.34 |  |  |  | 0
 |  |  | X |  |  |  | Y
 |  |  | X |  |  |  | Y
 |  |  | X |  |  |  | Y
 |  |  | X |  |  |  | Y
 |  |  | 1.69 |  |  |  | 18
 |  |  | 1.85 |  |  |  | 23
 |  |  | Distance is a summary of all the distances between stops in table 2
 |  |  | Passengers are the passengers in table 1 traveling the distance in table 2