Spreadsheet: 841579d1693750568-excel-formula-to-automatically-create-a-class-schedule-excel_class_schedule_example
Sheet: CS

1 | ELY |  |  |  |  | 2 |  | LISA |  |  |  | 3 | MAX |  |  |  |  | 4 | EMA
Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday
08:00 – 08:45 | German | German | German | German | German | 08:00 – 08:45 | Maths | Maths | Maths | Maths | Maths | 08:00 – 08:45 | Englisch | Englisch | Englisch | Englisch | Englisch | 08:00 – 08:45 | Italian | Italian | Italian | Italian | Italian
1. Class | I | II | III | IV | I | 1. Class | II | III | IV | I | II | 1. Class | IV | I | II | III | IV | 1. Class | III | IV | I | II | III
8:50 – 9:35 | German | German | German | German | German | 8:50 – 9:35 | Maths | Maths | Maths | Maths | Maths | 8:50 – 9:35 | Englisch | Englisch | Englisch | Englisch | Englisch | 8:50 – 9:35 | Italian | Italian | Italian | Italian | Italian
2. Class | II | III | IV | I | II | 2. Class | III | IV | I | II | III | 2. Class | I | II | III | IV | I | 2. Class | IV | I | II | III | IV
Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast
09:55 – 10:40 | German | German | German | German | German | 09:55 – 10:40 | Maths | Maths | Maths |  | Maths | 09:55 – 10:40 | Englisch | Englisch | Englisch | Englisch | Englisch | 09:55 – 10:40 | Italian | Italian | Environment |  | Italian
3. Class | III | IV | I | II | III | 3. Class | IV | I | II |  | IV | 3. Class | II | III | IV | I | II | 3. Class | I | II | III |  | I
10:45 – 11:30 | German | German | German |  | German | 10:45 – 11:30 | Maths | Maths |  |  | Maths | 10:45 – 11:30 | Englisch | Englisch |  |  | Englisch | 10:45 – 11:30 | Italian | Italian |  | Environment
4. Class | IV | I | II |  | IV | 4. Class | I | II |  |  | I | 4. Class | III | IV |  |  | III | 4. Class | II | III |  | I
Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch
12:15 – 13:00 |  |  |  | German |  | 12:15 – 13:00 | Musik | Musik | Maths | Maths |  | 12:15 – 13:00 |  |  |  |  |  | 12:15 – 13:00 |  | Environment | Italian |  | Environment
5. Class |  |  |  | III |  | 5. Class | I | II | III | IV |  | 5. Class |  |  |  |  |  | 5. Class |  | III i IV | IV |  | II
13:05 – 13:50 |  |  | Practicing |  |  | 13:05 – 13:50 | Musik |  |  | Maths |  | 13:05 – 13:50 |  |  |  |  |  | 13:05 – 13:50 |  | Environment |  | Environment | Environment
6. Class |  |  | III i IV |  |  | 6. Class | III i IV |  |  | III |  | 6. Class |  |  |  |  |  | 6. Class |  | II |  | IV | I
13:55 – 14:40 | Practicing | Practicing | Practicing |  |  | 13:55 – 14:40 |  |  |  |  |  | 13:55 – 14:40 |  |  |  | Practicing | Practicing | 13:55 – 14:40
7. Class | III i IV | III i IV | III i IV |  |  | 7. Class |  |  |  |  |  | 7. Class |  |  |  | III i IV | III i IV | 7. Class
Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack
Class Schedule     1. Klasse     IDSS     School Year 2023/2024 |  |  |  |  |  | Class Schedule     2. Klasse     IDSS     School Year 2023/2024 |  |  |  |  |  | Class Schedule     3. Klasse     IDSS     School Year 2023/2024 |  |  |  |  |  | Class Schedule     4. Klasse     IDSS     School Year 2023/2024
Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday
08:00 – 08:45 | German | Englisch | Italian | Maths | German | 08:00 – 08:45 | Maths | German | Englisch | Italian | Maths | 08:00 – 08:45 | Italian | Maths | German | Englisch | Italian | 08:00 – 08:45 | Englisch | Italian | Maths | German | Englisch
1. Class | ELY | MAX | EMA | LISA | ELY | 1. Class | LISA | ELY | MAX | EMA | LISA | 1. Class | EMA | LISA | ELY | MAX | EMA | 1. Class | MAX | EMA | LISA | ELY | MAX
8:50 – 9:35 | Englisch | Italian | Maths | German | Englisch | 8:50 – 9:35 | German | Englisch | Italian | Maths | German | 8:50 – 9:35 | Maths | German | Englisch | Italian | Maths | 8:50 – 9:35 | Italian | Maths | German | Englisch | Italian
2. Class | MAX | EMA | LISA | ELY | MAX | 2. Class | ELY | MAX | EMA | LISA | ELY | 2. Class | LISA | ELY | MAX | EMA | LISA | 2. Class | EMA | LISA | ELY | MAX | EMA
Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast
09:55 – 10:40 | Italian | Maths | German | Englisch | Italian | 09:55 – 10:40 | Englisch | Italian | Maths | German | Englisch | 09:55 – 10:40 | German | Englisch | Environment | Sport | German | 09:55 – 10:40 | Maths | German | Englisch | Sport | Maths
3. Class | EMA | LISA | ELY | MAX | EMA | 3. Class | MAX | EMA | LISA | ELY | MAX | 3. Class | ELY | MAX | EMA | MAYA | ELY | 3. Class | LISA | ELY | MAX | MAYA | LISA
10:45 – 11:30 | Maths | German | Art | Environment | Maths | 10:45 – 11:30 | Italian | Maths | German | Ethics | Nature | 10:45 – 11:30 | Englisch | Italian | Ethics | Sport | Englisch | 10:45 – 11:30 | German | Englisch | Ethics | Sport | German
4. Class | LISA | ELY | MELANY | EMA | LISA | 4. Class | EMA | LISA | ELY | ANITA | ANITA | 4. Class | MAX | EMA | ANITA | MAYA | III | 4. Class | ELY | MAX | ANITA | MAYA | ELY
Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch
12:15 – 13:00 | Musik | Ethics | Art | Sport | Nature | 12:15 – 13:00 | Art | Musik | Nature | Sport | Environment | 12:15 – 13:00 | Nature | Environment | Maths | German | Art | 12:15 – 13:00 | Nature | Environment | Italian | Maths | Art
5. Class | LISA | ANITA | MELANY | MAYA | ANITA | 5. Class | MELANY | LISA | ANITA | MAYA | EMA | 5. Class | ANITA | EMA | LISA | ELY | MELANY | 5. Class | ANITA | EMA | EMA | LISA | MELANY
13:05 – 13:50 | Nature | Practicing | Practicing | Sport | Environment | 13:05 – 13:50 | Art | Environment | Practicing | Sport | Practicing | 13:05 – 13:50 | Musik | Nature | Practicing | Maths | Art | 13:05 – 13:50 | Musik | Nature | Practicing | Environment | Art
6. Class | ANITA | MELANY | MELANY | MAYA | EMA | 6. Class | MELANY | EMA | ANITA | MAYA | ANITA | 6. Class | LISA | ANITA | ELY | LISA | MELANY | 6. Class | LISA | ANITA | ELY | EMA | MELANY
13:55 – 14:40 | Practicing | Practicing | Practicing | Practicing | Practicing | 13:55 – 14:40 | Practicing | Practicing | Practicing | Practicing | Practicing | 13:55 – 14:40 | Practicing | Practicing | Practicing | Practicing | Practicing | 13:55 – 14:40 | Practicing | Practicing | Practicing | Practicing | Practicing
7. Class | MELANY | MELANY | MELANY | MELANY | MELANY | 7. Class | ANITA | ANITA | ANITA | ANITA | ANITA | 7. Class | ELY | ELY | ELY | MAX | MAX | 7. Class | ELY | ELY | ELY | MAX | MAX
Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack
5 | ANITA |  |  |  |  | 6 | MELANY |  |  |  |  | 7 | MAYA
Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday | Time | Monday | Tuesday | Wednesday | Thuersday | Friday
08:00 – 08:45 |  |  |  |  |  | 08:00 – 08:45 |  |  |  |  |  | 08:00 – 08:45
1. Class |  |  |  |  |  | 1. Class |  |  |  |  |  | 1. Class
8:50 – 9:35 |  |  |  |  |  | 8:50 – 9:35 |  |  |  |  |  | 8:50 – 9:35
2. Class |  |  |  |  |  | 2. Class |  |  |  |  |  | 2. Class
Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast | Small Break | Breakfast | Breakfast | Breakfast | Breakfast | Breakfast
09:55 – 10:40 |  |  |  |  |  | 09:55 – 10:40 |  |  |  |  |  | 09:55 – 10:40 |  |  |  | Sport
3. Class |  |  |  |  |  | 3. Class |  |  |  |  |  | 3. Class |  |  |  | III i IV
10:45 – 11:30 |  |  | Ethics | Ethics | Nature | 10:45 – 11:30 |  |  | Art |  |  | 10:45 – 11:30 |  |  |  | Sport
4. Class |  |  | III i IV | II | II | 4. Class |  |  | I |  |  | 4. Class |  |  |  | III i IV
Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch | Long Break | Lunch | Lunch | Lunch | Lunch | Lunch
12:15 – 13:00 | Nature | Ethics | Nature |  | Nature | 12:15 – 13:00 | Art |  | Art |  | Art | 12:15 – 13:00 |  |  |  | Sport
5. Class | III i IV | I | II |  | I | 5. Class | II |  | I |  | III i IV | 5. Class |  |  |  | I i II
13:05 – 13:50 | Nature | Nature | Practicing |  | Practicing | 13:05 – 13:50 | Art | Practicing | Practicing |  | Art | 13:05 – 13:50 |  |  |  | Sport
6. Class | I | III i IV | II |  | II | 6. Class | II | I | I |  | III i IV | 6. Class |  |  |  | I i II
13:55 – 14:40 | Practicing | Practicing | Practicing | Practicing | Practicing | 13:55 – 14:40 | Practicing | Practicing | Practicing | Practicing | Practicing | 13:55 – 14:40
7. Class | II | II | II | II | II | 7. Class | I | I | I | I | I | 7. Class
Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack | Long Break | Snack | Snack | Snack | Snack | Snack