skills.rest
sebaperiesdigit-create
sebaperiesdigit-createCOMMUNITY
Explore all skills by this author →
GitHub

work-hours-log-automation

Generates monthly three-sheet Excel attendance workbooks with confirmed work-hours calculations and audit logging.

Updated Jul 27, 2026
Search Tags:#openpyxl#audit log#attendance tracking#csv import#excel workbook#work hours#period lock
One-click install
npx skills add https://github.com/sebaperiesdigit-create/Peries-Skills-Master --skill work-hours-log-automation-sebaperiesdigit-create
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: work-hours-log-automation
Source: https://github.com/sebaperiesdigit-create/Peries-Skills-Master/tree/main/.claude/skills/work-hours-log-automation
Command: npx skills add https://github.com/sebaperiesdigit-create/Peries-Skills-Master --skill work-hours-log-automation-sebaperiesdigit-create

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve? It removes the manual, error-prone work of maintaining monthly attendance records by generating a consistent Excel workbook that logs arrival and departure times, computes confirmed work hours under fixed business rules, and flags missing scans for supervisor review instead of guessing values. ## Core Features & Use Cases - Monthly Workbook Generation: Builds a three-sheet workbook (Attendance Log, Work Hours Calculation, Summary Report) per month, pre-filling every active employee's working-day rows. - CSV Import with Confirmed Mapping: Imports attendance CSVs of any shape after the user explicitly confirms column mappings, reporting every skipped row with a reason. - Period Lock and Audit Trail: Locks finalized months, requires a named override with reason for corrections, and appends every save to an audit log with backup-before-write and concurrency protection. - Use Case: A supervisor asks to log today's arrivals and departures for five employees; the skill collects the entries conversationally, dry-runs the calculation, and saves the updated September workbook with a backup and audit entry. ## Quick Start Ask the assistant to log today's attendance for this month and follow the prompts to enter arrival and departure times for each employee.

Frequently Asked Questions about work-hours-log-automation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I log daily attendance and generate a monthly work-hours Excel workbook?▼

Invoke the skill with a month argument like 2026-09, then enter arrival and departure times conversationally or import a CSV. The skill dry-runs the calculation, shows added and updated row counts, and saves the three-sheet workbook only after your confirmation.

How do I import an attendance CSV with different column names?▼

Provide the CSV path and confirm which of its column headers map to employeeId, workDate, arrivalTime, and departureTime when prompted. The import-csv-preview command then reports imported and skipped counts with warnings before anything touches the workbook.

How are confirmed work hours calculated from arrival and departure times?▼

Confirmed hours equal departure time minus arrival time minus a flat one-hour break, computed only on working days when the employee is Present and both scans exist. Missing or invalid scans leave the value blank and flag the row as Needs Supervisor Review.

Does the period lock prevent unauthorized edits to a finalized month?▼

No, the lock is a self-attestation and audit-log control, not real access control. Writing to a locked month requires a name and reason, which are recorded in the append-only audit log, but no identity verification is performed.

What happens if two people save the same month's workbook at once?▼

A concurrency guard hashes the workbook at load time and re-checks it before saving. If the file changed in between, the command exits with code 4 without writing, and re-running the command applies your data on top of the other person's saved version.

Does this skill calculate payroll, overtime pay, or leave balances?▼

No, it produces confirmed work hours only and has no concept of pay rates, payroll amounts, or overtime premiums. The Summary Report contains only daily, weekly, and monthly hours totals, with no leave or absence columns.

Related Skills

Explore More Product & Management Skills→
ZJU-REALZJU-REAL
195

lark-attendance

Retrieve personal attendance punch records from Feishu via the attendance API.

Official
Intermediate
aviskaaraviskaar
6

payroll-compensation

Manage employee and contractor compensation flows, including payroll runs and compliance.

Official
Advanced
alon3153alon3153

google-cloud-storage-bucket-architect

Designs and creates secure Google Cloud Storage buckets tailored to specific workload use cases.

Community
Advanced
josuerivera300891-progjosuerivera300891-prog

shift-reminder

Automate daily gym staff shift reminders via WhatsApp using Twilio and Supabase.

Community
Intermediate