![]() ![]() Shifts that involve working X days followed by Y days off are easy to handle with this rota template. But, it does a pretty good job of handling most of the common cases: Patterns This rotation schedule template does not handle all types of shift schedule patterns. The workbook contains a "Holidays" worksheet where you can list days that should be considered non-working days. In these worksheets, the rotation excludes both weekend days and holidays, all of which we call "non-working days." This means that if the rotation calls for you to work 2 days starting on Friday, then you would work Friday and then Monday (skipping the non-working weekend days). In the Rotation_String worksheet, you can define a rotation as a repeating string such as "11xxx22xx333xx" which would mean that you work Shift 1 for 2 days, followed by 3 days off, followed by working Shift 2 for 2 days, followed by 2 days off, followed by working Shift 3 for 3 days, followed by 2 days off.īoth the Rotation_Advanced and Rotation_String worksheets use the new built-in function NETWORKDAYS.INTL(), available as of Excel 2010, to let you choose which days make up the "weekend" (Sat/Sun, Mon/Tue, Sunday only, etc.) and to also account for holidays. For a simpler "days on/off" pattern, just leave the "Shift 2" field blank. In the first two worksheets ( Rotation and Rotation_Advanced), the rota schedule is defined by entering the numbers of days on Shift 1, followed by the number of days on Shift 2, followed by the number of days off. ![]() The workbook contains 3 separate worksheets, each providing a slightly different set of features. Just enter the year and start month, then use the other inputs to define your shift schedule pattern. This template provides a convenient way to display your work rotation schedule, using the annual calendar template as a basis. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |