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 kommentar(er)
