Spreadsheet: 865255d1712305283-automatic-allocating-schedules-for-classes-to-am-and-pm-brunel-allocations-2024_test
Sheet: Brunel Zig-Zag

 |  |  |  |  | zz1 | zz2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY
 | Brunel | Nationality | Programme | Agent | Student options | Student sold | Options vs sold | Total Students ONLY |  |  | Zig-Zag |  |  |  |  |  |  |  |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
 | Opportunity Name | Group Name | Opportunity      Ref No | Stage | Billing Country | Opportunity Owner | No of students | Start Date | Finish Date | Duration | Week 1 | Start | End | Week 2 | Start | End | Week 3 | Start | End |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Group Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-17 00:00:00 | 2024-06-18 00:00:00 | 2024-06-19 00:00:00 | 2024-06-20 00:00:00 | 2024-06-21 00:00:00 | 2024-06-22 00:00:00 | 2024-06-23 00:00:00 | 2024-06-24 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 2024-06-27 00:00:00 | 2024-06-28 00:00:00 | 2024-06-29 00:00:00 | 2024-06-30 00:00:00 | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 2024-07-03 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-07-06 00:00:00 | 2024-07-07 00:00:00 | 2024-07-08 00:00:00 | 2024-07-09 00:00:00 | 2024-07-10 00:00:00 | 2024-07-11 00:00:00 | 2024-07-12 00:00:00 | 2024-07-13 00:00:00 | 2024-07-14 00:00:00 | 2024-07-15 00:00:00 | 2024-07-16 00:00:00 | 2024-07-17 00:00:00 | 2024-07-18 00:00:00 | 2024-07-19 00:00:00 | 2024-07-20 00:00:00 | 2024-07-21 00:00:00 | 2024-07-22 00:00:00 | 2024-07-23 00:00:00 | 2024-07-24 00:00:00 | 2024-07-25 00:00:00 | 2024-07-26 00:00:00 | 2024-07-27 00:00:00 | 2024-07-28 00:00:00 | 2024-07-29 00:00:00 | 2024-07-30 00:00:00 | 2024-07-31 00:00:00
1 |  |  |  |  |  |  |  |  |  |  | AM |  |  | AM | 2024-07-08 00:00:00 |  | AM
2 |  |  |  |  |  |  |  |  |  |  | PM |  |  | AM |  |  | AM
3 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 | AM | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
4 |  |  |  |  |  |  |  |  |  |  | PM |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
6 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
7 |  |  |  |  |  |  |  |  |  |  | AM |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
9 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
11 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
12 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-05 00:00:00 |  | 2024-07-08 00:00:00 | 2024-07-12 00:00:00
13
70 |  |  |  |  |  |  |  |  |  |  | PM |  |  | PM |  |  | PM
 |  |  |  |  |  | Total Students |  |  |  |  |  | Grand total
 |  |  |  | Student only |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  | TOTAL
 | Students Per Class | 15 |  | Classroom and Teacher requirements |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  | TOTAL
 |  |  |  | Current Teachers Employed
 |  |  |  | AM - Students
 |  |  |  | PM  - Students
 |  |  |  | AM - Classrooms
 |  |  |  | PM  - Classrooms
 |  |  |  | NOT ENOUGH TEACHERS
 |  |  |  | Classroom and Teacher requirements - NON ZIG-ZAG