GUARDIAN DEMO - LL CONSOLIDATION + VENDOR-FUNDING TOP-UP
=========================================================
Portfolio demo with synthetic data: buyer codes CG-01..CG-12, vendors, SKUs and
prices are fictional. Excel desktop on Windows, no add-ins.

WHAT IT SHOWS
  Stream A (monthly)     12-15 buyers return LL files, often several revisions each.
                         One click replays every file from the frozen LL, applies clear
                         changes, flags unclear or invalid ones and writes a clean LL.
  Stage 2 (buyers)       Buyer packs (one file per PIC, locked columns, dropdowns,
                         hidden IDs and baseline), a reply dashboard and Outlook drafts.
  Stream B (2x per week) New deals stacked on top of LL_Master give the top-up per unit,
                         the vendor-funded share (Vendor 100% / Co-share / Claimback) and
                         the file for the Data team (in the live process this step
                         ran in KNIME; the demo rebuilds it in Excel).

SETUP (once, about 3 minutes)
  1. Unzip to a LOCAL folder (not a synced OneDrive/SharePoint path).
  2. Open Guardian_Run.xlsx. Press Alt+F11, then File > Import File, and import the
     4 .bas files in Code/.
  3. File > Save As > Excel Macro-Enabled Workbook (Guardian_Run.xlsm), same folder.
     Close the file, reopen it and click Enable Content.
  4. Press Alt+F8, run SetupButtons. The buttons appear on the Control sheet.

RUN
  Health check        -> PASS
  1 Scan + export LL  -> Results/LL_Final_... ; LL/LL_Master.xlsx updated
                         Compare with Results/Expected_Final_Check.xlsx
                         (16 field changes, 1 new row, 1 duplicate, 1 warning)
  Exceptions          -> copy Buyer_Updates/_Optional_Exception_Test/*.xlsx into
                         Buyer_Updates and scan again. CG-08 is held back (6 issues),
                         everyone else is still published. Set the file to IGNORE in
                         Submissions column G when you are done.
  Reset demo          -> clears the run log so every file is scanned again
                         (use it before re-recording; files on disk are kept)
  Refresh dashboard / Draft emails (drafts are only displayed, never sent)
  Calculate top-up    -> TopUp/TopUp_20251211_... (63 lines)
                         Compare with TopUp/Expected_TopUp_20251211.xlsx

FOLDERS
  LL/             LL_Baseline (frozen) and LL_Master (current)
  Buyer_Updates/  returned buyer files, named PIC + date received; arrival order =
                  last-modified time, then file name
  Outgoing/       buyer packs sent at the start of the cycle
  Results/        LL outputs, a sample final and the expected check
  History/        archived buyer files and LL_Master backups
  TopUp/          top-up outputs and the expected result
  Code/           VBA modules (modGuardian, modPacks, modTopUp, modSetup)
