Date-wise Exam Summary Generator

0 Select Pre-Saved Dataset from Academic Folder Repository 🔄 Force Cloud Sync 1-Click Loading

Instead of re-uploading files, choose an Academic Year (AY) and Semester from your repository below to load pre-saved timetables, summary Excel files, and copy-case PRNs automatically!

1. Academic Year (AY):

2. Term / Semester:

3. Exam Type:

4. Exam Dataset Package:

    ─── OR UPLOAD NEW FILES MANUALLY BELOW ───

1 Upload timetable(s) — Word (.docx) or PDF (.pdf) optional Checking OCR Engine...

Upload one Summative-Assessment timetable per regulation/batch (e.g. Regulation 2023, Working Professionals). Supports Word (.docx) and PDF (.pdf).
For each file, set whether it covers Regular or Re-Register / Backlog students, and a short regulation label.

Click or drag .docx / .pdf timetable files here

2 Upload the system-generated summary — Excel (.xlsx)

Upload raw seat/summary exports from your exam system (course code, program, division/module, no. of students, PRN lists, etc.).

Click or drag .xlsx summary files here

3 CRC Report / Copy Case Banned PRNs & Unified Branch Merging optional

Upload a CRC Report (PDF) or paste comma/newline-separated PRNs/Seat numbers (e.g. 125B1G144, 20230104001).
Consolidated Program Naming & Branch Merging: PRNs are sorted alphanumerically and mapped by 6th character: A: Civil, B: Comp, C: CS-AIML, D: Comp-RL, E: E&TC, F: IT, G: Mech, H: VLSI, I: Civil-RL.
For First Year courses, all students of a branch (including FY and DSE) are merged into a single entry First Year Engg.-[Branch] (e.g. First Year Engg.-Comp, First Year Engg.-E&TC). Consolidated PRN blocks prevent fragmented duplicate rows!

A: Civil B: Comp C: CS-AIML D: Comp-RL E: E&TC F: IT G: Mech H: VLSI I: Civil-RL

Click or drag CRC Report (.pdf, .docx, .doc) here

Or paste PRNs / Copy Cases (e.g. 122V1R005:all, 124B1F131:BCE24MD02):

♿ Physically Handicapped (PH) Students

Students listed here will have * appended to their PRNs, highlighted in green in generated reports, and block supervisors will be alerted of their compensatory time allowance.

Physically Handicapped (PH) Students with Names: ⬇️ Download Sample Excel

📁 Upload File

4 Generate

Matches summary rows to timetable exam dates/times by course code, groups date-wise, decodes PRN branch codes (6th char), sorts PRNs alphanumerically, consolidates branch PRNs into unified Program entries, flags CRC banned PRNs with faint red formatting, and builds an official executive Excel workbook.

✓ Official Preview

🎓 Degree / Program:

📅 Year:

⇅ Sort By:

🔍 Search:

Matching & Protection logic: Summary course codes are matched against uploaded timetables in list order. Unmatched codes are safely grouped under "Not Scheduled" rather than dropped.
Consolidated Program Naming & Branch Merging: PRNs are sorted alphanumerically and mapped by 6th character (A: Civil, B: Comp, C: CS-AIML, D: Comp-RL, E: E&TC, F: IT, G: Mech, H: VLSI, I: Civil-RL). For First Year courses, all students of a branch (FY + DSE) merge into First Year Engg.-[Branch].
Strict Program Consolidation: Distinct programs and DSE PRNs are merged into single unified rows and single consolidated PRN blocks per course and date.
CRC Copy Case Handling: Any student PRN present in the CRC Report or manual ban list (e.g. 125B1G144) is formatted with a solid faint red cell background (#FFC7CE), bold red text (#9C0006), and a [BAN/COPY CASE] tag across web preview tables and downloadable Excel sheets.