Dashboard for DX
Project Management · PMBOK-grounded · Local-only

Five files in. The truth of where your project stands, out.

A single-file dashboard for managers and executives. Drop in master, WBS, defects, test counts, code lines — the dashboard joins them on Function ID and surfaces the truth: what's late, what's failing, who's where, what's at risk. Every byte stays on your machine.

Drop a file. Watch the raptor run.

Every upload runs a 7-step validation. The dashboard shows you the steps as cacti the raptor jumps. On all-clear, it reaches the goal. On the first hard error, it slams into the bad cactus and a hurt stegosaurus pops up to explain what failed. No spinner. No silent failure. No log-diving.

W
WBS · wbs.xlsm 投入日時 2026-04-28 14:32
1
file integrity
2
sheet / structure
3
encoding
4
required columns
5
Function ID extraction
6
numeric sanity
7
dataframe build
Dashboard for DX TREX
RUNNING Validating — step 1 / 7 elapsed 0.0s
💥 Hurt stegosaurus — step 4 failed: required columns

Column 機能ID not found in sheet メイン. Expected at column E or label "機能ID:XXXX" within E–I. Show detailed log entry →

The TREX is the system's brand logo; the hurt stegosaurus shown on error belongs to the same pixel-art set.

Three things on screen before you scroll.

When the dashboard finishes loading, three cards greet the manager: the worst-risk function, the people on it, and the delivery pulse. Everything else is one click away.

Alert · Function ID HIGH

AUTH001 · 認証ログイン基盤

Risk score 0.84 · 終了予定 5 days overdue · 障害発生率 above threshold

Drilldown · SYM1010 JP / EN

👥 田中 (開発) · 鈴木 (テスト仕様書)

Role progress: dev 100% / test 30% — bottleneck on test execution

Delivery · DORA 5Keys · 30d GOOD

リードタイム — 6 days median

Variation tightening; CFR 12% (band: Good)

Move your cursor. The console explains itself.

This is the current dashboard in miniature. Move the mouse across it — the nearest widget lights up and the panel on the right explains what it does, newest capabilities included. Nothing here is a real project; every figure is illustrative.

Dashboard for DX — 機能ID: all in scope Inputs · Charts · Calendar · 🚨 Alerts · 🏁 Delivery EN / 日本語
KPIs
128ktotal LoC
34open defects
71%run rate
93%pass rate
0.24bug density
68health
3at risk
2delayed
Inputs
ExcelRedminemaster.xlsxBacklogCSV
✓ 7-step validated · 47 機能ID joined
3 strike-through rows excluded · preflight logged
ChartsNEW
機能ID別(集計)テスト仕様書別
並び順 ▾ 注目度順
🚨 Alerts
0.84HIGH
AUTH001 · 認証ログイン基盤
X 障害発生率 0.18
遅延日数 5d
PeopleNEW
⚠ 障害0件⚠ テスト未実施
🏁 Delivery
リードタイム6dCFR12%
復旧14h信頼性0.41
History
CalendarNEW
週 日 < 今日 >
イベントテスト祝日非稼働WBS
日 🎌
キックオフ週間対応中
結合テスト完了
非稼働・田中
WBS 計画
WBS 実績
TODONEW
要件レビュー準備
キックオフ週間
結合テスト実施テスト
E2E 疎通確認テスト
設計レビュー
System 🔒 Local-only · no telemetry ⚙ settings persist per-user 📄 PDF: cover → TOC → signature

Miniature of the current build. Function IDs and figures are illustrative, not a real project.

Whatever you already use, we accept. Whatever you don't have, we ship.

Excel, Redmine, JIRA, Airtable, Backlog, GitHub Issues, ServiceNow, plain CSV — the dashboard reads them all. Each slot is an import endpoint matched to the standard format of a major tool (Redmine / Backlog, etc.); LV3 supplies an adapter for any other format. If your team isn't already producing one of the seven artifacts, LV3 ships a starter template you can hand off to your PM. Zero new tools to adopt. Zero new formats to learn.

① Function ID master

The scope spine

Anything not on the master isn't tracked. Keep it wherever you already maintain your function/feature catalogue.

Excel Airtable Notion Google Sheets CSV + LV3 template
② WBS

Schedule + assignees + sub-tasks

The richest artifact: planned/actual periods, effort, sub-task rows with role keywords driving 担当者×ロール analytics.

