College students and others with limited availability are often the most difficult to schedule to work shifts. An Excel spreadsheet now allows you to specify up to 6 daily time slots that each person is available. Shift assignments are then made in 48 daily time slots from drop-down menus of available people. Once someone is assigned to a shift his name is removed from the menu for that time-slot in order to avoid overlapping assignments.
Assign 50 people to 3 daily shifts and 75 locations each day on a simple Excel calendar scheduler. After you specify the availability of each employee for each shift each day for the month, 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. Outputs include location and employee calendars showing personnel assignments for the month.
Specify your daily shifts and then assign them to up to 25 people using drop-down menus of available shifts. Shifts are removed from the menu as they are assigned and when the menu is empty you are done. Created to schedule nurses, but can be used to schedule anyone to daily shifts and it keeps track of shifts for 3 different groups. Employee vacations can be entered and you are prevented from assigning shifts to employees who are on vacation.
Assign 50 people in 25 different groups to 6 daily shifts and 75 locations each day with an Excel calendar scheduler. After you specify the availability of each employee for each shift each day for the month, 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. Outputs include location and employee calendars showing personnel assignments for the month.
Automatically schedule up to 25 doctors to 10 daily calls each day for up to a year with Excel. Call preferences and qualifications are combined with doctor availability and call history to randomly select who is assigned to each call. Holiday and weekend calls, as well as weekday calls are evenly and fairly distributed to all of your doctors throughout the year. Creates files for use by MS Outlook Calendar as well as your PDA or Smart Phone.
An Excel spreadsheet where you specify the number of people you need each hour of the week and then assign daily hours to up to 25 people. You can assign 3 groups of hours (shifts) to each person each day and the program tracks hours for 3 different groups of people. A vacation planner lets you specify 10 vacation periods per person and prevents assignments when your people are on vacation. Bar graphs keep you informed of your scheduling progress
Specify up to 50 daily tasks and then assign them to up to 25 people using drop-down menus of available tasks. Tasks are removed from the menu as they are assigned and when the menu is empty you are done. Three different groups of tasks and people can be scheduled daily for 2 weeks. Employee vacations can be entered and you are prevented from assigning tasks to employees who are on vacation. Other spreadsheets available for 50 and 100 people.
Assign 50 people in 25 groups to 75 tasks on a simple Excel calendar scheduler. Up to 40 tasks can be scheduled each day and you can assign up to 10 tasks per person each day from drop-down menus of available people. Up to 10 vacation periods can be assigned to each employee and people will not appear on the drop-down menus while they are on vacation. Outputs include task and employee calendars showing personnel assignments for the month.
The Nurse Dispatcher can schedule nurses to work at several hospitals. It is ideal for situations where you need to send people to work different shifts at different locations. Two sizes, 20 locations and 200 employees or 10 locations and 100 employees, each with up to 3 daily shifts are available. The program makes sure that you do not assign overlapping shifts and will alert you if a person is assigned to more than 1 shift per day.
