Spreadsheet: 54021d1253985765-define-districts-to-calculate-busfares-701031-busfare
Sheet: Blad1

 |  |  | District | Rate
 |  |  | 1 | 0.1
 |  |  | 2 | 0.2
 |  |  |  |  |  |  |  |  | Distance in Miles above Diagonal, Fare below
Sta | Distance | [NAME] | District | Rate | Fare | Cum Fare |  | From \ To | Sta A | Sta B | Sta C | Sta D | Sta E | Sta F | Sta G | Sta H | Sta I | Sta J | [NAME] | Sta L | Sta M | Sta N | Sta O | Sta P | Sta Q | Sta R | Sta S | Sta T
Sta A |  |  |  |  |  |  |  | Sta A |  | 190 | 480 | 900 | 1150 | 1300 | 1450 | 1590 | 1780 | 2160 | 2610 | 2810 | 2980 | 3330 | 3540 | 3720 | 4120 | 4580 | 4880 | 5070
Sta B | 190 | 190 | 1 | 0.1 | 19 | 19 |  | Sta B | $19 |  | 290 | 710 | 960 | 1110 | 1260 | 1400 | 1590 | 1970 | 2420 | 2620 | 2790 | 3140 | 3350 | 3530 | 3930 | 4390 | 4690 | 4880
Sta C | 290 | 480 | 1 | 0.1 | 29 | 48 |  | Sta C | $48 | $29 |  | 420 | 670 | 820 | 970 | 1110 | 1300 | 1680 | 2130 | 2330 | 2500 | 2850 | 3060 | 3240 | 3640 | 4100 | 4400 | 4590
Sta D | 420 | 900 | 1 | 0.1 | 42 | 90 |  | Sta D | $90 | $71 | $42 |  | 250 | 400 | 550 | 690 | 880 | 1260 | 1710 | 1910 | 2080 | 2430 | 2640 | 2820 | 3220 | 3680 | 3980 | 4170
Sta E | 250 | 1150 | 1 | 0.1 | 25 | 115 |  | Sta E | $115 | $96 | $67 | $25 |  | 150 | 300 | 440 | 630 | 1010 | 1460 | 1660 | 1830 | 2180 | 2390 | 2570 | 2970 | 3430 | 3730 | 3920
Sta F | 150 | 1300 | 1 | 0.1 | 15 | 130 |  | Sta F | $130 | $111 | $82 | $40 | $15 |  | 150 | 290 | 480 | 860 | 1310 | 1510 | 1680 | 2030 | 2240 | 2420 | 2820 | 3280 | 3580 | 3770
Sta G | 150 | 1450 | 1 | 0.1 | 15 | 145 |  | Sta G | $145 | $126 | $97 | $55 | $30 | $15 |  | 140 | 330 | 710 | 1160 | 1360 | 1530 | 1880 | 2090 | 2270 | 2670 | 3130 | 3430 | 3620
Sta H | 140 | 1590 | 1 | 0.1 | 14 | 159 |  | Sta H | $159 | $140 | $111 | $69 | $44 | $29 | $14 |  | 190 | 570 | 1020 | 1220 | 1390 | 1740 | 1950 | 2130 | 2530 | 2990 | 3290 | 3480
Sta I | 190 | 1780 | 1 | 0.1 | 19 | 178 |  | Sta I | $178 | $159 | $130 | $88 | $63 | $48 | $33 | $19 |  | 380 | 830 | 1030 | 1200 | 1550 | 1760 | 1940 | 2340 | 2800 | 3100 | 3290
Sta J | 380 | 2160 | 1 | 0.1 | 38 | 216 |  | Sta J | $216 | $197 | $168 | $126 | $101 | $86 | $71 | $57 | $38 |  | 450 | 650 | 820 | 1170 | 1380 | 1560 | 1960 | 2420 | 2720 | 2910
[NAME] | 450 | 2610 | 2 | 0.2 | 90 | 306 |  | [NAME] | $306 | $287 | $258 | $216 | $191 | $176 | $161 | $147 | $128 | $90 |  | 200 | 370 | 720 | 930 | 1110 | 1510 | 1970 | 2270 | 2460
Sta L | 200 | 2810 | 2 | 0.2 | 40 | 346 |  | Sta L | $346 | $327 | $298 | $256 | $231 | $216 | $201 | $187 | $168 | $130 | $40 |  | 170 | 520 | 730 | 910 | 1310 | 1770 | 2070 | 2260
Sta M | 170 | 2980 | 2 | 0.2 | 34 | 380 |  | Sta M | $380 | $361 | $332 | $290 | $265 | $250 | $235 | $221 | $202 | $164 | $74 | $34 |  | 350 | 560 | 740 | 1140 | 1600 | 1900 | 2090
Sta N | 350 | 3330 | 2 | 0.2 | 70 | 450 |  | Sta N | $450 | $431 | $402 | $360 | $335 | $320 | $305 | $291 | $272 | $234 | $144 | $104 | $70 |  | 210 | 390 | 790 | 1250 | 1550 | 1740
Sta O | 210 | 3540 | 2 | 0.2 | 42 | 492 |  | Sta O | $492 | $473 | $444 | $402 | $377 | $362 | $347 | $333 | $314 | $276 | $186 | $146 | $112 | $42 |  | 180 | 580 | 1040 | 1340 | 1530
Sta P | 180 | 3720 | 2 | 0.2 | 36 | 528 |  | Sta P | $528 | $509 | $480 | $438 | $413 | $398 | $383 | $369 | $350 | $312 | $222 | $182 | $148 | $78 | $36 |  | 400 | 860 | 1160 | 1350
Sta Q | 400 | 4120 | 2 | 0.2 | 80 | 608 |  | Sta Q | $608 | $589 | $560 | $518 | $493 | $478 | $463 | $449 | $430 | $392 | $302 | $262 | $228 | $158 | $116 | $80 |  | 460 | 760 | 950
Sta R | 460 | 4580 | 2 | 0.2 | 92 | 700 |  | Sta R | $700 | $681 | $652 | $610 | $585 | $570 | $555 | $541 | $522 | $484 | $394 | $354 | $320 | $250 | $208 | $172 | $92 |  | 300 | 490
Sta S | 300 | 4880 | 2 | 0.2 | 60 | 760 |  | Sta S | $760 | $741 | $712 | $670 | $645 | $630 | $615 | $601 | $582 | $544 | $454 | $414 | $380 | $310 | $268 | $232 | $152 | $60 |  | 190
Sta T | 190 | 5070 | 2 | 0.2 | 38 | 798 |  | Sta T | $798 | $779 | $750 | $708 | $683 | $668 | $653 | $639 | $620 | $582 | $492 | $452 | $418 | $348 | $306 | $270 | $190 | $98 | $38