The timesheet is computed, not typed
A month of attendance, leave and the production calendar, resolved into one sheet — without anyone adding up columns in Excel.
In most companies the timesheet is a spreadsheet assembled in the last two days of the month: attendance on one side, leave requests on another, public holidays on a third. The mistakes are made in the joining.
Each day’s status is a computed value
The system derives a status for every day — worked, absent, on leave, permission, holiday or weekend — by reading attendance records, approved time-off requests and the production calendar together.
- No absence is recorded against a holiday or a weekend
- Somebody on annual leave is not given a penalty
- A business trip counts as a worked day; annual leave does not
The result exports to Excel and PDF, but the file is not the source — the query is. Correct something and the timesheet is not rebuilt, it is simply read again.