
By doing so the entire template would get altered as the various fields have interconnected formulas and the results in such a scenario would be doubtful. We recommend you not to change or delete the pre-defined formulas of the template. You can get the visibility of an employee punctuality with just one glance of this sheet. Manager can edit the schedule of each employee based on his presence or the reason of absence.

This template provides a colorful tabular view of the schedules followed by each employee of the team during the selected period. Select the year and month form the drop down menu and the calendar for those specific values is automatically populated. This sheet displays all the dates between the entire period, selected under the duration.

The data stored under the settings sheet is automatically populated in the second sheet Rotation Schedule. The kind of days the template specifies are: The last part of the setting page stores the color code that would be unique for every day type. Content is available under the Creative Commons Attribution-ShareAlike 4.0 License Page visited.

You can select the first day of the week in 'Week begins by' drop down. Here you can pre-define the color scheme for each day type and store basic company information like Company Name, Company Slogan both the fields can be enabled or disabled as required. Staff Rotation Schedule template has first sheets as Settings that works like a mini database for the template and all the information stored under this page is auto-populated to the main Rotation schedule worksheet.
