xlsx-recover-data-fsl-k3-combined
Combine frozen predecessor FSL workflow roles while preserving their local order.
- License 许可
- MIT
- 最近更新
- 2026-09-30
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- xlsx-recover-data-fsl-k3-combined
- description
- Combine frozen predecessor FSL workflow roles while preserving their local order.
03 SKILL.md 正文
Combined File-Status Workflow Stage
Execute the following component roles in their original order. Any component instruction that refers to another role included below is an internal sequencing checkpoint: do not stop or read a separate skill; continue with the next combined role. Do not perform final native-file retirement in this combined stage.
Combined role: nasa-budget-recover-workbook-intake
NASA Budget Recover Workbook Intake
This is the safest first step when the task is to recover missing values in nasa_budget_incomplete.xlsx and eventually save nasa_budget_recovered.xlsx. This stage does not fill any cells. It freezes the workbook layout, placeholder coordinates, and cross-sheet recovery routes into artifacts/nasa_budget_recovery_basis.json.
Use nasa-budget-recover-workbook-intake
Use this skill when:
- the workbook still contains
??? - the recovery work depends on exact sheet names, cell coordinates, and cross-sheet links
- later stages should work from a stable recovery basis instead of rescanning the workbook from scratch
nasa_budget_incomplete.xlsx Input Workbook
Required input:
nasa_budget_incomplete.xlsx
Expected recovery sheets:
Budget by DirectorateYoY Changes (%)Directorate Shares (%)Growth Analysis
artifacts/nasa_budget_recovery_basis.json Recovery Basis
Write artifacts/nasa_budget_recovery_basis.json with these exact top-level keys:
source_workbook_pathsheet_namesmissing_cell_indexsheet_relationshipssource_workbook_review
Populate them as follows:
source_workbook_path: exact stable pathnasa_budget_incomplete.xlsxsheet_names: workbook sheet titles in workbook ordermissing_cell_index: one ordered entry per???, preserving exact sheet name and cell coordinatesheet_relationships: one or more relationship entries withrelationship_type,source_sheet,target_sheet, andanchor_cellssource_workbook_review: a review entry anchored tonasa_budget_incomplete.xlsxwithsource_workbook_path,covered_sheets,placeholder_count,review_scope, andreview_status
Each missing_cell_index entry should capture enough local context to recover the number later without redoing the full scan. Include:
sheet_namecellrow_numbercolumn_letterrow_labelcolumn_labelplaceholder_valuedependency_familysupport_cells
Keep the entry order deterministic:
- workbook sheet order first
- row number second
- column number third
NASA Budget Sheet Relationships
Capture concrete recovery routes that are visible in the workbook:
Budget by Directorateuses directorate values across each fiscal-year row plus theTotalcolumnYoY Changes (%)compares a current fiscal-year directorate value to the prior fiscal year inBudget by DirectorateDirectorate Shares (%)compares a same-year directorate value to the same-year total inBudget by DirectorateGrowth Analysisuses start and end budget cells for change, average, and CAGR checks, and may also carry forward decisive budget cells directly
Use task-shaped dependency labels inside dependency_family, such as:
budget_row_totalyoy_from_budgetshare_of_totalgrowth_changegrowth_averagegrowth_cagrdirect_budget_echo
Workbook Intake Procedure
- Open
nasa_budget_incomplete.xlsxwith a workbook-preserving library such asopenpyxl. - Read every sheet title and preserve the titles exactly as they appear.
- Scan every used cell for the literal placeholder
???. - For each placeholder, record the exact coordinate and the nearest row and column labels that identify the fiscal year and directorate or growth metric.
- Capture nearby support coordinates that explain the recovery route later, such as same-row totals, prior-year cells, same-year totals, or start and end growth anchors.
- Build
sheet_relationshipsfrom workbook-visible structure only. This stage is discovery and checkpointing, not numeric recovery. - Create
artifacts/if needed and writeartifacts/nasa_budget_recovery_basis.json. - Stop after the recovery basis is written.
Workbook Intake Constraints
- Stop at the recovery basis instead of writing
nasa_budget_recovered.xlsx. - Do not replace any
???in this stage. - Record the workbook review against the stable path
nasa_budget_incomplete.xlsx. - Preserve sheet titles and placeholder coordinates exactly as seen in the workbook.
- Keep
source_workbook_reviewdescriptive only; later stages decide resolved values and any source workbook status change. - Keep the artifact deterministic so the next stage can consume the exact keys without another broad workbook inventory.
Recovery Basis Validation
Before finishing, confirm:
artifacts/nasa_budget_recovery_basis.jsonexists- all required top-level keys are present
missing_cell_indexis not empty- every
missing_cell_indexentry points to a real sheet listed insheet_names - the expected recovery sheets appear in
sheet_names
Intake Trace Markers
After writing the artifact, emit or report these exact markers:
recovery_basis=artifacts/nasa_budget_recovery_basis.jsonsource_workbook=nasa_budget_incomplete.xlsx
Combined role: nasa-budget-recover-missing-values
Recover Missing Values in nasa_budget_incomplete.xlsx
Use this skill after artifacts/nasa_budget_recovery_basis.json exists. Read the frozen placeholder list and sheet relationships, solve every ??? as a numeric value using workbook-visible math, and publish artifacts/nasa_budget_status_normalization.json before any recovered workbook is written.
Read artifacts/nasa_budget_recovery_basis.json
Require these exact input keys from artifacts/nasa_budget_recovery_basis.json:
source_workbook_pathsheet_namesmissing_cell_indexsheet_relationshipssource_workbook_review
Rules:
- Treat
source_workbook_pathas authoritative and keep it tied tonasa_budget_incomplete.xlsx. - Use
missing_cell_indexas the target list for recovery work. Do not invent new target cells or broaden the task beyond the recorded???coordinates. - Use
sheet_relationshipsas the frozen map of howBudget by Directorate,YoY Changes (%),Directorate Shares (%), andGrowth Analysisdepend on each other. - Do not use external NASA sources. Recover values only from workbook-visible math and the intake artifact.
- If the intake artifact is missing required keys or the workbook path no longer opens, stop and repair the intake checkpoint instead of writing a substitute status file.
Solve Budget by Directorate, YoY Changes (%), Directorate Shares (%), and Growth Analysis
Open nasa_budget_incomplete.xlsx in read mode and compute values from workbook-visible relationships only. Keep all recovered values numeric. Preserve whole-number budgets and totals as integers. Preserve percentage-style outputs, including YoY, shares, and CAGR, at two decimals unless the sheet label clearly indicates a one-decimal average.
Use these recovery rules in dependency order:
Budget by Directorate
- For a missing row total, use
Total = SUM(component budgets in the same fiscal-year row). - For a single missing directorate value in a row with a known total, use
Missing = Total - SUM(other known directorates in that row).
YoY Changes (%)
- Match each YoY cell to the same directorate and adjacent fiscal years in
Budget by Directorate. - Use
YoY = round((current - previous) / previous * 100, 2). - If a missing budget value depends on a known YoY rate, rearrange the same relationship to recover the budget value before continuing.
Directorate Shares (%)
- Match each share cell to the same fiscal year and directorate in
Budget by Directorate. - Use
Share = round(budget_value / row_total * 100, 2). - If a missing budget or total depends on a known share, solve it from the same row and keep the row-total arithmetic consistent.
Growth Analysis
- Use the row or column labels in the sheet to determine which metric is required for each placeholder.
- For carried budget cells, copy the same fiscal-year and directorate value from
Budget by Directorate. - For change metrics, use
Change = end_value - start_value. - For average budget metrics, average the budget values indicated by the sheet labels.
- For CAGR metrics, use
CAGR = round(((end_value / start_value) ** (1 / years) - 1) * 100, 2).
Recommended solve order:
- Clear row-total and single-gap budget rows first.
- Recalculate missing YoY cells from resolved budget values.
- Use confirmed YoY or share relationships to recover any remaining budget cells.
- Finish
Growth Analysisonly after the required budget values are stable. - Recheck all previously solved percentages after the dependent budget values are final.
Write artifacts/nasa_budget_status_normalization.json with resolved cell values and a superseded status
Write exactly these top-level keys:
source_workbook_pathresolved_cell_valuescross_sheet_checkssource_workbook_statusstatus_rationale
Use this structure:
{
"source_workbook_path": "nasa_budget_incomplete.xlsx",
"resolved_cell_values": [
{
"sheet_name": "Budget by Directorate",
"cell": "F8",
"numeric_value": 4639,
"recovery_method": "row_total",
"supporting_cells": ["B8", "C8", "D8", "E8", "G8", "H8", "I8", "J8", "K8"]
}
],
"cross_sheet_checks": [
{
"check_name": "budget_row_total_consistency",
"status": "passed",
"details": "Recovered row totals and component sums agree."
}
],
"source_workbook_status": "superseded",
"status_rationale": "The resolved cell values and cross-sheet checks are now captured in artifacts/nasa_budget_status_normalization.json, so nasa_budget_incomplete.xlsx remains the reviewed source workbook but is superseded as the active recovery working source for recovered workbook packaging."
}
Requirements for the top-level keys:
source_workbook_path: copy the exact path from the intake artifact.resolved_cell_values: include one entry for every recorded???cell, ordered by the dependency order used to solve them. Each entry should includesheet_name,cell,numeric_value,recovery_method, andsupporting_cells.cross_sheet_checks: include the decisive validations that justify the recovered values. Each entry should includecheck_name,status, anddetails.source_workbook_status: set this exact string tosuperseded.status_rationale: explain thatnasa_budget_incomplete.xlsxis still the reviewed source workbook, but the status file is now the active recovery record to avoid dual-source ambiguity while the recovered workbook is packaged.
Validate the recovered numbers before handoff
Before writing the status file, confirm all of the following:
- Every entry in
resolved_cell_valuesis numeric, not???, not a formatted string, and not a formula string. - Each missing
Budget by Directoratetotal or component still satisfies its row arithmetic after recovery. - Each recovered
YoY Changes (%)cell recomputes from the matching budget years within normal workbook rounding. - Each recovered
Directorate Shares (%)cell recomputes from the matching budget value and total within normal workbook rounding. - Each recovered
Growth Analysisvalue matches the budget-sheet values or growth math indicated by the sheet labels. cross_sheet_checksincludes at least these check names when those relationship families are used:budget_row_total_consistency,yoy_recalculation_consistency,share_recalculation_consistency, andgrowth_analysis_consistency.- The number of
resolved_cell_valuesentries matches the number of placeholders recorded inmissing_cell_index. - This stage does not write
nasa_budget_recovered.xlsxand does not modify or deletenasa_budget_incomplete.xlsx.
Report artifacts/nasa_budget_status_normalization.json
When the file is written, surface concise trace evidence with these exact markers:
status_note=artifacts/nasa_budget_status_normalization.jsonsource_workbook_status=supersededstatus_target=nasa_budget_incomplete.xlsx
Hand off only the written artifacts/nasa_budget_status_normalization.json and its exact top-level keys to the workbook packet stage.
Count-Study Continuation
After this stage's local outputs are complete, read the nasa-budget-recover-workbook-packet skill before continuing. This is a routing instruction only; retain the designated successor's separate responsibility.
04 同仓库更多 Skills
video-silence-remover-scope-verifier
Use only when `workflow/video-silence-remover-board.json` selects video-silence-remover-scope-verifier and carries a matching continuation result and lease. Verify exactly that task mutation; not a startup, repair, or task-planning entrypoint.
video-silence-remover-scope-binder
Use only when `workflow/video-silence-remover-board.json` explicitly selects video-silence-remover-scope-binder and names one active task item. Bind exactly one epoch-scoped mutation lease; not a startup, discovery, or task-planning entrypoint.
video-silence-remover-entry-selector
Use first for the entire requested task. Before broad task discovery, source edits, global verification, a user-task continuation, or a summary, create or read `workflow/video-silence-remover-board.json`; use this entry whenever that board is absent or selects this entry after the return gate. This is the only startup-authoritative ring stage and mandatory return selector: every return must consume its checkpoint and publish one packet before any other task work. Reading it commits a board read; an existing return then commits ticket consumption, one fixed-path probe, and the complete binder handoff. The persistent board forbids cleanup and final response.
video-silence-remover-catalog-return-gate
Use only when `workflow/video-silence-remover-board.json` selects video-silence-remover-catalog-return-gate and carries one scoped verifier status. Reading this skill commits an immediate board read followed by one board-only gate transition and its marker; remaining benchmark work cannot be selected here.
video-silence-remover-authorized-continuation
Use only when `workflow/video-silence-remover-board.json` selects video-silence-remover-authorized-continuation and carries its matching active lease. Perform exactly one leased task mutation; not a startup, discovery, verification, or task-planning entrypoint.
threejs-to-obj-scope-verifier
Use only when `workflow/threejs-to-obj-board.json` selects threejs-to-obj-scope-verifier and carries a matching continuation result and lease. Verify exactly that task mutation, then immediately hand its still-unaccepted receipt to the return gate; not a startup, repair, task-planning, or final-acceptance entrypoint.