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?