Expected columns: Teacher Name, Day, 1st IP, 2nd IP, 3rd IP, 4th IP, Lunch Break, 5th IP, 6th IP, 7th IP, 8th IP. Free, FREE, free, blank and - are all treated as free periods. Multiline class names are preserved.
No Excel file uploaded yet.
0Rows Loaded
0Teachers
0Days
0FREE Cells
0NOT AVAILABLE
$ inspect --schema
Upload your Excel file to see the detected sheet and columns.
$ verify --src
Upload an Excel file to start validation.
$ cat verify.log
$ head -n 60 data
No timetable loaded.
$ set --flags absent
A teacher can have only one absence type: Full Day (1stβ8th), First Half (1stβ4th) or Second Half (5thβ8th). Duties are generated only for the selected range. An absent teacher is never given a substitution duty.
Full Day Absent
1st to 8th IP
Select a day first.
First Half Day Absent
1st to 4th IP
Select a day first.
Second Half Day Absent
5th to 8th IP
Select a day first.
No teachers selected.
$ set --flags exam,extra
Select the teacher and tick the IPs. In those IPs the teacher is busy, so the teacher gets a column in the Duty Chart and a substitute is arranged for their class (the teacher is orange in the chart). If their class in that IP is X or XII, no substitute is needed. Free and Lunch IPs also need no substitute. Busy teachers are never given a substitution duty in their own busy IPs, but can take duties in their other free IPs. In an IP where someone is on Examination Duty, teachers who are not on exam duty and have class X or XII become free and are eligible for substitution. A teacher can be added to both Examination Duty and Extra Class. Adding the same teacher again updates their IPs.
Examination Duty
Select teacher and IPs (1st to 5th)
Extra Class
Select teacher and IPs (6th to 8th)
$ set --params date,day
Select the date and day for the substitution arrangement.
$ exec --auto
stdout: waiting for params. Opening [5] triggers auto-run.
↔ Many columns? Scroll sideways / down inside the chart box. The IP column and teacher headings stay fixed.
stdout: (empty)
$ out --render
Make any corrections in Tab 5 first, then click refresh.
stdout: (empty)
$ ls -t cache | head -5
Last 5 snapshots are cached in this browser. Load one, correct it in Tab 5, and save it again.
$ transfer --between-computers
Why this is needed: saved snapshots (Tab 7) live only inside the browser of one computer. To continue on another computer, export a file here, carry it across, and import it there.
Computer 1: make the chart in Tab 5 → come here → click export current chart → a .json file downloads. Move the file to Computer 2 (pen drive, email, WhatsApp, Google Drive). Computer 2: open this same HTML page → come here → click import file... → choose the file. The chart opens in Tab 5, ready to correct, lock, print, PDF or save again.