What it is for
When late arrivals and absences are kept "in your head" or in scattered notes, you have nothing to rely on in a conversation with an employee. Here a manager or HR specialist enters events into a single log, and for the chosen period the spreadsheet counts the number and minutes of late arrivals, early departures, absences, overtime and violation points, and shows each employee's status and a comparison of departments.
What is inside
- "Settings": organization, period, points for each event type, "warning" and "disciplinary action" thresholds.
- "Employees": up to 60 people — name, department, position.
- "Log": up to 1,500 events — date, employee, type, minutes, comment; points and department are filled in automatically.
- "Summary": for each employee over the period — events, minutes, points and status.
- "By department": violations by department and a chart.
Who it is for
Heads of departments and small companies, HR staff, managers of shops, warehouses and salons, and anyone responsible for work discipline.
Compatibility
Excel 2007 and later, LibreOffice. No macros. The spreadsheet records facts and shows statistics; it is not a basis for disciplinary action — follow labour law and your internal rules (check your local rules). The file is in English.
KHIZHNYAKOV

