Use a Calendar to Schedule 50 People to 6 Shifts

Assign up to 25 different groups of people (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.
LicenseFree to try
File Size1.31 MB
Operating System Windows Vista Windows XP Windows Server 2008 Windows Windows 7 Windows 2003 Windows NT Windows 98 Windows 95 Windows 2000 Windows Me
System RequirementsMicrosoft Excel 2000