I know this may be too complex for excel but I was wondering if anyone has
any experience with doing shift scheduling in excel.

I work for a police department. It seems the scheduling bid is always a huge
hassle. So I was wondering if there is a way to plug the bids into excel and
get a nice clean schedule.

What I would need is a way to input each officer and the shfits they would
prefer to work. Assign each a priority. Distribute those officers on the SWAT
team between the shifts. then ensure adequate coverage. Any ideas?

Excel is probably not the best platform to do what you want. But to give you
some ideas, have a look at this site. There are some templates you can
download which are free.

Hope helpful

http://www.vertex42.com/ExcelTemplat...-template.html
http://www.vertex42.com/ExcelTemplat...-schedule.html
--
jb


"MattB" wrote:

I know this may be too complex for excel but I was wondering if anyone has
any experience with doing shift scheduling in excel.

I work for a police department. It seems the scheduling bid is always a huge
hassle. So I was wondering if there is a way to plug the bids into excel and
get a nice clean schedule.

What I would need is a way to input each officer and the shfits they would
prefer to work. Assign each a priority. Distribute those officers on the SWAT
team between the shifts. then ensure adequate coverage. Any ideas?