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.
What do you
think aboutLet Excel Calendar 50 People to 6 Shifts
Add your comment
What's New in this Release: Changed to Annual License
Link to Let Excel Calendar 50 People to 6 Shifts sample code
Platform: Win95,Win98,WinME,WinNT 3.x,WinNT 4.x,Windows2000,WinXP,Windows2003,Windows Vist
License: Free To Try
Date Added: Oct 30, 2006
Last check for an update: Sep 24, 2016
Last version date: Jan 09, 2009
Downloads Total : 1
Downloads last 10 Days: None
Page Visit: 130
Malware Status: Clean
Scan Date: Mar 30, 2009