Reply to thread

Message

[QUOTE="joel, post: 6439589"]
I got everything working last night but on the 78th day of the year the
macro couldn't fill a shift person because anybody available would of
worked for more than 5 days in a row.  What I'm going to do is highlight
the cell in the worksheet Red and let the code continue.  Then see if
there is a way to easily fix the problem.  I think it occured on a
Friday day shift where I already schedule the person to work the
weekend.  I have a few algoritms I thinking of using to stop this from
happening.  Right now my queing system is comparing looking for the
person who worked the fewest number of days.  Instead if I calculate the
number of days a person is working an individual week (including the
weekends and holidays I already scheduled) the problem may not occur.

I'm also getting a number of cases where a person is working a night
shift and is also scheduled to work the next day shift.  I want to see
the number of times these issue occurs and see if I can easily fix the
problem.
[/QUOTE]

Verification