LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default I need a work schedule template for a union plant with 170 people

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rotating on-call schedule M-F for 13 people? SUZAG Excel Discussion (Misc queries) 0 July 22nd 08 02:34 PM
Need rotation schedule with 6 tables of 6 people for all to meet o sccyclist Charts and Charting in Excel 1 April 13th 07 08:05 PM
monthly work schedule for 2 people on same calendar roadbitch Excel Discussion (Misc queries) 0 May 18th 06 01:17 PM
Where can I find a template for a Credit Union account? Bill Sisk Excel Discussion (Misc queries) 1 August 13th 05 01:43 PM
I need a template for a work schedule. lenadavid Charts and Charting in Excel 0 January 7th 05 02:53 AM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"