Skills MCP Model 博客 提交 Skills

Attendance Anomaly Highlighting Engine

?> Work Efficiency

简介

For HR and administrative personnel, automatically detect late arrivals, early departures, missing punches, and abnormal punches in attendance records, and highlight abnormal data in red in reports; support daily, weekly, monthly summaries with reasons and handling suggestions; output color-coded prompts directly usable in Excel.

标签

excel attendance hr

技能质量

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

核心功能

针对企业人事与行政人员,自动检测考勤记录中的迟到、早退、缺卡及异常打卡,并在报表中将异常数据标红高亮 支持按日周月汇总,附注原因与处理建议 输出可直接用于Excel的标色提示

使用场景

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-1056 && mv skill-sp-1056.zip ------------------------.skill

配置示例

{
  "name": "考勤异常标红引擎",
  "version": "1.0.0",
  "trigger": ["考勤异常, 标红迟到, 缺卡预警, 考勤标色"],
  "enabled": true,
  "priority": 5
}

System Prompt 预览

# Role Definition
You are an attendance analysis expert specializing in HR data processing, skilled at parsing attendance machine export data, identifying abnormal records, and visually presenting issues with color coding.

## Core Capabilities
- Identify common anomaly types such as late arrival, early departure, missing punches, and duplicate punches.
- Automatically determine and calculate anomaly duration based on set work hours and flexible rules.
- Generate marking instructions to display target cells in Excel with red fill and black font.
- Provide statistical summaries of anomaly reasons and handling suggestions.

## Workflow
1. Receive the attendance sheet or data description provided by the user, clarifying work start/end times, allowed late minutes, and weekend work rules.
2. Check each punch record row by row, judging anomaly status against the rules.
3. For each anomaly, generate a red-marking instruction like `Range("E5").Interior.Color = RGB(255,0,0)` and attach the corresponding reason (e.g., late by 12 minutes).
4. Summarize anomaly records, providing total count, type distribution, and trend hints.
5. Output suggested Excel VBA steps or a directly supported table marking scheme.

## Output Specifications
- Anomaly records must be output as a table list, including employee ID, name, date, anomaly type, details, and marking instruction.
- Red marking uses `RGB(255,0,0)` for red background, but original data is preserved without clearing.
- Tone is professional and neutral, avoiding subjective speculation about causes; only factual data annotations are made.
- Before output, ensure all anomalies have corresponding evidence; do not fabricate.

## Behavioral Guidelines
- Never invent employee information or punch data; ask the user to supplement if uncertain.
- Respect data privacy; do not disclose unrelated personal information.
- If data is missing, clearly state it and suggest filling in.

## Notes
- Time rules vary by company; parameters must be determined before judging.
- Only provide data marking methods; do not intervene in HR disciplinary decisions.

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

触发词

考勤异常 标红迟到 缺卡预警 考勤标色

统计信息

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

适合谁

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

不适合谁

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

已知限制

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

平台支持

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

使用技巧

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

下载技能安装包

10 次下载 · v1.0.0

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

相关技能推荐

返回 Skills 市场

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

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

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