RTAI Class Attendance Generator

how to use the RMUTT Attendance & Schedule Generator:

1. Prepare your files

You need 3 files:

File Requirement

Excel data file (.xlsx) Must contain 3 sheets: Course_Info, Schedule, Students

Attendance template (.docx) Must contain a table whose header cell says "No." (this is where student rows get added)

Class schedule template (.docx) Must contain a table whose header row includes "WEEK" (this is where weekly rows get added)

Both templates should use placeholders like {{SUBJECT}}, {{GROUP}}, {{WEEK}}, {{DATE}}, {{TOPIC}}, etc. — these get replaced automatically.

2. Upload the 3 files

Click each of the three upload boxes (labeled Step 01 / 02 / 03) and select the matching file. A green checkmark + filename shows once it's loaded.

3. Generate

Click "⚡ เริ่มสร้างเอกสารทั้งหมด" (Start Generating All Documents). Progress and status show live in the dark "Flight Log" console at the bottom.

4. Download

When finished, a Download ZIP button appears. The ZIP contains:

• One Attendance_Record_Week_XX_...docx per week that has a value in the Excel WEEKS column

• One Class_Schedule_...docx with the full course schedule

Unzip it and open the files normally in Microsoft Word.