Spreadsheet: 870071d1716573322-summarizing-monthly-data-from-column-to-row-by-sections-book2
Sheet: Monthly Data

year | month_year | days_in_month | [NAME] | Origin | Destination | Route | Aircraft_type | Charter_Sch | Distance_KMs | year_num_route | month_num_route | daily_frequency | weekly_frequency | monthly_frequency | monthly_cycle | monthly_flight_hours | monthly_block_hours | FH_FC | monthly_total_seat | monthly_ASK_bc | monthly_ASK_eco | monthly_ASK | cf_bc_by_route | cf_eco_by_route | Total_PAX_BC | Total_PAX_ECO | Total_PAX | Total_REV_BC | Total_REV_ECO | Total_REV_PAX | AVG_fare_BC | AVG_fare_ECO | AVG_fare_PAX | Total_RPK_BC | Total_RPK_ECO | Total_RPK | new_cabin_factor_bc | new_cabin_factor_eco | new_cabin_factor | Ancillary_REV | Cargo_REV | Total_REV_Inc_Ancil | AVG_Fare_Inc_Ancil | [NAME] | Total_REV_Inc_Ancil_Cargo | AVG_Fare_Inc_Ancil_Cargo | RASK_Inc_Ancil_Cargo | Total_REV_Inc_Ancil_Cargo_per_BH
2025 | 2025-11 | 30 | 2 | BKK | TPE | BKK-TPE | A330-300 | Schedule | 2489 | 1 | 1 | 1 | 7 | 30 | 60 | 192 | 222 | 3.2 | 17520 | 4778880 | 38828400 | 43607280 | 74.841 | 78.78 | 1437 | 12289 | 13726 | 23340700.8 | 65623168.8 | 88963869.6 | 16242.6588726513 | 5339.99257872894 | 6481.41261838845 | 3576693 | 30587321 | 34164014 | 74.84 | 78.78 | 78.34 | 889638.696 | 7938000 | 89853508.2959999 | 6546.22674457234 | 2.06051623251897
2025 | 2025-12 | 31 | 2 | BKK | TPE | BKK-TPE | A330-300 | Schedule | 2489 | 1 | 2 | 1 | 7 | 31 | 62 | 198.4 | 229.4 | 3.2 | 18104 | 4938176 | 40122680 | 45060856 | 79.6385 | 83.83 | 1579 | 13514 | 15093 | 25647237 | 72176475 | 97823712 | 16242.7086763774 | 5340.86687879236 | 6481.39614390777 | 3930131 | 33636346 | 37566477 | 79.59 | 83.83 | 83.37 | 978237.12 | 8202600.000000001 | 98801949.12 | 6546.21010534685 | 2.19263364903676
2029 | 2029-11 | 30 | 2 | BKK | TPE | BKK-TPE | A330-300 | Schedule | 2489 | 5 | 49 | 1 | 7 | 30 | 60 | 192 | 222 | 3.2 | 17520 | 4778880 | 38828400 | 43607280 | 81.0103052865599 | 85.2740055647999 | 1555 | 13302 | 14857 | 26803996.0638214 | 75978616.3882355 | 102782612.452056 | 17237.2965040652 | 5711.81900377654 | 6918.1269739555 | 3870395 | 33108678 | 36979073 | 80.99 | 85.27 | 84.8 | 8222608.99616455 | 11793600 | 111005221.448221 | 7471.57713187194 | 2.54556627811277
2029 | 2029-11 | 30 | 2 | BKK | TPE | BKK-TPE | A350-900 | Schedule | 2489 | 1 | 1 | 1 | 7 | 30 | 60 | 192 | 222 | 3.2 | 19260 | 4778880 | 43159260 | 47938140 | 72.0689655172413 | 75.8620689655172 | 1383 | 13154 | 14537 | 22463766 | 70242422.4 | 92706188.4 | 16242.7809110629 | 5340.00474380416 | 6377.25723326683 | 3442287 | 32740306 | 36182593 | 72.03 | 75.86 | 75.48 | 927061.884 | 4808160 | 93633250.284 | 6441.0298055995 | 1.95320991352605
2029 | 2029-12 | 31 | 2 | BKK | TPE | BKK-TPE | A330-300 | Schedule | 2489 | 5 | 50 | 1 | 7 | 31 | 62 | 198.4 | 229.4 | 3.2 | 18104 | 4938176 | 40122680 | 45060856 | 86.20327357416 | 90.7402879727999 | 1711 | 14628 | 16339 | 29493054.231595 | 83552367.6468704 | 113045421.878465 | 17237.3198314407 | 5711.81074971769 | 6918.74789635017 | 4258679 | 36409092 | 40667771 | 86.24 | 90.74 | 88 | 9043633.75027724 | 12621960 | 122089055.628742 | 7472.24772805818 | 2.70942601775569
2030 | 2030-05 | 31 | 2 | BKK | TPE | BKK-TPE | A350-900 | Schedule | 2489 | 1 | 7 | 1 | 7 | 31 | 62 | 198.4 | 229.4 | 3.2 | 19902 | 4938176 | 44597902 | 49536078 | 72.0689655172413 | 75.8620689655172 | 1429 | 13591 | 15020 | 22300341 | 69799402.4 | 92099743.3999999 | 15605.5570328901 | 5135.70763004929 | 6131.80715046604 | 3556781 | 33827999 | 37384780 | 72.03 | 75.85 | 75.47 | 920997.433999999 | 5189400 | 93020740.8339999 | 6193.1252219707 | 1.87783822598955
2027 | 2027-03 | 31 | 3 | BKK | NRT | BKK-NRT | A350-900 | Schedule | 4649 | 1 | 5 | 1 | 7 | 31 | 62 | 372 | 403 | 6 | 19902 | 9223616 | 83300782 | 92524398 | 74.6896551724138 | 78.6206896551724 | 1484 | 14089 | 15573 | 46184067 | 140777773.5 | 186961840.5 | 31121.338948787 | 9992.03445950741 | 12005.5121363899 | 6899116 | 65499761 | 72398877 | 74.8 | 78.63 | 78.25 | 1869618.405 | 20686176 | 188831458.905 | 12125.5672577538 | 2.04088286967292
2027 | 2027-04 | 30 | 3 | BKK | NRT | BKK-NRT | A330-200 | Schedule | 4649 | 3 | 28 | 1 | 7 | 30 | 60 | 360 | 390 | 6 | 13560 | 8368200 | 54672240 | 63040440 | 86.0608476 | 95.623164 | 1549 | 11244 | 12793 | 62685518.4978749 | 147724699.360874 | 210410217.858749 | 40468.3786300032 | 13138.0913696971 | 16447.2928835105 | 7201301 | 52273356 | 59474657 | 86.06 | 95.61 | 88 | 10520510.8929374 | 14963184 | 220930728.751687 | 17269.657527686 | 3.50458735300209
2027 | 2027-04 | 30 | 3 | BKK | NRT | BKK-NRT | A350-900 | Schedule | 4649 | 1 | 6 | 1 | 7 | 30 | 60 | 360 | 390 | 6 | 19260 | 8926080 | 80613660 | 89539740 | 76.7487684729064 | 80.7881773399015 | 1473 | 14010 | 15483 | 57859230 | 176770035 | 234629265 | 39279.8574338085 | 12617.4186295503 | 15153.9924433249 | 6847977 | 65132490 | 71980467 | 76.72 | 80.8 | 80.39 | 2346292.65 | 20092320 | 236975557.65 | 15305.5323677581 | 2.64659644589095
2027 | 2027-05 | 31 | 3 | BKK | NRT | BKK-NRT | A350-900 | Schedule | 4649 | 1 | 7 | 1 | 7 | 31 | 62 | 372 | 403 | 6 | 19902 | 9223616 | 83300782 | 92524398 | 68.5123152709359 | 72.1182266009852 | 1358 | 12923 | 14281 | 38980875 | 119214075 | 158194950 | 28704.6207658321 | 9224.95357115221 | 11077.3020096631 | 6313342 | 60079027 | 66392369 | 68.45 | 72.12 | 71.76 | 1581949.5 | 21283794 | 159776899.5 | 11188.0750297598 | 1.72686235148484
2027 | 2027-05 | 31 | 3 | BKK | NRT | BKK-NRT | A330-200 | Schedule | 4649 | 3 | 29 | 1 | 7 | 31 | 62 | 372 | 403 | 6 | 14012 | 8647140 | 56494648 | 65141788 | 77.73847992 | 86.3760888 | 1445 | 10497 | 11942 | 42734948.6654999 | 100831152.187062 | 143566100.852562 | 29574.3589380622 | 9605.71136391944 | 12021.9478188379 | 6717805 | 48800553 | 55518358 | 77.69 | 86.38 | 85.23 | 7178305.04262812 | 15392988 | 150744405.89519 | 12623.0452097798 | 2.31409684203311
2027 | 2027-06 | 30 | 3 | BKK | NRT | BKK-NRT | A330-200 | Schedule | 4649 | 3 | 30 | 1 | 7 | 30 | 60 | 360 | 390 | 6 | 13560 | 8368200 | 54672240 | 63040440 | 75.657888 | 84.06432 | 1363 | 9887 | 11250 | 38187854.8852499 | 90015646.6676249 | 128203501.552874 | 28017.5017499999 | 9104.44489406543 | 11395.8668046999 | 6336587 | 45964663 | 52301250 | 75.72 | 84.07 | 82.96 | 6410175.07764374 | 14507424 | 134613676.630518 | 11965.6601449349 | 2.13535433176733
2027 | 2027-06 | 30 | 3 | BKK | NRT | BKK-NRT | A350-900 | Schedule | 4649 | 1 | 8 | 1 | 7 | 30 | 60 | 360 | 390 | 6 | 19260 | 8926080 | 80613660 | 89539740 | 66.4532019704433 | 69.9507389162561 | 1276 | 12131 | 13407 | 34699185 | 106069725 | 140768910 | 27193.7186520376 | 8743.69178138653 | 10499.6576415305 | 5932124 | 56397019 | 62329143 | 66.46 | 69.96 | 69.61 | 1407689.1 | 20531880 | 142176599.1 | 10604.6542179458 | 1.58786030761313
2027 | 2027-07 | 31 | 3 | BKK | NRT | BKK-NRT | A330-200 | Schedule | 4649 | 3 | 31 | 1 | 7 | 31 | 62 | 372 | 403 | 6 | 14012 | 8647140 | 56494648 | 65141788 | 75.657888 | 84.06432 | 1407 | 10215 | 11622 | 39420385.1684999 | 93046764.3603749 | 132467149.528874 | 28017.3313208955 | 9108.83645231277 | 11397.9650257163 | 6541143 | 47489535 | 54030678 | 75.65 | 84.06 | 82.94 | 6623357.47644374 | 14649062.4 | 139090507.005318 | 11967.8632770021 | 2.13519633518992