demographic-analysis-workbook-writer
Create /root/demographic_analysis.xlsx from artifacts/demographic-analysis/resolved_workbook_packet.json and emit artifacts/demographic-analysis/demographic_analysis_write_receipt.json.
- License 许可
- MIT
- 最近更新
- 2026-09-30
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- demographic-analysis-workbook-writer
- description
- Create /root/demographic_analysis.xlsx from artifacts/demographic-analysis/resolved_workbook_packet.json and emit artifacts/demographic-analysis/demographic_analysis_write_receipt.json.
02 资源文件 1
03 SKILL.md 正文
Demographic Analysis Workbook Writer
Use this when artifacts/demographic-analysis/resolved_workbook_packet.json is present and the remaining task is to write /root/demographic_analysis.xlsx plus the packet-to-workbook receipt without reopening source files.
Inputs and Outputs
Prerequisite artifact: artifacts/demographic-analysis/resolved_workbook_packet.json
Consume these packet keys:
resolved_source_rowspivot_sheet_specsterminal_sink_handlenon_self_source_handlewritten_sink_value
Allowed outputs:
/root/demographic_analysis.xlsxartifacts/demographic-analysis/demographic_analysis_write_receipt.json
next_required_skill: none
writer_allowed_non_packet_inputs: []
Write /root/demographic_analysis.xlsx
Each pivot_sheet_specs entry should already carry the sheet name plus the row field, value field, aggregation, and optional column_field. The helper writes SourceData and the four pivot-table sheets directly from resolved_source_rows and pivot_sheet_specs.
python skills/demographic-analysis-workbook-writer/scripts/write_demographic_analysis_workbook.py \
--packet-artifact artifacts/demographic-analysis/resolved_workbook_packet.json \
--workbook-output /root/demographic_analysis.xlsx \
--receipt-output artifacts/demographic-analysis/demographic_analysis_write_receipt.json
cat artifacts/demographic-analysis/demographic_analysis_write_receipt.json
Stop Condition
Stop when /root/demographic_analysis.xlsx exists and the receipt shows:
current_stageset toworkbook_writtenpacket_artifact,packet_sha256,terminal_sink_handle,non_self_source_handle,written_sink_valuesheet_names_verified,pivot_definitions_verified,source_row_count_verified
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.