how to use the RMUTT Merged Class Schedule Builder:
Click the dashed box (or drag & drop) and select one or more .docx and/or .xlsx files.
Each file gets read automatically. You'll see a table appear listing:
Subject, Group, Instructor, Room — auto-detected where possible
Rows — how many schedule rows were found
Status — Ready / Check / Error
Every field in that table is an editable text box. If a Subject, Instructor, etc. wasn't detected correctly (templates vary a lot), just click into the box and type the correct value — it'll be used for that file's rows in the merge.
In section 2, tick/untick the columns you want in the final merged table (Hours, Subject, Topic, Level, Instructor, Room, Group, Source file). Date and Time are always included since they drive the sort order.
Click "⚙ Merge & sort table". It combines every subject from every uploaded file into one list, sorted by date → start time, and shows a live preview plus quick stats (total rows / subjects / hours).
⬇ Export Excel (.xlsx) — downloads a spreadsheet with only your selected columns.
⬇ Export Word (.docx) — downloads a formatted Word table (navy header, bordered, landscape) with the same data.
🗑 Clear all wipes everything so you can start a fresh batch.