Invite your staff to view the board with “read-only” privileges so everyone has 24/7 access without the worry that staff may make alterations without your knowledge. Already have the schedule in Excel? Import it easily to transform it into a beautiful board in just a few steps. What are the benefits of using this template?Įxport this template to Excel with just one click. The weekly shift schedule template allows you to get your scheduling up and running without wasting time trying to create a schedule from scratch or struggling with the limited capabilities of other free work schedule templates out there. Shift Work at - Describes various types of shift schedules.Ensure you have staff and manager coverage for any amount of time-where and when you need it.Though the rotation schedule template is set up to show an entire year, you could use it to just show a few months at a time (by hiding or deleting the unneeded rows). It is pretty common for an employee to be assigned a shift for an extended amount of time (months?) because of how hard it can be on the body and general life planning to change from a day to a night shift on a regular basis. Day shift for X months, then Night shift for Y months I created the Rotation_Advanced worksheet specifically for cases like this, where the repeating pattern is "11xxx11xx111xx" with "x" meaning OFF and the "1" meaning ON. Some rotation schedules use a pattern that repeats every fortnight (2 weeks), and may be referred to as 2/3/2. If using the String method, this would be defined as "12xx". In some cases, an employee might work 2 days on Shift 1, followed by 2 days on Shift 2, followed by a number of days off.Īn example would be a 4-day shift pattern in which an employee works a 12 hour day shift the first day, followed by a 12 hour night shift the second day, followed by two days off. Or, if using the String method, you can define a 4/2 pattern as "1111xx". 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 |