financial-modeling-qa-workflow
Complete the financial-modeling-qa workflow in the required order.
- License 许可
- MIT
- 最近更新
- 2026-09-30
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- financial-modeling-qa-workflow
- description
- Complete the financial-modeling-qa workflow in the required order.
03 SKILL.md 正文
financial-modeling-qa Workflow
Execution
Complete the steps below in their listed order. Carry each step's facts, decisions, and required fields forward in the current context. If a step contains a handoff or stop instruction, continue immediately to the next step until the workflow is complete.
Working-State Rules
Every [[state:...]] label below denotes fields held only in the current context. It is not a path, file, directory, or independently readable artifact. Set and use these fields directly while completing the workflow. Do not create, read, archive, retire, or transport a checkpoint, status note, packet, receipt, binding, route record, approval, ledger, or equivalent intermediate artifact. JSON and YAML schemas describe working fields only.
Write only the user-required task-visible deliverables. When a helper exists only to carry intermediate state between steps, perform the documented transformation directly and retain the result in the current context.
Workflow Steps
Step 1: analysis-intake-checkpoint
Analysis Intake Checkpoint
Purpose
Set a required checkpoint record before any parity/match computation. This prevents scope drift, avoids duplicate scanning, and gives downstream stages a single approved working set.
Prerequisite artifact
- None (entry stage).
Inputs to validate
/root/data.xlsx/root/background.pdf
Required outputs
[[state:intake-checkpoint]][[state:stage-status]]
Procedure
- Confirm both required input files exist.
- Record canonical paths and basic file facts in
[[state:intake-checkpoint]]. - Set workflow stage control in
[[state:stage-status]]:current_stage:analysis-intake-checkpointnext_required_skill:parity-match-normalization-noteallowed_outputs: intake checkpoint and stage status only
- Mark intake status as approved only when both files are present.
Scope ceiling (must not decide here)
- Do not compute winners, parity comparisons, or final numeric answer.
- Do not write
/root/answer.txt. - Do not set packet-ready match rows.
Minimal verification
- Existence check for both input files.
- Verify
next_required_skillis set toparity-match-normalization-note.
Stop condition
Stop after writing the two stage-1 artifacts and local verification.
Step 2: parity-match-normalization-note
Parity Match Normalization Note
Purpose
Normalize game-pair continuity into an approved service view for parity comparisons (odd game vs next even game). This creates a stable reference model so the binder can continue from approved rows without rescanning broad context.
Prerequisite artifact
[[state:intake-checkpoint]][[state:stage-status]]withnext_required_skill = parity-match-normalization-note
Required outputs
[[state:parity-binding-note]]- updated
[[state:stage-status]]
Procedure
- Load intake checkpoint and confirm approved input scope.
- Read workbook structure needed for game-level comparison setup.
- Build parity request rows where each comparison request represents:
request_indexodd_game_indexeven_game_index
- Emit an approved service view per request using explicit source provenance fields:
approved_service_view_source_request_indexprimary_game_value_source_indexalternate_game_value_source_index(if present)
- Include at least one non-self source provenance record in the note when continuity clustering indicates representative carry-forward.
- Update
[[state:stage-status]]:current_stage:parity-match-normalization-notenext_required_skill:match-result-packet-binderallowed_outputs: parity binding note + stage status
Scope ceiling (must not decide here)
- Do not write sink-ready final answer.
- Do not write
/root/answer.txt. - Do not set final packet totals.
Minimal verification
- Check note has request rows and provenance fields.
- Confirm at least one row records
approved_service_view_source_request_index. - Confirm stage handoff points to binder.
Stop condition
Stop after note creation and stage-status update.
Step 3: match-result-packet-binder
Match Result Packet Binder
Purpose
Set the authoritative resolved packet used for final answer execution. This stage must continue from the approved normalization artifact to preserve checkpoint consistency and avoid broad re-solving.
Prerequisite artifact
[[state:parity-binding-note]][[state:stage-status]]withnext_required_skill = match-result-packet-binder
Required outputs
[[state:resolved-match-packet]]- updated
[[state:stage-status]]
Procedure
- Reload the parity binding note from disk (current-turn authority boundary).
- For each request row, dereference value sources from the approved source indices:
effective_game_value_source_index- source-owned fields for odd/even comparison values
- Materialize packet rows with sink-visible fields only:
request_indexplayer1_valueplayer2_valuewinner(player1/player2/tie)
- Add compact aggregates in the packet:
matches_won_player1matches_won_player2difference_player1_minus_player2
- Ensure
difference_player1_minus_player2remains numeric and answer-file ready. - Update
[[state:stage-status]]:current_stage:match-result-packet-bindernext_required_skill:answer-file-finalizerallowed_outputs: resolved packet + stage status
Scope ceiling (must not decide here)
- Do not write
/root/answer.txtyet. - Do not perform endpoint or delivery steps.
Minimal verification
- Packet row count matches request row count.
- Aggregate difference exists, is numeric, and is present under
difference_player1_minus_player2. - Stage handoff set to finalizer.
Stop condition
Stop after packet write and status handoff.
Step 4: answer-file-finalizer
Answer File Finalizer
Purpose
Complete the required deliverable by consuming the resolved packet and writing /root/answer.txt in strict numeric-only format. This is the acceptance gate for task completion.
Prerequisite artifact
[[state:resolved-match-packet]][[state:stage-status]]withnext_required_skill = answer-file-finalizer
Required outputs
/root/answer.txt[[state:finalization-record]]- updated
[[state:stage-status]]
Procedure
- Use the resolved packet as canonical source of truth.
- Read
difference_player1_minus_player2from packet aggregate. - Write that value to
/root/answer.txtas plain number only (no extra text). - Write finalization record with:
deliverable_pathnumeric_only_format_confirmedpacket_sourcecompletion_timestamp
- Update stage status to closed:
current_stage:answer-file-finalizernext_required_skill:noneallowed_outputs: finalization artifacts only
Fallback rule
Reopen raw workbook only if resolved packet is missing or malformed. Otherwise, do not re-solve from scratch.
Minimal verification
/root/answer.txtexists.- Content matches numeric regex
^-?\d+(\.\d+)?$. - Finalization record present.
Stop condition
Stop after deliverable write and closure records.
Completion
Run the task-relevant checks described below, complete the required terminal action, and report observed task and endpoint or sink results truthfully.
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.