Spreadsheet: 860599d1708628113-formula-to-help-select-suggest-the-best-aircraft-for-a-specific-route-excelforum-example1
Sheet: Aircraft

Aircraft Name | Cost Stage | Runway length required to land | Maximum flight [NAME] | Speed | E/C Ratio
172 | 1 | 2500 | 1000 | 221 | -0.925
340 | 1 | 2000 | 1730 | 425 | -1.244
1900 | 1 | 4500 | 2907 | 500 | -1.351
2000 | 1 | 2000 | 2185 | 737 | 0.406
1900C | 1 | 4500 | 2500 | 553 | -1.264
1900D | 1 | 4500 | 2776 | 470 | -2.665
2-0-2 | 1 | 1565 | 2900 | 510 | -0.52
208B | 1 | 2990 | 2000 | 327 | -0.691
328-100 | 1 | 4485 | 1310 | 639 | -0.37
328-310JET | 1 | 4485 | 1980 | 710 | -0.429
4-0-4 | 2 | 1980 | 1800 | 467 | -0.251
428JET | 2 | 4530 | 1665 | 710 | -0.273
90 Scandia | 2 | 2000 | 2510 | 477 | -0.48
A220-100 | 2 | 4790 | 5750 | 967 | 0.488
A220-300 | 2 | 4900 | 6110 | 967 | 0.321
A300-600 | 2 | 7625 | 6670 | 980 | 0.085
A300-600R | 2 | 7625 | 7505 | 963 | 0.075
A300B2-200 | 2 | 7625 | 3430 | 864 | 0.183
A300B4-200 | 2 | 7625 | 6300 | 864 | 0.079
A310-200 | 2 | 7000 | 6800 | 935 | 0.071
A310-300 | 2 | 6000 | 9600 | 935 | 0.039
A318-100 | 2 | 6500 | 6020 | 835 | 0.274
A319-200 | 2 | 6850 | 7000 | 835 | 0.226
A319NEO | 2 | 6000 | 6950 | 949 | 0.274
A320-200 | 3 | 6500 | 5700 | 881 | 0.232
A320-NEO | 3 | 6500 | 7000 | 893 | 0.143
A321-200 | 3 | 7250 | 6000 | 835 | 0.24
A321-NEO | 3 | 6500 | 7250 | 893 | 0.098
A321-XLR | 3 | 7500 | 8900 | 920 | 0.082
A330-200 | 3 | 9090 | 12500 | 958 | 0.046
A330-300 | 3 | 9090 | 10000 | 958 | 0.067
A330-800neo | 3 | 9500 | 13900 | 801 | 0.052
A330-900neo | 3 | 9950 | 12130 | 801 | 0.043
A340-200 | 3 | 9810 | 14800 | 950 | 0.148
A340-300 | 3 | 10200 | 14000 | 1004 | 0.049
A340-500 | 3 | 10200 | 14500 | 862 | 0.037
A340-600 | 3 | 10200 | 14630 | 871 | 0.043
A350-1000 | 3 | 8760 | 14800 | 860 | 0.047
A350-800 | 3 | 8760 | 14500 | 860 | 0.041
A350-900 | 3 | 8760 | 14500 | 860 | 0.046
A350-900R | 3 | 8760 | 14500 | 860 | 0.037
A350-900ULR | 3 | 8760 | 18000 | 848 | 0.028
A380-800 | 3 | 9680 | 14500 | 1049 | 0.031
An-10 | 3 | 6500 | 4075 | 728 | 0.386
An-10A | 3 | 6500 | 4075 | 728 | 0.445
An-12 | 3 | 6500 | 3600 | 663 | 0.636
[NAME] | 3 | 5500 | 2420 | 446 | 0.34
An-74-200 | 3 | 4650 | 3300 | 539 | -1.877
An-74TK-100 | 4 | 5600 | 2750 | 539 | 0.267
An-74TK-300 | 4 | 7500 | 3600 | 582 | 0.242
An-74VIP | 4 | 6500 | 3300 | 539 | -1.766
ARJ21-700 | 4 | 7500 | 2200 | 930 | 0.677
ARJ21-700ER | 4 | 7800 | 3700 | 930 | 0.41
ARJ21-900 | 4 | 7900 | 2200 | 930 | 0.848
ATR 42-300 | 4 | 6500 | 1945 | 524 | -0.453
ATR 42-320 | 4 | 6500 | 1945 | 483 | 0.463
ATR 42-400 | 4 | 6500 | 1945 | 504 | -0.669
ATR 42-500 | 4 | 6500 | 1611 | 550 | -0.81
ATR 42-600 | 4 | 6500 | 2000 | 559 | -0.334
ATR 72-200 | 4 | 6500 | 2665 | 456 | 0.431
ATR 72-210 | 4 | 6500 | 2800 | 485 | 0.421
ATR 72-500 | 4 | 6500 | 1650 | 553 | 0.492
ATR 72-600 | 4 | 6500 | 2800 | 613 | 0.48
[NAME] | 4 | 8600 | 6760 | 574 | -0.071
B707 | 4 | 6450 | 9913 | 1006 | 0.201
B717-200 | 4 | 6450 | 3815 | 761 | 0.599
B727-100 | 4 | 8300 | 3056 | 1009 | 1.013
B727-200 | 4 | 6450 | 4450 | 972 | 0.367
B737 MAX 10 | 5 | 7600 | 7000 | 881 | 0.151
B737 MAX 7 | 5 | 7300 | 6850 | 881 | 0.115
B737 MAX 8 | 5 | 7500 | 6500 | 881 | 0.128
B737 MAX 9 | 5 | 7550 | 7000 | 881 | 0.138
B737-100 | 5 | 7550 | 3440 | 796 | 0.586
B737-200 | 5 | 7550 | 4170 | 958 | 0.526
B737-200Adv | 5 | 7550 | 5473 | 858 | 0.332
B737-200C | 5 | 7550 | 4622 | 772 | 0.412
B737-300 | 5 | 7550 | 4707 | 795 | 0.414
B737-400 | 5 | 7550 | 4010 | 733 | 0.355
B737-500 | 5 | 7550 | 4449 | 718 | 0.483
B737-600 | 5 | 7550 | 5648 | 762 | 0.336
B737-700 | 5 | 7550 | 6230 | 762 | 0.338
B737-700C | 5 | 7550 | 5940 | 831 | 0.34
B737-700ER | 5 | 7550 | 10200 | 770 | 0.19
B737-800 | 5 | 7550 | 7000 | 725 | 0.413
B737-900 | 5 | 7550 | 3815 | 836 | 0.359
B737-900ER | 5 | 7550 | 5925 | 831 | 0.253
B747-100 | 5 | 10250 | 9800 | 938 | 0.028
B747-200B | 5 | 10250 | 12700 | 839 | 0.001
B747-300 | 5 | 10250 | 12400 | 973 | 0.03
B747-400 | 5 | 10250 | 14500 | 982 | 0.014
B747-400C | 5 | 10250 | 13360 | 1010 | 0.035
B747-400D | 5 | 10250 | 2905 | 1010 | 0.072
B747-400ER | 5 | 10250 | 14500 | 866 | 0.032
B747-8 | 5 | 10250 | 14815 | 1097 | 0.044
B747SP | 6 | 7545 | 10800 | 980 | 0.086
B757-200 | 6 | 7800 | 7222 | 842 | 0.19
B757-300 | 6 | 7800 | 6421 | 842 | 0.353
B767-200 | 6 | 7800 | 7300 | 1013 | 0.273
B767-200ER | 6 | 7800 | 12200 | 995 | 0.142
B767-300 | 6 | 7800 | 7300 | 945 | 0.083
B767-300ER | 6 | 7800 | 11065 | 936 | 0.046
B767-400ER | 6 | 7800 | 10415 | 928 | 0.057
B777-200 | 6 | 9000 | 9695 | 950 | 0.062
B777-200ER | 6 | 11000 | 14260 | 1014 | 0.044
B777-200LR | 6 | 11000 | 14500 | 986 | 0.044
B777-300 | 6 | 9000 | 11135 | 878 | 0.039
B777-300ER | 6 | 11000 | 14685 | 1036 | 0.052
B777-300LR | 6 | 11000 | 14500 | 1026 | 0.031
B777-8X | 6 | 9000 | 16100 | 951 | 0.048
B777-9X | 6 | 9000 | 14500 | 931 | 0.047
B787-10 | 6 | 8000 | 12000 | 860 | 0.052
B787-8 | 6 | 9000 | 14500 | 813 | 0.125
B787-9 | 6 | 9000 | 14500 | 813 | 0.033
BAe 146-300 | 6 | 3921 | 2400 | 702 | 0.892
BAe146 | 6 | 6500 | 2000 | 675 | 0.721
C S100 | 6 | 4449 | 5463 | 905 | 0.344
C S300 | 6 | 4800 | 5463 | 905 | 0.231
C919 | 6 | 5200 | 5555 | 980 | 0.31
Caravelle 10B | 6 | 7500 | 2650 | 924 | 0.726
Caravelle 10R | 6 | 7500 | 3455 | 896 | 0.406
Caravelle 11R | 6 | 7550 | 2300 | 896 | 0.79
Caravelle 12 | 6 | 7600 | 3465 | 924 | 0.738
Caravelle III | 6 | 7700 | 1700 | 886 | 0.821
Caravelle IV-N | 6 | 7800 | 2350 | 761 | 0.542
Caravelle IV-R | 6 | 7800 | 2300 | 828 | 0.605
Challenger 300 | 6 | 3500 | 3000 | 945 | -1.786
Challenger 600 | 6 | 3500 | 5925 | 863 | -0.241
Challenger 601 | 6 | 3500 | 6236 | 825 | -0.1
Challenger 604 | 6 | 3780 | 9680 | 800 | -0.007
Challenger 605 | 6 | 3780 | 7491 | 799 | -0.159
Citation X | 6 | 4000 | 6020 | 947 | -0.844
CL-44D | 6 | 8050 | 4855 | 711 | 0.291
Concorde | 7 | 11800 | 7500 | 1933 | -0.067
CRJ 100 | 7 | 4500 | 2417 | 840 | 0.737
CRJ 1000 | 7 | 5499 | 2760 | 877 | 0.578
CRJ 100ER | 7 | 4500 | 3056 | 840 | 0.577
CRJ 100LR | 7 | 2000 | 3710 | 840 | 0.471
CRJ 200 | 7 | 2000 | 3500 | 802 | 0.535
CRJ 200LR | 7 | 2000 | 3713 | 802 | 0.508
CRJ 700 | 7 | 2000 | 3121 | 794 | 0.393
CRJ 700ER | 7 | 2000 | 3676 | 794 | 0.33
[NAME] | 7 | 2000 | 2735 | 840 | 0.435
CRJ 701 | 7 | 2000 | 2655 | 879 | 0.489
CRJ 701ER | 7 | 2000 | 3206 | 879 | 0.401
CRJ 701LR | 7 | 2000 | 3708 | 879 | 0.345
CRJ 702 | 7 | 2000 | 3121 | 859 | 0.459
CRJ 705 | 7 | 2000 | 3184 | 879 | 0.445
CRJ 705ER | 7 | 2000 | 3635 | 879 | 0.39
[NAME] | 7 | 2000 | 3702 | 879 | 0.383
CRJ 900 | 7 | 2000 | 2956 | 837 | 0.518
CRJ 900ER | 7 | 2000 | 3488 | 808 | 0.448
[NAME] | 8 | 2000 | 4002 | 808 | 0.389
CRJ 900NG | 8 | 2000 | 2421 | 838 | 0.589
CV-880 | 8 | 8050 | 4636 | 979 | 0.357
CV-990A | 8 | 5350 | 5785 | 999 | -0.905
Dassault Mercure | 8 | 2000 | 1700 | 833 | 0.078
DC-1 | 8 | 2000 | 1500 | 297 | -1.543
DC-10-10 | 8 | 2000 | 6436 | 1008 | 0.359
DC-10-15 | 8 | 2000 | 7000 | 854 | 0.057
DC-10-30 | 8 | 2000 | 9493 | 872 | 0.04
DC-10-40 | 8 | 2000 | 9322 | 972 | 0.027
DC-2 | 8 | 2000 | 1750 | 273 | -0.985
DC-3 | 8 | 2000 | 1650 | 250 | -0.319
DC-4 | 8 | 2000 | 4023 | 332 | 0.199
[NAME] | 8 | 2000 | 2575 | 358 | -0.892
DC-6 | 8 | 2000 | 7376 | 491 | -0.165
DC-6B | 8 | 2000 | 4835 | 568 | 0.2
DC-7 | 8 | 2000 | 7410 | 576 | 0.126
DC-7B | 8 | 2000 | 8000 | 610 | 0.113
DC-7C | 8 | 2000 | 9070 | 500 | 0.11
DC-8-10 | 8 | 2000 | 7410 | 902 | 0.182
DC-8-20 | 8 | 2000 | 7410 | 877 | 0.184
DC-8-40 | 8 | 2000 | 8230 | 916 | 0.167
DC-8-50 | 8 | 2000 | 11260 | 844 | 0.092
DC-8-61 | 8 | 2000 | 6035 | 853 | 0.312
DC-8-62 | 8 | 2000 | 9620 | 856 | 0.18
DC-8-63 | 8 | 2000 | 7600 | 883 | 0.042
DC-8-71 | 8 | 2000 | 7035 | 808 | 0.278
DC-8-72 | 8 | 2000 | 10620 | 808 | 0.171
DC-8-73 | 8 | 2000 | 8650 | 808 | 0.045
DC-9-10 | 8 | 2000 | 2036 | 894 | 0.79
DC-9-21 | 8 | 2000 | 2977 | 914 | 0.425
DC-9-30 | 8 | 2000 | 2631 | 871 | 0.577
DC-9-40 | 8 | 2000 | 2712 | 871 | 0.557
DC-9-50 | 8 | 2000 | 2631 | 889 | 0.635
DHC-7 | 8 | 2000 | 1400 | 396 | -0.178
DHC-8-100 | 8 | 2000 | 1889 | 480 | -1.787
DHC-8-Q200 | 8 | 2000 | 1713 | 510 | -2.024
DHC-8-Q300 | 8 | 2000 | 1558 | 512 | -0.3
DHC-8-Q400 | 8 | 2000 | 2522 | 734 | 0.5
E175-E2 | 8 | 4265 | 3820 | 966 | 0.184
E190-E2 | 8 | 4314 | 3820 | 905 | 0.247
E195-E2 | 8 | 4593 | 3820 | 905 | 0.252
EMB 120 | 8 | 2000 | 1481 | 541 | -1.629
EMB 121 Xingu I | 8 | 2000 | 2352 | 329 | -1.775
ERJ 135ER | 8 | 2000 | 2650 | 910 | -0.025
ERJ 135LR | 8 | 2000 | 3138 | 910 | 0.307
ERJ 140LR | 8 | 2000 | 3019 | 910 | 0.509
ERJ 145ER | 8 | 2000 | 2445 | 866 | 0.747
ERJ 145LR | 8 | 2000 | 2870 | 883 | 0.67
ERJ 145XR | 8 | 2000 | 3705 | 909 | 0.426
ERJ 170-100 | 8 | 2000 | 3334 | 891 | 0.395
ERJ 170-100AR | 8 | 2000 | 3892 | 891 | 0.307
ERJ 170-100LR | 8 | 2000 | 3889 | 891 | 0.339
ERJ 170-200 | 8 | 2000 | 3334 | 891 | 0.455
ERJ 170-200AR | 8 | 2000 | 3706 | 891 | 0.371
ERJ 170-200LR | 8 | 2000 | 3889 | 891 | 0.388
ERJ 190-100 | 8 | 2000 | 3334 | 870 | 0.581
ERJ 190-100AR | 8 | 2000 | 4448 | 870 | 0.433
ERJ 190-100LR | 9 | 2000 | 4260 | 870 | 0.453
ERJ 190-200 | 9 | 2000 | 2593 | 870 | 0.793
ERJ 190-200AR | 9 | 2000 | 4077 | 870 | 0.458
ERJ 190-200LR | 9 | 2000 | 3334 | 870 | 0.616
F100 | 9 | 6000 | 4300 | 695 | 0.552
F27-100 | 9 | 2000 | 1315 | 466 | -0.326
F27-200 | 9 | 2000 | 1926 | 451 | -1.494
F27-400 | 9 | 2000 | 1468 | 412 | -0.319
F27-500 | 9 | 2000 | 1826 | 482 | -0.342
F27-600 | 9 | 2000 | 1890 | 392 | -0.879
F28-1000 | 9 | 2000 | 2000 | 908 | 0.549
F28-2000 | 9 | 2000 | 2743 | 908 | 0.514
F28-3000 | 9 | 2000 | 1900 | 902 | 0.61
F28-4000 | 9 | 2000 | 1900 | 944 | 0.866
F28-6000 | 9 | 2000 | 1650 | 767 | 0.911
Falcon 2000 | 9 | 5436 | 5790 | 1040 | -1.499
Falcon 2000LX | 9 | 5436 | 7400 | 1092 | -2.35
Fokker 50 | 9 | 2000 | 2055 | 624 | 0.46
Fokker 70 | 9 | 2000 | 2040 | 817 | 0.653
Fokker 70A | 9 | 2000 | 2040 | 817 | 0.745
Global 7500 | 9 | 5800 | 14260 | 898 | -0.362
Global 8000 | 9 | 5820 | 14631 | 898 | -0.312
Il-114 | 9 | 2000 | 1000 | 490 | 0.247
Il-114-100 | 9 | 2000 | 2000 | 465 | 0.558
Il-114-300 | 9 | 2000 | 2100 | 485 | 0.419
Il-14M | 9 | 2000 | 1750 | 339 | -0.386
Il-14P | 9 | 2000 | 1750 | 339 | -0.744
Il-18A | 9 | 2000 | 2560 | 564 | 0.479
Il-18B | 9 | 2000 | 2560 | 564 | 0.549
Il-18D | 9 | 2000 | 6500 | 580 | 0.338
Il-18I | 9 | 2000 | 3100 | 580 | 0.563
Il-18V | 9 | 2000 | 3100 | 589 | 0.461
Il-62 | 9 | 2000 | 7550 | 893 | 0.211
Il-62M | 10 | 2000 | 8850 | 932 | 0.174
Il-62MK | 10 | 2000 | 10000 | 944 | 0.18
Il-96-300 | 10 | 2000 | 11500 | 833 | 0.053
Il-96-400 | 10 | 2000 | 10000 | 809 | 0.091
Il-96M | 10 | 2000 | 12800 | 842 | 0.057
Jetstream 31 | 10 | 2000 | 1260 | 405 | -1.076
Jetstream 41 | 10 | 2000 | 1433 | 541 | -0.519
King Air 350i | 10 | 3300 | 3340 | 626 | -3.156
L-1011-200 | 10 | 2000 | 7420 | 838 | 0.055
L-1011-500 | 10 | 9400 | 9900 | 876 | 0.083
L-1049G S/C | 10 | 2000 | 8700 | 596 | -0.143
[NAME] | 10 | 2000 | 4585 | 957 | -3.399
[NAME] | 10 | 2000 | 3450 | 593 | 0.58
Learjet 25B | 10 | 2000 | 2684 | 789 | -1.912
Legacy 450 | 10 | 2000 | 4260 | 837 | -3.078
Legacy 500 | 10 | 2000 | 5186 | 837 | -2.538
Legacy 600 | 10 | 2000 | 6060 | 784 | -0.726
Lineage 1000 | 10 | 2000 | 8344 | 924 | -1.02
MC-21-200 | 10 | 6400 | 5000 | 1096 | 0.435
MC-21-300 | 10 | 6600 | 5000 | 1096 | 0.532
MC-21-400 | 10 | 6800 | 5500 | 1096 | 0.546
MD-11 | 10 | 2000 | 12655 | 929 | 0.039
MD-11C | 10 | 2000 | 12435 | 955 | 0.039
MD-11ER | 10 | 2000 | 13408 | 955 | 0.052
MD80 | 10 | 2000 | 6000 | 868 | 0.363
MD-81 | 10 | 2000 | 2910 | 819 | 0.573
MD-83 | 10 | 2000 | 4640 | 746 | 0.344
[NAME] | 10 | 2000 | 4440 | 738 | 0.5
MD-88 | 11 | 2000 | 3800 | 908 | 0.477
MD-90-30 | 11 | 2000 | 3860 | 909 | 0.503
MD-90-30ER | 11 | 2000 | 4424 | 909 | 0.434
MD-90-50 | 11 | 2000 | 5160 | 909 | 0.368
N262 | 11 | 2000 | 1100 | 346 | -0.462
Phenom 100 | 11 | 2000 | 2182 | 708 | -4.499
Phenom 300 | 11 | 2000 | 3334 | 851 | -4.195
Praetor 500 | 11 | 2000 | 6186 | 837 | -1.758
Praetor 600 | 11 | 2000 | 7441 | 794 | -1.555
SN-601 Corvette | 11 | 2000 | 2555 | 684 | -1.343
Spacejet M100 | 11 | 5770 | 3540 | 1123 | -0.708
Spacejet M90 | 11 | 5710 | 3770 | 1123 | -1.27
SU-80GP | 11 | 2000 | 1300 | 391 | -0.434
Superjet 100-60 | 11 | 4900 | 3204 | 1017 | 0.008
Superjet 100-75 | 11 | 4970 | 2900 | 1017 | 0.022
Superjet 100-95 | 11 | 2000 | 2950 | 839 | 0.562
Superjet 100-95LR | 11 | 6730 | 4578 | 1017 | 0.072
Tu-104 | 11 | 2000 | 2750 | 816 | -1.124
Tu-104A | 12 | 2000 | 2750 | 765 | 0.249
Tu-104B | 12 | 2000 | 2650 | 795 | 0.595
Tu-104D | 12 | 2000 | 2750 | 765 | 0.423
Tu-110 | 12 | 2000 | 3450 | 899 | 0.363
Tu-124 | 12 | 2000 | 2100 | 972 | 0.268
Tu-134A | 12 | 2000 | 2000 | 799 | 0.613
Tu-154 | 12 | 2000 | 5280 | 893 | 0.307
Tu-154M | 12 | 2000 | 4000 | 893 | 0.391
Tu-204-100 | 12 | 2000 | 4300 | 729 | 0.312
Tu-204-120 | 12 | 2000 | 4100 | 834 | 0.374
Tu-204-300 | 12 | 2000 | 5800 | 833 | 0.255
Tu-214 | 12 | 2000 | 4341 | 729 | 0.31
Tu-334-100 | 12 | 2000 | 3150 | 795 | 0.54
Tu-334-100D | 12 | 2000 | 4100 | 828 | 0.387
Tu-334-120D | 12 | 2000 | 4100 | 733 | 0.355
Tu-334-200 | 12 | 2000 | 2200 | 828 | 0.829
Tu-334-220 | 12 | 2000 | 2200 | 799 | 0.822