Excel Smartsheet MS Project export Asana export + LV3 template
③ Defect list

What's broken, when, by whom

Filtered to the defect-class tracker (e.g., 不具合管理 in Redmine). Encoding auto-detected (UTF-8 / CP932 / ASCII).

Redmine JIRA GitHub Issues Linear Backlog ServiceNow + LV3 template
④ Test counts

Planned vs executed, OK vs NG

Per Function ID: 総テスト, 実施済, OK, NG. Drives test-density alerts and quality scoring.

TestRail Excel Zephyr (Jira) CSV + LV3 template
⑤ Code metrics

How big is the implementation

Lines of code per Function ID. Trend across snapshots feeds the LoC-trend chart and the LoC × NG scatter.

SonarQube Excel cloc output Coverity CSV + LV3 template
⑥ Design pages

How big is the design

Page count per Function ID. Filled in directly in the dashboard — no upload needed. Auto-saves to design_pages.json.

In-app form No tool needed
⑦ Calendar & roster

Working days & events

行事 (global events) and 個人非稼働日 (per-assignee non-working days) layers for the Gantt and the calendar.

Google Calendar Outlook Excel iCal / .ics + LV3 template
⑧ Anything else

Custom tool? We adapt.

If your team uses a tool we haven't listed — internal in-house issue tracker, custom REST API, exotic export format — LV3 writes the import adapter. Same Function ID, same dashboard.

REST API SQL view Custom CSV + LV3 adapter

Eight live charts. One Gantt. One calendar. All from your files.

No new authoring environment. The dashboard renders interactive charts and a navigable calendar from the seven artifacts you already produce. Sample data shown below — fully synthetic, but matches the real shape: AUTH001 (User Login) / AUTH002 (User Registration) / SEARCH01 / CART001 / NOTIFY01 / ORD001. Every chart is one click away from an A3-landscape PDF (auto-grown page height).

Progress · planned vs actual 🦕 trike
AUTH001
78%
AUTH002
62%
SEARCH01
88%
CART001
42%
NOTIFY01
55%
ORD001
35%
Test coverage 🦖 raptor
AUTH001
AUTH002
AUTH003
CART001
CART002
SEARCH01
OK NG not run
Defect trend (weekly) 🦕 stego
opened closed cumulative open
Risk dimensions 🦖 ptero
障害率
遅延
テスト密度
未実施率
AUTH001
0.93
0.20
0.55
0.30
AUTH002
0.18
0.05
0.30
0.62
CART001
0.50
0.85
0.25
0.78
SEARCH01
0.22
0.30
0.10
0.20
NOTIFY01
0.55
0.62
0.30
0.25
ORD001
0.78
0.91
0.55
0.82
Schedule · Gantt (planned ▢ / actual ▣) 🦕 bronto
AUTH001
AUTH002
AUTH003
SEARCH01
CART001
CART002
NOTIFY01
ORD001
planned actual (on track) actual (late) today
Calendar · week view 🦕 plesio
Mon 14AUTH001
Tue 15AUTH002#4821
Wed 16SEARCH01#4847
Thu 17CART001
Fri 18NOTIFY01ORD001
Sat 19行事 (saved holiday)
Sun 20
WBS planned WBS actual defects

Sample data shown — fully synthetic, fictional Function IDs. Real-world data shape is identical.

Click any Function ID. The whole story opens beneath.

Schedule, assignees, role progress, sub-tasks, tests, code, defects, scores, trend across snapshots. One view. PDF-exportable.

FUNCTION ID · AUTH001

認証ログイン基盤 (auth-login)

主要ストリーム: 開発 田中 → テスト仕様書 鈴木 → テスト実施 渡辺. ⏰ 終了予定まで 5 days overdue (5/15 → 5/20 →…).

LoC 4,820 Tests 142 / 198 Defects 8 open Design pages 14 Risk 0.84 / HIGH

Schedule (WBS)

Planned start
2026-04-15
Planned end
2026-05-15
Actual start
2026-04-18
Actual end
(5 days overdue)
Planned effort
120 d
Actual effort
137 d

Role progress mini-bars

開発
100%
テスト仕様書作成
80%
テスト実施
30%

⚠ Bottleneck: dev done, test execution barely started.

Defects (Redmine, open)

#4821 — login fails on unicode email · 田中 · 04-22
#4847 — session timeout 30s shorter than spec · 渡辺 · 04-25
+6 more

