Scedule or Timeline

T

Tuzi

I am trying to create a schedule for a year of classes. There are thre
locations to track. There are two formats for the classes: Format
(F1) is every other week for 18 weeks total. Format2 (F2) is every wee
for 20 weeks.

I have tried some timeline templates, but it does not allow for th
week-off between the classes in format1. I need to be able to schedul
the instructor in another class on the weeks off between.

MIA-F1
MIA-F1 (in the off week of the class above)

I was planing to list every week for the year in one worksheet, and se
a clear schedule in another. Of course I would like to take advantag
of colors for class type. Anyone have an idea how to do this
 
S

Spencer101

Tuzi;1610541 said:
I am trying organize a complicated class schedule for instructors.
There are multiple types of classes T1, T2, T3 Each with their ow
schedule (see below). I have a spreadsheet that lists all of the day
of the year across the top starting with column E. In the next row
indicate the Type in column C, and the Start Date in the column D.
need a formula that looks at the Type, looks at Start Date and places a
X in the days whene the class is in session.

T1 = Mon-Sat for 16 weeks, every other week (Mon thru Sat On, Sun thr
Sun Off, Repeat for 9 weeks)
T2 = Mon-Thu for 20 weeks
T3 = Mon-Fri for 2 weeks

Any Idea how to write this?

Could you post an example workbook showing what you want it to look lik
AFTER
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top