requirements-traceability-register
Installation
SKILL.md
Requirements Management & Traceability Register
Build a spreadsheet that carries requirements from scoping (registers) through execution (tickets/phases) to validation (acceptance/testing), with a live master view and an executive dashboard. Targets Google Sheets and Excel.
Operating Principle
Silo data entry by phase; aggregate automatically for reporting. Each phase register (P1/P2/P3) is a hand-edited sheet on one shared 21-column schema. Every downstream view — All Requirements, Traceability, Acceptance Matrix, Dashboard — reads from those registers via formulas and is never hand-edited. This keeps entry fast and readable while reporting stays consistent and scalable. Dropdowns come from one Lists tab so metrics never break on typos.
Quick Navigation
| Your goal | Do this |
|---|---|
| Generate the whole workbook now | Run the scaffolder (below), then open the .xlsx or import the CSVs |
| Know the exact columns for any sheet | Read references/schema.md |
| Get the aggregation / dashboard formulas | Read references/formulas.md |
| Adapt lists, phases, or roles | Edit LISTS / --phases in the scaffolder, or the Lists tab |
| Understand the four zones | See "Workbook Map" below |