- pandas
- matplotlib
- openpyxl
- tkinter
To ensure these modules are installed, run the setup.py file.
This python tool renders timetable images from a single .xlsx file. The following constrains apply:
- Requires python3
- Every row of the spreadsheet must be a class/event
- The spreadsheet must start at A1, meaning that the first row must be the column headings
- The Following headings must be present in the spreadsheet (Caps Sensitive!):
- Curriculum Item (aka Subject Code)
- Full Title (aka Subject Name)
- Activity Name (aka class type, e.g. Lecture)
- Start Date
- Start Time
- End Time
- Building Id
- Room Id
- Staff Family Name
- Staff Given Name
- Year
- Study Period - Code
- Study Period - Date
- The third last character of the Room Id must denote the level of the room, e.g. OC203 --> Level 2
The resulting images will be outputted into separated folders, under the output folder. The output folder will be created in the same directory as the selected spreadsheet.
- Download the files setup.py and ttv.pyw. You only need these 2 files.
- Run the python file setup.py to ensure all required modules are installed.
- Run the python file ttv.pyw.
- Follow the prompts to generate your timetable.
Note that if you want to run this code on Linux or macOS, it should be functional if you change the file extension from .pyw to .py.