Spreadsheet: 54010d1253969760-define-districts-to-calculate-busfares-701031_rpadc
Sheet: Blad1

Distance in Miles
Busline X | To: | Station A | Station B | Station C | Station D | Station E | Station F | Station G | Station H | Station I | Station J | Station K | Station L | Station M | Station N | Station O | Station P | Station Q | Station R | Station S | Station T
From: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Station | District | Rate |  | District | Rate
Station A |  |  | 3000 | 3200 | 5600 | 5900 | 9000 | 10000 | 10600 | 11800 | 12300 | 13900 | 16300 | 18400 | 19700 | 19900 | 20400 | 21300 | 23100 | 26300 | 26700 |  | Station A | 1 | 0.1 |  | 1 | 0.1
Station B |  | 3000 |  | 200 | 2600 | 2900 | 6000 | 7000 | 7600 | 8800 | 9300 | 10900 | 13300 | 15400 | 16700 | 16900 | 17400 | 18300 | 20100 | 23300 | 23700 |  | Station B | 1 | 0.1 |  | 2 | 0.2
Station C |  | 3200 | 200 |  | 2400 | 2700 | 5800 | 6800 | 7400 | 8600 | 9100 | 10700 | 13100 | 15200 | 16500 | 16700 | 17200 | 18100 | 19900 | 23100 | 23500 |  | Station C | 1 | 0.1
Station D |  | 5600 | 2600 | 2400 |  | 300 | 3400 | 4400 | 5000 | 6200 | 6700 | 8300 | 10700 | 12800 | 14100 | 14300 | 14800 | 15700 | 17500 | 20700 | 21100 |  | Station D | 1 | 0.1
Station E |  | 5900 | 2900 | 2700 | 300 |  | 3100 | 4100 | 4700 | 5900 | 6400 | 8000 | 10400 | 12500 | 13800 | 14000 | 14500 | 15400 | 17200 | 20400 | 20800 |  | Station E | 1 | 0.1
Station F |  | 9000 | 6000 | 5800 | 3400 | 3100 |  | 1000 | 1600 | 2800 | 3300 | 4900 | 7300 | 9400 | 10700 | 10900 | 11400 | 12300 | 14100 | 17300 | 17700 |  | Station F | 1 | 0.1
Station G |  | 10000 | 7000 | 6800 | 4400 | 4100 | 1000 |  | 600 | 1800 | 2300 | 3900 | 6300 | 8400 | 9700 | 9900 | 10400 | 11300 | 13100 | 16300 | 16700 |  | Station G | 1 | 0.1
Station H |  | 10600 | 7600 | 7400 | 5000 | 4700 | 1600 | 600 |  | 1200 | 1700 | 3300 | 5700 | 7800 | 9100 | 9300 | 9800 | 10700 | 12500 | 15700 | 16100 |  | Station H | 1 | 0.1
Station I |  | 11800 | 8800 | 8600 | 6200 | 5900 | 2800 | 1800 | 1200 |  | 500 | 2100 | 4500 | 6600 | 7900 | 8100 | 8600 | 9500 | 11300 | 14500 | 14900 |  | Station I | 1 | 0.1
Station J |  | 12300 | 9300 | 9100 | 6700 | 6400 | 3300 | 2300 | 1700 | 500 |  | 1600 | 4000 | 6100 | 7400 | 7600 | 8100 | 9000 | 10800 | 14000 | 14400 |  | Station J | 1 | 0.1
Station K |  | 13900 | 10900 | 10700 | 8300 | 8000 | 4900 | 3900 | 3300 | 2100 | 1600 |  | 2400 | 4500 | 5800 | 6000 | 6500 | 7400 | 9200 | 12400 | 12800 |  | Station K | 2 | 0.2
Station L |  | 16300 | 13300 | 13100 | 10700 | 10400 | 7300 | 6300 | 5700 | 4500 | 4000 | 2400 |  | 2100 | 3400 | 3600 | 4100 | 5000 | 6800 | 10000 | 10400 |  | Station L | 2 | 0.2
Station M |  | 18400 | 15400 | 15200 | 12800 | 12500 | 9400 | 8400 | 7800 | 6600 | 6100 | 4500 | 2100 |  | 1300 | 1500 | 2000 | 2900 | 4700 | 7900 | 8300 |  | Station M | 2 | 0.2
Station N |  | 19700 | 16700 | 16500 | 14100 | 13800 | 10700 | 9700 | 9100 | 7900 | 7400 | 5800 | 3400 | 1300 |  | 200 | 700 | 1600 | 3400 | 6600 | 7000 |  | Station N | 2 | 0.2
Station O |  | 19900 | 16900 | 16700 | 14300 | 14000 | 10900 | 9900 | 9300 | 8100 | 7600 | 6000 | 3600 | 1500 | 200 |  | 500 | 1400 | 3200 | 6400 | 6800 |  | Station O | 2 | 0.2
Station P |  | 20400 | 17400 | 17200 | 14800 | 14500 | 11400 | 10400 | 9800 | 8600 | 8100 | 6500 | 4100 | 2000 | 700 | 500 |  | 900 | 2700 | 5900 | 6300 |  | Station P | 2 | 0.2
Station Q |  | 21300 | 18300 | 18100 | 15700 | 15400 | 12300 | 11300 | 10700 | 9500 | 9000 | 7400 | 5000 | 2900 | 1600 | 1400 | 900 |  | 1800 | 5000 | 5400 |  | Station Q | 2 | 0.2
Station R |  | 23100 | 20100 | 19900 | 17500 | 17200 | 14100 | 13100 | 12500 | 11300 | 10800 | 9200 | 6800 | 4700 | 3400 | 3200 | 2700 | 1800 |  | 3200 | 3600 |  | Station R | 2 | 0.2
Station S |  | 26300 | 23300 | 23100 | 20700 | 20400 | 17300 | 16300 | 15700 | 14500 | 14000 | 12400 | 10000 | 7900 | 6600 | 6400 | 5900 | 5000 | 3200 |  | 400 |  | Station S | 2 | 0.2
Station T |  | 26700 | 23700 | 23500 | 21100 | 20800 | 17700 | 16700 | 16100 | 14900 | 14400 | 12800 | 10400 | 8300 | 7000 | 6800 | 6300 | 5400 | 3600 | 400 |  |  | Station T | 2 | 0.2
District 1 | Fare is 10 cents per mile
District 2 | Fare is 20 cents per mile
Fares in Euro's
Busline X | To: | Station A | Station B | Station C | Station D | Station E | Station F | Station G | Station H | Station I | Station J | Station K | Station L | Station M | Station N | Station O | Station P | Station Q | Station R | Station S | Station T
From:
Station A |  |  | 300 | 320 | 560 | 590 | 900 | 1000 | 1060 | 1180 | 1230 | 1550 | 2030 | 2450 | 2710 | 2750 | 2850 | 3030 | 3390 | 4030 | 4110
Station B |  | 300 |  | 20 | 260 | 290 | 600 | 700 | 760 | 880 | 930 | 1250 | 1730 | 2150 | 2410 | 2450 | 2550 | 2730 | 3090 | 3730 | 3810
Station C |  | 320 | 20 |  | 240 | 270 | 580 | 680 | 740 | 860 | 910 | 1230 | 1710 | 2130 | 2390 | 2430 | 2530 | 2710 | 3070 | 3710 | 3790
Station D |  | 560 | 260 | 240 |  | 30 | 340 | 440 | 500 | 620 | 670 | 990 | 1470 | 1890 | 2150 | 2190 | 2290 | 2470 | 2830 | 3470 | 3550
Station E |  | 590 | 290 | 270 | 30 |  | 310 | 410 | 470 | 590 | 640 | 960 | 1440 | 1860 | 2120 | 2160 | 2260 | 2440 | 2800 | 3440 | 3520
Station F |  | 900 | 600 | 580 | 340 | 310 |  | 100 | 160 | 280 | 330 | 650 | 1130 | 1550 | 1810 | 1850 | 1950 | 2130 | 2490 | 3130 | 3210
Station G |  | 1000 | 700 | 680 | 440 | 410 | 100 |  | 60 | 180 | 230 | 550 | 1030 | 1450 | 1710 | 1750 | 1850 | 2030 | 2390 | 3030 | 3110
Station H |  | 1060 | 760 | 740 | 500 | 470 | 160 | 60 |  | 120 | 170 | 490 | 970 | 1390 | 1650 | 1690 | 1790 | 1970 | 2330 | 2970 | 3050
Station I |  | 1180 | 880 | 860 | 620 | 590 | 280 | 180 | 120 |  | 50 | 370 | 850 | 1270 | 1530 | 1570 | 1670 | 1850 | 2210 | 2850 | 2930
Station J |  | 1230 | 930 | 910 | 670 | 640 | 330 | 230 | 170 | 50 |  | 320 | 800 | 1220 | 1480 | 1520 | 1620 | 1800 | 2160 | 2800 | 2880
Station K |  | 1550 | 1250 | 1230 | 990 | 960 | 650 | 550 | 490 | 370 | 320 |  | 480 | 900 | 1160 | 1200 | 1300 | 1480 | 1840 | 2480 | 2560
Station L |  | 2030 | 1730 | 1710 | 1470 | 1440 | 1130 | 1030 | 970 | 850 | 800 | 480 |  | 420 | 680 | 720 | 820 | 1000 | 1360 | 2000 | 2080
Station M |  | 2450 | 2150 | 2130 | 1890 | 1860 | 1550 | 1450 | 1390 | 1270 | 1220 | 900 | 420 |  | 260 | 300 | 400 | 580 | 940 | 1580 | 1660
Station N |  | 2710 | 2410 | 2390 | 2150 | 2120 | 1810 | 1710 | 1650 | 1530 | 1480 | 1160 | 680 | 260 |  | 40 | 140 | 320 | 680 | 1320 | 1400
Station O |  | 2750 | 2450 | 2430 | 2190 | 2160 | 1850 | 1750 | 1690 | 1570 | 1520 | 1200 | 720 | 300 | 40 |  | 100 | 280 | 640 | 1280 | 1360
Station P |  | 2850 | 2550 | 2530 | 2290 | 2260 | 1950 | 1850 | 1790 | 1670 | 1620 | 1300 | 820 | 400 | 140 | 100 |  | 180 | 540 | 1180 | 1260
Station Q |  | 3030 | 2730 | 2710 | 2470 | 2440 | 2130 | 2030 | 1970 | 1850 | 1800 | 1480 | 1000 | 580 | 320 | 280 | 180 |  | 360 | 1000 | 1080
Station R |  | 3390 | 3090 | 3070 | 2830 | 2800 | 2490 | 2390 | 2330 | 2210 | 2160 | 1840 | 1360 | 940 | 680 | 640 | 540 | 360 |  | 640 | 720
Station S |  | 4030 | 3730 | 3710 | 3470 | 3440 | 3130 | 3030 | 2970 | 2850 | 2800 | 2480 | 2000 | 1580 | 1320 | 1280 | 1180 | 1000 | 640 |  | 80
Station T |  | 4110 | 3810 | 3790 | 3550 | 3520 | 3210 | 3110 | 3050 | 2930 | 2880 | 2560 | 2080 | 1660 | 1400 | 1360 | 1260 | 1080 | 720 | 80
 | original |  | 0.3 | 0.32 | 0.56 | 0.5900000000000001 | 0.9 | 1 | 1.06 | 1.18 | 1.23 | 1.55 | 2.03 | 2.45 | 2.71 | 2.75 | 2.85 | 3.03 | 3.39 | 4.03 | 4.11
 | results | 0.3 |  | 0.02 | 0.26 | 0.29 | 0.6 | 0.7000000000000001 | 0.76 | 0.88 | 0.93 | 1.25 | 1.73 | 2.15 | 2.41 | 2.45 | 2.55 | 2.73 | 3.09 | 3.73 | 3.81
 |  | 0.32 | 0.02 |  | 0.24 | 0.27 | 0.5800000000000001 | 0.68 | 0.74 | 0.86 | 0.91 | 1.23 | 1.71 | 2.13 | 2.39 | 2.43 | 2.53 | 2.71 | 3.07 | 3.71 | 3.79
 |  | 0.56 | 0.26 | 0.24 |  | 0.03 | 0.34 | 0.44 | 0.5 | 0.62 | 0.67 | 0.99 | 1.47 | 1.89 | 2.15 | 2.19 | 2.29 | 2.470000000000001 | 2.830000000000001 | 3.470000000000001 | 3.550000000000001
 |  | 0.5900000000000001 | 0.29 | 0.27 | 0.03 |  | 0.31 | 0.41 | 0.47 | 0.5900000000000001 | 0.64 | 0.96 | 1.44 | 1.86 | 2.12 | 2.16 | 2.26 | 2.44 | 2.8 | 3.44 | 3.52
 |  | 0.9 | 0.6 | 0.5800000000000001 | 0.34 | 0.31 |  | 0.1 | 0.16 | 0.28 | 0.33 | 0.65 | 1.13 | 1.55 | 1.81 | 1.85 | 1.95 | 2.13 | 2.49 | 3.13 | 3.21
 |  | 1 | 0.7000000000000001 | 0.68 | 0.44 | 0.41 | 0.1 |  | 0.06 | 0.18 | 0.23 | 0.55 | 1.03 | 1.45 | 1.71 | 1.75 | 1.85 | 2.03 | 2.39 | 3.03 | 3.11
 |  | 1.06 | 0.76 | 0.74 | 0.5 | 0.47 | 0.16 | 0.06 |  | 0.12 | 0.17 | 0.49 | 0.97 | 1.39 | 1.65 | 1.69 | 1.79 | 1.97 | 2.33 | 2.97 | 3.05
 |  | 1.18 | 0.88 | 0.86 | 0.62 | 0.5900000000000001 | 0.28 | 0.18 | 0.12 |  | 0.05 | 0.37 | 0.8500000000000001 | 1.27 | 1.53 | 1.57 | 1.67 | 1.85 | 2.21 | 2.85 | 2.93
 |  | 1.23 | 0.93 | 0.91 | 0.67 | 0.64 | 0.33 | 0.23 | 0.17 | 0.05 |  | 0.32 | 0.8 | 1.22 | 1.48 | 1.52 | 1.62 | 1.8 | 2.16 | 2.8 | 2.88
 |  | 1.55 | 1.25 | 1.23 | 0.99 | 0.96 | 0.65 | 0.55 | 0.49 | 0.37 | 0.32 |  | 0.48 | 0.9000000000000001 | 1.16 | 1.2 | 1.3 | 1.48 | 1.84 | 2.48 | 2.56
 |  | 2.03 | 1.73 | 1.71 | 1.47 | 1.44 | 1.13 | 1.03 | 0.97 | 0.8500000000000001 | 0.8 | 0.48 |  | 0.42 | 0.68 | 0.7200000000000001 | 0.8200000000000001 | 1 | 1.36 | 2 | 2.08
 |  | 2.45 | 2.15 | 2.13 | 1.89 | 1.86 | 1.55 | 1.45 | 1.39 | 1.27 | 1.22 | 0.9000000000000001 | 0.42 |  | 0.26 | 0.3 | 0.4 | 0.5800000000000001 | 0.9400000000000002 | 1.58 | 1.66
 |  | 2.71 | 2.41 | 2.39 | 2.15 | 2.12 | 1.81 | 1.71 | 1.65 | 1.53 | 1.48 | 1.16 | 0.68 | 0.26 |  | 0.04 | 0.14 | 0.3200000000000001 | 0.6800000000000002 | 1.32 | 1.4
 |  | 2.75 | 2.45 | 2.43 | 2.19 | 2.16 | 1.85 | 1.75 | 1.69 | 1.57 | 1.52 | 1.2 | 0.7200000000000001 | 0.3 | 0.04 |  | 0.1 | 0.28 | 0.6400000000000001 | 1.28 | 1.36
 |  | 2.85 | 2.55 | 2.53 | 2.29 | 2.26 | 1.95 | 1.85 | 1.79 | 1.67 | 1.62 | 1.3 | 0.8200000000000001 | 0.4 | 0.14 | 0.1 |  | 0.18 | 0.54 | 1.18 | 1.26
 |  | 3.03 | 2.73 | 2.71 | 2.470000000000001 | 2.44 | 2.13 | 2.03 | 1.97 | 1.85 | 1.8 | 1.48 | 1 | 0.5800000000000001 | 0.3200000000000001 | 0.28 | 0.18 |  | 0.36 | 1 | 1.08
 |  | 3.39 | 3.09 | 3.07 | 2.830000000000001 | 2.8 | 2.49 | 2.39 | 2.33 | 2.21 | 2.16 | 1.84 | 1.36 | 0.9400000000000002 | 0.6800000000000002 | 0.6400000000000001 | 0.54 | 0.36 |  | 0.64 | 0.72
 |  | 4.03 | 3.73 | 3.71 | 3.470000000000001 | 3.44 | 3.13 | 3.03 | 2.97 | 2.85 | 2.8 | 2.48 | 2 | 1.58 | 1.32 | 1.28 | 1.18 | 1 | 0.64 |  | 0.08
 |  | 4.11 | 3.81 | 3.79 | 3.550000000000001 | 3.52 | 3.21 | 3.11 | 3.05 | 2.93 | 2.88 | 2.56 | 2.08 | 1.66 | 1.4 | 1.36 | 1.26 | 1.08 | 0.72 | 0.08