Building a Zero-VBA Excel & Single-File Offline HTML Studio for Milestone Trend Analysis (MTA)

ianquinn_dev — Wed, 11 Nov 2026 17:39:23 +0000

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)

👉 Live Interactive Demo (GitHub Pages): https://yang233l.github.io/slipline/

(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

1. 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.

2. 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: https://slipline.gumroad.com/l/suite

(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!

DEV Community: ianquinn_dev