📘 AI Based Time Table Generation System (Python)

This Python project automates college timetable generation using Excel input files that define courses, instructors, and lab details. It smartly assigns lecture and lab slots while avoiding clashes between instructors, semesters, and lab rooms. Finally, it exports all generated timetables and allocation summaries into a neatly formatted Excel workbook.

---

🚀 Features

• 📂 Excel-based input for easy data entry (courses, instructors, semesters, labs)
• 🧠 Automatic scheduling of lectures and labs with time clash detection
• 🔁 Support for combined classes across semesters
• 🧑‍🏫 Instructor-wise, semester-wise, and lab-wise timetable generation
• 💾 Exports results to a single, well-structured Excel file
• 🪄 Interactive GUI using Tkinter for file upload and output naming

---

🧩 Tech Stack

• Python 3.8+
• Pandas – Data processing and manipulation
• OpenPyXL – Excel file creation and editing
• Tkinter – Simple GUI for file dialogs and user input
• Regex (re) – Parsing course types and formats

---

📁 Input Excel Format

Your Excel file should contain the following columns in each semester sheet:

Branch	Course	Course Instructor	Course Type	Lab Type (optional)	Combined With (optional)
CSE	Data Structures	Dr. Rao	3L+2H	CS Lab	Sem5_ECE
ECE	Digital Logic	Prof. Sharma	3L

There can also be a separate sheet named "Professors" (optional).

---

⚙️ How It Works

1. Upload your Excel file when prompted.
2. The script reads and validates all semester data.
3. It automatically assigns lecture and lab slots while avoiding conflicts.
4. A final Excel file is generated containing:
   • 🗓 Semester timetables
   • 👨‍🏫 Instructor timetables
   • 🧪 Lab timetables
   • ✅ Course scheduling status

---

💡 Example Output

Excel Sheets Generated:

• TT-Sem-Sem3_CSE
• TT-Inst-Dr. Rao
• TT-Lab-CS Lab
• Sem3_CSE (Course Summary)

git clone https://github.com/your-username/timetable-generator.git cd timetable-generator