Work schedule help

  • Thread starter Thread starter phoneman
  • Start date Start date
P

phoneman

Hi

I need to create an Excel spreadsheet to manage employee wor
schedules.

Typicaly I have 6 to 10 employees (multiple work locations) that wil
have up to 15 different possible weekly schedules. An example would b
what we refer to as a "D21" trick. During the week the employee i
assigned a "D21" the employee would have monday off and have to wor
saturday.

There are variations in day off and hours worked, we sometimes requir
an employee to work something like 10:30 to 7pm in addition to havin
to work a weekend.

To add insult to injury and even more confusion we have to rotat
holidays yearly so the same employee does not repeat a holiday.

The layout used is typicaly cell A1 to A10 would contain the employee'
name. B1 to B10 the employees hire date. C1 to C10 would be vacatio
weeks allowed off. D1 to D10 and on horizontaly would be the months o
the year broken down by week. I will attach a small example file fo
reference.

My question about this is would it be possible to automate a sprea
sheet to populate "tricks" randomly and evenly without repeatin
holidays? Would it be possible to select the "tricks" that I want t
allow on any given work schedule, maybe by using a check box? Can it b
done in 6 month or 3 month schedules?

I understand the complexity involved may not allow building such a wor
schedule, but it sure would make the job of building the schedule b
hand much easier
 
phoneman said:
Hi

I need to create an Excel spreadsheet to manage employee work
schedules.
Click to expand...

Hi, I think this is a problem to be handled by the Solver add-in,
because it involves variable shifts, restrictions, etc...

You may want to take a look at it.
Regards,
 
Solver ? I have no idea how to use it. Mainly I use excel by performing
manual inputs in data cells and some calculation work
 
Back
Top