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?