evo-nasa-budget-recovery
Analyzes NASA budget workbook mathematical structure to recover missing ??? values via constraint propagation across sheets (row sums, YoY percentages, directorate shares, growth analysis).
SKILL.mdtasks-evolved/xlsx-recover-data/environment/skills/evo-nasa-budget-recovery/SKILL.md
GitHubevo-nasa-budget-recovery
Recovers missing ??? values in multi-sheet NASA budget Excel files.
Relationships Detected
- Row sums: Budget sheet Total col = sum of directorate cols
- YoY %: (current - previous) / previous * 100, rounded to 2 decimals
- Shares %: directorate_val / total * 100, rounded to 2 decimals
- Growth Analysis: CAGR, 5-year change, average annual budget
- Cross-sheet: Budget values recoverable from YoY + previous year
Usage
import sys
sys.path.insert(0, '/app/environment/skills/evo-nasa-budget-recovery/scripts')
from utils import run_recovery_pipeline
wb = run_recovery_pipeline('input.xlsx', 'output.xlsx')
Key Functions
run_recovery_pipeline(input_path, output_path)- Full pipelinesolve_row_with_one_unknown(ws, row, data_cols, total_col)- Row sum solverrecover_yoy_value(budget_ws, yoy_ws, row, col)- YoY % calculatorrecover_share_value(budget_ws, shares_ws, row, col)- Share % calculatorrecover_growth_analysis(wb)- Growth sheet recoveryrecover_budget_from_yoy(budget_ws, yoy_ws, row, col)- Cross-sheet recovery