attendance-sheet
gykdly 제작
PDF & Documents요약
Generate professional attendance sheets in xlsx format from employee work information.
설명
이 스킬이 하는 일
Generates formatted Excel attendance sheets from employee work data. Accepts employee names, date ranges, and attendance status codes, then outputs a color-coded .xlsx file with summary statistics.
Skips manual Excel formatting by producing a ready-to-share .xlsx file with color coding and totals in one step.
사용 시점
- Creating a monthly HR attendance report for 50 employees
- Converting raw daily check-in logs into a formatted spreadsheet
- Tracking late arrivals and absences across a team for a pay period
- Preparing attendance documentation for a performance review
- Generating a one-day attendance record for a small team
예시 워크플로
User asks: Generate December attendance sheet for employees Zhang San, Li Si, Wang Wu with normal, late, and leave statuses
- 1
Parses employee names and date range from the request
- 2
Maps attendance status codes to the supported types (normal, late, absent, leave, overtime)
- 3
Runs generate_attendance.py with the structured input data
- 4
Applies color coding per status and calculates summary statistics
- 5
Writes the output to 2024年12月考勤统计表.xlsx
A formatted .xlsx file with employee rows, date columns, color-coded status cells, and totals for late count and attendance days
설치
clawhub install gykdly/attendance-sheetCLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.