Create a 52 Week Schedule With a Shift Template

Why do I need this spreadsheet scheduler

This scheduler is ideal if your employees work a regular schedule of shifts and days off and you want to create a schedule for up to 52 weeks at a time while managing daily employee breaks, vacations, overtime and coverage of unfilled shifts. It is often used to create 24/7 schedules for manufacturing plants, law enforcement agencies and other organizations with full time employees working a full time schedule with rotating days off. Scheduling patterns (templates) can be up to 100 days long and consist of 8 hour, 10 hour, 12 hour or other length shifts mixed with scheduled days off.

It's so easy to use

Simply input your employee names, define your shift start and stop times, select a template and assign template "legs" to your employees to create your schedule for 52 weeks. You can use one of the 8 hour, 10 hour or 12 hour shift templates that come with the spreadsheet or create your own pattern of shifts and days off. Template work patterns can be anywhere from 1 to 100 days long but most schedules consist of 6, 7 or 8 day patterns.

It shows you exactly what you need to know to manage your business

After you create your schedule on the "Scheduling" sheet you can assign vacations, shift changes and overtime shifts on the "ReSchedule" sheet making it very easy to adjust the schedule to accommodate employee requests. The overtime scheduler keeps track of overtime hours assigned to each employee and lets you know who is available and due for an extra shift each day. An overtime signup sheet is produced to show what vacated shifts are available for overtime volunteers each day. Numerous reports and charts show the people assigned to each shift each day so you can easily spot scheduling problems and shifts with inadequate personnel assigned. And, a calendar file is created that you can import into your Microsoft Outlook Calendar and to your PDA or Smart Phone so you will have everybody's schedule readily available.

It tells your employees all they need to know about their schedules

Several different schedules, calendars and other outputs are created for distribution to your employees showing their schedules for a full 52 weeks. There is also a 4 week calendar that can be e-mailed to each employee and a calendar file showing the shifts for an employee that can be imported into their Microsoft Outlook Calendar and to their PDA or Smart Phone so they will have their 52 week schedule readily available.

It will save you time and money every week

Using this scheduler instead of your typical paper and pencil method or outdated scheduling program or a spreadsheet that somebody put together a few years ago saves you a great deal of time and since it is so easy to create your schedules and manage employee vacations and overtime you will save money every week and before you know it the small price you paid for the spreadsheet will be repaid many times over.