I've been working on the code a little bit each day. I expect to be
finish tonight. I will check to make sure the problems you listed gets
fixed.

I'm generating the schedule in the following order

1) Holiday
2) Weekends - This is the most complicated sections. I'm scheduling
Saturday and Sunday together. I schedule on person on the AM shift for
both Saturday and Sunday and one person one the PM shift for both
Saturday and Sunday. Then I schedule the remaining people trying to not
schedule the same person on more than one shift. I also try not toe
schedule a person when they work a holiday from Wednesday to Tuesday
(with the weekend in the middle). And I try not to schedule a person
who works Friday Night on a holiday on Saturday morning then try not to
schedule a person who works on a Monday AM holiday on sunday night.

Meeting all these conditions and meeting the number of people you
required to work is impossible. So there will be a few times when all
these conditions are not met. Usually the some of people who are off
for a holiday will also have to work the weekend.

There is a trade off between the reuirement for people to have both
Saturday and Sunday Off and having people working both Saturday and
Sunday. I don't schedule people to have off both Sturday and Sunday
since with holidays and billing cyles this is impossible. Instead I
rotate the pople who have off both days so everybody eventually gets
both days off and equal number of times. I do the same thing with
working only Saturday and working only Sunday. So if you look at the
schedule on a monthly basis you may not see everybody getting off both
Saturday and Sunday together. But you will see the schedule rotating as
you go through the year.

3) I then schedule nights making sure pople don't work morre than 5
days in a row. Try not to schedule people Friday night after I
scheduled them Saturday morning. And I also try not to schedule people
a night before a holiday when they are work the next morning.


4) Finally I will schedule the day shift. I will need to use one of
the shift workers on Friday to meet the demand for 5 people.


One question. Is there a minimum number of hours each shift person
need to work? My plan is to only schedule people to meet the scedule
requirements and not to schedule any more people than the requirements.
I'm not sure if shift workers will get too many days off.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=183222

Microsoft Office Help