Let Excel Calendar 50 People to 6 Shifts

Assign 50 people in 25 different groups (for example RN’s, LPN’s and CNA’s) to 6 daily shifts and 75 locations each day on a simple Excel calendar scheduler. First you specify the availability of each employee for each shift each day for the month, and then you assign them to one or more daily shifts and locations from drop-down menus of people who are qualified and available for the shift on that day. You may schedule someone to more than 1 daily shift, but are alerted if you do.

This scheduler is ideal for companies that dispatch contract personnel to various locations each day such as agencies who dispatch nurses to several different hospitals and nursing homes. Since you can specify exactly which shifts each person can work each day, you are assured that scheduling conflicts will not arise.

Outputs include location and employee calendars showing personnel assignments for the month and a schedule calendar that you can e-mail to selected employees. The spreadsheet is available to schedule 3 or 6 daily shifts for 50, 100 or 200 people and may be downloaded from the Shift Schedules website and used freely for evaluation.