Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have to schedule 170 people over 3 shifts 7 days a week in a complex union
environment. The rules to the calling people in, covering open slots, and job qualifications is extremely difficult. The focus of the problem is tha it takes about 30 minutes to replace someone when they call in sick. I check which employees are qualified, if they are already working, if they have at least 8 hours off before and after the position I must fill, see if they have signed up for over time; if they are qualified and signed up-I must call them senior to junior, If I can not fill the opening, I must start at the junior people qualified with 8 hrs off before and after the slot and require them in. Yesterday I had 3 call ins for 2nd shift, it took 4 hours to cover the openings. Any help would be greatly appreciated!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rotating on-call schedule M-F for 13 people? | Excel Discussion (Misc queries) | |||
Need rotation schedule with 6 tables of 6 people for all to meet o | Charts and Charting in Excel | |||
monthly work schedule for 2 people on same calendar | Excel Discussion (Misc queries) | |||
Where can I find a template for a Credit Union account? | Excel Discussion (Misc queries) | |||
I need a template for a work schedule. | Charts and Charting in Excel |