Let Excel Calendar 50 People to 3 Shifts Screenshot

Assign up to 25 different groups of people (for example RN’s, LPN’s and CNA’s) to 3 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 . Spreadsheets are available to schedule 50, 100 or 200 people and are priced between $149 and $349. Spreadsheets may be downloaded from the Shift Schedules website and used freely for evaluation.