Using Excel to make a work schedule

[turkishtommy]

Hi, I'm (sadly) completely new to this forum and mostly new to Excel.

I need to set up a work schedule for 14 people, who rotate between different clinics each week. I would like to use excel to automate the process, rather than picking and choosing who should go where. There are certain parameters that need to be met (equal number of days off per week, only certain people can work in certain spots).

I know this is elementary, but I really have no idea how to get started, and would appreciate any help! Thanks in advance.

The schedule looks like this:

\1