Build CEO Dashboard — Mission Control

← Back to Tasks

OVERRIDES runtime profile: uses direct_python (plain Python, no model) because the command chain never invokes the claude CLI or any LLM API — pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).

Daily CEO dashboard build. Downloads all data files from Google Drive, runs build_html_dashboard.py, uploads Dashboard.html back to Drive.

Runs weekdays at 8:30am SAST (6:30 UTC) — after all data feeds are fresh: - SummaryRoute/Excel: synced from Dropbox via CloudHQ (~6:30am) - ACSA monthly: checked at 7:00am - Booking curve: pulled at 8:00am - ACSA website: updated Tue 8:00am - IATA fuel: updated Tue 8:10am
- Fleet: updated Tue 8:15am

100% Python, zero AI cost. Downloads ~25MB of data, generates ~1.7MB HTML. After build, sends a Telegram briefing with critical analysis of the data.

Source: All reporting data files on Google Drive Target: Dashboard.html in Reporting Data folder (Google Drive) Post-build: scripts/ceo_briefing.py sends Telegram briefing

Schedule Weekdays at 05:000 5 * * 1-5

EnabledYes

Run Asshell

Timeout600s

RetryYes

Next Runin 2d (2026-06-15 05:00)

Task Definition

tasks/ceo-dashboard-build.md

Run Asshell

Commandset

Tool-lessNo

BackgroundNo

Runtime profile

Notify destination

cd /home/lucienne/workspace && /home/lucienne/workspace/.venvs/ceo-dashboard/bin/python scripts/ceo_dashboard_build.py

---
id: ceo-dashboard-build
title: Build CEO Dashboard
schedule: "0 5 * * 1-5"
timeout: 600
retry: true
enabled: true
notify_on: always
run_as: shell
command: "cd /home/lucienne/workspace && /home/lucienne/workspace/.venvs/ceo-dashboard/bin/python scripts/ceo_dashboard_build.py"
tags: [flysafair, dashboard, ceo, reporting]
runtime_profile: direct_python
---
**OVERRIDES runtime profile:** uses `direct_python` (plain Python, no model) because the command chain never invokes the `claude` CLI or any LLM API — pure-infra task; scheduler provider env injection is a no-op (MC-4942 U12 sweep).

Daily CEO dashboard build. Downloads all data files from Google Drive,
runs build_html_dashboard.py, uploads Dashboard.html back to Drive.

Runs weekdays at 8:30am SAST (6:30 UTC) — after all data feeds are fresh:
- SummaryRoute/Excel: synced from Dropbox via CloudHQ (~6:30am)
- ACSA monthly: checked at 7:00am
- Booking curve: pulled at 8:00am
- ACSA website: updated Tue 8:00am
- IATA fuel: updated Tue 8:10am  
- Fleet: updated Tue 8:15am

100% Python, zero AI cost. Downloads ~25MB of data, generates ~1.7MB HTML.
After build, sends a Telegram briefing with critical analysis of the data.

Source: All reporting data files on Google Drive
Target: Dashboard.html in Reporting Data folder (Google Drive)
Post-build: scripts/ceo_briefing.py sends Telegram briefing

Edit Schedule

Frequency

Result:

Runs (7d)

Completed

Failed

Timeout

100%

Success (7d)

1.9m

Avg Duration

flysafair dashboard ceo reporting

Run History (5)

