Multi Project RAG Tracker Excel Programme Dashboard Gantt Chart Portfolio Status Report Project Health Board PMO Template

Run your entire programme from a single browser tab. No software to install. No subscription. No internet required.

This is a professional-grade programme management dashboard delivered as a single HTML file. Double-click it, and it opens. Everything — all the logic, all the charts, all the data — is self-contained. Your data never leaves your device.

Built for programme managers, PMO leads, and project delivery consultants who are tired of juggling spreadsheets.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ WHAT YOU GET
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

① ComplianceSprints_Dashboard_WebApp.html
The full web application. One file. Open in Chrome, Edge, Firefox, or Safari. Works on Windows, macOS, and Linux. No installation. No login. Nothing to configure.

② ComplianceSprints_Dashboard_WebApp_UserGuide.docx
A comprehensive professional user guide (v2.0) covering every feature, all settings, formulas, troubleshooting, and a full quick-reference appendix.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ THE DASHBOARD
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

7 Clickable KPI Cards — each card drills straight into a filtered project view:
▸ Active Projects · On Track % · At Risk · Critical · Complete · Total Budget · Budget Variance
Trend arrows (↑/↓) show change vs your previous session.

Project Status Summary — every active project in one table, 15 columns wide:
RAG · Auto RAG · Mismatch alert · Next milestone · Top risk · Budget variance · Progress bar

RAG Distribution — portfolio breakdown with overspend per RAG band
Upcoming Milestones — sorted by due date, overdue flagged in red
Budget Overview — plan vs actual with programme totals row
Top Risks — sorted Red → Amber → Green automatically
12-Month Gantt Timeline — bars coloured by RAG, current month highlighted gold
Completed Projects Archive — permanent record, click any row for full project report card

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ PROJECT REPORT CARDS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Click any project row anywhere in the app. A full report card slides in from the right.

▸ SVG progress ring — % complete as a donut chart, coloured by health
▸ 5 live KPI tiles — progress, budget variance, days remaining, tasks complete, open risks
▸ Project timeline bar — start to end, % complete filled, today marked in gold
▸ Budget bars — Plan vs Actual with variance £, variance %, and remaining budget
▸ All linked tasks and risks in one place
▸ 🖨 Print/PDF — one-click print-ready view, Save as PDF in any browser

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ POWERPOINT EXPORT
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Click 📊 PPT in the header. A full 7-slide widescreen presentation downloads instantly — no options required.

▸ Cover slide with metadata grid and RAG distribution bar
▸ Executive KPI Summary — 7 colour-coded cards
▸ Project Status Summary table — full data, colour-coded RAG
▸ RAG Distribution chart + Budget Overview split slide
▸ Milestones & Top Risks split slide — both tables, full colour coding
▸ Full Gantt Timeline — built with shapes, RAG-coloured bars
▸ Closing slide with contact details

Every slide uses your configured accent colour, organisation name, and dashboard title.
Ideal for steering groups, board packs, and stakeholder briefings.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ PDF REPORT GENERATOR
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

10 selectable sections — KPI Summary, Project Status, RAG Distribution (visual chart),
Milestones, Budget Overview, Top Risks, Gantt Timeline (visual chart), Tasks, Risk Register, Archive
Paper: A4 / A3 / Letter · Orientation: Landscape / Portrait
Branded header and footer on every page · Prepared By field · Timestamped filename
PDF library fully embedded — no third-party service, no internet required

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ EXCEL EXPORT
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 Excel button in the header — downloads a formatted .xlsx workbook instantly
4 sheets: Project Register · Tasks & Milestones · Risk Register · KPI Summary
Frozen headers · correct column widths · numeric values for Excel sorting

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ CUSTOMISE EVERYTHING
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

24 configurable settings across six sections. Make it yours — or make it your client's.

Brand & identity
▸ Dashboard title — change the banner from the default to your programme name
▸ Organisation name — replaces ComplianceSprints everywhere: footer, PDF, PPT, and filenames
▸ Accent colour — colour picker changes every highlight across the app, PDF, and PPT in real time
▸ Currency — British Pound £, US Dollar $, or Euro € throughout
▸ Date format — DD-MMM-YY (UK), MM/DD/YYYY (US), or YYYY-MM-DD (ISO)
▸ PDF cover text — print a classification or reference on the PDF report cover

Project data
▸ Programme list — define your own workstreams as a dropdown in the project modal
▸ Project status values — replace the defaults with your own (Discovery, Build, UAT, Live etc.)
▸ Three custom project fields — label them anything: Client, Budget Code, Department, Region
▸ Delivery methodology — Waterfall / Agile / Scrum / PRINCE2 / Hybrid / SAFe / Kanban

Dashboard
▸ Show/hide any of the 8 panels — remove ones you don't need, preview changes instantly
▸ Max milestones and risks shown — 3 to 20 per panel
▸ RAG threshold presets — Tight (5%/15%), Standard (10%/25%), or Relaxed (15%/35%)
▸ Fiscal year start month — aligns the Gantt to any month

Portfolios & access
▸ Portfolio management — define named portfolios, assign projects, filter the entire app
▸ Password protection — basic access control for shared drives

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ MORE FEATURES
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔍 Global Search — searches all projects, tasks, and risks simultaneously
🌙 Dark Mode — full dark scheme, persists between sessions
📈 KPI Trends — session-to-session trend arrows, 30-day history
📊 Presentation Mode — one click hides all edit controls for clean stakeholder views
📁 Tasks: Priority field (High/Med/Low) · 8-metric summary tiles · overdue detection
⚠ Risk Register: Likelihood × Impact heatmap built in

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ DATA & STORAGE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

All data stored locally in your browser. Nothing sent anywhere.
▸ JSON Export/Import — one-click backup and restore
▸ CSV Export — per tab, Excel-compatible
▸ Auto-saves after every operation

Sample data included: 14 projects · 45 tasks · 8 risks · 5 programmes · ready to explore immediately

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ TECHNICAL
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Single HTML file · 1.3 MB · zero external dependencies · all libraries fully embedded
Chrome 88+ · Edge 88+ · Firefox 85+ · Safari 14+ · Windows · macOS · Linux

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ WHO THIS IS FOR
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Built for professionals managing multiple projects who need a fast, credible view of programme health — without enterprise software.

▸ Programme managers and PMO leads who present to steering groups and boards
▸ Consultants who want to brand the tool with their own organisation name and colours for client deliveries
▸ Project managers switching from Excel who want proper RAG reporting and budget tracking in one place
▸ PMO teams who need a tool the whole team can use without a software licence
▸ Anyone managing compliance, regulatory, or transformation programmes where RAG is standard

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ INSTANT DOWNLOAD
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Delivered immediately after purchase. Download the ZIP, unzip it, and open the HTML file. Up and running in under 60 seconds.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
◈ LICENCE
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Licensed for personal or internal business use by the original purchaser.
Not for redistribution, resale, or use as the basis for a competing product.

Questions before buying? Message the shop — happy to help.