A colloscope is a timetable for a class of 45 students showing when and where each group of three students (numbered 1 to 15) has a "colle" (a 1-hour lesson).
The colloscope provided by my teacher (shown below) was a single Excel spreadsheet, containing information for every group.
This format has a few disadvantages. As a student, it's hard to find the information you need, as this requires searching through the table for the correct group number. The Excel spreadsheet contains a lot of unnecessary information about other groups.
The code from the Colloscope project parses the Excel spreadsheet, stores the information in a database for later use, then generates a personnalized colloscope - one PDF for each group - containing only information that is relevant to the student reading the PDF.
A screenshot of a PDF generated automatically.
This personalized format presents only relevant information, improves readability and spares students the headache of manually searching for their group number through a sprawling spreadsheet.