| name | dark-intelligence-workflow |
| description | Extract calculation methodology from legacy Excel/files into clean, client-free dark intelligence archive — the canonical path for porting legacy calculations to public repos while avoiding legal/IP issues.
|
| type | reference |
| version | 1.0.0 |
| category | data |
| related_skills | ["research-literature","calculation-report"] |
| tags | ["excel","legacy-extraction","engineering-calculations","ip-compliance","methodology-archive"] |
| triggers | ["dark intelligence","extract from excel","port legacy calculation","archive calculation","extract methodology"] |
Dark Intelligence Workflow
Overview
Use this skill when porting engineering calculations from legacy Excel spreadsheets
(or other legacy formats) into clean, client-free implementations in the 4 public
repos. The workflow extracts only generic methodology — equations, input/output
schemas, worked examples — and strips all client/project identifiers before archival.
Sub-Skills
Ecosystem Audit & Promotion Planning
Use this workflow when you need to assess the full dark intelligence landscape
across the ecosystem and plan promotion work into GitHub issues.
3-Parallel-Subagent Audit Pattern
Run 3 subagents simultaneously to cover the full surface:
-
Excel Inventory Subagent — scan for:
- Actual .xlsx/.xls files on disk and in repo
- Dark intelligence extraction outputs (knowledge/dark-intelligence/)
- Excel-processing scripts (scripts/data/doc_intelligence/)
- Catalog/index entries referencing Excel (data/document-index/, docs/CONTENT_INDEX.md)
- Planning docs (.planning/algorithm-extraction.md, heavy-batch-prompts.md)
-
Conversion Infrastructure Subagent — map:
- Skills: dark-intelligence-workflow, xlsx-to-python, doc-extraction, doc-intelligence-promotion
- Pipeline scripts: parsers, formula_to_python, chain builder, pattern detector, module assembler
- POC outputs: xlsx-poc/ (v1 formula extraction), xlsx-poc-v2/ (pattern + code gen)
- digitalmodel Excel utilities (legacy/ scripts, excel_utilities.py modules)
- Schema & validation (config/schemas/dark-intelligence-archive.yaml)
-
Domain Coverage Subagent — assess:
- Module registries (solver registry, design code registry, skill graph index)
- Standards transfer ledger (data/document-index/standards-transfer-ledger.yaml)
- Domain file counts in digitalmodel/src/digitalmodel/ (30 domains, 1,362 files)
- Function counts and standards-mapped vs unmapped (docs/vision/CALCULATIONS-VISION.md)
- Test coverage baselines (config/testing/coverage-baseline.yaml)
Gap Matrix Output
Cross-reference the 3 subagent outputs into a promotion map:
