johnalbertini14-glitch Attendance Sheet Generator
Overview
Generate professional attendance sheets (考勤表) in xlsx format based on employee work information. Input employee names, dates, and attendance status (normal, late, absent, leave, etc.) to automatically create formatted Excel files ready for HR or management use.
When to Use
Use this skill when:
- Creating monthly attendance reports
- Generating employee attendance sheets
- Converting raw attendance data to formatted Excel
- HR needs standardized attendance documentation
Input Format
Provide the following information:
员工: 张三, 李四, 王五
日期范围: 2024-01-01 至 2024-01-31
考勤类型: 正常出勤, 迟到, 早退, 缺勤, 请假, 加班
Or structured format:
{
"employees": ["张三", "李四", "王五"],
"start_date": "2024-01-01",
"end_date": "2024-01-31",
"attendance_types": ["正常出勤", "迟到", "早退", "缺勤", "请假", "加班"]
}
Output
Generates an xlsx file with:
- Employee names in rows
- Dates in columns
- Attendance status cells with color coding
- Summary statistics (total days, late count, etc.)
- Professional formatting
Usage Examples
Example 1 - Monthly Report:
Input: 员工列表 + 1月考勤数据
Output: 2024年1月考勤表.xlsx
Example 2 - Simple Attendance:
Input: 今天出勤人员: 张三, 李四
Output: 出勤记录_20240101.xlsx
Example 3 - Full Month with Multiple Types:
Input: 全体员工12月考勤数据（含迟到、请假）
Output: 2024年12月考勤统计表.xlsx
Resources
scripts/
generate_attendance.py- Main Python script for generating attendance sheets