timetable planner

[petermccallion]

Hi has any body got a timetable planner that includes multiple teachers and rooms etc that can be used for block bookings and day release

 

[Logit]

Here is a project for Banquet Rooms. Edit the format so it references Classrooms.

Internxt Drive – Private & Secure Cloud Storage

 

[Fluff]

@Logit please post your solution to the board as per rule#4

 

[petermccallion]

How am I in breach of rule 4

 

[Fluff]

You're not, that comment was aimed at Logit, which is why I mentioned him in the post.

 

[Logit]

Re: my first Post #2. In an effort to comply with Rule #4 ... here is an image of the main tab.

And a representative formula required for cell E9 :

=1-SUMPRODUCT((Availability!$N$16:$N$1014=E$8)*(Availability!$Q$16:$Q$1014=$B9))