Using Excel as a scheduling program.
 

I'm looking for a way to use excel to take a lot of the headache out
of scheduling rehearsals for the theatre company I work for.
Basically, I have a list of variables that I would like to enter in,
and then let the computer sort it out for me- I'm not sure if Excel
can even do this, but it seems to me it would be pretty simple
operation for a computer to figure out!

For example, let's say I have this sort of list of variables.

TIME variables
I have 8 days that I can rehearse
I have 10 hours every day that are available for rehearsal.
Rehearsals need to be at least 2 hours in length
Before and after any rehearsal block, there needs to be a 15 minute
break
There needs to be a 1 hour break for lunch and a one hour break for
dinner

SPACE variables
There are 3 spaces available for rehearsing in.
Each of the 3 spaces has certain blocks of time that are unavailable
for use.
Only one group may rehearse in each space at one time.

GROUP & PEOPLE VARIABLES
There are 15 people involved
There are 9 different groups
Each group has at least 3 people in it
Each person is involved in at least 2, maybe 3 of the groups
Some people will have times that are unavailable, outside of their
rehearsal times (i.e. Jimmy will have a doctor's appointment at 3pm
on Tuesday and will be unavailable)
People cannot rehearse in more than one group at the same time.
People may not need to show up for the entire rehearsal block.
Each group must have either a. an equal amount of time or b. a
predetermined amount of time

Any ideas?
Thanks!
Tyler