# 1. Making of initial data file

Initial data file is created with MS Excel and saved in "XML" format. We prepare initial data file by instructions or by this template. The instructions follows:
1 page (Sheet1) | "Subjects" is the name of page 1.

Visual explanations:

In the page 1 Subjects are listed in column "A" . Groups of subjects are in column "B". Priority of subjects are in column "C". Max number of pupils are in column "D".
Both subjects and groups are in short symbols. For example, symbol "Mat" means mathematics and symbol "Inf" means informatics.
The Subject symbols are used in teacher list (Sheet2) and in all student classes.
Here is the meaning of different Group symbols:

- symbol "e " denotes a group of choice subjects. For example, group "e1" includes three subjects: Religion (T), Ethic (E) and Psychology (Ps), group "e2" includes four foreign languages. A student must select one and only one subject from this list.
- symbol "but" means necessary curriculum subjects.
- symbol "pas" denotes groups of free subjects. For example, student can choose Biology (Biol), Chemistry (Chem), Geography (Geo) and/or History (Ist). A student can choose any subset of this group.

The Priority numbers shows how difficult subject is. Most difficult subjects had priority "5" and should be teached in first part of pupils day. Most easiest subject has priority "1".
The Maximal number of pupils in the lesson shows how many pupils can be in one group during named lesson.

Example:

2 page (Sheet2) | "Teachers" is the name of page 2.
Visual explanations:

In the page 1 ordinal numbers of groups are in column "A". Ordinal numbers of teachers are in column "B. Full names of subjects are in column "C". Column "D" contains full names of teachers, column "E" includes class-room numbers, column "F" shows number of weekly working hours for teachers, column "G" is a list of of subject symbols, column "H" describes names of all classes for teachers, column "I" is a list of free days wanted by teachers.

Here is a detailed guideline how to fill the page 2:

- Groups – user can fill this column as he wants. Teachers can be grouped by subjects, by choises, by last names, etc. The grouping is for visual search in this list.
- Nr. – ordinal numbers of teachers.
- Subject – full names of all subjects separated be semicolons for teachers. For example, "English; German", etc. "Mathematics; Informatics"" , etc. All subject names are permanent, the same in all tables for all teachers and students.
- Lastname_Name – this column is self-explanatory.
- Room – ordinal numbers of classrooms for teachers. If teacher don't has own room, here can be writen all rooms where he can work. For example "102;114;115;" etc. Different rooms for different subjects of the same teacher are separated by the symbol #, for example, "112;113; #219;220;".
- Hour – maximal number of weekly hours for teachers' subjects. Numbers for different subjects are separated by semicolons. For example, "15;8;5;" etc.
- Short – subjects' symbols separated by semicolon for teachers, the same as in the page 1. For example, "Biol;Chem", etc.
- Teacher classes – symbols of classes separated by semicolons for teachers, the same as in the page 1. For example, "11a; 11b; 12a; 12b; 12d; 12e;". Different subjects of the same teacher are separated by the symbol #, for example, "11c; 12a; # 11a; 11b; 12e;". The classes mean groups of students united by common choice of subjects. In theory, a class could be a single student.
- Free days – ordinal numbers of free days wanted by teachers. For example: "3;4;" means that teacher wants to be free on Wednesday and Thursday.

Example:
3 page (Sheet3) | Name of this page must to be same as class symbol. For example "11a", "12g", etc. All sheets starting by this one represent choices of students belonging to different classes. A class sheet contain names of students and their choices (subjects and hours). The last sheet is the "template".
Visual explanations:
A class sheet can be created by the "Template". We just copy this template for every class sheet and fill it by class student choices. That saves time. We can select new subject symbols and save them in the template. Note that the symbols in all sheet's must to be same. The column "Sum" shows hours per week for each student. This column calculates everything automatically.
Example: