Ready-to-use Excel templates
Six files built for HR work on the shop floor. Each has a dashboard of KPIs and charts, data-entry sheets, settings and a "How to use" sheet; formulas work, sample data is fictional. Labels are in Turkish. No sign-up or e-mail required.
Leave Tracking
Department-filtered leave dashboard fed by the staff list and leave records. Entitlement by seniority (14/20/26 days), used and remaining leave, who is off today, pending approvals and accrued-leave warnings.
Dashboard · İzin Kayıtları · Personel · Listeler
- 6 KPIs and 4 charts recalculated by department filter
- Automatic day count excluding Sundays
- Who is off today and top accrued-leave list
- 300 records / 80 staff capacity, grows by copying rows
Guide: Yıllık izin hakkı nasıl hesaplanır? Kıdeme göre gün sayısı, devreden izin ve takip şablonu →
Workforce KPIs
One-page workforce dashboard for management: headcount, hires and leavers, turnover rate, average seniority, absenteeism rate; exit reasons, seniority distribution and monthly trend.
Dashboard · Personel · Aylık Devamsızlık · Listeler
- Department filter and month-over-month trend indicator
- Turnover and absenteeism rate against targets
- Recent leavers and employees on probation
- Department × month absence entry, months over target in red
Timesheet
Enter hours worked or a leave code per day; days worked, total hours, overtime, leave, social-security days and warnings are calculated automatically. Pre-payroll control dashboard.
Dashboard · Puantaj · Ayarlar
- Hours and codes (HT, RT, Yİ, R, Üİ, Mİ, D) in the same cell
- Overtime, social-security days and warning column (high OT / absent / missing rest day)
- Daily attendance, weekly hours and top 10 overtime charts
- Flagged employees list
Guide: Puantaj nasıl tutulur? Fazla mesai, hafta tatili ve SGK gün hesabı →
Shift Schedule
Person × day plan for a 3-shift department; planned headcount is compared with the requirement per shift, short days show in red. Legal checklist on the dashboard.
Dashboard · Çizelge · Ayarlar
- Day and weekend headers update from the month start date
- Longest consecutive run, weekly rest and night-shift checks
- Daily planned vs. required and list of short-staffed days
- Per-person shift and leave distribution chart
Skills Matrix
Employee × operation skill levels (0–4); qualified people per operation, target comparison, RISK flag and training need calculated automatically. Evidence for IATF 16949 clause 7,2.
Dashboard · Matris · Operasyonlar
- Operation list and targets on a separate sheet, matrix headers automatic
- Versatility rate, at-risk and single-person-dependent operations
- Trainer-capable staff and critical operations list
- Level distribution and qualified-operations-per-person charts
Training Plan & Records
Annual training plan, signed attendance form and per-person certificate validity tracking in one file; overdue training and expired certificates on the dashboard.
Dashboard · Eğitim Planı · Katılım Formu · Personel Kayıtları · Listeler
- Plan completion rate, training hours, overdue training
- Pending effectiveness reviews and certificates to renew
- Attendance form: roll call, exam score, pass / fail
- Certificate status by department chart
When a template is not enough
In the TAKMOS HR Module the same jobs are linked: entering a leave updates the schedule and timesheet, a training record feeds the skills matrix.