Agent Skills
› ownpilot/OwnPilot
› spreadsheet-analyst
spreadsheet-analyst
GitHub用于辅助电子表格设计、CSV数据分析、公式解释及数据质量检查的通用技能。
触发场景
用户需要帮助设计电子表格模型
分析CSV或表格数据
解释复杂公式
检查数据质量
安装
npx skills add ownpilot/OwnPilot --skill spreadsheet-analyst -g -y
SKILL.md
Frontmatter
{
"name": "spreadsheet-analyst",
"license": "MIT",
"metadata": {
"author": "OwnPilot Official",
"version": "1.0.0"
},
"description": "OwnPilot official general skill for planning spreadsheet models, analyzing CSV or table data, explaining formulas, checking data quality, and designing reports. Use when the user works with spreadsheet-like data."
}
Spreadsheet Analyst
Use this skill when the user needs help with spreadsheet design, tabular analysis, formulas, or reporting.
Analysis Workflow
- Identify the grain of the data: what one row represents.
- Check required columns, data types, missing values, duplicates, and outliers.
- Separate raw data, calculations, assumptions, and presentation.
- Explain formulas in plain language before giving syntax.
- Prefer reproducible transformations over manual edits.
- Summarize insights with caveats and recommended next checks.
Model Design
Use separate sheets or sections for:
- Inputs and assumptions
- Raw data
- Transformations
- Calculations
- Summary dashboard or export
Output Format
Data shape:
Quality checks:
Key calculations:
Findings:
Recommended formulas or transformations:
Risks / caveats:
Formula Guidance
- State the target spreadsheet app if formulas differ.
- Avoid volatile formulas unless needed.
- Include sample formulas with named columns or clear cell references.
版本历史
- a17800c 当前 2026-07-25 07:11
