DDL Knowledge Architecture

Excel knowledge,
governed and
graphed.

A registry of 75 Excel patterns, formulas, and architectures — typed, tiered, and connected by governed edges. Not a glossary. Not a tutorial. A knowledge graph you can traverse.

Enter the Graph → View Radial Map
75Entries
178Edges
7Types
4Tiers
75
Governed entries
across 7 types
FRM · PTN · ARC · ANT · CON · PQ · KEY
178
Typed edges
connecting entries
LEADS_TO · DEPENDS_ON · PAIRS_WITH
574
Validation checks
passed at v0.1.1
Zero failures · Schema locked
9/9
Council unanimous
on schema lock
Zero REJECT · Zero REVISE
What It Is

Three layers.
One architecture.

01 — THE REGISTRY
Governed Schema
Every entry has 17 fields: type, tier, intent, example, edges, failure modes, governance notes. Locked by 9-model council review. Zero REJECT. Zero REVISE.
v0.1.1 LOCKED
02 — THE GRAPH
Typed Edges
130 governed edges connect every entry via LEADS_TO, DEPENDS_ON, and PAIRS_WITH relationships. Click any node. Trace any path. The graph is the cathedral.
LIVE EXPLORER
03 — THE STANDARDS
Institutional Rules
STD-EXCEL-001 and STD-EXCEL-002 define analytical and operational workbook architecture. Every entry that references a standard links directly to the governing rule.
2 STANDARDS
Entry Types

Seven types.
One prefix each.

FRM
FRM
Formula
17
PTN
PTN
Pattern
10
ARC
ARC
Architecture
6
ANT
ANT
Anti-Pattern
6
CON
CON
Convention
6
PQ
PQ
Power Query
6
KEY
KEY
Shortcut
4
Skill Tiers

Four tiers.
One governed path.

B
Beginner
14 entries
I
Intermediate
21 entries
A
Advanced
16 entries
E
Expert
4 entries
“The graph is the cathedral. Everything else is scaffolding.”
ROWAN BENNETT · SEAT 1005 · COUNCIL REVIEW CR-EXCEL-001
Tools, Standards & Paths

The applied layer.

Tools · PTN-0007
CF Pattern Library
10 conditional formatting patterns with visual previews, governed formulas, scope guidance, and copy-ready syntax.
↗
Graph Explorer
Explore the Full Graph
Force-directed layout with Explore and Path Finder modes. Trace any learning path from Beginner to Expert through governed edges.
↗
STD-EXCEL-001
Analytical Workbook Standard
9 rules covering star schema layout, fact table design, MAKEARRAY matrices, dashboard standards, and naming conventions.
↗
STD-EXCEL-002
Operational Workbook Standard
8 rules covering INPUT→LOGIC→OUTPUT architecture, status lifecycle, exception logs, and control parameters.
↗
Learning Paths · Path 01
Your First Hour
Five foundational entries, zero prerequisites. The floor everything else stands on.
↗
Learning Paths · Path 02
The Star Schema Path
Grain to MAKEARRAY. The DDL methodology in five governed steps. How the Assurance Map was built.
↗
Excelligence

The graph gets smarter
every time you lay stone.

75 entries. 178 edges. Four tiers from first shortcut to institutional-grade architecture. Built by one CPA with a governed methodology and too much Excel experience.

Enter the Graph →