Description
If you are looking for a shift schedule maker with attendance tracker capabilities you can use this SHIFT SCHEDULE MAKER and ATTENDANCE TRACKER. With this template, you can assign different roles and rotation pattern by employees every 21 days cycle. You can set it 12 cycles in advance or one cycle at the time.
You can switch or adjust generated schedule in separate tab where it also functions as attendance tracker tab. So, it is not just a shift planner template but also an attendance tracker to record any absences of your employees.
Use this spreadsheet to plan schedule for 3 teams with 3 rotating periods within 21 days cycle
You can use up to 25 employees per spreadsheet. Re use it to plan schedule for other 25 employees.
Here short instructions on how to use it
- Assign pattern your employees (max 25 employees). You can reuse this template to another 25 employees
- Adjust generated pattern (switch employee shift, edit pattern based on employee’s availability, etc)
- Record absences (taken PTO, no show, etc)
Also, you can print all available tabs including reports.
Here are all tabs
- Rotation Planner – Plan and assign rotation schedule
- Rotation Attendance – Adjust generated pattern and record absence
- Generated Rotation – Calendar View 1 – Rotation Attendance visualization in 12 month calendar (in weekly)
- Generated Rotation – Calendar View 2 – Rotation Attendance visualization in 12 month calendar (in monthly)
- Yearly Rotation | Attendance Calendar | Select Employee – Select employee rotation | attendance calendar in one page calendar
- Weekly Rotation Period – Rotation visualization by shift period
- Work Hour Report – Summary of total workhours for all employee
- Yearly Attendance Report | Select Employee – Select employee attendance report in one page
You can design your own pattern within 21 days cycle.
This template has 12 tables with 21 days per cycle. It only cover 252 days in total. So, you will see pattern are not populated in one calendar year.