Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| التاريخ | الفترة | المادة | كود الفصل | كود اللجنة | كود المراقب | الحالة |
|---|---|---|---|---|---|---|
| 46376 | الأولى | عربي | ف1 | L1 | S01 | سليم |
| 46376 | الأولى | عربي | ف2 | L2 | S02 | سليم |
| 46376 | الأولى | عربي | ف3 | L3 | S03 | سليم |
| 46377 | الأولى | رياضيات | ف1 | L1 | S02 | سليم |
| 46377 | الأولى | رياضيات | ف2 | L2 | S03 | تعارض طالب |
| 46377 | الأولى | حاسب | ف2 | L4 | S06 | تعارض طالب |
| 46377 | الأولى | رياضيات | ف3 | L3 | S04 | سليم |
| 46378 | الأولى | علوم | ف1 | L1 | S03 | سليم |
Example from the “الامتحانات” tab (Arabic), with the numbers and formulas that are in the file.
What is inside
- الفصول (Classes): For each class: code, name and number of students, then the number of its exams recorded and the number of its conflicting exams.
- اللجان (Committees): For each committee: code, name and capacity in seats, then the number of exams in it, the number of duplicate bookings and the number of times capacity is exceeded.
- المراقبون (Invigilators): For each invigilator: code, name and maximum number of sessions. The sheet then shows their number of sessions, what remains of their limit, their status (within limit, over limit or no assignment) and their number of conflicting sessions.
- الامتحانات (Exams): The exams log: date, slot (first or second), subject, class, committee and invigilator. Next to it appear the invigilator's name, the class's students, the committee's capacity, student conflict, committee conflict, invigilator conflict, over capacity, the number of problems and the status.
- الملخص (Summary): The number of exams, how many are valid, and the count of each kind of conflict; the number of invigilators, how many are over the limit or have no assignment, and the highest and lowest number of sessions; then a table of dates that you enter, with each slot's exams, the total and how many have a problem.
The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.
What makes it different
Instead of finding out while you prepare exam papers that a class has two subjects at once, that an invigilator is listed in two committees, or that a committee cannot hold its students, you record the schedule and see every violation in red with its type. From "المراقبون" (Invigilators) you see who is over their limit and who has not been assigned anything, so you can adjust the allocation.
How to use it
- In the "الفصول" (Classes) tab, enter each class's code, name and number of students.
- In the "اللجان" (Committees) tab, enter each committee's code, name and capacity in seats.
- In the "المراقبون" (Invigilators) tab, enter each invigilator's code, name and the maximum number of sessions they can supervise across the whole exam period.
- In the "الامتحانات" (Exams) tab, record each exam on a row: date, slot, subject, class, committee and invigilator.
- Next to each exam the sheet writes its status: valid, or student, committee or invigilator conflict, or over capacity, and colors the offending row red.
- Open "المراقبون" (Invigilators) to see each person's number of sessions and whether they exceeded their limit, then the "الملخص" (Summary) tab for exams on each day and slot and the problems.
Before you start:
- Student conflict = a class listed in more than one exam on the same date and in the same slot, because students of one class cannot sit two exams at once.
- Committee conflict = a committee listed in more than one exam on the same date and slot. Invigilator conflict = an invigilator listed in more than one committee on the same date and slot.
- Over capacity = the class's student count is greater than the capacity of the committee listed for its exam. The sheet compares each class with its committee on each row separately.
- The slot is chosen from the list: "first" or "second". Enter the dates of the days in the Summary cells so that their counts appear.
- What remains of an invigilator's limit = their limit − their number of sessions. A negative number means they are over the limit. An invigilator with no sessions shows the status "no assignment".
- The sheet holds 200 classes, 200 committees, 200 invigilators and 400 exams. The names and numbers in the example are fictional.
Free cheat sheet for this field
Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
What is a student conflict?
The same class is listed in more than one exam on the same date and in the same slot, because students of one class cannot sit two exams at once. The sheet compares the class with the date and slot on every row.
How does the sheet know a committee is too small for a class?
It takes the class's student count from the "الفصول" (Classes) tab and the committee's capacity from the "اللجان" (Committees) tab, and writes "over capacity" if the students outnumber the seats. The comparison is made row by row, so if two classes sit in one committee, check their combined total yourself.
How do I share invigilation fairly?
In "المراقبون" (Invigilators) you read each invigilator's number of sessions and what remains of their limit, and in "الملخص" (Summary) you read the highest and lowest number and the gap between them. Then you move a session from the most loaded to the least loaded by changing the code in the exams log. The sheet does not allocate automatically.
How many exams does it hold?
It holds 400 exams, 200 classes, 200 committees and 200 invigilators. The Summary tab has six date cells, which you can change as you like.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Excel templates for teachers: gradebook, lesson planning and follow-up
More free templates for: Schools and students
More free templates
- Gradebook Template for Excel (Weighted Categories, Letter Grades)
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- School class timetable (Excel)
- Homework and behavior tracker for teachers (Excel)
- School bus subscriptions tracker (Excel)
- University applications tracker (Excel)
- Complete nursery management sheet
- Private school management sheet
- Lending library management sheet
- Graduation project manager sheet: tasks, team, phases and deliverables
- American diploma GPA calculator: unweighted, weighted and cumulative (Excel)
- IGCSE subject tracker with mock scores and target grades (Excel)
- IGCSE past papers log and error tracker (Excel)
- AP, SAT and ACT prep planner (Excel)
- Al-Azhar student grades sheet (Excel)
- Quran memorization and review tracker (Excel)
- Teacher weighted gradebook (Excel)
- Lesson plan and curriculum coverage tracker for teachers (Excel)





