Demo kit: Holding portfolio review from subsidiary reports
==========================================================

FICTIONAL DEMO DATA. Not a real document. Any resemblance to real organisations or people is coincidental.

Scenario: https://hmarofiq.github.io/copilot-scenarios-asean/scenarios/gov-portfolio-004/

CONTENTS
  - FICTIONAL_KPI_Targets_FY2026.xlsx
  - Portfolio Reports/ (20 subsidiary folders, Excel and PowerPoint mix)
  - ANSWER_KEY_portfolio.xlsx (presenter only)

SETUP (demo tenant only, never a customer or production tenant)
  1. Create a SharePoint site called Portfolio Reports in the demo tenant.
  2. Upload the 20 folders and the target sheet.
  3. Run the Cowork prompt from the scenario.

PRESENTER ANSWER KEY (what the seeded data should surface)
  - Readable subsidiaries: 6 Red, 6 Amber, 6 Green.
  - Could-not-read list must contain SUB-07 (not uploaded) and SUB-19 (image only).
  - SUB-11 reports in IDR millions and SUB-15 in USD millions. If either shows as a huge outlier or a tiny Red, units were not normalised.
  - KPI labels vary: Pendapatan, Net Sales, Total Revenue all mean revenue; FTE and Jumlah Pegawai mean headcount.
