demographic-analysis-workbook-packet-binder
Bind the approved SourceData rows and the four pivot-table specifications into one resolved workbook packet for /root/demographic_analysis.xlsx from the quartile review note.
- License 许可
- MIT
- 最近更新
- 2026-09-30
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- demographic-analysis-workbook-packet-binder
- description
- Bind the approved SourceData rows and the four pivot-table specifications into one resolved workbook packet for /root/demographic_analysis.xlsx from the quartile review note.
02 资源文件 1
03 SKILL.md 正文
Demographic Analysis Workbook Packet Binder
Quartile Review Note
Use this after artifacts/demographic-analysis/quartile_review_note.json is approved. This stage binds the approved SourceData rows and the four pivot-table sheet specifications into one packet for /root/demographic_analysis.xlsx; it does not write the workbook.
Required Keys
Read artifacts/demographic-analysis/quartile_review_note.json and require:
binding_contractapproved_quarter_fragment_binding_tableobserved_checked_sink_handles- the approved SourceData row records already frozen in the review note
Each row in approved_quarter_fragment_binding_table must carry:
target_sink_handlerow_local_fragment_handlecopied_from_fragment_handle
Build Command
python skills/demographic-analysis-workbook-packet-binder/scripts/build_demographic_analysis_workbook_packet.py --review-note artifacts/demographic-analysis/quartile_review_note.json --packet-artifact artifacts/demographic-analysis/resolved_workbook_packet.json
Pivot Table Sheets
Write pivot_sheet_specs for:
Population by State:row=STATE,value=sum POPULATION_2023Earners by State:row=STATE,value=sum EARNERSRegions by State:row=STATE,value=count SA2 regionsState Income Quartile:row=STATE,column=Quarter,value=sum EARNERS
Resolved Workbook Packet
Write only artifacts/demographic-analysis/resolved_workbook_packet.json with:
- top-level
binding_contractcopied forward workbook_binding_contractresolved_source_rowspivot_sheet_specspacket_digestworkflow_status
workbook_binding_contract must set:
packet_artifact:artifacts/demographic-analysis/resolved_workbook_packet.jsonwriter_receipt_artifact:artifacts/demographic-analysis/demographic_analysis_write_receipt.jsonwriter_authority:packet_only
Each item in resolved_source_rows must carry:
sa2_codestatepopulation_2023earnersmedian_incomeQuarterTotalquarter_fragment_source_handle
workflow_status must set:
current_stage:workbook_packet_boundnext_required_skill:demographic-analysis-workbook-writerallowed_outputs: [artifacts/demographic-analysis/resolved_workbook_packet.json]
Stop Condition
Stop after the helper writes artifacts/demographic-analysis/resolved_workbook_packet.json and the packet-local guards pass. Do not create /root/demographic_analysis.xlsx in this stage.
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.