Employee Schedule
 

Hello Everyone
I need to make an employee schedule in excel. I am not sure if it i
possible, but here are my constraints:

20 employees

5-6 different meeting locations (sm1, sm2, sm3, sm4, sm5, sm6) Thes
locations are scattered within our service area.

some employees can only meet at certain locations (ex. paul can meet a
either sm2 or sm3)

all employees are PT so they can only work on certain days or a certai
amount of days per week. (ex. paul can work up to 4 days a week and ji
can work only sat and fri)

I would like to make a program in excel that will take all thes
factors into consideration. EX. if i try to schedule paul on sm4 th
program will not let me do it or it will give a warning or if i try t
schedule paul for 5 days it will give me a warning.
It would also be great to have a counter that will show how many day
each employee has left to be scheduled for, EX: if i scheduled paul fo
2 days it will show that he can actually work 2 days more if i need hi
to.

I know this might be a lot, but i also know there are so many talente
people here so i am sure it is feasible. Please let me know if you kno
how to do this or if you could guide me through it.

or if you know about a different program that can solve this please le
me know
Thanks in advanc

--
henrikj
-----------------------------------------------------------------------
henrikjt's Profile: http://www.excelforum.com/member.php...fo&userid=3567
View this thread: http://www.excelforum.com/showthread.php?threadid=55456