Spreadsheet Dashboard / 表格分析与 Dashboard

Purpose / 用途

中文

分析 Excel/CSV 的字段和指标，建议 KPI、生成图表和可复现 Dashboard；业务 KPI 最好由用户确认。

English

Analyze spreadsheet schemas, propose KPIs, generate charts, and build a reproducible dashboard or report.

Status / 状态

• Workflow status: 🟢 Verified Workflow / 已验证工作流
• Implementation: ✅ Tested reference implementation / 已测试参考实现
• Audit grade: A
• Quality score: 4.0/5
• Automation level: L2
• Category: Data & Analytics / 数据与分析

Workflow status describes how well the workflow itself is understood. Implementation status separately tells you whether this repository ships runnable code for it. Integration skills still require external services or authorization; experimental skills may need more human review.

Search aliases / 搜索关键词

spreadsheet-dashboard · Spreadsheet Dashboard · 表格分析与 Dashboard · Excel dashboard · AI spreadsheet analysis · CSV dashboard · Excel数据看板 · 表格分析 · data automation · AI data analysis · Excel automation · analytics workflow · 数据自动化 · 数据分析

When to use / 何时使用

Use this skill when the user explicitly requests spreadsheet dashboard, or when the requested outcome clearly matches this workflow.

Do not activate it merely because the topic is related. Confirm the input, desired output, and any consequential external action.

Inputs / 输入

• CSV/XLSX dataset
• Schema, goal, and constraints

Outputs / 输出

• Structured analysis output
• Validation / provenance notes

Core stack / 核心工具

Python / Pandas / plotting

Permissions / 权限

• filesystem:read
• filesystem:write

Treat permissions as capabilities to request or verify, not as permissions automatically granted by installing the skill.

Workflow / 工作流

1. Load CSV
2. Detect numeric columns
3. Calculate row/column/missing-value statistics
4. Calculate min/max/mean for numeric fields
5. Render self-contained HTML dashboard
6. Write machine-readable JSON metrics

Dependency suggestions / 依赖建议

• Python: python3 -m pip install pandas

The Agent Skill itself should remain installable even when optional runtimes are absent. Report missing runtime dependencies instead of silently installing privileged software.

Runnable reference / 可运行参考实现

This skill ships a tested reference runtime in scripts/run.py. From a cloned repository:

ows doctor spreadsheet-dashboard
ows run spreadsheet-dashboard -- --help
ows test spreadsheet-dashboard

runtime.json declares the entrypoint and optional system commands. Runtime dependencies are checked separately from installing the Skill definition.

Install / 安装

Inspect before installing

npx skills add BryceYuuu/open-workflow-skills --list

Install this skill into the current project

npx skills add BryceYuuu/open-workflow-skills --skill spreadsheet-dashboard

Install for a specific supported agent

npx skills add BryceYuuu/open-workflow-skills --skill spreadsheet-dashboard --agent codex

npx skills is a community ecosystem CLI, not an OpenAI-official installer. Review third-party skills and scripts before granting shell, filesystem, network, or credential access.

Example invocation / 调用示例

中文

使用 spreadsheet-dashboard 工作流处理我提供的输入。先检查依赖和权限，不覆盖源文件；执行后给我输出路径、验证结果和需要人工审核的部分。

English

Use the spreadsheet-dashboard workflow for the provided input. Check dependencies and permissions first, preserve the source, validate the result, and report outputs plus any human-review items.

Validation / 验证

At minimum:

• Verify all expected outputs exist and are readable.
• Verify the source was not unintentionally overwritten.
• Verify structured outputs against their expected schema or invariants.
• Record warnings, skipped steps, external dependencies, and failed checks.
• Never mark the workflow successful solely because a model produced text.

See references/QUALITY.md for skill-specific quality expectations.

Safety / 安全

• Do not invent source facts or claim an external action succeeded without verification.
• Preserve source files unless the user explicitly requests in-place modification.
• Surface missing dependencies, permissions, credentials, and failed checks clearly.

Failure handling / 失败处理

If a dependency, credential, connected service, browser session, file, or required permission is unavailable:

1. Stop the affected step.
2. Preserve completed safe outputs.
3. State exactly what is missing.
4. Do not fabricate a successful result.
5. Suggest the minimum next action needed to continue.

Files / 文件

• SKILL.md — workflow instructions
• references/QUALITY.md — quality/evaluation guidance
• tests/cases.yaml — example evaluation cases
• runtime.json — runtime manifest
• scripts/run.py — runnable reference implementation
• tests/smoke.py — deterministic smoke test