In construction and enterprise PMO Steering Committees, two constraints constantly collide:
Standard Gantt charts hide chronic drift: When a milestone slips 3–5 days every review cycle, baselines often get overwritten ("watermelon reports" — green on the outside, red on the inside).
Strict corporate IT lock-down: .xlsm macros are blocked by Mark-of-the-Web (MOTW), and uploading sensitive schedule spreadsheets to third-party cloud SaaS tools is prohibited.
To solve both problems simultaneously, I built SlipLine — a dual-core offline schedule analytics suite combining a 100% Zero-VBA .xlsx workbook with a single-file, zero-dependency offline HTML studio.
🟢 Try the Live Browser Sandbox (No Download Required)
👉 Launch Interactive Demo (GitHub Pages)(Pre-loaded with Construction & IT/PMO sample datasets — scrub the T00→T12 timeline, spotlight trajectories, and toggle the Client-facing display view right in your browser.)
How the Dual-Core Architecture Works
- The Excel Core (.xlsx, 100% Zero-VBA) Instead of fragile VBA macros or structured table references that break across desktop Excel versions, the workbook uses a Horizon-Wide Entry layout:
You record forecast dates across review periods (T00..T12) on a single row per milestone.
Classic desktop-compatible formulas (INDEX/COUNTA, NETWORKDAYS) automatically extract the latest forecast, compute consecutive slip streaks, separate Original Baseline vs. Approved EOT Baseline, and mirror the matrix into a 45° Milestone Trend Analysis (MTA) XY scatter chart.
- The Single-File Offline Studio (.html, CSP default-src 'none') For interactive Steering Committee presentations, the companion SlipLine_Studio.html runs 100% locally in any modern browser with zero network requests:
Zero-Dependency Local .xlsx Parsing: Uses the browser's native DecompressionStream('deflate-raw') API to unzip and parse local .xlsx and .csv files directly in memory without external JS libraries.
Time-Lapse Playback (T00 → T12): Watch milestone trajectories climb away from the 45° reference line (slipping) or flatten out (stabilizing) across review periods.
Internal vs. Client-Facing View Toggle: Switch display layers for internal review vs. client printouts, and print a clean single-page PDF brief.
📦 Grab the Free Starter or Full Suite
If you'd like to use it on your own projects, there is a Free 8-Milestone Starter Workbook ($0 Lite .xlsx) alongside the full Pro Dual-Core Suite on Gumroad:
👉 Download SlipLine on Gumroad
(Note: The public GitHub Pages sandbox is sample-data-only; local .xlsx/.csv import, CSV export, and What-If mitigation sliders are included in the full offline Studio file. Client view is a display-layer toggle rather than file-level encryption.)
Happy to answer any questions about generating desktop-safe OOXML charts with openpyxl or parsing .xlsx archives with native Web Streams!
