본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

attendance-sheet

gykdly 제작

PDF & Documents
807clawskills.sh가 보고한 다운로드 수
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

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. 1

    Parses employee names and date range from the request

  2. 2

    Maps attendance status codes to the supported types (normal, late, absent, leave, overtime)

  3. 3

    Runs generate_attendance.py with the structured input data

  4. 4

    Applies color coding per status and calculates summary statistics

  5. 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-sheet

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크