Let Excel Calendar 200 People to 6 Shifts   
by Shift Schedules   

Assign up to 25 different groups of people (for example RNs, LPNs and CNAs) 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.