excel-deliverableslisted

# Excel deliverables The brief requires it: *"Your report should include tables and/or figures developed using MS Excel to visualize data and support your arguments."* Rubric item 8 marks the use of visuals. This is not optional decoration. ## Build the workbook py .claude/skills/excel-deliverables/scripts/build_workbook.py Writes `02-Analysis/DXB-Calculations.xlsx` with seven sheets: | Sheet | Contents | |---|---| | `1-Data` | The provided series — the only hard-typed numbers in the file | | `2-Passengers` | Six forecasting methods, full error columns, CFE/MAD/MSE/MAPE/TS, accuracy comparison, 2026 forecast, two charts | | `3-Movements` | The same for flight movements | | `4-Associative` | Passengers regressed on movements; SLOPE/INTERCEPT/RSQ/STEYX; scatter with fitted line; expected traffic at 500k/550k/600k | | `5-Long-Term` | Projections to 2036 on three fitting bases, with a comparison chart | | `6-Weighted-Factor` | Location decision template with SUMPRODUCT scoring | | `7-Capacity-Gap` | Forecast demand against the 115m design capacity, with gap and utilisation columns | Options: `--capacity`, `--long-to`, `--at`, `-o`. **Open it in Excel and press F9 before using anything from it.** openpyxl writes formulas but does not evaluate them; the cached values are empty until Excel calculates. A screenshot taken before recalculation will show zeros or blanks. ## Why live formulas, not pasted values 1. The brief says the visuals must be *developed using Excel*. A