How does the spreadsheet find conflicts?

For each class it counts how many log rows match it by day and slot for the same teacher, in the same room and for the same group. If there is more than one, the row turns red and the "Check" column says what exactly is busy.

How do I get the timetable of a group or teacher?

On the "Grid" sheet, choose in the drop-down list whom to show and specify the group or surname. The weekly grid is built from the log automatically.

How is workload calculated?

Hours = the teacher's number of classes per week × academic hours per class (2 by default). This is compared with the quota: above 100% is overload, below the threshold is underload.

Can I change the class times?

Yes. The slot times are set on the "Lists" sheet and are filled into the log and the grid automatically. It works for a school bell schedule as well as for college periods.

← All templates

Class Timetable and Teacher Workload — Excel Template

Timetable log with automatic conflict checks, a weekly grid by group or teacher, and workload in hours against each teacher's quota.

≈ $4.89

390 ₽

Blank template + filled-in example · Excel 2007+, LibreOffice, Google Sheets

Payment is processed securely by YooKassa in Russian rubles. If your card is declined, email us at info@хижняков.рф and we will arrange another way to pay.

What it is for

A timetable at a school, college, training center or club often lives in several files, and clashes are found on Monday morning. Here each class is entered as a row from drop-down lists: the spreadsheet immediately shows that a teacher, room or group is busy, builds a weekly grid and calculates each teacher's hours against their quota.

What is inside

"Lists": teachers with a quota in hours per week, groups, rooms, subjects, class times (slots), workload settings.
"Classes": up to 800 classes: day, slot, group, subject, teacher, room; time, hours and a conflict check with highlighting and a text message.
"Grid": a weekly grid for the selected group or teacher, built from the log with formulas and ready to print.
"Workload": weekly hours per teacher against their quota, load percentage, overload, classes by day, two charts.

Who it is for

Heads of studies and deputy principals, academic coordinators at colleges and training centers, administrators of language schools, studios and clubs, tutoring centers, and anyone who builds a timetable in Excel by hand.

What you get

The package contains a blank spreadsheet and a filled-in sample with fictional data, so you can see how the formulas and checks work. It is a spreadsheet built on ordinary formulas, not accounting software. All fixes and new versions of the project are free.

Compatibility

Excel 2007 and later, LibreOffice. No macros. The file is in English. Thresholds and quotas are kept in the lists: check them against your own policies before use. The calculation is approximate.

📘 How to Make a Class Timetable in Excel and Calculate Teacher Workload

Questions and answers

How does the spreadsheet find conflicts?: For each class it counts how many log rows match it by day and slot for the same teacher, in the same room and for the same group. If there is more than one, the row turns red and the "Check" column says what exactly is busy.
How do I get the timetable of a group or teacher?: On the "Grid" sheet, choose in the drop-down list whom to show and specify the group or surname. The weekly grid is built from the log automatically.
How is workload calculated?: Hours = the teacher's number of classes per week × academic hours per class (2 by default). This is compared with the quota: above 100% is overload, below the threshold is underload.
Can I change the class times?: Yes. The slot times are set on the "Lists" sheet and are filled into the log and the grid automatically. It works for a school bell schedule as well as for college periods.