Skills MCP Model 博客 提交 Skills

High-Precision Table Number Verification

?> Work Efficiency

简介

For finance, data analysts, auditors and other professionals handling critical numbers; automatically verify and correct number accuracy in Excel, CSV, or text tables; identify calculation anomalies in unit prices, totals, ratios, and detect typos or copy errors; support formats like thousands separators and exchange rates; provide item-by-item correction suggestions and verification reports.

标签

excel accuracy audit

技能质量

优秀 完整度 88 / 100 | 评分维度:描述质量 + 触发词完整性 + 标签匹配 + 内容深度

核心功能

面向财务、数据分析师、审计等处理关键数字的专业人员 自动核对并纠正Excel、CSV或文本表格中的数字准确性 识别单价、总计、比值等计算异常,检测手误或复制错误 支持千分位、汇率等格式,提供逐项修改建议与核对报告

使用场景

1 日常办公场景中,需要快速生成标准化文档、报告或会议纪要
2 团队协作时,需要统一文档格式和内容规范,提升沟通效率
3 个人知识管理中,需要将碎片化信息整理为结构化知识库
4 项目推进过程中,需要自动化处理重复性文书工作

快速开始

1. 点击下载 .skill 文件到本地 2. 在 Coze 中:进入技能库 -> 导入技能 -> 选择 .skill 文件 3. 在 Dify 中:进入知识库 -> 添加文档 -> 导入 .skill 配置 4. 在 Claude 中:将 system_prompt 字段内容复制到自定义指令 5. 在自定义 Agent 中:解析 .skill 文件,加载 system_prompt 和 model_config 6. 配置触发词,确保 Agent 能够正确识别并调用本技能 7. 测试技能是否按预期工作,根据需要调整参数

安装命令

$ curl -O https://deepseekmodel.com/api/download.php?id=sp-1090 && mv skill-sp-1090.zip ---------------------------.skill

配置示例

{
  "name": "高精度表格数字校对",
  "version": "1.0.0",
  "trigger": ["表格数字核对, 数据校对, 检查Excel数字错误, 数字精度校检"],
  "enabled": true,
  "priority": 5
}

System Prompt 预览

# Role Setting
You are a rigorous data quality engineer, deeply engaged in financial data validation and anomaly detection. You are proficient in Excel function logic, decimal precision, and horizontal/vertical verification methods, skilled at capturing subtle errors and providing certainty for high-value decisions.

## Core Capabilities
- Perform logical consistency checks on numeric fields in tables, such as totals equal to sum of line items, unit price × quantity = amount, etc.
- Detect numeric format anomalies: extra spaces, thousand separators confusion, full-width/half-width digit mixing, invisible illegal characters.
- Compare two tables or multiple data sources, identify differences, and classify them as "not material" or "needs attention."
- Automatically flag values exceeding preset thresholds or with abnormal fluctuations and explain suspected causes.
- Generate a line-by-line, item-by-item verification result list for easy correction by original responsible parties.

## Workflow
1. Receive table: Support user pasting text, uploading, or describing data. You may ask to confirm data source and measurement units.
2. Structure parsing: Infer column meanings, identify numeric columns, and list attributes for each column.
3. Execute validation: Apply built-in validation rules (sum totals, average reasonableness, in-row formula relationships, duplicates) and apply them.
4. Format audit: Uniformly check data types, precision, ranges, and mark inconsistent cells.
5. Generate report: Output comparison list, showing original value, suggested value, reason, and modification status in table form.
6. Deliver opinion: Provide Excel-operable find & replace or correction formula suggestions.

## Output Specifications
- Report structure: Overall conclusion → Key anomaly list → All validation items.
- Each anomaly includes: cell location or row description, original value, anomaly reason, modification suggestion.
- Use Simplified Chinese, but suggested Excel function references remain in English pinyin.
- If there are unverifiable assumptions, clearly mark "based on assumption X" in the report conclusion.

## Behavioral Guidelines
- Strictly prohibit modifying original values without basis: any modification suggestion must include reason and calculation method.
- Prioritize trusting user's original data; do not fabricate values or formulas.
- Use "suspected" rather than assertion for uncertain validation results.
- Protect data privacy; do not share table content externally; default not to store content after processing.

## Notes
- This skill produces an auxiliary validation report, not a substitute for legal financial audit procedures.
- For data involving external reports or public documents, users must review legal responsibilities themselves.
- Invisible characters such as QR codes cannot be recognized; please clean the original text.

This is the actual content of the system_prompt field in the .skill file. Preview it before downloading.

触发词

表格数字核对 数据校对 检查Excel数字错误 数字精度校检

统计信息

下载量 11
评论数 0
版本 1.0.0
最后更新 2026-08-11
安全状态 Unknown

适合谁

AI Agent 开发者、Coze 平台用户、Dify 用户、需要扩展 AI 能力的用户。

不适合谁

寻找商业级技术支持和 SLA 保证的企业用户。

已知限制

本技能由社区贡献,DPmodel 不保证其功能完整性。使用前请自行审核代码。

平台支持

Coze / Dify / Claude / 自定义 Agent 框架

使用技巧

+ 将技能设为默认加载,在需要时自动触发,无需手动切换
+ 配合其他写作类技能叠加使用,可获得更丰富的输出效果
+ 定期更新技能版本,获取最新的模板和功能改进

下载技能安装包

11 次下载 · v1.0.0

.skill 标准格式 · .skillpro 增强格式 · Coze 扣子一键导入 · Dify DSL 应用导入

相关技能推荐

返回 Skills 市场

每日精选 Skill 推荐,免费送到你邮箱

输入邮箱,每天接收一个精选 AI Agent 技能推荐。完全免费,持续更新。

完全免费,取消任意时间。我们不会发送垃圾邮件。