Started	Finished	Status	Duration	Output	Log
1d ago	1d ago	completed	2.0m	final) \| Rev R681M (70% of PY) 📊 2026-07 forward: 189,762 pax (22% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 7 ... final) \| Rev R681M (70% of PY) 📊 2026-07 forward: 189,762 pax (22% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE-JNB (rev +118.8% YoY, 20,559 pax) ⚠️ LF dropping on CPT-DUR: -13.1pp YoY (now 81%, cap -2.6% YoY) ⚠️ Jet fuel up 3.3% WoW ($146/mt) ⛽ Jet fuel: $146/mt \| Crack: $47 💱 ZAR stronger (-1.0% in 30d) — R16.29/$ ✅ Brent down 6.3% WoW ($89/bbl) ✅ ACSA market share (2026-05): 65.1% (+1.4pp MoM) 📈 YTD (5m): Pax 4,308,739 (+1.2% vs PY) \| Rev R5.89B (+8.5% vs PY) _Dashboard: http://100.118.207.3:3001/apps/ceo-dashboard_ Telegram sent: True === CEO Dashboard Build — 2026-06-12 05:00 === Downloading data files... SummaryRoute.xlsx (7,227,751 bytes) SummaryExcel.xlsx (6,016,226 bytes) Data Fuel.xlsx (17,437 bytes) ACSA Monthly Data.xlsx (76,083 bytes) ACSA Website Data.xlsx (27,750 bytes) fleet_asana.json (49,744 bytes) 202606 Booking Curve.csv (booking curve) Downloading FlightAware capacity reports... Capacity_Scheduled_2026-06-01_to_2026-12-31.xlsx (138,845 bytes) Capacity_Actuals_2024-01-01_to_2026-06-08.xlsx (603,061 bytes) FA data ends 2026-06-08 (4 days old) Downloading Capacity schedule snapshots... Capacity_Scheduled_snapshot_2026-06-09.xlsx (138,843 bytes) Capacity_Scheduled_snapshot_2026-06-01.xlsx (155,743 bytes) Capacity_Scheduled_snapshot_2026-05-29.xlsx (155,797 bytes) Capacity_Scheduled_snapshot_2026-05-21.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-13.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-05.xlsx (156,128 bytes) Staging build script from PKA repo: /home/lucienne/workspace/PKA/Projects/ceo-dashboard/scripts/build_html_dashboard.py build_html_dashboard.py (326,289 bytes) Running build script (Linux branch, BASE auto-detected)... Loading SummaryRoute.xlsx... Loading SummaryExcel.xlsx... Data loaded. Processing... Loading forward bookings from Neon DB... Neon: 640,301 booking snapshot rows loaded (departures 2026-04-01 to 2026-07-31) Curve: 73 departure dates with real curves (flat-state filtered) Curve shape: 65 DBA points from 72 completed departures 2026-04: 126 points, latest gap=-4.4pp, 19/26 routes behind curve, PY final LF=90.9% 2026-05: 126 points, latest gap=-9.7pp, 23/25 routes behind curve, PY final LF=91.8% 2026-06: 126 points, latest gap=-7.2pp, 20/25 routes behind curve, PY final LF=86.3% 2026-07: 126 points, latest gap=-2.7pp, 16/25 routes behind curve, PY final LF=91.8% Loading economic indicators... EIA jet fuel: 649 weeks (2014-01-03 to 2026-06-05) FX data: 1394 days loaded (Frankfurter) FX gap-fill: +1 days from yfinance (through 2026-06-12) Fetching Brent crude oil prices... Oil data: 3128 days loaded Fuel trend: 649 weeks total (591 EIA [71 gap-fill] + 58 IATA from 2023-12-22) Loading ACSA data... Loading FlightAware capacity data... Actuals cutoff: 2026-06-08 (scheduled MTD cap for 2026-06) Schedule reliability: DB unavailable, prorating current month from xlsx Schedule reliability: prorated 2026-06 scheduled by 12/30 days Trimming 2 sparse months: ['2026-11', '2026-12'] Pre-computed route tables for 8 months, 4268 changes FlightAware: 34 months, 315 routes in latest month Loading fleet data from Asana... Fleet: 56 aircraft loaded from Asana Processing complete. Building HTML... WARNING: cash_data.json unavailable (no candidate found); Cash tab will show a placeholder. Dashboard written to: /home/lucienne/workspace/dashboard-build/dashboard/Dashboard.html File size: 3380 KB Data JSON written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_data.json (4816 KB) Summary MD written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_summary.md Dashboard.html generated (3,461,018 bytes) Updated Dashboard.html on Drive (ID: 15EeKvzeI2ZErZ6IFV2jHH7wBvA7cSf29) Copied to /home/lucienne/workspace/PKA/dashboards/ceo-dashboard.html Published to cloud: /home/lucienne/gdrive/PKA-Outputs/dashboards Success: CEO Dashboard built and uploaded	View log
2d ago	2d ago	completed	2.0m	2026-07 forward: 183,643 pax (22% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE-JNB (r ... 2026-07 forward: 183,643 pax (22% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE-JNB (rev +118.8% YoY, 20,557 pax) ⚠️ LF dropping on CPT-PLZ: -13.2pp YoY (now 81%, cap +27.5% YoY) ⚠️ Jet fuel up 3.3% WoW ($146/mt) ⛽ Jet fuel: $146/mt \| Crack: $47 💱 ZAR weaker (+0.5% in 30d) — R16.60/$ ✅ Brent down 3.4% WoW ($94/bbl) ✅ ACSA market share (2026-05): 65.1% (+1.4pp MoM) 📈 YTD (5m): Pax 4,301,241 (+1.2% vs PY) \| Rev R5.88B (+8.4% vs PY) _Dashboard: http://100.118.207.3:3001/apps/ceo-dashboard_ Telegram sent: True === CEO Dashboard Build — 2026-06-11 05:00 === Downloading data files... SummaryRoute.xlsx (7,243,470 bytes) SummaryExcel.xlsx (6,013,774 bytes) Data Fuel.xlsx (17,437 bytes) ACSA Monthly Data.xlsx (76,083 bytes) ACSA Website Data.xlsx (27,750 bytes) fleet_asana.json (49,744 bytes) 202606 Booking Curve.csv (booking curve) Downloading FlightAware capacity reports... Capacity_Scheduled_2026-06-01_to_2026-12-31.xlsx (138,845 bytes) Capacity_Actuals_2024-01-01_to_2026-06-08.xlsx (603,061 bytes) FA data ends 2026-06-08 (3 days old) Downloading Capacity schedule snapshots... Capacity_Scheduled_snapshot_2026-06-09.xlsx (138,843 bytes) Capacity_Scheduled_snapshot_2026-06-01.xlsx (155,743 bytes) Capacity_Scheduled_snapshot_2026-05-29.xlsx (155,797 bytes) Capacity_Scheduled_snapshot_2026-05-21.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-13.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-05.xlsx (156,128 bytes) Staging build script from PKA repo: /home/lucienne/workspace/PKA/Projects/ceo-dashboard/scripts/build_html_dashboard.py build_html_dashboard.py (325,614 bytes) Running build script (Linux branch, BASE auto-detected)... Loading SummaryRoute.xlsx... Loading SummaryExcel.xlsx... Data loaded. Processing... Loading forward bookings from Neon DB... Neon: 635,447 booking snapshot rows loaded (departures 2026-04-01 to 2026-07-31) Curve: 72 departure dates with real curves (flat-state filtered) Curve shape: 65 DBA points from 71 completed departures 2026-04: 125 points, latest gap=-4.6pp, 19/26 routes behind curve, PY final LF=90.8% 2026-05: 125 points, latest gap=-9.8pp, 23/25 routes behind curve, PY final LF=91.6% 2026-06: 125 points, latest gap=-7.2pp, 20/25 routes behind curve, PY final LF=86.1% 2026-07: 125 points, latest gap=-2.7pp, 16/25 routes behind curve, PY final LF=91.7% Loading economic indicators... EIA jet fuel: 649 weeks (2014-01-03 to 2026-06-05) FX data: 1393 days loaded (Frankfurter) Fetching Brent crude oil prices... Oil data: 3127 days loaded Fuel trend: 649 weeks total (591 EIA [71 gap-fill] + 58 IATA from 2023-12-22) Loading ACSA data... Loading FlightAware capacity data... Actuals cutoff: 2026-06-08 (scheduled MTD cap for 2026-06) Schedule reliability: DB unavailable, prorating current month from xlsx Schedule reliability: prorated 2026-06 scheduled by 11/30 days Trimming 2 sparse months: ['2026-11', '2026-12'] Pre-computed route tables for 8 months, 4268 changes FlightAware: 34 months, 315 routes in latest month Loading fleet data from Asana... Fleet: 56 aircraft loaded from Asana Processing complete. Building HTML... WARNING: cash_data.json unavailable ([Errno 2] No such file or directory: '/home/lucienne/workspace/dashboard-build/scripts/../data/cash_data.json'); Cash tab will show a placeholder. Dashboard written to: /home/lucienne/workspace/dashboard-build/dashboard/Dashboard.html File size: 3383 KB Data JSON written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_data.json (4820 KB) Summary MD written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_summary.md Dashboard.html generated (3,464,045 bytes) Updated Dashboard.html on Drive (ID: 15EeKvzeI2ZErZ6IFV2jHH7wBvA7cSf29) Copied to /home/lucienne/workspace/PKA/dashboards/ceo-dashboard.html Published to cloud: /home/lucienne/gdrive/PKA-Outputs/dashboards Success: CEO Dashboard built and uploaded	View log
3d ago	3d ago	completed	2.0m	f PY) 📊 2026-07 forward: 179,192 pax (21% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE ... f PY) 📊 2026-07 forward: 179,192 pax (21% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE-JNB (rev +118.8% YoY, 20,557 pax) ⚠️ LF dropping on CPT-PLZ: -13.2pp YoY (now 81%, cap +27.5% YoY) ⚠️ Jet fuel up 3.3% WoW ($146/mt) ⛽ Jet fuel: $146/mt \| Crack: $47 💱 ZAR weaker (+0.7% in 30d) — R16.55/$ ✅ Brent down 4.0% WoW ($92/bbl) ✅ ACSA market share (2026-05): 65.1% (+1.4pp MoM) 📈 YTD (5m): Pax 4,301,255 (+1.2% vs PY) \| Rev R5.88B (+8.5% vs PY) _Dashboard: http://100.118.207.3:3001/apps/ceo-dashboard_ Telegram sent: True === CEO Dashboard Build — 2026-06-10 05:00 === Downloading data files... SummaryRoute.xlsx (7,241,310 bytes) SummaryExcel.xlsx (5,976,555 bytes) Data Fuel.xlsx (17,437 bytes) ACSA Monthly Data.xlsx (76,083 bytes) ACSA Website Data.xlsx (27,750 bytes) fleet_asana.json (49,744 bytes) 202606 Booking Curve.csv (booking curve) Downloading FlightAware capacity reports... Capacity_Scheduled_2026-06-01_to_2026-12-31.xlsx (138,845 bytes) Capacity_Actuals_2024-01-01_to_2026-06-08.xlsx (603,061 bytes) FA data ends 2026-06-08 (2 days old) Downloading Capacity schedule snapshots... Capacity_Scheduled_snapshot_2026-06-09.xlsx (138,843 bytes) Capacity_Scheduled_snapshot_2026-06-01.xlsx (155,743 bytes) Capacity_Scheduled_snapshot_2026-05-29.xlsx (155,797 bytes) Capacity_Scheduled_snapshot_2026-05-21.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-13.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-05.xlsx (156,128 bytes) Staging build script from PKA repo: /home/lucienne/workspace/PKA/Projects/ceo-dashboard/scripts/build_html_dashboard.py build_html_dashboard.py (325,614 bytes) Running build script (Linux branch, BASE auto-detected)... Loading SummaryRoute.xlsx... Loading SummaryExcel.xlsx... Data loaded. Processing... Loading forward bookings from Neon DB... Neon: 630,524 booking snapshot rows loaded (departures 2026-04-01 to 2026-07-31) Curve: 71 departure dates with real curves (flat-state filtered) Curve shape: 65 DBA points from 70 completed departures 2026-04: 124 points, latest gap=-4.6pp, 19/26 routes behind curve, PY final LF=90.8% 2026-05: 124 points, latest gap=-9.8pp, 23/25 routes behind curve, PY final LF=91.6% 2026-06: 124 points, latest gap=-7.9pp, 20/25 routes behind curve, PY final LF=86.1% 2026-07: 124 points, latest gap=-2.7pp, 15/25 routes behind curve, PY final LF=91.7% Loading economic indicators... EIA jet fuel: 648 weeks (2014-01-03 to 2026-05-29) FX data: 1392 days loaded (Frankfurter) FX gap-fill: +1 days from yfinance (through 2026-06-10) Fetching Brent crude oil prices... Oil data: 3126 days loaded Fuel trend: 649 weeks total (591 EIA [71 gap-fill] + 58 IATA from 2023-12-22) Loading ACSA data... Loading FlightAware capacity data... Actuals cutoff: 2026-06-08 (scheduled MTD cap for 2026-06) Schedule reliability: DB unavailable, prorating current month from xlsx Schedule reliability: prorated 2026-06 scheduled by 10/30 days Trimming 2 sparse months: ['2026-11', '2026-12'] Pre-computed route tables for 8 months, 4268 changes FlightAware: 34 months, 315 routes in latest month Loading fleet data from Asana... Fleet: 56 aircraft loaded from Asana Processing complete. Building HTML... WARNING: cash_data.json unavailable ([Errno 2] No such file or directory: '/home/lucienne/workspace/dashboard-build/scripts/../data/cash_data.json'); Cash tab will show a placeholder. Dashboard written to: /home/lucienne/workspace/dashboard-build/dashboard/Dashboard.html File size: 3378 KB Data JSON written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_data.json (4813 KB) Summary MD written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_summary.md Dashboard.html generated (3,459,317 bytes) Updated Dashboard.html on Drive (ID: 15EeKvzeI2ZErZ6IFV2jHH7wBvA7cSf29) Copied to /home/lucienne/workspace/PKA/dashboards/ceo-dashboard.html Success: CEO Dashboard built and uploaded	View log
4d ago	4d ago	completed	1.8m	% YoY — quality growth 📊 2026-06 bookings: 439,285 pax (52% of PY final) \| Rev R649M (67% of PY) 📊 2026-07 forward: 173, ... % YoY — quality growth 📊 2026-06 bookings: 439,285 pax (52% of PY final) \| Rev R649M (67% of PY) 📊 2026-07 forward: 173,492 pax (20% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE-JNB (rev +118.8% YoY, 20,557 pax) ⚠️ LF dropping on CPT-PLZ: -13.2pp YoY (now 81%, cap +27.5% YoY) ⚠️ Jet fuel up 3.3% WoW ($146/mt) ⛽ Jet fuel: $146/mt \| Crack: $47 💱 ZAR weaker (+0.3% in 30d) — R16.46/$ ✅ ACSA market share (2026-05): 65.1% (+1.4pp MoM) 📈 YTD (5m): Pax 4,301,267 (+1.2% vs PY) \| Rev R5.88B (+8.5% vs PY) _Dashboard: http://100.118.207.3:3001/apps/ceo-dashboard_ Telegram sent: True === CEO Dashboard Build — 2026-06-09 05:00 === Downloading data files... SummaryRoute.xlsx (7,240,713 bytes) SummaryExcel.xlsx (5,976,555 bytes) Data Fuel.xlsx (17,496 bytes) ACSA Monthly Data.xlsx (76,083 bytes) ACSA Website Data.xlsx (27,750 bytes) fleet_asana.json (49,744 bytes) 202606 Booking Curve.csv (booking curve) Downloading FlightAware capacity reports... Capacity_Scheduled_2026-06-01_to_2026-12-31.xlsx (138,843 bytes) Capacity_Actuals_2024-01-01_to_2026-06-07.xlsx (602,962 bytes) FA data ends 2026-06-07 (2 days old) Downloading Capacity schedule snapshots... Capacity_Scheduled_snapshot_2026-06-09.xlsx (138,843 bytes) Capacity_Scheduled_snapshot_2026-06-01.xlsx (155,743 bytes) Capacity_Scheduled_snapshot_2026-05-29.xlsx (155,797 bytes) Capacity_Scheduled_snapshot_2026-05-21.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-13.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-05.xlsx (156,128 bytes) Staging build script from PKA repo: /home/lucienne/workspace/PKA/Projects/ceo-dashboard/scripts/build_html_dashboard.py build_html_dashboard.py (325,515 bytes) Running build script (Linux branch, BASE auto-detected)... Loading SummaryRoute.xlsx... Loading SummaryExcel.xlsx... Data loaded. Processing... Loading forward bookings from Neon DB... Neon: 625,601 booking snapshot rows loaded (departures 2026-04-01 to 2026-07-31) Curve: 70 departure dates with real curves (flat-state filtered) Curve shape: 65 DBA points from 69 completed departures 2026-04: 123 points, latest gap=-4.6pp, 19/26 routes behind curve, PY final LF=90.8% 2026-05: 123 points, latest gap=-9.8pp, 23/25 routes behind curve, PY final LF=91.6% 2026-06: 123 points, latest gap=-8.6pp, 20/25 routes behind curve, PY final LF=86.1% 2026-07: 123 points, latest gap=-2.7pp, 15/25 routes behind curve, PY final LF=91.7% Loading economic indicators... EIA jet fuel: 648 weeks (2014-01-03 to 2026-05-29) FX data: 1391 days loaded (Frankfurter) Fetching Brent crude oil prices... Oil data: 3125 days loaded Fuel trend: 649 weeks total (591 EIA [71 gap-fill] + 58 IATA from 2023-12-22) Loading ACSA data... Loading FlightAware capacity data... Actuals cutoff: 2026-06-07 (scheduled MTD cap for 2026-06) Schedule reliability: DB unavailable, prorating current month from xlsx Schedule reliability: prorated 2026-06 scheduled by 9/30 days Trimming 2 sparse months: ['2026-11', '2026-12'] Pre-computed route tables for 8 months, 4268 changes FlightAware: 34 months, 315 routes in latest month Loading fleet data from Asana... Fleet: 56 aircraft loaded from Asana Processing complete. Building HTML... WARNING: cash_data.json unavailable ([Errno 2] No such file or directory: '/home/lucienne/workspace/dashboard-build/scripts/../data/cash_data.json'); Cash tab will show a placeholder. Dashboard written to: /home/lucienne/workspace/dashboard-build/dashboard/Dashboard.html File size: 3373 KB Data JSON written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_data.json (4804 KB) Summary MD written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_summary.md Dashboard.html generated (3,453,629 bytes) Updated Dashboard.html on Drive (ID: 15EeKvzeI2ZErZ6IFV2jHH7wBvA7cSf29) Copied to /home/lucienne/workspace/PKA/dashboards/ceo-dashboard.html Success: CEO Dashboard built and uploaded	View log
5d ago	5d ago	completed	1.7m	nd not absorbing capacity growth ✅ Revenue/flight up +24.8% YoY — quality growth 📊 2026-06 bookings: 428,032 pax (51% of ... nd not absorbing capacity growth ✅ Revenue/flight up +24.8% YoY — quality growth 📊 2026-06 bookings: 428,032 pax (51% of PY final) \| Rev R634M (65% of PY) 📊 2026-07 forward: 170,292 pax (20% of PY final) ✅ Best yield: CPT-HLA (+51.0% YoY, LF 75%) 🚀 Fastest growing: HRE-JNB (rev +118.8% YoY, 20,557 pax) ⚠️ LF dropping on CPT-PLZ: -13.2pp YoY (now 81%, cap +27.5% YoY) ✅ Jet fuel down 11.4% WoW ($142/mt) ⛽ Jet fuel: $142/mt \| Crack: $41 💱 ZAR stronger (-0.9% in 30d) — R16.27/$ ✅ ACSA market share (2026-04): 63.7% (+0.5pp MoM) 📈 YTD (5m): Pax 4,301,263 (+1.2% vs PY) \| Rev R5.88B (+8.5% vs PY) _Dashboard: http://100.118.207.3:3001/apps/ceo-dashboard_ Telegram sent: True === CEO Dashboard Build — 2026-06-08 05:00 === Downloading data files... SummaryRoute.xlsx (7,239,722 bytes) SummaryExcel.xlsx (5,974,292 bytes) Data Fuel.xlsx (17,478 bytes) ACSA Monthly Data.xlsx (76,043 bytes) ACSA Website Data.xlsx (27,750 bytes) fleet_asana.json (49,744 bytes) 202606 Booking Curve.csv (booking curve) Downloading FlightAware capacity reports... Capacity_Scheduled_2026-06-01_to_2026-12-31.xlsx (138,831 bytes) Capacity_Actuals_2024-01-01_to_2026-06-03.xlsx (581,941 bytes) FA data ends 2026-06-03 (5 days old) Downloading Capacity schedule snapshots... Capacity_Scheduled_snapshot_2026-06-01.xlsx (155,743 bytes) Capacity_Scheduled_snapshot_2026-05-29.xlsx (155,797 bytes) Capacity_Scheduled_snapshot_2026-05-21.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-13.xlsx (156,384 bytes) Capacity_Scheduled_snapshot_2026-05-05.xlsx (156,128 bytes) Staging build script from PKA repo: /home/lucienne/workspace/PKA/Projects/ceo-dashboard/scripts/build_html_dashboard.py build_html_dashboard.py (325,515 bytes) Running build script (Linux branch, BASE auto-detected)... Loading SummaryRoute.xlsx... Loading SummaryExcel.xlsx... Data loaded. Processing... Loading forward bookings from Neon DB... Neon: 620,678 booking snapshot rows loaded (departures 2026-04-01 to 2026-07-31) Curve: 69 departure dates with real curves (flat-state filtered) Curve shape: 65 DBA points from 68 completed departures 2026-04: 122 points, latest gap=-4.6pp, 19/26 routes behind curve, PY final LF=90.8% 2026-05: 122 points, latest gap=-9.8pp, 23/25 routes behind curve, PY final LF=91.6% 2026-06: 122 points, latest gap=-8.1pp, 20/25 routes behind curve, PY final LF=86.1% 2026-07: 122 points, latest gap=-2.6pp, 14/25 routes behind curve, PY final LF=91.7% Loading economic indicators... EIA jet fuel: 648 weeks (2014-01-03 to 2026-05-29) FX data: 1390 days loaded (Frankfurter) Fetching Brent crude oil prices... Oil data: 3125 days loaded Fuel trend: 648 weeks total (591 EIA [71 gap-fill] + 57 IATA from 2023-12-22) Loading ACSA data... Loading FlightAware capacity data... Actuals cutoff: 2026-06-03 (scheduled MTD cap for 2026-06) Schedule reliability: DB unavailable, prorating current month from xlsx Schedule reliability: prorated 2026-06 scheduled by 8/30 days Trimming 2 sparse months: ['2026-11', '2026-12'] Pre-computed route tables for 8 months, 4231 changes FlightAware: 34 months, 307 routes in latest month Loading fleet data from Asana... Fleet: 56 aircraft loaded from Asana Processing complete. Building HTML... WARNING: cash_data.json unavailable ([Errno 2] No such file or directory: '/home/lucienne/workspace/dashboard-build/scripts/../data/cash_data.json'); Cash tab will show a placeholder. Dashboard written to: /home/lucienne/workspace/dashboard-build/dashboard/Dashboard.html File size: 3349 KB Data JSON written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_data.json (4767 KB) Summary MD written to: /home/lucienne/workspace/dashboard-build/dashboard/dashboard_summary.md Dashboard.html generated (3,429,117 bytes) Updated Dashboard.html on Drive (ID: 15EeKvzeI2ZErZ6IFV2jHH7wBvA7cSf29) Copied to /home/lucienne/workspace/PKA/dashboards/ceo-dashboard.html Success: CEO Dashboard built and uploaded	View log

Comments (0)

No comments yet — add instructions for Luci

←