attendance-sheet
por gykdly
PDF & DocumentsResumo
Generate professional attendance sheets in xlsx format from employee work information.
Descrição
O que esta skill faz
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.
Quando usá-la
- 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
Exemplo de fluxo de trabalho
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
Instalação
clawhub install gykdly/attendance-sheetExecute o comando da CLI ou cole o prompt no Claude Code, Cursor, Codex ou no agente de código que você usa.