Guidelines
to write files for the University Timetables Maker Software (UTM)
--------
1) Rename the template (UTM-2.xlsx) to :
OLD-Mech-L6-Block1-G2.xslx
Each part of the file name gives info for the software.
OLD- If the file is for the old curriculum – it should be omitted for the new curriculum.
Mech / Civil / Elec Department name.
L6-Block1 is the level number and the block number.
- and G1 is the group number (section number).
2) Use the template and don’t create your own files.
3) Place only one group from the level in each file i.e. Don’t place other tables in another sheet of the same file.
Lectures are placed at the first group and don’t repeat it again, in case you will divide the lecture then place the second lecture group in separate file. Say we have two groups of lectures and four sections then.
1st file contains lecture_1 + section_1 2nd file contains section_2
3rd file contains lecture_2 + section_3 4th file contains section_4
4) Fill in the cells according to the file key (Nr. Of students / Hall name / Course ID / Course Name / Prof. ID / Prof. Name). (Course Name / Prof. Name) will be detected by the software.
5) Don’t insert rows or columns if you do so then you are not on the right way.
6) The courses list stored in the software data base are written in columns S and T with their codes make sure that your course code is correct.
7) The course code bears other important information which are the group number and if it is lecture of practice:
Hints:
803224-3 Lecture and there is no other groups
803224-3-G1 Lecture of group 1
803224-3-P Practice and there is no other groups
803224-3-G2-P Practice for group 2
Downloads:
--------------------
University Time Tables Software