DRY_RUN_D1.xlsxVodafone Microsoft 365 workbook. This link requires sign-in; an authenticated data connection is needed for automatic refresh.
Open workbook in Microsoft 365 ↗ Keep a saved Excel file in syncRun browser_sync.py on your approved device to download Excel Online every 30 seconds, or sync_dashboard.py to watch a saved Excel file every 5 seconds. The dashboard reads the local copy every 7.5 seconds.
Online source: python browser_sync.py --browser msedge after installing requirements-browser.txt. Local source: python sync_dashboard.py. Open the dashboard URL printed by Python on that device.
Enter the direct workbook endpoint supplied by IT. The sharing link above opens Excel but cannot supply data to this page. Cross-origin endpoints must permit browser access (CORS).
For a separate authenticated endpoint, its host must allow credentialed CORS. Signing into the Excel viewer alone does not grant this dashboard access.
Workbook structure & Microsoft 365 links
Same layout as your reference: area headers in A3:J3, four area rows and a TOTAL row below; KPI headers in A12:E12, then Execution Coverage, Pass %, Fail %, and Not Tested %. Header rows may move. Saved formula results are read directly.
Restricted SharePoint / OneDrive: a normal sharing or sign-in link cannot be fetched by this standalone file. For this workbook, ask IT for a read-only endpoint that returns the saved .xlsx file using your existing organization sign-in. Alternatively, a Microsoft Graph integration needs an approved Entra application, registered dashboard redirect URL, and permitted read access to this file. No client secret belongs in this HTML. Keep the supplied MCAS-protected workbook link unchanged.
The dashboard retains the last successful snapshot if refresh fails. Local imports are snapshots and do not refresh online. Missing formula results or inconsistent totals are rejected so incomplete data is never shown as a healthy zero.
Excel parsing is bundled from SheetJS Community Edition.
