Demo kit: Maintenance backlog analysis from an SAP PM export
============================================================

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/enr-maint-backlog-009/

CONTENTS
  - FICTIONAL_IW38_Order_Export_28.09.2026.xlsx (156 rows, formatted as an Excel table)

SETUP (demo tenant only, never a customer or production tenant)
  1. Upload the workbook to OneDrive in the demo tenant and open it in Excel for the web.
  2. Select a cell in the table and open Copilot.

PRESENTER ANSWER KEY (what the seeded data should surface)
  - 6 exact duplicate rows; 31 TECO or CLSD orders; 119 open orders, 2745 estimated hours.
  - 112 open orders are overdue (Basic Start before 28.09.2026), of which 29 are priority 1: 40012003, 40012014, 40012018, 40012022, 40012036, 40012037, 40012041, 40012044, 40012053, 40012055, 40012060, 40012061, 40012064, 40012069, 40012077, 40012078, 40012084, 40012106, 40012114, 40012115, 40012116, 40012121, 40012123, 40012124, 40012131, 40012144, 40012145, 40012148, 40012149.
  - TRAP: dates are text. Reading 05.03.2026 as 3 May instead of 5 March gives wrong ages and a wrong overdue count.
  - Pivot (open orders / hours): E01 P1 14/288, E01 P2 13/290, E01 P3 10/251, E01 P4 7/183, I01 P1 6/127, I01 P2 11/325, I01 P3 11/239, I01 P4 12/253, M01 P1 11/306, M01 P2 6/129, M01 P3 8/124, M01 P4 10/230.
