Spreadsheet: 790030d1659514210-list-of-data-auto-split-based-on-max-number-allowed-in-list-excel-form-test-ans
Sheet: FY 2023 - Classes

Name (First Last) | Classes Needed (Auto Generated) | Week Training  Scheduled |  |  |  |  |  | Current State Last two classes are typed in red  but do not show with current formula |  |  |  |  | [NAME] to make this view [NAME] should only show class name again if first one is full with [NAME] of 15 students |  |  |  |  |  | [NAME] to make this view [NAME] should only show class name again if first one is full with [NAME] of 15 students
Colleague 1 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  | Class Name |  | Class 2 | Class 1 | Class 2 |  | Class 1 | Class 2 | Class 1 | Class 2 |  |  | Class 1 | Class 2 | Class 1 | Class 2
Colleague 2 | Class 3, Class 2 | 2022-08-08 00:00:00 |  | Week Of | 2022-08-08 00:00:00 |  | Date of Class | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 |  | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00 |  |  | 2022-08-08 00:00:00 | 2022-08-09 00:00:00 | 2022-08-10 00:00:00 | 2022-08-11 00:00:00
Colleague 3 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Colleague 1 | Colleague 1 | Colleague 16 | Colleague 16
Colleague 4 | Class 1, Class 2 | 2022-08-08 00:00:00 |  | Class List | Class 1 |  |  | Colleague 3 | Colleague 2 | Colleague 3 | Colleague 2 |  | Colleague 3 | Colleague 2 | Colleague 18 | Colleague 17 |  |  | Colleague 2 | Colleague 2 | Colleague 17 | Colleague 17
Colleague 5 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  | Class 2 |  |  | Colleague 4 | Colleague 3 | Colleague 4 | Colleague 3 |  | Colleague 4 | Colleague 3 | Colleague 19 | Colleague 18 |  |  | Colleague 3 | Colleague 3 | Colleague 18 | Colleague 18
Colleague 6 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 5 | Colleague 4 | Colleague 5 | Colleague 4 |  | Colleague 5 | Colleague 4 | Colleague 20 | Colleague 20 |  |  | Colleague 4 | Colleague 4 | Colleague 19 | Colleague 19
Colleague 7 | Class 1, Class 2 | 2022-08-08 00:00:00 |  | These cells classes are changed for verification. |  |  |  | Colleague 6 | Colleague 5 | Colleague 6 | Colleague 5 |  | Colleague 6 | Colleague 5 | Colleague 21 | Colleague 21 |  |  | Colleague 5 | Colleague 5 | Colleague 20 | Colleague 20
Colleague 8 | Class 1, Class 2 | 2022-08-08 00:00:00 |  | Result is OK.Collegue2 not included in Class1 list. |  |  |  | Colleague 7 | Colleague 6 | Colleague 7 | Colleague 6 |  | Colleague 7 | Colleague 6 | Colleague 22 | Colleague 23 |  |  | Colleague 6 | Colleague 6 | Colleague 21 | Colleague 21
Colleague 9 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 8 | Colleague 7 | Colleague 8 | Colleague 7 |  | Colleague 8 | Colleague 7 | Colleague 23 | Colleague 24 |  |  | Colleague 7 | Colleague 7 | Colleague 22 | Colleague 22
Colleague 10 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 9 | Colleague 8 | Colleague 9 | Colleague 8 |  | Colleague 9 | Colleague 8 | Colleague 24 | Colleague 25 |  |  | Colleague 8 | Colleague 8 | Colleague 23 | Colleague 23
Colleague 11 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 10 | Colleague 9 | Colleague 10 | Colleague 9 |  | Colleague 10 | Colleague 9 | Colleague 25 | Colleague 26 |  |  | Colleague 9 | Colleague 9 | Colleague 24 | Colleague 24
Colleague 12 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 11 | Colleague 10 | Colleague 11 | Colleague 10 |  | Colleague 11 | Colleague 10 | Colleague 26 | Colleague 27 |  |  | Colleague 10 | Colleague 10 | Colleague 25 | Colleague 25
Colleague 13 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 12 | Colleague 11 | Colleague 12 | Colleague 11 |  | Colleague 12 | Colleague 11 | Colleague 27 | Colleague 28 |  |  | Colleague 11 | Colleague 11 | Colleague 26 | Colleague 26
Colleague 14 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 13 | Colleague 12 | Colleague 13 | Colleague 12 |  | Colleague 13 | Colleague 12 | Colleague 28 | Colleague 29 |  |  | Colleague 12 | Colleague 12 | Colleague 27 | Colleague 27
Colleague 15 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 14 | Colleague 13 | Colleague 14 | Colleague 13 |  | Colleague 14 | Colleague 13 | Colleague 29 |  |  |  | Colleague 13 | Colleague 13 | Colleague 28 | Colleague 28
Colleague 16 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 15 | Colleague 14 | Colleague 15 | Colleague 14 |  | Colleague 15 | Colleague 14 |  |  |  |  | Colleague 14 | Colleague 14 | Colleague 29 | Colleague 29
Colleague 17 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 16 | Colleague 15 | Colleague 16 | Colleague 15 |  | Colleague 16 | Colleague 15 |  |  |  |  | Colleague 15 | Colleague 15
Colleague 18 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 17 | Colleague 16 | Colleague 17 | Colleague 16
Colleague 19 | Class 1, Class 4 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 18 | Colleague 17 | Colleague 18 | Colleague 17
Colleague 20 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 19 | Colleague 18 | Colleague 19 | Colleague 18
Colleague 21 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 20 | Colleague 20 | Colleague 20 | Colleague 20
Colleague 22 | Class 1, Class 5 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 21 | Colleague 21 | Colleague 21 | Colleague 21
Colleague 23 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 22 | Colleague 23 | Colleague 22 | Colleague 23
Colleague 24 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 23 | Colleague 24 | Colleague 23 | Colleague 24
Colleague 25 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 24 | Colleague 25 | Colleague 24 | Colleague 25
Colleague 26 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 25 | Colleague 26 | Colleague 25 | Colleague 26
Colleague 27 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 26 | Colleague 27 | Colleague 26 | Colleague 27
Colleague 28 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 27 | Colleague 28 | Colleague 27 | Colleague 28
Colleague 29 | Class 1, Class 2 | 2022-08-08 00:00:00 |  |  |  |  |  | Colleague 28 | Colleague 29 | Colleague 28 | Colleague 29
 |  |  |  |  |  |  |  | Colleague 29 |  | Colleague 29