Different types of reports

[llbuenoo]

I would like to generate a report that show the teachers and theirs restrictions (mainly the "Teachers not available times") and Activities related to the years (with its Groups and subgroups), in a way that I can better manage the distribution of the teachers activities according to their availability.

I have been making this by hand, but it generates a lot of work on each manual iteration on the timetable. As the data is stored on the FET database, it could be generated directly by the program.

I think in a pair of tables per year, one with the teachers and their activities in that year and another with the "teachers not available time" for that year.

With this table it could be simpler to redistribute Activities or teachers.

Thank you for the great program

[Volker Dirr]

"Teachers not available times" is already printed in the "teachers free periods" timetable. you can hide the other information there by sytling/hiding in the css file.

i am not sure why you want to use the "Activities related to the years", but maybe just:
a) ... check the activity planning in fet

or

b) ... save data with an other name (just to keep your data). and delete all other years, just keep the needed one.
Now ...
...1) simply print a timetable
or 2) save and check the fet or xml file
or 3) export as csv and check that file

[llbuenoo]

The idea behind this kind of report is to identify possible locks in the relationship between the "Teachers not available times" and the activities of each teacher in a given year.

This information is important to our institution because we have many teachers that have other jobs and we need to adjust their availability to the activities. Some situations can be only seen with this kind of data crossing.

I have inserted all the data in the program, but it can't generate, so I have to dive into the data to identify the problem. I had a problem with one activity that is caused by another activity in other Year, and I can only see that looking into all the years and crossing the data manually, without a timetable.

[Volker Dirr]

Can't you see that in the files/forms i noted (at 15:53)? If not: what is missing? maybe write down an example how it should look like. maybe we implement it.

[llbuenoo]

I  will try to make an example of what I mean. Imagine I have 2 years with teachesrs A, B, C, D, E and F and a week with 5 days, the day is divided in 4 hours. The attached files has this example.

When the teachers ask for an activity I have to match the year, the availability in order to have a valid set of data. In the example, it is impossible to generate the timetable, because there are open slots that need a teacher. In this case I have to change the Activity or the teacher.

In this simple example it is very easy to visualize, but I have 396 activities, 25 different groups( some divided into subgroups with different activities simultaneous for esch subgroup) and 50 teachers. The week is divided in 5 days some groups have their days split in 6 hours and others in 4 hours.

Visualize the  availability of teachers per year/group would help a lot to identify the locks in the process.

Thank you again for the great software.

[Volker Dirr]

All your requested features are already implemented in FET!

Open your sample file and save it.

fet -> export -> csv
now you will get a csv file like your "activities.doc".

fet -> advanced -> activity planning -> delete all
then add only 1 random activity
fet -> settings -> timetable -> mark not available with -x-
fet -> timetable -> generate
now you can see years and teachers avability here:
fet -> timetable ->view ...

[Liviu Lalescu]

I added the first post in the TODO file. Please let me know if I should add other posts from this topic, or if you want anything changed.