Industry-banded delivery metrics. Calculated from your own files.

Lead time, change-failure rate, mean-time-to-recovery, reliability — colour-coded against the DORA 2024 industry bands (Good / Normal / Bad). Hover any card for the metric definition, source column, and exact thresholds.

リードタイム
6days median
Good · Lead time ≤ 7d
変更失敗率 (CFR)
12%
Good · ≤ 30%
障害復旧時間
14hours median
Good · < 24h
信頼性
0.41faults / feature
Bad · > 0.30

One risk score. Four breachable metrics.

Every Function ID gets a single score on a 0–1 scale. The score combines defect rate, schedule delay, test density, and test-execution rate — weighted by impact. Crossing a threshold tier raises an alert tile.

score = Σ(n × w) ÷ Σ(w)
AUTH001
認証ログイン基盤
0.84
HIGH
X障害発生率 0.18 (threshold 0.10) — main culprit
遅延日数 5 d (threshold 14)
テスト密度 0.7 (threshold 1.0)
SYM1010
同期処理ライブラリ
0.46
MEDIUM
Xテスト未実施率 72% (threshold 60%) — main culprit
ADM01010
管理者バックオフィス
0.22
LOW
X遅延日数 28 d (threshold 14) — main culprit

Seven of ten knowledge areas covered. Two partial. One out of scope.

Dashboard for DX is not a project-management toy. It maps directly onto PMBOK's ten knowledge areas — most fully, two partially, one explicitly out of scope. Deliberate trade-offs, all documented.

7 / 10

Fully covered — Integration, Scope, Schedule, Quality, Resource, Communications, Risk. Partial — Cost (effort tracked but not direct cost), Stakeholder (drilldown for managers + DORA for execs, no formal stakeholder map). Out of scope — Procurement (your contracts and POs live in your finance system).

Integration 統合マネジメント

Five artifacts joined on one Function ID key. Integration is what we are.

→ Inputs tab · Function ID join
Scope スコープマネジメント

Function ID master is the scope spine. Anything not on the master sheet isn't tracked. Scope creep becomes visible immediately.

→ 機能ID master · sheet 機能一覧
Schedule スケジュールマネジメント

WBS planned vs actual, Gantt, calendar layers, today marker, auto-flag overruns and delays.

→ Calendar tab · WBS cols Q–T
Cost コストマネジメント

Effort tracked (planned vs actual person-days) — the labour-cost component. Direct cost layer is up to your finance system.

→ WBS col P / U · effort only
Quality 品質マネジメント

Tests planned vs executed, pass/fail rate, density per Function ID, threshold-breach alerts.

→ test_counts · 仕様書別テスト集計
Resource 資源マネジメント

Assignees from WBS, role × person analytics, role-progress mini-bars, bottleneck surfaces, roster.

→ Charts tab · 担当者×ロール
Communications コミュニケーションマネジメント

A3-landscape PDFs, drilldown PDFs, per-section reports — every view one click from a regulator-grade share.

→ PDF chrome · CJK font embedded
Risk リスクマネジメント

0 – 1 risk score, weighted formula, severity tiers (HIGH / MEDIUM / LOW). Alert tiles surface what to fix first.

→ 🚨 Alerts tab · DORA 5Keys
Procurement 調達マネジメント

Out of scope. Contracts, POs, and vendor management live in your finance / ERP system. We don't try to replicate that.

→ deliberately not implemented
Stakeholder ステークホルダーマネジメント

Managers get the drilldown. Execs get DORA 5Keys. Not a formal stakeholder map — but the right view per audience.

→ 🏁 Delivery tab · drilldown panel

Every byte of data stays on the machine running the app.

Your project artifacts are sensitive — defect logs, internal staffing, schedule reality. They don't belong in a SaaS dashboard. Dashboard for DX is a single self-contained app with no outbound network calls. Deploy it on the machine of your choice; that's the only place your data ever touches.

🔒

No SaaS. No cloud. No telemetry. No phoning home.

A single self-contained desktop app — your files, settings, and logs all stay on the same machine. The Charts tab can write A3-landscape PDF reports for sharing, but only when you ask.

Deploy it on your laptop in five minutes.

LV3 handles installation, source-card configuration, alert thresholds, and team rollout. Your artifacts, our dashboard, no SaaS in between.