dark-intelligence-workflow

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

• Inputs
• Step 1 — Identify (+4)
• Step 6 — Implement (+1)
• Integration Points
• AC Checklist

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:

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

2. 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)

3. 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: